QUERY: (SELECT tmp.*, tt.code, tt.name, tp.code as perf_code, tp.name as perf_name, date_format(tmp.date, '%e,%M,%W') as date_first,  date_format(tmp.time, '%k:%i') as time_column, IF(tp.description='',tp1.description,tp.description) as description, tp.description_full, tp.id_perfomancetype, IF(year(curdate())=year(tmp.date),'',year(tmp.date) ) as year, tt.ves as ves, date_format(tmp.time, '%l:%i %p') as time_column1, datediff(tmp.date, curdate()) as offset, tt.address FROM U_ticketsTmp tmp LEFT JOIN ticket_theatre tt ON tt.id=tmp.theatre_id LEFT JOIN ticket_perfomances tp ON tp.id=tmp.perf_id LEFT JOIN ticket_perfomances tp1 ON tp1.id=tp.id_base WHERE 1=1 AND tt.show2=1  AND tmp.date >=curdate()  AND tmp.id IN (8426,10130,11713,13296,14650,14761,16103,16213,17823,19213,20658,22139,23593,25056,26831,27770,29166,31004,32520,34042,35568,37112,37248,38659,38728,38801,40175,40247,41556,107700,109587,111464,113334,115195,117070,118945,120816,122682,124540,126389,128229,130057,131886,133719,135544,137365,139183,140993,142793,144583,146363,148134,149891,151640,153381,155112,156833,158544,160270,161997,163725,165467,167197,168918,170630,172334,174028,175712,177390,179053,180706,182353,183993,185624,198334,198351,198494,199651,199668,199811,200968,200985,201128,202650,202667,202810,204324,204339,204482,206026,206044,206189,207724,207742,207887,209412,209430,209575,211077,211094,211238,212611,212628,212769,214150,214167,214308,215686,215703,215844,217217,217234,217375,218746,218763,218904,220269,220286,220427,221788,221805,221946,223302,223319,223460,224811,224828,224969,226321,226339,226483,227827,227844,227985,229326,229343,229484,231311,231328,231469,233306,233323,233464,235296,235313,235454,237279,237298,237442,239253,239272,239416,241219,241238,241382,243180,243199,243343,245141,245160,245304,247093,247112,247256,249040,249059,249203,250984,251002,251147,252967,252986,253130,254943,254959,255104,256908,256924,257068,258876,258897,259042,260846,260864,261008,262806,262824,262968,264772,264790,264935,266732,266750,266895,268683,268701,268845,270624,270642,270786,272563,272581,272725,274496,274514,274658,276430,276448,276592,278356,278375,278519,280233,280252,280396,282101,282120,282264,283960,283979,284123,285817,285836,285980,287671,287690,287833,289514,289536,289677,291377,291405,291582,293273,293301,293478,295162,295190,295366,297042,297070,297246,298918,298947,299121,300789,300818,301004,302675,302707,302896,304558,304589,304778,306490,306521,306710,308414,308445,308634,310332,310363,310552,312246,312277,312465,314155,314186,314374,316060,316091,316279,317958,317989,318177,319848,319879,320067,321727,321758,321946,323596,323628,323816,325502,325533,325721,327411,327440,327631,329308,329339,329527,331201,331232,331420,333086,333118,333306,334961,334993,335181,336827,336859,337047,338705,338738,338928,340624,340668,340859,342317,342547,342592,342783,344243,344469,344517,344709,346159,346392,346440,346632,348066,348300,348347,348539,349956,350192,350237,350429,351833,352070,352115,352307,353711,353947,353993,354185,355584,355819,355866,356068,357461,357696,357743,357945,359368,359603,359650,359852,361267,361503,361551,361753,363158,363394,363441,363641,365040,365277,365325,365526,366918,367156,367204,367405,368797,369035,369082,369284,370668,370904,370952,371154,372532,372768,372816,373018,374386,374623,374671,374873,376232,376468,376516,376717,378068,378303,378351,378553,379900,380136,380184,380386,381728,381964,382012,382213,383547,383788,383833,384033,385363,385603,385648,385848,387170,387411,387456,387656,389222,389267,389467,391023,391068,391268,392823,392869,393068,394616,394663,394863,396408,396454,396654,398193,398240,398440,399969,400018,400220,401739,401787,401986,403499,403546,403748,405254,405303,405502,407006,407055,407254,408753,408802,409001,410493,410542,410740,412264,412309,412507,414020,414066,414264,415763,415809,416007,417503,417549,417750,419243,419289,419490,420976,421022,421223,422707,422752,422953,424431,424477,424682,426146,426191,426392,427844,427890,428095,429538,429584,429789,431225,431273,431503,432928,432975,433212,434625,434673,434910,436319,436367,436608,438002,438050,438291,439670,439718,439959,441326,441375,441615,442968,443017,443258,444601,444646,444888,446220,446266,446512,447833,447880,448125,449435,449482,449728,451028,451074,451319,452618,452664,452909,454205,454252,454497,455785,455833,456077,457358,457406,457651,458924,458973,459218,460480,460529,460774,462027,462077,462323,463579,463628,463875,465127,465176,465423,466669,466718,466965,468366,468416,468672,470117,470386,471668,471937,473209,473479,474790,475059,476367,476636,477938,478211,479508,479777,481071,481817,482556,483291,497553,499017,500472,501927,503421,504898,506369,507845,509311,510774,512230,513691,515164,516627,518081,519525,520967,522404,523814,523836,525233,525254,526641,526664,527942,528045,528069,529345,529449,529473,530746,530851,530873,532140,532245,532262,533528,533631,533649,534960,535063,535086,536489,536511,537918,537935,539341,539365,540757,540781,542191,542208,543632,543653,545102,545123,546556,546577,548016,548033,549467,549484,549538,550910,550932,550981,552346,552368,552416,553770,553792,553840,555184,555208,555254,556591,556615,556661,557995,558017,558063,559392,559414,559460,560785,560807,560853,562171,562193,562239,563553,563575,563621,564923,564945,564991,566306,566352,567663,567714,569020,569065,570367,570413,571707,571752,573131,574503,575863,577221,578573,579914,581246,582574,583894,736061,737041,738009,738968,739921,741890,743871,745840,747800,749786,751768,753750,756626,759495,762362,765225,768081,770928,773771,776608,779441,782277,785110,787938,790762,793582,796394,799201,802004,804802,807595,810382,813163,815939,818710,821474,824230,826979,829723,832462,835198,837930,840657,843380,846125,848860,851591,854329,857058,859780,862497,865204,867899,870583,873266,875949,878635,881319,884005,886680,889345,892007,894662,897316,899966,902607,905235,907851,910466,913078,915709,918413,921106,923785,926476,929193,931901,934609,937314,940045,1483420,1484769,1486108,1487437,1488752,1490054,1491344,1492626,1493936,1495237,1496530,1497823,1499121,1500407,1501686,1502959,1504220,1505481,1506730,1507972,1509200,1510429,1511658,1512880,1514101,1515328,1516551,1517761,1518963,1520163,1521356,1522543,1523722,1524894,1526059,1527217,1528369,1529516,1530659,1531798,1532932,1534061,1535188,1536309,1537425,1538565,1539698,1540825,1541947,1543064,1544171,1545273,1546365,1547445,1648648,1651457,1654321,1657175,1660018,1662847,1665664,1668471,1671278,1674132,1676980,1679823,1682656,1685475,1688332,1691190,1693961,1696726,1699484,1707846,1710613,1713371,1716151,1718921,1721676,1724418,1727157,1729889,1732601,1735305,1738000,1740682,1743348,1746010,1748663,1751308,1753946,1756575,1759193,1761799,1971119,1973131,2105059,2105136,2107009,2107085,2108948,2109024,2110877,2110953,2112794,2112873,2114700,2114779,2116603,2116677,2118495,2118569,2120376,2120450,2122246,2122321,2124106,2124181,2125950,2126025,2127790,2127863,2129619,2129693,2131440,2131514,2133251,2133325,2135052,2135126,2136842,2136916,2138757,2140596,2142425,2144243,2146050,2147851,2149639,2151413,2153176,2154929,2156673,2158405,2160164,2161910,2386993,2390057,2393117,2396169,2399205,2402227,2405239,2408251,2411252,2414243,2417224,2420232,2423226,2426216,2429198,2432170,2435133,2438084,2441022,2443949,2446872,2449787,2452695,2455581,2475931,2478867,2481791,2484702,2487607,2490550,2493479,2496399,2499310,2502205,2505084,2507948,2510814,2513675,2516529,2519378,2522217,2525044,2527857,2530666,2533472,2536268,2539055,2541851,2544628,2547392,2550159,2552959,2555750,2558557,2561353,2870574,2871952,2873324,2874688,2876045,2877391,2878742,2880114,2882890,2885655,2888396,2891117,2893831,2896523,2899217,2901914,2904559,2906674,2907064,2907158,2909260,2909661,2909770,2911869,2912270,2912379,2914460,2914861,2914970,2917045,2917449,2917561,2919626,2920029,2920141,2922193,2922597,2922709,2924752,2925159,2925271,2927299,2927706,2927818,2929827,2930234,2930346,2932337,2932744,2932856,2934843,2935250,2935362,2937338,2937760,2937875,2939839,2940265,2940382,2942336,2942762,2942880,2944823,2945250,2945368,2947293,2947720,2947838,2950169,2950287,2952617,2952743,2955068,2955211,2957451,2957554,2957697,2959926,2960029,2960172,2962388,2962491,2962634,2964826,2964929,2965072,2967246,2967349,2967492,2969660,2969764,2969907,2972079,2972183,2972326,2974471,2974575,2974718,2976852,2976956,2977099,2979217,2979321,2979464,2981597,2981701,2981844,2983968,2984072,2984215,2986333,2986437,2986580,2988713,2988817,2988960,2991085,2991189,2991333,2993453,2993557,2993701,2995808,2995912,2996056,2998146,2998250,2998394,3000466,3000570,3000714,3002784,3002888,3003032,3005080,3005185,3005329,3007312,3007417,3007562,3009500,3009608,3009755,3011681,3011788,3011934,3013838,3013945,3014091,3015981,3016090,3016236,3018120,3018229,3018375,3020312,3020421,3020569,3022134,3022203,3022295,3023606,3023676,3023773,3025072,3025142,3025234,3026522,3026592,3026684,3027958,3028029,3028126,3029397,3029467,3029564,3030824,3030893,3030991,3032237,3032307,3032405,3033643,3033712,3033811,3035234,3035304,3035403,3036816,3036887,3036981,3038385,3038455,3038549,3040014,3040109,3041564,3041659,3043108,3043208,3044649,3044746,3046180,3046276,3047696,3047789,3049203,3049297,3050710,3050806,3052213,3052309,3053702,3053798,3055183,3055280,3056659,3056754,3058117,3058214,3059661,3061100,3062845,3064576,3066292,3068004,3069700,3071387,3073066,3074740,3076399,3078053,3079708,3081360,3082998,3084627,3086276,3087922,3089551,3091177,3137796,3139417,3141029,3142579,3142633,3144173,3144227,3145763,3145817,3147343,3147397,3147979,3148033,3148609,3148663,3149233,3149287,3149857,3149911,3151404,3151458,3152943,3152997,3154476,3154530,3155999,3156053,3157515,3157569,3159022,3159076,3160516,3160570,3162001,3162055,3163478,3163533,3164950,3165005,3166428,3166489,3167835,3167851,3167865,3167895,3169229,3169245,3169259,3169289,3170614,3170630,3170644,3170674,3171991,3172007,3172021,3172051,3173362,3173378,3173392,3173422,3174726,3174742,3174756,3174786,3176128,3176144,3176158,3176188,3177526,3177542,3177556,3177586,3177671,3177677,3177683,3177705,3177713,3178915,3178931,3178945,3178975,3179064,3179070,3179077,3179101,3179116,3180387,3180403,3180417,3180447,3180536,3180542,3180549,3180573,3180588,3181855,3181871,3181885,3181915,3182004,3182010,3182017,3182041,3182056,3183321,3183337,3183351,3183381,3183466,3183472,3183478,3183500,3183511,3184784,3184802,3184816,3184846,3184931,3184937,3184943,3184965,3184976,3186245,3186263,3186277,3186307,3186392,3186398,3186404,3186426,3186437,3187702,3187720,3187734,3187764,3187849,3187855,3187861,3187883,3187894,3189153,3189171,3189185,3189215,3189300,3189306,3189312,3189334,3189345,3190598,3190616,3190629,3190661,3190744,3190751,3190757,3190779,3190790,3192039,3192058,3192069,3192102,3192186,3192192,3192199,3192220,3192231,3193476,3193492,3193505,3193537,3193642,3193652,3193665,3193699,3193719,3195167,3195183,3195194,3195229,3195334,3195343,3195356,3195390,3195410,3196952,3196969,3196979,3197014,3197119,3197128,3197142,3197175,3197195,3198926,3198943,3198957,3198989,3199094,3199105,3199115,3199150,3199171,3200895,3200912,3200921,3200957,3201040,3201046,3201053,3201075,3201086,3202592,3202610,3202622,3202656,3202738,3202745,3202752,3202773,3202784,3204286,3204303,3204312,3204349,3204432,3204437,3204445,3204466,3204477,3205975,3205992,3206005,3206038,3206122,3206127,3206134,3206156,3206167,3207662,3207680,3207693,3207726,3207809,3207814,3207822,3207843,3207854,3209342,3209360,3209371,3209406,3209488,3209494,3209502,3209523,3209534,3211015,3211032,3211047,3211078,3211162,3211167,3211174,3211196,3211207,3212735,3212751,3212765,3212796,3212881,3212886,3212893,3212915,3212926,3214438,3214457,3214466,3214502,3214585,3214590,3214598,3214619,3214630,3216134,3216151,3216162,3216196,3216281,3216286,3216294,3216315,3216326,3217828,3217845,3217857,3217890,3217975,3217980,3217988,3218009,3218020,3219516,3219534,3219546,3219577,3219662,3219668,3219675,3219697,3219708,3221195,3221212,3221221,3221257,3221342,3221347,3221354,3221376,3221387,3222862,3222880,3222894,3222924,3223015,3223020,3223027,3223049,3223061,3224527,3224545,3224559,3224589,3224679,3224685,3224692,3224714,3224728,3226156,3226173,3226185,3226217,3226308,3226315,3226321,3226343,3226357,3227771,3227791,3227800,3227835,3227924,3227930,3227938,3227959,3227973,3229388,3229406,3229417,3229452,3229542,3229547,3229555,3229576,3229590,3231011,3231030,3231039,3231075,3231165,3231170,3231178,3231199,3231213,3232511,3232628,3232645,3232658,3232691,3232780,3232786,3232793,3232815,3232829,3234125,3234237,3234256,3234269,3234299,3234389,3234395,3234402,3234424,3234438,3235723,3235836,3235855,3235867,3235898,3235988,3235994,3236001,3236023,3236037,3237303,3237420,3237439,3237450,3237482,3237572,3237578,3237585,3237607,3237621,3238878,3238989,3239007,3239018,3239051,3239143,3239149,3239156,3239177,3239191,3240440,3240556,3240575,3240588,3240618,3240710,3240716,3240722,3240744,3240758,3242043,3242160,3242177,3242187,3242221,3242312,3242318,3242325,3242347,3242361,3243638,3243750,3243768,3243782,3243812,3243904,3243909,3243917,3243938,3243952,3245221,3245332,3245351,3245365,3245394,3245486,3245491,3245499,3245520,3245534,3246824,3246934,3246953,3246962,3246998,3247088,3247093,3247100,3247122,3247136,3248411,3248520,3248538,3248548,3248584,3248673,3248679,3248686,3248708,3248722,3249977,3250090,3250110,3250123,3250152,3250244,3250249,3250257,3250278,3250292,3251543,3251655,3251674,3251683,3251717,3251808,3251814,3251821,3251843,3251857,3253106,3253216,3253233,3253247,3253288,3253411,3253417,3253425,3253446,3253460,3254702,3254815,3254832,3254847,3254887,3255061,3255069,3255084,3255131,3255162,3256712,3256826,3256844,3256855,3256899,3257070,3257080,3257095,3257142,3257173,3258723,3258836,3258856,3258865,3258911,3259082,3259093,3259107,3259154,3259184,3260723,3260834,3260853,3260864,3260907,3261079,3261088,3261104,3261151,3261180,3262816,3262833,3262843,3262888,3263060,3263070,3263084,3263132,3263163,3264796,3264816,3264828,3264869,3265041,3265053,3265067,3265113,3265144,3266773,3266793,3266802,3266849,3267027,3267040,3267060,3267108,3267136,3268738,3268758,3268776,3268790,3268832,3269012,3269027,3269046,3269110,3269151,3270789,3270807,3270827,3270835,3270882,3271100,3271116,3271134,3271201,3271241,3272915,3272934,3272954,3272966,3273010,3273226,3273243,3273261,3273326,3273367,3275026,3275045,3275063,3275075,3275118,3275336,3275354,3275371,3275436,3275476,3277117,3277138,3277157,3277168,3277213,3277429,3277444,3277465,3277529,3277569,3279208,3279227,3279247,3279255,3279303,3279520,3279536,3279554,3279622,3279661,3281341,3281362,3281379,3281393,3281437,3281655,3281669,3281688,3281755,3281794,3283468,3283489,3283508,3283518,3283564,3283781,3283798,3283816,3283883,3283923,3285587,3285611,3285630,3285640,3285686,3285905,3285919,3285938,3286003,3286043,3287736,3287760,3287777,3287792,3287833,3288053,3288067,3288087,3288153,3288193,3289869,3289893,3289912,3289924,3289969,3290186,3290203,3290220,3290288,3290325,3291986,3292009,3292028,3292038,3292084,3292303,3292318,3292338,3292404,3292442,3294090,3294115,3294132,3294146,3294190,3294406,3294423,3294443,3294508,3294546,3296190,3296215,3296232,3296247,3296288,3296507,3296522,3296542,3296607,3296646,3298283,3298308,3298326,3298336,3298382,3298600,3298615,3298636,3298701,3298739,3300368,3300391,3300411,3300421,3300467,3300686,3300703,3300719,3300785,3300824,3302443,3302467,3302487,3302496,3302543,3302760,3302777,3302796,3302862,3302901,3304508,3304531,3304550,3304558,3304605,3304823,3304840,3304859,3304924,3304964,3306556,3306579,3306599,3306611,3306655,3306873,3306892,3306909,3306974,3307012,3308602,3308625,3308645,3308657,3308701,3308919,3308937,3308954,3309019,3309058,3310644,3310667,3310686,3310697,3310742,3310959,3310977,3310995,3311060,3311099,3312700,3312719,3312733,3312775,3312990,3313009,3313025,3313091,3313127,3314719,3314739,3314751,3314794,3315009,3315026,3315043,3315108,3315148,3316731,3316750,3316759,3316805,3317021,3317038,3317056,3317120,3317157,3318732,3318750,3318760,3318805,3319022,3319040,3319056,3319120,3319158,3320719,3320739,3320751,3320794,3321008,3321024,3321045,3321110,3321148,3322704,3322723,3322735,3322779,3322993,3323009,3323030,3323095,3323133,3324851,3324869,3324881,3324927,3325141,3325157,3325175,3325241,3325280,3327121,3327140,3327148,3327195,3327412,3327431,3327446,3327511,3327550,3329528,3329541,3329582,3329800,3329816,3329834,3329900,3329939,3331909,3331919,3331964,3332183,3332198,3332215,3332281,3332318,3334274,3334285,3334331,3334549,3334563,3334581,3334646,3334684,3336627,3336635,3336683,3336899,3336916,3336935,3337000,3337037,3338976,3338985,3339032,3339250,3339266,3339282,3339347,3339386,3341319,3341327,3341375,3341593,3341609,3341625,3341690,3341730,3343666,3343711,3343927,3343945,3343962,3344027,3344067,3346026,3346067,3346285,3346304,3346320,3346384,3346423,3348374,3348420,3348636,3348652,3348673,3348736,3348775,3350758,3350976,3350990,3351008,3351074,3351113,3353080,3353298,3353314,3353331,3353398,3353434,3355399,3355616,3355632,3355650,3355717,3355754,3357728,3357946,3357966,3357987,3358064,3358105,3360074,3360290,3360312,3360332,3360412,3360456,3362437,3362654,3362670,3362695,3362772,3362819,3364789,3365006,3365026,3365049,3365125,3365172,3367129,3367349,3367365,3367387,3367465,3367512,3369460,3369677,3369699,3369717,3369797,3369842,3371784,3372003,3372023,3372044,3372122,3372167,3374102,3374322,3374340,3374360,3374441,3374484,3376416,3376632,3376648,3376674,3376752,3376796,3378720,3378939,3378957,3378979,3379058,3379102,3381235,3381252,3381275,3381355,3381400,3383504,3383526,3383544,3383624,3383670,3385789,3385808,3385829,3385907,3385954,3388058,3388079,3388098,3388175,3388222,3390316,3390334,3390358,3390435,3390482,3392569,3392584,3392609,3392686,3392734,3394806,3394827,3394846,3394926,3394970,3397028,3397049,3397069,3397145,3397192,3399241,3399259,3399284,3399363,3399406,3401443,3401461,3401486,3401563,3401610,3403636,3403654,3403675,3403755,3403801,3405816,3405832,3405855,3405934,3405981,3407983,3408002,3408023,3408101,3408157,3410148,3410165,3410190,3410266,3410321,3412292,3412309,3412333,3412412,3412464,3414462,3414479,3414500,3414580,3414634,3414692,3416608,3416629,3416650,3416727,3416783,3416846,3418749,3418770,3418790,3418868,3418923,3418987,3420869,3420889,3420911,3420992,3421042,3421102,3422971,3422992,3423012,3423091,3423146,3423208,3425053,3425072,3425095,3425172,3425227,3425288,3427111,3427134,3427154,3427231,3427285,3427344,3429155,3429173,3429196,3429275,3429329,3429393,3431179,3431197,3431222,3431302,3431354,3431412,3433189,3433210,3433231,3433311,3433363,3433423,3435196,3435210,3435235,3435313,3435368,3435431,3437189,3437210,3437232,3437308,3437364,3437425,3439171,3439189,3439210,3439290,3439344,3439401,3441138,3441152,3441176,3441256,3441308,3441368,3443101,3443119,3443143,3443216,3443273,3443333,3445077,3445093,3445116,3445194,3445246,3445307,3447231,3447247,3447271,3447345,3447401,3447461,3449377,3449398,3449417,3449495,3449547,3449605,3451517,3451534,3451554,3451632,3451686,3451745,3453649,3453669,3453686,3453762,3453818,3453883,3455767,3455783,3455805,3455882,3455938,3455999,3457890,3457907,3457932,3458008,3458063,3458125,3460014,3460055,3460132,3460187,3460248,3462152,3462191,3462270,3462322,3462386,3464275,3464319,3464396,3464449,3464510,3466426,3466469,3466546,3466596,3466658,3468605,3468649,3468725,3468779,3468841,3470775,3470816,3470893,3470943,3471007,3472931,3472972,3473049,3473099,3473167,3475085,3475128,3475204,3475255,3475321,3477237,3477280,3477358,3477410,3477471,3479426,3479505,3479557,3479618,3481564,3481642,3481690,3481752,3483697,3483775,3483822,3483882,3485817,3485893,3485945,3486010,3487930,3488007,3488055,3488117,3490037,3490113,3490164,3490223,3492167,3492243,3492291,3492356,3494287,3494366,3494415,3494478,3496404,3496481,3496530,3496596,3498558,3498635,3498682,3498748,3500780,3500824,3500893,3502915,3502959,3503028,3505046,3505090,3505159,3507167,3507219,3507279,3509289,3509336,3509405,3511405,3511453,3511519,3513512,3513559,3513625,3515607,3515655,3515717,3517697,3517745,3517805,3519782,3519830,3519898,3521862,3521910,3521975,3523931,3523980,3524046,3525989,3526038,3526101,3528045,3528093,3528158,3530104,3530150,3530216,3532146,3532197,3532259,3534186,3534237,3534299,3536227,3536274,3536342,3538256,3538306,3538372,3540281,3540329,3540389,3542348,3542399,3542462,3544454,3544521,3546495,3546558,3548533,3548597,3550564,3550630,3550664,3552606,3552673,3552704,3554640,3554706,3554737,3556680,3556746,3556779,3558703,3558769,3558804,3560718,3560781,3560814,3562719,3562784,3562813,3564721,3564789,3564816,3566738,3566807,3566837,3568751,3568819,3568850,3570837,3570869,3571060,3572841,3572877,3573070,3574854,3574891,3575082,3576764,3576793,3576991,3578667,3578700,3578895,3580563,3580597,3580794,3582454,3582478,3582653,3584310,3584337,3584516,3586167,3586197,3586373,3588025,3588049,3588226,3589874,3589901,3590078,3591722,3591748,3591927,3593571,3593595,3593772,3595520,3595558,3595754,3596093,3596104,3597517,3597551,3597746,3598087,3598095,3599492,3599527,3599723,3600063,3600072,3601484,3601682,3602021,3602030,3603432,3603631,3603971,3603980,3605367,3605566,3605907,3605917,3607294,3607493,3607832,3607843,3609212,3609412,3609753,3609762,3611127,3611322,3611661,3611669,3613022,3613218,3613559,3613570,3615139,3615482,3615491,3617053,3617397,3617406,3618963,3619303,3619314,3620864,3621205,3621216,3622762,3623103,3623115,3624652,3624996,3625007,3626533,3626872,3626885,3628401,3628742,3628753,3630261,3630602,3630614,3630729,3632121,3632461,3632473,3632588,3633971,3634312,3634325,3634440,3635814,3636155,3636168,3636282,3637650,3637991,3638004,3638118,3639474,3639815,3639828,3639943,3641286,3641626,3641638,3641753,3643089,3643430,3643442,3643557,3644884,3645225,3645237,3645350,3646671,3647013,3647024,3647138,3648451,3648792,3648803,3648917,3650220,3650560,3650573,3650688,3651980,3652320,3652331,3652445,3653726,3654067,3654079,3654193,3655465,3655806,3655820,3655932,3657197,3657539,3657552,3657664,3658919,3659260,3659273,3659392,3660638,3660979,3660992,3661126,3662367,3662707,3662719,3662850,3664081,3664421,3664432,3664565,3665784,3666124,3666135,3666268,3667481,3667822,3667833,3667964,3669166,3669507,3669521,3669654,3670846,3671188,3671199,3671332,3672520,3672862,3672873,3673006,3674185,3674526,3674538,3674672,3675838,3676181,3676192,3676326,3677481,3677823,3677835,3677967,3679121,3679464,3679475,3679607,3680754,3681097,3681109,3681243,3682387,3682727,3682739,3682875,3684010,3684354,3684365,3684500,3685631,3685971,3685983,3686119,3687240,3687578,3687592,3687727,3688841,3689182,3689192,3689328,3690435,3690777,3690788,3690924,3692025,3692368,3692380,3692514,3693610,3693950,3693962,3694098,3695183,3695524,3695537,3695672,3696756,3697097,3697108,3697242,3698311,3698649,3698662,3698798,3699851,3700195,3700206,3700341,3701391,3701731,3701744,3701879,3702923,3703265,3703277,3703413,3704449,3704789,3704802,3704937,3706308,3706322,3706456,3707820,3707832,3707967,3709313,3709326,3709460,3710803,3710815,3710949,3712288,3712299,3712434,3713765,3713776,3713911,3715235,3715246,3715381,3716697,3716710,3716844,3718161,3718172,3718307,3719615,3719626,3719761,3721059,3721072,3721206,3722502,3722514,3722650,3723940,3723951,3724086,3725368,3725380,3725514,3726792,3726802,3726938,3728206,3728219,3728355,3729616,3729629,3729765,3731019,3731030,3731165,3732412,3732424,3732558,3733798,3733809,3733945,3735171,3735185,3735319,3736543,3736554,3736688,3737905,3737917,3738053,3739257,3739269,3739405,3740603,3740615,3740749,3741939,3741953,3742087,3743271,3743283,3743416,3744593,3744603,3744739,3745908,3745920,3746055,3747217,3747228,3747362,3748514,3748527,3748663,3749806,3749817,3749951,3751089,3751101,3751234,3752364,3752375,3752510,3753629,3753641,3753777,3754890,3754902,3755037,3756143,3756155,3756291,3757398,3757410,3757546,3758644,3758657,3758792,3759882,3759896,3760030,3761117,3761129,3761263,3762342,3762354,3762489,3763561,3763575,3763710,3764778,3764792,3764926,3765988,3766002,3766136,3767190,3767203,3767339,3768387,3768399,3768534,3769574,3769587,3769722,3769968,3769978,3770114,3770357,3770367,3770503,3770741,3770754,3770889,3771123,3771135,3771271,3771504,3771515,3771650,3771881,3771894,3772027,3772256,3772268,3772404,3772629,3772640,3772776,3772996,3773009,3773145,3773365,3773376,3773510,3773734,3773745,3773879,3774101,3774112,3774247,3774466,3774477,3774612,3774829,3774840,3774975,3775190,3775201,3775336,3775549,3775560,3775695,3775906,3775917,3776052,3776259,3776270,3776405,3776607,3776618,3776753,3776959,3776970,3777105,3777308,3777319,3777454,3777653,3777664,3777799,3777993,3778004,3778139,3778328,3778339,3778474,3778658,3778669,3778804,3778983,3778994,3779129,3779313,3779324,3779459,3779639,3779650,3779785,3779960,3779971,3780106,3780276,3780287,3780422,3780591,3780602,3780737,3780902,3780913,3781048,3781207,3781218,3781353,3781507,3781518,3781653,3781804,3781815,3781950,3782096,3782107,3782242,3782384,3782395,3782530,3782667,3782678,3782813,3782952,3782963,3783098,3783234,3783245,3783380,3783513,3783524,3783659,3783789,3783800,3783935,3784061,3784072,3784207,3784332,3784343,3784478,3784598,3784609,3784744,3784860,3784871,3785006,3785118,3785129,3785264,3785373,3785384,3785519,3785625,3785636,3785826,3785959,3785970,3786160,3786290,3786301,3786491,3786640,3786651,3786841,3786986,3786997,3787187,3787328,3787339,3787529,3787667,3787678,3787868,3788002,3788013,3788203,3788335,3788346,3788536,3788664,3788675,3788865,3788990,3789001,3789191,3789313,3789324,3789514,3789631,3789642,3789832,3789947,3789958,3790148,3790260,3790271,3790461,3790571,3790582,3790772,3790878,3790889,3791079,3791182,3791193,3791383,3791483,3791494,3791684,3791780,3791791,3791981,3792075,3792086,3792276,3792367,3792378,3792568,3792656,3792667,3792857,3792943,3792954,3793144,3793226,3793237,3793427,3793505,3793516,3793706,3793791,3793981,3794064,3794254,3794333,3794523,3794599,3794789,3795053,3795315,3795574,3795828,3796095,3796360,3796622,3796881,3797136,3797386,3797630,3797872,3798110,3798345,3798577,3798808,3799034,3799254,3799473,3799689,3799903,3800114,3800323,3800528,3800731,3800933,3801133,3801330,3801524,3801715,3801901,3802079,3802256,3802431,3802603,3802772,3802939,3803102,3803258,3803423,3803586,3803747,3803905,3804060,3804210,3804354,3804497,3804636,3804771,3804902,3805030,3805154,3805272,3805388,3805501,3805611,3805716,3805817,3805913,3806004,3806094,3806183,3806270,3806355,3806437,3806515,3836756,3837015,3837272,3837529,3837783,3838035,3838036,3838292,3838293,3838545,3838546,3838796,3838798,3839049,3839050,3839299,3839301,3839547,3839548,3839791,3839793,3840033,3840034,3840272,3840521,3840804,3841083,3841358,3841630,3841897,3842159,3842419,3869463,3870231,3870994,3871754,3872491,3873243,3873998,3874750,3875500,3876248,3876994,3877737,3878481,3879223,3879963,3880706,3881450,3882194,3882936,3883677,3884417,3885155,3885891,3886628,3887362,3888095,3888825,3889555,3890281,3891004,3891724,3892440,3893156,3893870,3894592,3895308,3896022,3896729,3897439,3898144,3898845,3899544,3900246,3900966,3901679,3902393,3903103,3903813,3904514,3905216,3905912,3906607,3907297,3907986,3908677,3909360,3918260,3918933,3919620,3920310,3920987,3921669,3922337,3922340,3923017,3923022,3941356,3941997,3942634,3943262,3943891,3944516,3945133,3945754,3946380,3946402,3947002,3947026,3947618,3947640,3948245,3948885,3949523,3950157,3950791,3951419,3953303,3953923,3954534,3979903,3980485,3981064,3981644,3982217,3982786,3983357,3983931,3984500,3985063,4094615,4095376,4096135,4096891,4097647,4098399,4099149,4099900,4100645,4101391,4102135,4102875,4103613,4104351,4105087,4105818,4106548,4107275,4107998,4108720)) 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





	Hovhannes Ayvazyan (Tenor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Hovhannes Ayvazyan (Tenor)
			

																
Hovhannes Ayvazyan (Tenor)

														
				


        




    

        
Participant at the International Plбcido Domingo OPERALIA Competition (2012) 
Recipient of the Armenian Presidential Prize (2009) 
Prize-winner at the International Gasparyan Opera Competition (1st prize, Yerevan, 2008) 
Prize-winner at the Tatevik Sazandarian Republican Competition of Singers and Performers (2nd prize, Yerevan, 2007) 
Born in Yerevan (Armenia). In 2011 he graduated from the Yerevan State Komitas Conservatoire. 
Since 2010 Hovhannes Ayvazyan has frequently performed with the Opera Belcanto of York in South Simcoe, Toronto, Canada (Turiddu (Cavalleria rusticana) and Cavaradossi (Tosca)). 
In 2013 the singer performed the role of Manrico in the opera Il trovatore at the Novaya Opera in Moscow and appeared in a Verdi gala with Anna Netrebko at the new Mariinsky Theatre. 
Other engagements for 2013 include appearances at the Mariinsky Theatre as Cavaradossi in the opera Tosca (19 July) and Manrico in the opera Il trovatore (9 August, concert performance). 
Guest soloist with the Novaya Opera in Moscow. Lead soloist with the Yerevan State Alexander Spendiaryan Opera and Ballet Theatre. 
Repertoire at the Mariinsky Theatre includes: 
Manrico (Il trovatore). 
Repertoire also includes: 
Don Josй (Carmen), Radames (Aida), the Duke of Mantua (Rigoletto), Alfredo (La traviata), Manrico (Il trovatore), Canio (I pagliacci), Turiddu (Cavalleria rusticana), Pinkerton (Madama Butterfly), Luigi (Il tabarro), Cavaradossi (Tosca) and Lensky (Eugene Onegin). 
        

    

    

            


			

		





	


	

	

		


			

				

					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