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 (8426,10130,11713,13296,14650,4641,14704,16103,4641,16158,17763,17768,19170,35519,35554,37170,37240,38718,38723,38792,38836,40167,40171,40240,40284,41548,41593,41597,41604,41616,41645,41646,41673,42986,42991,43001,43012,43038,43039,43065,44347,44353,44362,44369,44398,44400,44426,45699,45704,45714,45721,45750,45752,45778,47044,47049,47059,47066,47095,47097,47123,48388,48398,48409,48435,48436,48462,49732,49743,49768,49770,49796,51060,51071,51096,51098,51124,52390,52416,52417,52443,53705,53731,53732,53758,55014,55040,55041,55071,56342,56343,56371,57703,57705,57735,59772,59775,59805,61836,61839,61868,63891,63894,63923,65941,65970,68015,70057,72094,74124,76142,78152,80158,107666,107984,108168,109552,109870,110055,110143,111429,111747,111932,112020,113298,113617,113802,113890,115159,115478,115663,115751,117034,117354,117538,117627,118909,119229,119412,119502,120780,121100,121283,121373,122646,122966,123149,123239,124504,124824,125007,125097,126353,126673,126856,126946,128193,128513,128696,128786,130022,130343,130525,130615,131851,132172,132354,132444,133684,134005,134187,134277,135509,135830,136012,136102,137330,137651,137833,137923,139148,139469,139651,139741,140958,141279,141461,141551,142759,143080,143262,143352,144549,144870,145052,145142,146329,146650,146832,146922,148100,148421,148603,148693,149857,150179,150361,150451,151607,151929,152111,152201,153351,153670,153852,153941,155082,155401,155583,155672,156803,157122,157307,157393,158514,158833,159018,159104,160240,160559,160744,160830,161967,162285,162471,162557,163684,164037,164219,164309,165426,165778,165960,166050,167157,167509,167691,167781,168878,169230,169415,169502,170590,170942,171127,171214,172294,172646,172832,172919,173994,174340,174526,174612,176024,176210,176296,177697,177883,177969,179360,179546,179632,181013,181199,181286,182660,182846,182933,184301,184487,184574,185931,186118,186205,187555,187740,187827,189166,189351,189439,190766,190951,191039,192355,192540,192628,193936,194121,194209,196720,196937,197025,198034,198253,198341,198457,198474,199351,199570,199658,199774,199791,200668,200887,200975,201091,201108,202350,202569,202657,202773,202790,204022,204241,204329,204445,204462,205696,205945,206033,206151,206168,207394,207643,207731,207849,207866,209082,209331,209419,209537,209554,210745,210995,211083,211201,211218,212253,212519,212617,212734,212751,213788,214058,214156,214273,214290,215324,215594,215692,215809,215826,216855,217125,217223,217340,217357,218384,218654,218752,218869,218886,219907,220177,220275,220392,220409,221426,221696,221794,221911,221928,222940,223210,223308,223425,223442,224449,224719,224817,224934,224951,225954,226230,226328,226445,226462,227459,227735,227833,227950,227967,228958,229234,229332,229449,229466,230943,231219,231317,231434,231451,232937,233214,233312,233429,233446,234927,235204,235302,235419,235436,236913,237189,237286,237404,237421,238887,239163,239261,239378,239395,240853,241129,241226,241343,241361,242814,243090,243187,243304,243322,244771,245050,245148,245265,245283,246725,247002,247100,247217,247235,248672,248949,249047,249164,249182,250616,250896,250991,251108,251126,252599,252879,252974,253091,253109,254573,254853,254948,255065,255083,256537,256817,256913,257030,257048,258498,258778,258885,259003,259021,260464,260745,260852,260970,260988,262424,262705,262812,262930,262948,264391,264671,264778,264896,264914,266351,266631,266738,266856,266874,268303,268582,268689,268807,268825,270243,270523,270630,270748,270766,272182,272462,272569,272687,272705,274103,274115,274242,274258,274394,274502,274620,274638,276049,276176,276192,276328,276436,276554,276572,277973,278101,278117,278255,278363,278482,278499,279850,279978,279993,280132,280240,280359,280376,281846,281861,282000,282108,282227,282244,283705,283720,283859,283967,284086,284103,285562,285577,285716,285824,285943,285960,287416,287432,287571,287678,287797,287814,289261,289274,289414,289524,289641,289660,291098,291114,291253,291387,291541,291562,292994,293010,293149,293283,293437,293458,294882,294899,295038,295172,295326,295347,296763,296779,296918,297052,297205,297227,298635,298651,298791,298929,299081,299104,300507,300522,300661,300800,300953,300978,302398,302415,302554,302689,302843,302868,304277,304296,304436,304571,304725,304750,306203,306220,306368,306503,306657,306682,308131,308144,308292,308427,308581,308606,310048,310062,310210,310345,310499,310524,311963,311977,312124,312259,312413,312438,313872,313886,314033,314168,314322,314347,315777,315791,315938,316073,316227,316252,317675,317689,317836,317971,318125,318150,319565,319579,319726,319861,320014,320040,321444,321458,321605,321740,321893,321919,323314,323328,323475,323610,323763,323789,325209,325224,325370,325515,325668,325694,327107,327123,327270,327422,327576,327601,329008,329024,329169,329321,329475,329500,330915,331061,331214,331368,331393,332801,332947,333100,333254,333279,334676,334822,334975,335129,335154,336688,336841,336994,337020,338555,338719,338875,338901,340436,340639,340805,340832,342342,342360,342362,342374,342563,342729,342756,344266,344283,344287,344298,344488,344653,344680,346182,346199,346203,346214,346411,346576,346603,348089,348106,348110,348121,348318,348484,348510,349980,349996,350000,350011,350208,350373,350400,351858,351874,351878,351894,352086,352253,352278,353736,353752,353756,353766,353964,354129,354156,355609,355625,355628,355639,355836,356012,356038,357486,357501,357505,357516,357713,357889,357915,359393,359408,359412,359423,359620,359796,359822,361291,361306,361311,361322,361521,361697,361723,363183,363199,363204,363218,363412,363588,363613,365065,365080,365084,365101,365295,365473,365497,366943,366963,366967,366980,367175,367352,367376,368823,368837,368841,368853,369053,369230,369254,370693,370711,370715,370728,370923,371100,371124,372557,372572,372579,372592,372787,372964,372988,374411,374430,374434,374447,374642,374818,374843,376256,376275,376279,376292,376487,376663,376688,378091,378110,378114,378127,378322,378498,378523,379924,379943,379947,379960,380155,380331,380356,381752,381771,381775,381788,381983,382159,382184,383575,383590,383594,383605,383805,383980,384006,385387,385406,385410,385423,385621,385795,385820,387199,387213,387217,387228,387428,387603,387629,389007,389025,389029,389041,389239,389414,389439,390811,390824,390828,390841,391040,391217,391241,392611,392624,392628,392640,392840,393017,393041,394405,394421,394426,394440,394634,394810,394835,396197,396210,396214,396228,396426,396603,396627,397982,397995,397999,398012,398211,398388,398412,399773,399780,399794,399989,400165,400190,401542,401546,401559,401758,401935,401959,403301,403308,403322,403518,403693,403718,405058,405065,405079,405275,405450,405475,406817,406831,407027,407202,407227,408578,408774,408949,408974,410318,410514,410689,410714,412086,412281,412456,412481,414038,414212,414238,415781,415955,415981,417521,417698,417724,419261,419438,419464,420994,421171,421197,422724,422901,422927,424449,424628,424652,426163,426342,426366,427862,428041,428065,429556,429735,429759,431244,431447,431473,432946,433149,433180,434644,434847,434878,436338,436543,436572,438021,438226,438255,439688,439894,439923,441344,441550,441579,442986,443192,443221,444618,444822,444852,446237,446444,446476,447851,448058,448091,449451,449660,449691,451045,451252,451285,452635,452842,452875,454223,454429,454463,455803,456010,456043,457323,457376,457383,457584,457617,458942,458949,459151,459183,460498,460505,460706,460740,462046,462053,462254,462287,463598,463605,463806,463839,465146,465153,465354,465387,466688,466695,466896,466929,468386,468396,468600,468634,470086,470093,470311,470349,471637,471644,471862,471899,473179,473189,473404,473440,474759,474766,474984,475020,476346,476561,476597,477918,478136,478172,479710,479741,484040,484050,484108,484791,484801,484859,485536,485546,485604,486284,486342,487014,487071,487786,488497,489211,489919,490621,491320,492007,492684,493365,494043,494715,495380,496035,497354,497431,497444,497473,497517,498818,498895,498908,498936,498980,500273,500350,500362,500391,500439,501727,501804,501818,501845,501890,503220,503297,503310,503334,503383,504698,504774,504788,504816,504864,506170,506246,506261,506287,506335,507641,507718,507734,507759,507807,509187,509203,509227,509277,510651,510666,510690,510739,512106,512122,512146,512196,513556,513569,513596,513645,515027,515043,515066,515118,516490,516504,516530,516584,517943,517956,517983,518038,519387,519404,519427,519481,520829,520846,520869,520923,522266,522283,522306,522360,523697,523709,523740,523790,525116,525128,525157,525210,526525,526537,526567,526618,527929,527942,527971,528022,529332,529345,529374,529426,530732,530746,530774,530826,532140,532170,532220,533528,533550,533603,534960,534987,535040,536412,536464,537843,537893,539266,539318,540681,540734,542116,542166,543557,543608,545078,546535,547990,549442,549501,550885,550943,552321,552379,553745,553802,555161,555224,556568,556630,557971,558030,559426,560819,562208,563589,564957,566319,567676,569032,570380,571722,573099,574468,583901,585215,638482,640020,641550,643071,644584,646089,647590,649080,650572,652057,653533,654999,656454,657901,659350,660787,662214,663634,665048,666451,667886,669311,670745,672174,693922,693933,695170,695181,696400,696410,697619,697630,698827,698837,700023,700033,701222,702421,736037,737015,737983,738943,739896,741867,743843,745812,747777,749757,751739,753721,756602,759472,762339,765202,768058,770907,773750,776587,779420,782254,785087,787915,790739,793559,796371,799178,801981,804779,807572,810359,813140,815916,818687,821451,824207,826956,829700,832440,835175,837907,840634,843357,846102,848838,851569,854300,857029,859751,862468,865175,867870,870554,873238,875921,878608,881292,883978,886653,889319,891981,894636,897289,899939,902568,902581,902619,905200,905209,905252,907817,907826,907869,910430,910440,910483,910597,913041,913051,913094,913209,915672,915683,915722,915840,918376,918386,918426,918544,921079,921119,921237,923757,923798,923915,926493,926609,929209,929324,931918,932031,934625,934738,937330,937443,940061,940174,942779,942892,945484,945597,948186,948299,951005,953705,956395,959071,961726,964366,967002,969634,972262,974882,977494,980101,982694,985280,987904,990523,993135,995744,998339,1000923,1003504,1006077,1008644,1011203,1013783,1016346,1018896,1021443,1024185,1026720,1029250,1031611,1031627,1031698,1031781,1034116,1034129,1034201,1034284,1036605,1036619,1036691,1036774,1039094,1039105,1039180,1039263,1041578,1041589,1041664,1041747,1044065,1044140,1044222,1044278,1046532,1046607,1046689,1046745,1048988,1049064,1049146,1049202,1051511,1051590,1051646,1053940,1054018,1054075,1056367,1056445,1056502,1058790,1058866,1058924,1061199,1061274,1061333,1063600,1063675,1063732,1065994,1066069,1066126,1068375,1068457,1068508,1070744,1070827,1070878,1073144,1073227,1073277,1075537,1075619,1075670,1077920,1078001,1078053,1080291,1080372,1080424,1082651,1082731,1082784,1084996,1085076,1085130,1087324,1087405,1087459,1089725,1089777,1092055,1092107,1094377,1094429,1096687,1096739,1098981,1099036,1101258,1101314,1103529,1103584,1105779,1105839,1108006,1108066,1110218,1110273,1112404,1112460,1114571,1114628,1116726,1116777,1118896,1118916,1121026,1121043,1123167,1123188,1125300,1125320,1127491,1127511,1129712,1129732,1131916,1131934,1134107,1134124,1136327,1138529,1140727,1142918,1145101,1971138,1971142,1971148,1973145,1973152,1973157,1975145,1975149,1975155,1977128,1977135,1977140,1979106,1979112,1981104,1981113,1983105,1985087,2112794,2114700,2116603,2118495,2120376,2122246,2124106,2125950,2127790,2129619,2131440,2133251,2135052,2136842,2349961,2353086,2387047,2390110,2393165,2396222,2399258,2402275,2405291,2408303,2411299,2414293,2417271,2420280,2423279,2426268,2429246,2432223,2435186,2438137,2441076,2444003,2446926,2449842,2452742,2455635,2458510,2461385,2464243,2467095,2469966,2472896,2475807,2478749,2481673,2635599,2638237,2640874,2643487,2646099,2648690,2651274,2653855,2656419,2658964,2661494,2663999,2666495,2668971,2671430,2673871,2676297,2678704,2678733,2678755,2681116,2681138,2683489,2683509,2685854,2685877,2688213,2688233,2690564,2690584,2692901,2692921,2695222,2695245,2697868,2697903,2700977,2704059,2707131,2710167,2713204,3002620,3002647,3002888,3004916,3004943,3005185,3007175,3007417,3009362,3009608,3011543,3011788,3013945,3016090,3018229,3020421,3022203,3023676,3025142,3026592,3028029,3029467,3030832,3030893,3031006,3032250,3032307,3032421,3033655,3033712,3035247,3035304,3036829,3036887,3038397,3038455,3039956,3040014,3041507,3041564,3043108,3044649,3046180,3047696,3049203,3050710,3052213,3053702,3055183,3056659,3056727,3058117,3058183,3059633,3061076,3062813,3064545,3064643,3066268,3066365,3067974,3068074,3069671,3069771,3071362,3071457,3073040,3073139,3074711,3074805,3076367,3076467,3078023,3078119,3079682,3079779,3081329,3081430,3082969,3083066,3084693,3086350,3087992,3089625,3091249,3092854,3094459,3096051,3097633,3099209,3100779,3102342,3103885,3105426,3106978,3108518,3110088,3111645,3132743,3134383,3136023,3137656,3137948,3139277,3139569,3140889,3141181,3142493,3142568,3142785,3144087,3144162,3144379,3145677,3145752,3145969,3147257,3147332,3147549,3147893,3147968,3148185,3148523,3148598,3148815,3149147,3149222,3149439,3149771,3149846,3150063,3151318,3151393,3151610,3152857,3152932,3153149,3154390,3154465,3154682,3155913,3155988,3156205,3157429,3157504,3157721,3158936,3159011,3159228,3160430,3160505,3160722,3161915,3161990,3162207,3163392,3163467,3163685,3164864,3164939,3165157,3166327,3166416,3166641,3167745,3167803,3167823,3168041,3169139,3169197,3169217,3169435,3170524,3170582,3170602,3170820,3171901,3171959,3171979,3172197,3173272,3173330,3173350,3173568,3174637,3174694,3174714,3174932,3176039,3176096,3176116,3176334,3177437,3177494,3177514,3177608,3177732,3178826,3178883,3178903,3178997,3179141,3180298,3180355,3180375,3180469,3180613,3181766,3181823,3181843,3181937,3182081,3183232,3183289,3183309,3183403,3183530,3184695,3184752,3184772,3184868,3184995,3186156,3186213,3186233,3186329,3186456,3187613,3187670,3187690,3187786,3187913,3189064,3189121,3189141,3189237,3189364,3190513,3190567,3190589,3190682,3190809,3191954,3192010,3192030,3192123,3192250,3193386,3193442,3193462,3193560,3193761,3195079,3195136,3195152,3195251,3195452,3196862,3196923,3196937,3197036,3197237,3198839,3198893,3198914,3199010,3199211,3200804,3200863,3200881,3200979,3201105,3202507,3202562,3202583,3202676,3202803,3204195,3204255,3204273,3204370,3204496,3205887,3205942,3205966,3206059,3206186,3207573,3207633,3207649,3207746,3207873,3209253,3209312,3209329,3209426,3209553,3210850,3210927,3210940,3210982,3211006,3211099,3211226,3212570,3212647,3212659,3212701,3212722,3212819,3212945,3214274,3214350,3214365,3214409,3214426,3214522,3214649,3215968,3216043,3216057,3216101,3216124,3216218,3216345,3217663,3217738,3217752,3217797,3217813,3217912,3218039,3219349,3219425,3219438,3219484,3219506,3219600,3219727,3221030,3221105,3221120,3221165,3221182,3221278,3221406,3222697,3222773,3222786,3222831,3222851,3222946,3223081,3224361,3224438,3224449,3224496,3224517,3224612,3224748,3225990,3226068,3226081,3226124,3226143,3226241,3226377,3227606,3227684,3227697,3227739,3227759,3227857,3227993,3229223,3229300,3229314,3229357,3229375,3229473,3229610,3230847,3230920,3230936,3230981,3231002,3231096,3231233,3232460,3232541,3232550,3232600,3232615,3232712,3232849,3234071,3234150,3234160,3234206,3234223,3234322,3234458,3235670,3235749,3235761,3235805,3235825,3235921,3236057,3237254,3237333,3237345,3237388,3237407,3237505,3237641,3238825,3238902,3238915,3238959,3238980,3239074,3239211,3240389,3240470,3240480,3240529,3240546,3240641,3240778,3242073,3242084,3242129,3242149,3242245,3242381,3243667,3243677,3243723,3243743,3243835,3243972,3245244,3245259,3245307,3245323,3245418,3245554,3246851,3246861,3246909,3246925,3247019,3247156,3248437,3248449,3248495,3248513,3248605,3248742,3250005,3250017,3250062,3250083,3250175,3250312,3251571,3251582,3251630,3251644,3251741,3251877,3253132,3253141,3253185,3253207,3253315,3253480,3254731,3254740,3254787,3254804,3254913,3255213,3256737,3256753,3256796,3256818,3256926,3257223,3258753,3258765,3258806,3258827,3258936,3259235,3260747,3260761,3260807,3260822,3260934,3261232,3262728,3262742,3262789,3262807,3262916,3263213,3264713,3264722,3264770,3264786,3264895,3265195,3266690,3266701,3266745,3266761,3266874,3267185,3268675,3268686,3268711,3268733,3268748,3268859,3269226,3270721,3270733,3270762,3270778,3270796,3270908,3271316,3272847,3272863,3272889,3272907,3272922,3273036,3273441,3274958,3274970,3274999,3275015,3275034,3275145,3275552,3277063,3277090,3277108,3277127,3277237,3277645,3279153,3279178,3279200,3279220,3279329,3279735,3281286,3281315,3281332,3281350,3281461,3281870,3283412,3283440,3283459,3283480,3283590,3283751,3283774,3283997,3285560,3285579,3285602,3285712,3285873,3285891,3286119,3287708,3287728,3287752,3287861,3288020,3288040,3288267,3289841,3289860,3289884,3289993,3290154,3290178,3290401,3291960,3291978,3291999,3292111,3292271,3292291,3292518,3294063,3294084,3294105,3294215,3294375,3294397,3294622,3296183,3296207,3296316,3296474,3296495,3296721,3298277,3298297,3298408,3298568,3298591,3298816,3300358,3300383,3300491,3300654,3300662,3300678,3300901,3302437,3302457,3302568,3302729,3302737,3302752,3302977,3304498,3304522,3304632,3304794,3304802,3304814,3305039,3306572,3306679,3306841,3306850,3306866,3307088,3308618,3308727,3308887,3308897,3308911,3309135,3310659,3310767,3310929,3310937,3310952,3311176,3312689,3312802,3312959,3312968,3312983,3313204,3314709,3314767,3314821,3314976,3314987,3315001,3315222,3316723,3316777,3316831,3316988,3316995,3317012,3317233,3318722,3318777,3318832,3318988,3318996,3319013,3319233,3320767,3320821,3320978,3320987,3320997,3321222,3322752,3322806,3322964,3322971,3322982,3323207,3324900,3324951,3325108,3325118,3325131,3325355,3327169,3327221,3327378,3327386,3327405,3327626,3329557,3329608,3329769,3329777,3329790,3330013,3331935,3331990,3332149,3332155,3332171,3332395,3334301,3334357,3334514,3334521,3334536,3334760,3336654,3336709,3336867,3336873,3336889,3337113,3339005,3339056,3339214,3339224,3339240,3339461,3341347,3341399,3341557,3341566,3341582,3341803,3343685,3343737,3343896,3343905,3343920,3344140,3346039,3346095,3346253,3346260,3346276,3346498,3348394,3348446,3348605,3348614,3348630,3348849,3350730,3350784,3350940,3350951,3350964,3351188,3353051,3353105,3353264,3353272,3353288,3353509,3355371,3355424,3355582,3355592,3355604,3355830,3357701,3357754,3357912,3357920,3357938,3358179,3360046,3360100,3360258,3360266,3360284,3360536,3362461,3362622,3362628,3362645,3362844,3362901,3364817,3364973,3364982,3364998,3365198,3365253,3367156,3367315,3367321,3367336,3367539,3367592,3369486,3369643,3369651,3369670,3369871,3369925,3371812,3371969,3371978,3371994,3372193,3372247,3374130,3374288,3374295,3374312,3374511,3374567,3376441,3376600,3376609,3376625,3376825,3376879,3378748,3378905,3378913,3378926,3379128,3379186,3381045,3381202,3381210,3381228,3381425,3381482,3383314,3383470,3383480,3383496,3383695,3383750,3385602,3385756,3385766,3385780,3385980,3386035,3387870,3388023,3388034,3388049,3388249,3388306,3390285,3390291,3390310,3390509,3390562,3392536,3392544,3392561,3392761,3392814,3394774,3394779,3394795,3394996,3395053,3396995,3397003,3397017,3397220,3397272,3399209,3399218,3399230,3399432,3399489,3401411,3401418,3401433,3401637,3401689,3403601,3403612,3403626,3403825,3403882,3405781,3405792,3405804,3406005,3406062,3407952,3407959,3407976,3408192,3408249,3410116,3410122,3410137,3410355,3410414,3412258,3412266,3412285,3412499,3412556,3414429,3414436,3414448,3414669,3414725,3416574,3416583,3416600,3416818,3416875,3418716,3418724,3418741,3418959,3419016,3420837,3420844,3420858,3421078,3421135,3422938,3422949,3422961,3423181,3423237,3425020,3425028,3425046,3425262,3425319,3427078,3427089,3427104,3427322,3427377,3429121,3429131,3429147,3429362,3429422,3431146,3431157,3431172,3431390,3431446,3433157,3433167,3433180,3433398,3433456,3435162,3435169,3435186,3435400,3435458,3437159,3437165,3437179,3437395,3437454,3439136,3439146,3439159,3439378,3439436,3441102,3441111,3441128,3441343,3441403,3443069,3443077,3443094,3443306,3443363,3445045,3445051,3445066,3445279,3445341,3447199,3447206,3447222,3447434,3447491,3449344,3449354,3449365,3449580,3449640,3451484,3451491,3451507,3451717,3451779,3453614,3453623,3453636,3453849,3453913,3455734,3455741,3455757,3455968,3456032,3457859,3457867,3457881,3458097,3458155,3459982,3459989,3460007,3460053,3460219,3460287,3462128,3462141,3462189,3462356,3462424,3464253,3464267,3464314,3464481,3464548,3466418,3466465,3466630,3466697,3468596,3468645,3468811,3468876,3470767,3470811,3470978,3471044,3472969,3473136,3473202,3475125,3475292,3475359,3477275,3477442,3477512,3479421,3479589,3479657,3481559,3481724,3481792,3483691,3483856,3483923,3485816,3485977,3486044,3487926,3488089,3488154,3490035,3490198,3490272,3492163,3492327,3492399,3494285,3494446,3494523,3496402,3496561,3496639,3498714,3498792,3500858,3500934,3502994,3503071,3505041,3505064,3505125,3505202,3507164,3507189,3507252,3507326,3509283,3509308,3509371,3509448,3511400,3511422,3511485,3511560,3513507,3513529,3513595,3513669,3515604,3515628,3515690,3515767,3517692,3517714,3517777,3517855,3519778,3519803,3519820,3519865,3519942,3521854,3521881,3521897,3521943,3522018,3523924,3523951,3523966,3524014,3524087,3525985,3526010,3526026,3526075,3526151,3528038,3528064,3528078,3528126,3528202,3530100,3530123,3530140,3530185,3530261,3532142,3532169,3532183,3532230,3532308,3534182,3534209,3534222,3534270,3534348,3536223,3536245,3536265,3536310,3536384,3538251,3538278,3538293,3538340,3538417,3540277,3540300,3540317,3540364,3540439,3542369,3542389,3542431,3542509,3544426,3544442,3544490,3544564,3546468,3546484,3546531,3546607,3548506,3548524,3548566,3548643,3550536,3550554,3550598,3550675,3550686,3552576,3552594,3552639,3552715,3552728,3554629,3554673,3554751,3554764,3556668,3556714,3556789,3556801,3558694,3558740,3558813,3558827,3560702,3560749,3560827,3560837,3562753,3562828,3562842,3564755,3564832,3564842,3566774,3566851,3566863,3568784,3568860,3568873,3570803,3570880,3570892,3572815,3572891,3572901,3574825,3574903,3574915,3576734,3576810,3576820,3578637,3578712,3578725,3580534,3580611,3580624,3582430,3582489,3582499,3584288,3584349,3584358,3586145,3586207,3586216,3588061,3588070,3589911,3589922,3591761,3591769,3593607,3593616,3595572,3595582,3596091,3597564,3597577,3598082,3599539,3599553,3600058,3601497,3601512,3602017,3603447,3603458,3603967,3605383,3605396,3605905,3607311,3607323,3607830,3609230,3609240,3609748,3611139,3611148,3611658,3613033,3613046,3613557,3614955,3614969,3615476,3616870,3616883,3617391,3617452,3618780,3618791,3619300,3619360,3620679,3620692,3621200,3621261,3622592,3623097,3623160,3624481,3624990,3625052,3626360,3626870,3626930,3628736,3628798,3630600,3630660,3632459,3632519,3634308,3634371,3636152,3636214,3637989,3638050,3639811,3639874,3641623,3641684,3643427,3643488,3645220,3645282,3647007,3647069,3648785,3648848,3650558,3650619,3652314,3652377,3654061,3654124,3655803,3655864,3657537,3657596,3659258,3659319,3660976,3661044,3662701,3662770,3664416,3664484,3666118,3666187,3667817,3667884,3669506,3669572,3671183,3671251,3672857,3672924,3674521,3674590,3676175,3676244,3677819,3677887,3679457,3679526,3681092,3681160,3682722,3682791,3684348,3684416,3685968,3686035,3687577,3687643,3689176,3689244,3690772,3690840,3692362,3692431,3693945,3694014,3695522,3695589,3697092,3697159,3698648,3698714,3700190,3700257,3701730,3701796,3703261,3703329,3704787,3704854,3706306,3706373,3707814,3707883,3709312,3709378,3710797,3710866,3712283,3712350,3713760,3713827,3715230,3715297,3716696,3716762,3718157,3718223,3719610,3719677,3721058,3721124,3722499,3722566,3723934,3724002,3725363,3725431,3726787,3726854,3728205,3728271,3729614,3729681,3731013,3731082,3732407,3732476,3733793,3733861,3735170,3735236,3736537,3736605,3737901,3737969,3739255,3739321,3740597,3740666,3741936,3742004,3743265,3743334,3744587,3744655,3745903,3745971,3747213,3747280,3748513,3748579,3749800,3749869,3751083,3751152,3752358,3752427,3753624,3753693,3754885,3754953,3756140,3756207,3757394,3757462,3758639,3758708,3759881,3759947,3761112,3761180,3762336,3762405,3763560,3763626,3764777,3764843,3765986,3766053,3767188,3767255,3768381,3768450,3769569,3769638,3769963,3770030,3770351,3770419,3770736,3770805,3771119,3771187,3771499,3771567,3771876,3771945,3772252,3772320,3772623,3772692,3772995,3773061,3773359,3773427,3773729,3773796,3774094,3774163,3774459,3774528,3774822,3774891,3775183,3775252,3775542,3775611,3775899,3775968,3776252,3776321,3776600,3776669,3776952,3777021,3777301,3777370,3777646,3777715,3777986,3778055,3778321,3778390,3778651,3778720,3778976,3779045,3779306,3779375,3779632,3779701,3779953,3780022,3780269,3780338,3780584,3780653,3780895,3780964,3781200,3781269,3781500,3781569,3781797,3781866,3782089,3782158,3782377,3782446,3782660,3782729,3782945,3783014,3783227,3783296,3783506,3783575,3783782,3783851,3784054,3784123,3784325,3784394,3784591,3784660,3784853,3784922,3785111,3785180,3785366,3785435,3785618,3785709,3785952,3786043,3786283,3786374,3786633,3786724,3786979,3787070,3787321,3787412,3787660,3787751,3787995,3788086,3788328,3788419,3788657,3788748,3788983,3789074,3789306,3789397,3789624,3789715,3789940,3790031,3790253,3790344,3790564,3790655,3790871,3790962,3791175,3791266,3791476,3791567,3791773,3791864,3792068,3792159,3792360,3792451,3792649,3792740,3792936,3793027,3793219,3793310,3793589,3793864,3794137,3794406,3794672,3794936,3795198,3795457,3795711,3795977,3796242,3796504,3796763,3797018,3797268,3797512,3797754,3797992,3798227,3798459,3798690,3798916,3799136,3799355,3799571,3799785,3799996,3800205,3800410,3800613,3800815,3801015,3801212,3801406,3845816,3846062,3846305,3846544,3846782,3847016,3847245,3847473,3847705,3847933,3910042,3922388,3922391,3923066,3923070,3923744,3923750,3924420,3924422,3925088,3925091,3925753,3925757,3926415,3926418,3927078,3927081,3927736,3927740,3928396,3928399,3929050,3929055,3929704,3929705,3930353,3930356,3931000,3931001,3931645,3931648,3932286,3932292,3932926,3932931,3933570,3933576,3934214,3936147,3936803,3937456,3938106,3938753,3939395,3940036,3953312,3953927,3954546,3955152,3955764,3969984,3969998,3970556,3970570,3971123,3971137,3971693,3971705,3972255,3972265,3972823,3973377,3973933,3974485,3979903,3980485,3981064,3981644,3982217,3982786,3983357,3983397,3983931,3983966,3984500,3984534,3985063,3985103,3985662,3986217,3986772,3987325,3987873,3988414,3988950,3989484,3990016,3990554,4035097,4035457,4036360,4037256,4038175,4039090,4051512,4051530,4052389,4052407,4053266,4053282,4054137,4054157,4055002,4055025,4055872,4055888,4056732,4056754,4057594,4057613,4058446,4058467,4059318,4060165,4061012,4061852,4062687,4094627,4095387,4096147,4096903,4097658,4098412,4099162,4099913,4100659,4101404,4102146,4102889,4103627,4104363,4105098,4105832,4106562,4107288,4108012,4108731,4109449,4110165,4110877,4111589,4112296,4125912,4125919,4126608,4127290,4250757,4251125)) 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





	Edem Umerov (Baritone) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Edem Umerov (Baritone)
			

																
