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 (8692,10381,11964,13547,14702,14742,14751,14776,14783,14906,16155,16196,16203,16227,16232,16356,17762,17806,17813,17837,17842,17966,19167,19199,19207,19228,19236,19357,20643,20650,20669,20677,20799,22126,22133,22153,22161,22303,23580,23587,23607,23615,23757,25044,25049,25070,25077,25240,26803,26813,26859,26874,27158,27723,27740,27840,27878,28454,29135,29148,29197,29212,29549,30992,30997,31018,31025,31188,32506,32513,32536,32543,32713,34058,34063,34237,35632,37175,37190,38721,38745,38765,38798,38816,40174,40192,40213,40245,40268,41554,41579,41600,41628,41633,41636,41674,41694,42966,42996,43022,43023,43030,43069,43087,44354,44381,44387,44389,44427,44446,45706,45733,45739,45741,45780,45797,47051,47078,47084,47086,47125,47142,48393,48419,48420,48427,48466,48484,49727,49750,49757,49759,49798,49815,51078,51085,51087,51126,51143,52396,52404,52406,52445,52462,53711,53719,53721,53760,53777,55020,55028,55030,55068,55086,56323,56329,56336,56370,56389,57684,57689,57694,57732,57754,59759,59764,59802,59824,61832,61865,61887,63921,63942,65968,65989,68013,68034,70055,70076,72092,72113,74122,74143,76140,76161,78150,78171,80156,80177,82176,84168,86153,88131,105606,105689,107501,107583,109470,111347,113216,115077,116953,118831,120701,122567,124425,126274,128114,129942,131771,133604,135429,137250,139067,140877,142678,144468,146249,153354,153429,153437,155085,155160,155168,156806,156880,156889,158517,158591,158600,160243,160317,160326,161970,162044,162053,163693,163780,163790,165435,165522,165532,167166,167253,167263,168887,168974,168984,170599,170685,170696,172303,172389,172400,173997,174083,174094,175680,175767,175781,177439,177454,179107,179117,180761,180771,182408,182418,184048,184058,185679,185688,187301,187310,188912,188922,190512,190522,192101,192111,193679,193689,196434,196449,197746,197761,199063,199078,200380,200395,202062,202077,203734,203749,205409,205418,207107,207116,208794,208804,274168,274218,276102,276152,278027,278077,279904,279954,281772,281822,283631,283681,285487,285538,287342,287394,289189,289240,289264,291023,291074,291100,292919,292970,292996,294808,294858,294884,296688,296738,296765,298563,298618,298642,300488,300513,302374,302400,304258,304283,306184,306209,308108,308133,310026,310051,311940,311966,313849,313875,315754,315780,317652,317678,319542,319568,321447,323317,325212,327113,329011,330901,457356,457399,458923,458965,460479,460522,462026,462069,463578,463620,465126,465168,466668,466710,468367,468408,470110,471661,473201,474781,476358,477930,477969,478118,479505,479538,479571,479687,481065,481104,481135,481814,481851,481882,482589,482620,483323,483357,484064,484095,484815,484846,485560,485591,486298,486329,487022,487053,487737,487771,488449,488480,489162,489193,489902,490604,491303,491991,492669,493351,494029,497376,497384,497437,498845,498848,498901,500298,500302,500361,501753,501756,501811,503244,503250,503305,504726,504727,504782,506198,506204,506254,507668,507673,507730,509138,509139,509195,510602,510603,510659,512057,512058,512114,513499,513508,513562,514975,514978,515034,516441,516497,517951,519395,520837,522274,523706,525125,526531,527935,529338,530738,532132,533519,539429,539446,540845,540861,542278,542287,543725,543735,545195,545205,546649,546659,548105,548114,549556,549565,550998,551008,552433,552443,553856,553867,555272,555288,556679,556695,558081,558097,559478,559494,560871,560886,562258,562273,563640,563655,565009,565022,566375,566382,567734,567740,569088,569096,570436,570443,571774,571788,573152,573162,574524,574533,575885,575893,577243,577251,578595,578602,579936,579943,581269,581276,582593,582602,583917,583924,583945,583964,583970,584003,585230,585246,585259,585282,585287,585322,586541,586551,586566,586590,586595,586627,587844,587859,587873,587896,587901,587935,589140,589155,589168,589192,589197,589229,590795,590808,590833,590838,590870,592413,592427,592450,592455,592488,594056,594076,594081,594119,595754,595779,595785,595817,597470,597475,597506,599151,599156,599187,600822,600827,600861,602499,602504,602536,604167,604172,604203,605830,605861,607510,609149,610836,612520,614190,614236,615852,615898,615985,616023,616086,617500,617551,617634,617672,617735,619185,619271,619308,619370,620817,620900,620937,621000,622439,622525,622562,622624,624053,624139,624176,624238,625678,625764,625801,625863,627295,627378,627416,627479,628899,628983,629021,629084,630495,630583,630617,630680,632084,632172,632206,632269,633668,633756,633790,633852,635240,635329,635362,635425,636890,636924,636985,638364,638444,638477,638538,639983,640016,640077,641513,641549,641607,643031,643068,643130,644542,644579,644643,646048,646085,646149,647548,647586,647648,649040,649076,649133,650532,650569,650631,652015,652052,652114,653491,653528,653590,654957,654994,655056,656412,656448,656511,657857,657896,657964,659306,659344,659412,660781,660849,662207,662274,663626,663693,665040,665108,666448,666516,667883,667951,669307,669375,670742,670810,672238,673657,675062,676457,677843,679249,680642,682030,683401,684768,686113,693917,693984,693989,694033,695165,695232,695237,695281,696395,696461,696466,696513,697614,697681,697686,697732,698821,698889,698892,698940,700086,700089,700136,701275,701278,701325,702472,702477,702521,703656,703665,703706,704831,704840,704881,705989,705996,706038,707134,707139,707183,708264,708272,708313,709386,709393,709434,710530,710539,710585,711670,711680,711725,712817,712863,713988,715102,716205,717297,718378,719450,720509,875899,878586,881270,883956,886631,889296,891958,894613,897267,899920,902557,905189,907805,910419,913029,921198,921219,923873,923900,926568,926591,929281,929308,932013,934721,937426,940157,942873,945578,948280,950986,953686,956375,959052,961707,964347,966987,969615,972247,974867,977479,980086,982678,985261,987885,990504,993120,995725,995847,998319,998440,1000903,1001024,1003484,1003605,1006063,1006178,1008630,1008745,1011189,1011304,1013884,1016449,1018995,1021542,1024088,1026621,1029151,1031609,1031613,1031617,1031621,1031681,1034112,1034115,1034120,1034124,1034184,1036601,1036604,1036608,1036612,1036673,1039090,1039093,1039097,1039101,1039162,1041577,1041581,1041585,1041646,1044057,1044061,1044090,1044122,1046527,1046557,1046589,1049014,1049046,1051458,1051490,1053888,1053919,1056315,1056346,1058737,1058768,1061146,1061177,1063547,1063577,1065971,1068352,1070725,1073125,1073213,1075518,1075606,1075631,1077901,1077989,1078014,1080271,1080360,1080385,1082720,1082745,1085065,1085091,1087392,1087418,1089713,1089738,1092043,1092069,1094364,1094391,1096670,1096699,1098967,1099000,1101244,1101277,1103515,1103548,1105764,1105797,1107991,1108025,1110204,1110232,1112390,1112418,1114586,1116739,1118875,1121005,1123146,1125277,1847886,1850035,1852181,1854321,1856464,1858591,1860707,1862822,1864933,1867034,1869121,1871201,1873266,1875321,1877374,1879449,1881516,1883576,1885627,1887696,1889754,1891812,1915718,1915731,1915738,1917931,1917943,1917950,1920132,1920142,1920150,1922330,1922342,1922349,1924523,1924531,1924538,1926770,1926778,1926786,1929011,1929019,1929027,1931240,1931248,1931256,1933454,1933462,1933470,1935653,1935661,1935669,1937849,1937857,1937865,1940038,1940046,1940053,1942217,1942225,1942232,1944388,1944396,1944403,1946549,1946556,1946564,1948698,1948709,1948710,1950833,1950844,1950850,1952965,1952975,1952982,1955087,1955098,1955105,1957163,1957174,1957181,1959228,1959238,1959245,1961281,1961291,1961297,1963319,1963329,1963334,1965345,1965357,1965362,1967366,1967381,1967382,1969385,1969396,1969402,1971141,1971396,1971411,1971412,1973153,1973406,1973418,1973423,1975148,1975403,1975418,1975419,1977136,1977390,1977401,1977405,1979105,1979360,1979375,1979376,1981105,1981359,1981370,1981374,1983351,1983362,1983366,1985335,1985350,1985351,1987312,1987326,1987329,1989282,1989296,1989299,1991237,1991249,1991253,1993177,1993192,1993193,1995115,1995126,1995130,1997043,1997054,1997059,1998965,1998980,1998981,2000879,2000894,2000895,2002782,2002797,2002798,2004672,2004687,2004692,2006548,2006563,2006564,2008433,2008447,2008453,2010318,2010332,2010338,2012195,2012208,2012215,2014059,2014074,2014075,2015899,2015914,2015915,2017730,2017737,2017742,2019536,2019551,2019552,2021343,2021358,2021359,2023144,2023159,2023160,2024937,2024949,2024955,2026930,2026945,2026946,2028920,2028935,2028936,2030899,2030914,2030915,2032863,2032876,2032881,2034823,2034838,2034839,2036778,2036790,2036794,2038723,2038734,2038738,2040661,2040672,2040676,2042587,2042598,2042602,2044498,2044513,2044514,2046395,2046406,2046411,2048285,2048300,2048301,2050167,2050178,2050183,2052041,2052055,2052056,2053905,2053920,2053921,2055856,2055871,2055872,2057891,2057905,2057911,2059924,2059938,2059944,2061951,2061965,2061971,2063971,2063985,2063990,2065981,2065995,2066000,2067983,2067996,2069989,2070002,2071986,2071993,2073964,2073971,2075936,2075943,2077895,2077909,2079907,2081897,3000383,3002614,3002630,3002641,3002701,3004926,3004937,3004997,3007158,3007169,3007229,3009356,3009416,3011537,3011595,3013752,3015895,3018034,3020227,3022077,3023553,3025020,3029485,3030815,3030912,3032233,3032329,3033637,3033731,3035229,3035323,3036807,3036902,3038471,3040031,3041585,3043129,3044665,3046196,3047713,3049220,3050728,3052233,3053724,3055205,3056675,3058136,3059582,3061027,3062766,3064497,3064644,3066362,3068072,3069770,3071456,3073135,3074807,3076464,3078123,3079777,3081431,3083069,3084696,3086346,3087993,3088268,3089621,3089902,3091245,3091526,3092859,3093134,3094458,3094737,3096049,3096328,3097638,3097913,3099213,3099491,3099494,3101063,3102623,3104170,3105704,3107257,3108804,3110375,3111932,3113479,3115013,3116534,3118046,3119558,3121062,3122591,3124288,3125970,3127644,3129308,3130964,3132611,3134251,3135891,3137524,3139145,3140757,3142361,3142591,3143955,3144185,3145545,3145775,3147125,3147355,3147761,3147991,3148391,3148621,3149015,3149245,3149639,3149869,3151186,3151416,3152725,3152955,3154258,3154488,3155781,3156011,3157297,3157527,3158804,3159034,3160298,3160528,3161783,3162013,3163260,3163491,3164732,3164963,3166195,3166441,3167640,3167849,3169034,3169243,3170419,3170628,3171796,3172005,3173167,3173376,3174532,3174740,3175933,3176142,3177292,3177331,3177540,3178683,3178721,3178929,3180155,3180193,3180401,3181623,3181661,3181869,3183089,3183127,3183335,3184552,3184590,3184728,3184739,3184743,3184800,3186013,3186051,3186189,3186200,3186204,3186261,3187470,3187508,3187646,3187657,3187661,3187718,3188921,3188959,3189097,3189108,3189112,3189169,3190366,3190406,3190542,3190551,3190554,3190614,3191807,3191846,3191980,3191992,3191998,3192055,3193243,3193286,3193413,3193430,3193433,3193491,3194934,3194977,3195106,3195120,3195124,3195182,3196719,3196762,3196891,3196905,3196907,3196967,3198694,3198733,3198867,3198881,3198884,3198942,3200661,3200704,3200837,3200848,3200852,3200908,3202360,3202399,3202535,3202546,3202550,3202608,3204052,3204094,3204228,3204238,3204244,3204299,3205743,3205781,3205918,3205930,3205932,3205991,3207430,3207473,3207602,3207617,3207619,3207678,3209110,3209153,3209281,3209297,3209298,3209358,3210821,3210958,3210970,3210972,3211031,3212544,3212678,3212688,3212691,3212748,3214245,3214379,3214392,3214394,3214454,3215940,3216076,3216086,3216089,3216147,3217636,3217766,3217781,3217783,3217843,3219323,3219459,3219469,3219472,3219529,3221003,3221133,3221148,3221152,3221210,3222669,3222804,3222815,3222818,3222876,3224335,3224470,3224481,3224486,3224541,3225963,3226093,3226110,3226113,3226170,3227712,3227725,3227728,3227788,3229329,3229343,3229348,3229405,3230949,3230966,3230969,3231027,3232570,3232583,3232586,3232643,3234178,3234191,3234193,3234252,3235776,3235790,3235792,3235850,3237359,3237374,3237379,3237434,3238929,3238944,3238946,3239006,3240496,3240511,3240514,3240573,3242098,3242114,3242117,3242174,3243691,3243708,3243710,3243767,3245277,3245290,3245294,3245348,3246876,3246890,3246895,3246951,3248463,3248478,3248481,3248537,3250033,3250047,3250052,3250107,3251598,3251612,3251615,3251672,3253156,3253172,3253175,3253231,3254761,3254771,3254776,3254829,3256768,3256782,3256785,3256842,3258782,3258792,3258798,3258852,3260778,3260789,3260795,3260850,3262761,3262772,3262774,3262830,3264741,3264752,3264755,3264811,3266718,3266729,3266735,3266788,3268691,3268703,3268716,3268720,3268735,3268768,3268773,3270737,3270751,3270764,3270767,3270786,3270815,3270824,3272864,3272880,3272890,3272895,3272912,3272943,3272949,3274975,3274991,3275000,3275003,3275022,3275052,3275059,3277068,3277083,3277093,3277099,3277115,3277145,3277152,3279158,3279170,3279184,3279187,3279203,3279236,3279244,3281293,3281306,3281317,3281320,3281338,3281369,3281377,3283419,3283431,3283443,3283446,3283463,3283498,3283506,3285538,3285552,3285562,3285568,3285584,3285622,3285626,3287702,3287712,3287714,3287732,3287767,3287775,3289834,3289847,3289851,3289868,3289904,3289910,3291963,3291966,3291983,3292017,3292024,3294066,3294069,3294088,3294125,3294129,3296168,3296170,3296188,3296222,3296231,3298264,3298281,3298316,3298322,3300366,3300403,3300408,3302440,3302475,3302483,3304505,3304539,3304547,3306553,3306590,3306595,3308599,3308636,3308641,3310678,3310682,3312711,3312716,3314728,3314735,3316739,3316745,3318739,3318746,3320730,3320735,3322715,3322720,3324862,3324868,3327133,3327136,3329519,3329526,3331898,3331907,3334266,3334272,3336625,3338974,3341336,3341346,3341357,3341388,3341403,3341434,3343670,3343683,3343698,3343724,3343740,3343772,3346029,3346042,3346051,3346077,3346096,3346128,3348379,3348392,3348402,3348434,3348450,3348482,3350720,3350731,3350739,3350772,3350785,3350816,3353054,3353065,3353089,3353111,3353141,3355373,3355382,3355414,3355427,3355459,3357700,3357712,3357739,3357760,3357789,3360048,3360060,3360084,3360105,3360134,3362422,3362449,3362464,3362495,3364774,3364805,3364821,3364849,3367117,3367140,3367160,3367191,3369470,3369490,3369520,3371799,3371816,3371844,3374112,3374134,3374164,3376430,3376445,3376474,3378734,3378751,3378783,3378787,3381032,3381047,3381078,3381083,3383317,3383348,3383355,3385604,3385633,3385641,3387871,3387901,3387910,3390132,3390161,3390168,3392413,3392416,3394648,3394658,3396869,3396880,3399087,3399092,3401288,3401293,3403478,3403483,3403519,3403619,3405660,3405664,3405698,3405800,3407833,3407870,3407967,3410032,3410130,3412177,3412279,3414346,3414443,3416491,3416591,3418633,3418732,3420756,3420855,3422958,3425035,3427098,3429141,3431166,3433173,3435177,3437172,3439155,3441119,3443084,3445060,3447213,3449363,3451498,3453633,3455753,3457874,3459998,3462136,3464262,3466412,3468592,3492161,3492195,3494284,3494316,3496401,3496432,3498585,3500729,3502863,3504995,3507118,3509241,3511354,3513461,3515562,3534256,3536297,3538326,3540347,3542418,3544476,3546518,3548552,3550585,3550615,3550629,3552625,3552657,3552674,3554660,3554689,3554705,3556701,3556730,3556745,3558723,3558752,3558771,3560737,3560766,3560782,3562738,3562768,3562781,3564742,3564772,3564784,3566760,3566787,3566803,3568773,3568799,3568817,3570791,3570820,3570835,3572800,3572828,3572846,3574813,3574840,3574855,3576719,3576747,3576765,3578621,3578652,3578665,3580549,3580562,3582440,3582451,3584301,3584312,3586157,3586170,3588012,3588022,3589864,3589876,3591712,3591725,3593558,3593569,3595523,3597514,3599494,3810826,3811217,3811603,3811982,3812361,3812737,3813106,3813472,3813834,3814190,3814543,3814894,3815243,3815588,3815932,3816271,3816962,3816970,3816975,3817314,3817318,3817323,3817659,3817667,3817672,3818043,3818053,3818057,3818445,3818452,3818460,3818854,3818858,3819247,3819640,3836749,3837006,3837264,3837520,3837774,3838027,3838283,3838538,3838790,3839041,3839291,3839540,3839783,3840024,3840263,3840266,3840286,3840512,3840517,3840540,3840795,3840800,3840823,3841074,3841079,3841102,3841349,3841354,3841377,3841621,3841626,3841649,3841893,3841916,3842178,3842438,3842705,3842970,3843233,3843491,3843745,3843996,3845792,3845812,3846038,3846058,3846281,3846301,3846540,3846778,3847012,3847241,3847469,3847701,3852385,3852485,3852489,3853078,3853082,3853670,3853674,3854257,3854262,3854842,3854850,3855424,3855430,3856006,3856012,3856585,3856591,3857161,3857167,3857779,3857785,3858396,3858401,3859199,3859202,3859999,3860002,3860798,3860803,3861594,3861598,3862387,3862392,3863177,3863182,3863964,3863968,3864747,3864754,3865527,3865530,3866305,3866308,3867079,3867083,3867851,3867858,3868621,3868625,3869388,3869394,3870154,3870158,3870917,3870921,3871678,3871683,3873166,3873170,3873921,3873926,3874673,3874677,3875424,3875428,3876171,3876177,3876918,3876921,3877662,3877666,3878405,3878410,3879147,3879151,3879888,3879893,3880628,3880634,3881372,3881377,3882115,3882119,3882857,3882864,3883599,3883605,3884338,3884342,3885076,3885083,3885812,3885819,3886547,3886555,3887282,3887286,3888016,3888020,3888745,3888750,3889476,3889481,3890206,3890930,3893821,3894540,3895258,3895971,3897426,3898131,3898832,3899533,3900232,3900949,3901663,3902375,3903088,3903797,3904503,3905199,3905901,3907293,3907982,3908673,3946397,3947016,3947633,3948239,3948880,3949519,3950154,3953307,3953925,3954539,3955148,3963650,3963670,3964244,3964812,3965381,3965966,3966545,4138024,4138697,4139363,4140025,4140684,4141336,4141990,4142640,4143284,4143926,4144564,4145196,4279223,4279348,4279471,4279592,4279751,4279906)) 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





	Yuri Smekalov (Dancer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Yuri Smekalov (Dancer)

Yuri Smekalov (Dancer)

• Prizewinner at the XI International Ballet Dancers' and Choreographers' Competition in the category "Choreographer" (Moscow, 2009).
• Recipient of the Golden Mask, Russia's most prestigious theatre prize, for "Best Male Role" in the ballet The Seagull (as Trigorin, season 2007-2008).
• Diploma-recipient at the Benois de la danse festival 2008.
• Diploma-recipient of the Golden Sofit, St Petersburg's most prestigious theatre prize (2008)

Born in Nizhny Tagil.
Graduated from the Vaganova Academy of Russian Ballet in 1998 (class of Yuri Shatalov).
From 1998-2009, he was a soloist with the Boris Eifman St Petersburg State Academic Ballet Theatre, where he danced the lead roles in ballets including Don Quixote, or Fantasies of a Madman, Tchaikovsky, The Karamazovs, Red Giselle, Russian Hamlet, Don Juan and Moliиre, Who is Who and The Seagull. As a guest artist, he has appeared in the ballets Spartacus (Spartacus) at the Mikhailovsky Theatre and Andro-Geny (Zeus) at the Leonid Yakobson Theatre.
As a choreographer, he has staged Autumn Gold – verba volant, scripta manent (Words Fly away, What Is Written Remains), a project in memory of Georgy Alexidze, Parting, a choreographic miniature performed by Yevgenia Obraztsova and Vladimir Shklyarov (MALAKHOV AND FRIENDS). In the 2003-2004 season, Yuri Smekalov worked as Yevgeny Plushchenko's choreographer: short programme to the music Nyah, free programme to Edvin Minton's music Violin Fantasy, to which Plushchenko performed at Campbell's Figure Skating Classics (New York, USA, 2003), MasterCard Skate Canada (Mississauga, Canada, 2003), the Trophйe Lalique (Paris, France, 2003), Cup of Russia Gallina Blanca (Moscow, 2003), the International Figure Skating Challenge (Auburn Hills, USA, 2003), the ISU Grand Prix Final (Colorado Springs, USA, 2003), the Russian Championships (St Petersburg, 2004), the European Championships (Budapest, 2004) and the World Championships (Dortmund, 2004).
In the 2008-2009 season, Yuri Smekalov worked as a choreographer with figure skater Artur Gachinsky (coach  Alexei Mishin) and prepared the programmes Narcissus and The Hermit.
Yuri Smekalov has been a Mariinsky Theatre soloist since February 2009.

Repertoire at the Mariinsky Theatre includes:
Le Corsaire (Birbanto);
The Sleeping Beauty (one of Aurora's Suitors);
Raymonda (Abderchaman);
Romeo and Juliet (Tybald);
The Little humpbacked hourse (Gentleman of the Bedchaber, Horses, Sea horses)