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 (382877,384696,386508,388312,390120,391920,393719,395514,397303,399085,400859,402623,404383,406137,407888,409632,411372,413134,414885,416627,418368,420104,421883,423607,425330,427037,428734,430433,432135,433844,435539,437227,501095,502544,504029,505506,506977,508449,642187,642188,643704,643705,645214,645215,646719,646721,648214,648216,649713,649715,651201,651203,652682,652684,654154,654156,655615,655617,657066,657068,658521,658523,919704,922391,925090,927783,930496,933200,935910,938627,941351,944064,946768,949472,952174,954871,957552,960214,962861,965499,968131,970764,973387,976000,978613,981211,983800,986427,989049,991667,994275,996874,999462,1002045,1259424,1261371,1263305,1265230,1267160,1269080,1270989,1272887,1274771,1276640,1278495,1280349,1282194,1284025,1285849,1287660,1381454,1381585,1381592,1383270,1383401,1383408,1385077,1385211,1385219,1386881,1387015,1387023,1388675,1388809,1388817,1390455,1390589,1390597,1392224,1392358,1392366,1393984,1394118,1394126,1395762,1395896,1395904,1397528,1397662,1397670,1399285,1399419,1399427,1401171,1401179,1402913,1402921,1404646,1404654,1406369,1406377,1408090,1408098,1409814,1409822,1411541,1411549,1413291,1413299,1415051,1415059,1416793,1416803,1418536,1418544,1420263,1420271,1421980,1421988,1423683,1423691,1425372,1425380,1427046,1427054,1428710,1428718,1430360,1430368,1432000,1432008,1433631,1433639,1435247,1435255,1436852,1436860,1438473,1438481,1440081,1440089,1441682,1441690,1443276,1443284,1444868,1446444,2094471,2096350,2098215,2100176,2102127,2117725,2119612,2121489,2123356,2125208,2127049,2128883,2130709,2132525,2134332,2136126,2137906,2139753,2141587,2143412,2145226,2147030,2148824,2150604,2152371,2154129,2155878,2157616,2159343,2161097,2162836,2649848,2649855,2652427,2652434,2654994,2655001,2657546,2657553,2660080,2660087,2662595,2662602,2665096,2665103,2667583,2667590,2670046,2670053,2672497,2672504,2815069,2818052,2821028,2824000,2826976,2829935,2832877,2835804,2838738,2841662,2907913,2910530,2913128,2915716,2918306,2920879,2923444,2925999,2928535,2931054,2933562,2936062,2938570,2941073,2943567,2946045,2948507,2950954,2953401,3096759,3098340,3099917,3101483,3103034,3104576,3106115,3107664,3168292,3169679,3171059,3172433,3173801,3175161,3176562,3177958,3179432,3180902,3182369,3183830,3185293,3186751,3188205,3189652,3191095,3192534,3194227,3195914,3197697,3199667,3201368,3203062,3204754,3206443,3208125,3209711,3209803,3211381,3211473,3213090,3213182,3214790,3214878,3216484,3216572,3218175,3218263,3219859,3219947,3221534,3221622,3221627,3223206,3223294,3223299,3224841,3224929,3224934,3226463,3226551,3226556,3228077,3228165,3228170,3229692,3229782,3229787,3231399,3231404,3233012,3233017,3234614,3234619,3236201,3236206,3237776,3237781,3239345,3239350,3240908,3240913,3242506,3242511,3244092,3244097,3245668,3245673,3247259,3247264,3248836,3248841,3250404,3250409,3251968,3251973,3253565,3253570,3255561,3255566,3257576,3257581,3267625,3269677,3271763,3273878,3275977,3278067,3280160,3282290,3284414,3286530,3288670,3290793,3292902,3295005,3297101,3299189,3301268,3402255,3404438,3406610,3408783,3410934,3413063,3415217,3417359,3419491,3421600,3423689,3425756,3427804,3429835,3536936,3538962,3541001,3543062,3545110,3547148)) 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 Goryacheva (Soloist) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Anastasia Goryacheva (Soloist)

