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 (8399,8401,8458,10108,10162,11691,11745,13274,13328,14680,14693,14709,14742,14762,16131,16146,16161,16196,16214,17741,17756,17771,17806,17824,19163,19172,19199,19216,20643,22126,23580,25044,26803,27723,29135,30992,32506,32524,34048,34095,34105,34133,35529,35573,35588,37116,37130,37139,38664,38677,38687,40139,105615,105638,105683,105700,107509,107532,107577,107594,109395,109419,109464,109480,111272,111296,111341,111357,113165,113210,113226,115026,115070,115086,116902,116946,116962,118781,118822,118837,120651,120692,120706,122517,122558,122572,124416,124435,126265,126284,128105,128124,129933,129953,131762,131782,133595,133615,135420,135439,137241,137260,139059,139078,140869,140887,142670,142687,144477,146257,148028,153402,153458,155133,155189,156854,156911,158565,158622,160291,160348,162022,162075,163749,163819,165490,165560,167221,167291,168942,169012,170654,170724,172358,172428,174057,174122,175740,175806,177414,177479,179077,179142,180731,180796,182378,182443,184018,184083,185649,185714,187271,187336,188883,188948,190483,190548,192072,192137,193715,196474,197785,199102,200419,202101,203773,205446,207144,208832,210497,221383,221411,221422,221440,221444,221449,222897,222925,222936,222954,222958,222963,224406,224434,224445,224462,224467,224472,225912,225939,225950,225969,225974,225980,227417,227444,227455,227475,227479,227486,228916,228943,228954,228973,228978,228985,230901,230928,230939,230958,230963,230970,232896,232923,232934,232953,232958,232965,234886,234913,234924,234943,234948,234955,236871,236898,236909,236928,236933,236939,238846,238872,238883,238902,238907,238914,240813,240838,240849,240866,240873,240880,242774,242799,242810,242827,242834,242841,244731,244759,244767,244784,244791,244798,246686,246713,246721,246738,246745,246752,248633,248660,248668,248685,248692,248699,250577,250603,250612,250629,250635,250641,252561,252587,252595,252612,252618,252626,254534,254560,254569,254586,254592,254598,256499,256524,256532,256550,256556,256562,258460,258485,258494,258511,258517,258524,260426,260451,260460,260477,260483,260489,262386,262411,262420,262437,262443,262449,264377,264387,264404,264410,264417,266337,266347,266364,266370,266377,268289,268298,268316,268322,268329,270230,270239,270257,270263,270270,272169,272178,272196,272202,272209,274102,274111,274129,274135,274142,276045,276062,276069,276076,277972,277992,277998,278004,278016,279868,279874,279880,279893,281736,281742,281748,281762,283595,283601,283607,283620,285452,285458,285464,285477,287312,287319,287332,289161,289181,289264,291013,291100,292909,292996,294798,294884,296765,298642,300513,302400,304283,306209,308133,310051,311966,313875,315780,317678,319568,321447,323317,325212,327113,329011,330901,342347,342364,342368,344273,344288,344292,346189,346204,346208,348092,348111,348115,349982,350001,350005,351865,351879,351882,353738,353757,353761,355615,355629,355632,357488,357506,357509,359395,359413,359416,361294,361312,361315,363188,363203,363208,365068,365086,365089,366950,366965,366969,368826,368843,368846,370700,370713,370717,372561,372577,372581,374415,374432,374436,376264,376277,376281,378095,378112,378116,379928,379945,379949,381756,381772,381776,383579,383595,383599,385396,385411,385412,387203,387218,387222,389012,389030,389034,390816,390829,390833,392616,392629,392633,394410,394425,394430,396198,396215,396219,397983,398000,398004,399763,399777,399781,401547,401551,403305,403309,405062,405067,406814,406819,408566,477985,479554,481118,481863,482601,483336,484080,484831,485576,486314,487038,487753,488462,489176,489885,490587,491284,497458,498921,500377,501831,503321,504802,506274,507745,509215,510679,512135,513582,515055,516517,517972,519416,520858,522294,523724,525142,526551,527955,529358,530758,532153,533539,534972,536397,537827,539251,539347,539357,539371,539374,539388,540763,540773,540785,540797,540804,542195,542205,542217,542225,542236,543642,543652,543666,543669,543678,545112,545121,545136,545139,545149,546564,546575,546589,546593,546603,548020,548031,548045,548048,548059,549471,549481,549496,549499,549509,550914,550924,550938,550942,550952,552350,552360,552374,552378,552387,553774,553784,553796,553803,553815,555190,555200,555212,555219,555231,556597,556607,556618,556625,556638,558000,558010,558020,558033,558040,559397,559407,559417,559429,559437,560790,560800,560810,560822,560829,562176,562186,562196,562204,562216,563557,563568,563578,563585,563597,564927,564938,564948,564961,564967,566289,566301,566308,566323,566329,567651,567660,567673,567680,567686,569013,569021,569036,569041,570363,570369,570384,570388,571715,571718,571730,573088,573098,573104,574471,574476,575837,577195,583944,584043,585258,585357,586565,586665,587871,587972,589167,589268,590807,590909,592426,592526,594054,594155,595753,595855,597545,599226,600898,602574,604242,605900,607549,609188,610875,612555,614228,615892,615975,616060,616086,617541,617624,617709,617735,619175,619259,619347,619370,620807,620890,620975,621000,622429,622513,622601,622624,624043,624127,624215,624238,625668,625752,625840,625863,627286,627369,627453,627479,628891,628974,629058,629084,630487,630570,630654,630680,632076,632159,632243,632269,633741,633826,633852,635315,635400,635425,636877,636961,636985,638429,638514,638538,639969,640053,640077,641499,641583,641607,643019,643107,643130,644532,644618,644643,646037,646124,646149,647538,647625,647648,649025,649110,649133,650520,650608,650631,652004,652086,652114,653480,653563,653590,654946,655028,655056,656402,656485,656511,657936,657964,659383,659412,660820,660849,662248,662274,663672,663693,665081,665108,666491,666516,667926,667951,669350,669375,670785,670810,672208,672238,673632,673657,675037,675062,676432,676457,677818,677843,679225,679249,680618,680642,682030,683401,684768,686113,694019,695267,696500,697719,698926,700123,701311,702507,703692,704867,706024,707169,708301,709423,710567,711708,712846,713974,715090,716193,717283,718367,859662,862379,865086,867781,870464,873147,875830,878517,921186,921198,921203,921231,923865,923873,923879,923911,926558,926568,926573,926606,929273,929281,929287,929318,931982,931997,932024,934689,934701,934731,937394,937406,937436,940125,940140,940167,942843,942858,942885,945547,945563,945590,948249,948265,948292,950955,950971,950998,953655,953671,953698,956345,956361,956388,959022,959037,959064,961677,961691,961719,964317,964331,964359,966953,966967,967000,969585,969599,969632,972213,972226,972260,974834,974846,974880,977445,977459,977492,980053,980066,980099,982645,982657,982690,985230,985246,985272,987854,987870,987896,990489,990515,993099,993132,995709,995736,995791,995792,995873,998302,998331,998386,998387,998468,1000915,1000970,1000971,1001052,1003496,1003551,1003552,1003633,1006076,1006124,1006125,1006205,1008643,1008691,1008692,1008772,1011202,1011250,1011251,1011331,1013782,1013830,1013831,1013911,1016344,1016395,1016396,1016476,1018942,1018943,1019025,1021489,1021490,1021572,1024034,1024035,1024117,1026568,1026570,1026652,1029098,1029099,1029182,1031624,1031625,1031706,1034126,1034127,1034209,1036616,1036617,1036699,1039108,1039110,1039188,1041592,1041594,1041676,1044068,1044070,1044152,1046535,1046537,1046619,1048991,1048993,1049076,1051520,1053950,1056377,1058799,1061208,1063609,1066003,1068384,1070754,1073154,1075546,1077929,1080300,1082659,1085004,1087332,1089652,1091982,1553926,1554960,1555977,1556994,1558000,1559007,1559999,1561352,1563043,1564885,1566710,1569348,1572244,1575131,1578008,1580876,1583729,1586569,1589405,1592234,1595055,1597929,1600795,1603649,1606491,1609328,1612159,1614980,1617792,1620593,1623376,1971118,3222754,3222759,3224417,3224424,3226046,3226052,3227662,3227669,3229279,3229286,3230903,3230910,3232518,3232526,3234127,3234133,3235728,3235733,3237311,3237317,3238882,3238886,3240449,3240454,3242050,3242058,3243645,3243650,3245226,3245234,3246830,3246834,3248416,3248421,3249984,3249992,3251550,3251555,3253109,3253117,3254708,3254716,3256720,3256725,3258732,3258736,3260728,3260735,3262710,3262717,3264690,3264697,3266673,3268658,3268768,3270815,3272943,3275052,3277145,3279236,3281369,3283498,3285622,3287767,3289904,3292017,3294125,3296222,3298316,3300403,3302475,3304539,3306590,3308636,3310678,3312711,3314728,3316739,3318739,3320730,3322715,3324862,3327133,3329519,3331898,3334266,3378787,3381083,3383355,3385641,3387910,3390168,3392416,3394658,3396880,3399092,3401293,3403483,3403521,3405664,3405702,3407833,3407865,3410035,3412179,3414342,3416494,3418635,3420757,3492192,3494317,3496433,3498587,3500730,3502864,3504996,3507119,3509242,3511356,3513464,3515558,3534214,3536255,3538283,3540304,3542376,3544432,3546472,3548509,3550542,3550627,3552584,3552672,3554616,3554703,3556657,3556742,3558768,3560780,3562786,3564788,3566801,3568815,3570795,3570834,3572805,3572844,3574817,3574853,3576724,3576763,3578629,3578669,3580527,3580568,3582423,3582450,3584315,3586168,3588026,3589873,3591723,3593572,3595521,3597512,3599490,3807850,3808226,3808599,3808968,3809336,3809702,3810064,3810423,3810774,3810798,3811165,3811189,3811572,3811954,3812332,3812707,3813076,3816970,3817318,3817667,3818053,3818452,3818854,3836710,3836973,3837227,3837483,3837737,3837991,3838004,3838261,3838514,3838765,3839018,3839269,3850712,3850934,3851151,3851365,3851576,3851784,3851990,3852194,3852393,3852396,3852491,3852513,3852986,3852988,3853083,3853104,3853578,3853579,3853676,3853694,3854165,3854167,3854263,3854285,3854753,3854846,3854868,3855431,3855451,3856014,3856033,3856592,3856612,3857168,3857188,3857786,3857806,3858403,3858427,3859203,3859228,3860003,3860029,3860805,3860824,3861599,3861624,3862393,3862413,3863183,3863203,3863969,3863991,3864751,3864774,3865531,3865555,3866309,3866332,3867085,3867106,3867855,3867880,3868626,3868651,3869395,3869416,3870160,3870185,3870923,3870948,3871685,3871706,3872456,3873172,3873192,3873928,3873947,3874679,3874704,3875431,3875450,3876178,3876202,3876924,3876948,3877669,3877688,3878411,3878435,3879154,3879173,3879891,3879916,3880632,3880657,3881380,3881399,3882122,3882146,3882865,3882884,3883606,3883625,3884345,3884369,3885080,3885104,3885821,3885840,3886556,3886575,3887287,3887311,3888021,3888046,3888751,3888775,3889482,3889503,3890207,3890232,3890931,3890954,3891675,3892392,3893108,3893819,3893834,3894537,3894554,3895257,3895272,3895970,3895986,3896696,3897404,3898107,3898811,3899511,3900207,3900929,3907308,3907997,3908683,3909366,3910048,3910737,3923727,3924401,3925070,3925734,3926399,3927062,3927721,3928377,3929032,3929686,3932298,3932937,3933583,3934225,3934860,3935496,3936128,3963662,3964234,3964806,3983351,3983923,3984494,3994310,3994833,3995349,3995869,3998422,3998928,3999430,3999929,4000423,4000921,4001415,4001906,4066014,4066833,4067648,4068461,4069268,4125943,4126631,4127314,4127995,4128669,4129348,4130020,4130689,4131350,4250753,4279226,4279351,4279474,4279595,4279754,4279909)) 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
Dmitry Pykhachov (Dancer) - uVisitRussia
• Prize-winner at the Vaganova-prix competition (St Petersburg, 1995)
Born in Leningrad. Graduated from the Vaganova Academy of Russian Ballet in 1995 (class of Professor Gennady Selyutsky). Joined the Mariinsky Ballet in 1995.
Repertoire at the Mariinsky Theatre includes: La Sylphide (James, Gurn, Youths); choreography by August Bournonville, revised version by Elsa-Marianne von Rosen, Giselle (Hans, the Duke, Classical Duet, Armour-Bearer); choreography by Jean Coralli, Jules Perrot and Marius Petipa, La Bayadиre (Toloragva, Dugmanta, Grand pas); choreography by Marius Petipa, revised version by Vladimir Ponomarev and Vakhtang Chabukiani, Swan Lake (Friends of the Prince, Spanish Dance, Mazurka, Neapolitan Dance); choreography by Marius Petipa and Lev Ivanov, revised version by Konstantin Sergeyev, Raymonda (Abderakhman, Mazurka, Bйranger, Grand pas); choreography by Marius Petipa, revised version by Konstantin Sergeyev, The Sleeping Beauty (Aurora’s Suitors, the Bluebird); choreography by Marius Petipa, revised version by Konstantin Sergeyev, The Sleeping Beauty (Prince Fleur de Pois, Prince Chйri); choreography by Marius Petipa, reconstruction of the 1890 production by Sergei Vikharev, Don Quixote (Gamache); choreography by Alexander Gorsky after Marius Petipa, Michel Fokine’s ballets Schйhйrazade (Shahriar, Shakhezman), Le Carnaval (Florestan, Eusybius) and Pйtrouchka(Coachman, Drunken Workman); production by Gary Chryst, Le Sacre du printemps (youth); choreography by Millicent Hodson after motifs of the choreography by Vaslav Nijinsky, George Balanchine’s ballets Prodigal Son (Friends of the Prodigal), Symphony in C (II. Adagio; III. Allegro vivace), Jewels (Emeralds, Diamonds), A Midsummer Night’s Dream (Bottom), La Valse, The Four Temperaments (Theme) and Theme and Variations, The Fountain of Bakhchisarai (Cracovienne, Prince Adam, Vaslav, Youths); choreography by Rostislav Zakharov, The Nutcracker (Elegant Cavaliers); choreography by Vasily Vainonen, Romeo and Juliet (Capulets, Tybalt, Troubadour); choreography by Leonid Lavrovsky, Leonid Yakobson’s ballets Shurale (Matchmakers), Spartacus (Arcill) and The Bedbug (Boxer), Carmen-Suite (Corregidor); choreography by Alberto Alonso, Manon (Chief Warder, Governor, Young Gentlemen); choreography by Kenneth MacMillan, Йtudes; choreography by Harald Lander, The Legend of Love (Vizier, Friends of Ferkhad); choreography by Yuri Grigorovich, Le Corsaire (Birbanto); production by Pyotr Gusev after the composition and choreography by Marius Petipa, Alexei Ratmansky’s ballets Cinderella (Summer), Anna Karenina (Alexei Karenin, Steve Oblonsky) and The Little Humpbacked Horse (Gentleman of the Bedchamber, the Tsar), Approximate Sonata; choreography by William Forsythe, The Nutcracker (Mr Stahlbaum, the Rat Emperor); production by Mihail Chemiakin, choreography by Kirill Simonov, Princess Pirlipat, or Worthiness Punished (Polish Suitors); production by Mihail Chemiakin, choreography by Kirill Simonov, The Magic Nut (Turkish Suitor); production by Mihail Chemiakin, choreography by Donvena Pandoursky and The Golden Age (Heinrich); choreography by Noah D. Gelber.
Repertoire also includes: Romance; choreography by Dmitry Bryantsev, Dolce, con fuoco; choreography by Svetlana Anufrievaand Sounds of Empty Pages; choreography by John Neumeier.
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.