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 (1915679,1915705,1915707,1915725,1915738,1917891,1917918,1917919,1917937,1917950,1920090,1920118,1920119,1920137,1920150,1922289,1922317,1922318,1922336,1922349,1924479,1924503,1924504,1924527,1924538,1926727,1926751,1926752,1926774,1926786,1928968,1928991,1929015,1929027,1931197,1931220,1931244,1931256,1933411,1933440,1933458,1933470,1935610,1935639,1935657,1935669,1937806,1937835,1937853,1937865,1939998,1940024,1940042,1940053,1942176,1942203,1942220,1942232,1944347,1944374,1944390,1944403,1946507,1946533,1946555,1946564,1948656,1948681,1948703,1948710,1950791,1950817,1950839,1950850,1952923,1952949,1952970,1952982,1955050,1955071,1955093,1955105,1957126,1957147,1957169,1957181,1959190,1959211,1959237,1959245,1961240,1961264,1961285,1961297,1963277,1963301,1963323,1963334,1965305,1965332,1965350,1965362,1967328,1967355,1967372,1967382,1969345,1969372,1969390,1969402,1971358,1971385,1971402,1971412,1973366,1973394,1973412,1973423,1975365,1975392,1975409,1975419,1977349,1977377,1977395,1977405,1979322,1979349,1979366,1979376,1981318,1981345,1981364,1981374,1983310,1983337,1983356,1983366,1985297,1985324,1985341,1985351,1987273,1987299,1987319,1987329,1989242,1989269,1989288,1989299,1991197,1991224,1991245,1991253,1993139,1993166,1993183,1993193,1995077,1995100,1995122,1995130,1997006,1997029,1997049,1997059,1998927,1998954,1998971,1998981,2000841,2000868,2000885,2000895,2002744,2002771,2002788,2002798,2004635,2004659,2004682,2004692,2006510,2006537,2006554,2006564,2008396,2008419,2008442,2008453,2010281,2010305,2010327,2010338,2012157,2012182,2012204,2012215,2014023,2014049,2014065,2014075,2015863,2015889,2015905,2015915,2017688,2017711,2017731,2017742,2019500,2019526,2019542,2019552,2021307,2021333,2021349,2021359,2023108,2023134,2023150,2023160,2024899,2024926,2024944,2024955,2026894,2026920,2026936,2026946,2028884,2028910,2028926,2028936,2030863,2030889,2030905,2030915,2032824,2032851,2032870,2032881,2034787,2034813,2034829,2034839,2036738,2036765,2036784,2036794,2038683,2038710,2038729,2038738,2040621,2040648,2040667,2040676,2042547,2042574,2042593,2042602,2044462,2044488,2044504,2044514,2046360,2046382,2046402,2046411,2048249,2048275,2048291,2048301,2050132,2050154,2050173,2050183,2052005,2052026,2052050,2052056,2053868,2053894,2053911,2053921,2055819,2055845,2055862,2055872,2057852,2057874,2057899,2057911,2059886,2059907,2059932,2059944,2061913,2061934,2061959,2061971,2063933,2063954,2063979,2063990,2065964,2065989,2066000,2067973,2067991,2069976,2069997,2071969,2071989,2073966,2075938,2077904,2079902)) 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 Agrest (Conductor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Mikhail Agrest (Conductor)
			

																
Mikhail Agrest (Conductor)

														
				


        




    

        Born in Leningrad. Began his music training as a violinist at the Leningrad Conservatoire School for Gifted Children. Moved to the USA with his family in 1989 and went on to earn a bachelorґs degree in violin performance with Josef Gingold at the Indiana University School of Music. He returned to St Petersburg for post-graduate studies in conducting with Ilya Musin and Mariss Jansons at the St Petersburg State Conservatoire. In the summers of 2000 and 2001, he was a fellow at the Aspen Music Festivalґs American Academy of Conducting where he studied with David Zinman.
Born in Leningrad. Began his music training as a violinist at the Leningrad Conservatoire School for Gifted Children. Moved to the USA with his family in 1989 and went on to earn a bachelor?s degree in violin performance with Josef Gingold at the Indiana University School of Music. He returned to St Petersburg for post-graduate studies in conducting with Ilya Musin and Mariss Jansons at the St Petersburg State Conservatoire. In the summers of 2000 and 2001, he was a fellow at the Aspen Music Festival?s American Academy of Conducting where he studied with David Zinman.
Has been with the Mariinsky Theatre since 2001, where he conducts the operas La Boheme, La Cleopatra, Cosi fan tutte, Lucia di Lammermoor, Oedipus Rex, The Legend of the Invisible City of Kitezh and the Maiden Fevronia, Sadko, A Life for the Tsar, Le Rossignol and the ballets The Firebird, Petrouchka, Prodigal Son, Cinderella, Apollo, Jewels, Manon, Le Sacre du printemps, Romeo and Juliet, Le Corsaire, Swan Lake, Giselle, La Sylphide, The Nutcracker, La Valse and The Four Temperaments. In 2002, he received a nomination for the Golden Sophit, St Petersburg?s highest theatre prize, in the category "best work by a conductor" for new productions of Cinderella, Prodigal Son and Cosi fan tutte. 
On May 28th 2003, he conducted the Mariinsky Theatre Orchestra with Valery Gergiev in the concert dedicated to St Petersburg?s tercentenary on Palace Square. The concert was broadcast live on two national television channels. 
He has performed with the Mariinsky Theatre in Austria, Switzerland, Germany, France, the USA, the UK and Finland and has given concerts with orchestras in Russia, Ukraine, Romania, Italy, Hong Kong and the USA. Since 2000, he has been Music Director of the PI Chamber Orchestra in South Carolina.
Was awarded second prize at the A. Pedrotti International Conducting Competition (Italy, 2001) and third prize at the Mitropoulos Conducting Competition (2002).
In July 2003, he made his Metropolitan Opera debut with Rimsky-Korsakov?s The Legend of the Invisible City of Kitezh and the Maiden Fevronia and his Covent Garden debut with Le Sacre du printemps and Les Noces. 

© State Academic Mariinkiy Opera and Ballettheatre        

    

    

            


			

		





	


	

	

		


			

				

					Deals & Discounts 
					Subscribe to our email newsletter
				



				
				


			

			

		

		

	

	




 



	

		

			
    		

    

        

		
		
Award-winning
Group Tour Packages

        

        

		
Useful Links &
Company Information

        

        

        
    
		

	





	

		

			
© 2001 – 2024 by Northern Crown, Ltd. uVisitRussia and uVisitRussia.com are registered trademarks. Terms & Conditions  Privacy Policy