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 (8456,10160,11743,13326,14675,14791,16125,16243,17735,17853,19241,20683,22166,23620,25086,26892,27915,29230,31034,32549,34073,35558,37266,38820,38831,40266,40281,41575,41589,42970,42984,44346,45698,56441,56512,57806,57874,59876,59944,61939,62008,63994,64063,66040,66110,68085,68155,70127,70197,72163,72234,74193,74263,76211,76281,78221,78291,80227,80297,82226,82301,84219,84294,86204,86279,88182,88257,90150,90225,92108,92181,94061,94131,96010,96083,97949,98022,99878,99951,101799,101872,103708,103781,105608,105681,105734,107502,107575,107628,108103,109388,109462,109515,109990,111339,111392,111867,113208,113260,113737,115068,115121,115598,116944,116997,117474,118819,118872,119349,120689,120742,121220,122555,122607,123086,124413,124465,124944,126262,126313,126793,128102,128153,128633,129930,129982,130462,131759,131811,132291,133592,133644,134124,135417,135469,135949,137238,137290,137770,139055,139108,139588,140865,140918,141398,142666,142719,143199,144509,144988,146289,146768,148060,148539,149821,150297,151571,152047,153311,153619,153788,155041,155350,155519,156762,157071,157240,158473,158781,158951,160507,160677,162234,162404,163988,164155,165729,165896,167458,167627,169179,169348,170891,171060,172596,172765,174290,174459,175974,176143,177646,177816,179310,179479,180964,181132,182611,182779,184252,184420,185883,186051,187505,187673,189117,189285,190717,190885,192306,192474,193887,194055,196660,196867,197972,198183,198391,198401,199289,199500,199708,199718,200606,200817,201025,201035,202288,202499,202707,202717,203960,204171,204378,204389,205634,205868,206085,206095,207332,207566,207782,207793,209020,209254,209470,209481,210684,210918,211134,211144,212186,212308,212435,212668,212678,213722,213843,213972,214207,214217,215257,215379,215508,215743,215753,216788,216910,217039,217274,217284,218317,218439,218568,218803,218813,219840,219962,220091,220326,220336,221359,221481,221610,221845,221855,222874,222995,223124,223359,223369,224383,224504,224633,224868,224878,225889,226015,226144,226379,226389,227394,227520,227649,227884,227894,228893,229019,229148,229383,229393,230878,231004,231133,231368,231378,232873,232999,233128,233363,233373,234863,234989,235118,235353,235363,236846,236973,237103,237338,237348,238821,238948,239077,239312,239322,240787,240912,241043,241278,241288,242748,242873,243004,243239,243249,244709,244831,244964,245200,245210,246663,246785,246917,247152,247162,248610,248732,248864,249099,249109,250553,250676,250806,251043,251053,252537,252659,252789,253026,253036,254633,254763,255000,255010,256602,256728,256964,256975,258558,258688,258938,258948,260530,260655,260905,260915,262490,262615,262864,262875,264451,264581,264831,264841,266416,266541,266791,266801,268368,268492,268742,268752,270309,270433,270683,270692,272248,272372,272622,272631,274181,274237,274305,274555,274564,276114,276170,276239,276489,276499,278039,278095,278166,278416,278426,279916,279972,280043,280293,280303,281784,281840,281911,282161,282171,283643,283699,283770,284019,284030,285500,285556,285627,285876,285887,287354,287411,287482,287730,287740,289196,289254,289329,289575,289585,291036,291093,291163,291461,291474,292932,292989,293059,293357,293370,294821,294877,294948,295246,295259,296701,296758,296828,297126,297139,298575,298631,298706,299002,299016,300444,300501,300576,300873,300887,302335,302393,302464,302763,302776,304275,304346,304645,304658,306201,306278,306577,306590,308125,308202,308501,308514,310043,310120,310419,310432,311958,312034,312333,312346,313867,313943,314242,314255,315772,315848,316147,316160,317670,317746,318045,318058,319560,319636,319935,319948,321439,321515,321814,321827,323309,323385,323684,323697,325204,325280,325589,325602,327101,327180,327497,327510,329079,329395,329408,330970,331288,331301,332856,333174,333187,334731,335049,335062,336597,336915,336928,338463,338795,338809,340344,340725,340739,342268,342374,342649,342663,344194,344298,344573,344587,346110,346214,346496,346510,348017,348121,348403,348417,349907,350011,350293,350307,351783,351894,352173,352187,353663,353766,354049,354063,355533,355639,355929,355944,357410,357516,357806,357821,359317,359423,359713,359728,361216,361322,361614,361629,363108,363218,363505,363520,365101,365388,365405,366980,367269,367285,368853,369145,369162,370728,371016,371033,372592,372880,372897,374447,374735,374752,376292,376580,376597,378127,378415,378432,379960,380248,380265,381788,382076,382093,383605,383898,383913,385423,385713,385728,387228,387521,387535,389041,389332,389346,390841,391133,391149,392640,392932,392949,394440,394727,394742,396228,396519,396535,398012,398304,398320,399794,400082,400097,401559,401850,401867,403322,403610,403624,405079,405366,405382,406831,407118,407135,408578,408865,408881,410318,410605,410621,412086,412372,412387,414129,414144,415872,415887,417612,417627,419352,419367,421085,421102,422815,422832,424540,424557,426254,426271,427953,427969,429647,429663,431358,431378,433060,433078,434758,434776,436452,436472,438135,438155,439803,439823,441460,441479,443102,443121,444732,444750,446354,446372,447968,447986,449570,449588,451162,451180,452752,452770,454340,454360,455920,455940,457494,457514,459061,459081,460617,460637,462165,462185,463717,463737,465265,465285,466807,466827,468511,468531,470216,470236,471767,471787,473309,473327,474889,474908,476466,476484,478041,478059,479611,479630,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,497338,497354,498802,498818,500258,500273,501712,501727,503220,504698,506170,507641,523779,525203,526606,528010,529414,530814,532208,533598,535028,536452,537881,539306,540722,542154,543602,545072,546526,547982,549432,550875,552309,553736,555152,638482,638533,640020,640072,641550,641602,643071,643124,644584,644637,646089,646143,647590,647637,649080,649128,650572,650625,652057,652103,653533,653579,654999,655045,656454,656500,657901,657952,659350,659400,660787,660837,662214,662264,663634,663690,665048,665104,666451,666509,667886,667944,669311,669364,670745,670803,672174,672227,673644,675055,676450,677836,679242,680636,682023,683396,684763,736023,737001,737969,738929,739882,741853,743828,745797,747761,749743,751725,753707,756583,759455,762322,765185,768041,770890,773733,776570,779403,782239,785071,787899,790723,793543,796354,799161,801964,804762,807555,810342,813123,815899,818670,821434,824190,826939,829683,832422,835159,837891,840617,843340,846085,848821,851552,854285,857014,859736,862452,865158,867852,870536,873219,875902,878589,881273,883959,886638,889303,891965,894620,897274,899925,902562,905194,907809,910423,913036,915668,1024170,1026705,1029243,1031641,1031667,1031703,1031766,1034144,1034169,1034206,1034269,1036634,1036659,1036697,1036759,1039123,1039148,1039186,1039248,1039330,1041607,1041632,1041670,1041732,1041814,1044083,1044108,1044146,1044208,1044290,1046550,1046575,1046613,1046675,1046757,1049007,1049032,1049070,1049132,1049214,1051452,1051476,1051514,1051577,1051658,1053881,1053906,1053944,1054008,1054088,1056308,1056333,1056371,1056435,1056515,1058730,1058754,1058793,1058857,1058937,1061163,1061202,1061266,1061345,1063563,1063603,1063667,1063746,1065957,1065997,1066061,1066140,1068339,1068378,1068443,1068522,1070712,1070748,1070811,1070892,1073112,1073147,1073211,1073294,1075540,1075604,1075687,1077923,1077987,1078070,1080294,1080358,1080441,1082654,1082718,1082801,1084999,1085063,1085146,1087331,1087390,1087474,1089648,1089711,1089794,1092041,1092124,1094362,1094446,1096668,1096756,1098965,1099053,1101242,1101330,1103513,1103601,1105771,1105851,1107998,1108077,1110203,1110286,1112389,1112473,1114641,1116791,1118928,1118958,1121057,1121088,1123200,1123229,1125333,1125362,1127523,1127553,1129744,1129775,1131947,1131981,1134140,1134172,1136344,1136376,1138545,1138578,1140743,1140775,1142934,1142966,1145117,1145149,1147287,1147319,1149443,1149475,1151596,1151628,1153774,1155916,1158089,1160252,1162398,1164531,1256583,1258549,1260504,1262445,1264372,1266294,1268220,1270134,1272038,1273931,1275810,1277669,1279524,1281373,1283213,1285043,1286861,1288663,1290450,1292262,1317562,1319485,1321398,1323303,1325202,1327078,1328939,1330795,1332676,1334548,1336413,1338265,1340103,1341926,1343738,1345544,1412370,1414133,1415886,1417628,1419362,1421082,1422792,1424487,1426170,1427838,1429495,1431137,1432771,1434393,1436004,1437636,1439250,1440853,1442449,1444040,1445619,1494059,1495360,1496651,1497944,1499242,1500529,1501808,1503080,1504344,1505602,1506851,1508093,1509325,1510550,1511779,1513002,1514227,1515454,1516673,1517883,1519085,1520288,1521478,1522665,1523844,1525016,1526184,1527339,1528491,1529638,1530781,1531920,1533054,1534186,1535310,1536431,1537547,1538687,1539820,1540948,1542070,1543186,1544293,1545395,1546487,1547567,1548635,1549693,1550745,1551789,1552834,1553875,1553876,1554909,1554910,1555928,1555932,1556942,1556944,1557951,1557955,1558955,1558957,1559951,1559954,1561304,1561307,1562997,1562999,1564833,1564836,1566661,1566666,1569300,1569303,1572198,1572200,1575085,1575088,1577962,1577965,1580830,1580833,1583683,1583686,1586522,1586526,1589358,1589362,1592186,1592190,1595009,1595012,1597886,2197482,2199007,2200541,2202096,2203637,2205167,2206695,2208222,2209737,2211241,2212755,2214455,2216144,2217826,2219619,2221855,2224081,2226295,2228496,2230685,2232865,2235281,2237902,2240813,2243990,2247157,2250315,2253462,2256602,2259733,2262853,2265966,2269068,2272160,2275272,2278417,2281554,2284704,2287846,2290978,2294102,2297222,2300346,2300500,2303475,2303629,2306622,2306776,2309791,2309945,2312957,2313111,2316117,2316271,2319273,2319427,2322424,2322578,2325566,2325720,2328699,2328853,2331816,2331970,2334923,2335077,2338021,2338175,2341119,2341273,2344231,2344385,2347334,2347488,2350436,2350590,2353562,2353716,2356675,2356829,2359778,2359932,2362877,2363031,2365967,2366121,2369044,2369198,2372114,2372268,2375173,2375327,2378216,2378371,2381250,2381404,2384279,2384433,2387299,2387453,2390363,2390517,2393423,2393577,2396475,2396629,2399511,2399665,2402533,2402687,2405547,2405701,2408557,2408711,2411558,2411712,2414550,2414704,2417571,2417726,2420579,2420733,2423573,2423727,2426563,2426717,2429546,2429700,2432518,2432672,2435481,2435635,2438433,2438587,2441373,2441527,2444301,2444455,2447225,2447379,2450139,2450293,2453044,2453198,2455934,2456088,2458821,2458974,2461693,2461847,2464549,2464703,2467413,2467576,2470287,2470493,2473213,2473410,2476161,2476358,2479099,2479296,2482023,2482220,2484933,2485130,2487840,2488037,2490780,2490975,2493707,2493902,2496628,2496824,2499538,2499733,2502433,2502628,2505313,2505508,2508180,2508376,2511041,2511236,2513901,2514096,2516755,2516950,2519604,2519799,2522443,2522638,2525270,2525465,2528085,2528280,2530895,2531090,2533700,2533895,2536496,2536691,2539295,2539490,2542087,2542281,2544866,2545061,2547632,2547827,2550422,2550634,2553222,2553434,2556037,2556249,2558845,2559057,2561644,2561856,2564427,2564639,2567196,2567409,2570001,2570244,2572829,2573072,2575648,2575891,2578458,2578700,2581267,2581510,2584057,2584300,2586832,2587075,2589599,2589843,2592365,2592608,2595118,2595361,2597864,2598107,2600603,2600847,2603326,2603569,2606034,2606277,2608739,2608982,2611438,2611681,2614165,2614408,2616887,2617130,2619601,2619844,2622303,2622545,2624987,2625230,2627668,2627914,2630340,2630586,2633001,2633256,2635652,2635907,2638297,2638552,2640926,2641181,2643543,2643800,2646152,2646407,2648747,2649005,2651333,2651590,2653908,2654164,2656472,2656728,2659017,2659275,2661545,2661804,2664052,2664311,2666551,2666810,2669026,2669283,2671479,2671742,2673924,2674189,2676346,2676608,2678752,2679012,2681135,2681395,2683508,2683770,2685873,2686134,2688232,2688494,2690583,2690845,2692920,2693182,2695240,2695501,2697897,2698253,2700971,2701327,2704053,2704409,2707125,2707481,2710161,2710525,2713562,2716585,2719655,2722766,2725868,2728957,2732050,2735160,2738251,2741333,2744405,2747456,2750486,2753513,2756541,2759554,2762569,2765578,2768568,2771542,2774512,2777471,2780455,2783480,2786561,2789640,2792699,2795755,2798824,2801883,2804933,2807900,2810844,2813768,2816684,2819665,2822635,2825617,2828586,2831537,2834467,2837390,2840318,2843236,2844675,2846103,2847522,2848930,2851784,2853204,2854617,2856027,2857430,2858826,2860213,2861589,2864365,2867142,2868515,2869894,2871270,2872641,2874006,2875363,2876709,2878052,2957668,2960143,2962605,2965043,2967463,2969878,2972297,2974689,2977070,2979435,2981815,2984186,2986551,2988931,2991304,2993672,2996027,2998365,3000685,3002728,3003003,3005024,3005300,3007256,3007532,3009443,3009725,3011621,3011904,3013778,3014061,3015921,3016206,3018060,3018345,3020253,3020537,3022095,3022275,3023566,3023748,3025033,3025214,3026482,3026663,3027923,3028106,3029361,3029538,3030965,3032384,3033785,3035377,3036961,3038530,3040089,3041638,3043182,3044719,3046250,3047765,3049274,3050782,3052289,3053776,3055256,3056733,3058192,3059641,3061081,3062817,3064552,3066274,3067980,3069680,3071367,3073046,3074713,3076372,3078027,3079687,3081337,3082975,3084604,3088308,3088380,3089940,3090014,3091565,3091637,3093173,3093247,3094777,3094848,3096368,3096442,3097954,3098025,3099532,3099605,3101103,3101177,3102662,3102737,3104209,3104281,3105747,3105819,3107299,3107373,3108854,3108951,3110423,3110521,3111982,3112080,3113531,3113625,3115062,3115159,3116582,3116682,3118100,3118194,3119606,3119706,3121111,3121208,3122639,3122739,3124336,3124432,3126024,3126119,3127699,3127794,3129360,3129457,3131016,3131113,3132663,3132690,3132760,3134303,3134330,3134400,3135943,3135970,3136040,3137576,3137603,3137673,3137931,3139197,3139224,3139294,3139552,3140809,3140836,3140906,3141164,3142413,3142440,3142510,3142541,3142768,3144007,3144034,3144104,3144135,3144362,3145597,3145624,3145694,3145725,3145952,3147177,3147204,3147274,3147305,3147532,3147813,3147840,3147910,3147941,3148168,3148443,3148470,3148540,3148571,3148798,3149067,3149094,3149164,3149195,3149422,3149691,3149718,3149788,3149819,3150046,3151238,3151265,3151335,3151366,3151593,3152777,3152804,3152874,3152905,3153132,3154310,3154337,3154407,3154438,3154665,3155833,3155860,3155930,3155961,3156188,3157349,3157376,3157446,3157477,3157704,3158856,3158883,3158953,3158984,3159211,3160350,3160377,3160447,3160478,3160705,3161835,3161862,3161932,3161963,3162190,3163312,3163339,3163409,3163440,3163668,3164784,3164811,3164881,3164912,3165140,3166247,3166274,3166344,3166385,3166624,3167680,3167703,3167759,3167797,3168024,3169074,3169097,3169153,3169191,3169418,3170459,3170482,3170538,3170576,3170803,3171836,3171859,3171915,3171953,3172180,3173207,3173230,3173286,3173324,3173551,3174572,3174595,3174650,3174688,3174915,3175974,3175997,3176052,3176090,3176317,3177372,3177395,3177450,3177488,3177661,3177664,3177665,3177715,3178762,3178784,3178839,3178877,3179054,3179057,3179058,3179118,3180234,3180256,3180311,3180349,3180526,3180529,3180530,3180590,3181702,3181724,3181779,3181817,3181994,3181997,3181998,3182058,3183168,3183190,3183245,3183283,3183456,3183459,3183460,3183513,3184631,3184653,3184708,3184746,3184921,3184924,3184925,3184978,3186092,3186114,3186169,3186207,3186382,3186385,3186386,3186439,3187549,3187571,3187626,3187664,3187839,3187842,3187843,3187896,3189000,3189022,3189077,3189115,3189290,3189293,3189294,3189347,3190448,3190467,3190525,3190559,3190735,3190738,3190739,3190792,3191888,3191908,3191965,3192000,3192177,3192179,3192180,3192233,3193325,3193344,3193400,3193435,3193628,3193631,3193632,3193726,3195016,3195035,3195093,3195127,3195317,3195322,3195323,3195417,3196801,3196823,3196876,3196912,3197103,3197107,3197108,3197201,3198774,3198796,3198850,3198886,3199079,3199082,3199084,3199178,3200744,3200765,3200820,3200855,3201032,3201034,3201035,3201088,3202442,3202461,3202519,3202553,3202729,3202732,3202733,3202786,3204135,3204157,3204212,3204246,3204423,3204425,3204426,3204480,3205822,3205844,3205900,3205935,3206113,3206115,3206116,3206169,3207509,3207534,3207589,3207624,3207800,3207802,3207803,3207856,3209189,3209211,3209268,3209304,3209480,3209482,3209483,3209537,3210818,3210862,3210885,3210940,3210975,3211153,3211155,3211156,3211210,3212538,3212582,3212605,3212659,3212694,3212872,3212874,3212875,3212929,3214239,3214286,3214308,3214365,3214400,3214576,3214578,3214579,3214632,3215936,3215981,3216002,3216057,3216095,3216271,3216274,3216275,3216329,3217626,3217675,3217698,3217752,3217789,3217966,3217968,3217969,3218022,3219315,3219362,3219386,3219438,3219477,3219654,3219656,3219657,3219710,3220992,3221041,3221065,3221120,3221155,3221333,3221335,3221336,3221389,3222660,3222708,3222732,3222786,3222824,3223005,3223007,3223008,3223063,3224327,3224374,3224397,3224449,3224487,3224669,3224672,3224673,3224731,3226003,3226025,3226081,3226117,3226298,3226301,3226302,3226360,3227616,3227639,3227697,3227733,3227915,3227917,3227918,3227976,3229233,3229257,3229314,3229350,3229531,3229534,3229535,3229593,3230856,3230882,3230936,3230973,3231155,3231157,3231158,3231215,3232472,3232495,3232550,3232589,3232771,3232773,3232774,3232832,3234082,3234107,3234160,3234197,3234379,3234382,3234383,3234441,3235682,3235706,3235761,3235797,3235978,3235981,3235982,3236039,3237266,3237288,3237345,3237381,3237562,3237565,3237566,3237624,3238837,3238857,3238915,3238952,3239133,3239135,3239136,3239193,3240404,3240425,3240480,3240519,3240700,3240702,3240703,3240761,3242007,3242028,3242084,3242121,3242303,3242305,3242306,3242363,3243599,3243623,3243677,3243715,3243894,3243896,3243897,3243954,3245180,3245206,3245259,3245296,3245476,3245478,3245479,3245537,3246805,3246861,3246898,3247078,3247080,3247081,3247139,3248392,3248449,3248484,3248664,3248666,3248667,3248725,3249962,3250017,3250053,3250233,3250236,3250237,3250295,3251528,3251582,3251619,3251799,3251801,3251802,3251859,3253088,3253141,3253179,3253402,3253404,3253405,3253462,3254740,3254777,3255039,3255046,3255047,3255170,3256753,3256789,3256923,3256954,3257052,3257057,3257059,3257180,3258765,3258801,3258933,3258965,3259063,3259068,3259069,3259192,3260761,3260797,3260929,3260963,3261058,3261064,3261067,3261188,3262742,3262779,3262913,3262943,3263041,3263047,3263048,3263171,3264722,3264760,3264894,3264926,3265022,3265027,3265030,3265151,3266701,3266738,3266870,3266902,3267000,3267008,3267010,3267144,3268686,3268723,3268856,3268889,3268985,3268991,3268994,3269163,3270733,3270771,3270906,3270935,3271067,3271073,3271077,3271252,3272863,3272899,3273033,3273063,3273192,3273202,3273204,3273379,3274970,3275008,3275142,3275174,3275302,3275310,3275316,3275489,3277063,3277102,3277234,3277267,3277396,3277403,3277409,3277582,3279153,3279191,3279325,3279356,3279482,3279491,3279497,3279673,3281286,3281324,3281460,3281491,3281615,3281628,3281632,3281807,3283412,3283450,3283586,3283618,3283743,3283754,3283759,3283934,3285569,3285707,3285738,3285867,3285876,3285878,3286055,3287720,3287858,3287889,3288015,3288026,3288028,3288203,3289854,3289990,3290022,3290150,3290158,3290161,3290336,3291970,3292108,3292138,3292264,3292274,3292279,3292452,3294074,3294212,3294243,3294371,3294379,3294383,3294559,3296175,3296311,3296342,3296469,3296481,3296484,3296660,3298267,3298404,3298437,3298565,3298572,3298578,3298752,3300352,3300490,3300520,3300648,3300657,3300662,3300837,3302565,3302596,3302726,3302733,3302737,3302912,3304628,3304658,3304788,3304796,3304802,3304976,3306677,3306708,3306837,3306846,3306850,3307024,3308723,3308754,3308883,3308893,3308897,3309070,3310765,3310795,3310924,3310934,3310937,3311112,3312798,3312830,3312951,3312964,3312968,3313140,3314816,3314848,3314873,3314973,3314983,3314987,3315160,3316828,3316859,3316887,3316983,3316992,3316995,3317168,3318830,3318859,3318888,3318985,3318994,3318996,3319172,3320817,3320848,3320872,3320974,3320983,3320987,3321159,3322801,3322833,3322857,3322959,3322968,3322971,3323144,3324950,3324981,3325004,3325102,3325115,3325118,3325291,3327219,3327250,3327277,3327372,3327383,3327386,3327563,3329605,3329638,3329663,3329763,3329770,3329777,3329950,3331986,3332019,3332044,3332143,3332152,3332155,3332329,3334352,3334385,3334408,3334509,3334519,3334521,3334695,3336705,3336736,3336760,3336860,3336870,3336873,3337048,3339053,3339085,3339111,3339210,3339220,3339224,3339399,3341397,3341428,3341454,3341552,3341564,3341566,3341741,3343733,3343766,3343793,3343888,3343901,3343905,3344077,3346091,3346121,3346148,3346249,3346257,3346260,3346433,3348444,3348474,3348499,3348598,3348609,3348614,3348787,3350781,3350811,3350835,3350938,3350944,3350951,3351122,3353104,3353133,3353161,3353260,3353269,3353272,3353447,3355421,3355454,3355478,3355578,3355586,3355592,3355764,3357751,3357783,3357812,3357908,3357918,3357920,3358038,3358117,3360096,3360128,3360152,3360255,3360263,3360266,3360382,3360466,3362458,3362491,3362517,3362614,3362625,3362628,3362745,3362831,3364812,3364843,3364868,3364970,3364978,3364982,3365099,3365185,3367154,3367184,3367208,3367309,3367320,3367321,3367438,3367522,3369484,3369514,3369543,3369640,3369647,3369651,3369771,3369853,3371809,3371838,3371863,3371966,3371973,3371978,3372097,3372180,3374125,3374157,3374181,3374281,3374292,3374295,3374415,3374495,3376438,3376469,3376494,3376596,3376605,3376609,3376724,3376809,3378744,3378774,3378800,3378901,3378910,3378913,3379033,3379116,3381041,3381073,3381096,3381198,3381207,3381210,3381327,3381413,3383311,3383342,3383365,3383467,3383475,3383480,3383598,3383679,3385599,3385626,3385654,3385749,3385762,3385766,3385884,3385966,3387893,3387921,3388018,3388029,3388034,3388152,3388233,3390154,3390182,3390280,3390288,3390291,3390408,3390492,3392404,3392430,3392528,3392541,3392544,3392659,3392745,3394641,3394667,3394769,3394777,3394779,3394899,3394983,3396864,3396890,3396991,3396999,3397003,3397120,3397205,3399078,3399104,3399206,3399213,3399218,3399336,3399419,3401281,3401310,3401406,3401416,3401418,3401536,3401621,3403497,3403595,3403605,3403612,3403729,3403811,3405678,3405775,3405786,3405910,3405991,3407846,3407947,3407953,3408077,3408170,3410009,3410110,3410119,3410241,3410338,3412156,3412256,3412264,3412383,3412481,3414420,3414431,3414556,3414585,3414649,3416572,3416581,3416702,3416733,3416796,3418711,3418722,3418844,3418872,3418937,3420833,3420842,3420962,3420996,3421061,3422933,3422945,3423066,3423098,3423163,3425016,3425023,3425146,3425177,3425244,3427074,3427082,3427204,3427238,3427303,3429118,3429128,3429249,3429278,3429343,3431143,3431150,3431273,3431307,3431370,3433153,3433163,3433282,3433316,3433380,3435155,3435166,3435290,3435318,3435381,3437151,3437160,3437285,3437317,3437379,3439133,3439142,3439265,3439297,3439359,3441096,3441109,3441230,3441258,3441325,3443062,3443074,3443193,3443223,3443288,3445036,3445048,3445168,3445200,3445263,3447192,3447202,3447322,3447355,3447417,3449337,3449349,3449466,3449497,3449560,3451476,3451487,3451608,3451637,3451700,3453611,3453620,3453738,3453769,3453834,3455737,3455858,3455890,3455950,3457862,3457981,3458013,3458075,3459987,3460109,3460136,3460203,3462124,3462245,3462273,3462339,3464369,3464400,3464464,3466517,3466554,3466611,3468698,3468728,3468794,3470864,3470899,3470959,3473024,3473055,3473115,3475180,3475209,3475272,3477330,3477361,3477424,3479476,3479511,3479572,3481613,3481644,3481704,3483746,3483777,3483837,3485867,3485899,3485960,3487980,3488014,3488071,3490086,3490119,3490180,3492219,3492250,3492306,3494339,3494369,3494428,3496454,3496487,3496546,3498608,3498641,3498699,3500751,3500784,3500840,3502888,3502918,3502978,3505019,3505049,3505109,3507145,3507173,3507235,3509262,3509295,3509353,3511377,3511408,3511467,3513483,3513515,3513575,3515584,3515617,3515673,3517669,3517702,3517760,3519757,3519786,3519846,3521834,3521863,3521923,3523904,3523935,3523995,3525967,3525994,3526055,3528019,3528051,3528106,3530108,3530167,3530345,3530350,3532151,3532212,3532390,3532398,3534191,3534253,3534270,3534430,3534438,3536235,3536290,3536310,3536469,3536474,3538266,3538322,3538340,3538499,3538504,3540286,3540344,3540364,3540521,3540529,3542357,3542416,3542431,3542594,3542600,3544414,3544471,3544490,3544649,3544657,3546511,3546531,3546692,3546697,3548550,3548566,3548730,3548736,3550582,3550598,3550764,3550766,3552623,3552639,3552804,3552808,3554655,3554673,3554839,3554844,3556694,3556714,3556878,3556879,3558721,3558740,3558901,3558905,3560734,3560749,3560915,3560917,3562736,3562753,3562914,3562923,3564739,3564755,3564919,3564922,3566754,3566774,3566935,3566941,3568767,3568784,3568950,3568954,3570786,3570803,3570968,3570973,3572796,3572815,3572974,3572979,3574808,3574825,3574991,3574995,3576717,3576734,3576895,3576899,3578637,3578797,3578802,3580534,3580700,3580705,3582430,3582558,3582563,3584288,3584421,3584427,3586145,3586279,3586284,3588129,3588136,3589983,3589989,3591831,3591835,3593677,3593682,3595658,3595664,3597653,3597657,3599628,3599632,3601586,3601591,3603537,3603541,3605471,3605476,3607397,3607402,3609317,3609323,3611227,3611231,3613125,3613129,3615045,3615048,3616961,3616963,3618870,3618873,3620769,3620774,3622665,3622672,3624560,3624562,3626436,3626444,3628306,3628309,3630166,3630170,3632025,3632029,3633877,3633883,3635720,3635727,3637556,3637563,3639380,3639388,3641191,3641196,3642993,3642998,3644789,3644792,3646577,3646580,3648357,3648358,3650124,3650133,3651884,3651888,3653631,3653636,3655371,3655379,3657103,3657111,3658827,3658828,3659309,3659378,3660547,3660551,3661034,3661108,3662270,3662275,3662760,3662833,3663987,3663992,3664473,3664546,3665693,3666177,3666250,3667874,3667947,3669561,3669635,3671241,3671314,3672914,3672988,3674580,3674654,3676233,3676306,3677876,3677950,3679516,3679589,3681150,3681224,3682781,3682856,3684405,3684479,3686025,3686098,3687633,3687707,3689233,3689307,3690829,3690903,3692421,3692494,3694003,3694078,3695579,3695654,3697148,3697223,3698704,3698777,3700247,3700322,3701786,3701861,3703318,3703393,3704844,3704919,3706362,3706437,3707872,3707947,3709368,3709443,3710855,3710930,3712340,3712414,3713816,3713890,3715286,3715360,3716752,3716826,3718212,3718286,3719666,3719740,3721114,3721188,3722555,3722629,3723992,3724066,3725421,3725495,3726844,3726919,3728261,3728335,3729671,3729746,3731071,3731145,3732465,3732541,3733850,3733924,3735226,3735300,3736594,3736668,3737958,3738032,3739310,3739384,3740655,3740731,3741993,3742067,3743323,3743399,3744644,3744719,3745960,3746036,3747269,3747344,3748568,3748644,3749858,3749933,3751141,3751217,3752416,3752491,3753683,3753758,3754943,3755017,3756197,3756272,3757451,3757525,3758698,3758773,3759937,3760012,3761170,3761245,3762395,3762469,3763616,3763691,3764833,3764908,3766042,3766117,3767245,3767320,3768439,3768513,3769628,3769703,3770019,3770093,3770409,3770483,3770795,3770870,3771176,3771250,3771556,3771630,3771935,3772010,3772309,3772383,3772681,3772755,3773050,3773125,3773417,3773491,3773785,3773860,3774152,3774226,3774517,3774591,3774880,3774954,3775241,3775315,3775600,3775674,3775957,3776031,3776310,3776384,3776658,3776732,3777010,3777084,3777359,3777433,3777704,3777778,3778044,3778118,3778379,3778453,3778709,3778783,3779034,3779108,3779364,3779438,3779690,3779764,3780011,3780085,3780327,3780401,3780642,3780716,3780953,3781027,3781258,3781332,3781558,3781632,3781855,3781929,3782147,3782221,3782435,3782509,3782718,3782792,3783003,3783077,3783285,3783359,3783564,3783638,3783840,3783914,3784112,3784186,3784383,3784457,3784649,3784723,3784911,3784985,3785169,3785243,3785424,3785498,3785689,3785795,3786023,3786129,3786354,3786460,3786704,3786810,3787050,3787156,3787392,3787498,3787731,3787837,3788066,3788172,3788399,3788505,3788728,3788834,3789054,3789160,3789377,3789483,3789695,3789801,3790011,3790117,3790324,3790430,3790635,3790741,3790942,3791048,3791246,3791352,3791547,3791653,3791844,3791950,3792139,3792245,3792431,3792537,3792720,3792826,3793007,3793113,3793290,3793396,3793569,3793675,3793844,3793950,3794117,3794223,3794386,3794492,3794652,3794758,3794916,3795022,3795178,3795284,3795437,3795543,3795691,3795797,3795956,3796064,3796221,3796329,3796483,3796591,3796742,3796850,3796997,3797105,3797247,3797355,3797491,3797599,3797733,3797841,3797971,3798079,3798206,3798314,3798438,3798546,3798669,3798777,3798895,3799003,3799115,3799223,3799334,3799442,3799550,3799658,3799764,3799872,3800083,3800292,3800497,3800700,3800902,3801102,3801299,3801493,3801684,3801870,3802048,3802225,3802400,3802572,3802741,3802908,3803071,3803227,3810788,3811180,3811564,3811942,3812324,3816969,3816977,3817320,3817327,3817661,3817675,3818049,3818061,3818453,3818464,3818850,3818862,3819253,3819641,3820027,3836738,3836744,3836998,3837003,3837256,3837261,3837510,3837517,3837766,3837770,3838018,3838024,3838274,3838279,3838527,3838531,3838778,3838783,3839031,3839037,3839280,3839288,3839528,3839533,3839774,3839778,3840014,3840021,3840252,3840258,3840493,3840501,3840784,3841063,3845826,3846072,3846315,3846554,3846792,3847026,3847255,3847483,3847715,3847943,3848167,3848396,3848621,3860836,3861632,3862424,3863215,3864002,3864784,3865564,3866343,3867117,3867889,3868659,3869425,3869468,3870192,3870235,3870955,3870999,3871717,3871758,3872463,3872493,3873203,3873245,3873958,3873999,3874711,3874755,3875462,3875503,3876209,3876252,3876956,3876999,3877700,3877740,3878442,3878485,3879185,3879226,3879926,3879967,3880667,3880711,3881410,3881453,3882153,3882198,3882895,3882938,3883636,3883679,3884377,3884422,3885114,3885157,3885852,3885894,3886587,3886629,3887320,3887363,3888054,3888099,3888784,3888827,3889514,3889556,3890239,3890284,3890963,3891007,3891682,3891726,3892401,3892443,3893115,3893161,3893829,3893852,3893875,3894549,3894571,3894594,3895266,3895291,3895314,3895979,3896002,3896027,3896687,3896710,3896733,3897395,3897418,3897442,3898100,3898124,3898148,3898802,3898824,3898847,3899525,3899547,3900223,3900249,3900942,3900968,3901656,3901683,3902372,3902396,3903081,3903110,3903789,3903818,3904495,3904519,3905222,3905916,3906613,3907303,3907993,3908678,3909362,3910041,3963658,3964230,3970001,3970573,3971140,3971706,3972269,3972826,3973383,3973936,3974487,3975051,3975701,3976311,3976915,3977513,3978110,3978703,3979294,3979883,3980467,3981049,3981624,3983396,3983970,3984539,3985100,3985659,3986221,3986776,3987323,3987870,3988417,3988954,3989488,3990019,3990028,3990559,3990568,3991102,3991633,3992171,4094607,4095368,4096127,4096882,4097639,4098391,4099141,4099891,4100638,4101382,4102127,4102867,4103607,4104344,4105078,4105811,4106541,4125912,4125939,4126630,4127311,4127992,4128671,4129347,4130017,4130685,4131352)) 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





	Vladimir Vaneyev (Bass) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Vladimir Vaneyev (Bass)

