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 (14695,16143,17753,19161,35516,37153,37160,37245,38703,38711,38796,40151,40160,40243,41551,41689,43083,44443,45795,47140,48480,49813,51141,52460,53775,55084,56384,56520,57748,57881,59818,59951,61881,62015,63935,64070,65982,66117,68027,68163,70069,70205,72107,72242,74137,74272,76155,76290,78165,78300,80171,80306,82170,82305,84163,84298,86148,86283,88261,90229,92187,94140,96089,98028,99957,101878,103786,105686,105740,107580,107634,107996,108144,108146,109467,109521,109883,110031,110033,111344,111398,111760,111908,111910,113213,113267,113630,113778,113780,115072,115128,115491,115639,115641,116948,117004,117367,117515,117517,118823,118879,119242,119390,119392,120693,120749,121113,121261,121263,122559,122615,122979,123127,123129,124417,124473,124837,124985,124987,126266,126322,126686,126834,126836,128106,128161,128526,128674,128676,129935,129990,130355,130503,130505,131764,131819,132184,132332,132334,133597,133652,134017,134165,134167,135422,135477,135842,135990,135992,137243,137297,137663,137811,137813,139060,139115,139481,139629,139631,140870,140925,141291,141439,141441,142675,142726,143092,143240,143242,144465,144516,144882,145030,145034,146296,146662,146810,146814,148067,148433,148581,148585,149824,150190,150339,150343,151574,151940,152089,152093,153314,153681,153830,153834,155043,155411,155561,155565,156764,157132,157282,157286,158475,158843,158992,158997,160201,160569,160718,160723,162296,162445,162450,164047,164197,164201,165788,165938,165942,167519,167669,167673,169240,169390,169394,170952,171102,171106,172657,172806,172811,174351,174500,174505,176038,176186,176189,177711,177859,177862,179374,179522,179525,181027,181175,181178,182674,182822,182825,184315,184463,184466,185945,186094,186097,187567,187716,187719,189178,189328,189331,190777,190928,190931,192366,192517,192520,193947,194098,194101,196739,196912,196916,198053,198228,198232,199370,199545,199549,200687,200862,200866,202369,202544,202548,204040,204216,204220,205713,205919,205924,207411,207617,207622,209099,209304,209310,210764,210970,210974,212271,212492,212496,213806,214031,214035,215342,215567,215571,216873,217098,217102,218402,218627,218631,219925,220150,220154,221443,221669,221673,222957,223183,223187,224466,224692,224695,225973,226203,226209,227478,227708,227712,228976,229207,229210,230961,231192,231195,232956,233187,233190,234946,235177,235180,236931,237162,237168,238905,239136,239142,240871,241102,241108,242832,243063,243069,244789,245022,245028,246743,246974,246980,248690,248921,248927,250639,250868,250871,252622,252851,252854,254596,254825,254828,256560,256790,256793,258521,258750,258753,260487,260717,260720,262447,262677,262680,264414,264643,264646,266374,266603,266606,268326,268554,268557,270267,270495,270498,272206,272434,272437,274139,274367,274370,276073,276301,276304,277996,278228,278231,279873,280105,280108,281741,281973,281976,283600,283832,283835,285457,285689,285692,287311,287544,287547,289386,289390,291225,291228,293121,293124,295010,295013,296890,296893,298764,298767,300634,300637,302526,302528,304408,304410,306340,306342,308264,308266,310182,310184,312096,312098,314004,314007,315909,315912,317807,317810,319697,319700,321576,321579,323444,323449,325341,325344,327241,327246,329140,329143,331030,331034,332915,332920,334790,334795,336656,336661,338525,338528,340407,340409,342331,342333,344255,344256,346171,346172,348078,348079,349968,349969,351846,351851,353724,353725,355597,355598,357474,357475,359381,359385,361280,361284,363170,363174,365052,365057,366934,366935,368810,368815,370679,370684,372543,372548,374401,374403,376245,376248,378081,378083,379914,379916,381742,381744,383561,383564,385377,385379,387184,387187,388996,388998,390796,390799,392596,392599,394396,457393,458959,460514,462063,463615,465162,466705,468403,470104,471655,473196,474776,476353,477924,477937,477974,478043,479497,479506,479542,479613,481056,481069,481109,481815,481852,482553,482590,483329,484066,484817,485562,486300,487024,487743,488454,489168,489876,497342,498806,500260,501715,523777,525197,526605,528009,529413,530813,532207,533593,535027,536451,537880,539305,540721,542153,543598,545068,546520,547975,549426,549553,550869,550996,552305,552431,553733,553854,555269,556676,558078,559475,560868,562254,563636,565005,566365,567729,569079,570426,571767,573145,574517,575878,577236,578588,579929,581262,582586,583910,583956,584008,584018,585222,585269,585320,585331,586535,586580,586625,586642,587838,587883,587933,587946,589179,589228,589242,590823,590869,590883,592440,592486,592498,594067,594114,594130,595767,595820,595830,597457,597509,597520,599138,599190,599200,600810,600863,600873,602539,602549,604206,604216,605864,605874,607513,607523,609152,609161,610839,610848,612517,612528,614194,614202,615856,615864,617504,617513,619150,620778,622404,638395,638467,639934,640006,641464,641536,642986,643053,644498,644565,646004,646071,647501,647573,649063,650554,652039,653515,654981,656436,657881,659330,660766,662192,663612,665026,666431,693916,693927,695164,695175,696397,696404,697617,697624,698824,698831,700028,701217,732036,733022,734011,734993,735962,736021,736939,736996,737907,737965,738867,738925,739820,739878,741791,741849,743767,743824,745740,745793,747702,747755,749686,749739,751668,751721,753650,753703,756526,756579,759396,759449,762263,762316,765126,765179,767982,768035,770831,770884,773673,773727,776509,776564,779342,779397,782178,782233,785010,785065,787838,787893,790662,790717,793482,793537,796288,796347,799095,799154,801898,801957,804696,804755,807489,807548,810276,810335,813057,813116,815833,815892,818605,818663,821369,821427,824125,824182,826874,826932,829618,829676,832358,832416,835094,835150,837823,837882,840550,840609,843272,843332,846017,846077,848753,848813,851484,851544,854216,854277,856945,857005,859667,859732,862384,862448,865091,865156,867786,867851,870470,870535,873156,873218,875838,875901,878525,878588,881209,881272,883958,886633,889298,891960,894615,897269,899918,902555,902632,902662,902690,905187,905265,905291,905320,907804,907882,907908,907940,910418,910496,910522,910554,913031,913108,913133,913164,915739,915764,915795,918443,918468,918499,921136,921161,921192,923815,923840,923872,926504,926534,926565,929223,929248,929280,931932,931957,931989,934639,934664,934696,937344,937369,937400,940075,940100,940130,942793,942818,942848,945498,945523,945553,948200,948225,948255,950905,950930,950961,953604,953630,953660,956293,956320,956353,958997,959029,961654,961684,964294,964324,966930,966960,969562,969592,972190,972220,974840,977452,980059,982651,985237,987861,990480,993091,1006243,1008810,1011368,1013948,1016516,1019061,1021608,1024153,1024179,1026688,1026714,1029218,1029249,1031679,1031744,1031774,1034182,1034247,1034276,1036672,1036737,1036765,1039161,1039234,1039254,1041645,1041717,1041738,1044121,1044193,1044214,1046588,1046660,1046681,1049045,1049117,1049138,1051489,1051561,1051584,1053920,1053991,1054014,1056347,1056418,1056441,1058769,1058840,1058863,1061178,1061249,1061272,1063579,1063648,1063673,1065973,1066042,1066067,1068354,1068424,1068449,1070723,1070794,1070819,1073123,1073192,1073219,1075516,1075585,1075612,1077899,1077968,1077995,1080269,1080339,1080366,1082699,1082726,1085041,1085071,1087375,1087399,1089689,1089719,1092019,1092049,1094341,1094371,1096658,1096680,1098954,1098975,1101230,1101252,1103501,1103523,1105750,1105774,1107978,1108002,1110207,1112394,1114562,1707881,1710646,1713406,1716186,1718954,1721709,1724454,1727193,1729925,1732636,1735340,1738035,1740716,1743383,1746045,1748698,1751342,1753980,1756609,1759227,1761832,1764433,1767029,1769618,1772198,1774772,1777340,1779892,1782439,1784977,1847900,1850046,1852191,1854331,1856470,1858598,1860714,1862829,1864940,1867041,1869128,1871208,1873273,1875329,1877382,1879457,1881524,1883583,1885635,1887704,1889761,1891819,1893894,1895981,1915684,1915705,1917900,1917918,1920098,1920118,1922297,1922317,1924483,1924503,1926731,1926751,1928972,1928991,1931205,1931220,1933417,1933440,1935618,1935639,1937814,1937835,1940003,1940024,1942181,1942203,1944352,1944374,1946512,1946533,1948661,1948681,1950797,1950817,1952928,1952949,1955055,1955071,1957131,1957147,1959195,1959211,1961245,1961264,1963282,1963301,1965310,1965332,1967330,1967355,1969350,1969372,1971360,1971385,1973373,1973394,1975367,1975392,1977355,1977377,1979324,1979349,1981323,1981345,1983315,1983337,1985299,1985324,1987278,1987299,1989248,1989269,1991202,1991224,1993141,1993166,1995078,1995100,1997007,1997029,1998929,1998954,2000843,2000868,2002746,2002771,2004637,2004659,2006512,2006537,2008398,2008419,2010283,2010305,2012159,2012182,2014025,2014049,2015865,2015889,2017695,2017711,2019502,2019526,2021309,2021333,2023110,2023134,2024907,2024926,2026896,2026920,2028886,2028910,2030865,2030889,2032833,2032851,2034789,2034813,2036746,2036765,2038691,2038710,2040629,2040648,2042554,2042574,2044464,2044488,2046361,2046382,2048251,2048275,2050133,2050154,2052006,2052026,2053870,2053894,2055821,2055845,2057858,2057874,2059892,2059907,2061919,2061934,2063939,2063954,2065948,2065964,2067973,2069976,2071969,2112760,2112807,2114665,2114713,2116561,2116611,2118457,2118502,2120338,2120382,2122207,2122257,2124067,2124118,2125961,2127801,2129629,2131450,2133259,2135060,2136850,2138691,2140530,2197273,2198799,2200333,2201886,2203427,2204958,2206486,2208013,2209528,2211031,2212524,2214224,2215913,2217595,2219374,2221610,2223836,2226051,2228251,2230439,2232619,2235036,2237658,2240569,2243746,2246913,2250070,2253219,2256356,2259488,2262607,2265720,2268822,2271914,2275027,2278172,2281306,2284456,2287598,2290731,2293858,2296975,2300099,2303228,2306378,2309547,2312709,2315871,2319026,2322177,2325319,2328454,2331579,2334686,2337784,2340882,2343994,2347097,2350196,2353321,2356436,2359539,2362636,2365727,2368806,2371876,2374934,2377978,2381012,2384041,2387062,2390126,2393183,2396235,2399273,2402293,2405307,2408319,2411318,2414311,2417292,2420300,2423298,2426284,2429267,2432238,2435202,2438157,2441096,2444023,2446946,2449862,2452765,2455655,2458533,2461406,2464263,2467114,2469987,2472917,2475828,2478769,2481693,2484602,2487507,2490449,2493379,2496299,2795711,2798780,2801839,2804889,2807856,2810800,2813724,2816640,2819621,2822591,2825573,2828542,2831493,2834423,2837346,2840274,2843191,2844630,2846058,2847477,2848885,2851739,2853159,2854572,2855982,2857385,2858781,2860168,2861544,2864320,2867097,2868470,2869873,2871249,2872620,2873985,2937808,2940313,2942810,2945298,2947768,2950217,2952670,2954762,2955107,2955123,2957245,2957593,2957609,2959720,2960068,2960084,2962182,2962530,2962546,2964620,2964968,2964984,2967040,2967388,2967404,2969454,2969803,2969819,2971872,2972222,2972238,2974264,2974614,2974630,2976645,2976995,2977011,2979013,2979360,2979376,2981393,2981740,2981756,2983761,2984111,2984127,2986126,2986476,2986492,2988507,2988856,2988872,2990879,2991228,2991244,2993247,2993596,2993612,2995951,2995967,2998289,2998305,3000609,3000625,3002927,3002943,3005224,3005240,3007456,3007472,3009647,3009663,3011827,3011843,3013984,3014000,3016129,3016145,3018268,3018284,3020460,3020476,3022237,3023712,3025178,3026628,3028068,3029502,3030929,3032347,3033751,3035343,3036924,3038493,3040054,3041604,3043149,3044685,3046218,3047733,3049240,3050748,3052253,3053743,3055221,3056695,3058156,3059603,3061045,3062786,3064514,3064531,3066237,3066253,3067947,3067960,3069643,3069660,3071329,3071349,3073025,3074697,3076355,3089917,3091543,3093153,3094752,3096345,3097931,3099511,3101081,3102640,3104188,3105725,3107278,3108827,3110396,3111953,3113500,3115034,3116556,3118070,3119579,3121084,3122614,3124309,3125994,3127671,3129335,3130991,3132638,3134278,3135918,3137551,3139172,3140784,3142388,3143982,3145572,3147152,3147788,3148418,3149042,3149666,3151213,3152752,3154285,3155808,3157324,3158831,3160325,3161810,3163287,3164759,3166222,3167660,3167773,3169054,3169167,3170439,3170552,3171816,3171929,3173187,3173300,3174552,3174664,3175954,3176066,3177352,3177464,3177597,3177647,3177663,3178742,3178853,3178986,3179040,3179056,3180214,3180325,3180458,3180512,3180528,3181682,3181793,3181926,3181980,3181996,3183148,3183259,3183392,3183442,3183458,3184611,3184722,3184795,3184857,3184907,3184923,3186072,3186183,3186256,3186318,3186368,3186384,3187529,3187640,3187713,3187775,3187825,3187841,3188980,3189091,3189164,3189226,3189276,3189292,3190423,3190541,3190608,3190669,3190722,3190737,3191864,3191982,3192050,3192110,3192163,3192178,3193300,3193415,3193483,3193550,3193604,3193630,3194993,3195104,3195175,3195236,3195295,3195321,3196778,3196889,3196958,3197021,3197080,3197106,3198751,3198868,3198936,3199000,3199056,3199081,3200719,3200836,3200902,3200965,3201017,3201033,3202417,3202534,3202602,3202662,3202716,3202731,3204111,3204227,3204294,3204357,3204408,3204424,3205800,3205917,3205985,3206049,3206099,3206114,3207489,3207601,3207671,3207734,3207786,3207801,3209167,3209280,3209350,3209414,3209466,3209481,3210842,3210957,3211025,3211089,3211139,3211154,3212560,3212677,3212745,3212808,3212858,3212873,3214263,3214378,3214448,3214509,3214562,3214577,3215956,3216077,3216144,3216204,3216258,3216273,3217652,3217765,3217836,3217899,3217951,3217967,3219340,3219457,3219524,3219588,3219640,3219655,3221019,3221132,3221203,3221266,3221318,3221334,3222685,3222803,3222873,3222933,3222990,3223006,3224350,3224469,3224537,3224601,3224655,3224671,3225979,3226099,3226166,3226230,3226285,3226300,3227594,3227714,3227781,3227843,3227900,3227916,3229212,3229332,3229398,3229462,3229517,3229533,3230836,3230953,3231021,3231086,3231141,3231156,3232451,3232566,3232636,3232699,3232756,3232772,3234061,3234175,3234247,3234310,3234365,3234381,3235660,3235778,3235846,3235909,3235964,3235980,3237362,3237430,3237492,3237548,3237564,3238931,3238999,3239063,3239118,3239134,3240498,3240567,3240627,3240685,3240701,3242101,3242167,3242235,3242289,3242304,3243694,3243761,3243824,3243879,3243895,3245274,3245344,3245405,3245461,3245477,3246879,3246945,3247006,3247064,3247079,3248466,3248528,3248594,3248650,3248665,3250036,3250101,3250161,3250219,3250235,3251602,3251666,3251728,3251784,3251800,3253162,3253223,3253298,3253388,3253403,3254759,3254822,3254899,3255006,3255044,3256772,3256834,3256908,3256959,3257017,3257054,3258779,3258846,3258919,3258970,3259028,3259065,3260774,3260842,3260917,3260966,3261023,3261062,3262759,3262823,3262903,3262947,3263008,3263045,3264739,3264808,3264882,3264928,3264988,3265026,3266717,3266783,3266858,3266907,3266967,3267005,3268700,3268769,3268847,3268891,3268951,3268990,3270749,3270816,3270897,3270940,3271019,3271071,3272877,3272945,3273023,3273067,3273144,3273198,3274990,3275056,3275134,3275178,3275255,3275307,3277079,3277149,3277226,3277270,3277348,3277401,3279167,3279235,3279313,3279360,3279439,3279488,3281305,3281372,3281446,3281494,3281570,3281621,3283429,3283497,3283525,3283579,3283621,3283701,3283710,3283722,3283751,3285551,3285621,3285648,3285698,3285741,3285819,3285831,3285839,3285873,3287698,3287769,3287796,3287843,3287890,3287969,3287980,3287988,3288020,3289830,3289903,3289930,3289979,3290024,3290105,3290118,3290120,3290154,3292019,3292046,3292095,3292141,3292220,3292235,3292241,3292271,3294124,3294152,3294198,3294245,3294324,3294339,3294342,3294375,3296225,3296250,3296300,3296347,3296426,3296440,3296445,3296474,3298318,3298344,3298392,3298438,3298517,3298529,3298538,3298568,3300402,3300428,3300480,3300523,3300604,3300615,3300621,3300654,3302477,3302503,3302556,3302598,3302678,3302692,3302698,3302729,3304540,3304568,3304620,3304663,3304742,3304753,3304761,3304794,3306588,3306614,3306667,3306711,3306791,3306801,3306809,3306841,3308634,3308660,3308715,3308757,3308838,3308848,3308854,3308887,3310676,3310700,3310754,3310799,3310878,3310888,3310895,3310929,3312709,3312736,3312785,3312832,3312910,3312921,3312928,3312959,3314730,3314753,3314808,3314851,3314926,3314939,3314944,3314976,3316738,3316768,3316815,3316862,3316940,3316954,3316960,3316988,3318740,3318769,3318815,3318864,3318940,3318955,3318958,3318988,3320728,3320753,3320808,3320850,3320926,3320938,3320949,3320978,3322713,3322738,3322793,3322835,3322911,3322923,3322934,3322964,3324860,3324888,3324935,3324983,3325060,3325073,3325077,3325108,3327130,3327158,3327204,3327253,3327330,3327343,3327347,3327378,3329521,3329545,3329598,3329640,3329716,3329727,3329738,3329769,3331899,3331927,3331974,3332021,3332097,3332113,3332119,3332149,3334264,3334292,3334341,3334386,3334463,3334480,3334484,3334514,3336644,3336692,3336739,3336817,3336832,3336836,3336867,3338994,3339043,3339089,3339166,3339176,3339186,3339214,3341337,3341386,3341432,3341508,3341518,3341529,3341557,3343673,3343726,3343769,3343844,3343857,3343866,3343896,3346028,3346079,3346124,3346201,3346218,3346221,3346253,3348383,3348435,3348476,3348555,3348565,3348575,3348605,3350717,3350768,3350814,3350893,3350901,3350914,3350940,3353090,3353136,3353213,3353230,3353236,3353264,3355408,3355457,3355534,3355547,3355551,3355582,3357743,3357787,3357865,3357873,3357886,3357912,3360089,3360131,3360208,3360220,3360225,3360258,3362445,3362493,3362572,3362586,3362589,3362622,3362804,3364799,3364846,3364923,3364937,3364941,3364973,3365156,3367141,3367188,3367265,3367278,3367281,3367315,3367498,3369469,3369518,3369596,3369606,3369615,3369643,3369825,3371795,3371841,3371919,3371934,3371942,3371969,3372152,3374114,3374161,3374236,3374247,3374260,3374288,3374469,3376427,3376471,3376550,3376564,3376569,3376600,3376783,3378732,3378779,3378854,3378869,3378878,3378905,3379086,3381027,3381074,3381154,3381165,3381173,3381202,3381385,3383345,3383423,3383435,3383439,3383470,3383652,3385630,3385706,3385716,3385723,3385756,3385940,3387898,3387973,3387984,3387997,3388023,3388207,3390158,3390233,3390249,3390251,3390285,3390468,3392407,3392484,3392496,3392502,3392536,3392719,3394646,3394721,3394738,3394745,3394774,3394953,3396867,3396944,3396959,3396961,3396995,3397178,3399082,3399158,3399172,3399179,3399209,3399391,3401283,3401362,3401373,3401381,3401411,3401595,3403475,3403554,3403562,3403575,3403601,3403785,3405734,3405743,3405755,3405781,3405964,3407902,3407915,3407919,3407952,3408136,3410067,3410078,3410084,3410116,3410303,3412210,3412224,3412232,3412258,3412445,3414378,3414387,3414395,3414429,3414614,3416526,3416540,3416542,3416574,3416763,3418668,3418682,3418683,3418716,3418903,3420787,3420802,3420810,3420837,3421024,3422888,3422901,3422906,3422938,3423127,3424971,3424986,3424988,3425020,3425209,3427029,3427043,3427046,3427078,3427267,3429073,3429088,3429094,3429121,3429306,3431097,3431112,3431117,3431146,3431337,3433119,3433129,3433157,3433343,3435121,3435133,3435162,3435344,3437120,3437127,3437159,3437345,3439110,3439136,3439320,3441102,3441292,3443069,3443251,3445045,3445229,3447199,3447380,3449344,3449530,3451484,3451663,3453614,3453796,3455734,3455914,3457859,3458045,3459982,3460167,3462303,3464432,3466579,3468761,3470929,3473081,3475237,3477392,3479535,3481671,3483801,3485927,3488035,3490144,3492271,3494397,3496512,3498665,3500810,3502944,3505074,3507199,3509320,3511433,3513543,3515640,3517727,3519753,3519813,3521829,3521893,3523899,3523959,3525962,3526022,3528072,3530134,3530349,3532177,3532397,3534219,3534437,3536256,3536473,3538288,3538438,3538441,3538445,3538449,3538505,3540313,3540461,3540465,3540467,3540469,3540528,3542379,3542533,3542536,3542537,3542539,3542599,3544438,3544588,3544594,3544595,3544598,3544656,3546481,3546630,3546633,3546635,3546637,3546698,3548514,3548667,3548671,3548673,3548677,3548735,3550549,3550699,3550701,3550703,3550710,3550765,3552587,3552741,3552742,3552744,3552747,3552810,3554625,3554773,3554777,3554778,3554785,3554843,3556659,3556813,3556816,3556818,3556820,3556883,3558685,3558837,3558841,3558842,3558845,3558904,3560851,3560855,3560856,3560858,3560919,3562852,3562856,3562859,3562865,3562922,3564855,3564858,3564861,3564865,3564921,3566873,3566875,3566876,3566885,3566939,3568885,3568888,3568889,3568892,3568951,3570903,3570908,3570910,3570913,3570971,3572913,3572917,3572919,3572923,3572982,3574926,3574930,3574932,3574934,3574993,3576833,3576836,3576839,3576842,3576902,3578737,3578740,3578741,3578743,3578805,3580635,3580639,3580640,3580642,3580701,3582505,3582510,3582511,3582513,3582565,3584367,3584369,3584370,3584372,3584424,3586222,3586226,3586227,3586229,3586280,3588078,3588080,3588081,3588083,3588135,3589928,3589933,3589934,3589936,3589988,3591777,3591779,3591780,3591786,3591834,3593624,3593626,3593627,3593629,3593681,3595595,3595597,3595600,3595605,3595665,3597586,3597591,3597592,3597596,3597659,3599562,3599568,3599569,3599572,3599634,3601522,3601525,3601527,3601529,3601592,3603470,3603473,3603474,3603482,3603542,3605409,3605411,3605414,3605420,3605478,3607335,3607338,3607339,3607342,3607404,3609253,3609255,3609257,3609263,3609325,3611160,3611165,3611167,3611169,3611233,3613057,3613060,3613064,3613068,3613126,3614981,3614984,3614985,3614988,3615051,3616894,3616899,3616901,3616903,3616966,3618803,3618805,3618808,3618814,3618871,3620702,3620705,3620706,3620715,3620775,3622602,3622604,3622605,3622614,3622673,3624494,3624497,3624500,3624502,3624565,3626371,3626374,3626378,3626384,3626440,3628239,3628242,3628245,3628248,3628312,3630103,3630104,3630108,3630111,3630173,3631962,3631963,3631966,3631970,3632032,3633814,3633816,3633818,3633825,3633881,3635656,3635659,3635661,3635663,3635725,3637496,3637498,3637500,3637560,3639326,3639384,3641197,3642999,3644794,3646582,3648360,3650131,3651890,3653637,3655375,3657107,3658830,3659324,3660549,3661051,3662274,3662778,3663990,3664489,3665692,3666196,3667889,3669580,3671259,3672929,3674597,3676250,3677891,3679535,3681169,3682797,3684425,3686042,3687647,3689253,3690847,3692439,3694020,3695593,3697168,3698721,3700265,3701804,3703336,3704863,3706382,3707889,3709387,3710871,3712357,3713835,3715305,3716771,3718231,3719685,3721133,3722572,3724007,3725436,3726861,3728278,3729689,3731089,3732480,3733868,3735245,3736612,3737975,3739326,3740671,3742013,3743342,3744660,3745980,3747284,3748586,3749874,3751160,3752431,3753701,3754962,3756215,3757467,3758715,3759955,3761189,3762414,3763633,3764851,3766061,3767262,3768456,3769646,3770036,3770426,3770813,3771191,3771571,3771952,3772324,3772697,3773068,3773432,3773803,3774167,3774532,3774895,3775256,3775615,3775972,3776325,3776673,3777025,3777374,3777719,3778059,3778394,3778724,3779049,3779379,3779705,3780026,3780342,3780657,3780968,3781273,3781573,3781870,3782162,3782450,3782733,3783018,3783300,3783579,3783855,3784127,3784398,3784664,3784926,3785184,3785439,3785715,3786049,3786380,3786730,3787076,3787418,3787757,3788092,3788425,3788754,3789080,3789403,3789721,3790037,3790350,3790661,3790968,3791272,3791573,3791870,3792165,3792457,3792746,3793033,3793316,3793595,3793870,3794143,3794412,3794678,3794942,3795204,3795463,3795717,3795984,3796249,3796511,3796770,3797025,3797275,3797519,3797761,3797999,3798234,3798466,3798697,3798923,3799143,3799362,3799578,3799792,3800003,3800212,3800417,3800620,3800822,3801022,3801219,3801413,3801604,3801790,3807835,3807845,3808211,3808221,3808584,3808594,3808953,3808963,3809321,3809331,3809687,3809697,3810059,3810415,3810771,3827417,3827427,3827757,3827766,3828097,3828102,3828425,3828433,3828753,3828763,3829077,3829088,3829400,3829404,3829720,3829722,3830035,3830037,3830342,3830352,3830645,3830651,3830950,3840288,3840541,3840824,3841103,3841378,3841650,3841917,3842179,3842439,3842706,3842971,3843234,3843492,3843746,3843997,3860816,3860848,3861610,3861645,3862401,3862438,3863191,3863228,3863980,3864016,3864762,3864798,3865543,3865577,3866320,3866355,3867094,3867132,3867868,3867902,3868639,3868672,3869405,3869440,3870172,3870209,3870935,3870972,3871693,3871731,3872445,3872473,3873180,3873220,3873935,3873975,3874691,3874728,3875438,3875478,3876190,3876225,3876935,3876971,3877676,3877714,3878422,3878458,3879161,3879201,3879904,3879941,3880645,3880682,3881387,3881425,3882133,3882169,3882872,3882912,3883613,3883653,3884356,3884392,3885093,3885131,3885829,3885867,3886563,3886602,3887301,3887336,3888034,3888069,3888764,3888800,3889491,3889530,3890219,3890256,3890944,3890978,3891663,3891698,3892378,3892414,3893096,3893131,3893805,3893843,3894566,3895282,3895995,3896703,3897410,3898116,3898817,3899519,3900217,3900935,3901649,3902362,3903075,3907325,3908015,3908703,3909386,3910063,3910754,3911441,3912125,3912808,3913489,3914167,3914840,3914861,3915544,3916220,3916899,3917572,3918237,3918249,3918911,3918923,3919603,3919612,3920288,3920300,3920978,3921658,3922363,3923042,3923720,3924395,3925063,3925727,3926390,3927053,3927713,3953335,3953952,3954565,3955173,3955780,3956382,3957005,3957628,3958246,3975051,3979897,3980480,3981063,3981638,3982211,3982784,3983354,3983926,3984493,3994308,3994322,3994832,3994848,3995352,3995367,3995868,3995881,3996398,3996901,3997402,4035104,4035462,4036364,4037266,4038185,4039098,4040005,4040907,4132022,4132023,4132027,4132029,4132693,4132694,4132698,4132699,4133360,4133361,4133366,4133368,4134027,4134028,4134030,4134033,4134690,4134691,4134696,4134697,4135353,4135355,4135357,4135358,4136016,4136021)) 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





	Andrei Serov (Bass-baritone) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Andrei Serov (Bass-baritone)
			

																
