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 (14702,14777,16155,16229,17762,17839,19167,19232,20673,22157,23611,25073,26865,27860,29204,31021,32539,34060,105708,107602,109489,111366,113235,115096,116972,118847,120716,122582,124440,126289,128129,129958,131787,133620,135444,137265,139084,140894,142695,144485,146265,148036,149794,153447,155178,156899,158610,160336,162062,163802,165544,167275,168996,170708,172412,174105,175789,177462,179125,180778,182425,184065,185696,187318,188930,190530,192119,193697,196457,197769,199086,200403,202085,203756,205431,207129,208817,457398,457399,458964,458965,460521,460522,462068,462069,463619,463620,465167,465168,466709,466710,468407,468408,470109,470110,471660,471661,473200,473201,474780,474781,476357,476358,477929,477930,479503,479505,481063,481065,481813,481814,497375,497376,498844,498845,500297,500298,501752,501753,503243,503244,504724,504726,506197,506198,507667,507668,509137,509138,510601,510602,512056,512057,513499,513504,514974,514975,615985,617634,619271,620900,622525,624139,625764,627378,628983,630583,632172,633756,635329,636890,638444,639983,641513,643031,644542,646048,647548,649040,650532,652015,653491,654957,656412,657857,659306,694026,694033,695274,695281,696507,696513,697727,697732,698934,698940,700129,700136,701318,701325,702514,702521,703698,703706,704873,704881,706030,706038,707176,707183,708305,708313,709433,709434,710579,710585,711719,711725,712857,712863,713981,713988,715095,715102,716198,716205,717290,717297,718373,718378,719443,719450,720509,875911,875917,875918,878598,878604,878605,881282,881288,881289,883968,883974,883975,886643,886649,886650,889309,889315,889316,891971,891977,891978,894626,894632,894633,897280,897286,897287,899930,899934,899936,902566,902571,902572,905198,905203,905204,907814,907820,907821,910427,910434,910435,913042,913047,913048,915673,915678,915679,918377,918381,918382,921074,921075,921137,921142,921165,923816,923821,923844,926505,926510,926535,929224,929227,929252,931933,931936,931961,934640,934643,934668,937345,937348,937373,940076,940079,940104,942794,942797,942822,945499,945502,945527,948201,948204,948229,950906,950911,950934,953605,953610,953634,956294,956300,956324,958977,959001,961656,964296,966932,969564,972192,974812,1075646,1075647,1078029,1078030,1080400,1080401,1082760,1082761,1085105,1085106,1087434,1087435,1089752,1089754,1092082,1092083,1094404,1094405,1096714,1096715,1099008,1099010,1101287,1101288,1103558,1103559,1105807,1105808,1108035,1108036,1110242,1110243,1112426,1112427,1114597,1114598,1116747,1116753,1118884,1118885,1121013,1121019,1123155,1123156,1125288,1125289,1127480,1127481,1129700,1129701,1155908,1155910,1158081,1158082,1160245,1160246,1162390,1162391,1367763,1367770,1369569,1369576,1371369,1371376,1373154,1373162,1374929,1374937,1376782,1376790,1378616,1378625,1380436,1380445,1382250,1382259,1384064,1384073,1385872,1385881,1387673,1387680,1389462,1389470,1391244,1648659,1648666,1651468,1651472,1654332,1654336,1657186,1657190,1660029,1660033,1662858,1662862,1665675,1665682,1668485,1668489,1671286,1671291,1674141,1674145,1676988,1676993,1679835,1679839,1682665,1682669,1685484,1685491,1688342,1688349,1691200,1691207,1693974,1693978,1696739,1696743,1699497,1699501,1702246,1702250,1704984,1704989,1707757,1707762,1710529,1716163,1718933,1721689,1724431,1727170,1729902,1732613,1735317,1738012,1740696,1743360,1746022,1748675,1751319,1753958,1756588,1759206,1761810,1764411,1767007,1769597,1772178,3807855,3808231,3808604,3808973,3809341,3809707,3810069,3810425,3810782,3811173,3811560,3818078,3818481,3818880,3819269,3819660,3820046,3820427,3820807,3821184,3821553)) 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





	Andrei Yakovlev (Dancer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Andrei Yakovlev (Dancer)
			

																
Andrei Yakovlev (Dancer)

														
				


        




    

        Born in Sverdlovsk. 



Graduated from the Vaganova Ballet Academy (class of Prof. Gennady Selyutsky). 



Joined the Mariinsky Theatre in 1988. Became a principal in 1992. 
Born in Sverdlovsk. 

Graduated from the Vaganova Ballet Academy (class of Prof. Gennady Selyutsky). 

Joined the Mariinsky Theatre in 1988. Became a principal in 1992. 

Repertoire includes:
La Silphide (James);
The Nutcracker (The Prince, Pas de trois);
The Sleeping Beauty (Prince Desire, the Blue Bird);
Giselle (Albrecht);
Raymonda (Jean de Brienne);
Swan Lake (Prince Siegfried, Pas de trois);
Le Corsaire (Conrad);
Fokine?s: Chopiniana (Youth), The Firebird (Ivan Tsarevich); The Fountain of Bakhchisarai (Vaslav);
Romeo and Juliet (Romeo);
Anna Karenina (Vronsky);
Balanchine?s: Jewels (Emeralds), Symphony in C, Serenade;
In the Nigh;
The Stone Flower (Danila);
The Leaves are fading;
Le Poeme de l?Extase;
Carmen (Don Jose);
La Baiser de la Fee (Youth);
The brook (Pa-de de);
La Bayadere (Solor, Pa-de-sis);
Goya-Divertissement (Makho);
Bejart?s Our Faust;
Leningrader Symphony (Youth);
Simonov?s The play of consciousness;
The lilac garden.

© State Academic Mariinkiy Opera and Ballet theatre         

    

    

            


			

		





	


	

	

		


			

				

					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