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 (381008,382822,382828,382829,382833,384647,384648,384652,386459,386460,386464,388268,467614,467623,469319,469328,471035,471043,472584,472592,474111,474125,474134,474139,475691,475705,475714,475719,477268,477283,477291,477297,478841,478856,478865,478870,480408,480423,480432,480437,481161,481176,481184,481190,481905,481920,481928,481934,482642,482657,482665,482671,483377,483391,483400,483405,484119,484133,484141,484147,484882,484890,484896,485625,485633,485639,486355,486363,486369,487076,487084,487090,487790,487798,487804,488502,488510,488516,489214,489222,489228,489929,489935,490629,490635,491324,491330,492015,492698,493380,494056,501155,501163,502602,502610,504085,504094,505565,505573,507033,507042,508505,508514,509975,509981,511435,511443,512887,512894,514366,514374,515836,515844,517297,517305,518748,518756,520190,520198,521633,521641,523065,523073,524490,524498,525908,525916,527315,527323,528721,528729,530124,530133,531522,531531,532912,532921,534350,534358,535781,535791,537207,537217,538635,538645,540056,540066,541476,542928,557389,558789,560186,561576,562963,564340,565707,567067,568425,568449,569779,569803,571122,571146,572528,573908,575277,576637,577993,579343,580681,582010,583340,586004,587313,588614,589920,591540,593179,594883,596580,598267,599942,601624,642153,642161,643669,643677,645182,645191,646684,646693,648188,649687,688135,688136,689434,689435,690720,690721,691996,691997,693261,693262,694518,694519,695757,695758,696983,696984,698196,698197,699398,699399,700592,700593,701779,701780,702971,702972,704152,704153,705322,705323,825408,828154,830895,833634,836367,839096,841821,844476,844481,844486,844541,847214,847219,847225,847280,849947,849951,849957,850013,852676,852681,852686,852742,855406,855411,855417,855472,858131,858135,858141,858197,860851,860855,860861,860916,863563,863567,863573,863628,866264,866268,866273,866329,868953,868958,868963,869019,871637,871642,871647,871703,874321,874325,874330,874385,877000,877005,877011,877065,879684,879689,879695,879749,882364,882369,882375,882429,885047,885052,885058,885112,887717,887721,887728,887784,890382,890387,890393,890447,893042,893047,893053,893107,895700,895705,895711,895765,898353,898360,898416,901007,901059,903695,906319,908934,911549,914186,916891,919593,919690,922279,922376,924980,925078,927670,927770,930383,930483,933088,933189,935797,935898,938611,941335,944047,946752,949460,952158,954859,957535,960195,962843,965481,968113,970753,973375,975984,978597,981193,983783,986410,989033,991655,991715,994258,994321,996921,999509,1002091,1002131,1002144,1002146,1004673,1004708,1004719,1004724,1007242,1007277,1007288,1007293,1009804,1009843,1009854,1009856,1012357,1012392,1012403,1012408,1014925,1014966,1014979,1014980,1017483,1017518,1017529,1017534,1020030,1020065,1020076,1020081,1022572,1022612,1022623,1022624,1025113,1025148,1025159,1025164,1027679,1027690,1027695,1030205,1030217,1030219,1032715,1032726,1032731,1035210,1035221,1035226,1037698,1037710,1037711,1040183,1040195,1040196,1042661,1042673,1042674,1045143,1045144,1047611,1047612,1097756,1100035,1102307,1104565,1106801,1109017,1111212,1113391,1115549,1117689,1119824,1121954,1124092,1126287,1128479,1130690,1152569,1152608,1152623,1152660,1154717,1154756,1154772,1154808,1156853,1156891,1156909,1156946,1159021,1159063,1159078,1159109,1161176,1161218,1161233,1161265,1163316,1163355,1163370,1163407,1165448,1165491,1165504,1165536,1167585,1167624,1167639,1167676,1169715,1169758,1169771,1169803,1171880,1171893,1171925,1173991,1174006,1174043,1176137,1176152,1176189,1178272,1178287,1178324,1180400,1180415,1180452,1182519,1182534,1182571,1184629,1184644,1184681,1186743,1186755,1186788,1188849,1188861,1188894,1190948,1190961,1190993,1193048,1193087,1195127,1195166,1197203,1197242,1199269,1199306,1201367,1203421,1205470,1207507,1209536,1211578,1213606,1215628,1276660,1276711,1276771,1278518,1278568,1278626,1280375,1280420,1280481,1282213,1282265,1282322,1284048,1284098,1284156,1285872,1285922,1285980,1287683,1287733,1287791,1289477,1289527,1289585,1291262,1291312,1291370,1293072,1293122,1293180,1294874,1294924,1294982,1296669,1296719,1296777,1298455,1298505,1298563,1300276,1300334,1302035,1302094,1303784,1303842,1305532,1305590,1307272,1307330,1309002,1309060,1310720,1310778,1312639,1312697,1314556,1314614,1316490,1316548,1318417,1318475,1320394,1322303,1324204,1326091,1327962,1329820,1329868,1331707,1331755,1333584,1333632,1335451,1335499,1337307,1337355,1339152,1339200,1341030,1342847,1344656,1346463,1348260,1350050,1351955,1353847,1355728,1381587,1383403,1385213,1387017,1388811,1390591,1392360,1394120,1395898,1395909,1397664,1397675,1399421,1399432,1401173,1401184,1402915,1402926,1404648,1404659,1406371,1406382,1408092,1408103,1409816,1409827,1411543,1411554,1413293,1413304,1415053,1415064,1416800,1416808,1418538,1418549,1420265,1420276,1421982,1421993,1423685,1423696,1425374,1425385,1427048,1427059,1428712,1428723,1430362,1430373,1432002,1432013,1433633,1433644,1435249,1435260,1436854,1436865,1438475,1438486,1440083,1440094,1441684,1441695,1443278,1443289,1444862,1444873,1446449,1448013,1545851,1546936,1548009,1549072,1550128,1558466,1559464,1560822,1562171,1564014,1565847,1567670,1570592,1573485,1576368,1579237,1582102,1584949,1587784,1590622,1593447,1596304,1599175,1602031,1604883,1607721,1610554,1647064,1649877,1652746,1655606,1658454,1661291,1664114,1666928,1669733,1672589,1865936,1865950,1865958,1868026,1868040,1868048,1870108,1870126,1870134,1872184,1872198,1872206,1874246,1874260,1874269,1876300,1876314,1876323,1878351,1878365,1878373,1880424,1880438,1880446,1882488,1882502,1882510,1884543,1884557,1884565,1886620,1886634,1886643,1888683,1888700,1888708,1890743,1890760,1890768,1892804,1892824,1892836,1894876,1894896,1894908,1896959,1896979,1896991,1899094,1899114,1899126,1901242,1901262,1901274,1903399,1903411,1905526,1905539,1907673,1907685,1909830,1909842,1911977,1911989,1914138,1914153,1916370,1918579,1920776,1922973,2117615,2117673,2117674,2119502,2119560,2119561,2121379,2121437,2121438,2123246,2123304,2123305,2125098,2125156,2125157,2126997,2126998,2128831,2128832,2128922,2130657,2130658,2130748,2132473,2132474,2132564,2134280,2134281,2134371,2136074,2136075,2136165,2137858,2137859,2137948,2139701,2139702,2139792,2141535,2141536,2141626,2143360,2143361,2143451,2145174,2145175,2145265,2146978,2146979,2147069,2148772,2148773,2148863,2150643,2152410,2154168,2155917,2157655,2159382,2161136,2162875,2164604,2166325,2168028,2169719,2170503,2171282,2172052,2382202,2385229,2385294,2388244,2388309,2391306,2391371,2394362,2394427,2397405,2397470,2400434,2400499,2403452,2403517,2406466,2406531,2409471,2409536,2412466,2412531,2415452,2415518,2418466,2418532,2421468,2421534,2424459,2424525,2427445,2427511,2430422,2430488,2433390,2433456,2436349,2436415,2439361,2442296,2445222,2448143,2451053,2453956,2456840,2459719,2462583,2465438,2468315,2471253,2474167,2477110,2480042,2509217,2512078,2514933,2517783,2520626,2523458,2526278,2529091,2531899,2534700,2537494,2540288,2543072,2545845,2548610,2551415,2551430,2554211,2554226,2557022,2557037,2559823,2559838,2559871,2559899,2559907,2562612,2562627,2562660,2562688,2562696,2565385,2565400,2565436,2565465,2565472,2565491,2568151,2568166,2568202,2568231,2568238,2568257,2570999,2571032,2571060,2571068,2571087,2573823,2573856,2573884,2573909,2576637,2576670,2576698,2576723,2579472,2579499,2579524,2582269,2582296,2582321,2585051,2585078,2585103,2587822,2587849,2587874,2590590,2590617,2590642,2593349,2593376,2593401,2596127,2596152,2598869,2598894,2601598,2601623,2604314,2604339,2607021,2607046,2609724,2609749,2612443,2615167,2617884,2620591,2754648,2754658,2757670,2757673,2757680,2760691,2760694,2760701,2763710,2763717,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,2907895,2910464,2910467,2910476,2910512,2913062,2913065,2913074,2913110,2915650,2915653,2915662,2915698,2918240,2918243,2918252,2918288,2920813,2920816,2920825,2920861,2923378,2923381,2923390,2923426,2925936,2925945,2925981,2928517,2931036,2933544,2936044,2938552,2941055,2943549,3096740,3096746,3098321,3098327,3099898,3099904,3101464,3101470,3139758,3139768,3141367,3141377,3142967,3142977,3144561,3144571,3146146,3146156,3150223,3150233,3151767,3151777,3153304,3153314,3154832,3154842,3156352,3156362,3157864,3157874,3159364,3159374,3160853,3160863,3162335,3162345,3163811,3163821,3165278,3165288,3166760,3166770,3168157,3168167,3168214,3168235,3169544,3169554,3169601,3169622,3170924,3170934,3170981,3171002,3172298,3172308,3172355,3172376,3173666,3173676,3173723,3173744,3175026,3175036,3175083,3175104,3176427,3176437,3176484,3176505,3177823,3177833,3177880,3177901,3179297,3179307,3179354,3179375,3180767,3180777,3180824,3180845,3182234,3182244,3182291,3182312,3183695,3183705,3183752,3183773,3185158,3185168,3185215,3185236,3186616,3186626,3186673,3186694,3188070,3188080,3188127,3188148,3189517,3189527,3189574,3189595,3190960,3190970,3191017,3191038,3192399,3192409,3192456,3192477,3194092,3194102,3194149,3194170,3195779,3195789,3195836,3195857,3197562,3197572,3197619,3197640,3199532,3199542,3199589,3199610,3201233,3201243,3201290,3201311,3202927,3202937,3202984,3203005,3204619,3204629,3204676,3204697,3206307,3206317,3206365,3206386,3207989,3207999,3208047,3208068,3209661,3209673,3209720,3209741,3211331,3211343,3211390,3211411,3213052,3213099,3213120,3214752,3214800,3214821,3216446,3216494,3216515,3218185,3218206,3219869,3219890,3221544,3221565,3223216,3223237,3224851,3224872,3226473,3226494,3228087,3228108,3229702,3229723,3231319,3231340,3232932,3232953,3234555,3236142,3267627,3269679,3271765,3273880,3275979,3278069,3280162,3282292,3284416,3286536,3288676,3290799,3292908,3295011,3297107,3299195,3301274,3339831,3339910,3339916,3342249,3342255,3344610,3344616,3346962,3346968,3349305,3349311,3351633,3351639,3353954,3353960,3356272,3356278,3358620,3358626,3360985,3360991,3363342,3363348,3365686,3365692,3368022,3368028,3370350,3370356,3372671,3372677,3374985,3374991,3377294,3377300,3379594,3379600,3413093,3415247,3417389,3419521,3421630,3423719,3425786,3427834,3429865,3431879,3433886,3435886,3437873,3439846,3441812,3443774,3443825,3445796,3447947,3450090,3452225,3454349,3456468,3458592,3460723,3462853,3465003,3467147,3469320,3471482,3473636,3475792)) 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
Mikhail Lobukhin (Leading Ballet Soloist) - uVisitRussia
Born in Leningrad (St. Petersburg). In 2002, he completed his training at the A.Y. Vaganova Academy of RussianBallet (ARB), a diploma with distinction and a bachelor ofarts degree(Boris Bregvadze`s class) and, in the same year, joined the Maryinsky Theatre Ballet Company.
Repertoire at the Maryinsky
Interpolated pas de deux (Giselle, choreography Jean Coralli, Jules Perrot, Marius Petipa) Ali, Lanquedem, Conrad (Le Corsaire, choreography Marius Petipa in a version by Pyotr Gusev) Solor (La Bayadere, choreography Marius Petipa in a version by V. Ponomaryov and Vakhtang Chabukiani) Pas de trois (Swan Lake, choreography Marius Petipa, Lev Ivanov, in a version by Konstantin Sergeyev) Variation (Raymonda, choreography Marius Petipa in a version by Konstantin Sergeyev) Basil (Don Quixote, choreography Marius Petipa, Alexander Gorsky) Vatslav (The Fountain of BakhchiseraiBoris Asafiev, choreography Ratislav Zakharov) Troubadour, Title Role (Romeo and Juliet Sergei Prokofiev, choreography Leonid Lavrovsky) Ali-Batyr (Shuraleh F. Yarullin, Choreography Leonid Jacobson) The Youth (The Leningrad Symphony to music by Dmitri Shostakovich, choreography Igor Belsky) Ferkhad (Legend of Love Arif Melikov, choreography Yuri Grigorovich) Title Role (Apollo Igor Stravinsky, choreography George Balanchine) Title Role (The Prodigal Son Sergei Prokofiev, choreography George Balanchine) Soloist Allegro vivace(Symphony in C, choreography George Balanchine) Soloist (Ballet Imperial, choreography George Balanchine) Soloist (Theme with Variations, choreography George Balanchine) Sanguinic (The Four Temperaments Paul Hindemith, choreography George Balanchine) Soloist (Steptext to music by Thom Willems, choreography William Forsythe) Soloist (There where the Golden Cherries Hang to music by Thom Willems, choreography William Forsythe) Turkish Suitor (The Magic Nut Sergei Slonimsky, choreography DonvenaPandoursky) The Spider (Le Sacre du printemps, choreography Donvena Pandoursky) Soloist (Reverence to music by Gavin Bryars, choreography David Dawson) Daphnis (Daphnis et Chloe Maurice Ravel, choreography Kirill Simonov) Monsieur Jourdain(Le Bourgeois gentilhomme to music by Richard Strauss, croreography Nikita Dmitrievsky) Soloist (The Ring tomusic by the 2H Company group, choreography Alexei Miroshnichenko) Prince (Cinderella Sergei Prokofiev, Alexei Ratmansky production) Ivan the Fool (The Humpbacked Horse Rodion Shchedrin, choreography Alexei Ratmansky) Soloist (For Four to music by Franz Schubert, choreography by Christopher Wheeldon) - under the auspices of the 8thMaryinsky International Ballet Festival Diana Vishneva: Beauty in Motion (Pierrot Lunaire to music by Arnold Schoenberg, choreograph Alexei Ratmansky; Three Point Turn to music by David Rozenblatt, choreography DwightRhoden)
Tours
With the Maryinsky Theatre Ballet Company he toured in Germany, France, Great Britain, Holland, USA, China, Japan, New Zealand. Under the auspices of the Rudolph Nureyev International Festival of Classical Ballet, he has twice danced the role of Basil in Don Quixote with the Ballet Company of the Musa Dzhalil Tartar Academic Theatre of Opera and Ballet, Kazan(Kitri - Maryinsky Theatre soloist Yekaterina Osmolkina, 2007; Yelena Yevseyeva, 2009).
Awards 2002 - lst prize at the Vaganova-prix International Ballet Competition, founded by the Vaganova ARB. 2008 - Zolotoy Sofit, the most prestigious St. Petersburg theatre prize for hisperformance in the ballet For Four produced by Christopher Wheeldon(in the Best Acting Ensemble in a Ballet nomination).
At the Bolshoi Theatre
In January 2010, he joined the Bolshoi Theatre Ballet Company. His teacher-repetiteurs are Mikhail Lavrovsky and Valery Lagunov.
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.