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 (1355062,1356937,1358800,1360657,1362505,1364345,1366170,1367981,1369787,1371587,1373372,1375148,1377000,1378840,1380660,1382473,1384287,1386095,1387895,1389684,1391457,1393220,1394997,1396767,1398527,1400276,1400299,1402025,1402050,1403768,1403787,1405492,1405512,1407212,1407236,1408944,1408963,1410675,1410694,1412399,1412417,1414162,1414179,1415914,1415934,1417655,1417674,1419386,1419405,1421106,1421125,1422815,1422834,1424511,1424529,1426194,1426217,1427862,1427885,1429518,1429542,1431163,1431181,1432796,1432820,1434423,1434441,1436034,1436052,1437663,1437681,1439277,1439295,1440879,1440898,1442475,1442494,1444066,1444084,1445645,1445663,1447214,1447232,1448772,1448792,1450317,1450337,1451848,1451870,1453390,1454905,1456410,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,1707862,1707889,1710629,1710656,1713387,1713417,1716167,1716197,1718937,1718966,1721696,1721719,1724438,1724461,1727177,1727199,1729908,1729931,1732619,1732643,1735323,1735347,1738018,1738042,1740700,1740727,1743366,1743390,1746028,1746052,1748682,1748705,1751325,1751348,1753964,1753991,1756593,1756620,1759210,1759238,1761814,1761843,1764415,1764444,1767011,1767039,1769601,1769628,1772182,1772208,1774755,1774783,1777350,1779901,1782448,1784986,1787514,1790014,2095392,2097264,2099123,2101080,2103026,2104983,2106934,2108873,2110802,2169282,2177038,2178646,2180241,2181818,2183387,2184941,2186487,2188028,2189566,2191090,2192605,2194112,2195645,2197173,2197529,2198699,2199054,2200233,2200588,2201760,2202143,2203299,2203684,2204830,2205214,2206269,2206353,2206742,2207799,2207880,2208269,2209314,2209395,2209784,2210818,2210899,2211288,2212310,2212391,2212825,2214010,2214091,2214525,2215698,2215779,2216214,2217381,2217462,2217896,2219160,2219242,2219738,2221394,2221473,2221974,2223622,2223704,2224200,2225835,2225914,2226414,2228037,2228118,2228614,2230226,2230306,2230804,2232406,2232486,2232983,2234822,2234903,2235400,2237441,2237523,2238022,2240353,2240435,2240933,2243529,2243610,2244110,2246697,2246779,2247277,2249855,2249937,2250434,2253002,2253084,2253580,2256141,2256221,2256722,2259271,2259352,2259852,2262392,2262472,2262973,2265504,2265584,2266084,2268606,2268686,2269186,2271698,2271778,2272279,2274810,2274892,2275391,2277954,2278035,2278536,2281091,2281171,2281673,2284241,2284319,2284823,2287382,2287463,2287965,2290515,2290596,2291098,2293639,2293721,2294222,2296762,2296841,2297342,2299883,2299963,2300466,2300477,2303015,2303094,2303595,2303607,2306159,2306242,2306742,2306753,2309328,2309411,2309911,2309925,2312493,2312575,2313076,2313089,2315654,2315736,2316237,2316251,2318810,2318889,2319393,2319404,2321961,2322040,2322544,2322555,2325105,2325187,2325685,2325699,2328239,2328321,2328819,2328833,2331368,2331446,2331934,2331949,2334475,2334553,2335041,2335056,2337573,2337652,2338140,2338152,2340669,2340752,2341238,2341250,2343782,2343861,2344349,2344362,2346886,2346964,2347452,2347466,2349983,2350061,2350554,2350568,2353107,2353187,2353680,2353693,2356221,2356301,2356793,2356805,2359324,2359404,2359896,2359908,2362420,2362504,2362995,2363007,2365512,2365592,2366085,2366100,2368672,2369162,2369175,2371741,2372232,2372245,2374802,2375291,2375304,2377846,2378335,2378348,2380877,2381369,2381382,2383905,2384398,2384411,2386925,2387418,2387433,2389990,2390482,2390494,2393051,2393542,2393555,2396102,2396594,2396606,2399138,2399630,2399642,2402156,2402651,2402664,2405170,2405666,2405680,2408181,2408676,2408688,2411181,2411676,2411689,2414172,2414669,2414683,2417154,2417691,2417703,2420699,2420711,2423693,2423704,2426683,2426694,2429666,2429678,2432638,2432649,2435601,2435612,2438553,2438564,2441491,2441503,2444419,2444431,2447343,2447355,2450258,2450270,2453163,2453175,2456052,2456064,2458939,2458951,2461811,2461825,2464667,2464680,2467537,2467549,2470444,2470464,2473361,2473379,2476309,2476327,2479248,2479264,2482172,2482189,2485082,2485099,2487988,2488003,2490926,2490941,2493854,2493872,2496774,2496792,2499685,2499703,2502580,2502598,2505459,2505475,2508328,2508343,2511188,2511207,2514048,2514067,2516902,2516921,2519751,2519770,2522591,2522605,2525418,2525433,2528231,2528250,2531042,2531058,2533848,2533862,2536643,2536659,2539443,2539458,2542234,2542253,2545013,2545029,2547780,2547795,2550586,2550601,2553386,2553401,2556201,2556220,2558791,2559009,2559028,2561584,2561808,2561823,2564375,2564591,2564606,2567145,2567361,2567375,2569944,2570195,2570213,2572775,2573024,2573042,2575596,2575842,2575861,2578405,2578652,2578670,2581213,2581461,2581479,2584004,2584251,2584269,2586772,2587026,2587042,2589545,2589795,2589814,2592307,2592559,2592576,2595063,2595313,2595332,2597805,2598060,2598075,2600548,2600797,2600816,2603270,2603520,2603539,2605975,2606229,2606245,2608684,2608934,2608951,2611386,2611634,2611649,2614109,2614360,2614376,2616834,2617082,2617096,2619549,2619795,2619815,2622250,2622497,2622514,2624932,2625182,2625198,2627611,2627866,2627882,2630287,2630537,2630555,2632948,2633204,2633220,2635599,2635606,2635856,2635874,2638237,2638251,2638501,2638517,2640874,2640880,2641130,2641144,2643487,2643496,2643746,2643764,2646099,2646106,2646355,2646374,2648690,2648703,2648952,2648970,2651274,2651288,2651539,2651556,2653855,2653863,2654113,2654132,2656419,2656427,2656678,2656692,2658964,2658973,2659225,2659239,2661494,2661501,2661753,2661768,2663999,2664007,2664260,2664274,2666495,2666505,2666757,2666776,2668971,2668983,2669233,2669250,2671430,2671436,2671687,2671702,2673871,2673881,2674131,2674150,2676297,2676304,2676554,2676569,2678704,2678710,2678959,2678975,2681093,2681342,2681357,2683465,2683714,2683729,2686079,2686096,2688438,2688454,2690789,2690808,2693126,2693142,2695446,2695466,2698184,2698203,2701258,2701277,2704340,2704359,2707412,2707431,2710293,2710345,2710455,2710474,2713329,2713381,2713492,2713515,2716353,2716405,2716516,2716539,2719418,2719470,2719583,2719609,2722492,2722544,2722677,2722710,2725591,2725643,2725778,2725812,2728680,2728732,2728867,2728901,2731765,2731818,2731954,2731988,2734876,2734928,2735064,2735098,2737967,2738019,2738155,2738189,2741049,2741101,2741237,2741271,2744121,2744173,2744309,2744343,2747172,2747224,2747360,2747394,2750202,2750254,2750390,2750424,2753229,2753281,2753417,2753451,2756253,2756306,2756445,2756479,2759266,2759319,2759458,2759492,2762281,2762334,2762473,2762507,2765290,2765343,2765482,2765516,2768280,2768333,2768472,2768506,2771254,2771307,2771446,2771480,2774277,2774416,2774450,2777236,2777375,2777409,2780220,2780359,2780393,2783245,2783384,2783418,2786326,2786395,2786465,2786499,2789405,2789474,2789544,2789578,2792464,2792533,2792603,2792637,2795520,2795589,2795659,2795693,2798589,2798658,2798728,2798762,2801717,2801787,2801821,2804767,2804837,2804871,2807734,2807804,2807838,2810678,2810748,2810782,2813602,2813672,2813706,2816518,2816588,2816622,2819497,2819569,2819603,2822467,2822539,2822573,2825449,2825521,2825555,2828418,2828490,2828524,2831441,2831475,2834371,2834405,2837294,2837328,2840221,2840255,2843138,2843172,2844577,2844611,2846005,2846039,2847424,2847458,2848832,2848866,2851686,2851720,2853106,2853140,2854553,2855963,2857366,2858762,2907087,2907207,2909686,2909826,2912295,2912435,2914886,2915026,2917474,2917617,2920054,2920197,2922622,2922765,2925184,2925327,2927731,2927874,2930259,2930402,2932769,2932912,2935275,2935417,2937786,2937930,2940291,2940437,2942788,2942935,2945276,2945423,2947746,2947893,2950195,2950342,2952645,2952797,2955097,2955276,2957583,2957762,2960058,2960237,2962520,2962699,2964958,2965137,2967378,2967557,2969793,2969973,2972212,2972387,2974604,2974780,2976985,2977161,2979350,2979526,2981730,2981906,2984101,2984277,2986466,2986642,2988846,2989022,2991218,2991394,2993586,2993762,2995941,2996117,2998279,2998455,3000599,3000775,3002843,3002888,3002917,3003093,3005139,3005185,3005214,3005390,3007371,3007417,3007446,3007623,3009563,3009608,3009637,3009816,3011744,3011788,3011817,3011995,3013901,3013945,3013974,3014152,3016045,3016090,3016119,3016297,3018184,3018229,3018258,3018436,3020375,3020421,3020450,3020630,3022177,3022203,3022222,3022341,3023649,3023676,3023694,3023813,3025116,3025142,3025160,3025279,3026566,3026592,3026609,3026729,3028001,3028029,3028049,3028170,3029441,3029467,3029484,3029604,3030868,3030893,3030911,3031035,3032279,3032307,3032328,3032449,3033690,3033712,3033732,3033856,3035277,3035304,3035324,3035449,3036860,3036887,3036903,3037026,3038429,3038455,3038472,3038595,3039989,3040014,3040032,3040156,3041539,3041564,3041586,3041707,3043082,3043108,3043128,3043251,3044623,3044649,3044667,3044788,3046154,3046180,3046197,3046320,3047667,3047696,3047711,3047833,3049173,3049203,3049222,3049342,3050683,3050710,3050730,3050850,3052213,3052231,3052356,3053702,3053725,3053845,3055183,3055202,3055323,3056659,3056677,3056799,3058117,3058137,3058257,3059585,3059705,3061025,3061144,3062765,3062884,3064498,3064616,3066336,3068046,3069744,3071432,3073113,3074783,3076440,3078092,3079755,3081401,3083043,3084670,3086321,3087965,3089597,3091222,3092831,3094431,3096023,3097608,3099185,3099457,3100757,3101031,3102315,3102593,3103858,3104138,3105671,3107223,3108769,3110337,3111893,3113440,3114978,3116495,3118011,3119521,3121025,3122556,3124247,3125936,3127610,3129277,3130933,3132580,3134220,3135860,3137493,3137899,3139114,3139520,3140726,3141132,3142330,3142736,3143924,3144330,3145514,3145920,3147094,3147500,3147730,3148136,3148360,3148766,3148984,3149390,3149608,3150014,3151155,3151561,3152694,3153100,3154227,3154633,3155750,3156156,3157266,3157672,3158773,3159179,3160267,3160673,3161752,3162158,3163229,3163636,3164701,3165108,3166164,3166592,3167616,3167992,3169010,3169386,3170395,3170771,3171772,3172148,3173143,3173519,3174508,3174883,3175908,3176285,3177306,3177683,3177721,3177734,3177735,3178697,3179077,3179128,3179143,3179144,3180169,3180549,3180600,3180615,3180616,3181637,3182017,3182068,3182083,3182084,3183103,3183478,3183519,3183532,3183533,3184566,3184943,3184984,3184997,3184998,3186027,3186404,3186445,3186458,3186459,3187484,3187861,3187902,3187915,3187916,3188935,3189312,3189353,3189366,3189367,3190376,3190757,3190798,3190811,3190812,3191818,3192199,3192239,3192252,3192253,3193255,3193665,3193738,3193764,3193766,3194946,3195356,3195429,3195455,3195457,3196733,3197142,3197214,3197240,3197242,3198705,3199115,3199189,3199216,3199218,3200674,3201053,3201094,3201107,3201108,3202369,3202752,3202792,3202805,3202806,3204065,3204445,3204485,3204498,3204499,3205757,3206134,3206175,3206188,3206189,3207443,3207822,3207862,3207875,3207876,3209123,3209502,3209542,3209555,3209556,3210796,3211174,3211215,3211228,3211229,3212513,3212893,3212934,3212947,3212948,3214216,3214598,3214638,3214651,3214652,3216294,3216334,3216347,3216348,3217988,3218028,3218041,3218042,3219675,3219716,3219729,3219730,3221354,3221395,3221408,3221409,3223027,3223069,3223083,3223084,3224692,3224736,3224750,3224751,3226321,3226365,3226379,3226380,3227938,3227981,3227995,3227996,3229555,3229598,3229612,3229613,3231178,3231221,3231235,3231236,3232793,3232837,3232851,3232852,3234402,3234446,3234460,3234461,3236001,3236045,3236059,3236060,3237585,3237629,3237643,3237644,3239156,3239199,3239213,3239214,3240722,3240766,3240780,3240781,3242325,3242369,3242383,3242384,3243917,3243960,3243974,3243975,3245499,3245542,3245556,3245557,3247100,3247144,3247158,3247159,3248686,3248730,3248744,3248745,3250257,3250300,3250314,3250315,3251821,3251865,3251879,3251880,3253425,3253468,3253482,3253483,3255084,3255184,3255216,3255218,3256923,3257095,3257196,3257228,3257230,3258933,3259107,3259207,3259239,3259240,3260929,3261104,3261203,3261235,3261237,3262913,3263084,3263185,3263218,3263220,3264894,3265067,3265166,3265198,3265200,3266870,3267060,3267160,3267189,3267191,3268856,3269046,3269186,3269231,3269235,3270906,3271134,3271276,3271320,3271325,3273033,3273261,3273400,3273447,3273451,3275142,3275371,3275510,3275557,3275560,3277234,3277465,3277604,3277650,3277653,3279325,3279554,3279694,3279742,3279745,3281460,3281688,3281829,3281876,3281878,3283586,3283788,3283816,3283956,3284003,3284007,3285707,3285909,3285938,3286079,3286124,3286127,3287858,3288057,3288087,3288228,3288275,3288276,3289990,3290191,3290220,3290361,3290409,3290410,3292108,3292307,3292338,3292476,3292523,3292527,3294212,3294412,3294443,3294583,3294627,3294632,3296311,3296513,3296542,3296682,3296730,3296732,3298404,3298606,3298636,3298774,3298820,3298825,3300490,3300690,3300719,3300861,3300905,3300909,3302565,3302765,3302796,3302937,3302982,3302986,3304628,3304830,3304859,3304998,3305046,3305048,3306677,3306878,3306909,3307048,3307096,3307097,3308723,3308923,3308954,3309095,3309142,3309143,3310765,3310966,3310995,3311136,3311183,3311184,3312798,3312994,3313025,3313162,3313208,3313213,3314816,3315012,3315043,3315182,3315230,3315232,3316828,3317023,3317056,3317192,3317238,3317243,3318830,3319025,3319056,3319194,3319240,3319244,3320817,3321012,3321045,3321181,3321230,3321231,3322801,3323000,3323030,3323166,3323215,3323217,3324950,3325147,3325175,3325313,3325359,3325364,3327219,3327418,3327446,3327585,3327631,3327634,3329605,3329806,3329834,3329972,3330020,3330022,3331986,3332185,3332215,3332354,3332400,3332403,3334352,3334553,3334581,3334720,3334767,3334769,3336705,3336902,3336935,3337071,3337118,3337122,3339053,3339254,3339282,3339420,3339467,3339471,3341397,3341594,3341625,3341765,3341811,3341814,3343733,3343931,3343962,3344100,3344146,3344150,3346091,3346291,3346320,3346458,3346506,3346508,3348444,3348643,3348673,3348810,3348855,3348860,3350781,3350980,3351008,3351148,3351195,3351196,3353104,3353301,3353331,3353469,3353515,3353519,3355421,3355622,3355650,3355789,3355837,3355838,3357751,3357951,3357987,3358009,3358140,3358185,3358188,3360096,3360297,3360332,3360352,3360492,3360546,3360547,3362458,3362658,3362695,3362713,3362854,3362907,3362911,3364812,3365010,3365049,3365067,3365208,3365262,3365265,3367154,3367352,3367387,3367407,3367550,3367603,3367604,3369484,3369682,3369717,3369737,3369877,3369931,3369935,3371809,3372006,3372044,3372064,3372204,3372254,3372260,3374125,3374326,3374360,3374383,3374522,3374573,3374577,3376438,3376635,3376674,3376692,3376834,3376884,3376889,3378744,3378941,3378979,3379000,3379141,3379192,3379195,3381041,3381239,3381275,3381295,3381436,3381491,3381492,3383311,3383510,3383544,3383566,3383705,3383756,3383762,3385599,3385795,3385829,3385850,3385989,3386041,3386046,3388063,3388098,3388118,3388259,3388310,3388316,3390323,3390358,3390377,3390519,3390572,3390574,3392572,3392609,3392630,3392768,3392822,3392825,3394808,3394846,3394867,3395007,3395057,3395062,3397031,3397069,3397089,3397230,3397281,3397284,3399246,3399284,3399302,3399442,3399498,3399500,3401447,3401486,3401505,3401644,3401700,3401702,3403638,3403675,3403695,3403835,3403889,3403893,3405820,3405855,3405877,3406016,3406070,3406073,3407988,3408023,3408043,3408201,3408256,3408260,3410152,3410190,3410211,3410364,3410421,3410425,3412295,3412333,3412353,3412508,3412567,3412569,3414464,3414500,3414522,3414679,3414692,3414733,3414737,3416613,3416650,3416669,3416826,3416846,3416884,3416885,3418752,3418790,3418809,3418967,3418987,3419024,3419026,3420875,3420911,3420930,3421087,3421102,3421144,3421148,3422978,3423012,3423035,3423190,3423208,3423246,3423249,3425056,3425095,3425114,3425271,3425288,3425329,3425330,3427116,3427154,3427175,3427329,3427344,3427386,3427390,3429158,3429196,3429215,3429372,3429393,3429430,3429432,3431183,3431222,3431240,3431399,3431412,3431454,3431458,3433195,3433231,3433253,3433408,3433423,3433464,3433468,3435199,3435235,3435257,3435411,3435431,3435465,3435470,3437194,3437232,3437252,3437407,3437425,3437462,3437467,3439176,3439210,3439231,3439385,3439401,3439444,3439446,3441139,3441176,3441199,3441352,3441368,3441411,3441412,3443107,3443143,3443162,3443317,3443333,3443370,3443375,3445078,3445116,3445135,3445290,3445307,3445349,3445350,3447233,3447271,3447287,3447444,3447461,3447501,3447503,3449380,3449417,3449434,3449590,3449605,3449644,3449649,3451519,3451554,3451573,3451732,3451745,3451785,3451790,3453651,3453686,3453706,3453864,3453883,3453921,3453922,3455771,3455805,3455825,3455980,3455999,3456037,3456042,3457896,3457932,3457948,3458108,3458125,3458161,3458167,3460020,3460055,3460075,3460232,3460248,3460294,3460297,3462153,3462191,3462212,3462367,3462386,3462428,3462433,3464280,3464319,3464337,3464492,3464510,3464554,3464560,3466429,3466469,3466486,3466641,3466658,3466703,3466709,3468610,3468649,3468668,3468822,3468841,3468885,3468888,3470776,3470816,3470834,3470989,3471007,3471050,3471056,3472932,3472972,3472989,3473144,3473167,3473206,3473212,3475091,3475128,3475144,3475300,3475321,3475367,3475368,3477243,3477280,3477298,3477456,3477471,3477518,3477522,3479387,3479426,3479446,3479601,3479618,3479662,3479668,3481564,3481582,3481736,3481752,3481799,3481802,3483697,3483715,3483866,3483882,3483928,3483934,3485817,3485835,3485989,3486010,3486054,3486055,3487930,3487946,3488101,3488117,3488162,3488167,3490037,3490055,3490209,3490223,3490277,3490284,3492167,3492186,3492335,3492356,3492408,3492412,3494287,3494306,3494457,3494478,3494528,3494536,3496404,3496424,3496575,3496596,3496646,3496652,3498558,3498577,3498725,3498748,3498798,3498804,3500720,3500869,3500893,3500941,3500949,3502856,3503007,3503028,3503077,3503083,3504984,3505135,3505159,3505209,3505215,3507111,3507262,3507279,3507334,3507338,3509229,3509384,3509405,3509456,3509461,3511343,3511498,3511519,3511570,3511575,3513603,3513625,3513675,3513683,3515702,3515717,3515772,3515778,3517788,3517805,3517864,3517865,3519875,3519898,3519947,3519952,3521954,3521975,3522027,3522031,3524022,3524046,3524097,3524100,3526086,3526101,3526158,3526161,3528138,3528158,3528209,3528213,3530197,3530216,3530268,3530274,3532243,3532259,3532315,3532319,3534283,3534299,3534354,3534360,3536322,3536342,3536392,3536398,3538351,3538372,3538425,3538427,3540374,3540389,3540444,3540452,3542445,3542462,3542514,3542519,3544502,3544521,3544573,3544578,3546543,3546558,3546613,3546620,3548577,3548597,3548652,3548657,3550609,3550630,3550685,3550686,3552653,3552673,3552723,3552728,3554687,3554706,3554759,3554764,3556724,3556746,3556799,3556801,3558749,3558769,3558821,3558827,3560762,3560781,3560836,3560837,3562763,3562784,3562837,3562842,3564767,3564789,3564839,3564842,3566786,3566807,3566857,3566863,3568797,3568819,3568871,3568873,3570814,3570837,3570886,3570892,3572825,3572841,3572895,3572901,3574836,3574854,3574911,3574915,3576744,3576764,3576817,3576820,3578646,3578667,3578719,3578725,3580545,3580563,3580617,3580624,3582439,3582454,3582495,3582499,3584298,3584310,3584354,3584358,3586156,3586167,3586212,3586216,3588010,3588025,3588064,3588070,3589862,3589874,3589917,3589922,3591709,3591722,3591764,3591769,3593571,3593610,3593616,3595520,3595581,3595582,3596104,3597517,3597572,3597577,3598095,3599492,3599547,3599553,3600072,3601504,3601512,3602030,3603455,3603458,3603980,3605390,3605396,3605917,3607317,3607323,3607843,3609237,3609240,3609762,3611146,3611148,3611669,3613043,3613046,3613570,3614963,3614969,3615491,3616880,3616883,3617403,3617406,3618788,3618791,3619309,3619314,3620686,3620692,3621209,3621216,3622584,3622592,3623108,3623115,3624478,3624481,3625000,3625007,3626360,3626877,3626885,3628746,3628753,3630610,3630614,3632468,3632473,3634321,3634325,3636162,3636168,3637998,3638004,3639822,3639828,3641634,3641638,3643438,3643442,3645232,3645237,3647017,3647024,3648796,3648803,3650568,3650573,3652327,3652331,3654074,3654079,3655812,3655820,3657547,3657552,3659265,3659273,3660988,3660992,3662711,3662719,3664425,3664432,3666130,3666135,3667827,3667833,3669514,3669521,3671194,3671199,3672868,3672873,3674532,3674538,3676185,3676192,3677829,3677835,3679468,3679475,3681101,3681109,3682733,3682739,3684358,3684365,3685977,3685983,3687587,3687592,3689187,3689192,3690782,3690788,3692372,3692380,3693957,3693962,3695530,3695537,3697103,3697108,3698657,3698662,3700198,3700206,3701738,3701744,3703271,3703277,3704796,3704802,3706315,3706322,3707824,3707832,3709320,3709326,3710807,3710815,3712293,3712299,3713770,3713776,3715240,3715246,3716705,3716710,3718165,3718172,3719619,3719626,3721067,3721072,3722507,3722514,3723946,3723951,3725373,3725380,3726798,3726802,3728212,3728219,3729622,3729629,3731025,3731030,3732417,3732424,3733803,3733809,3735178,3735185,3736547,3736554,3737910,3737917,3739262,3739269,3740608,3740615,3741946,3741953,3743277,3743283,3744599,3744603,3745913,3745920,3747222,3747228,3748520,3748527,3749812,3749817,3751094,3751101,3752370,3752375,3753635,3753641,3754894,3754902,3756148,3756155,3757404,3757410,3758651,3758657,3759890,3759896,3761121,3761129,3762346,3762354,3763569,3763575,3764787,3764792,3765997,3766002,3767199,3767203,3768391,3768399,3769581,3769587,3769973,3769978,3770362,3770367,3770747,3770754,3771130,3771135,3771509,3771515,3771886,3771894,3772264,3772268,3772635,3772640,3773005,3773009,3773370,3773376,3773737,3773745,3774105,3774112,3774470,3774477,3774833,3774840,3775194,3775201,3775553,3775560,3775910,3775917,3776263,3776270,3776611,3776618,3776963,3776970,3777312,3777319,3777657,3777664,3777997,3778004,3778332,3778339,3778662,3778669,3778987,3778994,3779317,3779324,3779643,3779650,3779964,3779971,3780280,3780287,3780595,3780602,3780906,3780913,3781211,3781218,3781511,3781518,3781808,3781815,3782100,3782107,3782388,3782395,3782671,3782678,3782956,3782963,3783238,3783245,3783517,3783524,3783793,3783800,3784065,3784072,3784336,3784343,3784602,3784609,3784864,3784871,3785122,3785129,3785377,3785384,3785629,3785636,3785963,3785970,3786294,3786301,3786644,3786651,3786990,3786997,3787332,3787339,3787671,3787678,3788006,3788013,3788339,3788346,3788668,3788675,3788994,3789001,3789317,3789324,3789635,3789642,3789951,3789958,3790264,3790271,3790575,3790582,3790882,3790889,3791186,3791193,3791487,3791494,3791784,3791791,3792079,3792086,3792371,3792378,3792660,3792667,3792947,3792954,3793230,3793237,3793509,3793516,3793784,3793791,3794057,3794064,3794333,3794599,3816957,3816974,3817309,3817324,3817652,3817671,3818041,3818055,3818461,3818859,3819248,3819637,3835747,3835989,3836232,3836736,3836995,3837252,3837509,3837762,3838014,3838271,3838523,3838775,3839028,3839279,3839526,3839770,3840012,3840251,3845789,3845825,3846035,3846071,3846278,3846314,3846553,3846791,3847025,3847254,3847482,3847714,3847942,3848166,3848395,3860854,3861651,3862443,3863233,3864021,3864803,3865584,3866361,3867136,3867909,3868678,3869449,3869460,3870216,3870229,3870979,3870992,3871739,3871751,3873225,3873238,3873980,3873993,3874735,3874748,3875483,3875497,3876233,3876246,3876979,3876992,3877721,3877734,3878466,3878479,3879206,3879220,3879949,3879960,3880691,3880704,3881433,3881448,3882178,3882192,3882917,3882933,3883658,3883674,3884401,3884415,3885138,3885152,3885874,3885889,3886608,3886623,3887343,3887358,3888077,3888092,3888807,3888822,3889535,3889550,3890263,3890278,3890987,3891001,3891706,3891721,3892422,3892439,3893140,3893154,3893852,3893866,3894571,3894588,3895291,3895307,3896002,3896020,3896710,3896726,3897418,3897434,3898124,3898140,3898824,3898841,3899525,3899539,3900223,3900242,3900942,3900958,3901656,3901673,3902372,3902386,3903081,3903099,3903789,3903806,3904495,3904511,3905210,3905911,3906604,3907296,3907984,3908669,3918262,3918937,3919627,3920314,3920993,3921673,3922344,3922367,3923026,3923048,3923704,3923725,3924399,3925069,3925732,3926396,3927058,3927718,3928375,3929031,3975704,3976316,3976919,3977518,3978115,3978709,3979298,3979888,3980472,3981053,3981630,3982202,3982775,4250810,4251178,4251542,4251904,4252263,4252620,4252974,4253326,4253675,4254021,4254362,4254699,4255031,4255361,4255688,4256013,4256336,4256656,4256975,4257292,4257606)) 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





	Elena Stikhina (Soprano) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Elena Stikhina (Soprano)

