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 (20624,22106,23560,25026,26766,27651,29094,30974,32610,34131,35527,918541,921234,923909,926604,929316,932028,934735,937439,940170,942888,945593,948295,951001,953701,956391,959066,961721,964361,966996,969628,972256,974876,977488,980095,982686,985275,987899,990518,993129,995739,998334,1000918,1003499,1006073,1008640,1011199,1013779,1016343,2371859,2374919,2377963,2380992,2384021,2387045,2390108,2393163,2396220,2399256,2402273,2405289,2408301,2411297,2414291,2417272,2420279,2423277,2426266,2429244,2432221,2435184,2438135,2441074,2444001,2446924,2449840,2452748,2455633,2458516,2461382,2464239,2467093,2469968,2472899,2475809,2478743,2481667,3449366,3451504,3453640,3455759,3457884,3460005,3462143,3464270,3466416,3468595,3470763,3558691,3560705)) 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





	Andrey Yakhnyuk (Dancer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Andrey Yakhnyuk (Dancer)

Andrey Yakhnyuk (Dancer)

Born in 1982. In 1999, graduated from the Moscow Ballet Academy. In 1999-2007, he was a principal dancer of the Tachkin Ballet Theatre. In 2007, joined the Mikhailovsky Ballet Company.

The repertoire includes:
— Prince Siegfried (Swan Lake)
— Prince (The Nutcracker, vers. by Nikolay Boyarchikov)
— Prince Desire (The Sleeping Beauty)
— Albert, peasant pas de deux (Giselle)
— Ocean (Ocean and Pearl)
— Four friends (Romeo and Juliet, vers. by O.Vinogradov)
— Master Grape (Cipollino, chor. by Genrikh Mayorov)
— Shepherd (Spartacus, chor. by George Kovtun)
— In a Minor Key (chor. by Slava Samodurov)
— Without Words, chor. by Nacho Duato
— Duende chor. by Nacho Duato
— Prelude, chor. by Nacho Dauto
— Multiplicity. Forms of Silence and Emptiness, chor. by Nacho Duato