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
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Dmitry Pykhachov (Dancer)

Dmitry Pykhachov (Dancer)

• 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.