QUERY: (SELECT tmp.*, tt.code, tt.name, tp.code as perf_code, tp.name as perf_name, date_format(tmp.date, '%e,%M,%W') as date_first,  date_format(tmp.time, '%k:%i') as time_column, IF(tp.description='',tp1.description,tp.description) as description, tp.description_full, tp.id_perfomancetype, IF(year(curdate())=year(tmp.date),'',year(tmp.date) ) as year, tt.ves as ves, date_format(tmp.time, '%l:%i %p') as time_column1, datediff(tmp.date, curdate()) as offset, tt.address FROM U_ticketsTmp tmp LEFT JOIN ticket_theatre tt ON tt.id=tmp.theatre_id LEFT JOIN ticket_perfomances tp ON tp.id=tmp.perf_id LEFT JOIN ticket_perfomances tp1 ON tp1.id=tp.id_base WHERE 1=1 AND tt.show2=1  AND tmp.date >=curdate()  AND tmp.date>='2024-04-23' AND tmp.date<='2024-05-13' AND tmp.perf_id=1923) ORDER BY date ASC, ves DESC, time ASC
ERROR: (#1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'offset, tt.address FROM U_ticketsTmp tmp LEFT JOIN ticket_theatre tt ON tt.id...' at line 1

QUERY: (SELECT tmp.*, tt.code, tt.name, tp.code as perf_code, tp.name as perf_name, date_format(tmp.date, '%e,%M,%W') as date_first,  date_format(tmp.time, '%k:%i') as time_column, IF(tp.description='',tp1.description,tp.description) as description, tp.description_full, tp.id_perfomancetype, IF(year(curdate())=year(tmp.date),'',year(tmp.date) ) as year, tt.ves as ves, date_format(tmp.time, '%l:%i %p') as time_column1, datediff(tmp.date, curdate()) as offset, tt.address FROM U_ticketsTmp tmp LEFT JOIN ticket_theatre tt ON tt.id=tmp.theatre_id LEFT JOIN ticket_perfomances tp ON tp.id=tmp.perf_id LEFT JOIN ticket_perfomances tp1 ON tp1.id=tp.id_base WHERE 1=1 AND tt.show2=1  AND tmp.date >=curdate()  AND tmp.date>='' AND tmp.date NOT BETWEEN '2024-04-23' AND '2024-05-13' AND tmp.perf_id=1923) ORDER BY date ASC, ves DESC, time ASC
ERROR: (#1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'offset, tt.address FROM U_ticketsTmp tmp LEFT JOIN ticket_theatre tt ON tt.id...' at line 1

QUERY: SELECT tmp.*, tt.code, tt.name, tp.code as perf_code, tp.name as perf_name, date_format(tmp.date, '%e,%M,%W') as date_first,  date_format(tmp.time, '%k:%i') as time_column, IF(tp.description='',tp1.description,tp.description) as description, tp.description_full, tp.id_perfomancetype, IF(year(curdate())=year(tmp.date),'',year(tmp.date) ) as year, tt.ves as ves, date_format(tmp.time, '%l:%i %p') as time_column1, datediff(tmp.date, curdate()) as offset, tt.address FROM U_ticketsTmp tmp LEFT JOIN ticket_theatre tt ON tt.id=tmp.theatre_id LEFT JOIN ticket_perfomances tp ON tp.id=tmp.perf_id LEFT JOIN ticket_perfomances tp1 ON tp1.id=tp.id_base WHERE 1=1 AND tt.show2=1  AND tmp.date >=curdate()  AND tmp.date>='' AND tmp.perf_id<>1923 AND tp.id_base=-1 AND tmp.city_id=1 ORDER BY date ASC, ves DESC, time ASC
ERROR: (#1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'offset, tt.address FROM U_ticketsTmp tmp LEFT JOIN ticket_theatre tt ON tt.id...' at line 1

QUERY: SELECT tmp.*, tt.code, tt.name, tp.code as perf_code, tp.name as perf_name, date_format(tmp.date, '%e,%M,%W') as date_first,  date_format(tmp.time, '%k:%i') as time_column, IF(tp.description='',tp1.description,tp.description) as description, tp.description_full, tp.id_perfomancetype, IF(year(curdate())=year(tmp.date),'',year(tmp.date) ) as year, tt.ves as ves, date_format(tmp.time, '%l:%i %p') as time_column1, datediff(tmp.date, curdate()) as offset, tt.address FROM U_ticketsTmp tmp LEFT JOIN ticket_theatre tt ON tt.id=tmp.theatre_id LEFT JOIN ticket_perfomances tp ON tp.id=tmp.perf_id LEFT JOIN ticket_perfomances tp1 ON tp1.id=tp.id_base WHERE 1=1 AND tt.show2=1  AND tmp.date >=curdate()  AND tmp.date>='' AND tmp.perf_id<>1923 AND tp.id_base=-1 AND tmp.city_id=2 ORDER BY date ASC, ves DESC, time ASC
ERROR: (#1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'offset, tt.address FROM U_ticketsTmp tmp LEFT JOIN ticket_theatre tt ON tt.id...' at line 1





	15 November 2017, 19:00 - "Both Classics and Jazz" performed by Mikhail Ivanov (piano), Andrey Ivanov (double bass), Denis Shvytov (saxophone) and the others. - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Tchaikovsky Concert Hall 15 November 2017, 19:00 - "Both Classics and Jazz" performed by Mikhail Ivanov (piano), Andrey Ivanov (double bass), Denis Shvytov (saxophone) and the others.
  • Mikhail Ivanov (piano)
  • Andrey Ivanov (double bass)
  • Denis Shvytov (saxophone)
  • Dmitry Illarionov (guitar, lute)
  • Polina Orbakh (vocal)
  • Dmitry Vlasenko (percussion)
  • Igor Goldenberg (organ)
  • Anastasia Vinogradova (flute)
  • Kozhevnikov Choir
  • Conductor – Platon Grekov
  • Sofya Tyurina (saxophone) 
  • Ivanov's brother is an alliance of two outstanding musicians, Grand Prix winners of the Brussels Jazz Competition EuroJazzContest, Honored Artists of Russia, laureates of the Moscow Government Prize in Literature and Art, Laureates of the Russian Federation Government Award in the field of culture MIKHAILA (piano) and ANDREY (contrabass ) IVANOV, widely known on the domestic and European stage.
  • Denis Shvytov is a Moscow saxophonist and composer, a graduate of the Gnessin Russian Academy of Music (Alexander Osseychuk saxophone class). He worked with such famous artists as Dee Dee Bridgewater, Deborah Brown, Randy Brecker, Alan Harris, Cynthia Scott, Larisa Dolina, Boris Frumkin, Batyrkhan Shukenov, Victoria Pierre-Marie, Sati Casanova, Vadim Eilenkrig, Anton Baronin, Jazz Parking Band.
  • Dimitry Illarionov (b. 1979) is one of the most brilliant young classical guitarists. In 1997 he graduated with honors from the Academic Music College at the Moscow Tchaikovsky Conservatory (class of guitar—Natalia Dmitrieva). Then he studied at the Russian Gnesins Academy of Music with the famous performer and Professor Alexander Frauchi. In 2002, Dimitry graduated from the Academy “cum laude”.  He also took lessons with famous Russian composer and guitarist Nikita Koshkin; masterclasses with such prominent musicians as guitarists Carlo Marchione and Roberto Aussell, lutenist Hopkinson Smith, cellist David Geringas. In 2002-2004 Dimitry Illarionov was an assistant of professor Frauchi. Now Dimitry teaches his own class in the Academy.
  • Polina Orbakh is one of the brightest and most diverse jazz singer in Moscow. Possessing excellent technique and a rare timbre, she feels confident both in the jazz mainstream and in pop music.
  • Dmitry Vlasenko (percussion)
  • Graduate of the State Academy of Music named after Gnesin. Laureate of numerous competitions and festivals. Cooperates with such musicians as A. Croll, I. Butman, and O. Lundstrem's orchestra. Member of the jazz festivals "Jazz Province", "Moscow Autumn", "Eurodzhaz."
  • Igor Goldenberg, was born in Moscow in 1968, and began to study music at the age of 10.
  • In 1987 he graduated Moscow Tchaikovsky Conservatoire Musical College as a pianist and as a musicologist, and after it in 1993 graduated Moscow Tchaikovsky Conservatoire with excellent marks as a composer (prof. A.S.Leman), in 1994 – as a pianist (prof. O.M.Zhukova), and as an organist (prof. S.L.Dizhur). Also studied polyphony (prof. J.N.Kholopov), musical analysis (prof. V.V.Zaderatsky), orchestration (prof. N.P.Rakov). In 1996 he finished postgraduate studies as a pianist (prof. O.M.Zhukova).
  • State Academic Moscow Regional Choir named after A.Kozhevnikov. Artistic director and chief conductor - Mykola Azarov. The State Academic Moscow Regional Choir named after AD Kozhevnikov is one of the oldest celebrated collectives in Russia. It was organized in 1956 by the People's Artist of the USSR Professor Vladislav Gennadievich Sokolov, the Moscow Conservatory.