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 (14685,14763,14791,16134,16215,16243,17744,17825,17853,19219,19241,20683,22166,23620,25086,26892,27915,29230,31034,32527,32549,34046,34073,35535,37144,37231,37240,38695,38780,38792,40144,40227,40240,41548,41597,41612,41646,41656,42991,43004,43039,43050,44353,44365,44400,44409,45704,45717,45752,45761,47049,47062,47097,47106,48388,48401,48436,48447,49735,49770,49779,51063,51098,51107,52382,52417,52426,53697,53732,53741,55041,55050,56343,56353,56465,56502,57705,57716,57827,57863,59775,59786,59897,59933,61839,61850,61961,61997,63894,63905,64016,64052,65941,65952,66063,66099,67997,68109,68144,70039,70150,70186,72076,72188,72223,74218,74253,76236,76271,78246,78281,80252,80287,82251,82286,84244,84279,86229,86264,88207,88242,90175,90210,92133,92168,94085,94121,96035,96070,97974,98009,99903,99938,101824,101859,103733,103768,105633,105668,105734,107527,107562,107628,107635,107766,108099,109413,109449,109515,109526,109654,109986,111290,111326,111392,111402,111531,111863,113159,113195,113260,113268,113401,113733,115020,115055,115121,115129,115262,115594,116896,116931,116997,117009,117138,117470,118771,118806,118872,118884,119013,119345,120676,120742,120754,120884,121216,122542,122607,122620,122750,123082,124400,124465,124478,124608,124940,126249,126313,126327,126456,126789,128089,128153,128167,128296,128629,129918,129982,129996,130125,130458,131747,131811,131825,131954,132287,133580,133644,133658,133787,134120,135405,135469,135483,135612,135945,137226,137290,137304,137433,137766,139108,139122,139251,139584,140918,140932,141061,141394,142719,142733,142862,143195,144509,144523,144655,144984,146289,146303,146435,146764,148060,148074,148206,148535,149821,149831,149964,150293,151571,151581,151714,152045,153311,153321,153455,153786,155041,155052,155186,155517,156762,156773,156907,157237,158473,158484,158618,158948,160210,160344,160674,161936,162071,162401,163813,164151,165555,165892,167286,167623,169007,169344,170719,171058,172423,172763,174117,174457,175801,176141,177474,177814,179136,179477,180790,181129,182437,182776,184077,184417,185708,186048,187330,187670,188942,189282,190542,190882,192130,192471,193708,194052,195269,195651,196033,196469,196805,196864,196870,197781,198121,198180,198186,198380,198486,198504,199098,199438,199497,199503,199697,199803,199821,200415,200755,200814,200820,201014,201120,201138,202097,202437,202496,202502,202696,202802,202820,203769,204109,204168,204174,204368,204474,204492,205442,205783,205865,205875,206073,206181,206197,207140,207480,207563,207573,207771,207879,207895,208828,209168,209251,209261,209459,209567,209583,210831,210914,210923,211124,211231,211247,212204,212248,212340,212344,212426,212439,212657,212765,212783,213740,213783,213875,213879,213964,213976,214196,214304,214322,215276,215319,215411,215415,215500,215512,215732,215840,215858,216807,216850,216942,216946,217031,217043,217263,217371,217389,218335,218379,218471,218475,218560,218572,218792,218900,218918,219858,219902,219994,219998,220083,220095,220315,220423,220441,221377,221421,221513,221517,221602,221614,221834,221942,221960,222891,222935,223027,223031,223116,223128,223348,223456,223474,224400,224444,224536,224540,224625,224637,224857,224965,224983,225906,225949,226047,226051,226136,226148,226368,226476,226494,227411,227454,227552,227556,227641,227653,227873,227981,227999,228910,228953,229051,229055,229140,229152,229372,229480,229498,230895,230938,231036,231040,231125,231137,231357,231465,231483,232890,232933,233031,233035,233120,233132,233352,233460,233477,234880,234923,235021,235025,235110,235122,235342,235450,235467,236869,236908,237006,237010,237099,237107,237327,237435,237452,238840,238882,238980,238984,239069,239081,239301,239409,239427,240810,240848,240946,240950,241035,241047,241267,241375,241393,242771,242809,242907,242911,243000,243008,243228,243336,243354,244728,244766,244864,244868,244960,244968,245189,245296,245315,246682,246720,246818,246825,246913,246920,247141,247248,247267,248629,248667,248765,248772,248860,248867,249088,249195,249214,250572,250611,250712,250716,250804,250811,251032,251138,251158,252556,252594,252692,252699,252787,252794,253015,253122,253141,254529,254568,254669,254673,254761,254768,254989,255095,255115,256494,256535,256634,256638,256725,256732,256954,257060,257080,258454,258493,258591,258598,258686,258693,258927,259035,259053,260421,260459,260561,260565,260652,260659,260893,261001,261020,262419,262521,262525,262612,262619,262853,262961,262980,264386,264487,264491,264579,264586,264820,264927,264946,266346,266447,266451,266539,266546,266780,266887,266906,268297,268399,268403,268489,268497,268731,268837,268857,270238,270340,270344,270430,270437,270672,270778,270798,272177,272279,272283,272369,272376,272611,272717,272737,274110,274115,274212,274215,274302,274309,274544,274650,274670,276044,276049,276146,276149,276236,276243,276478,276584,276604,277971,277973,278071,278075,278163,278170,278404,278511,278531,279850,279948,279952,280040,280047,280281,280388,280408,281816,281819,281908,281915,282149,282256,282276,283675,283677,283767,283774,284008,284115,284135,285532,285534,285624,285631,285865,285972,285992,287387,287389,287479,287486,287719,287826,287846,289229,289234,289322,289332,289564,289672,289689,291067,291072,291160,291167,291445,291574,291594,292962,292968,293056,293063,293341,293470,293490,294851,294856,294945,294954,295229,295359,295379,296731,296736,296825,296832,297109,297239,297259,298606,298610,298699,298709,298984,299116,299133,300477,300481,300569,300579,300856,300998,301022,302367,302371,302461,302468,302746,302887,302913,304249,304253,304343,304350,304629,304769,304794,306175,306179,306273,306282,306561,306701,306726,308099,308103,308197,308206,308485,308625,308650,310017,310021,310115,310126,310403,310543,310568,311931,311938,312029,312040,312317,312457,312482,313840,313846,313938,313949,314226,314366,314391,315745,315751,315843,315854,316131,316271,316296,317649,317741,317752,318029,318169,318195,319631,319642,319919,320059,320085,321510,321521,321797,321938,321964,323381,323391,323667,323808,323834,325275,325286,325573,325713,325739,327176,327185,327479,327621,327644,329074,329085,329379,329519,329545,330965,330976,331272,331412,331438,332851,332862,333158,333298,333324,334727,334737,335032,335173,335199,336593,336603,336898,337039,337065,338457,338469,338778,338920,338946,340338,340349,340706,340850,340876,342262,342273,342306,342630,342774,342799,344189,344197,344230,344554,344699,344723,346105,346113,346146,346477,346622,346646,348012,348020,348053,348384,348529,348553,349902,349910,349943,350276,350419,350443,351778,351788,351820,352155,352296,352323,353658,353666,353699,354032,354175,354200,355528,355538,355571,355911,356057,356083,357405,357416,357448,357788,357934,357960,359312,359322,359355,359695,359841,359867,361212,361216,361221,361231,361254,361596,361742,361768,363108,363113,363121,363146,363484,363631,363656,364996,365004,365028,365370,365516,365542,366876,366884,366909,367249,367396,367421,368762,368785,369127,369273,369296,370632,370654,370997,371144,371170,372519,372861,373008,373034,374373,374716,374863,374889,376221,376561,376707,376734,378056,378396,378542,378568,379889,380229,380375,380401,381717,382057,382203,382229,383876,384025,384049,385693,385840,385865,387499,387648,387673,389312,389459,389484,391114,391260,391285,392914,393060,393085,394706,394853,394878,396499,396646,396671,398284,398431,398456,400060,400209,400232,401830,401977,402003,403588,403736,403760,405346,405493,405520,407098,407245,407272,408845,408992,409018,410584,410732,410758,412351,412499,412525,414108,414256,414283,415851,415999,416026,417591,417742,417769,419331,419482,419509,421064,421215,421242,422794,422945,422972,424519,424670,424697,426233,426384,426411,427932,428083,428110,429626,429777,429804,431330,431491,431518,433033,433204,433231,434730,434902,434929,436424,436596,436623,438107,438279,438306,439775,439947,439974,441432,441603,441631,443078,443245,443272,444707,444877,444902,446329,446501,446526,447942,448115,448141,449546,449715,449743,451137,451309,451335,452727,452899,452925,454315,454487,454513,455895,456067,456093,457469,457641,457667,459036,459208,459234,460592,460764,460790,462140,462312,462338,463692,463864,463890,465240,465411,465437,466782,466954,466979,468483,468661,468686,470187,470375,470401,471738,471926,471952,473279,473468,473493,474860,475048,475073,476435,476625,476650,478009,478200,478225,479581,479767,479794,481144,481891,482629,483363,484106,484857,485602,486340,487064,487779,488489,489204,489913,490615,491312,491999,492677,493359,494041,494713,495378,497543,497568,499006,499032,500464,500492,501916,501946,503410,503437,504890,504917,506362,506389,507834,507861,509303,509330,510766,510793,512222,512249,513680,513714,515149,515187,516616,516650,518070,518104,519514,519548,520956,520990,522393,522427,523823,523858,525242,525279,526650,526687,528054,528092,529458,529496,530858,530892,532252,532286,533634,533672,535072,535110,536496,536530,537925,537960,539350,539384,540766,540800,542198,542233,543639,543677,545109,545147,546567,546601,548023,548058,549474,549510,549513,550917,550953,550956,552353,552388,552392,553777,553811,553816,555193,555228,555235,556600,556635,556642,558003,558037,558044,559400,559434,559441,560793,560826,560834,562179,562213,562217,563560,563594,563599,564930,564964,564972,566292,566327,566333,567649,567689,567692,569040,569046,570387,570394,571727,571731,573105,573110,574477,574482,575839,575843,577197,577201,578553,592430,594059,595758,597448,638367,638482,638515,640020,640054,641550,641584,643071,643106,644584,644619,646089,646125,647590,647620,649080,649111,650572,650607,652057,652087,653533,653562,654999,655033,656454,656484,657901,657935,659350,659387,660787,660824,662214,662251,663634,663669,665048,665084,666451,666490,667886,667925,669311,669345,670745,670784,672174,672213,673630,675035,676431,677817,679223,680616,694004,695252,696482,697702,698909,700105,701292,702492,703673,704853,706010,707154,708286,709408,710553,711694,712831,713959,715069,732009,732028,732993,733013,733980,733999,734962,734981,735937,735954,736023,736917,736931,737001,737885,737899,737969,738844,738859,738929,739796,739812,739882,741766,741783,741853,743742,743759,743828,745711,745728,745797,747673,747693,747761,749657,749677,749743,751639,751659,751725,753621,753641,753707,756497,756517,756583,759366,759387,759455,762233,762254,762322,765096,765117,765185,767952,767973,768041,770801,770822,770890,773644,773664,773733,776481,776501,776570,779314,779334,779403,782150,782170,782239,784983,785003,785071,787811,787831,787899,790639,790655,790723,793459,793475,793543,796266,796281,796354,799073,799088,799161,801876,801891,801964,804673,804689,804762,807466,807481,807555,810253,810268,810342,813034,813049,813123,815810,815825,815899,818581,818596,818670,821344,821360,821434,824100,824116,824190,826849,826865,826939,829592,829609,829683,832334,832349,832422,835067,835084,835159,837796,837813,837891,840523,840540,840617,843246,843262,843340,845991,846007,846085,848727,848743,848821,851458,851474,851552,854190,854207,854285,856918,856936,857014,859640,859658,859736,862357,862375,862452,865069,865082,865158,867776,867852,870460,870536,873143,873219,875826,875902,878589,881273,883959,886638,889303,891965,894620,897274,899925,902562,902644,902660,905194,905278,905292,907809,907894,907909,910423,910508,910523,913036,913116,913134,915668,915749,915765,918453,918469,921144,921162,923828,923841,926520,926532,929233,929249,931940,931958,934649,934665,937353,937370,940083,940101,942807,942819,945512,945524,948214,948226,950920,950932,953618,953632,956307,956322,958984,958999,961639,961653,964293,966929,969561,972189,1024182,1026717,1029247,1031615,1031772,1034117,1034273,1036609,1036768,1039098,1039257,1041582,1041741,1044058,1044217,1044278,1044324,1046684,1046745,1046791,1049141,1049202,1049248,1051585,1051646,1051692,1054015,1054075,1054121,1056442,1056502,1056548,1058864,1058924,1058970,1061273,1061333,1061379,1063674,1063732,1063780,1066068,1066126,1066174,1068450,1068508,1068556,1070818,1070878,1070926,1073218,1073277,1073326,1075611,1075670,1075719,1077994,1078053,1078102,1080365,1080424,1080473,1082725,1082784,1082836,1085070,1085130,1085181,1087397,1087459,1087510,1089718,1089777,1089828,1092048,1092107,1092158,1094370,1094429,1094481,1096679,1096739,1096791,1098974,1099036,1099088,1101251,1101314,1101365,1103522,1103584,1103636,1105772,1105839,1105885,1108000,1108066,1108113,1110212,1110273,1110320,1112399,1112460,1112507,1114567,1114628,1114676,1116777,1116825,1118916,1118964,1121043,1121092,1121096,1123188,1123235,1123237,1125320,1125367,1125371,1127511,1127559,1127561,1129732,1129779,1129782,1131934,1131983,1131990,1134124,1134174,1134181,1136327,1136378,1136385,1138529,1138580,1138587,1140727,1140780,1140785,1142918,1142970,1142976,1145101,1145153,1145158,1147323,1147327,1149479,1149483,1151632,1151636,1153778,1153782,1155919,1155924,1158091,1158097,1160253,1160258,1162399,1162405,1164533,1164538,1166662,1166668,1168801,1971145,1973156,1975152,1977139,1979109,1981108,1983100,2112793,2114699,2116597,2118489,2120370,2122240,2124099,2125943,2127781,2129609,2131430,2133241,2135042,2196841,2197496,2197532,2198369,2199021,2199057,2199886,2200555,2200591,2201404,2202110,2202146,2202945,2203651,2203687,2204476,2205181,2205217,2205999,2206709,2206745,2208236,2208272,2209751,2209787,2211255,2211291,2212773,2212829,2214473,2214529,2216162,2216218,2217844,2217900,2219652,2219744,2221888,2221981,2224114,2224206,2226328,2226421,2228528,2228621,2230718,2230810,2232897,2232989,2235315,2235406,2237935,2238027,2240847,2240938,2244023,2244115,2247190,2247282,2250348,2250439,2253494,2253587,2256636,2256727,2259765,2259858,2262887,2262978,2265998,2266091,2269100,2269193,2272192,2272285,2275304,2275398,2278449,2278542,2281587,2281678,2284736,2284828,2287879,2287970,2291012,2291103,2294135,2294228,2296803,2297256,2297347,2299930,2300379,2300471,2303056,2303509,2303600,2306204,2306655,2306749,2309372,2309824,2309917,2312537,2312989,2313081,2315698,2316150,2316243,2318857,2319306,2319398,2322008,2322457,2322549,2325149,2325598,2325691,2328283,2328732,2328825,2331409,2331848,2331941,2334517,2334955,2335048,2337620,2338055,2338146,2340716,2341152,2341244,2343825,2344263,2344355,2346928,2347366,2347459,2350025,2350468,2350560,2353150,2353595,2353686,2356263,2356707,2356799,2359366,2359810,2359902,2362468,2362909,2363002,2365555,2365999,2366093,2368635,2369077,2369169,2371710,2372147,2372239,2374768,2375205,2375298,2377811,2378249,2378342,2380846,2381284,2381376,2383875,2384313,2384405,2386891,2387332,2387426,2389954,2390396,2390490,2393017,2393457,2393549,2396067,2396508,2396600,2399544,2399638,2402566,2402658,2405579,2405673,2408590,2408684,2411591,2411683,2414582,2414676,2417605,2417697,2420613,2420705,2423606,2423700,2426596,2426688,2429580,2429672,2432551,2432643,2435514,2435606,2438466,2438558,2441405,2441499,2444333,2444427,2447257,2447351,2450172,2450264,2453078,2453169,2455966,2456060,2458854,2458945,2461725,2461819,2464581,2464675,2467447,2467545,2470334,2470453,2473259,2473368,2476207,2476317,2479144,2479257,2482068,2482181,2484979,2485092,2487885,2487997,2490825,2490935,2493753,2493864,2496673,2496784,2499584,2499692,2502479,2502587,2505357,2505468,2508224,2508336,2511088,2511195,2513948,2514058,2516802,2516912,2519651,2519758,2522490,2522598,2525314,2525425,2528131,2528238,2530939,2531051,2533525,2533744,2533855,2536319,2536542,2536652,2539113,2539339,2539450,2541902,2542133,2542241,2544681,2544912,2545022,2547450,2547676,2547787,2550214,2550480,2550594,2553014,2553279,2553394,2555804,2556098,2556208,2558611,2558906,2559016,2561411,2561701,2561816,2564194,2564484,2564599,2566963,2567254,2567369,2569764,2570063,2570205,2572594,2572894,2573031,2575414,2575713,2575850,2578222,2578523,2578659,2581031,2581332,2581468,2583822,2584122,2584258,2586595,2586894,2587035,2589365,2589666,2589802,2592129,2592427,2592568,2594883,2595182,2595323,2597926,2598068,2600668,2600804,2603391,2603527,2606097,2606238,2608804,2608944,2611500,2611641,2614228,2614369,2616952,2617089,2619665,2619802,2622367,2622507,2625051,2625190,2627735,2627874,2630408,2630544,2633069,2633212,2635722,2635865,2638364,2638508,2640995,2641137,2643610,2643755,2646220,2646365,2648815,2648961,2651401,2651545,2653977,2654122,2656542,2656685,2659087,2659231,2661612,2661760,2664122,2664267,2666618,2666766,2669092,2669240,2671545,2671694,2673993,2674139,2676414,2676561,2678820,2678966,2681203,2681349,2683578,2683724,2685941,2686086,2688302,2688448,2690651,2690798,2692990,2693136,2695309,2695456,2697989,2698192,2701063,2701266,2704145,2704348,2707217,2707420,2710253,2710463,2713290,2713500,2716314,2716524,2719379,2719593,2722453,2722690,2725552,2725791,2728641,2728880,2731726,2731967,2734837,2735077,2737928,2738168,2741010,2741250,2744082,2744322,2747133,2747373,2750163,2750403,2753190,2753430,2756213,2756458,2759471,2762486,2765495,2768485,2771459,2774429,2777388,2780372,2783397,2786478,2789557,2792616,2795672,2798741,2801800,2804850,2807817,2810761,2813685,2816601,2819582,2822552,2825534,2828503,2831454,2834384,2837307,2840234,2843151,2844590,2846018,2847437,2848845,2851699,2853119,2854532,2855942,2869961,2871337,2872708,2874073,2875430,2876776,2878119,2879491,2882267,2885032,2887773,2890501,2893215,2895907,2898592,2901291,2903975,3029441,3030868,3031006,3031068,3032279,3032421,3032482,3033690,3033889,3035277,3035481,3036860,3037059,3038429,3038628,3039989,3040188,3041539,3041742,3043082,3043285,3044623,3044824,3046154,3046355,3047667,3047870,3049173,3049377,3050683,3050888,3052388,3053878,3055359,3056830,3058293,3059740,3061181,3062919,3064652,3066374,3068081,3069781,3071469,3073146,3074814,3076474,3078132,3079793,3081440,3083079,3084705,3086361,3088001,3088244,3089636,3089879,3091260,3091502,3092868,3093112,3094467,3094712,3096062,3096308,3097646,3097891,3098165,3099220,3099467,3099745,3100792,3101040,3101319,3102351,3102598,3102875,3103900,3104145,3104423,3105436,3105682,3105961,3106989,3107235,3107513,3108532,3108775,3109091,3110100,3110345,3110660,3111658,3111903,3112221,3113206,3113453,3113769,3114741,3114985,3115302,3116506,3116820,3118018,3118336,3119529,3119847,3121032,3121348,3122564,3122877,3124259,3124574,3125947,3126260,3127620,3127935,3129283,3129597,3130939,3131253,3132586,3132685,3132900,3134226,3134325,3134540,3135866,3135965,3136180,3137499,3137598,3137813,3137872,3139120,3139219,3139434,3139493,3140732,3140831,3141046,3141105,3142336,3142435,3142650,3142709,3143930,3144029,3144244,3144303,3145520,3145619,3145834,3145893,3147100,3147199,3147414,3147473,3147736,3147835,3148050,3148109,3148366,3148465,3148680,3148739,3148990,3149089,3149304,3149363,3149614,3149713,3149928,3149987,3151161,3151260,3151475,3151534,3152700,3152799,3153014,3153073,3154233,3154332,3154547,3154606,3155756,3155855,3156070,3156129,3157272,3157371,3157586,3157645,3158779,3158878,3159093,3159152,3160273,3160372,3160587,3160646,3161758,3161857,3162072,3162131,3163235,3163334,3163550,3163609,3164707,3164806,3165022,3165081,3166170,3166269,3166506,3166565,3167620,3167699,3167911,3167965,3169014,3169093,3169305,3169359,3170399,3170478,3170690,3170744,3171776,3171855,3172067,3172121,3173147,3173226,3173438,3173492,3174512,3174591,3174802,3174856,3175912,3175993,3176204,3176258,3177310,3177391,3177602,3177614,3177656,3177691,3178700,3178780,3178991,3179003,3179049,3179085,3180172,3180252,3180463,3180475,3180521,3180557,3181640,3181720,3181931,3181943,3181989,3182025,3183106,3183186,3183397,3183409,3183451,3183486,3184569,3184649,3184862,3184874,3184916,3184951,3186030,3186110,3186323,3186335,3186377,3186412,3187487,3187567,3187780,3187792,3187834,3187869,3188938,3189018,3189231,3189243,3189285,3189320,3190382,3190465,3190678,3190690,3190730,3190765,3191823,3191906,3192120,3192131,3192171,3192207,3193259,3193341,3193554,3193564,3193617,3193676,3194951,3195031,3195244,3195255,3195308,3195367,3196735,3196816,3197030,3197040,3197093,3197153,3198711,3198792,3199006,3199017,3199068,3199128,3200678,3200761,3200973,3200983,3201026,3201061,3202376,3202459,3202672,3202684,3202724,3202760,3204069,3204152,3204364,3204374,3204417,3204452,3205761,3205840,3206056,3206066,3206107,3206143,3207447,3207530,3207741,3207751,3207794,3207830,3209127,3209210,3209421,3209431,3209474,3209510,3210801,3210873,3210880,3210919,3211096,3211106,3211147,3211183,3212520,3212592,3212599,3212637,3212814,3212824,3212866,3212902,3214223,3214295,3214306,3214340,3214518,3214528,3214570,3214605,3215916,3215991,3215999,3216033,3216214,3216225,3216266,3216301,3217609,3217687,3217692,3217729,3217906,3217916,3217960,3217995,3219371,3219379,3219415,3219596,3219607,3219648,3219684,3221054,3221058,3221097,3221272,3221283,3221327,3221362,3222721,3222726,3222763,3222942,3222952,3222999,3223035,3224380,3224393,3224428,3224605,3224617,3224664,3224700,3226012,3226019,3226056,3226237,3226245,3226293,3226329,3227627,3227636,3227671,3227852,3227864,3227909,3227946,3229247,3229253,3229289,3229469,3229479,3229526,3229563,3230871,3230876,3230913,3231093,3231101,3231149,3231186,3232486,3232492,3232529,3232707,3232717,3232765,3232802,3234096,3234101,3234138,3234315,3234327,3234374,3234410,3235692,3235702,3235735,3235914,3235926,3235973,3236009,3237276,3237286,3237320,3237498,3237510,3237557,3237594,3238844,3238854,3238890,3239071,3239082,3239127,3239164,3240412,3240422,3240458,3240638,3240646,3240694,3240731,3242015,3242025,3242060,3242238,3242251,3242297,3242333,3243610,3243619,3243656,3243831,3243841,3243888,3243924,3245194,3245201,3245235,3245411,3245422,3245470,3245506,3246794,3246801,3246837,3247015,3247024,3247072,3247108,3248380,3248389,3248424,3248600,3248610,3248658,3248694,3249957,3249996,3250172,3250180,3250228,3250264,3251523,3251558,3251736,3251748,3251793,3251829,3253118,3253310,3253321,3253396,3253432,3254718,3254909,3254920,3255026,3255106,3256730,3256917,3256936,3257038,3257118,3258740,3258930,3258947,3259047,3259129,3260736,3260928,3260945,3261045,3261124,3262721,3262907,3262923,3263027,3263106,3264701,3264891,3264903,3265008,3265089,3266678,3266868,3266886,3266985,3267083,3268661,3268853,3268870,3268970,3269073,3270713,3270902,3270916,3271044,3271162,3273029,3273045,3273171,3273291,3275140,3275157,3275282,3275401,3277230,3277250,3277374,3277494,3279323,3279337,3279465,3279583,3281454,3281474,3281597,3281719,3283585,3283597,3283718,3283725,3283845,3285703,3285720,3285843,3285845,3285967,3287852,3287871,3287986,3287996,3288116,3289989,3290003,3290126,3290130,3290248,3292104,3292116,3292238,3292244,3292365,3294210,3294226,3294344,3294350,3294470,3296307,3296324,3296444,3296450,3296572,3298403,3298416,3298535,3298544,3298662,3300485,3300502,3300625,3300627,3300748,3302561,3302578,3302696,3302706,3302824,3304626,3304638,3304758,3304768,3304887,3306673,3306690,3306813,3306815,3306936,3308719,3308735,3308859,3308861,3308981,3310759,3310776,3310900,3310905,3311023,3312794,3312812,3312925,3313051,3314812,3314832,3314946,3315073,3316826,3316839,3316959,3317082,3318825,3318840,3318960,3319083,3320812,3320829,3320948,3321073,3322798,3322815,3322933,3323057,3324945,3324964,3325076,3325202,3327215,3327231,3327350,3327473,3327694,3329604,3329618,3329737,3329863,3330080,3331984,3332001,3332121,3332243,3332461,3334349,3334363,3334487,3334609,3334828,3336703,3336716,3336838,3336963,3337181,3339052,3339067,3339188,3339309,3339529,3341395,3341409,3341531,3341652,3341873,3343731,3343748,3343862,3343992,3344210,3346087,3346100,3346223,3346347,3346567,3348438,3348458,3348571,3348701,3348917,3350777,3350792,3350913,3351035,3351254,3353100,3353117,3353232,3353361,3353578,3355419,3355436,3355555,3355677,3355896,3357749,3357765,3357885,3357975,3358022,3358246,3360095,3360108,3360227,3360320,3360366,3360615,3362454,3362470,3362593,3362683,3362731,3362978,3364810,3364822,3364944,3365035,3365085,3365332,3367149,3367164,3367283,3367377,3367422,3367671,3369480,3369494,3369616,3369706,3369755,3370002,3371806,3371822,3371936,3372032,3372077,3372327,3374123,3374141,3374255,3374351,3374397,3374645,3376434,3376449,3376571,3376661,3376708,3376958,3378740,3378748,3378758,3378872,3378969,3379016,3379262,3381037,3381045,3381056,3381170,3381238,3381265,3381310,3381561,3383305,3383314,3383323,3383438,3383508,3383533,3383580,3383830,3385598,3385602,3385607,3385726,3385794,3385817,3385867,3386115,3387870,3387875,3387994,3388061,3388088,3388135,3388382,3390137,3390255,3390322,3390345,3390392,3390638,3392388,3392508,3392573,3392596,3392645,3392890,3394743,3394809,3394836,3394881,3395126,3396967,3397033,3397056,3397102,3397348,3399178,3399248,3399273,3399320,3399565,3401378,3401448,3401473,3401522,3401767,3403573,3403639,3403665,3403712,3403956,3405752,3405821,3405844,3405893,3406138,3407917,3407989,3408012,3408059,3408323,3410088,3410154,3410178,3410224,3410489,3412231,3412296,3412321,3412370,3412632,3414394,3414465,3414491,3414537,3414803,3416548,3416612,3416636,3416685,3416951,3418689,3418753,3418777,3418825,3419092,3420809,3420873,3420898,3420948,3421211,3422912,3422977,3423000,3423051,3423314,3424987,3425057,3425082,3425131,3425394,3427048,3427117,3427140,3427190,3427453,3429090,3429159,3429184,3429232,3429497,3431120,3431184,3431209,3431256,3431521,3433126,3433193,3433221,3433266,3433532,3435128,3435197,3435224,3435270,3435535,3437125,3437195,3437218,3437269,3437532,3439106,3439173,3439201,3439249,3439512,3441141,3441165,3441214,3441477,3443105,3443129,3443175,3443441,3445080,3445103,3445151,3445414,3447234,3447257,3447306,3447569,3449382,3449403,3449449,3449713,3451521,3451544,3451590,3451855,3453652,3453675,3453721,3453987,3455769,3455794,3455841,3456106,3457897,3457920,3457965,3458232,3460017,3460046,3460090,3460364,3462156,3462182,3462228,3462500,3464279,3464307,3464351,3464634,3466430,3466456,3466502,3466783,3468612,3468635,3468681,3468963,3470777,3470804,3470848,3471130,3472933,3472960,3473006,3473288,3475088,3475117,3475162,3475444,3477241,3477268,3477314,3477598,3479389,3479413,3479462,3479743,3481553,3481599,3481878,3483683,3483731,3484010,3485808,3485851,3486131,3487918,3487965,3488240,3490025,3490070,3490375,3492153,3492171,3492202,3492507,3494290,3494324,3494627,3496406,3496437,3496745,3498559,3498592,3498899,3500704,3500737,3501042,3502870,3503180,3505003,3505311,3507127,3507435,3509245,3509551,3511359,3511668,3513469,3513773,3515565,3515872,3517652,3517961,3519738,3520049,3522126,3524195,3526256,3528330,3530389,3532435,3534292,3534475,3536333,3536514,3538272,3538287,3538344,3538365,3538544,3540296,3540311,3540369,3540384,3540569,3542367,3542380,3542441,3542455,3542639,3544424,3544439,3544494,3544511,3544695,3546464,3546479,3546536,3546554,3546736,3548502,3548515,3548572,3548590,3548773,3550532,3550547,3550608,3550625,3550649,3550806,3552586,3552649,3552663,3552691,3552847,3554623,3554679,3554696,3554725,3554883,3556660,3556720,3556738,3556761,3556920,3558688,3558746,3558764,3558787,3558946,3560759,3560776,3560801,3560958,3562759,3562779,3562804,3562962,3564762,3564780,3564803,3564962,3566782,3566797,3566822,3566981,3568794,3568808,3568834,3568994,3570811,3570830,3570854,3571012,3572822,3572837,3572863,3573023,3574833,3574852,3574876,3575033,3576741,3576759,3576784,3576940,3578641,3578661,3578687,3578843,3580541,3580560,3580584,3580742,3582433,3582447,3582468,3582605,3584296,3584309,3584329,3584464,3586152,3586165,3586184,3586321,3588007,3588018,3588039,3588176,3589856,3589870,3589892,3590029,3591720,3591738,3591875,3593566,3593586,3593722,3595516,3595543,3595706,3597508,3597536,3597697,3599513,3599674,3601472,3601632,3603421,3603582,3605355,3605519,3607282,3607443,3609364,3611270,3613170,3615092,3617004,3618913,3620812,3622711,3624604,3626483,3628351,3630211,3632070,3633925,3635766,3637602,3639427,3641235,3643042,3644833,3646620,3648399,3650171,3651928,3653678,3655416,3657148,3658869,3660589,3662316,3664029,3665734,3667432,3669120,3670799,3672469,3674136,3675792,3677434,3679071,3680705,3807823,3808199,3836702,3840296,3840553,3840836,3841115,3841390,3841662,3841929,3842191,3842451,3842718,3842983,3843246,3843504,3843758,3844009,3844266,3844522,3844775,3845025,3845279,3845531,3845817,3846063,3846306,3846545,3846783,3847017,3847246,3847474,3847706,3847934,3848158,3849337,3849571,3849803,3850033,3850261,3850487,3850711,3850933,3851150,3851364,3851575,3851783,3851989,3852193,3852397,3852989,3853580,3854169,3854754,3860821,3860860,3861618,3861656,3862408,3862447,3863200,3863240,3863987,3864027,3864769,3864810,3865549,3865588,3866326,3866367,3867105,3867142,3867874,3867912,3868645,3868683,3869412,3869452,3869485,3870179,3870221,3870252,3870942,3870984,3871015,3871701,3871746,3871778,3873187,3873233,3873265,3873943,3873988,3874020,3874698,3874740,3874771,3875445,3875491,3875522,3876197,3876237,3876269,3876943,3876983,3877015,3877685,3877729,3877761,3878430,3878470,3878502,3879168,3879214,3879245,3879912,3879952,3879987,3880653,3880694,3880731,3881396,3881441,3881475,3882141,3882182,3882216,3882879,3882926,3882959,3883620,3883667,3883700,3884364,3884405,3884439,3885100,3885142,3885179,3885835,3885882,3885915,3886574,3886616,3886650,3887306,3887348,3887385,3888040,3888083,3888116,3888769,3888813,3888849,3889501,3889543,3889577,3890226,3890270,3890303,3890948,3890991,3891027,3891670,3891711,3891746,3892384,3892430,3892463,3893102,3893145,3893178,3893815,3893860,3893897,3894532,3894579,3894617,3895251,3895296,3895334,3896008,3896048,3896716,3896756,3897423,3897464,3898128,3898168,3898830,3898871,3899532,3899572,3900231,3900272,3900948,3900992,3901666,3901706,3902378,3902418,3903091,3903129,3903798,3903839,3904501,3904542,3905202,3905243,3905899,3905940,3906632,3907325,3908015,3908703,3909386,3910063,3910754,3911441,3912125,3912808,3913489,3914167,3914840,3926430,3927091,3927753,3928411,3929065,3929719,3930368,3931014,3931660,3932301,3932941,3933585,3934226,3934865,3935500,3936134,3936789,3946390,3947013,3947627,3948232,3948879,3949517,3953312,3953927,3954546,3955152,3955764,3963666,3964239,3964810,3965378,3965961,3969991,3970563,3971131,3971699,3972261,3972820,3973374,3973929,4035091,4035453,4036355,4037253,4038168,4051530,4052407,4053282,4054157,4055025,4055888,4056754,4057613,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,4125942,4126628,4127313,4127994,4128672,4129345,4130018,4130688,4131348,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,4137997,4138671,4139333,4139998,4140655)) 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





	Gennady Bezzubenkov (Bass) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Gennady Bezzubenkov (Bass)
			

																
