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 (3449362,3449367,3449509,3449512,3451503,3451505,3451649,3451650,3453631,3453638,3453780,3453785,3455750,3455760,3455900,3455903,3457877,3457883,3458024,3458028,3459999,3460004,3460148,3460152,3462138,3462140,3462285,3462290,3464261,3464268,3464411,3464414,3466409,3466420,3466561,3466564,3468589,3468599,3468740,3468745,3470762,3470909,3470910,3473065,3473068,3475221,3475224,3477374,3477376,3479518,3479523,3481656,3481659,3483789,3483791,3485912,3485913,3488023,3488027,3490129,3490133,3492260,3492264,3494380,3494384,3496497,3496499,3498651,3498653,3500795,3500797,3502930,3502932,3505061,3505062,3507184,3507188,3509305,3509307,3511420,3511421,3513527,3513532,3515623,3515627,3517713,3517715,3519799,3519800,3521877,3521878,3523945,3523949,3526006,3526012,3528060,3528061,3530120,3530124,3532163,3532167,3534203,3534207,3536243,3536248,3538273,3538277,3540297,3540298,3542366,3542370,3544422,3544428,3546465,3546466,3548500,3548505,3550533,3550534,3552577)) 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





	Igor Dronov (Conductor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Igor Dronov (Conductor)
			

																
Igor Dronov (Conductor)

														
				


        




    

        
In 1992, Igor Dronov graduated from the Choral Conducting Department as well as from the Opera and Symphony Conducting Department of the Moscow Tchaikovsky Conservatoire. In 1994, he finished his postgraduate studies at the Conservatoire. He also participated in masterclasses held by Georg Solti and Pierre Boulez.

Since 1992, he has been a professor of conducting at the Moscow Conservatoire. Since 1994, he has been the principal conductor and artistic director of the Premiere Youth Ensemble. In 1991–1996, he was the principal conductor with the Bolshoi Theatre. At the Bolshoi Theatre, he has conducted Tchaikovsky’s Eugene Onegin, Gounod’s Faust, Verdi’s Il trovatore and La traviata, and Rachmaninoff’s Aleko and Miserly Knight. Then he became the principal guest conductor with the Bolshoi Theatre. In 2003, he contributed to staging of the original version of Glinka’s Ruslan and Lyudmila at the Bolshoi Theatre. At the Bolshoi Theatre, he was also a musical director of the following productions: Pärt’s Ward No. 6, Krasavin’s Magrittomania and Lea to music by Bernstein (2004), Midsummer Night’s Dream to music by Mendelssohn and Ligeti and to traditional mechanical music (2005), Serenade to music by Tchaikovsky (2006), Misericordes to Pärt’s Third Symphony (world première, 2006), Prokofiev’s Cinderella (2006), Delerue’s Enetime (2007), Russian Seasons to music by Desyatnikov (2008), Delibes’s Coppelia (2009), Stravinsky’s Petrushka (2010), Chroma to music by Talbot and White (2011), Cinque to music by Vivaldi (2011), Symphony of Psalms to music by Stravinsky (2011), and The Taming of the Shrew to music by Shostakovich (2014, world première). He also appears with concert programmes of the Bolshoi Orchestra. Igor Dronov is a guest conductor with many renowned orchestras including the Russian National Orchestra, Ensemble Modern (Germany), the Orchestra of the Finnish National Opera, Monte Carlo Philharmonic Orchestra, National Symphony Orchestra of the Kennedy Center (USA) and others, as well as the principal conductor of the Studio for New Music (Moscow). With the Studio, he has performed over 500 concerts featuring compositions by modern Russian and foreign composers and presented several world premières. He has also been the principal conductor of the Moscow Forum Festival since its foundation. Igor Dronov has recorded several CDs of the Russian and foreign music. He has toured to Europe, USA, and Japan.
        

    

    

            


			

		





	


	

	

		


			

				

					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