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 (8418,10124,11707,13290,14784,16237,17847,19238,20679,22163,23617,25081,26883,27897,29220,31029,32503,32548,34069,35545,38831,40281,41589,41623,42984,43017,44346,44376,45698,45728,47073,48414,49746,51074,52393,53708,55017,56320,56462,57825,59895,61958,64014,66060,68104,70146,72183,74213,76231,78241,80247,82245,84238,86224,88203,90171,92129,94082,96031,97970,99898,101819,103728,105628,105695,107522,107589,107772,107971,107978,109409,109475,109659,109858,109865,111286,111352,111536,111735,111742,113155,113221,113406,113605,113612,115016,115082,115267,115466,115472,116892,116958,117143,117344,117348,118832,119018,119219,119223,120705,120889,121090,121094,122570,122755,122956,122960,124428,124613,124814,124818,126277,126462,126663,126667,128117,128302,128503,128506,129946,130130,130332,130335,131775,131959,132161,132164,133608,133792,133994,133997,135433,135617,135819,135822,137254,137438,137640,137643,139071,139256,139458,139461,140881,141066,141268,141271,142682,142867,143069,143072,144472,144657,144859,144862,146252,146436,146639,146642,148023,148211,148410,148413,149969,150168,150174,151719,151918,151924,153292,153298,153460,153659,153665,155027,155191,155390,155396,156912,157111,157117,158623,158822,158828,160349,160547,160554,162076,162274,162281,163814,164026,164029,165561,165767,165770,167292,167498,167504,169013,169219,169225,170725,170931,170937,172429,172636,172642,174123,174329,174336,175807,176013,176020,177480,177686,177693,179143,179349,179356,180797,181002,181009,182444,182649,182656,184084,184290,184297,185715,185920,185927,187337,187542,187549,188949,189154,189161,190549,190754,190761,192138,192343,192350,193716,193924,193930,195269,195651,196033,196475,196704,196714,196805,197787,198018,198028,198121,198375,198407,198461,199104,199335,199345,199438,199692,199724,199778,200421,200652,200662,200755,201009,201041,201095,202103,202334,202344,202437,202691,202723,202777,203775,204006,204016,204109,204363,204394,204451,205422,205447,205680,205689,205783,206069,206101,206155,207123,207145,207378,207387,207480,207767,207799,207853,208810,208834,209065,209075,209168,209455,209487,209541,210498,210729,210739,210831,211119,211149,211206,212193,212237,212242,212344,212653,212682,212739,213729,213772,213777,213879,214192,214221,214278,215264,215308,215313,215415,215728,215757,215814,216795,216839,216844,216946,217259,217288,217345,218324,218368,218373,218475,218788,218817,218874,219847,219890,219896,219998,220311,220340,220397,221366,221409,221415,221517,221830,221859,221916,222880,222923,222929,223031,223344,223373,223430,224389,224432,224438,224540,224853,224881,224939,225893,225937,225943,226051,226363,226392,226449,227399,227442,227448,227556,227869,227897,227955,228898,228941,228947,229055,229368,229396,229453,230883,230926,230932,231040,231353,231381,231438,232877,232921,232927,233035,233348,233376,233433,234866,234911,234917,235025,235338,235366,235423,236857,236897,236906,237010,237322,237351,237408,238832,238871,238880,238984,239297,239325,239382,240798,240837,240846,240950,241263,241291,241348,242759,242798,242807,242911,243224,243252,243309,244716,244754,244764,244868,245185,245213,245270,246670,246707,246718,246825,247137,247168,247222,248617,248654,248665,248772,249084,249115,249169,250559,250598,250609,250716,251027,251059,251113,252543,252581,252592,252699,253011,253042,253096,254515,254555,254566,254673,254984,255016,255072,256519,256529,256638,256948,256980,257037,258480,258491,258598,258923,258954,259008,260446,260456,260565,260888,260921,260977,262406,262416,262525,262848,262881,262937,264372,264384,264491,264816,264847,264903,266332,266343,266451,266776,266807,266863,268284,268294,268403,268727,268758,268814,270225,270235,270344,270668,270698,270755,272164,272174,272283,272606,272637,272694,274107,274215,274305,274333,274539,274570,274627,276041,276149,276239,276267,276473,276504,276561,278075,278166,278193,278400,278431,278488,279952,280043,280069,280277,280308,280365,281819,281911,281938,282145,282176,282233,283677,283770,283797,284004,284035,284092,285534,285627,285654,285861,285892,285949,287389,287482,287509,287716,287746,287803,289234,289329,289356,289560,289589,289646,291072,291163,291191,291437,291482,291549,292968,293059,293087,293333,293378,293445,294856,294948,294976,295224,295267,295334,296736,296828,296856,297104,297147,297214,298610,298706,298734,298978,299020,299088,300481,300576,300604,300850,300892,300960,302371,302464,302492,302741,302784,302851,304253,304346,304373,304623,304665,304732,306179,306278,306305,306555,306597,306664,308103,308202,308229,308479,308521,308588,310021,310120,310147,310397,310439,310506,311938,312034,312061,312311,312353,312420,313846,313943,313970,314220,314262,314329,315751,315848,315875,316125,316167,316234,317649,317746,317773,318023,318065,318132,319636,319663,319913,319955,320022,321515,321542,321792,321834,321901,323385,323412,323662,323704,323770,325280,325307,325567,325609,325676,327180,327208,327472,327518,327584,329079,329106,329373,329415,329482,330970,330997,331266,331308,331375,332856,332883,333152,333194,333261,334731,334758,335027,335069,335136,336597,336623,336893,336935,337002,338463,338490,338772,338816,338883,340344,340372,340700,340746,340813,342268,342296,342309,342624,342670,342737,344194,344222,344233,344548,344594,344662,346110,346138,346149,346470,346517,346585,348017,348045,348056,348378,348424,348492,349907,349935,349946,350268,350313,350382,351783,351812,351823,352149,352191,352260,353663,353690,353702,354024,354069,354138,355533,355563,355574,355901,355951,356020,357410,357440,357451,357779,357828,357897,359317,359347,359358,359686,359734,359804,361216,361246,361257,361587,361635,361705,363108,363137,363150,363477,363526,363596,365018,365031,365363,365409,365479,366896,366912,367241,367292,367359,368777,368788,369117,369166,369237,370645,370660,370989,371040,371107,372509,372525,372854,372904,372971,374364,374380,374709,374759,374826,376209,376224,376553,376605,376671,378059,378389,378440,378506,379892,380222,380273,380340,381720,382050,382101,382168,383540,383869,383921,383989,385685,385737,385804,387492,387544,387612,389305,389355,389423,391104,391155,391224,392904,392955,393024,394699,394748,394818,396491,396541,396609,398276,398326,398394,400055,400102,400173,401823,401872,401941,403583,403630,403701,405339,405387,405457,407093,407140,407209,408839,408887,408956,410579,410627,410696,412346,412393,412464,414104,414151,414221,415847,415894,415964,417586,417634,417707,419327,419374,419447,421058,421106,421180,422788,422836,422910,424513,424565,424635,426228,426275,426349,427927,427976,428048,429621,429670,429742,431325,431382,431456,433027,433085,433158,434725,434782,434856,436419,436480,436550,438101,438163,438233,439769,439830,439901,441426,441486,441558,443068,443128,443199,444697,444758,444830,446319,446381,446454,447935,447995,448068,449534,449597,449670,451129,451188,451262,452719,452778,452852,454307,454366,454440,455887,455946,456019,457461,457520,457593,459027,459086,459160,460584,460642,460716,462132,462189,462264,463684,463741,463816,465231,465289,465364,466774,466831,466905,468475,468535,468609,470179,470240,470323,471730,471791,471874,473270,473333,473417,474852,474913,474997,476428,476490,476573,478002,478019,478065,478148,479573,479590,479636,479719,481137,481153,481884,481900,482622,482638,483354,483373,484098,484117,484849,484868,485594,485614,486332,486349,487056,487073,487770,487788,488482,488500,489196,489213,489905,489922,490607,490624,491305,491323,491993,492010,492671,492694,493353,493376,494030,494054,494726,495391,496044,496686,497362,497397,497433,497513,498826,498860,498897,498977,500282,500316,500356,500433,501736,501770,501807,501887,503228,503261,503300,503379,504707,504742,504781,504860,506178,506214,506253,506332,507647,507684,507725,507803,509119,509154,509194,509273,509337,510582,510618,510658,510736,510800,512073,512113,512192,512255,513520,513558,513642,513725,514993,515033,515117,515198,516455,516496,516578,516661,517910,517950,518034,518119,519354,519394,519478,519563,520836,520920,521005,522273,522357,522442,523701,523786,523805,523831,523868,525119,525205,525230,525250,525286,526529,526613,526633,526658,526694,527933,528017,528039,528062,528100,529336,529421,529442,529466,529504,530737,530821,530842,530866,530904,532131,532216,532237,532259,532298,533602,533626,533647,533682,535035,535055,535081,535118,536460,536480,536505,536543,537889,537909,537934,537973,539313,539335,539359,539397,540729,540751,540775,540813,542162,542183,542207,542244,543605,543627,543649,543687,545075,545097,545119,545157,546529,546551,546573,546611,547985,548007,548029,548067,549438,549457,549483,549522,550881,550900,550926,550965,552317,552337,552362,552400,553742,553761,553786,553823,555158,555178,555202,555239,556564,556585,556609,556646,557988,558011,558048,559385,559408,559445,560777,560801,560838,562164,562187,562223,563546,563569,563605,564939,564975,566302,566336,567661,567694,569012,569049,570362,570397,571736,573116,574488,575849,577207,578559,579898,579956,581289,582610,583933,584033,585251,585346,586557,586652,587865,587960,589161,589256,590801,590895,592419,592512,594048,594143,595843,597533,599214,600886,602563,604230,605888,607537,609176,610863,612542,614217,615878,617526,619160,620791,622414,624028,625653,627270,638533,640072,641602,643124,644637,646143,647637,649128,650625,652103,653579,655045,656500,657952,659400,660837,662264,663690,665104,666509,667944,669364,670803,672227,673644,675055,676450,677836,679242,680636,682023,683396,684763,693937,694045,695185,695293,696418,696524,697638,697743,698845,698950,700041,700148,701230,701337,702425,702533,703611,703717,704891,706047,707195,708323,709450,710595,711736,712873,714000,715112,716215,717309,718389,719462,720521,721570,722619,736053,737030,737998,738958,739911,741882,743858,745827,747789,749776,751758,753740,756615,759484,762350,765213,768069,770918,773761,776598,779431,782267,785100,787928,790752,793572,796385,799192,801995,804793,807586,810373,813154,815930,818701,821465,824221,826970,829714,832453,835189,837921,840648,843371,846116,848852,851583,854316,857045,859767,862484,865191,867886,870570,873253,875936,878625,881310,883996,886671,889337,891999,894654,897308,899958,902596,902667,905227,905297,907844,907915,910458,910527,910574,910595,913070,913138,913185,913201,915701,915770,915818,915832,918405,918473,918521,918536,921098,921166,921215,921229,923777,923845,923893,923913,926467,926539,926586,926602,929184,929253,929301,929320,931894,931962,932007,932026,934601,934669,934715,934734,937374,937419,937440,940105,940151,940171,942823,942869,942889,945533,945576,945594,948235,948278,948296,950940,950984,951002,953639,953683,953702,956328,956373,956392,959005,959050,959068,961659,961705,961723,964301,964345,964363,966937,966981,966998,969569,969613,969630,972197,972241,972258,974817,974861,974878,977429,977473,977490,980080,980097,982672,982688,985259,985276,985288,987883,987900,987912,990502,990519,990530,993114,993130,993142,995723,995740,995751,998318,998335,998346,1000902,1000919,1000930,1003483,1003500,1003511,1006058,1006074,1006084,1008625,1008641,1008651,1011200,1011210,1013780,1013790,1016345,1016355,1018904,1021451,1023996,1024220,1026531,1026755,1029285,1031689,1031709,1031716,1031811,1034192,1034212,1034219,1034314,1036682,1036702,1036709,1036804,1039171,1039191,1039198,1039293,1039320,1041655,1041674,1041682,1041777,1041804,1044131,1044150,1044158,1044253,1044280,1046598,1046617,1046625,1046720,1046747,1049055,1049074,1049082,1049177,1049204,1051507,1051518,1051529,1051621,1051648,1053937,1053948,1053959,1054051,1054085,1056364,1056375,1056386,1056482,1056512,1058786,1058797,1058808,1058903,1058934,1061195,1061205,1061217,1061312,1061342,1063596,1063605,1063618,1063713,1063743,1065990,1065999,1066012,1066107,1066137,1068370,1068385,1068394,1068489,1068519,1070738,1070755,1070764,1070859,1070887,1073138,1073155,1073163,1073259,1073287,1075531,1075547,1075556,1075652,1075680,1077914,1077930,1077939,1078035,1078060,1080285,1080301,1080309,1080406,1080430,1082645,1082660,1082669,1082766,1082790,1084986,1085005,1085015,1085111,1085135,1087333,1087343,1087440,1087464,1089653,1089662,1089759,1089783,1091983,1091992,1092089,1092113,1094314,1094411,1094435,1096624,1096721,1096745,1099018,1099042,1101295,1101319,1103566,1103590,1105815,1105847,1108044,1108074,1110251,1110281,1112437,1112467,1114606,1114635,1116756,1116789,1118893,1118923,1121022,1121055,1123164,1123193,1125297,1125323,1127489,1127513,1129709,1129741,1131913,1131943,1134134,1136338,1138538,1140735,1142924,1145107,1147277,1256657,1258623,1260578,1262520,1264446,1266370,1268296,1270208,1272114,1274005,1275880,1277739,1279594,1281443,1283283,1285113,1286935,1288737,1290521,1292333,1294140,1295939,1297732,1299513,1301279,1303027,1304779,1306525,1308255,1309984,1311699,1313622,1315556,1317485,1317584,1319408,1319507,1321420,1323325,1325224,1327101,1328963,1330810,1330819,1332692,1332700,1334566,1334570,1336425,1336434,1338276,1338285,1340114,1340122,1341942,1341949,1343754,1343761,1345560,1345569,1347366,1347373,1349158,1349165,1350941,1350948,1352846,1716235,1719005,1721758,1724499,1727238,1729969,1732681,1735385,1738080,1740766,1743428,1746090,1748743,1751391,1754030,1756659,1759277,1761882,1764483,1767079,1769668,1772249,1774822,1777390,1779942,1782489,1785025,1787553,1790052,1792541,1795009,1797459,1799930,1802387,1804824,1807244,1971195,1973201,1975202,1977187,1979159,1981155,1983147,1985134,1987109,1989078,1991033,1992976,1994909,1996838,1998764,2000678,2002582,2112760,2114665,2116561,2118457,2120338,2122207,2124067,2196906,2198433,2199949,2201470,2203010,2204542,2206064,2207593,2209108,2210611,2212104,2213802,2215490,2217173,2218952,2221189,2223414,2225629,2710241,2713274,2716298,2719363,2722437,2725536,2728625,2731710,2734821,2737912,2740994,2744066,2747117,2906663,2909249,2911858,2914449,2917034,2919615,2922182,2924740,2927287,2929815,2932325,2934831,2937326,2939827,2942324,2944811,2957596,2960071,2962533,2964971,2967391,2969806,2972225,2974617,2976998,2979363,2981743,2984114,2986479,2988859,2991231,2993599,2995954,2998292,3000612,3002747,3002930,3005043,3005227,3007275,3007459,3009462,3009650,3011640,3011830,3013797,3013987,3015940,3016132,3018079,3018271,3020272,3020463,3022107,3022232,3023577,3023705,3025044,3025171,3026496,3026621,3027938,3028061,3029369,3029496,3030797,3030832,3030923,3032212,3032250,3032337,3033655,3033744,3035247,3035337,3036829,3036915,3038397,3038484,3039956,3040044,3041507,3041594,3043139,3044676,3046206,3047722,3049231,3050739,3052241,3053733,3055214,3056686,3058145,3059593,3061033,3062776,3064507,3066227,3067935,3088380,3089968,3090014,3091591,3091637,3093202,3093247,3094803,3094848,3096396,3096442,3097979,3098025,3098245,3099558,3099605,3099825,3101133,3101177,3101396,3102688,3102737,3102954,3104235,3104281,3104500,3105772,3105819,3106038,3107326,3107373,3107591,3108890,3108951,3109171,3110459,3110521,3110740,3112021,3112080,3112298,3113569,3113625,3113846,3115099,3115159,3115378,3116621,3116682,3116900,3118135,3118194,3118413,3119647,3119706,3119924,3121147,3121208,3121428,3122679,3122739,3122955,3124375,3124432,3124652,3126060,3126119,3126339,3127734,3127794,3128013,3129399,3129457,3129676,3131055,3131113,3131332,3132702,3132760,3132979,3134342,3134400,3134619,3135982,3136040,3136259,3137615,3137673,3137892,3139236,3139294,3139513,3140848,3140906,3141125,3142452,3142510,3142729,3144046,3144104,3144323,3145636,3145694,3145913,3147216,3147274,3147493,3147852,3147910,3148129,3148482,3148540,3148759,3149106,3149164,3149383,3149730,3149788,3150007,3151277,3151335,3151554,3152816,3152874,3153093,3154349,3154407,3154626,3155872,3155930,3156149,3157388,3157446,3157665,3158895,3158953,3159172,3160389,3160447,3160666,3161874,3161932,3162151,3163351,3163409,3163629,3164823,3164881,3165101,3166286,3166344,3166585,3167713,3167759,3167778,3167985,3169107,3169153,3169172,3169379,3170492,3170538,3170557,3170764,3171869,3171915,3171934,3172141,3173240,3173286,3173305,3173512,3174605,3174650,3174669,3174876,3176007,3176052,3176071,3176278,3177278,3177405,3177450,3177469,3177676,3178669,3178794,3178839,3178858,3179069,3180141,3180266,3180311,3180330,3180541,3181609,3181734,3181779,3181798,3182009,3183075,3183200,3183245,3183264,3183471,3184538,3184663,3184708,3184727,3184936,3185999,3186124,3186169,3186188,3186397,3187456,3187581,3187626,3187645,3187854,3188907,3189032,3189077,3189096,3189305,3190352,3190475,3190525,3190540,3190750,3191792,3191916,3191965,3191983,3192191,3193227,3193353,3193400,3193417,3193653,3194919,3195044,3195093,3195109,3195345,3196704,3196830,3196876,3196894,3197130,3198803,3198850,3198865,3199103,3200772,3200820,3200838,3201047,3202469,3202519,3202536,3202744,3204164,3204212,3204229,3204438,3205854,3205900,3205916,3206128,3207540,3207589,3207600,3207815,3209220,3209268,3209282,3209495,3210895,3210940,3210956,3211168,3212612,3212659,3212674,3212887,3214315,3214365,3214382,3214591,3216010,3216057,3216075,3216287,3217705,3217752,3217771,3217981,3219391,3219438,3219453,3219669,3221072,3221120,3221136,3221348,3222739,3222786,3222805,3223021,3224404,3224449,3224467,3224686,3226034,3226081,3226098,3226314,3227647,3227697,3227711,3227931,3229264,3229314,3229331,3229548,3230890,3230936,3230955,3231171,3232504,3232550,3232565,3232787,3234114,3234160,3234177,3234396,3235712,3235761,3235775,3235995,3237297,3237345,3237361,3237579,3238866,3238915,3238933,3239148,3240434,3240480,3240494,3240715,3242036,3242084,3242103,3242319,3243632,3243677,3243697,3243910,3245213,3245259,3245273,3245492,3246813,3246861,3246875,3247094,3248399,3248449,3248467,3248680,3249970,3250017,3250035,3250250,3251534,3251582,3251601,3251815,3253094,3253141,3253157,3253418,3254696,3254740,3254756,3255070,3256704,3256753,3256767,3256906,3257081,3258765,3258777,3258916,3259092,3260761,3260779,3260913,3261089,3262742,3262762,3262893,3263071,3264722,3264742,3264872,3265051,3266701,3266720,3266852,3267042,3268686,3268704,3268838,3269029,3270733,3270752,3270890,3271117,3272863,3272878,3273016,3273244,3274970,3274989,3275127,3275351,3277063,3277084,3277220,3277447,3279153,3279168,3279305,3279539,3281286,3281307,3281438,3281672,3283412,3283433,3283567,3283670,3283725,3283801,3285549,3285693,3285785,3285845,3285921,3287696,3287837,3287935,3287996,3288070,3289833,3289972,3290072,3290130,3290205,3292086,3292184,3292244,3292319,3294196,3294292,3294350,3294425,3296292,3296392,3296450,3296524,3298389,3298484,3298544,3298617,3300471,3300572,3300627,3300700,3302549,3302645,3302706,3302779,3304613,3304708,3304768,3304842,3306659,3306760,3306815,3306889,3308704,3308806,3308861,3308935,3310748,3310845,3310905,3310979,3312780,3312880,3313005,3314796,3314851,3314899,3315028,3316812,3316862,3316910,3317035,3318814,3318864,3318911,3319036,3320798,3320850,3320895,3321026,3322782,3322835,3322879,3323011,3324930,3324983,3325029,3325159,3327201,3327253,3327300,3327428,3327694,3329586,3329640,3329686,3329817,3330080,3331971,3332021,3332067,3332200,3332461,3334337,3334386,3334429,3334565,3334828,3336688,3336739,3336784,3336914,3337181,3339034,3339089,3339133,3339263,3339529,3341378,3341432,3341475,3341610,3341873,3343719,3343769,3343813,3343947,3344210,3346071,3346124,3346169,3346300,3346567,3348427,3348476,3348525,3348654,3348917,3350761,3350814,3350862,3350992,3351254,3353082,3353136,3353180,3353315,3353578,3355404,3355457,3355504,3355633,3355896,3357731,3357787,3357830,3357968,3358246,3360076,3360131,3360177,3360307,3360615,3362444,3362493,3362541,3362672,3362978,3364797,3364846,3364891,3365029,3365332,3367132,3367188,3367230,3367368,3367671,3369468,3369518,3369564,3369693,3370002,3371788,3371841,3371890,3372019,3372327,3374108,3374161,3374203,3374341,3374645,3376418,3376471,3376518,3376649,3376958,3378723,3378779,3378822,3378900,3378960,3379262,3381020,3381074,3381123,3381197,3381255,3381561,3383345,3383390,3383466,3383520,3383830,3385630,3385674,3385752,3385810,3386115,3387898,3387943,3388021,3388075,3388382,3390158,3390204,3390278,3390336,3390638,3392407,3392455,3392531,3392588,3392890,3394646,3394689,3394767,3394821,3395126,3396867,3396911,3396990,3397044,3397348,3399082,3399130,3399205,3399262,3399565,3401283,3401332,3401405,3401464,3401767,3403475,3403517,3403598,3403655,3403956,3405703,3405778,3405835,3406138,3407869,3407945,3408004,3408323,3410030,3410108,3410167,3410489,3412178,3412254,3412313,3412632,3414347,3414422,3414481,3414585,3414700,3414803,3416495,3416569,3416624,3416733,3416849,3416951,3418636,3418709,3418765,3418872,3418990,3419092,3420754,3420831,3420890,3420996,3421112,3421211,3422932,3422994,3423098,3423213,3423314,3425014,3425074,3425177,3425296,3425394,3427072,3427129,3427238,3427354,3427453,3429117,3429174,3429278,3429395,3429497,3431140,3431200,3431307,3431423,3431521,3433151,3433212,3433316,3433432,3433532,3435158,3435212,3435318,3435434,3435535,3437150,3437206,3437317,3437430,3437532,3439132,3439191,3439297,3439409,3439512,3441099,3441156,3441258,3441377,3441477,3443061,3443122,3443223,3443341,3443441,3445040,3445095,3445200,3445315,3445414,3447190,3447250,3447355,3447469,3447569,3449341,3449392,3449497,3449615,3449713,3451479,3451535,3451637,3451753,3451855,3453608,3453663,3453769,3453887,3453987,3455786,3455890,3456004,3456106,3457910,3458013,3458131,3458232,3460036,3460136,3460259,3460364,3462172,3462273,3462394,3462500,3464295,3464400,3464523,3464634,3466445,3466554,3466670,3466783,3468622,3468728,3468850,3468963,3470793,3470899,3471018,3471130,3472947,3473055,3473171,3473288,3475105,3475209,3475327,3475444,3477260,3477361,3477480,3477598,3479406,3479511,3479627,3479743,3481543,3481644,3481763,3481878,3483675,3483777,3483894,3484010,3485795,3485899,3486019,3486131,3488014,3488128,3488240,3490119,3490235,3490293,3490375,3492250,3492365,3492422,3492507,3494369,3494488,3494544,3494627,3496487,3496603,3496659,3496745,3498641,3498752,3498813,3498899,3500784,3500900,3500956,3501042,3502918,3503032,3503090,3503180,3505049,3505165,3505221,3505311,3507173,3507293,3507348,3507435,3509295,3509411,3509468,3509551,3511408,3511523,3511581,3511668,3513515,3513635,3513691,3513773,3515617,3515727,3515787,3515872,3517702,3517815,3517876,3517961,3519786,3519901,3519961,3520049,3521863,3521982,3522038,3522126,3523935,3524050,3524109,3524195,3525994,3526111,3526169,3526256,3528051,3528166,3528221,3528330,3530108,3530223,3530282,3530389,3532151,3532268,3532328,3532435,3534191,3534308,3534368,3534475,3536235,3536347,3536406,3536514,3538266,3538378,3538435,3538544,3540286,3540400,3540460,3540569,3542357,3542471,3542530,3542639,3544414,3544529,3544585,3544695,3546572,3546628,3546736,3548604,3548665,3548773,3550640,3550697,3550806,3552680,3552737,3552847,3554712,3554772,3554883,3556752,3556811,3556920,3558775,3558836,3558946,3560787,3560848,3560958,3562790,3562849,3562962,3564794,3564851,3564962,3566814,3566870,3566981,3568823,3568883,3568994,3570846,3570900,3571012,3572851,3572911,3573023,3574868,3574922,3575033,3576770,3576830,3576940,3578674,3578734,3578843,3580577,3580631,3580742,3582462,3582503,3582605,3584322,3584363,3584464,3586177,3586220,3586321,3588033,3588074,3588176,3589881,3589926,3590029,3591731,3591774,3591875,3593579,3593620,3593722,3595531,3595592,3595706,3597524,3597585,3597697,3599499,3599560,3599674,3601458,3601520,3601632,3603408,3603468,3603582,3605404,3605519,3607330,3607443,3609250,3609364,3611158,3611270,3613056,3613170,3614978,3615092,3616891,3617004,3617500,3618799,3618913,3619408,3620701,3620812,3621313,3622599,3622711,3623212,3624491,3624604,3625104,3626368,3626483,3626982,3628238,3628351,3628849,3630098,3630211,3630711,3631957,3632070,3632570,3633811,3633925,3634422,3635766,3636265,3637602,3638101,3639427,3639925,3641235,3641735,3643042,3643539,3644833,3645334,3646620,3647121,3648399,3648900,3650171,3650670,3651928,3652429,3653678,3654176,3655416,3655916,3657148,3657648,3658869,3659375,3660589,3661104,3662316,3662830,3664029,3664544,3665734,3666247,3667432,3667944,3669120,3669632,3670799,3671311,3672469,3672984,3674136,3674651,3675792,3676305,3677434,3677947,3679071,3679587,3680705,3681222,3682852,3684477,3686096,3687705,3689305,3690901,3692493,3694075,3695651,3697221,3698775,3700319,3701857,3703390,3704915,3706435,3707945,3709439,3710928,3712411,3713889,3715358,3716823,3718285,3719738,3721185,3722627,3724063,3725492,3726915,3728332,3729743,3731144,3732537,3733923,3735298,3736667,3738030,3739382,3740728,3742066,3743396,3744717,3746033,3747342,3748640,3749931,3751214,3752489,3753754,3755015,3756268,3757523,3758769,3760008,3761242,3762467,3763687,3764904,3766115,3767316,3768512,3769699,3770091,3770481,3770866,3771248,3771629,3772006,3772381,3772753,3773122,3773489,3773857,3774224,3774589,3774952,3775313,3775672,3776029,3776382,3776730,3777082,3777431,3777776,3778116,3778451,3778781,3779106,3779436,3779762,3780083,3780399,3780714,3781025,3781330,3781630,3781927,3782219,3782507,3782790,3783075,3783357,3783636,3783912,3784184,3784455,3784721,3784983,3785241,3785496,3785792,3786126,3786457,3786807,3787153,3787495,3787834,3788169,3788502,3788831,3789157,3789480,3789798,3790114,3790427,3790738,3791045,3791349,3791650,3791947,3792242,3792534,3792823,3793110,3793393,3793672,3793947,3794220,3794489,3794755,3795019,3795281,3795540,3795794,3796061,3796326,3796588,3796847,3797102,3797352,3797596,3797838,3798076,3798311,3798543,3798774,3799000,3799220,3799439,3799655,3799869,3800080,3800289,3800494,3800697,3800899,3801099,3801296,3801490,3801681,3801867,3802045,3802222,3802397,3802569,3802738,3802905,3803068,3803224,3849303,3849537,3849769,3849999,3850227,3850453,3850677,3855343,3855924,3856504,3857153,3857772,3858389,3859190,3859991,3860790,3861586,3862379,3863169,3863956,3864738,3865519,3866296,3867072,3867843,3868612,3869379,3870147,3870910,3871671,3873158,3873913,3874666,3875416,3876163,3876909,3877654,3878396,3879139,3879879,3880619,3881364,3882106,3882849,3883590,3884329,3885067,3885805,3893833,3894551,3895271,3895982,3896690,3897397,3898103,3898805,3899506,3900205,3922391,3923070,3923750,3924422,3925091,3925757,3926418,3927081,3927740,3928399,3929055,3929705,3930356,3931001,3931648,3932292,3932931,3933576,3934214,3941345,3941984,3942621,3943255,3943879,3944507,3945127,3945748,3946368,3946997,3953335,3953952,3954565,3955173,3955780,3956382,3957005,3957628,3958246,3969998,3970570,3971137,3971705,3972265,3972823,3973377,3973933,3974485,3979911,3980494,3981077,3981650,3982225,3982796,3983367,3983940,3984509,3985071,3985633,3986190,3986744,4066051,4066868,4067685,4068497,4069306,4070110,4070908,4071705,4072498,4073289,4074079,4074867,4075649,4076430,4077206,4077980,4078753,4079523,4094607,4094627,4095368,4095387,4096127,4096147,4096882,4096903,4097639,4097658,4098391,4098412,4099141,4099162,4099891,4099913,4100638,4100659,4101382,4101404,4102127,4102146,4102867,4102889,4103607,4103627,4104344,4104363,4105078,4105098,4105811,4105832,4106541,4106562,4107288,4108012,4108731,4109449,4110165,4110877,4111589,4112296)) 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





	Yekaterina Goncharova (Soprano) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Yekaterina Goncharova (Soprano)
			

																