Elena Stikhina (Soprano)

• Recipient of the Audience Award and special Culturarte Prize at the Operalia competition (Guadalajara, Mexico, 2016) 
• Prize-winner at the Competizione dell’Opera (Linz, Austria, 2014, 1st prize) 
• Prize-winner at the II International Rachmaninoff Vocalists' Competition (Rostov on Don, 2013, 1st prize) 
• Prize-winner at the IV International Georgy Sviridov Chamber Singing Competition (Kursk, 2011, 3rd prize)

Born in Lesnoy, Sverdlovsk Region. Graduated from the Moscow Conservatoire (class of Larisa Rudakova). Trained at the Galina Vishnevskaya Opera Singing Centre under Makvala Kasrashvili.

Since 2014 she has been a soloist of the State Primorsk Opera and Ballet Theatre (now the Primorsky Stage of the Mariinsky Theatre); Mariinsky Theatre soloist since 2017.

In 2013 she took part in an international opera master-class in Zurich, where she rehearsed the title role of Aida under Peter Konwitschny. Has appeared at the Beethovenfest in Bonn, the Brucknerhaus in Linz, the Tonhalle in Zurich, the opera festivals Gut Immling in Halfing and DomStufen in Erfurt (the title role in Tosca) and the Landestheater in Salzburg (Micaëla in Carmen).

In the 2016-2017 she made her debut at the Theater Basel (Leonora in La forza del destino), the Mariinsky Theatre (title role in a premiere of Salome) and the Finnish National Opera (Tatiana in Eugene Onegin). In April 2017, she made her debut as Lady Macbeth in Verdi's opera Macbeth at the Primorsky Stage of the Mariinsky Theatre.

Upcoming engagements include her debut at the Opéra National de Paris and the Deutsche Oper Berlin (Leonora in Il trovatore), at the Boston Lyric Opera (the title in Tosca).

Repertoire at the Mariinsky Theatre: 
Lisa (The Queen of Spades
Leonora (La forza del destino
Salome (Salome)

Repertoire also includes: the Countess (Le nozze di Figaro), Violetta (La traviata), Leonora (La forza del destino), Micaëla (Carmen), Nedda (I pagliacci), Tatiana (Eugene Onegin), Zemfira (Aleko), Olga (The Story of a Real Man) and the title roles in Iolanta and Tosca among others.