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 (3532211,3534251,3536293,3538323,3540345,3542414,3544473,3546512,3548549,3550581,3552624,3554658,3556697,3558719,3560733,3562734,3564736,3566756,3568769,3570785,3572794,3574807,3576716,3835752,3835996,3836235,3836468,3910091,3910778,3911464,3912153,3912830,3913516,3914192,3914863,3915542,3916222,3916896,3917567,3918239,3918912,3919601,3920292,3956435,3957058,3957679,3957685,3958299,3958303,3958911,3958916,3959518,3959522,3960122,3960125,3960724,3960729,3961324,3961329,3961919,3961922,3962506,3962510,3963089,3963092,3963662,3963665,3964234,3964240,3964806,3964809,3965377,3965963)) 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





	Anastasia Yaromenko (Dancer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Anastasia Yaromenko (Dancer)

Anastasia Yaromenko (Dancer)

Born in Novosibirsk. 
Graduated from the Vaganova Academy of Russian Ballet in 2016 (class of Irina Sitnikova).
Joined the Mariinsky Ballet the same year.

Repertoire includes: 
Swan Lake (Swans, Mazurka, Spanish Dance); choreography by Marius Petipa and Lev Ivanov, revised version by Konstantin Sergeyev, 
La Bayadère (D'Jampe); choreography by Marius Petipa, revised version by Vladimir Ponomarev and Vakhtang Chabukiani,
Don Quixote (Street Dancer); choreography by Alexander Gorsky after motifs of the production by Marius Petipa, 
Schéhérazade (Odalisques); choreography by Michel Fokine, 
The Nutcracker (Elegant Lady); choreography by Vasily Vainonen, 
The Fountain of Bakhchisarai (Ghirei's Second Wife); choreography by Rostislav Zakharov, 
The Stone Flower (Amethysts); choreography by Yuri Grigorovich, 
Carmen Suite (Fate); choreography by Alberto Alonso, 
5 Tango’s; choreography by Hans van Manen; 
Le Parc; choreography by Angelin Preljocaj 
Cinderella (Dance Teacher), The Little Humpbacked Horse (Gypsy Dance); choreography by Alexei Ratmansky, 
Russian Overture; choreography by Maxim Petrov; 
and Yaroslavna. The Eclipse (Dancers); choreography by Vladimir Varnava.