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 (479533,481101,481848,482586,483320,484059,484809,485555,486292,487017,487735,488446,497384,498848,500302,501756,503250,504727,506204,507673,509139,510603,512058,513508,514978,516441,583964,583970,584034,585282,585287,585351,586590,586595,586657,587896,587901,587965,589192,589197,589261,590833,590838,590900,592450,592455,592518,594076,594081,594147,595779,595785,595847,597470,597475,597537,599151,599156,599218,600822,600827,600890,602499,602504,602567,604167,604172,604234,605830,605892,607541,609179,610866,612547,614219,614220,614251,615881,615882,615913,615968,616054,617529,617531,617562,617617,617703,619164,619169,619196,619254,619341,620794,620799,620827,620883,620969,622418,622423,622450,622508,622595,624032,624037,624064,624122,624209,625657,625662,625689,625747,625834,627273,627279,627303,627362,627447,628884,628907,628967,629051,630503,630563,630647,632092,632151,632236,633676,633735,633825,635249,635309,635398,636811,636871,636959,638364,638424,638512,639963,640050,641492,641579,643014,643101,644525,644614,646031,646121,647531,647617,649018,649107,650515,650602,651999,652083,653474,653559,654940,655024,656451,656461,656479,657898,657908,657930,659347,659357,659379,660784,660799,660816,662211,662226,662243,663631,663644,663665,665045,665059,665075,666453,666465,666485,667888,667900,667920,669309,669324,669342,670747,670759,670779,672173,672187,672205,673605,673624,675010,675029,676426,677812,679218,693958,695206,696434,697654,698862,700060,701249,702446,703630,704805,705961,707108,859662,862379,865086,867781,870464,873147,875830,878517,921202,923878,926572,929286,1136450,1138652,1140849,1143040,1145223,1147393,1149549,1151702,1153851,1155990,1158163,1160321,1162470,1164603,1166733,1168867,1170992,1173108,1175219,1177359,1179489,1181615,1183730,1185836,1187946,1190047,1192140,1194221,1196299,1198374,1200439,3403530,3405706,3407876,3410043,3412186,3414353,3416504,3418643,3420763,3422865,3492159,3494280,3532211,3534251,3536293,3538323,3538330,3540345,3540354,3542414,3542423,3544473,3544480,3546512,3546523,3548549,3548560,3550581,3550592,3550627,3552624,3552631,3552672,3554658,3554665,3554703,3556697,3556705,3556742,3558719,3558731,3558768,3560733,3560742,3560780,3562734,3562746,3562786,3564736,3564746,3564788,3566756,3566764,3566801,3568769,3568777,3568815,3570785,3570795,3570834,3572794,3572805,3572844,3574807,3574817,3574853,3576716,3576724,3576763,3578629,3578669,3580527,3580568,3582423,3582450,3584315,3586168,3588026,3589873,3591723,3593572,3595521,3597512,3599490,3807850,3808226,3808599,3808968,3809336,3809702,3810064,3810423,3810774,3810802,3811165,3811193,3811578,3811958,3812334,3812712,3813079,3813448,3836712,3836974,3837231,3837485,3837738,3837992,3840273,3840523,3840806,3841085,3841360,3841632,3841899,3842161,3842421,3842688,3847478,3847710,3847938,3848162)) 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





	Viktoria Brilyova (Dancer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Viktoria Brilyova (Dancer)

Viktoria Brilyova (Dancer)

Born in Rostov-on-Don. 
Graduated from the Vaganova Academy of Russian Ballet in 2010. 
Joined the Mariinsky Ballet the same year.

Repertoire includes: 
La Sylphide (Sylphs); choreography by August Bournonville, revised version by Elsa-Marianne von Rosen, 
Giselle (Zulma, Monna); choreography by Jean Coralli, Jules Perrot and Marius Petipa, 
Swan Lake (Swans, Spanish Dance); choreography by Marius Petipa and Lev Ivanov, revised version by Konstantin Sergeyev, 
La Bayadère (Grand pas, D’Jampe); choreography by Marius Petipa, revised version by Vladimir Ponomarev and Vakhtang Chabukiani, 
Raymonda (Grand pas); choreography by Marius Petipa, revised version by Konstantin Sergeyev, 
Don Quixote (Street Dancer), choreography by Alexander Gorsky after motifs of the production by Marius Petipa, 
Michel Fokine’s ballets Le Carnaval (Chiarina, Estrella) and Schéhérazade (Zobeide, Odalisques), 
George Balanchine’s ballets Jewels (Esmeralds, Rubies, Diamonds), A Midsummer Night’s Dream (Helena), Symphony in C (III, IV. Allegro vivace) and Serenade
The Fountain of Bakhchisarai (Zarema); choreography by Rostislav Zakharov, 
The Nutcracker (Elegant Ladies, Rose Waltz); choreography by Vasily Vainonen, 
The Young Lady and the Hooligan (Friend of the Leader); choreography by Konstantin Boyarsky,
Spartacus (Phrygia); choreography by Leonid Yakobson,
Sylvia (Ceres, Terpsichore); choreography by Frederick Ashton, 
In the Night (II part); choreography by Jerome Robbins, 
Adagio Hammerklavier; choreography by Hans van Manen, 
Ondine (Four Naiads); choreography by Pierre Lacotte, 
Alexei Ratmansky’s ballets Cinderella (Female Dance, Dance Teachers), Anna Karenina (Dolly, a Minister’s Wife),Concerto DSCH
Le Parc (Soloist); choreography by Angelin Preljocaj, 
Presentiment of Spring (Winter); choreography by Yuri Smekalov, 
In the Middle, Somewhat Elevated; choreography by William Forsythe,
Choreographic Game 3x3; choreography by Anton Pimonov,
and Infra; choreography by Wayne McGregor.

Repertoire also includes: 
Chopiniana (Prelude); choreography by Michel Fokine, 
Vladimir Varnava's ballets Window on Deep Midwinter, Clay, 
Maxim Petrov's ballets Cinéma, Ballet No 2,
the pas de deux from the ballet The Tragedy of Salome; choreography by Emil Faski, 
and the Oriental Dance in the opera Ruslan and Lyudmila.

Has toured with the Mariinsky Ballet to the USA, Japan, Germany and Italy.