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 (382836,382898,382900,384655,384718,384719,386467,386530,386531,388271,388332,388333,390079,390140,390141,391879,391940,391941,393678,393739,393741,395473,395534,395536,397324,397325,399107,399109,400882,400883,402647,402648,404403,404404,406161,406162,407912,407913,409656,409657,411395,411396,413156,413157,414906,414907,416648,416649,418389,418391,420126,420128,421857,421858,421894,423586,423587,423623,425303,425309,425346,427016,427017,427053,428714,428715,428751,430407,430408,430444,432153,433858,435553,437241,438917,440581,442232,474109,474164,474165,475689,475744,475745,477266,477320,477321,478839,478895,478896,480406,480462,480463,481159,481213,481214,481903,481959,481960,482640,482696,482697,483375,483430,483431,484175,484176,484924,484925,485667,485668,486397,486398,487118,487119,487832,487833,488544,488545,489256,489257,489963,489964,490663,490664,491358,491359,492043,492044,492726,492727,493408,493409,494084,494085,494753,494754,495414,495415,496063,496064,496701,496702,498171,498172,499633,499634,501088,501089,501098,502536,502537,502547,504031,505509,506979,508451,509918,538631,538635,538645,540056,540066,541476,542928,568441,568459,569795,569813,571138,571156,572520,572539,573901,573919,575270,575288,576630,576648,577986,578005,579336,579355,580674,580693,582022,583352,584672,585985,586002,586009,586013,587294,587311,587318,587322,588595,588612,588619,588623,589890,589915,589927,589931,591535,591547,591551,593174,593186,593190,594877,594888,594895,596574,596585,596592,598258,598263,598274,598278,599936,599947,599954,601631,601635,603300,603307,604970,614959,614961,642149,643665,645178,688069,688070,688088,688104,688105,688129,689387,689403,689404,689428,690673,690689,690690,690714,691949,691965,691966,691990,693215,693231,693232,693255,694487,694488,694512,695726,695727,695751,696952,696953,696977,698190,699392,700586,701773,702965,704146,844476,847214,849947,852676,855406,858131,860851,863563,866264,868953,871637,874321,874364,877000,877044,879684,879726,882364,882406,885047,885089,887717,887759,890382,890424,893042,893084,895700,895742,898391,901038,903674,906298,908913,911524,914161,916871,919571,919654,919662,919663,919690,919715,922341,922347,922348,922376,922401,925040,925046,925048,925078,925102,927733,927741,927742,927770,927795,930446,930453,930454,930483,930508,933151,933159,933160,933189,933214,935860,935868,935869,935898,935923,938571,938579,938580,938611,938642,941293,941302,941303,941335,941365,944006,944016,944017,944047,944077,946707,946713,946714,946752,946785,949409,949415,949421,949460,949487,952116,952125,952127,952158,952189,954808,954814,954820,954859,954886,957494,957504,957505,957535,957565,960156,960165,960166,960195,960227,962804,962805,962806,962843,962877,965442,965451,965452,965481,965511,968074,968083,968084,968113,968143,970702,970708,970714,970753,970779,973324,973330,973336,973375,973402,975951,975952,975984,976013,978597,978625,981193,981224,983783,983812,986410,986439,989033,989061,991655,991682,991715,994258,994286,994321,996885,996921,999472,999509,1002054,1002091,1002131,1004640,1004673,1004708,1007209,1007242,1007277,1009767,1009804,1009843,1012357,1012392,1014925,1014966,1017483,1017518,1020030,1020065,1022572,1022612,1025113,1025148,1027679,1030205,1032715,1035210,1037698,1037778,1037807,1037808,1040183,1040263,1040292,1040293,1042661,1042740,1042770,1042771,1045211,1045240,1045241,1047672,1047700,1047702,1050122,1050152,1050153,1052556,1052587,1052588,1054989,1055016,1055024,1057415,1057442,1057450,1059834,1059861,1059869,1062235,1062265,1062266,1064636,1064663,1064671,1067023,1067056,1067058,1069394,1069424,1069425,1071762,1071791,1071792,1071897,1071899,1074161,1074194,1074196,1074292,1074300,1076548,1076575,1076583,1076681,1076687,1078924,1078951,1078959,1079057,1079063,1081318,1081319,1081422,1081425,1083668,1083669,1083774,1083778,1086006,1086008,1086112,1086116,1088331,1088332,1088436,1088439,1090664,1090672,1090770,1090776,1093099,1093101,1095412,1095418,1097665,1097712,1097718,1097756,1097762,1099937,1099994,1099995,1100035,1100044,1102209,1102265,1102266,1102307,1102316,1104523,1104524,1104565,1104574,1106760,1106762,1106801,1106811,1108977,1108978,1109017,1109027,1111171,1111174,1111212,1111222,1113348,1113352,1113391,1113399,1115549,1115557,1117689,1117698,1119824,1119833,1121954,1121963,1124092,1124101,1126287,1126296,1128479,1128486,1130690,1130699,1132895,1135085,1137290,1139490,1152569,1152595,1154717,1154741,1156853,1156878,1159021,1159048,1161176,1161204,1163316,1163342,1165448,1165476,1167585,1167611,1169715,1169743,1171864,1173978,1176124,1178259,1180387,1182506,1184616,1276680,1276771,1278538,1278626,1280357,1280388,1280481,1282198,1282234,1282322,1284033,1284068,1284156,1285857,1285892,1285980,1287668,1287703,1287791,1289462,1289497,1289585,1291247,1291282,1291370,1293057,1293092,1293180,1294894,1294982,1296689,1296777,1298475,1298563,1300246,1300334,1302003,1302094,1303754,1303842,1305502,1305590,1307330,1309060,1310778,1312697,1314614,1316548,1318475,1320394,1322303,1324204,1326091,1327962,1329820,1329871,1331707,1331758,1333584,1333635,1335451,1335502,1337307,1337358,1339152,1339203,1341033,1342850,1344659,1346466,1348263,1350053,1351958,1353850,1355731,1357602,1381548,1383364,1385172,1386976,1388770,1390550,1392319,1394079,1395857,1397623,1399380,1401132,1402874,1404607,1406330,1408051,1409775,1411502,1413252,1415012,1416759,1418497,1420224,1421941,1423644,1425333,1427007,1428671,1430321,1431961,1463124,1464570,1466002,1467424,1545868,1545873,1545876,1545882,1546953,1546958,1546961,1546967,1548026,1548031,1548034,1548040,1549089,1549094,1549097,1549103,1550149,1550150,1550153,1550163,1551197,1551198,1551201,1551211,1552236,1552237,1552240,1552250,1553277,1553278,1553281,1553291,1554312,1554313,1554316,1554326,1555343,1555353,1556371,1557381,1558389,1558475,1558518,1558520,1559473,1559516,1559518,1560831,1560874,1560876,1562180,1562223,1562225,1564023,1564066,1564068,1565856,1565899,1565901,1567681,1567729,1567730,1570602,1570649,1570650,1573495,1573541,1573542,1576377,1576420,1576422,1579247,1579292,1579293,1582111,1582154,1582156,1584958,1585001,1585003,1587794,1587839,1587840,1590631,1590674,1590676,1593456,1593499,1593501,1596313,1596356,1596358,1599184,1599227,1599229,1602041,1602087,1602089,1604892,1604935,1604937,1607732,1607777,1607778,1610565,1610610,1610611,1613390,1613434,1613435,1616209,1616254,1616255,1619057,1619059,1621849,1621850,1624623,1624625,1627392,1627394,1630155,1630156,1632900,1632901,1635697,1635698,1638525,1638527,1783723,1786255,1788760,1791254,1793730,1796187,1798637,1801090,1865936,1865950,1868026,1868040,1870108,1870126,1872184,1872198,1874246,1874260,1876300,1876314,1878351,1878365,1880424,1880438,1882488,1882502,1884543,1884557,1886620,1886634,1888683,1888700,1890743,1890760,1892804,1892824,1894876,1894896,1896959,1896979,1899094,1899114,1901242,1901262,1903399,1905526,1907673,1909830,1911977,1914138,2117742,2119629,2121506,2123373,2125225,2127066,2128900,2130726,2132542,2134349,2136143,2137928,2139770,2141604,2143429,2145243,2147047,2148841,2150621,2152388,2154146,2155895,2157633,2159360,2161114,2162853,2164582,2166303,2168006,2169697,2382249,2385276,2388291,2391353,2394409,2397452,2400481,2403499,2406513,2409518,2412513,2415500,2418514,2421516,2424507,2427493,2430470,2433438,2436358,2436372,2436397,2439304,2439318,2439343,2442239,2442253,2442278,2445165,2445179,2445204,2448100,2448125,2451010,2451035,2453913,2453938,2456797,2456822,2459701,2462565,2465420,2468297,2471235,2559871,2562660,2565436,2568202,2571032,2573856,2576670,2579472,2582269,2585051,2587822,2590590,2593349,2649817,2649949,2649954,2652396,2652528,2652533,2654963,2655095,2655100,2657515,2657647,2657652,2660049,2660181,2660186,2662564,2662696,2662701,2665065,2665197,2665202,2667684,2667689,2670147,2670152,2672598,2672603,2675029,2675034,2677441,2677446,2679833,2679838,2682209,2682214,2684576,2684581,2686938,2686943,2689293,2689298,2691637,2691642,2693965,2693970,2696303,2696310,2699386,2699393,2702456,2702463,2705532,2705539,2708579,2708586,2711622,2711629,2714660,2754651,2754665,2754763,2757673,2757687,2757783,2760694,2760708,2760804,2763710,2763724,2763820,2766723,2766819,2769803,2772776,2775741,2778730,2781711,2784799,2787885,2790955,2794013,2797088,2800150,2803205,2806179,2809135,2812069,2814991,2817974,2880904,2880907,2880916,2883676,2883679,2883688,2886434,2886437,2886446,2889168,2889171,2889180,2891891,2891894,2891903,2894594,2894597,2894606,2897283,2897286,2897295,2899980,2899983,2899992,2902671,2902674,2902683,2905255,2905258,2905267,2907847,2907850,2907859,2910464,2910467,2910476,2913062,2913065,2913074,2915650,2915653,2915662,2918240,2918243,2918252,2920813,2920816,2920825,2923378,2923381,2923390,2925936,2925945,3168304,3169691,3171071,3172445,3173813,3175173,3176574,3177970,3179444,3180914,3182381,3183842,3185305,3186763,3188217,3189664,3191107,3192546,3194239,3195926,3197709,3199679,3201380,3203074,3204766,3206455,3208137,3209815,3211485,3213194,3214890,3216584,3218275,3219959,3221622,3221634,3223294,3223306,3224929,3224941,3226551,3226563,3228165,3228177,3229782,3229794,3231385,3231399,3231411,3232998,3233012,3233024,3234600,3234614,3234626,3236187,3236201,3236213,3237762,3237776,3237788,3239331,3239345,3239357,3240894,3240908,3240920,3242492,3242506,3242518,3244078,3244092,3244104,3245654,3245668,3245680,3247245,3247259,3247271,3248822,3248836,3248848,3250390,3250404,3250416,3251954,3251968,3251980,3253565,3253577,3255561,3255573,3257576,3257588,3259589,3267588,3267600,3269640,3269652,3271723,3271737,3273838,3273852,3275937,3275951,3278027,3278041,3280114,3280129,3282244,3282259,3284368,3284383,3286505,3288645,3402227,3404410,3406582,3408755,3410906,3413035,3413097,3415189,3415251,3417331,3417393,3419463,3419525,3421572,3421634,3423661,3423723,3425790,3427838,3429869,3431883,3433890,3435890,3437877,3439850,3441816,3443778,3443827,3445749,3445798,3447949,3450092,3452227,3454351,3456470,3458594,3460726,3462856,3465006,3467150,3469323,3471485,3473636,3473639,3475792,3475795,3477945,3536909)) 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
Nina Kaptsova (Dancer) - uVisitRussia
She was born in Rostov-on-Don. She studied at the Moscow Choreographic College (today the Moscow Choreographic Academy), in the class of Sophia Golovkina. Upon graduating in 1996 she joined the Bolshoi Ballet Company. Her coach at the Bolshoi is Marina Kondratieva.
In 1992-93 she was the grant-aided student of international charitable program "New names", 94- m g. - by the laureate of this of programmy. is rewarded with sign "for the achievements in the culture" (2001).
basic of repertuar
1997 Amur ("the Don Quixote" in the editorial staff Of yu. grigorovich, then it fulfilled this party in the play in the editorial staff Of a. fadeyechev, including on the premier in 1999) Pa of d‘aks‘on ("A. Adam‘s Zhizel‘", choreography Of zh. koralli, Zh. perro, M. petip in the editorial staff Of v. vasil‘eva) fe sportiveness ("the latent beauty" P. Tschaikovsky, M. petip‘s choreography in the editorial staff Yu. grigorovicha)
1998 Muza ("Paganini" to S. Rakhmaninoff‘s music, choreography L. lavrovskogo) to dzhampe - "two" ("the bayadere" Of l. minkus, M. petip‘s choreography in the editorial staff Yu. grigorovicha) lady-in-waiting ("latent krasavitsa")
1999 Mari ("the nut cracker" Of p. Tschaikovsky, choreography Yu. grigorovicha) four swans ("swan lake" P. Tschaikovsky in the editorial staff Of v. Vasil‘yev, then in the play in the editorial staff Yu. grigorovich‘s, choreography L. ivanova) the first Pa de trua ("I. stravinskiy‘s agonic lines", choreography J. balanchin) - there was one of first executors of this ballet in the the large of teatre the lady of heart ("fantasy by Casanova‘s theme" to V. a.Motsart‘s music, choreography M. lavrovskogo) Yu. grigorovich‘s Anyuta Anyuta "to V. gavrilin‘s music, choreography V. vasil‘eva)
2000 waltz ("Polish ball" in M. glinkya‘s opera "Ivan Susanin", choreography R. zakharova) soloist ("Motsartiana" to P. Tschaikovsky‘s music, J. balanchina) printsess‘s choreography aurora ("latent krasavitsa")
2001 soloist ("post-meridian leisure of faun" to K. Debussy‘s music, choreography J. robbinsa) neapolitanskaya is bride ("swan lake" in the second editorial staff Yu. grigorovicha)
2002 Lees ("vain precaution" L. gerol‘d, F. ashton‘s choreography) - the first executor in the Bolshoi theater of the contemporary of prince ("swan ozero") Of sil‘fida ("Kh. levenshell‘s Sil‘fida", A. burnonvil‘s choreography in the editorial staff 3. m.fon Rozen)
2003 variation into the boundary Pa, the first variation in the picture of the "dreams Of raymondy" ("A. glazunov‘s Raymonda", M. petip‘s choreography in the editorial staff Yu. grigorovicha)
2004 Princess of florin ("latent krasavitsa") tarantella (to L. m.Gottshal‘k‘s music, choreography J. balanchina) the second Pa de trua ("" i. stravinskiy‘s agonic lines, choreography of J. balanchin) p de de Tschaikovsky (choreography J. balanchina) Zina ("bright stream" d. Shostakovic in the setting A. ratmanskogo) Frigiya ("Spartacus" a. khachaturyan, choreography Of yu. grigorovicha) Helen ("sleep on the summer night" to the music Of f.Mendel‘sona-Bartol‘di and To d.Ligeti in setting Of dzh.Noymayera) - the first executor in the the large of teatre
2005 Lightness ("omens" to P. Tschaikovsky‘s music, choreography L. myasina)
2006 Rita ("the Golden Age" D. Shostakovic in the setting Yu. grigorovicha) Zhizel‘ ("Zhizel‘")
Gastroli
In 2000 it participated in the gala- concert of the artists of ballet in Greece - with Andrey yevdokimov carried out Pa de de from A. Adam‘s ballet "Corsair" (M. petipa). ispolnil‘s choreography title party in the ballet "anyuta" at the international festival of the classical ballet im. R. nureyev, which is conducted in Kazan (2002). in 2003 participated in the festival of the artists of the Bolshoi theater, Danish royal ballet and American ballet theater, that passed on the scene of Kennedy- center in Washington. It danced the "vision of rose" to the music k. m. von veber (choreography Of m. Fokin, the partner of gennadi yanin). vystupil also in the gala- concert, which was being taken place within the framework of the project of the "stars OF THE XXI century" in Toronto (partner of Dmitriy gudanov). ispolnil title party in the ballet of Anatoliy yemel‘yanov "Romeos and Juliette" to the music Of p. Tschaikovsky (partner Aleksandr volchkov) within the framework of the tours of theater "crown of Russian ballet" in Mexico (2003).
It participated in the project of the Bolshoi theater "workshop of new choreography" (200yag.), after coming out in the ballet "Hungarian dances" to the music Of i.Bramsa (choreography Of a.Miroshnichenko).
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.