Andrei Serov (Bass-baritone)

														
				


        




    

        
Andrei Serov was born in Klin, Moscow Region. In 2001 he graduated from the Institute of Contemporary Art (Moscow) and became a soloist with the Moscow Regional Philharmonic. 
From 2005-2007 he was a soloist with the Helikon Opera (Moscow). 
Soloist with the Mariinsky Academy of Young Singers since 2007. 
Repertoire at the Mariinsky Theatre includes: 
Ivan Nikiforovich (The Opera of How Ivan Ivanovich Quarrelled with Ivan Nikiforovich) 
the Water-Sprite (Antonнn Dvoшбk’s Rusalka) 
Head of the Village (May Night) 
Ivan Fyodorovich Shponka (Ivan Fyodorovich Shponka and his Aunt) 
the General (The Carriage) 
Sancho Panзa (Don Quichotte in concert) 
Repertoire also includes: Boris Godunov (Boris Godunov), Tsar Saltan (The Tale of Tsar Saltan), Figaro (Le nozze di Figaro), Don Bartolo (Il barbiere di Siviglia) and Il Commendatore (Don Giovanni). 
He has toured to France, Denmark, Israel, Germany, Hungary, Italy, Korea and Estonia. 
        

    

    

            


			

		





	


	

	

		


			

				

					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