Vladimir Vaneyev (Bass)

• People`s Artist of Russia
• Recipient of the State Prize of Russia
• Prize-winner at All-Union, All-Russian and International Competitions, including the Perm Vocalists` Competition (1987, 2nd prize), the Voci Verdiani competition (Italy, 1990, 3rd prize and prize as best bass), the Singing Competition in Paris (1990, 2nd prize) and the Shaliapin Competition (Kazan, 1993, Grand Prix).

Vladimir Vaneyev graduated from the Gorky State Conservatoire in 1986 and was invited to join the Musorgsky State Theatre of Opera and Ballet (Leningrad), where he sang the roles of Dosifei (Khovanshchina), Galitsky, Khan Konchak (Prince Igor), Gremin (Eugene Onegin), King Rene (Iolanthe), Zlatogor (The Queen of Spades), Peter I (Peter I), Monterone, Sparafucile (Rigoletto), Filippo II and the Grande Inquisitore (Don Carlo).
Vladimir Vaneyev joined the Mariinsky Theatre in 1997.

Among the roles he has performed at the Mariinsky are:
Ruslan (Ruslan and Lyudmila)
Boris Godunov, Pimen (Boris Godunov)
Dosifei, Khovansky (Khovanshchina)
Prince Galitsky, Khan Konchak, Prince Igor (Prince Igor)
Kochubei, Mazepa (Mazepa)
Remenyuk (Semyon Kotko)
Padre Augustine (Betrothal in a Monastery)
Boris Timofeyevich (Lady Macbeth of the Mtsensk District)
Zaccaria (Nabucco)
Filippo II (Don Carlo)
Calatrava (La forza del destino)
the Dutchman (Der fliegende Hollander)
Wotan (Das Rheingold)
Wotan, Hunding (Die Walkure)
Klingsor (Parsifal)