Yekaterina Goncharova (Soprano)

														
				


        




    

        
Prize-winner at the Elena Obraztsova International Young Opera Singers’ Competition (1st prize, 2007) 
Prize-winner at the Montserrat Caballe International Opera Singers’ Competition in Zaragoza (1st prize, 2008) 
Prize-winner at the Three Centuries of Classical Romance All-Russian Competition of Chamber Vocal Duets (2004) 
Prize-winner at the  S  Petersburg All-Russian Opera Singers’ Competition (2007) 
Yekaterina Goncharova is a graduate of the St Petersburg State Rimsky-Korsakov Conservatoire. Since 2009 she has been a soloist with the St Petersburg Conservatoire Opera and Ballet Theatre. In 2008 she appeared in a concert performance of the opera Carmen under the baton of Mariss Jansons as Micaлla. In October 2010 she made her debut at the Philharmonie in Cologne in a concert with Montserrat Caballe. In November 2010 she appeared as Tatiana in a production of the opera Eugene Onegin at the Opera de Monte-Carlo. In the 2011–2012 season she made her Mariinsky Theatre debuts as Tatiana (Eugene Onegin) and Micaлla (Carmen). Has toured throughout Russia and to Spain. 
Repertoire includes: 
Mimм (La boheme) 
Tatiana (Eugene Onegin) 
Iolanta (Iolanta) 
Maria (Mazepa) 
Genoveva (Genoveva) 
Micaлla (Carmen) 
Agnиs (The Maid of Orleans) 
Violetta (La traviata) 
Marfa (The Tsar’s Bride) 
Antonia (Les Contes d’Hoffmann) 
Natasha (War and Peace)  
        

    

    

            


			

		





	


	

	

		


			

				

					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