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 (20717,22209,23663,25134,26973,28065,29325,31082,32601,34122,35520,195271,195653,196035,196878,198194,199511,200828,202510,204182,590107,591727,593366,595073,596770,598455,600132,601813,603485,605148,606802,608447,610085,611769,613446,615113,616768,618410,620043,621670,623289,624899,626520,628131,629731,631324,632911,634489,636056,637614,639159,640696,642223,643740,645253,646756,648251,649750,651238,652719,654191,655652,657103,658558,659998,661433,662857,664274,665684,667124,668555,669996,671428,693900,695148,1913519,1915686,1917897,1920096,1922294,1924485,1926733,1928974,1931202,1933419,1935617,1937813,1940002,1942180,1944351,1946511,1948660,1950796,1952927,1955054,1957130,1959194,1961244,1963281,1965309,1967333,1969349,1971363,1973371,1975370,1977353,1979327,1981321,1983313,1985302,1987276,1989246,1991205,1993144,1995081,1997010,1998932,2000846,2002749,2004639,2006515,2008400,2010285,2012161,2014028,2015868,2017691,2019505,2021312,2023113,2024903,2026899,2028889,2030868,2032829,2034792,2036747,2038692,2040630,2042556,2044467,2046363,2048254,2050135,2052008,2053873,2055824,2057860,2059893,2061920,2063940,2065949)) 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





	Dmitry Korchak (Tenor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Dmitry Korchak (Tenor)
			

																
Dmitry Korchak (Tenor)

														
				


        




    

        
Tenor
Since winning in 2004 prize at Francisco Vinas International Competition in Barcelona and two prizes at Placido Domingo’s Operalia Competition in Los Angeles, Dmitry Korchak has continued to delight audiences worldwide in some of the most celebrated venues, playing some of the greatest leading operatic roles and collaborating with renowned conductors and orchestras.
Dmitry Korchak was born in Russia. After graduating from the Alexander Sveshnikov Moscow Choral College, Dmitry entered the Moscow Chorus Academy, where he studied both as a conductor and as a singer.
Dmitry has collaborated with such conductors as: D. Barenboim, B. Campanella, R. Chailly, J. Cura, P. Domingo, L. Maazel, Z. Mehta, M. Minkowski, R. Muti, K. Nagano, K. Penderezkyi, E. Pido, S. Sondeckis, J. Tate, T. Tsanderling, E. Queler, A. Zedda, V. Fedoseev, M. Pletniov, V. Popov, V. Spivakov, E. Svetlanov, J. Temirkanov and others.
Among Dmitry’s recent engagements at: Carnegie Hall, Teatro dell Opera di Roma, Teatro Filarmonico di Verona, Teatro alla Scala in Milan, Opera Bastille, Vienner Staatsoper, Covent Garden, De Nederlandse Oper, Berliner Staatsoper, Los Angeles Opera, Semperoper Dresden, Teatro San Carlo di Napoli, Teatro Massimo di Palermo, Bayrische Staatsoper, Theatre La Monnaie, Palau de les Artes in Valencia, Salzburg Festival, Pesaro Festival, Bad Kissingen Festival, Colmar Festival, Ravenna Festival, Reate Festival etc.
His future engagements include I Puriatni and Cosi fan tutte at Opera Bastille, Don Giovanni at Teatro Liceo (Barcelona), Don Giovanni and Il Barbiere di Siviglia at Metropolitan Opera, Evgeny Onegin and La Cenerentola at Vienner Staatsoper, Le Comte Ory at Lyon Opera, concerts at Bad Kissingen Festival and ricital tours in Russia and Europe.
        

    

    

            


			

		





	


	

	

		


			

				

					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