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.id IN (19165,918644,921337,924043,926733,929451,932159,934867,937571,940302,943021,945726,948428,951135,953835,956525,959201,961855,964495,967131,969764,972392,975012,977636,980244,982837,985422,988047,990666,993280,995889,998485,1001068,1003649,1006222,1008789,1011348,1013928,1016489,1019042,1021589,1024134,1026669,1029199,1031725,1034228,1036718,1039207,1041691,1044167,1046634,1049091,1051535,1053965,1056392,1058814,1061223,1063624,1066018,1068400,1070768,1073168,1075561,1077944,1080315,1082674,1085019,1087350,1089667,1091997,1094319,1096631,1098928)) ORDER BY date ASC, ves DESC, time ASC LIMIT 10
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





	Mikhail Tatarnikov (Musical Director) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Mikhail Tatarnikov (Musical Director)

Mikhail Tatarnikov (Musical Director)

Mikhail Tatarnikov studied music at the St Petersburg State Rimsky-Korsakov Conservatoire under Professor Ilya Ioffe (violin). After graduating from the Conservatoire in 2003 he subsequently continued his studies at the faculty of opera and symphony conducting (class of Professor Polishchuk).

Mikhail Tatarnikov began his career at the Mariinsky Theatre as a violinist. In 1999 he joined the Mariinsky Theatre Symphony Orchestra (first violinist). While employed with the Mariinsky Theatre Orchestra, Mikhail Tatarnikov had a busy concert schedule. Highlights of this period include appearances with the World Orchestra for Peace under Valery Gergiev in St Petersburg and Moscow.

Mikhail Tatarnikov made his debut as a conductor at the Mariinsky Theatre in November 2006 with the premiere of the ballet Metaphysics to Sergei Prokofiev`s Second Symphony. In March 2007 conducted his first opera – a new production of Prokofiev`s The Love for Three Oranges.

Mikhail Tatarnikov currently appears frequently at St Petersburg concert venues. In 2006 he supervised the Mariinsky Theatre?s production of Stravinsky?s musical tale L?histoire du soldat and in December 2007 he conducted the premiere of Mozart?s opera Die Zauberflote.

At the Mariinsky Theatre, Mikhail Tatarnikov has conducted Rimsky-Korsakov`s operas Sadko and Kashchei the Deathless, while at the Concert Hall his engagements have included Prokofiev`s opera Maddalena and Richard Strauss` Till Eulenspiegels lustige Streiche and Vier letzte Lieder for soprano and orchestra.

As a guest conductor he has appeared with Antonin Dvorak`s Rusalka at the Teatro Regio (Turin, Italy). In autumn 2006, having received a scholarship from the Ermenegildo Zegna Foundation, Mikhail Tatarnikov took part in master classes given by Gianandrea Noseda, subsequently appearing at the international festival Settimane Musicali di Stresa e del Lago Maggiore (Italy). Mikhail Tatarnikov has also conducted the Novosibirsk Philharmonic (2005) and St Petersburg State Rimsky-Korsakov Conservatoire (2007) orchestras, and in July 2007 he was Valery Gergiev`s assistant for performances of Der Ring des Nibelungen tetralogy at the Metropolitan Opera.