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
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Artem Ovcharenko (Dancer)

Artem Ovcharenko (Dancer)

Biography

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)