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 (8401,8452,8463,8467,10108,10156,10164,10171,11691,11739,11747,11754,13274,13322,13330,13337,14672,14682,14690,14709,16122,16135,16142,16161,17732,17745,17752,17771,19157,19172,34080,34095,35577,35591,37120,37132,37139,37191,38667,38683,38687,38746,40139,40193,41643,43037,44396,45748,47093,48434,49766,51094,52413,53728,55037,56340,57704,59773,61837,63892,105672,105700,107566,107594,109453,109480,111329,111357,113198,113226,115059,115086,116935,116962,118810,118837,120680,120706,122546,122572,124404,124435,126252,126284,128092,128124,129921,129953,131750,131782,133583,133615,135408,135439,137229,137260,139046,139078,140887,142687,144477,146257,148028,153319,153424,153449,153458,153468,155050,155154,155180,155189,155199,156771,156875,156901,156911,156920,158482,158586,158612,158622,158632,160208,160311,160338,160348,160358,161934,162038,162065,162075,162085,163775,163805,163819,163829,165517,165547,165560,165571,167248,167278,167291,167302,168967,168999,169012,169023,170679,170711,170724,170735,172383,172415,172428,172439,174077,174109,174122,174133,175760,175792,175806,175817,177433,177464,177479,177490,179096,179127,179142,179153,180750,180781,180796,180806,182397,182428,182443,182453,184037,184068,184083,184094,185668,185699,185714,185725,187295,187321,187336,187347,188907,188933,188948,188959,190507,190533,190548,190559,192096,192126,192137,192148,193674,193704,193715,193725,196428,196461,196474,196484,197742,197774,197785,197796,198210,199059,199091,199102,199113,199527,200376,200408,200419,200430,200844,202058,202090,202101,202112,202526,203729,203761,203773,203784,204198,205403,205435,205446,205457,205902,207101,207133,207144,207155,207600,208789,208821,208832,208843,209288,210497,210508,210954,212468,214008,215543,217074,218603,220126,221411,221449,221645,222925,222963,223159,224434,224472,224668,225939,225980,226179,227444,227486,227684,228943,228985,229183,230928,230970,231168,232923,232965,233163,234913,234955,235153,236898,236939,237138,238872,238914,239112,240838,240880,241078,242799,242841,243039,244759,244798,244999,246713,246752,246951,248660,248699,248898,250603,250641,250841,252587,252626,252825,254560,254598,254798,256524,256562,256766,258485,258524,258724,260451,260489,260693,262411,262449,262653,264377,264417,264616,266337,266377,266576,268289,268329,268530,270230,270270,270471,272169,272209,272410,274102,274142,274343,276076,276277,278004,278204,279880,280081,281748,281949,283607,283807,285464,285664,287319,287519,289161,289331,289341,289362,291169,291176,291198,293065,293072,293094,294953,294961,294986,296834,296841,296866,298708,298718,298740,300578,300588,300611,302470,302477,302499,304352,304358,304382,306284,306290,306314,308208,308214,308238,310125,310132,310156,312039,312046,312070,313948,313955,313979,315853,315860,315884,316034,317751,317758,317782,317932,319641,319648,319672,319822,321520,321528,321551,321701,323390,323398,323421,323571,325285,325292,325316,325476,327184,327192,327216,327380,329084,329091,329115,329282,330975,330982,331006,331175,332861,332869,332892,333061,334736,334744,334767,334936,336602,336610,336633,336802,338468,338476,338499,338679,340350,340356,340380,340586,342274,342280,342304,342359,342510,344198,344205,344227,344282,344432,346114,346121,346143,346198,346351,348021,348028,348050,348105,348258,349911,349918,349940,349994,350148,351789,351795,351821,351876,352025,353667,353674,353696,353750,353904,355539,355546,355572,355623,355777,357417,357424,357449,357500,357654,359323,359330,359356,359407,359560,361222,361229,361255,361309,361460,363114,363122,363145,363200,363349,364995,365002,365029,365083,365234,366875,366882,366906,366962,367112,368760,368786,368840,368992,370630,370655,370710,370861,372520,372575,372725,374374,374429,374580,376218,376274,376425,378053,378109,378259,379886,379942,380092,381714,381770,381920,383589,383745,385405,385561,387173,387212,387369,389024,389180,390826,390981,392626,392781,394422,394571,396212,396367,396688,397997,398152,398472,399775,399926,400252,401544,401699,402019,403303,403453,403780,405060,405215,405537,406967,407287,408714,409034,410454,410774,412220,412541,413977,414298,415720,416041,417459,417784,419199,419524,420932,421259,422662,422987,424385,424714,426101,426426,427798,428125,429492,429819,431181,431533,432884,433246,434582,434944,436274,436638,437955,438321,439625,439989,441284,441646,442925,443289,444555,444919,446173,446543,447787,448156,449390,449759,450980,451350,452570,452940,454158,454528,456108,457370,457682,458937,459249,460493,460805,462041,462353,463593,463905,465139,465453,466681,466995,468378,468702,470080,470417,471632,471968,473510,475090,476667,478023,478047,478242,479594,479619,479813,484115,484866,485612,492691,493373,494050,494724,495387,497346,497357,497371,497482,497591,498810,498821,498833,498944,499053,500266,500277,500289,500399,500509,501720,501731,501743,501854,501963,503212,503223,503233,503342,503457,504702,504714,504824,504934,506173,506186,506296,506406,507644,507656,507769,507878,509113,509126,509238,509347,510590,510701,510810,512045,512157,512266,513493,513606,513741,515078,515214,516540,516678,517994,518132,519438,519576,520880,521018,522317,522454,523745,523886,525164,525305,526574,526710,527978,528115,529381,529519,530781,530919,532174,532314,533562,533699,534993,535133,536417,536557,537848,537987,539271,539347,539388,539411,539446,540687,540763,540804,540827,540861,542121,542195,542236,542259,542287,543567,543642,543678,543706,543735,545037,545112,545149,545176,545205,546564,546603,546628,546659,548020,548059,548084,548114,549471,549509,549535,549565,550914,550952,550978,551008,552350,552387,552413,552443,553774,553815,553837,553867,555190,555231,555253,555288,556597,556638,556660,556695,558000,558040,558062,558097,559397,559437,559459,559494,560790,560829,560852,560886,562176,562216,562238,562273,563557,563597,563620,563655,564927,564967,564990,565022,566289,566329,566354,566382,567651,567686,567710,567740,569041,569067,569096,570388,570415,570443,571730,571754,571788,573104,573130,573162,574476,574502,574533,575837,575865,575893,577195,577223,577251,578575,578602,579916,579943,581249,581276,582575,582602,583897,583924,583970,584003,585246,585287,585322,586551,586595,586627,587859,587901,587935,589155,589197,589229,590795,590838,590870,592413,592455,592488,594081,594119,595785,595817,597475,597506,599156,599187,600827,600861,602504,602536,604172,604203,605830,605861,607510,609149,610836,612520,614190,614275,615852,615937,615940,616014,616065,617500,617586,617589,617663,617714,619221,619227,619299,619353,620850,620854,620929,620980,622475,622481,622553,622607,624089,624095,624167,624221,625714,625720,625792,625846,627332,627334,627408,627460,628937,628939,629013,629064,630533,630534,630608,630659,632122,632123,632196,632248,633706,633707,633780,633832,635279,635280,635356,635406,636841,636842,636918,636968,638393,638399,638470,638520,639931,639938,640009,640059,641461,641468,641538,641589,642981,642987,643059,643113,644494,644497,644572,644624,645999,646003,646078,646130,647505,647574,647631,649065,649116,650560,650614,652040,652092,653516,653568,654982,655034,656438,656489,657884,657940,659332,659389,660772,660826,662198,662253,663617,663678,665031,665087,666438,666497,667873,667932,669356,670791,672214,673633,675043,676438,677824,679231,680625,682011,693958,693984,693989,694014,694046,695206,695232,695237,695262,695294,696434,696461,696466,696494,696525,697654,697681,697686,697711,697744,698862,698889,698892,698917,698951,700060,700086,700089,700114,700147,701249,701275,701278,701308,701336,702446,702472,702477,702502,702534,703630,703656,703665,703689,703716,704805,704831,704840,704863,704890,705961,705989,705996,706020,706051,707108,707134,707139,707164,707196,708264,708272,708295,708327,709386,709393,709417,709448,710530,710539,710562,710594,711670,711680,711703,711735,712817,712840,712872,713969,714001,715083,715110,716184,716212,717278,717310,718392,719463,720522,721571,722622,859678,862394,865101,867796,870480,873162,875845,875876,878531,878563,881215,881247,883900,883933,886608,889273,891934,894589,897243,899898,902535,921188,923867,926561,929275,931984,934691,937396,940127,942845,945550,948252,950959,953659,956349,959026,961681,964321,966957,969589,972217,974837,977449,980056,982648,985234,987858,990477,995825,995842,998420,998437,1001004,1001021,1003584,1003602,1006157,1006175,1008723,1008742,1011282,1011301,1013862,1013881,1016426,1016443,1018975,1018990,1021522,1021537,1024067,1024084,1026601,1026616,1029131,1029146,1031658,1031676,1034161,1034177,1036651,1036666,1039140,1039155,1041624,1041639,1044100,1044115,1046567,1046582,1049024,1049039,1051468,1051483,1053898,1053913,1056325,1056340,1058745,1058762,1061154,1061171,1063555,1063572,1065953,1065965,1068335,1068351,1070720,1073120,1075513,1075649,1077896,1078036,1080407,1082767,1085112,1087441,1089760,1092090,1094412,1096722,1099019,1101296,1103567,1105816,1108043,1110250,1112436,1114605,1116755,1118892,1121021,1123163,1125296,1127488,1129708,1131912,1136465,1138667,1140865,1143056,1145239,1147408,1149564,1151717,1153863,1156005,1158178,1160340,1162486,1164619,1166749,1168883,1171007,1173123,1175169,1175234,1177374,1179504,1181633,1183748,1185854,1187958,1190066,1192159,1194238,1196316,1198387,1200452,1202507,1204565,1206607,1447254,1448812,1450357,1451890,1453413,1454926,1456431,1457929,1459421,1460892,1648602,1651407,1654271,1657126,1659969,1662798,1665615,1716178,1718948,1721703,1724445,1727184,1729916,1732629,1735333,1738028,1740710,1743376,1746038,1748691,1751334,1753973,1756602,1759220,1761825,1764426,1767022,1769612,1772193,1774764,1777333,1779886,1802415,1802478,1804853,1804916,1807274,1807337,1809677,1809740,1812058,1812121,1814413,1814476,1816759,1816822,1819144,1821442,1823714,1825962,1828186,1830388,1832576,1834776,1971177,1973187,1975184,1977169,1979141,1981138,1983130,1985116,1987093,1989063,1991019,1992958,1994895,1994895,2446922,2449838,2452746,2455631,2458514,2461388,2464237,2467090,2469963,2472900,2475805,2478747,2481671,2731804,2734916,2738007,2741089,2744161,2747212,2750242,2753269,2756294,2759307,2762322,2765331,2768321,2771295,2774265,2777224,2780208,2783233,2786314,2789393,2807792,2807913,2810736,2810857,2813660,2813781,2816576,2816697,2819557,2819678,2822527,2822648,2825509,2825630,2828478,2828599,2831429,2831550,2834359,2834480,2837282,2837403,2840209,2840331,2843126,2843249,2844565,2844688,2845993,2846116,2847412,2847535,2848943,2851797,2853217,2854630,2856040,2857443,2858839,2860226,2861602,2864378,2867155,2868528,2869907,2871283,2872654,2874019,2875376,2876722,2878065,2879437,2882213,3002641,3004937,3007169,3009356,3011537,3029476,3030816,3030873,3030902,3030952,3032234,3032291,3032316,3032369,3033638,3033692,3033721,3033773,3035230,3035284,3035313,3035365,3036808,3036867,3036891,3036944,3038436,3038460,3038513,3039995,3040025,3040073,3041544,3041574,3041626,3043087,3043117,3043170,3044625,3044659,3044708,3046156,3046186,3046238,3047674,3047700,3047754,3049180,3049212,3049260,3050688,3050720,3050772,3052192,3052219,3052274,3053714,3053764,3055193,3055244,3056668,3056716,3058125,3058177,3059575,3059626,3061014,3061066,3062805,3064536,3064614,3064638,3064647,3066259,3066333,3066358,3066366,3067968,3068041,3068069,3068079,3069665,3069738,3069767,3069776,3071352,3071429,3071453,3071462,3073032,3073108,3073130,3073141,3074701,3074777,3074801,3074809,3076360,3076434,3076462,3076472,3078013,3078090,3078113,3078129,3079673,3079750,3079774,3079783,3081397,3081420,3081432,3083036,3083059,3083075,3084662,3084688,3084702,3086318,3086340,3086357,3087960,3087986,3087994,3089593,3089615,3089629,3091217,3091239,3091252,3092825,3092850,3092863,3094427,3094454,3094462,3096018,3096044,3096056,3097603,3097629,3097639,3099177,3099206,3099216,3100750,3100777,3100788,3102309,3102337,3102347,3103879,3103895,3105418,3105429,3106971,3106982,3108515,3108526,3110084,3110094,3111655,3113202,3177292,3177708,3178683,3179105,3180155,3180577,3181623,3182045,3183089,3183503,3184552,3184815,3184968,3186013,3186276,3186429,3187470,3187733,3187886,3188921,3189184,3189337,3190366,3190628,3190782,3191807,3192071,3192223,3193243,3193507,3193705,3194934,3195198,3195395,3196719,3196982,3197181,3198694,3198958,3199155,3200661,3200925,3201078,3202360,3202623,3202776,3204052,3204313,3204469,3205743,3206006,3206159,3207430,3207691,3207845,3209110,3209373,3209525,3211043,3211199,3212762,3212918,3214470,3214621,3216165,3216318,3217856,3218012,3219544,3219700,3221223,3221379,3222889,3223052,3224554,3224718,3226183,3226346,3227804,3227961,3229416,3229578,3231041,3231201,3232659,3232819,3234264,3234427,3235863,3236027,3237451,3237611,3239017,3239180,3240587,3240748,3242190,3242351,3243778,3243940,3245363,3245522,3246965,3247125,3248552,3248711,3250119,3250280,3251686,3251845,3253243,3253449,3254844,3255138,3256854,3256958,3257150,3258864,3258969,3259160,3260865,3260964,3261156,3262846,3262948,3263139,3264825,3264929,3265120,3266803,3266905,3267115,3268786,3268892,3269119,3270837,3270939,3271212,3272963,3273068,3273336,3275074,3275176,3275446,3277167,3277271,3277538,3279258,3279358,3279630,3281392,3281493,3281763,3283521,3283620,3283699,3283721,3283893,3285638,3285743,3285822,3285840,3286012,3287787,3287892,3287971,3287987,3288161,3289926,3290025,3290103,3290122,3290297,3292040,3292140,3292221,3292242,3292411,3294142,3294246,3294326,3294343,3294518,3296245,3296345,3296424,3296446,3296617,3298339,3298439,3298518,3298537,3298711,3300424,3300522,3300603,3300622,3300794,3302495,3302600,3302679,3302697,3302873,3304559,3304662,3304740,3304759,3304935,3306608,3306710,3306792,3306808,3306982,3308654,3308756,3308837,3308853,3309028,3310695,3310797,3310876,3310894,3311072,3312731,3312831,3312907,3312927,3313099,3314750,3314852,3314927,3314945,3315119,3316761,3316861,3316938,3316958,3317130,3318762,3318862,3318939,3318959,3319131,3320747,3320851,3320927,3320944,3321118,3322733,3322837,3322912,3322929,3323102,3324883,3324984,3325061,3325079,3325249,3327150,3327251,3327328,3327346,3327521,3329537,3329639,3329718,3329734,3329908,3331922,3332022,3332100,3332118,3332289,3334287,3334388,3334465,3334483,3334656,3336639,3336738,3336816,3336837,3337009,3338988,3339087,3339165,3339187,3339357,3341330,3341346,3341357,3341431,3341507,3341530,3341700,3343665,3343683,3343698,3343767,3343845,3343863,3344037,3346025,3346042,3346051,3346126,3346202,3346224,3346395,3348376,3348392,3348402,3348478,3348554,3348572,3348745,3350731,3350739,3350813,3350892,3350909,3351082,3353054,3353065,3353138,3353214,3353234,3353406,3355373,3355382,3355455,3355535,3355552,3355724,3357700,3357712,3357786,3357864,3357883,3358074,3360048,3360060,3360130,3360210,3360228,3360422,3362422,3362494,3362569,3362587,3362784,3364774,3364847,3364924,3364942,3365138,3367117,3367187,3367264,3367282,3367479,3369516,3369595,3369611,3369808,3371842,3371920,3371938,3372134,3374159,3374238,3374259,3374450,3376472,3376549,3376570,3376765,3378777,3378856,3378874,3379068,3381076,3381152,3381171,3381368,3383344,3383420,3383440,3383636,3385629,3385705,3385728,3385921,3387896,3387974,3387993,3388188,3390156,3390235,3390252,3390448,3392408,3392487,3392505,3392697,3394644,3394724,3394742,3394934,3396868,3396946,3396964,3397156,3399081,3399159,3399176,3399374,3401285,3401361,3401379,3401573,3403474,3403553,3403574,3403764,3405731,3405753,3405946,3407899,3407918,3408115,3410065,3410083,3410281,3412209,3412227,3412422,3414377,3414399,3414593,3416524,3416545,3416741,3418665,3418686,3418882,3420788,3420804,3421001,3422889,3422911,3423105,3424972,3424989,3425185,3427030,3427052,3427245,3429074,3429093,3429288,3431098,3431118,3431311,3433130,3433323,3435129,3435326,3437128,3437320,3439105,3439303,3441266,3443230,3445204,3447358,3449505,3451646,3453776,3455897,3458021,3460144,3462280,3464407,3466557,3468736,3470904,3473062,3475218,3477368,3479515,3481652,3483785,3485908,3488017,3490127,3492161,3492168,3492199,3492255,3494284,3494291,3494321,3494379,3496401,3496407,3496439,3496495,3498560,3498593,3498648,3500705,3500735,3500790,3502872,3502924,3505002,3505013,3505055,3507125,3507139,3507181,3509248,3509260,3509301,3511362,3511373,3511415,3513468,3513481,3513524,3515567,3515578,3515619,3517653,3517664,3517710,3519739,3519752,3519796,3521828,3521872,3523901,3523942,3525961,3526002,3528054,3530117,3530372,3532159,3532420,3534200,3534459,3536241,3536257,3536497,3538268,3538290,3538529,3540291,3540310,3540551,3542361,3542382,3542622,3544419,3544437,3544680,3546461,3546478,3546719,3548499,3548518,3548757,3550546,3550606,3550790,3552589,3552647,3552830,3554620,3554681,3554868,3556661,3556718,3556907,3558687,3558743,3558930,3560755,3560942,3562758,3562944,3564763,3564947,3566781,3566964,3568792,3568977,3570809,3570994,3572820,3573006,3574832,3575016,3576739,3576925,3578645,3578828,3580540,3580729,3582435,3582587,3584293,3584451,3586153,3586308,3588006,3588159,3589859,3590013,3591862,3593705,3595689,3597682,3599658,3601616,3603566,3605502,3607427,3609347,3611254,3613152,3615075,3616991,3618895,3620798,3622694,3624586,3626465,3628333,3630198,3632057,3633907,3635749,3637586,3639410,3641222,3643025,3644819,3646603,3648383,3650154,3651915,3653662,3655399,3657134,3658852,3660576,3662300,3664012,3665719,3667414,3669104,3670782,3672456,3674119,3807826,3808202,3808575,3816945,3816958,3816975,3817306,3817323,3817655,3817672,3818039,3818057,3818078,3818460,3818481,3818858,3818880,3819247,3819269,3819640,3819660,3820046,3820427,3820807,3821184,3821553)) 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





	David Zaleyev (Dancer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters David Zaleyev (Dancer)

David Zaleyev (Dancer)

Honoured Artist of the Republic of North Ossetia-Alania
• Prize-winner at the XII International Ballet and Choreography Competition in Moscow (1st prize, Gold Medal and special prize “For art and stage charm”,  2013)
• Prize-winner at the XII International Ballet Competition Arabesque (2nd prize, special prize for his performance of a contemporary work and the prize “For emotionality and expressiveness”; Perm, 2012)
• Prize-winner at the Yuri Grigorovich World Youth Ballet International Competition (Grand Prix; Sochi, 2012)
• Recipient of the Republic of Tatarstan’s theatre prize Tintin in the category “Best performer in musical theatre” (2013)

From 2000-2005 he trained at the Vaganova Academy of Russian Ballet.
In 2008 he graduated from the Bashkirian College of Dance (class of Nail Sarvarov).
From 2008 to 2013 he was a soloist with the Tatar Academic Musa Jalil Opera and Ballet Theatre, where he appeared in the ballets Swan Lake (Pas de trois), The Sleeping Beauty (Dйsirй, the Blue Bird), La Bayadиre (Golden Idol, Drummer, Indian Dance), Le Corsaire (Isaak Lankedem), The Nutcracker (Prince, choreography by Vasily Vainonen), La Fille mal gardйe (Alain, choreography by Oleg Vinogradov), The Arabian Nights (Roc Bird, choreography by Nailja Nazirova), Spartacus (Four Sirtakis) and The Golden Horde (the Spirit of Khan Batu, choreography by Georgy Kovtun).
Joined the Mariinsky Ballet in 2013.

Repertoire includes:
La Sylphide (James, Youths); choreography by August Bournonville, revised version by Elsa-Marianne von Rosen,
La Bayadиre (Golden Idol); choreography by Marius Petipa, revised version by Vladimir Ponomarev and Vakhtang Chabukiani,
Swan Lake (the Prince’s Friends); choreography by Marius Petipa and Lev Ivanov, revised version by Konstantin Sergeyev,
Le Corsaire (Ali, Lankendem); production by Pyotr Gusev after the composition and choreography by Marius Petipa,
Le Carnaval (Harlequin); choreorraphy by Michel Fokine,
The Nutcracker (Nutcracker Prince, Classical Trio); choreography by Vasily Vainonen
Romeo and Juliet (Troubadour); choreography by Leonid Lavrovsky,
George Balanchine’s ballets Symphony in C (IV. Allegro vivace), Jewels (Emeralds),
Spartacus (Gaul); choreography by Leonid Yakobson,
The Legend of Love (Dance of the Jesters); choreography by Yuri Grigorovich
and Anna Karenina (Levin); choreography by Alexei Ratmansky.

Repertoire also includes:
pas de deux from the ballet Flames of Paris; choreography by Vasily Vainonen
and Intensio (Intensifier); choreography by Yuri Smekalov.