Vladimir Vaneyev has toured in the USA, Japan, Germany, France, Great Britain, Spain, Italy, the Netherlands, Portugal, Belgium, Norway, Finland, Israel, Turkey, Poland, Austria and New Zealand. He has taken part in international productions of Boris Godunov (Venice, 1992; Nice, 1996; Austria, 1997; Metropolitan Opera, New York, 1998; Lisbon, 2001; Milan, 2002; London, 2003; Bologna, 2007); Don Carlo (Venice, 1993; Bonn, 2000); The Legend of the Invisible City of Kitezh and the Maiden Fevronia (Austria, 1994); Norma (Baltimore, 1998); Aida (Berlin, 1998); Don Carlo (Naples, 1999); Tosca (Rome, 1999); Der fliegende Hollander (Bologna, 1999); Sadko (Venice, 1999); Aida (Geneva, 1999); Iolanthe (Naples, 1999; Monte Carlo, 2001; Milan, 2002); Lady Macbeth of the Mtsensk District (Salzburg, 2001; Barcelona, 2002); The Queen of Spades (Milan, 2004); The Gambler (Milan, 2005; Paris, 2005); Khovanshchina (Barcelona, 2007).

Vladimir Vaneyev has taken part in recordings of Shostakovich`s 14th Symphony (with the West German Radio Orchestra, 1998), and of the operas Boris Godunov (Philips Classics, 1998), Betrothal in a Monastery (Philips Classics, 1998), Mascagni`s Parisina (with the French Radio Orchestra), A Love for Three Oranges (Philips Classics, 2002), and Simon Boccanegra (Washington, 2002). He has also made CD and DVD recordings of Rakhmaninov`s vocal-symphonic poem The Bells, as well as of the operas Lady Macbeth of the Mtsensk District (Amsterdam, 2006) and Khovanshchina (Barcelona, 2007).