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 (8456,10160,11743,13326,14675,14723,16125,16169,17735,17779,19183,20626,22110,23564,25024,26760,27641,29087,30971,38831,40281,41589,41612,42984,43004,44346,44365,45698,45717,47062,48401,49735,51063,52382,53697,342374,342418,344298,344341,346214,346257,348121,348164,350011,350054,351894,351928,353766,353809,355639,355682,357516,357558,359423,359464,361322,361363,363218,363255,365101,365135,366980,367020,368853,368893,370728,370762,372592,372626,374447,374481,376292,376333,378127,378169,379960,380002,381788,381829,383605,383648,385423,385465,387228,387272,389041,389084,390841,390884,392640,392682,394440,394477,396228,396270,398012,398054,399794,399828,401559,401601,403322,403356,405079,405115,406831,406868,408578,408615,410318,410354,412086,412121,413878,415621,417360,419100,420832,422562,424286,425999,509150,510612,512067,513518,514989,516453,517906,910574,913185,915818,918521,921215,923893,926586,929301,932007,934715,937419,940151,942869,945576,948278,950984,953683,956373,959050,961705,964345,966981,969613,972241,974861,977473,980080,982672,985259,987883,990502,993114,995723,998318,1000902,1003483,1006058,1008625,1039330,1041814,1044290,1046757,1049214,1051658,1054088,1056515,1058937,1061345,1063746,1066140,1068522,1070892,1073294,1075687,1078070,1080441,1082801,1085146,1087474,1089794,1092124,1094446,1096756,1099053,1101330,1103601,1105851,1108077,1110286,1112473,1114641,1116791,1118928,1121057,1123200,1125333,1127523,1129744,1131947,1134140,1136344,1138545,1140743,1142934,1145117,1147287,1149443,1151596,1915712,1917924,1920124,1922323,1924514,1926762,1929003,1931232,1933446,1935645,1937841,1940030,1942209,1944380,1946541,1948691,1950827,1952959,1955086,1957162,1959226,1961278,1963316,1965340,1967360,1969380,1971390,1973401,1975397,1977386,1979354,1981355,1983347,1985329,1987309,1989279,1991234,1993171,1995111,1997039,1998959,2000873,2002776,2004668,2006542,2008429,2010314,2012191,2014053,2015893,2017720,2019530,2021337,2023138,2024933,2026924,2028914,2030893,2032859,2034817,2036773,2038718,2040657,2042583,2044492,2046391,2048279,2050163,2052035,2053899,2055850,2057890,2059923,2061950,2063970,2065980,2067982,2069987,2071978,2073956,2075928,2112771,2114677,2116575,2118466,2120347,2122217,2124078,2125922,2127760,3029384,3030811,3032224,3033635,3035227,3088251,3089885,3091505,3093119,3094721,3096314,3097897,3099474,3101046,3102606,3104151,3105684,3107238,3108782,3110353,3111911,3113454,3114991,3116508,3118023,3119532,3121040,3122565,3124262,3125949,3127624,3129286,3130942,3132589,3132690,3134229,3134330,3135869,3135970,3137502,3137603,3139123,3139224,3140735,3140836,3142339,3142440,3143933,3144034,3145523,3145624,3147103,3147204,3147739,3147840,3148369,3148470,3148993,3149094,3149617,3149718,3151164,3151265,3152703,3152804,3154236,3154337,3155759,3155860,3157275,3157376,3158782,3158883,3160276,3160377,3161761,3161862,3163238,3163339,3164710,3164811,3166173,3166274,3167622,3167703,3169016,3169097,3170401,3170482,3171778,3171859,3173149,3173230,3174514,3174595,3175914,3175997,3177312,3177395,3178702,3178784,3180174,3180256,3181642,3181724,3183108,3183190,3184571,3184653,3186032,3186114,3187489,3187571,3188940,3189022,3190388,3190467,3191830,3191908,3193266,3193344,3194957,3195035,3196741,3196823,3198715,3198796,3200685,3200765,3202382,3202461,3204076,3204157,3205764,3205844,3207449,3207534,3209129,3209211,3210804,3210885,3212524,3212605,3214226,3214308,3215921,3216002,3217616,3217698,3219303,3219386,3221065,3222732,3224397,3226025,3227639,3229257,3230882,3232495,3234107,3235706,3237288,3238857,3240425,3242028,3243623,3245206,3246805,3248392,3249962,3251528,3253088,3283718,3283725,3285843,3285845,3287986,3287996,3290126,3290130,3292238,3292244,3294344,3294350,3296444,3296450,3298535,3298544,3300625,3300627,3302696,3302706,3304758,3304768,3306813,3306815,3308859,3308861,3310900,3310905,3312925,3314873,3314946,3316887,3316959,3318888,3318960,3320872,3320948,3322857,3322933,3325004,3325076,3327277,3327350,3327694,3329663,3329737,3330080,3332044,3332121,3332461,3334408,3334487,3334828,3336760,3336838,3337181,3339111,3339188,3339529,3341454,3341531,3341873,3343793,3343862,3344210,3346148,3346223,3346567,3348499,3348571,3348917,3350835,3350913,3351254,3353161,3353232,3353578,3355478,3355555,3355896,3357749,3357812,3357885,3358246,3360095,3360152,3360227,3360615,3362454,3362517,3362593,3362978,3364810,3364868,3364944,3365332,3367149,3367208,3367283,3367671,3369480,3369543,3369616,3370002,3371806,3371863,3371936,3372327,3374123,3374181,3374255,3374645,3376434,3376494,3376571,3376958,3378740,3378800,3378872,3379262,3381037,3381096,3381170,3381561,3383305,3383365,3383438,3383830,3385598,3385654,3385726,3386115,3387921,3387994,3388382,3390182,3390255,3390638,3392430,3392508,3392890,3394667,3394743,3395126,3396890,3396967,3397348,3399104,3399178,3399565,3401310,3401378,3401767,3403497,3403573,3403956,3405678,3405752,3406138,3407846,3407917,3408323,3410009,3410088,3410489,3412156,3412231,3412632,3414394,3414803,3416548,3416951,3418689,3419092,3420809,3421211,3422912,3423314,3424987,3425394,3427048,3427453,3429090,3429497,3431120,3431521,3433126,3433532,3435128,3435535,3437125,3437532,3439106,3439512,3441477,3443441,3445414,3447569,3449713,3451855,3453987,3456106,3458232,3460364,3462500,3464634,3466783,3468963,3471130,3473288,3475444,3477598,3479743,3481878,3484010,3486131,3488240,3490375,3492507,3494627,3496745,3498899,3501042,3503180,3505311,3507435,3509551,3511668,3513773,3515872,3517961,3520049,3522126,3524195,3526256,3528330,3530389,3532435,3534253,3534475,3536290,3536514,3538322,3538544,3540344,3540569,3542416,3544471,3546511,3548550,3550582,3552623,3554655,3556694,3558721,3560734,3562736,3564739,3566754,3568767,3570786,3572796,3574808,3576717,3918245,3918920,3919609,3920296,3920976,3969981,3970001,3970553,3970573,3971122,3971140,3971688,3971706,3972269,3972826,3973383,3973936,3974487,3975051)) 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





	Leonid Zakhozhaev (Tenor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Leonid Zakhozhaev (Tenor)
			

																
Leonid Zakhozhaev (Tenor)

														
				


        




    

        Tenor  
Honoured Artist of Russia


Leonid Zakhozhaev was born in Krasnodar in the South of Russia. 
His development to the position of a leading tenor at the Kirov Opera (Mariinsky Theatre in St Petersburg) went through a number of stages. Having graduated from St Petersburg State Academy of Theatre, Music and Cinema as a dramatic actor, he worked in theatre, created roles in the cinema and on television and had some success as a rock and pop singer in 80-s underground culture. In 1989 he realized his true vocation and entered the St Petersburg State Conservatoire. 


While a student he sang leading roles at the Conservatoire Opera Theatre including Lensky (Eugene Onegin), Vaudemont (Iolanta), Faust, Ivan Lykov (The Tsar`s Bride), Kuragin (War and Peace). Immediately upon graduation he was invited to the Mariinsky (Kirov) Opera to sing Narraboth in the new production of Salome by world-famous director Julie Taymor, conducted by Valery Gergiev. The premiere first took place in the legendary medieval theatre of the Ober Ammergau and was televised throughout Europe. Its first performance at the Mariinsky Theatre opened the White Nights Festival in 1995. 


It was as a leading tenor of the Kirov Opera, guided by Valery Gergiev, that Leonid Zakhozhaev was first introduced to the stages of great opera theatres and concert halls throughout the world including the Metropolitan Opera, New York, and Royal Opera House, Covent Garden, Germany`s Baden-Baden Festival (where he had a success as Siegfried), Deutsche Oper Berlin, Teatro Real, Madrid, the Chatelet, Paris, Italy`s Ravenna Festival, the Savonlinna Opera Festival and Mikkeli Music Festival in Finland, the Rotterdam Gergiev Festival and Amsterdam`s Concertgebouw in Holland, the Kennedy Center, Washington, in Japan, Israel, Argentina, Chile, Luxemburg, Hong-Kong, Australia, Sweden and Brazil.


His favourite roles include:
Lohengrin (which he performed in Ravenna Festival), Tamino (Die Zauberflote), Faust, Hermann (The Queen of Spades), Vaudemont (Iolanta) – which he sang in Munich, Macduff (Macbeth) – which he performed on the stage of the Metropolitan Opera, Sergei (Lady Macbeth of Mtsensk) – performed at the Salzburg Festival and Baltimore Opera, the title role of the Berlioz` Benvenuto Cellini, which he has also recorded under Valery Gergiev with the Rotterdam Philharmonic for Erato, and of course, Siegfried.


"Leonid Zakhozhaev, who looked handsome and sang handsomely as the young Siegfried, with plenty of range and endurance for the punishing final duet with Brunnhilde" – wrote New York Times about his performance in Baden-Baden in January 2004.


His forthcoming plans include Lohengrin in Brazil, Siegfried in Canada and the new role of Tristan in the new production at the Mariinsky Theatre under Valery Gergiev (to be premiered in may 2004). 


His repertoire at the Mariinsky Theatre includes:
Sobinin (Ivan Susanin),
Yurodiviy (Boris Godunov),
Prince Sinodal (The Demon),
Berendey (The Snow Maiden),
Indian Guest (Sadko),
Lensky (Eugene Onegin),
Prince Yury (The Enchantress),
Oedipus (Oedipus Rex),
Alexei (The Gambler),
Prince (Love for Three Oranges),
Agrippa, Mephistopheles (The Fiery Angel),
Antonio (Betrothal in a Monastery),
Sergei (Lady Macbeth of Mtsensk),
Macduff (Macbeth),
Benvenuto Cellini (Benvenuto Cellini),
Faust (Gounod`s Faust and Berlioz` La Damnation de Faust) ,
Hoffmann (Les Contes d`Hoffmann),
Erik (Der Fliegende Hollander),
Lohengrin (Lohengrin),
Froh (Das Rheingold),
Siegfried (Siegfried),
Siegfried (Gotterdammerung),
Tristan (Tristan und Isolde),
Narraboth (Salome),
Bacchus (Ariadne auf Naxos),
the tenor solo in Mahler`s Das Lied von der Erde.
        

    

    

            


			

		





	


	

	

		


			

				

					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