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,8430,8463,8500,10108,10137,10164,10198,11691,11720,11747,11781,13274,13303,13330,13364,14653,14682,14709,14713,14719,14751,16106,16135,16161,16167,16174,16203,16946,16982,17018,17054,17090,17716,17745,17771,17777,17784,17813,19172,19175,19182,19207,20625,20650,22109,22133,23563,23587,25022,25049,26756,26813,27634,27740,29084,29148,30970,30997,32513,34111,37157,37191,38706,38746,38777,40154,40193,40224,41600,41700,42996,43092,43120,44354,44452,44476,45706,45804,45828,47051,47149,47173,48393,48489,48517,49727,49822,49851,51148,51179,52467,52498,53782,53812,55091,55121,56394,56420,57755,57785,59829,59855,61893,61916,63948,63971,65995,66018,68040,68063,70082,70105,72119,72142,74149,74172,76167,76190,78177,78200,80183,80206,82182,82205,84175,84198,86160,86183,88138,88161,90106,90129,92087,94040,95989,97928,99857,101777,105645,105672,105708,107539,107566,107602,109425,109453,109489,111302,111329,111366,113170,113198,113235,115031,115059,115096,116907,116935,116972,118782,118810,118847,120657,120680,120716,122522,122546,122582,124380,124404,124440,126252,126289,128092,128129,129921,129958,131750,131787,133583,133620,135408,135444,137229,137265,139046,139084,140894,142695,144485,146265,148036,149794,153325,153418,153807,155056,155149,155538,156776,156870,157259,158487,158581,158970,160213,160306,160696,161940,162033,162423,163658,163768,164174,165510,165915,167241,167646,168961,169367,170673,171079,172377,172784,174071,174478,175754,176161,177427,177834,179090,179497,180744,181150,182391,182797,184031,184438,185667,186069,187289,187691,188901,189302,190501,190906,192090,192495,193668,194076,196422,196888,197736,198204,198236,198427,199053,199521,199553,199744,200370,200838,200870,201061,202052,202520,202552,202743,203723,204192,204224,204415,205397,205896,205925,206123,207095,207594,207623,207821,209282,209311,209509,210943,210978,211171,212459,212500,212704,213999,214039,214243,215535,215575,215779,217066,217106,217310,218595,218635,218839,220118,220158,220362,221402,221440,221637,221677,221881,222916,222954,223151,223191,223395,224425,224462,224660,224700,224904,225930,225969,226169,226210,226415,227435,227475,227675,227716,227920,228934,228973,229174,229215,229419,230919,230958,231159,231199,231404,232914,232953,233154,233194,233399,234904,234943,235143,235184,235389,236889,236928,237128,237169,237374,238864,238902,239102,239143,239348,240830,240866,241068,241109,241314,242791,242827,243029,243070,243275,244747,244784,244989,245030,245236,246701,246738,246940,246982,247188,248648,248685,248887,248929,249135,250590,250629,250831,250873,251079,252575,252612,252814,252856,253062,254545,254586,254788,254830,255036,256510,256550,256753,256798,257003,258472,258511,258713,258755,258974,260437,260477,260680,260722,260943,262397,262437,262640,262682,262903,264364,264404,264606,264648,264869,266323,266364,266566,266608,266829,268275,268316,268517,268559,268780,270257,270458,270500,270721,272196,272397,272442,272660,274129,274153,274330,274375,274593,276062,276087,276264,276309,276527,277992,278012,278196,278236,278454,279868,279889,280072,280113,280331,281736,281756,281940,281981,282199,283595,283615,283799,283840,284057,285452,285472,285656,285697,285914,287326,287511,287551,287768,289174,289327,289341,289352,289394,289612,291007,291165,291176,291188,291233,291509,292903,293061,293072,293084,293129,293407,294950,294961,294973,295017,295294,296830,296841,296853,296897,297175,298704,298718,298731,298771,299050,300574,300588,300602,300642,300923,302466,302477,302490,302533,302811,304348,304358,304374,304415,304693,306280,306290,306306,306347,306625,308204,308214,308230,308271,308549,310122,310132,310148,310189,310467,312036,312046,312062,312103,312381,313945,313955,313971,314012,314290,315850,315860,315876,315917,316195,317748,317758,317774,317815,318093,319638,319648,319664,319705,319983,321517,321528,321543,321584,321862,323387,323398,323413,323454,323732,325282,325292,325308,325349,325637,327182,327192,327209,327248,327546,329081,329091,329107,329148,329443,330972,330982,330998,331039,331336,332858,332869,332884,332925,333222,334733,334744,334759,334800,335097,336599,336610,336624,336666,336963,338465,338476,338491,338533,338844,340346,340356,340373,340415,340774,342270,342280,342297,342302,342339,342698,344192,344205,344219,344225,344263,344622,346108,346121,346135,346141,346179,346545,348015,348028,348042,348048,348086,348452,349905,349918,349932,349938,349976,350342,351786,351795,351809,351816,351855,352223,353661,353674,353687,353694,353731,354100,355535,355546,355560,355567,355604,355983,357412,357424,357437,357444,357481,357860,359319,359330,359344,359351,359388,359767,361218,361229,361243,361250,361287,361668,363110,363122,363136,363142,363178,363558,365002,365020,365025,365061,365441,366882,366898,366904,366939,367321,368760,368773,368780,368819,369198,370630,370646,370652,370689,371069,372510,372517,372553,372933,374365,374371,374407,374788,376210,376216,376252,376633,378051,378087,378468,379884,379920,380301,381748,382129,383571,383951,385383,385766,387194,387574,389002,389385,390806,391186,392606,392986,394400,394762,394780,396191,396553,396572,398338,398357,400118,400134,401888,401904,403646,403662,405404,405420,407156,407172,408903,408919,410643,410658,412410,412425,414167,414183,415910,415926,417648,417667,419390,419407,421121,421139,422851,422870,424576,424594,426290,426309,427989,428007,429683,429701,431397,431415,433101,433118,434797,434816,436491,436509,438174,438192,439842,439860,441499,441517,443141,443159,444772,444789,446394,446411,448007,448026,449609,449627,451200,451219,452790,452809,454378,454397,455958,455977,457363,457375,457532,457551,458930,458941,459102,459118,460486,460497,460658,460674,462034,462045,462205,462222,463586,463597,463757,463774,465131,465145,465305,465322,466673,466687,466847,466864,468371,468385,468550,468567,470074,470085,470259,470274,471636,471810,471825,473178,473349,473367,474758,474931,474947,476506,476524,478011,478081,478099,479578,479649,479670,481146,481893,482631,483365,484107,484858,485603,486341,487065,487780,488490,489205,489914,490616,491314,492001,492679,493361,494038,494710,495375,497384,497415,497461,498848,498879,498925,500302,500333,500381,501756,501788,501835,503250,503281,503328,504727,504757,504806,506204,506236,506278,507673,507706,507750,509139,509169,509219,510603,510633,510682,512058,512095,512138,513508,513537,513586,514978,515008,515059,516441,516472,516521,517926,517975,519376,519419,520818,520861,522254,522298,523683,523730,525101,525149,526554,527958,529361,530764,532156,533543,534979,536400,537830,539254,539301,539309,539380,539399,540670,540717,540725,540796,540819,542141,542151,542157,542224,542248,543583,543594,543599,543668,543694,545052,545064,545069,545138,545164,546506,546516,546523,546591,546617,547966,547978,547979,548047,548073,549417,549429,549435,549498,549524,550860,550872,550878,550941,550967,552307,552313,552377,552402,553732,553738,553801,553826,555154,555218,555241,556624,556648,558032,558050,559428,559451,560821,560843,562202,562227,563584,563608,564960,564982,566322,566344,567679,567701,569035,569057,570383,570405,571717,571743,573097,573120,574469,574493,575854,577212,578564,579905,581238,583945,583970,584014,585259,585287,585326,586566,586595,586637,587873,587901,587940,589168,589197,589236,590808,590838,590877,592415,592427,592455,592494,594047,594056,594081,594124,595754,595785,595824,597475,597513,599156,599194,600827,600867,602504,602543,604172,604210,605830,605868,607517,609156,610843,612526,614197,614251,615859,615913,615940,616041,617509,617562,617589,617690,619146,619196,619227,619324,620775,620827,620854,620956,622450,622481,622578,624064,624095,624192,625689,625720,625817,627303,627334,627433,628907,628939,629038,630503,630534,630634,632092,632123,632223,633676,633707,633807,635249,635280,635380,636811,636842,636940,638364,638399,638493,639938,640031,641468,641561,642987,643084,644497,644595,646003,646100,647505,647603,649088,650585,652064,653540,655011,656461,657908,659357,660799,662226,663644,665059,666465,667900,669324,670759,672187,673605,675010,693904,693946,694014,695152,695194,695262,696385,696426,696494,697645,697711,698852,698917,700049,700114,701238,701308,702434,702502,703619,703689,704793,704863,706020,707164,708295,709417,710562,711703,712840,713969,715083,716184,717278,859643,859662,859678,862360,862379,862394,865066,865086,865101,867781,867796,870464,870480,873147,873162,875830,875845,875864,875876,875917,875938,878517,878531,878551,878563,878604,878623,881215,881235,881247,881288,881307,883900,883921,883933,883974,883993,886595,886608,886649,886668,889261,889273,889315,889334,891923,891934,891977,891996,894578,894589,894632,894651,897243,897286,897305,899898,899934,899955,902535,902571,902597,905203,905228,907820,907845,910434,910459,913047,913067,915678,915698,918381,918402,921074,921095,921177,921198,921207,921231,923774,923854,923873,923887,923911,926468,926547,926568,926578,926606,929185,929264,929281,929295,929318,931895,931973,932001,932024,934602,934680,934709,934731,937385,937414,937436,940116,940144,940167,942834,942862,942885,945539,945567,945590,948241,948269,948292,950947,950975,950998,953646,953674,953698,956336,956364,956388,959013,959040,959064,961668,961695,961719,964306,964338,964359,966942,966974,967000,969574,969606,969632,972202,972234,972260,974822,974853,974880,977434,977465,977492,980041,980072,980099,982663,982690,985250,985272,987874,987896,990493,990515,993107,993132,995714,995736,995806,995819,995830,995851,998309,998331,998401,998414,998425,998446,1000893,1000915,1000985,1000998,1001009,1001030,1003474,1003496,1003566,1003579,1003590,1003611,1006076,1006139,1006152,1006163,1006184,1008643,1008709,1008720,1008730,1008751,1011202,1011268,1011279,1011292,1011310,1013782,1013848,1013859,1013872,1013890,1016344,1016411,1016423,1016435,1016454,1018961,1018972,1018985,1019004,1021508,1021519,1021532,1021551,1024053,1024064,1024077,1024096,1026587,1026598,1026611,1026628,1029117,1029128,1029141,1029158,1031643,1031655,1031666,1031684,1034146,1034158,1034168,1034187,1036636,1036647,1036658,1036677,1039125,1039136,1039147,1039166,1041609,1041620,1041631,1041650,1044085,1044096,1044107,1044125,1046552,1046563,1046574,1046592,1049008,1049020,1049031,1049049,1051450,1051463,1051475,1051493,1053883,1053893,1053904,1053923,1056310,1056319,1056331,1056350,1058731,1058741,1058756,1058772,1061150,1061165,1061181,1063550,1063565,1063581,1065948,1065959,1065975,1068341,1068363,1070710,1070731,1073110,1073131,1075524,1077907,1080278,1080405,1082637,1082765,1082787,1085110,1085131,1087439,1087460,1089758,1089780,1092088,1092110,1094410,1094432,1096720,1096741,1099017,1099038,1101294,1101315,1103565,1103585,1105814,1105834,1108042,1108067,1110249,1110274,1112435,1112459,1114604,1114627,1116759,1116780,1118891,1118914,1121025,1121046,1123162,1123186,1125295,1125318,1127487,1127509,1129707,1129730,1131911,1131937,1134126,1136329,1136453,1136473,1138531,1138655,1138675,1140729,1140853,1140873,1142920,1143044,1143064,1145103,1145227,1145247,1147396,1147416,1149552,1149572,1151705,1151725,1153852,1153873,1155992,1156013,1158165,1158186,1160326,1160346,1162472,1162493,1164606,1164627,1166736,1166756,1168870,1168890,1170995,1171016,1173111,1173132,1175223,1175243,1177363,1177383,1179493,1179513,1181619,1181639,1183733,1183754,1185840,1185860,1187947,1187969,1190051,1190072,1192144,1192166,1194228,1194246,1196305,1196324,1198377,1198395,1200441,1200460,1202496,1202516,1204574,1206617,1208648,1210689,1279539,1279557,1281388,1281405,1283228,1283245,1285057,1285075,1286880,1286894,1288682,1288696,1290469,1290482,1292281,1292294,1294087,1294105,1295886,1295904,1297677,1297691,1299458,1299472,1301238,1302992,1304738,1306485,1330820,1332701,1334569,1336435,1338287,1340124,1341945,1343757,1345565,1347369,1349161,1350945,1352843,1367732,1369538,1371337,1373123,1374899,1376752,1378586,1400371,1402121,1403858,1405583,1407307,1409035,1410765,1412261,1412296,1412331,1412488,1414024,1414059,1414098,1414251,1415813,1415852,1416005,1417555,1417594,1417747,1419286,1419324,1419476,1421006,1421044,1421196,1422716,1422753,1422906,1424411,1424448,1424601,1426131,1426284,1427799,1427952,1429456,1429614,1431101,1431253,1432735,1432892,1434357,1434513,1436124,1437752,1439366,1440969,1442565,1444156,1445734,1447255,1447303,1448813,1448862,1450358,1450408,1451891,1451941,1453410,1453462,1454927,1454977,1456432,1456482,1457930,1457981,1459416,1459472,1460888,1460944,1462401,1463850,1465290,1466717,1468132,1469534,1470920,1472296,1716123,1716196,1716214,1718893,1718965,1718987,1721651,1721720,1721742,1724393,1724462,1724484,1727132,1727200,1727223,1729864,1729932,1729954,1732576,1732644,1732666,1735279,1735348,1735370,1737973,1738043,1738065,1740657,1740728,1740747,1743320,1743391,1743414,1745982,1746053,1746076,1748706,1748729,1751349,1751372,1753987,1754011,1756616,1756640,1759234,1759257,1761839,1761862,1764440,1764463,1767040,1767058,1769629,1769648,1772209,1772228,1774779,1774801,1777348,1777369,1779904,1779922,1782451,1782469,1784989,1785007,1787517,1787535,1790018,1790035,1792527,1794995,1797444,1847867,1850018,1852164,1854303,1856441,1858568,1860687,1862802,1864913,1867014,1869101,1871181,1873247,1875302,1877355,1879430,1881497,1883556,1915720,1917932,1920133,1922332,1924518,1926771,1929012,1931241,1933455,1935654,1937850,1940039,1942218,1944389,1946550,1948699,1950834,1952966,1955088,1957164,1959229,1961283,1963321,1965346,1967370,1969386,1971141,1971400,1973153,1973407,1975148,1975407,1977136,1977391,1979105,1979364,1981105,1981360,1983352,1985339,1987313,1989283,1991238,1993181,1995116,1997044,1998969,2000883,2002786,2004673,2006552,2008434,2010319,2012197,2014063,2015903,2017725,2019540,2021347,2023148,2024938,2026934,2028924,2030903,2032864,2034827,2036779,2038724,2040662,2042588,2044502,2046396,2048289,2050168,2052042,2053909,2055860,2057892,2059925,2061952,2063972,2065982,2067984,2068032,2069990,2070038,2071981,2072030,2073965,2074012,2075937,2075984,2077896,2077944,2079942,2081932,2083919,2085844,2087758,2089667,2091570,2093466,2095351,2104987,2106938,2108878,2110807,2112779,2112801,2114685,2114706,2116583,2116608,2118475,2118500,2120355,2120381,2122226,2122252,2124087,2124112,2125936,2125956,2127769,2127794,2129598,2129623,2131419,2131443,2133254,2135055,2136845,2138686,2446923,2449839,2452747,2455632,2458515,2461383,2464240,2467092,2469964,2472901,2475804,2475868,2475949,2478746,2478809,2478888,2481670,2481733,2481811,2484643,2484721,2487547,2487627,2490489,2490569,2493419,2493498,2496339,2496418,2499247,2499327,2502141,2502222,2505020,2505102,2507888,2507970,2510751,2510832,2513611,2513693,2516465,2516547,2519317,2519398,2522152,2522234,2525061,2527876,2530686,2533490,2536287,2539077,2541868,2544649,2547414,2550178,2552978,2555773,2558580,2561375,2564158,2566927,2566945,2567050,2567073,2569732,2569749,2569856,2569878,2572562,2572581,2572686,2572703,2575378,2575395,2575505,2575523,2578203,2578314,2578333,2581012,2581124,2581142,2583804,2583914,2583932,2586685,2586709,2589457,2589474,2592218,2592237,2594972,2594991,2597718,2597742,2600459,2600476,2603181,2603199,2605888,2605907,2608594,2608612,2611292,2611316,2614020,2614038,2616744,2616761,2619456,2619474,2622158,2622176,2624842,2624860,2627523,2627541,2630195,2630213,2632856,2632874,2635519,2635532,2635582,2638161,2638177,2638223,2640793,2640808,2640852,2643408,2643424,2643470,2646017,2646033,2646083,2648628,2648675,2651214,2651261,2653790,2653839,2656355,2656405,2658950,2661473,2663984,2666480,2668955,2671409,2673856,2678719,2678747,2678771,2681101,2681129,2681153,2683473,2683505,2683523,2685842,2685867,2685891,2688198,2688224,2688247,2690549,2690578,2690597,2692913,2692935,2695236,2695259,2697894,2697924,2700968,2700998,2704050,2704080,2707122,2707152,2710188,2713223,2716247,2719312,2722386,2807772,2810716,2813640,2816556,2819536,2822506,2825488,2828457,2831408,2834338,2837261,2840188,2840788,2843105,2843706,2844544,2845145,2846573,2847992,2849400,2852255,2853675,2855089,2856499,2857902,2859298,2860685,2862061,2864838,2867615,2868992,2870371,2871749,2873121,2874485,2875842,2877188,2878103,2878532,2879475,2879904,2882251,2882680,2885016,2885445,2887757,2888186,2890485,2890914,2893199,2893628,2895891,2896320,2898576,2899008,2901706,2904375,2906651,2906973,2909237,2909561,2911846,2912170,2914437,2914761,2917022,2917346,2919603,2919926,2922170,2922493,2924726,2925055,2927273,2927602,2929801,2930130,2932311,2932640,2934818,2934921,2935146,2937313,2937416,2937649,2939814,2939917,2940150,2942311,2942414,2942512,2942532,2942647,2944901,2944999,2945019,2945135,2947371,2947469,2947489,2947605,2949820,2949918,2949938,2950054,2952260,2952364,2952381,2952500,2954705,2954803,2954823,2954945,2957186,2957289,2957309,2957431,2959661,2959764,2959784,2959906,2962123,2962226,2962246,2962368,2964561,2964664,2964684,2964806,2966981,2967084,2967104,2967226,2969395,2969498,2969518,2969640,2971813,2971916,2971936,2972059,2974205,2974308,2974328,2974451,2976689,2976709,2976832,2979056,2979075,2979197,2981436,2981455,2981577,2983804,2983823,2983948,2986169,2986188,2986313,2988550,2988570,2988693,2990922,2990942,2991065,2993290,2993310,2993433,2995645,2995665,2995788,2997983,2998003,2998126,3000303,3000323,3000446,3002621,3002641,3002764,3004917,3004937,3005060,3007169,3007292,3009356,3009479,3011537,3011659,3013816,3015959,3018098,3020291,3022120,3023590,3025057,3026509,3027951,3029382,3030808,3030857,3030873,3032228,3032271,3032291,3033630,3033675,3033692,3035222,3035267,3035284,3036850,3036867,3038418,3038436,3039978,3039995,3041528,3041544,3043071,3043087,3044609,3044625,3046143,3046156,3047659,3047674,3049180,3050688,3052192,3056741,3058204,3059653,3061090,3062830,3064565,3064631,3066281,3066355,3067995,3068064,3069692,3069762,3071378,3071447,3073059,3073127,3074727,3074795,3076388,3076452,3078037,3078110,3079698,3079769,3081350,3081416,3082984,3083054,3084611,3084681,3086265,3086338,3087910,3087977,3088268,3089613,3089902,3091235,3091526,3092844,3093134,3094443,3094737,3096039,3096328,3097624,3097913,3098291,3099197,3099491,3099494,3099871,3100769,3101063,3101442,3102326,3102623,3103001,3103877,3104170,3104547,3105409,3105704,3106084,3106962,3107257,3107637,3108506,3108804,3109217,3110375,3110786,3111932,3112344,3113479,3113892,3115013,3115425,3116534,3116946,3118046,3118460,3119558,3119970,3121062,3121474,3122591,3123002,3124288,3124698,3125970,3126385,3127644,3128059,3129308,3129723,3130964,3131379,3132611,3132661,3132686,3132740,3133027,3134251,3134301,3134326,3134380,3134667,3135891,3135941,3135966,3136020,3136307,3137524,3137574,3137599,3137653,3137940,3139145,3139195,3139220,3139274,3139561,3140757,3140807,3140832,3140886,3141173,3142361,3142411,3142436,3142490,3142777,3143955,3144005,3144030,3144084,3144371,3145545,3145595,3145620,3145674,3145961,3147125,3147175,3147200,3147254,3147541,3147761,3147811,3147836,3147890,3148177,3148391,3148441,3148466,3148520,3148807,3149015,3149065,3149090,3149144,3149431,3149639,3149689,3149714,3149768,3150055,3151186,3151236,3151261,3151315,3151602,3152725,3152775,3152800,3152854,3153141,3154258,3154308,3154333,3154387,3154674,3155781,3155831,3155856,3155910,3156197,3157297,3157347,3157372,3157426,3157713,3158804,3158854,3158879,3158933,3159220,3160298,3160348,3160373,3160427,3160714,3161783,3161833,3161858,3161912,3162199,3163260,3163310,3163335,3163389,3163677,3164732,3164782,3164807,3164861,3165149,3166195,3166245,3166270,3166324,3166633,3167640,3167679,3167700,3167743,3168033,3169034,3169073,3169094,3169137,3169427,3170419,3170458,3170479,3170522,3170812,3171796,3171835,3171856,3171899,3172189,3173167,3173206,3173227,3173270,3173560,3174532,3174571,3174592,3174635,3174924,3175933,3175973,3175994,3176037,3176326,3177331,3177371,3177392,3177435,3177724,3178721,3178761,3178781,3178824,3179131,3180193,3180233,3180253,3180296,3180603,3181661,3181701,3181721,3181764,3182071,3183127,3183167,3183187,3183230,3183522,3184590,3184630,3184650,3184693,3184728,3184987,3186051,3186091,3186111,3186154,3186189,3186448,3187508,3187548,3187568,3187611,3187646,3187905,3188959,3188999,3189019,3189062,3189097,3189356,3190406,3190442,3190466,3190503,3190542,3190801,3191846,3191883,3191907,3191948,3191980,3192242,3193286,3193319,3193342,3193381,3193413,3193742,3194977,3195010,3195033,3195071,3195106,3195433,3196762,3196795,3196818,3196856,3196891,3197219,3198733,3198769,3198793,3198833,3198867,3199194,3200704,3200739,3200762,3200803,3200837,3201097,3202399,3202437,3202460,3202498,3202535,3202795,3204094,3204130,3204153,3204190,3204228,3204488,3205781,3205818,3205841,3205883,3205918,3206178,3207473,3207508,3207527,3207567,3207602,3207865,3209153,3209188,3209207,3209249,3209281,3209545,3210821,3210859,3210881,3210924,3210958,3211218,3212544,3212577,3212600,3212641,3212678,3212937,3214245,3214284,3214303,3214346,3214379,3214641,3215940,3215976,3216000,3216038,3216076,3216337,3217636,3217670,3217694,3217733,3217766,3218031,3219323,3219358,3219382,3219419,3219459,3219719,3221003,3221036,3221061,3221098,3221133,3221398,3222669,3222696,3222704,3222727,3222743,3222754,3222768,3222804,3223072,3224335,3224362,3224370,3224391,3224409,3224417,3224432,3224470,3224739,3225963,3225991,3225997,3226022,3226036,3226046,3226059,3226093,3226368,3227605,3227612,3227637,3227652,3227662,3227677,3227712,3227984,3229221,3229230,3229254,3229269,3229279,3229292,3229329,3229601,3230844,3230855,3230877,3230891,3230903,3230918,3230949,3231224,3232462,3232470,3232494,3232510,3232518,3232533,3232570,3232840,3234072,3234077,3234100,3234117,3234127,3234140,3234178,3234449,3235671,3235677,3235699,3235717,3235728,3235741,3235776,3236048,3237255,3237261,3237283,3237300,3237311,3237323,3237359,3237632,3238823,3238832,3238855,3238869,3238882,3238895,3238929,3239202,3240392,3240398,3240423,3240439,3240449,3240463,3240496,3240769,3242002,3242023,3242042,3242050,3242065,3242098,3242372,3243594,3243618,3243635,3243645,3243658,3243691,3243963,3245199,3245215,3245226,3245241,3245277,3245545,3246804,3246819,3246830,3246845,3246876,3247147,3248388,3248406,3248416,3248430,3248463,3248733,3249958,3249975,3249984,3249997,3250033,3250303,3251525,3251540,3251550,3251565,3251598,3251868,3253098,3253109,3253125,3253156,3253471,3254698,3254708,3254722,3254761,3255189,3256709,3256720,3256734,3256768,3257201,3258721,3258732,3258746,3258782,3259212,3260728,3260742,3260778,3261209,3262710,3262726,3262761,3263190,3264690,3264704,3264741,3265172,3266684,3266718,3267165,3268668,3268703,3268728,3269193,3270715,3270751,3270779,3271283,3272841,3272880,3272905,3273409,3274991,3275016,3275517,3277083,3277109,3277612,3279170,3279199,3279703,3281306,3281333,3281835,3283431,3283460,3283669,3283764,3283965,3285552,3285580,3285791,3285884,3286085,3287702,3287725,3287936,3288032,3288233,3289834,3289859,3290074,3290167,3290369,3291979,3292187,3292283,3292485,3294083,3294295,3294389,3294590,3296185,3296391,3296486,3296690,3298278,3298487,3298581,3298783,3300357,3300566,3300664,3300867,3302435,3302648,3302743,3302943,3304500,3304709,3304804,3305006,3306755,3306855,3307054,3308801,3308901,3309100,3310842,3310940,3311141,3312876,3312972,3313169,3314897,3314989,3315189,3316909,3317002,3317199,3318910,3319001,3319202,3320893,3320989,3321188,3322880,3322974,3323173,3325030,3325120,3325321,3327298,3327391,3327592,3329688,3329778,3329980,3332063,3332161,3332360,3334430,3334527,3334728,3336787,3336878,3337078,3339130,3339226,3339428,3341474,3341572,3341770,3343814,3343909,3344107,3346173,3346263,3346465,3348523,3348616,3348817,3350861,3350955,3351154,3353181,3353278,3353478,3355498,3355596,3355797,3357831,3357926,3357988,3357993,3358005,3358147,3360179,3360270,3360333,3360337,3360350,3360500,3362540,3362633,3362693,3362696,3362710,3362861,3364894,3364987,3365048,3365050,3365065,3365215,3367233,3367326,3367388,3367392,3367406,3367557,3369562,3369655,3369719,3369722,3369734,3369887,3371888,3371980,3372043,3372046,3372059,3372212,3374207,3374301,3374361,3374365,3374379,3374528,3376514,3376611,3376673,3376675,3376690,3376842,3378824,3378919,3378978,3378985,3378997,3379148,3381120,3381215,3381277,3381279,3381293,3381445,3383391,3383483,3383546,3383549,3383561,3383714,3385672,3385770,3385830,3385833,3385846,3385997,3387939,3388035,3388099,3388103,3388114,3388269,3390203,3390295,3390359,3390362,3390376,3390526,3392454,3392549,3392608,3392615,3392627,3392777,3394691,3394786,3394845,3394849,3394863,3395016,3396915,3397007,3397067,3397070,3397085,3397238,3399127,3399220,3399283,3399289,3399299,3399451,3401326,3401422,3401485,3401489,3401501,3401653,3403521,3403616,3403677,3403681,3403693,3403846,3405702,3405793,3405857,3405860,3405873,3406026,3407865,3407963,3408025,3408026,3408040,3408206,3410035,3410127,3410188,3410193,3410205,3410373,3412179,3412270,3412334,3412339,3412351,3412516,3414342,3414439,3414501,3414503,3414517,3414685,3416494,3416587,3416648,3416655,3416665,3416834,3418635,3418728,3418789,3418796,3418806,3418975,3420757,3420849,3420912,3420917,3420929,3421095,3422951,3423013,3423017,3423030,3423198,3425032,3425094,3425100,3425110,3425279,3427091,3427153,3427158,3427170,3427336,3429134,3429195,3429201,3429213,3429380,3431158,3431220,3431223,3431239,3431404,3433169,3433230,3433236,3433249,3433415,3435172,3435234,3435240,3435251,3435419,3437168,3437230,3437235,3437247,3437414,3439148,3439212,3439215,3439228,3439394,3441116,3441177,3441182,3441195,3441362,3443080,3443141,3443144,3443157,3443322,3445057,3445115,3445118,3445132,3445299,3447208,3447269,3447274,3447285,3447450,3449355,3449415,3449422,3449432,3449596,3451494,3451555,3451560,3451570,3451738,3453627,3453687,3453691,3453702,3453870,3455745,3455806,3455808,3455821,3455988,3457872,3457931,3457937,3457947,3458113,3459996,3460057,3460060,3460071,3460240,3462131,3462192,3462194,3462208,3462377,3464255,3464318,3464324,3464334,3464500,3466405,3466468,3466470,3466484,3466650,3468647,3468653,3468664,3468831,3470815,3470819,3470831,3470996,3472971,3472974,3472987,3473154,3475126,3475133,3475143,3475309,3477281,3477285,3477296,3477463,3479427,3479430,3479442,3479608,3481565,3481569,3481580,3481742,3483696,3483700,3483712,3483873,3485818,3485820,3485833,3485996,3487928,3487935,3487945,3488108,3490038,3490041,3490052,3490214,3492166,3492170,3492182,3492345,3492440,3494289,3494293,3494303,3494465,3494562,3496405,3496409,3496419,3496580,3496678,3498556,3498562,3498573,3498734,3498831,3500707,3500717,3500877,3500973,3502852,3503013,3503109,3504983,3505144,3505240,3507108,3507271,3507365,3509228,3509389,3509488,3511505,3511601,3513611,3513707,3515709,3515804,3517796,3517892,3519884,3519980,3521962,3522057,3524032,3524126,3526094,3526190,3528145,3528241,3530203,3530299,3530361,3532249,3532345,3532409,3534241,3534289,3534386,3534449,3536279,3536327,3536424,3536486,3538309,3538360,3538456,3538515,3540331,3540380,3540477,3540540,3542402,3542452,3542547,3542612,3544458,3544509,3544603,3544666,3546500,3546548,3546644,3546709,3548537,3548585,3548681,3548746,3550570,3550619,3550713,3550779,3552612,3552658,3552756,3552819,3554645,3554694,3554790,3554854,3556685,3556731,3556829,3556892,3558710,3558757,3558852,3558919,3560720,3560769,3560865,3560931,3562724,3562771,3562867,3562933,3564724,3564775,3564871,3564933,3566743,3566792,3566889,3566952,3568755,3568803,3568901,3568964,3570774,3570824,3570919,3570984,3572831,3572927,3572992,3574846,3574942,3575007,3576754,3576850,3576911,3578657,3578752,3578814,3580555,3580650,3580716,3582443,3582519,3582577,3584305,3584378,3584437,3586162,3586235,3586294,3588016,3588090,3588149,3589866,3589942,3589999,3591716,3591789,3591849,3593562,3593636,3593695,3595510,3595610,3595676,3596100,3597604,3597667,3598091,3599581,3599643,3600066,3601540,3601602,3602027,3603486,3603552,3603976,3605424,3605490,3605912,3607352,3607416,3607839,3609269,3609333,3609758,3611179,3611241,3611665,3613073,3613139,3613566,3614995,3615060,3615488,3616911,3616978,3617400,3617471,3618821,3618883,3619311,3619378,3620719,3620786,3621208,3621283,3622619,3622683,3623109,3623181,3624512,3624577,3625001,3625073,3626387,3626453,3626880,3626951,3628255,3628323,3628745,3628820,3630120,3630183,3630609,3630681,3631979,3632042,3632467,3632540,3633830,3633893,3634319,3634392,3635671,3635736,3636161,3636236,3637508,3637573,3637997,3638072,3639331,3639397,3639821,3639896,3641144,3641207,3641632,3641705,3642947,3643010,3643437,3643509,3644806,3645229,3645303,3646594,3647019,3647090,3648373,3648798,3648869,3650141,3650569,3650641,3651900,3652325,3652398,3653646,3654071,3654145,3655390,3655814,3655885,3657121,3657544,3657618,3658841,3659266,3659343,3660563,3660986,3661072,3662287,3662714,3662798,3664000,3664428,3664512,3665705,3666128,3666216,3667403,3667826,3667913,3669089,3669513,3669601,3671192,3671280,3672866,3672952,3674533,3674618,3676188,3676272,3677830,3677915,3679469,3679554,3681102,3681189,3682734,3682819,3684360,3684444,3685979,3686063,3687584,3687672,3689188,3689272,3690784,3690869,3692374,3692459,3693958,3694042,3695531,3695617,3697100,3697188,3698658,3698743,3700199,3700285,3701739,3701825,3703272,3703358,3704797,3704882,3706314,3706402,3707825,3707912,3709321,3709407,3710808,3710895,3712294,3712379,3713768,3713856,3715239,3715326,3716704,3716791,3718164,3718252,3719618,3719706,3721066,3721152,3722510,3722596,3723945,3724031,3725372,3725460,3726796,3726883,3728215,3728301,3729625,3729710,3731023,3731112,3732420,3732506,3733802,3733890,3735177,3735266,3736546,3736634,3737913,3737999,3739265,3739351,3740607,3740695,3741945,3742033,3743275,3743363,3744598,3744685,3745912,3746000,3747221,3747308,3748522,3748607,3749811,3749899,3751093,3751182,3752368,3752455,3753634,3753723,3754896,3754981,3756151,3756235,3757406,3757492,3758649,3758737,3759889,3759976,3761122,3761210,3762347,3762433,3763568,3763655,3764785,3764872,3765996,3766081,3767198,3767284,3768393,3768479,3769579,3769667,3769974,3770059,3770360,3770447,3770749,3770834,3771129,3771217,3771508,3771597,3771889,3771973,3772261,3772350,3772634,3772722,3773004,3773089,3773368,3773455,3773740,3773825,3774106,3774193,3774471,3774558,3774834,3774921,3775195,3775282,3775554,3775641,3775911,3775998,3776264,3776351,3776612,3776699,3776964,3777051,3777313,3777400,3777658,3777745,3777998,3778085,3778333,3778420,3778663,3778750,3778988,3779075,3779318,3779405,3779644,3779731,3779965,3780052,3780281,3780368,3780596,3780683,3780907,3780994,3781212,3781299,3781512,3781599,3781809,3781896,3782101,3782188,3782389,3782476,3782672,3782759,3782957,3783044,3783239,3783326,3783518,3783605,3783794,3783881,3784066,3784153,3784337,3784424,3784603,3784690,3784865,3784952,3785123,3785210,3785378,3785465,3785630,3785748,3785964,3786082,3786295,3786413,3786645,3786763,3786991,3787109,3787333,3787451,3787672,3787790,3788007,3788125,3788340,3788458,3788669,3788787,3788995,3789113,3789318,3789436,3789636,3789754,3789952,3790070,3790265,3790383,3790576,3790694,3790883,3791001,3791187,3791305,3791488,3791606,3791785,3791903,3792080,3792198,3792372,3792490,3792661,3792779,3792948,3793066,3793231,3793349,3793510,3793628,3793785,3793903,3794058,3794176,3794445,3794711,3794975,3795237,3795496,3795750,3796017,3796282,3796544,3796803,3797058,3797308,3797552,3797794,3798032,3798267,3798499,3798730,3798956,3799176,3799395,3799611,3799825,3800036,3800245,3800450,3800653,3800855,3801055,3801252,3801446,3801637,3801823,3802001,3802178,3802353,3802525,3802694,3802861,3803024,3803180,3803334,3816958,3817306,3817655,3818039,4035094,4035452,4036354,4037254,4038169,4125921,4125936,4126610,4126621,4127294,4127307,4127974,4127989,4128668,4129341,4130014,4130683,4132024,4132695,4133367,4134029,4134694,4135361,4136020)) 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





	Anastasia Kolegova (Dancer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Anastasia Kolegova (Dancer)
			

																
Anastasia Kolegova (Dancer)

														
				


        




    

        Prize-winner at International competition
Principal Dancer of The Hermitage and Palace Theatres
      
Biography
Anastasia Kolegova was born February 9, 1982 in Cheliabinsk. She graduated from the Vaganova Academy of Russian Ballet.
Has appered with numerous ballet companies since 2000, such as the St Petersburg Konstantin Tachkin Ballet Company, the Lithuanian National Opera and Ballet Theatre (Vilnius), the St Petersburg Boris Eifman Ballet and the Mariinsky Theatre.In 2006 she joined the troupe of the famed Mariinsky Theater as a soloist.
Since 2004 – She has been the leading soloist of the Hermitage Ballet Theater. 
She is the Laureate of many international ballet competitions. During her career Anastasia toured many countries in the world including Japan, Germany, Great Britain, Switzerland, Belgium, Holland, and other Eastern European countries.
Anastasia Kolegova was blessed with all of the qualities necessary to become an outstanding ballet dance. She possesses a superior ballet technique, beauty and special charm that enables this ballerina to stand out among others. Her expressive, graceful movements, and refined technique conquer the harts of ballet aficionados. She is able to transfer her emotions and positive energy to the audience. Anastasia stands out because she works very hard, has true persistence and is ever striving for perfection. She is always very will received by the balletomanes, art critics and press. 

Repertoire:

"Giselle'', Adolphe Adam
Giselle, Myrtha
Choreography: Jean Coralli, Jules Perrot and Marius Petipa; 


''Le Corsair'',  Adolphe Adam, Cesare Pugni, Leo Delibes, Riccardo Drigo and Pavel Oldenburgsky
Medora, Gulnara
Choreography: Pyotr Gusev;  


''Sleeping Beauty'', Pyotr Tchaikovsky
Princess Aurora
Choreography: Marius Petipa


''Swan Lake'', Pyotr Tchaikovsky
Odette-Odille
Choreography: Marius Petipa and Lev Ivanov, revised choreography and stage direction: Konstantin Sergeyev; 


"Don Quixote", Ludwig Minkus
Kitri, Queen Dryad, Variation from IV act
Choreography: Alexander Gorsky; 


"Pas de quatre", Cesare Pugni 
Fanny Cerrito
Choreography: Jules Perrot ;


"Apollo", Igor Stravinsky
Calliope
Choreography: George Balanchine;


"La Valse", Maurice Ravel
Soloist
Choreography: George Balanchine


"The Dying Swan", Camille Saint-Saens
Choreography: Mikhail Fokine 
        

    

    

            


			

		





	


	

	

		


			

				

					Deals & Discounts 
					Subscribe to our email newsletter
				



				
				


			

			

		

		

	

	




 



	

		

			
    		

    

        

		
		
Award-winning
Group Tour Packages

        

        

		
Useful Links &
Company Information

        

        

        
    
		

	





	

		

			
© 2001 – 2024 by Northern Crown, Ltd. uVisitRussia and uVisitRussia.com are registered trademarks. Terms & Conditions  Privacy Policy