Anastasia Goryacheva (Soloist)

Biography
Born in Moscow. In 1998, having completed his studies at the Moscow Academy of Choreography (Tatiana Galtseva's class), she joined the Bolshoi Theatre Company. For a long time she was training under Raisa Struchkova. At the present time, her teacher-repetiteur is Lyudmila Semenyaka.

Main Repertory

1998
Spanish Doll (The Nutcracker; Yuri Grigorovich production)
Little Radish (Karen Khachaturyan's Cipollino; choreography by Genrikh Mayorov)

1999
Maid of Honour (Swan Lake; Vladimir Vasiliev production)
Pearl (Rodion Shchedrin's The Humpbacked Horse; choreography by Nikolai Androsov) - creation
Lady of Heart (Fantasy on the Casanova Theme to music by W.A. Mozart; choreography by Mikhail Lavrovsky)
Pas d’Action (Giselle; Vladimir Vasiliev production)
Imp (Fairy tale on the priest and his worker Balda to music by Dmitry Shostakovich; choreography by Vladimir Vasiliev)
Soloist (Mozartiana to music by Pyotr Tchaikovsky; choreography by Georges Balanchine)
2nd Pas de Trois (Agon; choreography by Georges Balanchine)
Cupid (Don Quixote, choreography by Marius Petipa, Alexander Gorsky in a version by Alexei Fadeyechev)

2000
Marie (The Nutcracker)
2nd Variation in Grand Pas (Cesare Pugni’s La Fille du Pharaon; Pierre Lacotte production after Marius Petipa) - creation
Princess Aurora, Fairy of Diamond (The Sleeping Beauty; Yuri Grigorovich production)

2001
Title role (La Sylphide; choreography by August Bournonville in a version by E.M. von Rosen)
Neapolitan Bride (Swan Lake in Yuri Grigorovich's second version)
Mazur (Chopiniana; choreography by Mikhail Fokine)

2002
Lise (La Fille mal gardee. Music by Louis Herold; choreography by Frederick Ashton)
Giselle (Giselle; Yuri Grigorovich and Vladimir Vasiliev productions)

2003
Variation in Grand Pas, 2nd variation in Raymonda's Dreams, Henriette (Raymonda; Yuri Grigorovich production)

2004
Soloist Part 1 (Symphony in C; choreography by Georges Balanchine)
Friend to the Prince (Swan Lake)

2005
Tarantella (choreography by George Balanchine)
Helena (A Midnight's Summer Dream; choreography by John Neumeier)

2007
Pas d'Esclaves (Le Corsaire; production and new choreography by Alexei Ratmansky and Yuri Burlaka after Marius Petipa)

2008
Title role (Herman Levenskiold's La Sylphide; choreography by August Bournonville in a version by Johan Kobborg)
Zina (Dmitry Shostakovich's The Bright Stream; choreography by Alexei Ratmansky)

In 2001, she danced at the Bolshoi Theatre the title part in La Sylphide opposite Johan Kobborg.
In 2003, she participated in the gala evening of the Bolshoi Ballet and Royal Ballet soloists at the Bolshoi Theatre. She danced the pas de deux from Flower festival in Genzano (choreography by August Bournonville) with Johan Kobborg.
In 2003, she danced the part of Fairy of Diamond in The Sleeping Beauty and the leading part in Chopiniana at the International Ballet Festival named after Rudolf Nureyev in Kazan.
In 2004, she participated in The Bolshoi Ballet Company workshop - taking part in Hungarian Dances to music by Johannes Brahms (choreography by Alexei Miroshnichenko).

Awards

In 1999, for her interpretation of the part of Agon and of the part of Little Radish in Cipollino she was awarded the Moscow Debuts Festival prize.
In 2002, Ballet magazine awarded him its Soul of Dance prize (in the Rising Star nomination).