Edem Umerov (Baritone)

														
				


        




    

        
Born in Samarkand. Graduated from the St Petersburg State Rimsky-Korsakov Conservatoire in 1991 (class of Professors Steblianko, Okhotnikov and Zastavny).
Lead soloist with the St Petersburg Chamber Opera Company from 1992.
With the Mariinsky Theatre since 1998. 

Repertoire in the Mariinsky Theatre includes: 
Boris Godunov (Boris Godunov), 
Mazepa (Mazepa), 
Prince Nikita Kurlyatev, Ivan Zhuran (The Enchantress), 
Tomsky (The Queen of Spades), 
Dolokhov, Denisov (War and Peace), 
Macbeth (Macbeth), 
Amonasro (Aida); 
Telramund (Lohengrin), 
Kurwenal (Tristan und Isolde), 
Alberich (Das Rheingold, Siegfried), 
Alberich, Gunther (Die Gotterdammerung), 
Mandarin (Turandot); 
the High Priest (Samson et Dalila); 
Jokanaan (Salome). 

Repertoire also includes:
Eugene Onegin (Eugene Onegin), Columbus (A. Smelkov?s Fifth Journey of Christopher Columbus), Geronimo (Il matrimonio segreto), Rigoletto (Rigoletto). 

With the Mariinsky Theatre, he has toured to the UK (Covent Garden), Italy (La Scala, Ravenna Festival), Spain (the Teatro Real) and Germany (Baden-Baden).
        

    

    

            


			

		





	


	

	

		


			

				

					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