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 (20014,21449,21501,22955,24407,25891,26203,27609,30352,31834,33433,34906,39558,42417,42434,43801,43818,45158,45175,46507,46524,47850,47867,49204,50536,51860,53177,54490,55797,57164,87817,89789,91753,93709,95660,97605,99540,101465,103380,105285,107182,109076,110958,112831,114697,116553,118426,120299,122169,124031,125886,127731,129567,131396,133225,135054,136877,138697,140510,142314,144110,145895,147670,149438,151194,152940,154679,156406,158122,159827,161550,163271,165018,166754,168484,170199,171908,173609,183810,185448,187076,188694,190301,191896,193480,195065,195447,195829,196211,201839,203517,205189,206893,208587,210245,211809,213342,214880,216413,217944,219469,220990,222507,224019,225527,227035,228538,230035,232019,234013,236001,251724,251725,251741,253704,253705,253721,255676,255677,255693,257641,257642,257657,259612,259613,259628,261577,261578,261593,263534,263535,263551,265498,265499,265515,267454,267455,267471,269401,269402,269418,271341,271343,271358,273280,273281,273296,275209,275210,275226,277139,277140,277156,279064,279065,279079,280952,282817,284675,286531,288381,290224,303534,303546,303550,303551,305465,305477,305481,305482,307395,307407,307411,307412,309318,309330,309334,309335,311236,311248,311252,311253,313150,313162,313166,313167,315057,315070,315074,315075,316960,316972,316976,316977,318854,318866,318870,318871,320738,320750,320754,320755,322614,322626,322630,322631,324483,324495,324499,324500,326387,326399,326403,326404,328291,328303,328307,328308,330187,330199,330203,330204,332078,332090,332094,332095,333959,333971,333975,333976,335830,335842,335846,335847,337695,337707,337711,337712,339575,339587,339591,339592,341503,341515,341519,341520,343427,343436,343440,343441,345347,345356,345360,345361,347265,347275,347279,347280,349166,349180,349183,349184,351053,351066,351070,351071,352931,352944,352948,352949,354807,354820,354824,354825,356686,356700,356704,356705,358561,358571,358575,358576,358594,358596,358597,360464,360474,360478,360479,360497,360499,360500,360548,362361,362371,362375,362376,362394,362396,362397,362445,364262,364266,364267,364282,364284,364286,364333,366142,366146,366147,366162,366165,366166,366214,368019,368023,368024,368042,368043,368045,368087,368091,369897,369901,369902,369917,369919,369921,369963,369968,371764,371769,371770,371784,371787,371788,371831,371836,373629,373630,373645,373648,373649,373691,373696,375495,375498,375499,375541,375546,377335,377338,377339,377382,377387,379169,379172,379173,379216,379221,381000,381003,381004,381047,381052,382825,382828,382829,382872,382877,384644,384647,384648,384690,384696,386459,386460,386503,386508,388307,388312,390115,390120,391915,391920,393714,393719,395509,395514,397298,397303,399080,399085,400854,400859,402619,402623,404380,404383,406133,406137,407884,407888,409628,409632,411369,411372,413131,413134,414882,414885,416624,416627,418365,418368,420104,421883,421917,423607,423646,425330,425368,427037,427076,428734,428774,430433,430467,432135,432174,433844,433878,435539,435573,437227,437260,438936,440600,442252,443890,445517,447139,448748,450345,451936,453526,501109,501159,501167,502559,502606,502614,504043,504089,504097,505518,505569,505577,506990,507037,507045,508462,508509,508517,509929,509976,509984,511389,511439,511447,512843,512891,512899,514320,514370,514378,515840,515848,517301,517309,518752,518760,520195,520203,520206,521637,521645,521647,523070,523078,523081,524495,524503,524506,525912,525920,525922,527319,527327,527329,528725,528733,528735,530128,530137,530139,531526,531535,531537,532916,532925,532927,534354,534363,534367,535785,535795,535797,537212,537221,537223,538640,538649,538652,540061,540069,540073,541473,541481,541485,541504,542932,542934,542953,544409,544411,544432,545879,545898,547333,547352,548807,550256,551697,553130,554551,555963,557369,558769,560166,568444,568459,569798,569813,571141,571156,572523,572539,573903,573919,575272,575288,576632,576648,577989,578005,579339,579355,580677,580693,582006,582022,583352,584672,585985,586004,586009,587294,587313,587318,588595,588614,588619,589890,589920,589927,591540,591547,593179,593186,594883,594888,596580,596585,598267,598274,599942,599947,601624,601631,603300,642187,642188,643704,643705,645214,645215,646719,646721,648214,648216,649713,649715,651201,651203,652682,652684,654154,654156,655615,655617,657066,657068,658521,658523,688129,688135,688136,689428,689434,689435,690714,690720,690721,691990,691996,691997,693255,693261,693262,694512,694518,694519,695751,695757,695758,696977,696983,696984,698190,698196,698197,699392,699398,699399,700586,700592,700593,701773,701779,701780,702965,702971,702972,704146,704152,704153,705322,705323,844476,847214,849947,852676,855406,858131,860851,863563,866264,868953,871637,874321,877000,879684,882364,885047,887717,890382,893042,895700,919654,919662,919663,919669,919684,919697,919715,922341,922347,922348,922354,922370,922383,922401,925040,925046,925048,925053,925071,925083,925102,927733,927741,927742,927748,927763,927776,927795,930446,930453,930454,930461,930476,930489,930508,933151,933159,933160,933167,933181,933194,933214,935860,935868,935869,935875,935890,935903,935923,938571,938579,938580,938589,938605,938621,938642,941293,941302,941303,941312,941329,941345,941365,944006,944016,944017,944026,944041,944056,944077,946707,946713,946714,946723,946744,946760,946785,949409,949415,949421,949431,949451,949467,949487,952116,952125,952127,952136,952152,952167,952189,954808,954814,954820,954830,954850,954866,954886,957494,957504,957505,957514,957528,957543,957565,960156,960165,960166,960174,960189,960204,960227,962804,962805,962806,962815,962836,962851,962877,965442,965451,965452,965459,965474,965489,965511,968074,968083,968084,968091,968106,968121,968143,970702,970708,970714,970724,970744,970760,970779,973324,973330,973336,973346,973366,973382,973402,975951,975952,975960,975976,975991,976013,978573,978590,978605,978625,981188,981203,981224,983778,983793,983812,986404,986419,986439,989026,989041,989061,991646,991662,991682,994266,994286,996866,996885,999472,1002054,1002124,1002137,1002144,1002146,1004640,1004702,1004713,1004719,1004724,1007209,1007271,1007282,1007288,1007293,1009767,1009836,1009848,1009854,1009856,1012386,1012397,1012403,1012408,1014960,1014971,1014979,1014980,1017512,1017523,1017529,1017534,1020059,1020070,1020076,1020081,1022605,1022616,1022623,1022624,1025142,1025153,1025159,1025164,1027673,1027684,1027690,1027695,1030198,1030210,1030217,1030219,1032709,1032720,1032726,1032731,1035204,1035215,1035221,1035226,1037692,1037704,1037710,1037711,1040177,1040189,1040195,1040196,1042667,1042673,1042674,1045138,1045143,1045144,1047611,1047612,1152569,1154717,1156853,1159021,1161176,1163316,1165448,1167585,1169715,1227640,1229654,1231665,1233660,1235647,1237628,1239596,1241552,1243535,1245510,1247473,1276653,1276771,1278512,1278626,1280365,1280481,1282206,1282322,1284042,1284156,1285866,1285980,1287677,1287791,1289471,1289585,1291256,1291370,1293066,1293180,1294868,1294982,1296663,1296777,1298563,1300334,1302094,1303842,1305590,1307330,1309060,1310778,1312697,1314614,1316548,1318475,1320394,1322303,1324204,1326091,1327962,1329820,1329875,1331707,1331762,1333584,1333639,1335451,1335506,1337307,1337362,1339152,1339207,1341037,1342854,1344663,1346470,1348267,1350057,1351962,1353854,1355735,1357606,1359467,1381474,1381548,1381562,1381563,1381585,1381592,1383290,1383364,1383378,1383379,1383401,1383408,1385097,1385172,1385187,1385188,1385211,1385219,1386901,1386976,1386991,1386992,1387015,1387023,1388695,1388770,1388785,1388786,1388809,1388817,1390475,1390550,1390565,1390566,1390589,1390597,1392244,1392319,1392334,1392335,1392358,1392366,1394004,1394079,1394094,1394095,1394118,1394126,1395782,1395857,1395872,1395873,1395896,1395904,1395916,1397548,1397623,1397638,1397639,1397662,1397670,1397682,1399305,1399380,1399395,1399396,1399419,1399427,1399439,1401057,1401132,1401147,1401148,1401171,1401179,1401191,1402799,1402874,1402889,1402890,1402913,1402921,1402933,1404532,1404607,1404622,1404623,1404646,1404654,1404666,1406255,1406330,1406345,1406346,1406369,1406377,1406389,1407976,1408051,1408066,1408067,1408090,1408098,1408110,1409775,1409790,1409791,1409814,1409822,1409834,1411502,1411517,1411518,1411541,1411549,1411561,1413252,1413267,1413268,1413291,1413299,1413311,1415012,1415027,1415028,1415051,1415059,1415071,1416759,1416777,1416778,1416793,1416803,1416815,1418497,1418512,1418513,1418536,1418544,1418556,1420224,1420239,1420240,1420263,1420271,1420283,1421941,1421956,1421957,1421980,1421988,1422000,1423644,1423659,1423660,1423683,1423691,1423703,1425333,1425348,1425349,1425372,1425380,1425392,1427007,1427022,1427023,1427046,1427054,1427066,1428671,1428686,1428687,1428710,1428718,1428730,1430321,1430336,1430337,1430360,1430368,1430380,1431961,1431976,1431977,1432000,1432008,1432020,1433607,1433608,1433631,1433639,1433651,1435223,1435224,1435247,1435255,1435267,1436828,1436829,1436852,1436860,1436872,1438473,1438481,1438493,1440081,1440089,1440101,1441682,1441690,1441702,1443276,1443284,1443296,1444868,1444880,1446444,1446456,1448020,1449572,1463113,1463124,1464559,1464570,1466002,1467424,1545851,1545887,1546936,1546972,1548009,1548045,1549072,1549108,1550128,1550167,1551215,1552254,1553295,1554330,1555357,1556375,1557385,1558393,1559391,1783669,1838083,1840263,1842422,1844566,1846707,1848861,1851010,1853152,1855288,1857421,1859542,1861659,1861677,1863772,1863792,1865882,1865900,1865940,1865943,1867990,1868030,1868033,1870074,1870113,1870118,1872148,1872188,1872191,1874209,1874249,1874251,1876263,1876303,1876305,1878315,1878355,1878358,1880428,1880431,1882492,1882495,1884547,1884550,1886622,1886626,1888687,1888692,1890747,1890752,1892810,1892815,1894882,1894887,1896965,1896970,1899100,1899105,1901248,1901253,1903385,1903390,1905514,1905517,1907663,1909820,2117615,2117709,2117725,2119502,2119596,2119612,2121379,2121473,2121489,2123246,2123340,2123356,2125098,2125192,2125208,2127033,2127049,2128867,2128883,2128922,2130693,2130709,2130748,2132509,2132525,2132564,2134316,2134332,2134371,2136110,2136126,2136165,2137893,2137906,2137948,2139737,2139753,2139792,2141571,2141587,2141626,2143396,2143412,2143451,2145210,2145226,2145265,2147014,2147030,2147069,2148808,2148824,2148863,2150588,2150604,2150643,2152355,2152371,2152410,2154113,2154129,2154168,2155862,2155878,2155917,2157600,2157616,2157655,2159327,2159343,2159382,2161097,2161136,2162836,2162875,2164604,2166325,2168028,2169719,2170503,2171282,2172052,2323369,2323404,2326507,2326542,2329637,2329672,2332748,2332783,2335850,2335885,2338946,2338981,2342042,2342077,2345149,2345184,2348248,2348283,2351344,2351379,2354463,2354498,2357570,2357605,2360671,2360706,2363766,2363801,2366851,2366886,2369925,2369960,2372990,2373025,2376040,2376075,2379113,2382145,2382188,2385172,2385215,2388187,2388230,2391249,2391292,2394305,2394348,2397348,2397391,2400377,2400420,2403395,2403438,2406409,2406452,2409457,2412452,2415438,2418452,2421454,2424445,2427431,2436363,2439309,2442244,2445170,2448091,2451058,2453961,2456845,2459724,2462588,2465443,2468320,2471258,2474172,2477115,2480047,2482965,2485873,2509217,2512078,2514933,2517783,2520626,2523458,2526278,2529091,2531899,2534700,2537494,2540288,2543072,2545845,2548610,2551415,2554211,2557022,2559823,2559897,2562612,2562686,2562724,2565385,2565461,2565497,2568151,2568227,2568263,2571058,2571096,2573882,2573918,2576696,2576732,2579497,2579533,2582294,2582330,2585076,2585112,2587847,2587883,2590615,2590651,2593374,2593410,2596125,2596161,2598867,2598903,2601596,2601632,2604312,2604348,2607019,2607055,2609758,2612452,2615176,2617893,2620600,2623292,2625974,2754651,2754678,2757673,2757700,2760694,2760721,2763710,2763737,2766736,2769720,2772693,2775658,2815039,2815048,2818022,2818031,2820998,2821007,2823970,2823979,2826946,2826955,2829905,2829914,2832847,2832856,2835774,2835783,2838708,2838717,2841632,2841641,2907904,2910521,2913119,2915707,2918297,2920870,2923435,2925990,2928526,2931045,2933553,2936053,2938561,2941064,2943558,2946036)) 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
Ruslan Skvortsov (Dancer) - uVisitRussia
Born in Yelets, Lipetsk region. In 1998, after completing his studies at the
Moscow Choreographic Academy (Vyacheslav Mikhaylov's class) joined the
Bolshoi Ballet Company. In 2000, he won the 3rd
prize at the International Ballet Competition in
Moscow. His constant coach is Nikolai Fadeyechev.
Main Repertory
1998 Grand Pas (La Bayadere. Yuri
Grigorovich production)
1999 Friend to
Ferkhad (A Legend of Love. Music by Arif Melikov. Yuri
Grigorovich production) Wilfreed (Giselle. Vladimir
Vasiliev production) Beranger (Raimonda. Yuri
Grigorovich production) Friend to Prince Siegfried (Swan
Lake. Vladimir Vasiliev production) Officer/Two Officers
(Anyuta to music by Valery Gavrilin. Vladimir Vasiliev
production) Soloist Part 4 (Symphony in
C)
2000 Little Count Cherry
(Cipollino. Music by Karen Khachaturyan. Genrikh Mayorov
production) Prince Fortune (The Sleeping
Beauty.Yuri Grigorovich production) 2001 Soloist (Chopiniana) part in
Passacaille to music by Anton von Webern (Rolan Petit
creation at Bolshoi Theatre)
2002 Ferkhad (A Legend of
Love) Prince Siegfried (Swan Lake. Yuri Grigorovich new production)
2003 Ballet Dancer (The Bright Stream.
Music by Dmitry Shostakovich. Alexei Ratmansky
production) Bernard
(Raimonda) Claude Frollo (Notre-Dame de
Paris. Rolan Petit production) Lord Wilson/Taor, A
Fisherman (La Fille du Pharaon. Pierre Lacotte
production after Marius Petipa) Count
Albrecht (Giselle. Vladimir Vasiliev production; then
Yuri Grigorovich production)
2004 Pas de
deux (Agon) Leading Soloist
(Magrittomania. Music by Yuri Krasavin. Yuri Possokhov
production) Soloist Part 3 (Symphony in
C) Jean de Brienne (Raimonda) -
debut on Bolhsoi Theatre's tour in USA
2005 Demetrius (A Midnight's Summer Dream.
John Neumeier production) Miller (Le Tricorne.
Music by Manuel de Falla. Choreography by Leonide
Massine) Hero (Les Presages to music by Pyotr
Tchaikovsky. Choreography by Leonide Massine)
2006 Boris (The Golden Age.
Music by Dmitry Shostakovich. Yuri Grigorovich production)
2007 Soloist (Misericordes to
music by Arvo Part. Christopher Wheeldon creation)
Soloist in Dance with Fans (Le Corsaire Adolphe
Adam; choreography Marius Petipa, production and new choreography by Alexei
Ratmansky and Yuri Burlaka) Class Concert (to
music by different composers; choreography by Asaf Messerer)
2008 James (Herman Levenskiold's La
Sylphide; choreography by August Bournonville in a version by Johan Kobborg)
Antoine Mistral (Boris Asfiev's The Flames of
Paris. Production and new choreography by Alexei Ratmansky after Vasily
Vainonen) - creator of the role Lucien d'Hervilly
(Paquita. Staging and new choreographic version by Yuri
Burlaka) - creation
2009 Frantz (Coppelia.Choreography by Marius Petipa and Enrico
Cecchetti; revival and new choreographic version by Sergei Vikharev) -
creation at the Bolshoi Theatre Conrad
(Le Corsaire. Production and new choreography by Alexei
Ratmansky and Yuri Burlaka after Marius Petipa) - debut on the
Bolshoi Theatre tour in Washington Solor (La Bayadere. Yuri
Grigorovich production) Phoebus (Esmeralda by
Cesare Pugni, choreography by Marius Petipa, staging and new choreographic
version by Yuri Burlaka and Vasily Medvedev) -
creation
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.