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 (382828,382829,384647,384648,386459,386460,421911,421912,421928,421932,421933,423640,423641,423657,423661,423662,425363,425364,425379,425383,425384,427070,427071,427087,427091,427092,428767,428768,428785,428789,428790,430460,430461,430478,430482,430483,432167,432168,432185,432189,432190,433871,433875,433889,433892,433893,435566,435570,435584,435587,435588,437257,437258,437271,437275,437276,438933,438934,438947,438951,438952,440597,440598,440611,440615,440616,442248,442249,442262,442266,442267,443883,443884,443900,443904,443905,445513,445514,445527,445531,445532,447135,447136,447149,447153,447154,448743,448744,448758,448762,448763,450355,450359,450360,451946,451950,451951,453536,453540,453541,455122,455126,455127,456700,456704,456705,458272,458276,458277,459836,459840,459841,461391,461395,461396,462939,462943,462944,464491,464495,464496,466038,466042,466043,467583,467584,467616,469288,469289,469321,471036,472585,474127,475707,477284,478858,480425,481177,481922,482659,483393,484135,484884,485627,486357,487078,487792,487807,488504,488519,489216,489231,489923,489938,490638,491333,492018,492701,493383,494058,494727,501098,501159,501167,502547,502606,502614,504031,504089,504097,505509,505569,505577,506979,507037,507045,508451,508509,508517,509918,509976,509984,511439,511447,512891,512899,514370,514378,515840,515848,517301,517309,518752,518760,520195,520203,521637,521645,523070,523078,524495,524503,525912,525920,527319,527327,528725,528733,530128,530137,531526,531535,532916,532925,534354,534363,535785,535795,537212,537221,538640,538649,540061,540069,541473,541481,542932,544409,568441,568449,569795,569803,571138,571146,572520,572528,573901,573908,575270,575277,576630,576637,577986,577993,579336,579343,580674,580681,582010,583340,586002,586013,587311,587322,588612,588623,589915,589931,591535,591551,593174,593190,594877,594895,596574,596592,598263,598278,599936,599954,601635,603307,604970,642149,642157,643665,643673,645178,645187,646689,648184,652707,654179,655640,657091,658546,659986,661421,662845,664262,665672,667111,688088,689387,690673,691949,693215,874364,877044,879726,882406,885089,887759,890424,893084,895742,898391,901038,903674,906298,908913,911524,914161,916871,919571,919697,919715,922383,922401,925083,925102,927776,927795,930489,930508,933194,933214,935903,935923,938621,938642,941345,941365,944056,944077,946760,946785,949467,949487,952167,952189,954866,954886,957543,957565,960204,960227,962851,962877,965489,965511,968121,968143,970760,970779,973382,973402,975991,976013,978605,978625,981203,981224,983793,983812,986419,986439,989041,989061,991662,991682,994266,994286,996866,996885,999472,1002054,1002111,1002124,1004640,1004692,1004702,1007209,1007261,1007271,1009767,1009823,1009836,1012376,1012386,1014946,1014960,1017502,1017512,1020049,1020059,1022592,1022605,1025132,1025142,1027663,1027673,1030187,1030198,1032699,1032709,1035204,1037692,1037744,1037745,1037800,1037837,1037840,1040177,1040229,1040230,1040285,1040322,1040325,1042707,1042708,1042763,1042799,1042802,1045178,1045179,1045234,1045271,1045273,1047639,1047640,1047695,1047731,1047733,1050089,1050090,1050146,1050179,1050181,1052523,1052524,1052582,1052615,1052629,1054950,1054956,1055014,1055047,1055057,1057376,1057382,1057440,1057473,1057483,1059795,1059801,1059859,1059892,1059902,1062201,1062202,1062260,1062294,1062295,1064597,1064603,1064661,1064694,1064704,1067048,1067088,1067091,1069419,1069452,1069455,1071785,1071821,1071825,1071840,1074185,1074226,1074229,1074246,1076573,1076606,1076616,1076634,1078949,1078982,1078992,1079010,1081310,1081346,1081347,1081367,1083662,1083697,1083699,1083719,1086002,1086033,1086038,1086054,1088325,1088357,1088361,1088380,1090695,1090705,1090723,1093019,1093022,1093042,1095337,1095347,1095365,1097637,1097647,1097665,1097738,1097762,1099937,1100020,1100044,1102209,1102292,1102316,1104550,1104574,1106787,1106811,1109003,1109027,1111198,1111222,1113375,1113399,1115533,1115557,1117674,1117698,1119809,1119833,1121939,1121963,1124077,1124101,1126296,1128486,1130699,1132895,1135085,1137290,1139490,1152667,1152668,1154811,1154819,1156956,1156957,1159117,1159118,1161274,1161275,1163414,1163415,1165544,1165545,1167683,1167684,1169811,1169812,1171933,1171935,1174050,1174051,1176196,1176197,1178331,1178332,1180459,1180460,1182578,1182579,1184688,1184689,1186796,1186797,1188902,1188903,1191001,1191002,1193089,1193090,1195168,1195169,1197244,1197245,1199313,1199314,1201374,1201375,1203432,1203433,1205477,1205478,1207514,1207515,1209543,1209544,1211588,1211589,1213613,1213614,1215635,1215636,1217644,1217645,1227633,1229647,1231658,1233653,1235638,1237621,1239589,1241545,1243528,1245501,1276653,1276680,1276691,1276708,1276715,1278512,1278538,1278547,1278564,1278572,1280365,1280388,1280397,1280416,1280423,1282206,1282234,1282244,1282261,1282268,1284042,1284068,1284077,1284094,1284102,1285866,1285892,1285901,1285918,1285926,1287677,1287703,1287712,1287729,1287737,1289471,1289497,1289506,1289523,1289531,1291256,1291282,1291291,1291308,1291316,1293066,1293092,1293101,1293118,1293126,1294868,1294894,1294903,1294920,1294928,1296663,1296689,1296698,1296715,1296723,1298475,1298484,1298501,1298509,1300246,1300255,1300272,1300280,1302003,1302014,1302031,1302039,1303754,1303763,1303780,1303788,1305502,1305511,1305528,1305536,1307251,1307268,1307276,1308981,1308998,1309006,1310716,1310724,1312635,1312643,1314552,1314560,1316486,1316494,1318421,1320340,1558481,1559479,1560837,1562186,1564029,1565862,1567687,1570612,1573505,1576383,1579257,1582117,1584964,1587802,1590637,1593462,1596319,1599190,1602051,1604898,1607741,1610571,1613396,1616217,1619020,1783773,1786304,1786305,1788809,1788810,1791303,1791304,1793779,1793780,1796236,1796237,1798688,1798690,1801139,1801140,1803584,1803585,1806009,1806010,1808431,1808432,1810824,1810825,1835868,1838058,1838085,1840238,1840265,1842398,1842425,1844543,1844569,1846683,1846710,1848836,1848863,1851012,1853155,1855291,1857424,1859545,1861662,1861677,1861684,1863775,1863792,1863797,1865885,1865900,1865907,1865943,1865961,1867975,1867990,1867997,1868033,1868051,1870074,1870080,1870118,1870136,1872148,1872155,1872191,1872209,1874209,1874215,1874251,1874271,1876263,1876269,1876305,1876325,1878315,1878322,1878358,1878376,1880395,1880431,1880449,1882459,1882495,1882513,1884550,1884568,1886626,1886645,1888692,1888710,1890752,1890770,1892815,1892840,1894887,1894912,1896970,1896995,1899105,1899130,1901253,1901278,1903390,1903415,1905517,1905545,1907663,1907689,1909820,1909845,1911993,1914158,1916374,1918583,1920780,1922977,1925183,2115710,2115712,2117605,2117607,2117636,2117684,2117709,2117737,2119492,2119494,2119523,2119571,2119596,2119624,2121369,2121371,2121400,2121448,2121473,2121501,2123236,2123238,2123267,2123315,2123340,2123368,2125119,2125167,2125192,2125220,2126960,2127008,2127033,2127061,2128794,2128842,2128867,2128895,2128910,2128911,2130620,2130668,2130693,2130721,2130736,2130737,2132436,2132484,2132509,2132537,2132552,2132553,2134243,2134291,2134316,2134344,2134359,2134360,2136085,2136110,2136138,2136153,2136154,2137868,2137893,2137922,2137939,2137940,2139712,2139737,2139765,2139780,2139781,2141546,2141571,2141599,2141614,2141615,2143371,2143396,2143424,2143439,2143440,2145185,2145210,2145238,2145253,2145254,2146989,2147014,2147042,2147057,2147058,2148783,2148808,2148836,2148851,2148852,2150563,2150588,2150616,2150631,2150632,2152355,2152383,2152398,2152399,2154113,2154141,2154156,2154157,2155862,2155890,2155905,2155906,2157600,2157628,2157643,2157644,2159327,2159355,2159370,2159371,2161109,2161124,2161125,2162848,2162863,2162864,2164577,2164592,2164593,2166298,2166313,2166314,2168001,2168016,2168017,2169707,2169708,2170491,2170492,2171270,2171271,2323349,2323404,2326487,2326542,2329617,2329672,2332728,2332783,2335830,2335885,2338926,2338981,2342022,2342077,2345129,2345184,2348228,2348283,2351324,2351379,2354443,2354498,2357550,2357605,2360651,2360706,2363746,2363801,2366831,2366886,2369960,2373025,2376075,2379113,2382145,2382196,2385172,2385223,2388187,2388238,2391249,2391300,2394305,2394356,2397348,2397399,2400377,2400428,2403395,2403446,2406409,2406460,2409465,2412460,2415446,2418460,2421462,2424453,2427439,2430416,2433384,2436363,2436377,2439309,2439323,2442244,2442258,2445170,2445179,2445184,2445209,2448091,2448100,2448105,2448130,2451010,2451015,2451040,2451058,2451063,2453913,2453918,2453943,2453961,2453966,2456797,2456802,2456827,2456845,2456850,2459706,2459724,2459729,2462570,2462588,2462593,2465425,2465443,2465448,2468302,2468320,2468325,2471240,2471258,2471263,2474154,2474172,2474177,2477115,2477120,2480047,2480052,2482965,2482970,2485873,2485878,2488781,2512082,2514937,2517787,2520630,2523462,2526282,2529095,2531903,2534704,2537498,2540292,2543076,2545849,2548614,2551419,2551432,2551441,2554215,2554228,2554237,2557026,2557039,2557048,2559827,2559840,2559849,2559871,2559879,2559885,2562616,2562629,2562638,2562660,2562668,2562674,2565390,2565409,2565410,2565436,2565445,2565446,2568156,2568175,2568176,2568202,2568211,2568212,2570988,2571001,2571010,2571032,2571040,2571046,2573834,2573856,2573864,2573870,2576648,2576670,2576678,2576684,2579452,2579472,2579479,2579485,2582269,2582276,2582282,2585051,2585058,2585064,2587822,2587829,2587835,2590590,2590597,2590603,2593349,2593356,2593362,2596107,2596113,2598849,2598855,2631372,2634039,2636685,2639319,2641940,2644549,2649817,2649848,2649855,2649948,2649978,2652396,2652427,2652434,2652527,2652557,2654963,2654994,2655001,2655094,2655124,2657515,2657546,2657553,2657646,2657676,2660049,2660080,2660087,2660180,2660210,2662564,2662595,2662602,2662695,2662725,2665065,2665096,2665103,2665196,2665226,2667583,2667590,2667683,2667713,2670046,2670053,2670146,2670176,2672497,2672504,2672597,2672627,2675028,2675058,2677440,2677470,2679832,2679862,2682208,2682238,2684575,2684605,2686937,2686967,2689292,2689322,2691636,2691666,2693964,2693994,2696302,2696338,2699385,2699423,2702455,2702493,2705531,2705569,2708578,2708616,2711659,2714690,2717710,2720775,2723883,2726982,2730069,2733168,2754763,2757710,2757783,2760731,2760804,2763747,2763820,2766746,2766819,2769730,2769803,2772703,2772776,2775668,2775741,2778657,2778730,2781638,2781711,2784726,2784799,2787885,2790955,2794013,2797088,2800150,2800179,2803205,2803234,2806179,2806208,2809135,2809164,2812069,2812098,2814991,2815020,2815037,2817974,2818003,2818020,2820979,2820996,2823931,2823951,2823968,2826927,2826944,2829886,2829903,2832845,2835772,2838706,2841630,2880907,2880916,2883679,2883688,2886437,2886446,2889171,2889180,2891894,2891903,2894597,2894606,2897286,2897295,2899983,2899992,2902674,2902683,2905258,2905267,2907850,2907859,2907895,2910467,2910476,2910512,2913065,2913074,2913110,2915653,2915662,2915698,2918243,2918252,2918288,2920816,2920825,2920861,2923381,2923390,2923426,2925936,2925945,2925981,2928517,2931036,2933544,2936044,2938552,2941055,2943549,3096759,3098340,3099917,3101483,3103034,3104576,3106115,3107664,3110828,3112381,3113920,3139768,3141377,3142977,3144571,3146156,3150233,3151777,3153314,3154842,3156362,3157874,3159374,3160863,3162345,3163821,3165288,3166770,3168167,3168199,3168226,3168304,3169554,3169586,3169613,3169691,3170934,3170966,3170993,3171071,3172308,3172340,3172367,3172445,3173676,3173708,3173735,3173813,3175036,3175068,3175095,3175173,3176437,3176469,3176496,3176574,3177833,3177865,3177892,3177970,3179307,3179339,3179366,3179444,3180777,3180809,3180836,3180914,3182244,3182276,3182303,3182381,3183705,3183737,3183764,3183842,3185168,3185200,3185227,3185305,3186626,3186658,3186685,3186763,3188080,3188112,3188139,3188217,3189527,3189559,3189586,3189664,3190970,3191002,3191029,3191107,3192409,3192441,3192468,3192546,3194102,3194134,3194161,3194239,3195789,3195821,3195848,3195926,3197572,3197604,3197631,3197709,3199542,3199574,3199601,3199679,3201243,3201275,3201302,3201380,3202937,3202969,3202996,3203074,3204629,3204661,3204688,3204766,3206317,3206349,3206377,3206455,3207999,3208031,3208059,3208137,3209673,3209706,3209728,3209815,3211343,3211376,3211398,3211485,3213052,3213085,3213107,3213194,3214752,3214784,3214812,3214890,3216446,3216478,3216506,3216584,3218169,3218197,3218275,3219853,3219881,3219959,3221528,3221556,3221622,3221634,3223200,3223228,3223294,3223306,3224835,3224863,3224929,3224941,3226457,3226485,3226551,3226563,3228071,3228099,3228165,3228177,3229714,3229782,3229794,3231331,3231391,3231399,3231411,3232944,3233004,3233012,3233024,3234546,3234606,3234614,3234626,3234646,3236193,3236201,3236213,3236233,3237768,3237776,3237788,3237808,3239337,3239345,3239357,3239377,3240900,3240908,3240920,3240940,3242498,3242506,3242518,3242538,3244084,3244092,3244104,3244124,3245660,3245668,3245680,3245700,3247251,3247259,3247271,3247291,3248828,3248836,3248848,3248868,3250396,3250404,3250416,3250436,3251960,3251968,3251980,3252000,3253557,3253565,3253577,3253597,3255561,3255573,3255593,3257576,3257588,3257608,3259589,3259609,3261597,3263579,3265559,3267547,3267588,3267600,3269599,3269640,3269652,3271723,3271737,3273838,3273852,3275937,3275951,3278027,3278041,3280114,3280129,3282244,3282259,3284368,3284383,3286505,3288645,3313689,3315703,3317707,3319701,3321687,3323670,3325727,3325747,3325814,3327996,3328016,3328083,3330399,3330466,3332769,3332836,3335193,3337543,3339889,3339955,3342228,3342294,3344589,3344655,3346941,3347007,3349284,3349350,3351612,3351678,3353933,3353999,3356251,3356317,3358599,3358665,3360964,3361030,3363321,3363387,3365665,3365731,3368001,3368067,3370329,3370395,3372716,3375030,3375117,3377339,3377426,3379639,3379727,3381922,3382010,3384187,3384293,3386461,3386567,3388721,3388827,3390975,3391081,3393324,3395553,3397769,3399976,3402170,3402188,3402242,3404353,3404371,3404425,3406525,3406543,3406597,3408698,3408716,3408770,3410849,3410867,3410921,3412978,3412996,3413050,3413093,3415150,3415204,3415247,3417292,3417346,3417389,3419478,3419521,3421587,3421630,3423676,3423719,3425743,3425786,3427791,3427834,3429865,3431879,3431922,3431942,3433886,3433929,3433949,3435886,3435929,3435949,3437873,3437916,3437936,3439846,3439889,3439909,3441812,3441855,3441875,3443774,3443817,3443825,3443837,3445788,3445796,3445808,3447939,3447947,3447959,3450082,3450090,3450102,3452217,3452225,3452237,3454341,3454349,3454361,3456460,3456468,3456480,3456491,3458584,3458592,3458604,3458615,3460714,3460723,3460736,3460749,3462844,3462853,3462866,3462879,3464994,3465003,3465016,3465029,3467138,3467147,3467160,3467173,3469320,3469333,3469346,3471482,3471495,3471508,3473636,3473649,3473662,3473683,3475792,3475805,3475818,3475839,3477955,3477968,3477989,3480097,3480110,3480131,3482229,3482242,3482263,3482269,3482321,3484369,3484390,3484396,3484448,3486487,3486508,3486514,3486566,3488596,3488618,3488624,3488676,3490729,3490751,3490757,3490809,3492855,3492877,3492883,3492935,3494997,3495003,3495055,3497154,3497160,3497212,3499301,3499307,3499359,3501441,3501447,3501499,3503574,3503580,3503600,3503616,3503631,3503648,3505702,3505708,3505728,3505744,3505759,3505776,3507825,3507831,3507851,3507867,3507882,3507899,3509947,3509967,3509983,3509998,3510015,3512059,3512079,3512095,3512110,3512127,3514181,3514197,3514212,3514229,3516275,3516291,3516306,3516323,3518362,3518378,3518393,3518410,3520448,3520464,3520479,3520496,3522522,3522538,3522553,3522570,3524590,3524606,3524621,3524638,3526662,3526677,3526694,3528727,3528742,3528759,3530794,3530811,3532836,3532853,3534876,3534893,3536909,3536926,3538952,3540991,3543052)) 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
Artem Ovcharenko (Dancer) - uVisitRussia
Artem Ovcharenko was born in Dnepropetrovsk, Ukraine). He began to study dance at Dnepropetrovsk Ballet School, then he entered the Moscow Choreographic Academy (class of Alexander Bondarenko). In 2007, after graduation from MCA he joined the Bolshoi Ballet Company where he started to rehearse with Nikolai Tsiskaridze. Now his master-repetiteur is Nikolai Fadeyechev.
Repertoire
2007
Policmen(Cipollino. Music by Karen Khachaturyan. Genrikh Mayorov production) French Doll (Nutcracker. Yuri Grigorovich production)
2008
Soloist (Class Concert to music by A.Glazunov, A. Lyadov, A. Rubinstein, D. Shostakovich; choreography by Asaf Messerer) Fisherman (Cesare Pugni’s La Fille du Pharaon; Pierre Lacotte production after Marius Petipa) Bluebird (The Sleeping Beauty by P.Tchaikovsky, choreography by M. Petipa, Y. Grigorovich’s version) The Nutcracker-Prince (Nutcracker, by P. Tchaikovsky, choreography by Y. Grigorovich) Soloist part III (Symphony C-major to music by G. Bizet, choreography by G. Balanchine)
2009
Frantz (Coppelia by Lйo Delibes Choreography by M. Petipa and Enrico Cecchetti; revival and new choreographic version by Sergei Vikharev) Grand Pas (Raimonda by A.Glazunov. Choreography by M. Petipa in the version of Y. Grigorovich) James (Herman Levenskiold’s La Sylphide; choreography by August Bournonville in a version by Johan Kobborg) Little Count Cherry (Cipollino) Albert (creator of the role at Bolshoi Theatre), Phoebus (Cesare Pugni’s La Esmeralda; Choreography by M. Petipa, production and new choreographic version by Y. Burlaka, V. Medvedev)
2010
Romeo (Romeo and Julie by S. Prokofiev. Production by Y. Grigorovich) Petrushka (Petrushka, by I. Stravinsky choreography by M. Fokin, new choreographic version by S. Vikharev) Jean de Brienne (Raimonda by A.Glazunov. Choreography by M. Petipa in the version of Y. Grigorovich) Lord Wilson/Taor (La Fille du Pharao by C. Pugni, Pierre Lacotte production after Marius Petipa) — debut on Bolhsoi Theatre’s tour in Beijing
2011
Count Albrecht (Giselle by A. Adam; choreography by Jean Coralli, Jules Perrot, Marius Petipa in the version by Yuri Grigorovich) Antoine Mistral (Boris Asfiev’s The Flames of Paris. Production and new choreography by Alexei Ratmansky after Vasily Vainonen) 1st Ballet Dancer (Illusions perdues. Music by Leonid Desyatnikov, choreography by Alexei Ratmansky) — creator of the role at Bolshoi Theatre Role in Chroma ballet, music by Joby Talbot and Jack White (choreography by Wayne McGregor) — appeared in the opening night performance in Bolshoi Theater Role in The Symphony of Psalms to music by I. Stravinsky (choreography by Jiri Kylian) — appeared in the opening night performance in Bolshoi Theater Prince Desire (The Sleeping Beauty)
2012
Student (Anyuta to music of V. Gavrilin, choreography by V. Vassiliev) Prince Siegfried (Swan Lake by P.Tchaikovsky, choreography in the second version by Yuri Grigorovich) Soloist in Dance with Fans (Le Corsaire Adolphe Adam; choreography Marius Petipa, production and new choreography by Alexei Ratmansky and Yuri Burlaka) Two couples (Classical Symphony to music of S. Prokofiev, choreography by Y. Possokhov) Duet (Dream of Dream to music of S. Rachmaninoff, choreography by J. Elo)
In 2009 he took part in the opening night performance of G. Getty’s The Oath of the Ushers (choreography by V. Vassiliev) on the New Scene of the Bolshoi Theater as part of the Russian National Orchestra festival. He danced Edgar.
Tours
In 2011 he appeared as Phoebus in La Esmeralda (production by Y. Burlaka and V. Medvedev) with the State Ballet of Berlin (Esmeralda — Yana Salenko)
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.