Gennady Bezzubenkov (Bass)

														
				


        




    

        Bass  

•People's Artist of Russia. 
•Recipient of the State Prize of Russia. 
•Recipient of the Russian opera prize CASTA DIVA – singer of the year (2004). 
•Recipient of the Baltika prize (2002).
•Awarded the Golden Mask, Russia?s highest theatre prize, for best male role in Wagner?s opera Parsifal (1998). 
•Awarded the Golden Sofit for his portrayal of Gurnemanz (Parsifal, 1997). 

Born in Staraya Vitelevka, Ulyanovsk Region. Graduated from the Leningrad State Rimsky-Korsakov Conservatoire in 1979 (class of B. Lushin and N. Velter). 
Mariinsky Theatre soloist since 1989. 

His repertoire includes over fifty roles, among them:
Ivan Susanin (A Life for the Tsar),
Varlaam, Pimen (Boris Godunov),
Ivan Khovansky (Khovanshchina),
Konchak (Prince Igor),
Prince Gudal (The Demon),
Prince Gremin (Eugene Onegin),
the Sea King (Sadko),
Prince Yuri Vsevolodovich (The Legend of the Invisible City of Kitezh and the Maiden Fevronia),
Vasily Sobakin (The Tsar?s Bride), 
the bass role in Les Noces,
Kutuzov (War and Peace),
the Doctor (The Nose),
Banco (Macbeth),
Padre Guardiano, Alcalde (La forza del destino),
Ramfis (Aida),
Timur (Turandot),
Commendatore (Don Giovanni),
Don Alfonso (Cosi fan tutte),
King Marke (Tristan und Isolde), 
Donner (Das Rheingold),
Hunding (Die Walkure),
Gurnemanz (Parsifal),
Verdi?s Requiem, Mozart?s Requiem and Sofia Gubaidulina?s St John?s Passion. 

Has toured with the Mariinsky Opera Company to Germany, France, Scotland (the Edinburgh Festival), Israel, the USA (Metropolitan Opera), Finland, Italy, Spain, Austria, the Netherlands, Belgium, Japan, Portugal, Luxembourg and Turkey. 
Audio and video recordings with the Mariinsky Theatre include War and Peace, Ruslan and Lyudmila, Iolanta, Sadko, The Fiery Angel and The Tsar?s Bride.
 
© State Academic Mariinkiy Opera and Ballet theatre
        

    

    

            


			

		





	


	

	

		


			

				

					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