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 (381031,382825,382828,382829,382841,382856,384644,384647,384648,384659,384675,386459,386460,386471,386487,388276,388291,390083,390099,391883,391899,393682,393698,395477,395493,397266,397282,399050,399065,400839,402604,404362,406118,407869,409613,421901,421906,421907,421928,421932,421933,423631,423636,423637,423657,423661,423662,425353,425359,425360,425379,425383,425384,427061,427066,427067,427087,427091,427092,428758,428762,428763,428785,428789,428790,430451,430455,430456,430478,430482,430483,432158,432162,432163,432185,432189,432190,433865,433869,433870,433889,433892,433893,435560,435564,435565,435584,435587,435588,437247,437252,437253,437271,437275,437276,438923,438928,438929,438947,438951,438952,440588,440592,440593,440611,440615,440616,442239,442243,442244,442262,442266,442267,443877,443881,443882,443900,443904,443905,445504,445508,445509,445527,445531,445532,447128,447129,447149,447153,447154,448758,448762,448763,450355,450359,450360,451946,451950,451951,453536,453540,453541,455122,455126,455127,456700,456704,456705,458272,458276,458277,459836,459840,459841,461391,461395,461396,462939,462943,462944,464491,464495,464496,466038,466042,466043,467583,467584,469288,469289,477294,478868,480435,481187,481932,482669,483403,484145,484894,485637,486367,487088,487802,488514,489226,489933,490633,491328,492013,492696,493378,501101,501151,501155,501163,502550,502598,502602,502610,504035,504081,504085,504094,505513,505561,505565,505573,506983,507029,507033,507042,508455,508501,508505,508514,509922,509971,509975,509981,511381,511431,511435,511443,512883,512887,512894,514362,514366,514374,515832,515836,515844,517293,517297,517305,518744,518748,518756,520186,520190,520198,521629,521633,521641,523061,523065,523073,524486,524490,524498,525904,525908,525916,527311,527315,527323,528717,528721,528729,530120,530124,530133,531518,531522,531531,532908,532912,532921,534346,534350,534358,535777,535781,535791,537203,537207,537217,538631,538635,538645,540056,540066,541476,542928,957565,960227,962877,965511,968143,970779,973402,976013,978625,981224,983812,986439,989061,991682,994286,996885,999472,1002054,1002111,1004640,1004692,1007209,1007261,1009767,1009823,1012376,1014946,1017502,1020049,1022592,1025132,1027663,1030187,1032699,1037710,1037711,1040195,1040196,1042673,1042674,1045143,1045144,1047611,1047612,1071889,1071890,1074282,1074289,1076672,1076678,1079048,1079054,1081413,1081416,1083765,1083768,1086101,1086105,1088425,1088429,1090761,1090767,1093088,1093090,1095403,1095409,1097703,1097709,1097762,1097766,1097767,1097771,1099983,1099985,1100044,1100049,1100053,1100054,1102255,1102257,1102316,1102321,1102325,1102326,1104514,1104515,1104574,1104579,1104583,1104584,1106751,1106754,1106811,1106814,1106819,1106821,1108967,1108971,1109027,1109030,1109034,1109035,1111162,1111166,1111222,1111225,1111229,1111230,1113399,1113402,1113406,1113407,1115557,1115560,1115564,1115566,1117698,1117701,1117705,1117707,1119833,1119836,1119840,1119842,1121963,1121966,1121970,1121972,1124101,1124104,1124108,1124110,1126296,1126299,1126303,1126305,1128486,1128489,1128493,1128494,1130699,1130703,1130707,1130708,1132895,1132899,1132903,1132904,1135085,1135088,1135092,1135094,1137290,1137293,1137297,1137298,1139490,1139494,1139498,1139499,1141689,1141693,1141694,1143879,1143880,1227627,1229641,1231650,1233647,1235633,1237615,1239583,1241539,1243522,1276650,1276660,1276691,1276708,1278507,1278518,1278547,1278564,1280361,1280375,1280397,1280416,1282203,1282213,1282244,1282261,1284037,1284048,1284077,1284094,1285861,1285872,1285901,1285918,1287672,1287683,1287712,1287729,1289466,1289477,1289506,1289523,1291251,1291262,1291291,1291308,1293061,1293072,1293101,1293118,1294863,1294874,1294903,1294920,1296669,1296698,1296715,1298455,1298484,1298501,1300255,1300272,1302014,1302031,1303763,1303780,1305511,1305528,1307251,1307268,1308981,1308998,1310716,1312635,1314552,1316486,1381474,1381553,1383290,1383369,1385097,1385178,1385215,1386901,1386982,1387019,1388695,1388776,1388813,1390475,1390556,1390593,1392244,1392325,1392362,1394004,1394085,1394122,1395782,1395863,1395900,1397548,1397629,1397666,1399305,1399386,1399423,1401057,1401138,1401175,1402799,1402880,1402917,1404532,1404613,1404650,1406255,1406336,1406373,1407976,1408057,1408094,1409781,1409818,1411508,1411545,1413258,1413295,1415018,1415055,1416765,1416805,1418503,1418540,1420230,1420267,1421947,1421984,1423650,1423687,1425339,1425376,1427013,1427050,1428677,1428714,1430327,1430364,1431967,1432004,1433598,1433635,1435251,1436856,1438477,1440085,1441686,1443280,1444864,1446440,1545887,1546972,1548045,1549108,1550167,1551215,1552254,1553295,1554330,1555357,1556375,1557385,1558393,1558469,1559391,1559467,1560825,1562174,1564017,1565850,1567676,1570597,1573490,1576371,1579243,1582105,1584952,1587790,1590625,1593450,1596307,1599178,1602037,1604886,1607727,1610560,1613385,1647069,1649880,1652749,1655612,1658460,1661297,1664120,1666935,1669739,1672595,1675447,1783748,1783749,1786280,1786281,1788785,1788786,1791279,1791280,1793755,1793756,1796212,1796213,1798660,1798664,1801115,1801116,1803560,1803561,1805985,1805986,1835868,1838058,1838069,1838070,1838083,1838089,1838090,1840238,1840248,1840250,1840263,1840269,1840271,1842398,1842406,1842407,1842422,1842431,1842432,1844543,1844552,1844553,1844566,1844572,1844573,1846683,1846693,1846694,1846707,1846712,1846713,1848836,1848848,1848850,1848861,1848868,1848869,1850996,1850999,1851010,1851017,1851018,1853138,1853139,1853152,1853157,1853158,1855274,1855275,1855288,1855293,1855294,1857421,1857426,1857427,1859542,1859550,1859551,1861659,1861664,1861665,1861677,1861689,1861692,1863772,1863780,1863781,1863792,1863804,1863806,1865882,1865887,1865888,1865900,1865912,1865915,1865930,1865946,1867977,1867978,1867990,1868002,1868005,1868020,1868036,1870061,1870062,1870074,1870084,1870085,1870103,1870121,1872148,1872160,1872163,1872178,1872194,1874209,1874219,1874220,1874242,1874255,1876263,1876273,1876274,1876296,1876309,1878315,1878327,1878330,1878345,1878361,1880400,1880403,1880418,1880434,1882464,1882467,1882482,1882498,1884519,1884522,1884537,1884553,1886616,1886629,1888681,1888695,1890741,1890755,1892798,1892819,1894870,1894891,1896953,1896974,1899088,1899109,1901257,1903394,1905521,1907667,1909824,1911972,2115710,2115712,2117605,2117607,2117673,2117674,2117702,2117732,2117742,2119492,2119494,2119560,2119561,2119589,2119619,2119629,2121369,2121371,2121437,2121438,2121466,2121496,2121506,2123236,2123238,2123304,2123305,2123333,2123363,2123373,2125156,2125157,2125185,2125215,2125225,2126997,2126998,2127026,2127056,2127066,2128831,2128832,2128860,2128874,2128890,2128900,2130657,2130658,2130686,2130700,2130716,2130726,2132473,2132474,2132502,2132516,2132532,2132542,2134280,2134281,2134309,2134323,2134339,2134349,2136074,2136075,2136103,2136117,2136133,2136143,2137858,2137859,2137887,2137898,2137916,2137928,2139701,2139702,2139730,2139744,2139760,2139770,2141535,2141536,2141564,2141578,2141594,2141604,2143360,2143361,2143389,2143403,2143419,2143429,2145174,2145175,2145203,2145217,2145233,2145243,2146978,2146979,2147007,2147021,2147037,2147047,2148772,2148773,2148801,2148815,2148831,2148841,2150581,2150595,2150611,2150621,2152348,2152362,2152378,2152388,2154107,2154120,2154136,2154146,2155856,2155869,2155885,2155895,2157594,2157607,2157623,2157633,2159334,2159350,2159360,2161088,2161104,2161114,2162843,2162853,2164572,2164582,2166293,2166303,2168006,2169697,2323415,2326553,2329683,2332794,2335896,2338992,2342088,2345195,2348294,2351390,2354509,2357616,2360717,2363812,2366897,2369971,2373036,2376086,2379124,2382156,2382202,2385183,2385229,2388198,2388244,2391260,2391306,2394316,2394362,2397359,2397405,2400388,2400434,2403406,2403452,2406420,2406466,2409425,2409471,2412420,2412466,2415452,2418466,2421468,2424459,2427445,2430422,2433390,2436349,2436372,2439318,2442253,2445179,2448100,2451010,2451063,2453913,2453966,2456797,2456850,2459729,2462593,2465448,2468325,2471263,2474177,2477120,2480052,2482970,2485878,2488781,2509134,2509215,2511995,2512076,2512082,2514850,2514931,2514937,2517700,2517781,2517787,2520543,2520624,2520630,2523456,2523462,2526276,2526282,2529089,2529095,2531897,2531903,2534698,2534704,2537492,2537498,2540286,2540292,2543070,2543076,2545843,2545849,2548608,2548614,2551413,2551419,2554209,2554215,2557020,2557026,2559821,2559827,2559866,2562610,2562616,2562655,2565386,2565390,2565432,2565491,2568152,2568156,2568198,2568257,2570988,2571027,2571087,2573851,2573909,2576665,2576723,2579467,2579524,2582264,2582321,2585046,2585103,2587817,2587874,2590585,2590642,2593401,2596152,2598894,2601623,2604339,2607046,2609749,2612443,2615167,2617884,2620591,2631400,2631408,2634067,2634075,2636713,2636721,2639347,2639355,2641968,2641976,2644577,2644585,2647178,2647186,2649766,2649774,2649897,2649902,2649948,2649975,2649983,2652345,2652353,2652476,2652481,2652527,2652554,2652562,2654912,2654920,2655043,2655048,2655094,2655121,2655129,2657595,2657600,2657646,2657673,2657681,2660129,2660134,2660180,2660207,2660215,2662644,2662649,2662695,2662722,2662730,2665145,2665150,2665196,2665223,2665231,2667632,2667637,2667683,2667710,2667718,2670095,2670100,2670146,2670173,2670181,2672546,2672551,2672597,2672624,2672632,2674977,2674982,2675028,2675055,2675063,2677389,2677394,2677440,2677467,2677475,2679781,2679786,2679832,2679859,2679867,2682157,2682162,2682208,2682235,2682243,2684524,2684529,2684575,2684602,2684610,2686886,2686891,2686937,2686964,2686972,2689241,2689246,2689292,2689319,2689327,2691636,2691663,2691671,2693964,2693991,2693999,2696302,2696335,2696345,2699385,2699419,2699430,2702455,2702489,2702500,2705531,2705565,2705576,2708578,2708612,2708623,2711655,2711666,2714686,2714697,2717706,2717717,2720771,2720782,2723879,2723890,2726978,2726989,2730065,2730076,2733175,2736278,3313590,3313592,3315604,3315606,3317608,3317610,3319602,3319604,3321588,3321590,3323573,3339831,3339938,3342277,3344638,3346990,3349333,3351661,3353982,3356300,3358648,3361013,3363370,3365714,3368050,3370378,3372699,3375013,3375112,3377322,3377421,3379622,3379721,3381905,3382004,3384170,3384286,3386444,3386560,3388820,3391074,3393317,3395546,3397762,3399969,3402163,3402204,3404346,3404387,3406518,3406559,3408691,3408732,3410842,3410883,3412971,3413012,3413092,3413109,3415166,3415246,3415263,3417308,3417388,3417405,3419440,3419520,3419537,3421549,3421629,3421646,3423718,3423735,3425785,3425802,3427833,3427850,3429864,3429881,3431878,3431895,3433885,3433902,3435885,3435902,3437872,3437889,3439845,3439862,3441811,3441828,3443790,3443825,3445761,3445796,3447912,3447947,3450055,3450090,3452190,3452225,3454349,3456468,3458592,3460723,3462853,3465003,3467147,3469320,3471482,3473636,3473639,3475792,3475795,3477945,3482269,3482317,3484396,3484444,3486514,3486562,3488618,3488624,3488672,3490751,3490757,3490805,3492877,3492883,3492931,3494997,3495003,3495051,3497154,3497160,3497208,3499301,3499307,3499355,3501441,3501447,3501495,3503574,3503580,3503627,3503645,3505702,3505708,3505755,3505773,3507825,3507831,3507878,3507896,3509947,3509994,3510012,3512059,3512106,3512124,3514208,3514226,3516302,3516320,3518350,3518389,3518407,3520475,3520493,3522549,3522567,3524617,3524635,3526673,3526691,3528738,3528756,3530790,3530808,3532832,3532850,3534872,3534890,3536923,3536939,3536957,3538949,3538965,3538983,3540988,3541004,3541022,3543065,3543083,3545113,3545131,3547151,3547169,3549185,3549203,3551245,3553282,3555323)) 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 Stashkevich (Dancer) - uVisitRussia
In 2003 she graduated from the Moscow State Choreographic Academy (class of Tatyana Galtseva) and joined the Ballet Company of the Bolshoi Theater. Now her teacher-repetiteur is Svetlana Adyrkhaeva.
Repertoire
2003
Cupid (Don Quixote by L.Minkus, choreography by Alexander Gorsky in the version by A. Fadeechev) Interpolation Pas de Deux (Giselle by A. Adam; choreography by Jean Coralli, Jules Perrot, Marius Petipa in the version by Yuri Grigorovich)
2004
Nutcracker-doll, Marie (Nutcracker, by P. Tchaikovsky, choreography by Y. Grigorovich) Little Red Riding-hood, Playful Fairy (The Sleeping Beauty by P.Tchaikovsky, choreography by M. Petipa, Y. Grigorovich version) Little Radish-brother(Karen Khachaturyan’s Cipollino, choreography by Genrikh Mayorov) Two Sylphs (Chopiniana to music by F. Chopin, choreography by Mikhail Fokine) Grand Pas (La Bayadere; choreography by Marius Petipa, in the version by Yuri Grigorovich) Gardeners (A Midsummer Night’s Dream to music by Felix Mendelssohn and Gyorgy Ligeti in a production by John Neumeier)
2005
Galya (The Bright Stream. Music by Dmitry Shostakovich. Alexei Ratmansky production)
2006
Friends to Boris (The Golden Age. Music by Dmitry Shostakovich. Production by Yuri Grigorovich) Shepherds (Spartacus by Karen Khachaturyan. Choreography by Yuri Grigorovich) 11th waltz (Chopiniana to music by F. Chopin, choreography by Mikhail Fokine) French doll (Nutcracker, by P. Tchaikovsky, choreography by Y. Grigorovich)
2007
Soloist (Philip Glass’ In the Upper Room; choreography by Twyla Tharp) Soloist (Igor Stravinsky’s Jeu de cards; Alexei Ratmansky’s сreation) Le Jardin Anime (appeared in the opening night performance in Bolshoi Theater), slaves dance and dance „with fans” (Le Corsaire by A. Adam. Production and new choreography by Alexei Ratmansky and Yuri Burlaka after Marius Petipa)
2008
Pas-de-six (Herman Levenskiold’s La Sylphide; choreography by August Bournonville in a version by Johan Kobborg) — was among the creators of this ballet at the Bolshoi Theatre Cupid (Boris Asfiev’s The Flames of Paris. Production and new choreography by Alexei Ratmansky after Vasily Vainonen) Soloist (was among the creators), pas de trois (Grand Pas classique for the ballet Paquita by L.Minkus, choreography by M. Petipa, new choreographic version by Y. Burlaka) Pair in red (Russian Seasons. Music by Leonid Desyatnikov, choreography by Alexei Ratmansky)
2009
Friends to Swanilda, L’Aurore, Swanilda (appeared in the opening night performance in Bolshoi Theater) (Coppelia by L. Délibes. Choreography by Marius Petipa and Enrico Cecchetti; revival and new choreographic version by Sergei Vikharev) Neapolitan bride (Swan Lake by P.Tchaikovsky, choreography Alexander Gorsky, Marius Petipa, Lev Ivanov in the 2nd version by Yuri Grigorovich) Pas d’action (Giselle in the version by V. Vasiliev) Princess Florine (The Sleeping Beauty) Esmeralda (Esmeralda by Cesare Pugni, choreography by Marius Petipa, staging and new choreographic version by Yuri Burlaka and Vasily Medvedev)
2010
Ballerina (Petrushka, by I. Stravinsky choreography by M. Fokin, new choreographic version by S. Vikharev) Lise (La Fille mal gardée by L. Hérold, choreography by F. Ashton)
2011
Coralie (Illusions perdues. Music by Leonid Desyatnikov, choreography by Alexei Ratmansky) Role in Chroma ballet, music by Joby Talbot and Jack White (choreography by Wayne McGregor) Vivette ( L’Arlesienne, to music by G. Bizet, choreography by R. Petit)
2012
Anyuta (Anyuta to music of V. Gavrilin, choreography by V. Vassiliev) Adelina (The Flames of Paris) Title role in The Rubies (Part II of Jewels, music by I.Stravinsky, choreography by G. Balanchine), title role in Emeralds (Part I of Jewels, music by G. Faure, choreography by G. Balanchine) Two pairs (Classical Symphony to music of S. Prokofiev, choreography by Y. Possokhov) Duet (Dream of Dream to music of S. Rachmaninov, choreography by J. Elo)
Fisherman’s wife, Guadalquivir, Ramze (Cesare Pugni’s La Fille du Pharaon; Pierre Lacotte production after Marius Petipa)
She took part in the Choreographers of the Bolshoi project Workshop of New Choreography (2004), dancing Diana in Riccardo Drigo’s Rosary pas de quatre from the ballet The Awakening of Flora (choreography Marius Petipa, reconstruction Yuri Burlaka) and the Carpets pas de quatre from Cesar Pugni’s ballet The Humpbacked Horse (choreography Alexander Gorsky, reconstruction Yuri Burlaka).
She participated in the Workshop of New Choreography project, dancing the part of Stork in the ballet Tamashi to music by group KODO, staged by Morihiro Iwata („Choreographers of the Bolshoi”, 2005), she also appeared in the piece Deja Vu to music by Wim Mertens, choreography by N. Dmitrievsky.
In 2011 she participated in the joint project of the Bolshoi theater and the Californian Segerstrom Center for the Arts (Remansos to music by E. Granados, Nacho Duato production; Pas de trois to music by M. Glinka, choreography G. Balanchine; Cinque to music by A. Vivaldi, staged by M. Bigonzetti)
Sign in to our website using your Facebook or Google+ account.
Why Do You Need Our Travel Expert
Contact our experts, and they will help you to plan your best trip to Russia, with attention to every detail!
Our Experts have been in the travel industry for many years, guarantee to offer first class customer service, excellent value for money and unbiased advice. They are standing by to find and build your dream holiday to one of the world's most fascinating destinations - Russia. Your personal Travel Expert will guide you through each stage of the travel process, from choosing a program that fits you best to support during your trip.
Just tell us your e-mail, and we'll take care of everything!
Your tour request has been received. Thank you ! We have sent you the confirmation message to [email]
Please make sure that you receive this message (sometimes e-mail messages may go to the spam/junk mail). If you did not get this message, it means you will not get message with the tours' selection as well. If you use a Yahoo!, Gmail, AOL or Hotmail, we recommend to add request@uvisitrussia.comto your address book.
We recommend to leave your phone number. If we will not heard back that you received the e-mail with the tours' selection, we will contact you by phone. And you will not miss the best tour for you.
Thank you ! Your request for Travel Expert assistance has been sent. We will e-mail you within 1 hour.
Sorry, some changes needed
Add your E-mail
There was a problem with your request
Missing contact person. Please correct and try again.