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 (14746,16198,17809,19201,20645,22128,23582,25047,26808,27734,29143,30995,32508,35591,37109,37132,37181,37184,38661,38683,38733,38739,40182,40185,41621,41679,43016,43070,43104,44374,44433,44463,45726,45785,45815,47071,47129,47160,48413,48467,48501,49744,49803,49833,51072,51131,51161,52391,52450,52479,53706,53765,53794,55015,55074,55103,56318,56375,56406,57737,57771,59807,59840,61870,61903,63925,63958,65972,66005,68017,68050,70059,70092,72096,72129,74126,74159,76144,76177,78154,78187,80160,80193,82159,82192,84185,86170,88148,90115,92073,94026,95975,105645,105693,107539,107587,109425,109474,111302,111351,113170,113220,115031,115081,116907,116957,118782,118835,120657,120704,122522,122571,124380,124429,126278,128118,129947,131776,133609,135434,137255,139072,140882,142683,144473,146253,148024,153458,155189,156911,158622,160348,162075,163819,165560,167291,169012,170724,172428,174122,175806,177479,179142,180796,182443,184083,185714,187336,188948,190548,192137,193715,196474,197785,199102,200419,202101,203773,205446,207144,208832,210497,221428,222942,224450,225955,227460,228959,230944,232938,234928,236912,238886,240852,242813,244770,246724,248671,250615,252598,254572,256536,258497,260463,262423,264390,266350,268302,270242,272181,274114,274175,274218,276048,276109,276152,277977,278016,278034,278077,279854,279893,279911,279954,281762,281779,281822,283620,283638,283681,285477,285494,285538,287332,287349,287394,289181,289191,289240,289272,289273,289275,289300,289301,289352,289353,291013,291027,291074,291105,291106,291112,291138,291139,291188,291190,292909,292923,292970,293001,293002,293008,293034,293035,293084,293085,294798,294812,294858,294889,294890,294897,294922,294923,294973,294974,296692,296738,296770,296771,296777,296802,296803,296853,296854,298570,298618,298648,298649,298655,298681,298682,298731,298732,300441,300488,300519,300520,300526,300551,300552,300602,300603,302374,302406,302407,302413,302439,302440,302490,302491,304258,304288,304289,304295,304322,304323,304374,304375,306184,306214,306215,306219,306251,306252,306306,306307,308108,308138,308139,308143,308175,308176,308230,308231,310026,310056,310057,310061,310093,310094,310148,310149,311940,311970,311971,311976,312007,312008,312062,312063,313849,313879,313880,313885,313916,313917,313971,313972,315754,315784,315785,315790,315820,315822,315876,315877,317652,317682,317683,317688,317719,317720,317774,317775,319542,319572,319573,319578,319609,319610,319664,319665,321451,321452,321457,321488,321489,321543,321544,323321,323322,323327,323357,323358,323413,323414,325216,325217,325222,325253,325254,325308,325309,327120,327121,327126,327154,327155,327209,327210,329015,329016,329021,329052,329053,329107,329108,330906,330907,330912,330944,330945,330998,330999,332792,332793,332798,332829,332830,332884,332885,334673,334703,334704,334759,334760,336569,336570,336624,336625,338436,338437,338491,338492,340316,340317,340373,340374,342240,342241,342297,342298,342302,344161,344162,344219,344220,344225,346077,346078,346135,346136,346141,347984,347985,348042,348043,348048,349874,349875,349932,349933,349938,351809,351810,351816,353687,353688,353694,355560,355561,355567,357437,357438,357444,359344,359345,359351,361243,361244,361250,363136,363138,363142,365020,365021,365025,366898,366899,366904,368773,368774,368780,370646,370647,370652,372510,372511,372517,374365,374366,374371,376210,376211,376216,378051,379884,457324,477944,479514,481076,481822,482560,483295,484038,484788,528021,529425,530825,532219,533606,535039,536463,537892,539301,539309,539317,540717,540725,540733,542141,542151,542157,542165,543583,543594,543599,543609,545052,545064,545069,545079,546506,546516,546523,546532,547966,547978,547979,547991,549417,549429,549435,549441,550860,550872,550878,550884,552307,552313,552320,553732,553738,553744,555154,555160,556567,557970,583970,584022,585287,585335,586595,586646,587901,587950,589197,589245,590838,590886,592455,592503,594081,594133,595785,595833,597475,597523,599156,599203,600827,600876,602504,602552,604172,604219,605830,605877,607526,609168,610855,612535,614209,614269,615871,615931,616014,617520,617580,617663,619152,619215,619299,620786,620845,620929,622406,622469,622553,624020,624083,624167,625708,625792,627327,627408,628932,629013,630527,630608,632116,632196,633700,633780,635273,635356,636835,636918,638386,638470,639925,640009,641455,641538,642975,643059,644488,644572,646078,647574,649065,650560,652040,653516,654982,656438,657884,659332,660772,662198,663617,665031,666438,667873,693996,695244,696474,697694,698899,700096,701291,702484,703672,704847,706004,707146,708277,709398,710546,711685,712822,713951,859671,859678,862394,862395,865101,865102,867796,867797,870480,870481,873162,873163,875845,875846,875876,878531,878532,878563,881215,881216,881247,883900,883901,883933,886608,889273,891934,894589,897243,899898,902535,921202,923878,926572,929286,1073204,1075596,1077979,1080350,1082710,1082787,1085054,1085131,1087383,1087460,1089702,1089780,1092031,1092110,1094351,1094432,1096661,1096741,1098957,1099038,1101234,1101315,1103505,1103585,1105755,1105834,1107990,1108067,1110197,1110274,1112459,1114627,1116780,1118914,1121046,1123186,1125318,1127509,1129730,1131937,1134126,1136329,1138531,1140729,1142920,1145103,1971123,1973130,3002637,3004933,3007165,3009352,3030867,3030941,3032284,3032359,3033686,3033764,3035278,3035356,3036859,3036934,3038428,3038501,3039988,3040061,3041538,3041617,3043081,3043161,3044621,3044699,3046151,3046229,3047669,3047743,3049176,3049249,3050684,3050762,3052262,3053756,3055235,3056705,3058169,3059617,3061055,3062795,3064528,3064557,3066249,3066276,3067959,3067988,3069656,3069685,3071345,3071373,3073020,3073050,3074688,3074719,3076379,3078036,3079690,3081344,3082979,3084608,3086264,3175871,3177269,3177290,3178660,3178681,3180132,3180153,3181600,3181621,3183066,3183087,3184529,3184550,3185990,3186011,3187447,3187468,3188898,3188919,3190344,3190364,3191785,3191804,3193241,3194931,3196717,3198691,3200660,3202357,3204051,3205741,3207428,3268770,3270818,3272946,3275055,3277148,3279238,3281373,3283499,3285619,3287771,3289901,3292018,3294123,3296226,3298317,3300400,3302478,3304542,3306587,3308633,3310674,3312708,3314727,3316741,3318742,3320727,3322712,3324859,3327132,3329518,3331901,3334268,3341358,3343695,3346055,3348405,3350742,3353067,3355383,3357714,3360056,3362423,3364777,3367112,3378802,3381098,3383370,3385655,3387923,3390168,3390178,3392416,3392429,3394658,3394670,3396880,3396892,3399092,3399106,3401293,3401307,3403483,3403498,3403547,3405664,3405680,3405727,3407833,3407849,3407898,3410013,3410060,3412157,3412206,3414372,3416521,3418661,3420781,3422885,3424963,3427023,3429067,3492166,3492170,3492205,3494289,3494293,3494325,3496405,3496409,3496442,3498556,3498562,3498594,3500707,3500738,3502875,3505005,3507132,3509251,3511365,3513471,3515569,3517657,3519745,3521823,3536259,3536287,3538286,3538312,3540312,3540341,3542383,3542409,3544440,3544467,3546480,3546509,3548516,3548540,3550548,3550574,3550615,3550627,3552590,3552615,3552657,3552672,3554621,3554649,3554689,3554703,3556663,3556688,3556730,3556742,3558689,3558715,3558752,3558768,3560725,3560766,3560780,3562731,3562768,3562786,3564731,3564772,3564788,3566747,3566787,3566801,3568759,3568799,3568815,3570778,3570820,3570834,3572790,3572828,3572844,3574840,3574853,3576747,3576763,3578652,3578669,3580549,3580568,3582440,3582450,3584301,3584315,3586157,3586168,3588012,3588026,3589864,3589873,3591712,3591723,3593558,3593572,3595521,3596111,3597512,3598101,3599490,3600079,3602039,3603987,3605924,3607851,3609769,3611677,3613576,3615500,3617415,3619320,3621221,3623120,3625013,3626892,3628758,3630623,3632482,3634333,3636174,3638010,3639834,3641646,3643448,3645242,3647032,3648808,3650581,3652337,3654086,3655828,3657557,3659281,3660999,3662725,3664441,3666142,3667839,3669527,3671206,3672880,3674545,3676201,3677844,3679481,3681115,3682747,3684372,3685991,3687600,3689200,3690796,3692386,3693970,3695544,3697114,3698669,3700213,3701753,3703286,3704809,3706329,3707841,3709334,3710822,3712308,3713785,3715255,3716717,3718181,3719635,3721079,3722524,3723958,3725386,3726810,3728228,3729638,3731037,3732431,3733818,3735191,3736561,3737926,3739279,3740622,3741961,3743289,3744612,3745927,3747235,3748536,3749824,3751107,3752383,3753649,3754910,3756164,3757420,3758665,3759902,3761136,3762363,3763582,3764800,3766010,3767213,3768406,3769593,3769988,3770377,3770761,3771142,3771522,3771901,3772277,3772650,3773018,3773382,3773752,3774121,3774486,3774849,3775210,3775569,3775926,3776279,3776627,3776979,3777328,3777673,3778013,3778348,3778678,3779003,3779333,3779659,3779980,3780296,3780611,3780922,3781227,3781527,3781824,3782116,3782404,3782687,3782972,3783254,3783533,3783809,3784081,3784352,3784618,3784880,3785138,3785393,3785646,3785980,3786311,3786661,3787007,3787349,3787688,3788023,3788356,3788685,3789011,3789334,3789652,3789968,3790281,3790592,3790899,3791203,3791504,3791801,3792096,3792388,3792677,3792964,3793247,3793526,3793801,3794074,3794343,3794609,3794873,3795135,3795394,3817695,3818081,3818484,3818882,3819273,3819664,3820050,3820432,3820812,3821187,3821555,3821920,3822284,3836707,3836965,3837224,3837479,3840273,3840286,3840523,3840540,3840806,3840823,3841085,3841102,3841360,3841377,3841632,3841649,3841899,3841916,3842161,3842178,3842421,3842438,3842688,3842705,3842970,3843233,3843491,3843745,3843996,3845804,3846050,3846293,3846532,3846770,3847004,3907302,3907992,3908682,3909363,3910043,3932291,3932932,3933575,3934217,3941333,3941973,3942607,3943239,3943867,3944490,3946377,3946388,3947000,3947010,3947612,3947623,3948231,3948873,3994323,3994850,3995366,3995882,3996397,3996900,3997405,3998405,3998912,3999414,4035089,4035099,4035448,4035456,4036350,4036357,4037249,4037255,4038176,4039088,4138006,4138676,4139342,4140006,4140666,4141318,4141971,4142622)) 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





	Vladislav Shumakov (Dancer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Vladislav Shumakov (Dancer)

Vladislav Shumakov (Dancer)

• Prize-winner at the IX Seoul International Dance Competition (South Korea, 2012)
• Prize-winner at the International Ballet Competition in Rieti (Italy, 2011)
• Prize-winner at the III International Yuri Grigorovich Competition Young Ballet of the World (Russia, Sochi, 2010)

Born in Perm.
Graduated from the Perm School of Dance in 2006.
Joined the Mariinsky Ballet in 2011.

Repertoire includes:
Swan Lake (Jester); choreography by Marius Petipa and Lev Ivanov, revised version by Konstantin Sergeyev,
The Sleeping Beauty (Puss in Boots); choreography by Marius Petipa, revised version by Konstantin Sergeyev,
The Fountain of Bakhchisarai (Polish Youths); choreography by Rostislav Zakharov,
The Legend of Love (Friends of Ferkhad); choreography by Yuri Grigorovich,
The Nutcracker (Chinese Dance); choreography by Kirill Simonov, designs by Mihail Chemiakin,
Le Parc; choreography by Angelin Preljocaj,
Jewels (Rubies); choreography by George Balanchine
and The Little Humpbacked Horse (the Humpbacked Horse), Cinderella (Spring); choreography by Alexei Ratmansky.