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 (3029481,3030908,3030952,3030956,3032321,3032369,3032373,3033726,3033773,3033776,3035318,3035365,3035368,3036897,3036944,3036947,3038466,3038513,3038516,3040026,3040073,3040076,3041579,3041626,3041630,3043123,3043170,3043174,3044663,3044708,3044712,3046194,3046238,3046241,3047710,3047754,3047757,3049217,3049260,3049264,3050723,3050772,3050776,3052226,3052274,3052277,3053716,3053764,3053769,3055199,3055244,3055247,3056672,3056716,3056720,3058130,3058177,3058182,3059578,3059626,3059629,3061022,3061066,3061068,3062758,3062805,3062811,3064536,3064542,3066259,3066260,3067968,3067971,3069665,3069668,3071352,3071358,3073032,3073037,3074701,3074704,3076360,3076362,3078013,3078017,3079673,3079676,3081325,3268739,3268781,3270788,3270829,3272914,3272957,3275025,3275065,3277119,3277160,3279206,3279248,3281342,3281383,3283466,3283512,3285588,3285634,3287737,3287782,3289871,3289917,3291985,3292031,3294091,3294137,3296191,3296238,3298284,3298330,3300367,3300415,3302445,3302489,3304507,3304553,3306555,3306603,3308601,3308648,3310643,3310690,3312722,3314740,3316753,3318752,3320742,3322725,3324873,3327144,3329529,3331912,3334278,3336629,3338979,3341323,3343660,3475143,3477296,3479442,3481580,3483712,3485833,3487945,3490052,3492182,3494303,3496419,3498573,3500717,3502852,3504983,3507108,3509228,3550612,3552651,3554684,3556726,3558750,3560763,3562766,3564768,3566785,3568796,3570817,3572824,3574838,3576746,3578649,3580548,3582437,3584299,3586154,3588009,3589861,3591708,3807826,3808202,3808575,3835746,3835988,3838001,3838006,3838025,3838258,3838262,3838282,3838510,3838516,3838534,3838761,3838767,3838786,3839015,3839020,3839039,3839270,3839290,3839518,3839537,3839781,3840023,3840262,3840507,3840790,3841069,3841344,3852390,3852983,3853575,3918250,3918926,3919617,3920303,3920982,3921660,3922334,3926409,3927071,3927730,3928387,3929043,3929696,3930344,3930991,3931636,3932281)) 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





	Nail Yenikeyev (Dancer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Nail Yenikeyev (Dancer)

Nail Yenikeyev (Dancer)

Born in Ufa. 
Graduated from the Vaganova Academy of Russian Ballet in 2014 (class of Mansur Yenikeyev) and joined the Mariinsky Ballet the same year.

Repertoire includes: 
Giselle (Hans); choreography by Jean Coralli, Jules Perrot, Marius Petipa, 
Swan Lake (Spanish and Hungarian Dances, Mazurka); choreography by Marius Petipa and Lev Ivanov, revised version by Konstantin Sergeyev, 
Raymonda (Hungarian Dance, Panaderos); choreography by Marius Petipa, revised version by Konstantin Sergeyev, 
La Bayadère (Indian Dance); choreography by Marius Petipa, revised version by Vladimir Ponomarev and Vakhtang Chabukiani, 
Le Corsaire (Birbanto, Forban dance); choreography by Pyotr Gusev after the composition by Marius Petipa, 
Don Quixote (Fandango); choreography by Alexander Gorsky after motifs of the production by Marius Petipa, Fandango choreographed by Fyodor Lopukhov, 
Le Carnaval (Eusebius); choreography by Michel Fokine, 
George Balanchine's ballets Scotch SymphonyA Midsummer Night’s Dream (Lysander), 
The Fountain of Bakhchisarai (Cracovienne); choreography by Rostislav Zakharov, 
The Nutcracker (Spanish Dance, Waltz of the Flowers, Elegant Cavaliers); choreography by Vasily Vainonen, 
Romeo and Juliet (Folk Dance); choreography by Leonid Lavrovsky, 
The Stone Flower (A Young Gypsy Man, Gems); choreography by Yuri Grigorovich, 
Spartacus (Numidian, Gannicus); choreography by Leonid Yakobson, 
Sylvia (Apollo); choreography by Frederick Ashton, 
Carmen-Suite (Corregidor); choreography by Alberto Alonso, 
5 Tango's; choreography by Hans van Manen,
Le Parc; choreography by Angelin Preljocaj, 
The Nutcracker (Cossack, Spanish Dance); choreography by Kirill Simonov, production by Mihail Chemiakin,
The Little Humpbacked Horse (Horses, Seahorses, Gypsy Dance), Anna Karenina (Yegorushka Korsunsky); choreography by Alexei Ratmansky, 
The Bronze Horseman (Contredanse); choreography by Rostislav Zakharov, Yuri Smekalov, 
Paquita (Young Gipsy Man); choreography by Yuri Smekalov, reconstruction and staging of Marius Petipa's choreography (Act III Grand Pas) by Yuri Burlaka,
Bambi (Ronno); choreography by Anton Pimonov, 
Pavlovsk, Russian Overture; choreography by Maxim Petrov,
Yaroslavna. The Eclipse (Mercenaries), Pétrouchka (Proscenium servants); choreography by Vladimir Varnava 
and dances in the opera Ruslan and Lyudmila (Lezginka).

Repertoire also includes: 
Raymonda (Mazurka); choreography by Marius Petipa, revised version by Konstantin Sergeyev, 
Panaderos from the ballet Raymonda; choreography by Marius Petipa, revised version by Konstantin Sergeyev, 
Labyrinth; choreography by Ksenia Zvereva,
as part of the project The Dreamers: Beyond; choreography by Maxim Petrov, Lose Yourself to Dance; choreography by Maxim Petrov and Ilya Zhivoi.

He has toured with the Mariinsky Ballet to China, the USA and Germany.