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 (3030956,3032373,3033776,3035368,3036947,3038516,3040076,3041630,3043174,3044712,3046241,3047757,3049264,3050776,3052277,3053769,3055247,3056720,3058182,3059629,3061068,3062811,3064542,3066260,3067971,3069668,3071358,3073037,3074704,3076362,3078017,3079676,3081325,3222691,3222696,3222704,3222710,3222719,3222759,3222761,3222777,3222787,3224353,3224362,3224370,3224377,3224383,3224424,3224426,3224444,3224452,3225983,3225991,3225997,3226006,3226009,3226052,3226057,3226071,3226079,3227597,3227605,3227612,3227622,3227631,3227669,3227672,3227689,3227695,3229215,3229221,3229230,3229238,3229248,3229286,3229290,3229306,3229313,3230841,3230844,3230855,3230860,3230870,3230910,3230912,3230927,3230937,3232456,3232462,3232470,3232476,3232483,3232526,3232528,3232545,3232551,3234064,3234072,3234077,3234089,3234095,3234133,3234136,3234154,3234161,3235663,3235671,3235677,3235688,3235694,3235733,3235736,3235752,3235760,3237247,3237255,3237261,3237272,3237278,3237317,3237319,3237336,3237344,3238823,3238832,3238841,3238843,3238886,3238892,3238906,3238913,3240392,3240398,3240405,3240411,3240454,3240459,3240474,3240482,3242002,3242012,3242018,3242058,3242059,3242077,3242085,3243594,3243603,3243613,3243650,3243655,3243671,3243678,3245186,3245192,3245234,3245237,3245251,3245261,3246786,3246791,3246834,3246840,3246853,3246860,3248377,3248421,3248426,3248440,3248446,3249992,3249994,3250011,3250018,3251555,3251560,3251574,3251584,3253117,3253120,3253134,3253144,3254716,3254719,3254734,3254742,3256725,3256729,3256746,3256752,3258736,3258742,3258757,3258764,3260735,3260739,3260753,3260759,3262717,3262718,3262734,3262741,3264697,3264702,3264715,3264725,3266673,3266677,3266692,3266702,3268658,3268664,3268677,3268687,3268778,3270711,3270727,3270734,3270825,3272853,3272861,3272953,3274964,3274973,3275064,3277058,3277065,3277156,3279145,3279155,3279246,3281289,3281380,3283414,3283509,3285628,3287779,3289913,3292029,3294134,3296233,3298327,3300410,3302486,3304549,3306598,3308644,3310684,3312720,3314737,3316748,3318749,3320737,3322722,3324871,3327139,3329527,3331908,3334275,3336626,3338975,3341318,3341346,3341408,3343683,3343749,3346042,3346103,3348392,3348452,3350731,3350793,3353054,3353114,3355373,3355434,3357700,3357764,3360048,3360111,3362474,3364825,3367168,3369495,3371818,3374139,3376448,3378759,3381050,3383324,3385609,3387879,3390138,3392385,3492192,3494317,3496433,3498587,3500730,3502864,3504996,3507119,3509242,3511356,3513464,3515558,3532211,3534251,3536293,3538323,3540345,3542414,3544473,3546512,3548549,3550581,3552624,3554658,3556697,3558719,3560733,3562734,3564736,3566756,3568769,3570785,3572794,3574807,3576716,3979878,3980462,3981047,3994321,3994844,3995360,3995879,3996391,3996898,4051491,4052370,4053244)) 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





	Yekaterina Petrova (Dancer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Yekaterina Petrova (Dancer)

Yekaterina Petrova (Dancer)

Graduated from the Vaganova Ballet Academy in 2005 (class of Irina Sitnikova). 
Joined the Mariinsky Ballet the same year.

Repertoire includes: 
La Sylphide (Effie, Nancy, Sylphs); choreography by August Bournonville, revised version by Elsa-Marianne von Rosen, 
Giselle (Myrtha); choreography by Jean Coralli, Jules Perrot and Marius Petipa, 
La Bayadère (Gamzatti, D’Jampe, Hindu Dance, Bayadères, Trio of Shades); choreography by Marius Petipa, revised version by Vladimir Ponomarev and Vakhtang Chabukiani, 
Swan Lake (Pas de trois, Cygnets, Swans, Two Swans); choreography by Marius Petipa and Lev Ivanov, revised version by Konstantin Sergeyev, 
Raymonda (Clemance, variation in the Dream scene, Grand pas); choreography by Marius Petipa, revised version by Konstantin Sergeyev, 
The Sleeping Beauty (Gold Fairy); choreography by Marius Petipa, revival of the 1890 version, staging by Sergei Vikharev, 
The Sleeping Beauty (Gold Fairy, Sapphire Fairy, Silver Fairy, Courage Fairy); choreography by Marius Petipa, revised version by Konstantin Sergeyev, 
Le Corsaire (Gulnare, Trio of Odalisques); production by Pyotr Gusev after the composition and choreography of Marius Petipa, 
Don Quixote (Queen of the Dryads, Amour, Flower-Seller); choreography by Alexander Gorsky, 
Michel Fokine's ballets The Firebird (Firebird), Le Carnaval (Estrella), 
Pétrouchka (Dancers); choreography by Michel Fokine, production by Gary Chryst, 
The Fountain of Bakhchisarai (Young Noblewomen); choreography by Rostislav Zakharov, 
Romeo and Juliet (Folk Dance, Juliet’s Companion, Servants at the Inn); choreography by Leonid Lavrovsky, 
Spartacus (Etruscans); choreography by Leonid Yakobson, 
George Balanchine’s ballets The Four Temperaments (Melancholic), Jewels (Diamonds, Rubies) and Symphony in C (I. Allegro vivo), Serenade, 
The Stone Flower (Amethysts); choreography by Yuri Grigorovich, 
Carmen Suite (Tobacco-Worker); choreography by Alberto Alonso, 
5 Tango's; choreography by Hans van Manen, 
The Nutcracker (the Nutcracker’s Sisters, Canteen-Keeper, Chinese Dance, Waltz of the Flowers); production by Mihail Chemiakin, choreography by Kirill Simonov, 
Alexei Ratmansky’s ballets Cinderella (Khudyshka, Kubyshka) and The Little Humpbacked Horse (Wet-Nurses, Gypsy Dance), Concerto DSCH, 
The Magic Nut (Princess Pirlipat, Rat Jester, Spanish Rat); production by Mihail Chemiakin, choreography by Donvena Pandoursky, 
Le Bourgeois Gentilhomme (Dancers); choreography by Nikita Dmitrievsky, 
Ondine (Tarantella, Four Naiads); choreography by Pierre Lacotte, 
Le Sacre du printemps (Sylph); choreography by Donvena Pandoursky, 
Yuri Smekalov's ballets Presentiment of Spring (Three Women), Camera Obscura (Magda), 
Diana Vishneva: Beauty in Motion (Moses Pendleton’s F.L.O.W. (Swan’s Dreams), 
Le Parc; choreography by Angelin Preljocaj, 
The Vertiginous Thrill of Exactitude; choreography by William Forsythe, 
Sacre; choreography by Sasha Waltz, 
Bambi (Falina); choreography by Anton Pimonov, 
Maxim Petrov's ballets Ballet No 2, Russian Overture, Pavlovsk
Paquita (Paquita’s friends); choreography by Yuri Smekalov, reconstruction and staging of Marius Petipa's choreography (Act III Grand Pas) by Yuri Burlaka,
Pulcinella (Prudenza); choreography by Ilya Zhivoi, 
as well as the Dances of Naina’s Charms and Chernomor’s Slaves in the opera Ruslan and Lyudmila.

Repertoire also includes:
Grand pas from “Paquita” (Variation); choreography by Marius Petipa.

Has toured with the Mariinsky Ballet to China.