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 (107712,107731,109599,109618,111476,111495,113346,113365,115207,115226,117083,117101,118958,118976,120829,120847,122695,122713,124553,124571,126402,126420,128242,128260,130072,130089,131901,131918,133734,133751,135559,135576,137380,137397,139198,139214,141008,141024,142809,142825,144598,144614,146378,146394,148149,148165,149906,149922,151660,151672,153401,153413,155132,155144,156853,156865,158564,158576,160290,160302,162017,162029,163742,163761,165484,165503,167215,167234,168941,168955,170653,170667,172357,172371,174051,174065,175735,175749,177408,177421,179071,179089,180724,180743,182371,182390,184011,184030,185642,185661,187264,187283,188876,188895,190476,190495,192084,193662,196421,197728,199045,200362,202044,203721,205390,342346,342371,344270,344294,346186,346210,348094,348117,349983,350007,351861,351888,353739,353763,355611,355635,357489,357512,359396,359419,361295,361321,363189,363211,365072,365095,366949,366974,368825,368849,370699,370722,372564,372586,374418,374441,376262,376286,378098,378122,379931,379955,381759,381783,383087,383094,383101,383577,383603,384906,384913,384920,385393,385419,386718,386725,386732,387200,387226,388534,388541,388548,389013,389038,390342,390349,390356,390812,390838,392143,392150,392157,392612,392637,393942,393949,393956,394411,394433,395737,395744,395751,396199,396224,397526,397533,397540,397984,398007,399311,399319,399325,399764,399788,401082,401090,401097,401554,402847,402855,402862,403316,404607,404615,404622,405070,406361,406369,406377,406822,408112,408120,408128,408569,409856,409864,409872,410309,411597,411606,411612,413360,413368,413374,415111,415118,415125,416853,416860,416867,418594,418601,418608,420330,420337,420344,422061,422069,422077,423790,423798,423806,425512,425520,425528,427220,427228,427236,428917,428926,428933,430610,430619,430626,432317,432326,432333,434022,434030,434038,435717,435725,435733,437405,437413,437421,439080,439088,439097,440744,440752,440760,442395,442403,442411,444033,444041,444049,445661,445669,445677,447283,447291,447299,448892,448900,448908,450490,450497,450506,452081,452088,452097,453671,453678,453687,455257,455264,455273,456835,456842,456851,458407,458414,458423,459971,459978,459987,461526,461533,461542,463074,463081,463090,464626,464633,464642,466173,466180,466189,467711,467719,467727,469416,469424,469432,471133,471140,471149,472682,472690,472698,474223,474231,474240,475803,475811,475820,477383,477391,477399,478954,478962,478970,480521,480529,480537,481275,481284,481292,482018,482026,482034,482755,482763,482771,483490,483498,483506,484236,484244,484252,484985,484993,485001,485728,485736,485744,486457,486465,486474,487178,487187,487195,487893,487901,487909,488605,488613,488621,489317,489325,489333,490024,490032,490040,490724,490732,490740,491419,491427,491435,492103,492112,492120,492786,492794,492803,493468,493476,493485,494144,494152,494160,494814,494822,494830,495475,495483,495491,496124,496132,496140,496762,496770,496778,498232,498240,498248,499695,499702,499711,501150,501157,501166,502599,502607,502615,504082,504090,504098,505558,505566,505574,507030,507038,507046,508502,508510,508518,509968,509977,509985,511428,511436,511444,512880,512888,512896,514360,514368,514376,515830,515838,515846,517291,517299,517307,518742,518750,518758,520188,520193,520201,521627,521635,521643,523063,523068,523076,523798,524488,524493,524501,525218,525902,525910,525919,526624,527310,527317,527326,528028,528716,528723,528732,529432,530119,530126,530136,530832,531517,531524,531534,532226,532907,532915,532924,533614,534345,534353,534362,535045,535776,535784,535794,536469,537202,537211,537220,537899,538630,538639,538648,539323,540060,540068,540739,541471,541480,542171,542931,543619,544408,545089,546541,547997,549448,550891,552327,553750,555166,556573,557977,559374,560767,597621,599302,600974,602655,604318,605979,607627,609264,610951,612636,614307,615969,617618,619255,620885,622509,624123,625748,627364,628969,630565,632153,633737,635310,636872,638425,638437,638449,639964,639976,639987,641494,641506,641517,643015,643025,643036,644527,644539,644550,646033,646045,646056,647532,647540,647552,649020,649032,649044,650516,650526,650537,651994,652007,652019,653475,653483,653495,654941,654949,654961,656404,656416,657849,657862,659310,660746,693944,695192,696420,697646,698853,700050,701239,702432,703620,704794,736065,737039,738007,738966,739919,741894,743869,745838,747798,749784,751766,753748,756624,759493,762360,765223,768079,770927,773770,776607,779440,782276,785109,787937,790761,793581,796393,799200,802003,804801,807594,810381,813162,815938,818709,821473,824229,826978,829722,832461,835197,837929,840656,843379,846124,848865,851596,854328,857057,859779,862496,865203,867898,870582,873265,875948,878634,881318,884004,886679,889344,892006,894661,897315,899964,902606,902641,905233,905269,907850,907885,910464,910499,913077,913110,915708,915742,918412,918445,921105,921138,923784,923817,926475,926513,929192,929230,931900,931939,934608,934646,937313,937351,940044,940082,942800,945505,948207,950913,953612,956302,958979,1081707,1081718,1084060,1084071,1086398,1086409,1088721,1088731,1091055,1091066,1093382,1093393,1095697,1095708,1097997,1098008,1100278,1100290,1102551,1102562,1104810,1104821,1107047,1107057,1109262,1109273,1111457,1111469,1113632,1113645,1115789,1115800,1117933,1117945,1120067,1120079,1122202,1122214,1124340,1124352,1126535,1126547,1128760,1128774,1130973,1130987,1133168,1133183,1135358,1135372,1137562,1137576,1139767,1139783,1141958,1141970,1144148,1144164,1146321,1146335,1148485,1148499,1150639,1150653,1152790,1152804,1154936,1154951,1157072,1157085,1159244,1159260,1161399,1161415,1163536,1163550,1165671,1165687,1167805,1167819,1169938,1169954,1172060,1172074,1174172,1174186,1176318,1176332,1178453,1178467,1180581,1180595,1182700,1182714,1184810,1184824,1186922,1186937,1189028,1189043,1191127,1191141,1193215,1193230,1195295,1195309,1197371,1197386,1199435,1199449,1201496,1201510,1203552,1203567,1205599,1205613,1207636,1207650,1209665,1209679,1211707,1211721,1213735,1213749,1215757,1215771,1217766,1217780,1219760,1219774,1221743,1221757,1223719,1223733,1225690,1225704,1227683,1227697,1229697,1229711,1231707,1231723,1233703,1233717,1235691,1235704,1237671,1237685,1239639,1239653,1241595,1241609,1243578,1243592,1245553,1245567,1247513,1247529,1249496,1249510,1251474,1251488,1253455,1253469,1255431,1255445,1256650,1257399,1257413,1258616,1259359,1259373,1260571,1261306,1261320,1262513,1263240,1263254,1264439,1265165,1265179,1266362,1267095,1267109,1268288,1269015,1269029,1270201,1270938,1272105,1272836,1273998,1275878,1277737,1279592,1281441,1283281,1285111,1286928,1288730,1290517,1292329,1294136,1295935,1297725,1299506,1301272,1303026,1304772,1306519,1308254,1309978,1311696,1313615,1315552,1317481,1354902,1356777,1358640,1360501,1362349,1364187,1366012,1367823,1369629,1371427,1373213,1374989,1376841,1378675,1380495,1382309,1384123,1385931,1386127,1387730,1387926,1389523,1389714,1391297,1391493,1393060,1393256,1394839,1395033,1396608,1396804,1398368,1398564,1400117,1400312,1401867,1402061,1403604,1403798,1405330,1405524,1407053,1407249,1408975,1410706,1412429,1414192,1415946,1417687,1419417,1421136,1422852,1424548,1426231,1427897,1429552,1431196,1432830,1434452,1436062,1437691,1439305,1440908,1442504,1444095,1445674,1447242,1448806,1450351,1451884,1453405,1454920,1456425,1457923,1459409,1483453,1483465,1484802,1484813,1486138,1486151,1487467,1487481,1488788,1488798,1490087,1490098,1491377,1491388,1492659,1492670,1493968,1493981,1495268,1495282,1496563,1496574,1497856,1497867,1499154,1499165,1500442,1500452,1501721,1501731,1502992,1503003,1504257,1504267,1505514,1505525,1506763,1506774,1508005,1508016,1509237,1509246,1510462,1510473,1511691,1511702,1512913,1512924,1514138,1514147,1515365,1515374,1516584,1516593,1517794,1517805,1518996,1519007,1520196,1520208,1521389,1521400,1522576,1522587,1523755,1523766,1524927,1524938,1526092,1526104,1527250,1527261,1528402,1528413,1529549,1529560,1530692,1530703,1531831,1531842,1532965,1532976,1534093,1534106,1535221,1535232,1536342,1536353,1537458,1537469,1538598,1538609,1539731,1539742,1540856,1540869,1541978,1541991,1543097,1543108,1544204,1544215,1545306,1545317,1546398,1546409,1547478,1547489,1548546,1548557,1549606,1549616,1550658,1550668,1551702,1551712,1552745,1552757,1553786,1553797,1554820,1554830,1555842,1555853,1556864,1557876,1558877,1648592,1648669,1651395,1651477,1654258,1654341,1657113,1657195,1659955,1660037,1662866,1665683,1668490,1671297,1674152,1676999,1679843,1682676,1685494,1688351,1691209,1693980,1696745,1699503,1702251,1704990,1707763,1710530,1713291,1802493,1804929,1807350,1809753,1812134,1814488,1816834,1819156,1821453,1823725,1825972,1828196,1830398,1832592,1834791,1836981,1839165,1841340,1893903,1895989,1898100,1900253,1971119,1971153,1971185,1973131,1973164,1973194,1975160,1975192,1977147,1977176,1979117,1979149,1981116,1981144,1983108,1983136,1985092,1985124,1987070,1987099,1989068,1991023,1992966,1994900,1996832,1998754,2105101,2107051,2108990,2110918,2112834,2112838,2114740,2114744,2116641,2116643,2118533,2118535,2120414,2120416,2122285,2122287,2124148,2125991,2127830,2129659,2131480,2133291,2135091,2136880,2138722,2140560,2142389,2144207,2146015,2147813,2149600,2197283,2197319,2197544,2198808,2198844,2199069,2200342,2200378,2200603,2201895,2201931,2202158,2203435,2203474,2203699,2204968,2205002,2205229,2206496,2206532,2206757,2208023,2208059,2208284,2209538,2209574,2209799,2211042,2211078,2211303,2212534,2212570,2212852,2214234,2214270,2214552,2215923,2215959,2216240,2217605,2217641,2217923,2219384,2219420,2219782,2221620,2221658,2222018,2223846,2223882,2224244,2226058,2226099,2226457,2228261,2228296,2228658,2230448,2230486,2230848,2232629,2232665,2233028,2235043,2235081,2235444,2237668,2237702,2238064,2240575,2240613,2240975,2243756,2243790,2244152,2246923,2246957,2247319,2250077,2250115,2250477,2253227,2253265,2253625,2256362,2256402,2256764,2259496,2259536,2259895,2262613,2262654,2263016,2265729,2265768,2266128,2268831,2268870,2269230,2271923,2271963,2272322,2275035,2275075,2275434,2278180,2278220,2278579,2281313,2281354,2281716,2284467,2284503,2284867,2287605,2287646,2288008,2290738,2290779,2291141,2293866,2293907,2294264,2296986,2297023,2297385,2300110,2300147,2300341,2300508,2303239,2303277,2303470,2303638,2306386,2306427,2306617,2306784,2309555,2309596,2309786,2309953,2312716,2312758,2312951,2313120,2315881,2315922,2316112,2316279,2319037,2319073,2319268,2319435,2322188,2322225,2322419,2322586,2325329,2325370,2325560,2325729,2328463,2328504,2328694,2328861,2331589,2331628,2331810,2331979,2334695,2334734,2334917,2335086,2337795,2337833,2338016,2338183,2340893,2340929,2341114,2341281,2344001,2344042,2344225,2344394,2347106,2347145,2347328,2347497,2350206,2350244,2350430,2350599,2353328,2353370,2353556,2353724,2356445,2356486,2356669,2356838,2359548,2359589,2359772,2359941,2362646,2362684,2362871,2363038,2365736,2365776,2365961,2366130,2368816,2368852,2369038,2369206,2371886,2371922,2372108,2372276,2374943,2374978,2375167,2375336,2377987,2378022,2378211,2378380,2381021,2381058,2381245,2381414,2384050,2384087,2384274,2384442,2387028,2387070,2387108,2387294,2387461,2390090,2390133,2390172,2390358,2390525,2393149,2393193,2393230,2393418,2393586,2396201,2396244,2396281,2396470,2396637,2399237,2399279,2399322,2399506,2399673,2402258,2402302,2402342,2402527,2402696,2405270,2405317,2405357,2405541,2405708,2408281,2408325,2408368,2408552,2408719,2411282,2411327,2411367,2411552,2411721,2414273,2414319,2414360,2414544,2414713,2417257,2417305,2417364,2417566,2417735,2420264,2420312,2420372,2420574,2420742,2423258,2423305,2423369,2423568,2423735,2426247,2426295,2426355,2426558,2426725,2429230,2429278,2429339,2429541,2429709,2432202,2432250,2432316,2432513,2432680,2435165,2435213,2435274,2435476,2435643,2438115,2438165,2438231,2438428,2438595,2441053,2441103,2441170,2441367,2441534,2443985,2444037,2444098,2444295,2444464,2446904,2446961,2447022,2447219,2447388,2449819,2449870,2449937,2450134,2450301,2452724,2452774,2452840,2453039,2453206,2455617,2455663,2455731,2455928,2456097,2458493,2458543,2458608,2458815,2458983,2461365,2461417,2461480,2461687,2461856,2464223,2464276,2464337,2464543,2464712,2467072,2467123,2467187,2467404,2467586,2469949,2470000,2470062,2470278,2470506,2472879,2472929,2472993,2473204,2473422,2475841,2475902,2476152,2476371,2478776,2478841,2479090,2479307,2481700,2481765,2482014,2482231,2484617,2484676,2484924,2485141,2487522,2487580,2487831,2488050,2490464,2490524,2490773,2490988,2493386,2493454,2493700,2493913,2496313,2496374,2496620,2496833,2499221,2499282,2499531,2499745,2502115,2502177,2502426,2502640,2505058,2505306,2505521,2507926,2508174,2508388,2510783,2511034,2511250,2513644,2513895,2514110,2516497,2516749,2516963,2519346,2519597,2519810,2522189,2522437,2522650,2525016,2525264,2525477,2527826,2528078,2528293,2530641,2530889,2531102,2533445,2533694,2533907,2536241,2536490,2536704,2539032,2539289,2539502,2541821,2542079,2542293,2544603,2544860,2545073,2547626,2547838,2550409,2550647,2553209,2553446,2556023,2556261,2558831,2559069,2561631,2561868,2564414,2564651,2567184,2567421,2569988,2570257,2572815,2573083,2575635,2575903,2578444,2578713,2581253,2581522,2584043,2584312,2586819,2587087,2589586,2589855,2592352,2592621,2595106,2595375,2597852,2598119,2600588,2600856,2603313,2603582,2606022,2606289,2608727,2608994,2611426,2611693,2614153,2614420,2616872,2617143,2619588,2619857,2622290,2622558,2624975,2625242,2627656,2627926,2630327,2630598,2632989,2633268,2635639,2635919,2638282,2638565,2640912,2641193,2643529,2643809,2646138,2646419,2648733,2649017,2651319,2651603,2653895,2654176,2656459,2656740,2659004,2659287,2661532,2661815,2664039,2664322,2666536,2666823,2669011,2669297,2671466,2671757,2673910,2674200,2676333,2676623,2678740,2679027,2681122,2681409,2683494,2683785,2685860,2686148,2688218,2688509,2690568,2690858,2692906,2693197,2695228,2695516,2697874,2698269,2700948,2701343,2704030,2704425,2707497,2710296,2710542,2713331,2713584,2716355,2716607,2719420,2719677,2722494,2722789,2725593,2725891,2728682,2728980,2731767,2732076,2734878,2735186,2737969,2738277,2741051,2741359,2744123,2744431,2747174,2747482,2750204,2750512,2753231,2753539,2756255,2756567,2759268,2759580,2762283,2762595,2765292,2765604,2768282,2768594,2771256,2771568,2774226,2774538,2777497,2780481,2783506,2786587,2789666,2792725,2795781,2798850,2801909,2804959,2807926,2810870,2813794,2816710,2819691,2822661,2825643,2828612,2831563,2834493,2837416,2840344,2843262,2844701,2846129,2847548,2848956,2851810,2853230,2854643,2856053,2857456,2858852,2860239,2861615,2864391,2867168,2868541,2869920,2871296,2872667,2874032,2875389,2876735,2878078,2879450,2882226,2884991,2887732,2906688,2909274,2911883,2914474,2917059,2919640,2922207,2924764,2927311,2929839,2932349,2934855,2937350,2939851,2942348,2942459,2944835,2944946,2947305,2947416,2949754,2949865,2952203,2952306,2954639,2954750,2957231,2959706,2962168,2964606,2967026,2969440,2971858,2974250,2976631,2978999,2981379,2983747,2986112,2988493,3016003,3018142,3020334,3022148,3023620,3025087,3026537,3027975,3029411,3030838,3032253,3033662,3035251,3036833,3038402,3039962,3041512,3043056,3098129,3098271,3098281,3099709,3099851,3099861,3101280,3101422,3101432,3102840,3102981,3102991,3104385,3104527,3104537,3105922,3106064,3106074,3107475,3107617,3107627,3109055,3109197,3109207,3110625,3110766,3110776,3112182,3112324,3112334,3113731,3113872,3113882,3115264,3115405,3115415,3116785,3116926,3116936,3118299,3118440,3118450,3119809,3119950,3119960,3121312,3121454,3121464,3122842,3122982,3122992,3124537,3124678,3124688,3126224,3126364,3126374,3127899,3128038,3128048,3129563,3129702,3129712,3131219,3131358,3131368,3132866,3133006,3133016,3134506,3134646,3134656,3136146,3136286,3136296,3137779,3137919,3137929,3137956,3139400,3139540,3139550,3139577,3141012,3141152,3141162,3141189,3142616,3142756,3142766,3142793,3144210,3144350,3144360,3144387,3145800,3145940,3145950,3145977,3147380,3147520,3147530,3147557,3148016,3148156,3148166,3148193,3148646,3148786,3148796,3148823,3149270,3149410,3149420,3149447,3149894,3150034,3150044,3150071,3151441,3151581,3151591,3151618,3152980,3153120,3153130,3153157,3154513,3154653,3154663,3154690,3156036,3156176,3156186,3156213,3157552,3157692,3157702,3157729,3159059,3159199,3159209,3159236,3160553,3160693,3160703,3160730,3162038,3162178,3162188,3162215,3163516,3163656,3163666,3163693,3164988,3165128,3165138,3165165,3166472,3166612,3166622,3166649,3167879,3168012,3168022,3168049,3169273,3169406,3169416,3169443,3170658,3170791,3170801,3170828,3172035,3172168,3172178,3172205,3173406,3173539,3173549,3173576,3174770,3174903,3174913,3174940,3176172,3176305,3176315,3176342,3177570,3177703,3177713,3177740,3178959,3179099,3179116,3179150,3180431,3180571,3180588,3180622,3181899,3182039,3182056,3182090,3183365,3183498,3183511,3183538,3184830,3184963,3184976,3185003,3186291,3186424,3186437,3186464,3187748,3187881,3187894,3187921,3189199,3189332,3189345,3189372,3190643,3190777,3190790,3190817,3192085,3192218,3192231,3192258,3193521,3193695,3193719,3193782,3195211,3195386,3195410,3195472,3196996,3197172,3197195,3197258,3198972,3199147,3199171,3199232,3200939,3201073,3201086,3201113,3202637,3202771,3202784,3202811,3204331,3204464,3204477,3204504,3206020,3206154,3206167,3206194,3207707,3207841,3207854,3207881,3209387,3209521,3209534,3209561,3211061,3211194,3211207,3211234,3212780,3212913,3212926,3212953,3214484,3214617,3214630,3214657,3216178,3216313,3216326,3216353,3217872,3218007,3218020,3218047,3219561,3219695,3219708,3219735,3221239,3221374,3221387,3221414,3222907,3223047,3223061,3223089,3224571,3224712,3224728,3224756,3226200,3226341,3226357,3226385,3227817,3227957,3227973,3228001,3229434,3229574,3229590,3229618,3231056,3231197,3231213,3231241,3232672,3232813,3232829,3232857,3234281,3234422,3234438,3234466,3235880,3236021,3236037,3236065,3237464,3237605,3237621,3237649,3239035,3239175,3239191,3239219,3240602,3240742,3240758,3240786,3242204,3242345,3242361,3242389,3243796,3243936,3243952,3243980,3245378,3245518,3245534,3245562,3246980,3247120,3247136,3247164,3248566,3248706,3248722,3248750,3250136,3250276,3250292,3250320,3251700,3251841,3251857,3251885,3253266,3253444,3253460,3253488,3254865,3255128,3255162,3255235,3256875,3257138,3257173,3257247,3258887,3259149,3259184,3259257,3260884,3261147,3261180,3261255,3262866,3263129,3263163,3263236,3264845,3265109,3265144,3265217,3266824,3267103,3267136,3267208,3268810,3269106,3269151,3269260,3270857,3271194,3271241,3271351,3272984,3273320,3273367,3273477,3275094,3275430,3275476,3275587,3277188,3277523,3277569,3277680,3279277,3279615,3279661,3279770,3281411,3281749,3281794,3281904,3283539,3283702,3283876,3283923,3284033,3285662,3285823,3285999,3286043,3286153,3287810,3287972,3288147,3288193,3288302,3289944,3290107,3290282,3290325,3290436,3292059,3292222,3292396,3292442,3292553,3294164,3294327,3294503,3294546,3294658,3296264,3296428,3296601,3296646,3296757,3298358,3298520,3298694,3298739,3298851,3300441,3300607,3300780,3300824,3300935,3302518,3302681,3302857,3302901,3303012,3304582,3304745,3304919,3304964,3305075,3306629,3306794,3306969,3307012,3307124,3308675,3308841,3309015,3309058,3309170,3310717,3310880,3311056,3311099,3311210,3312750,3312911,3313083,3313127,3313239,3314769,3314931,3315103,3315148,3315257,3316780,3316942,3317114,3317157,3317268,3318782,3318943,3319116,3319158,3319270,3320770,3320930,3321102,3321148,3321258,3322755,3322915,3323087,3323133,3323243,3324902,3325062,3325234,3325280,3325389,3327171,3327333,3327506,3327550,3327660,3329559,3329720,3329893,3329939,3330048,3331941,3332103,3332276,3332318,3332429,3334307,3334467,3334642,3334684,3334795,3336659,3336819,3336993,3337037,3337147,3339006,3339168,3339342,3339386,3339497,3341349,3341511,3341686,3341730,3341839,3343687,3343850,3344021,3344067,3344176,3346043,3346207,3346380,3346423,3346534,3348396,3348559,3348731,3348775,3348886,3350732,3350894,3351069,3351113,3351223,3353055,3353219,3353390,3353434,3353546,3355376,3355536,3355710,3355754,3355865,3357706,3357867,3358058,3358105,3358215,3360050,3360212,3360403,3360456,3360577,3362411,3362575,3362765,3362819,3362892,3362939,3364928,3365119,3365172,3365246,3365294,3367267,3367460,3367512,3367583,3367633,3369598,3369789,3369842,3369915,3369964,3371924,3372115,3372167,3372238,3372289,3374241,3374431,3374484,3374556,3374607,3376554,3376745,3376796,3376868,3376919,3378859,3379049,3379102,3379177,3379224,3381157,3381347,3381400,3381473,3381522,3383426,3383617,3383670,3383743,3383791,3385711,3385901,3385954,3386026,3386075,3387979,3388168,3388222,3388294,3388345,3390238,3390428,3390482,3390555,3390604,3392490,3392680,3392734,3392805,3392854,3394727,3394917,3394970,3395041,3395091,3396949,3397140,3397192,3397263,3397313,3399162,3399355,3399406,3399479,3399529,3401364,3401557,3401610,3401682,3401731,3403556,3403746,3403801,3403872,3403921,3405735,3405927,3405981,3406051,3406102,3407905,3408094,3408157,3408238,3408288,3410069,3410259,3410321,3410406,3410453,3412213,3412404,3412464,3412548,3412598,3414380,3414574,3414634,3414717,3414766,3416528,3416721,3416783,3416865,3416914,3418669,3418862,3418923,3419006,3419055,3420791,3420984,3421042,3421129,3421177,3422894,3423086,3423146,3423231,3423278,3424975,3425167,3425227,3425310,3425360,3427034,3427226,3427285,3427369,3427419,3429075,3429267,3429329,3429413,3429462,3431100,3431292,3431354,3431438,3431486,3433112,3433302,3433363,3433449,3433497,3435306,3435368,3435451,3435500,3437302,3437364,3437448,3437495,3439283,3439344,3439428,3439476,3441249,3441308,3441391,3441441,3443210,3443273,3443356,3443404,3445184,3445246,3445330,3445379,3447340,3447401,3447484,3447532,3449485,3449547,3449629,3449678,3451624,3451686,3451770,3451819,3453756,3453818,3453901,3453951,3455876,3455938,3456021,3456070,3457999,3458063,3458147,3458195,3460124,3460187,3460277,3460327,3462262,3462322,3462411,3462463,3464386,3464449,3464540,3464589,3466538,3466596,3466687,3466738,3468716,3468779,3468867,3468917,3470885,3470943,3471035,3471085,3473041,3473099,3473191,3473241,3475196,3475255,3475346,3475397,3477348,3477410,3477502,3477550,3479494,3479557,3479645,3479697,3481633,3481690,3481781,3481830,3483766,3483822,3483914,3483963,3485888,3485945,3486036,3486085,3487997,3488055,3488145,3488195,3490105,3490164,3490255,3490323,3492235,3492291,3492386,3492450,3494356,3494415,3494506,3494573,3496472,3496530,3496623,3496689,3498625,3498682,3498777,3498840,3500770,3500824,3500921,3500985,3502904,3502959,3503056,3503120,3505036,3505090,3505187,3505250,3507160,3507219,3507317,3507378,3509282,3509336,3509434,3509497,3511396,3511453,3511548,3511610,3513502,3513559,3513653,3513719,3515599,3515655,3515754,3515816,3517687,3517745,3517844,3517905,3519775,3519830,3519929,3519991,3521853,3521910,3522008,3522068,3523922,3523980,3524076,3524138,3525984,3526038,3526139,3526199,3528035,3528093,3528186,3528251,3530096,3530150,3530249,3530312,3532141,3532197,3532296,3532356,3534180,3534237,3534336,3534396,3536219,3536274,3536374,3536436,3538250,3538306,3538404,3538465,3540329,3540424,3540489,3542399,3542493,3542557,3544454,3544552,3544615,3546495,3546596,3546657,3548533,3548628,3548694,3550564,3550664,3550724,3552606,3552704,3552766,3554640,3554737,3554801,3556680,3556779,3556840,3558703,3558804,3558864,3560718,3560814,3560875,3562719,3562813,3562880,3564721,3564816,3564880,3566738,3566837,3566900,3568751,3568850,3568912,3570869,3570930,3572877,3572938,3574891,3574953,3576793,3576860,3578700,3578762,3580597,3580662,3582478,3582526,3584337,3584385,3586197,3586244,3588049,3588096,3589901,3589949,3591748,3591798,3593595,3593642,3595558,3595621,3597551,3597613,3599527,3599590,3601484,3601549,3603432,3603497,3605367,3605435,3607294,3607363,3609212,3609281,3611127,3611189,3613022,3613084,3615006,3616922,3618831,3620731,3622630,3624520,3626399,3628268,3630128,3630729,3631989,3632588,3633839,3634440,3635685,3636282,3637518,3638118,3639342,3639943,3641155,3641753,3642959,3643557,3644751,3645350,3646540,3647138,3648317,3648917,3650688,3652445,3654193,3655932,3657664,3659392,3661126,3662850,3664565,3666268,3667964,3669654,3671332,3673006,3674672,3676326,3677967,3679607,3681243,3682875,3684500,3686119,3687727,3689328,3690924,3692514,3694098,3695672,3697242,3698798,3700341,3701879,3703413,3704937,3706456,3707967,3709460,3710949,3712434,3713911,3715381,3716844,3718307,3719761,3721206,3722650,3724086,3725514,3726938,3728355,3729765,3731165,3732558,3733945,3735319,3736688,3738053,3739405,3740749,3742087,3743416,3744739,3746055,3747362,3748663,3749951,3751234,3752510,3753777,3755037,3756291,3757546,3758792,3760030,3761263,3762489,3763710,3764926,3766136,3767339,3768534,3769722,3770114,3770503,3770889,3771271,3771650,3772027,3772404,3772776,3773145,3773510,3773879,3774247,3774612,3774975,3775336,3775695,3776052,3776405,3776753,3777105,3777454,3777799,3778139,3778474,3778804,3779129,3779459,3779785,3780106,3780422,3780737,3781048,3781353,3781653,3781950,3782242,3782530,3782813,3783098,3783380,3783659,3783935,3784207,3784478,3784744,3785006,3785264,3785519,3785826,3786160,3786491,3786841,3787187,3787529,3787868,3788203,3788536,3788865,3789191,3789514,3789832,3790148,3790461,3790772,3791079,3791383,3791684,3791981,3792276,3792568,3792857,3793144,3793427,3793706,3793981,3794254,3794523,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)) 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
Maria Guleghina (Soprano) - uVisitRussia
Maria Guleghina is the worlds leading dramatic soprano. Her performances are invariably rewarded with standing ovations throughout the world’s foremost opera houses. She has been described as the “Cinderella from Russia”, “Russian soprano with Verdi flowing through her veins” and “Vocal Miracle”. She is particularly noted for her interpretation of the title role in Tosca and Turandot. Her repertoire also includes the title role in Aida, Manon Lescaut, Norma, Fedora, Adriana Lecouvreur, as well as Lady Macbeth in Macbeth, Abigaille in Nabucco, Violetta in La Traviata, Leonora in Il Trovatore, Oberto and La Forza del Destino, Elvira in Ernani, Elisabetta in Don Carlo, Amelia in Simon Boccanegra, and Un Ballo in Maschera, Lucrezia in I due Foscari, Desdemona in Otello, Santuzza in Cavalleria Rusticana, Maddalena in Andrea Chenier, Lisa in Pique Dame, Odabella in Attila,Gulnara in Il Corsaro, etc.
Maria Guleghina began her professional career at the State Opera in Minsk, and a year later made her debut in La Scala as Amelia in Un Ballo in Maschera under Maestro Gavazzeni opposite Luciano Pavarotti. Her voice of great power, warmth, thrust and with immense acting ability made her a permanent and welcome guest everywhere. At La Scala she has performed in 15 new productions including Lucrezia in I due Foscari, Tosca, Fedora, Turandot, Lady Macbeth in Macbeth, Lisa in Pique Dame, Manon Lescaut, Abigaille in Nabucco, Leonora in La Forza del Destino conducted by Riccardo Muti in Tokyo. She has accompanied La Scala on two tours to Japan in 1991 and 1999. She also performed two solo recitals at this legendary theatre.
Since her 1991 debut at the Metropolitan Opera as Maddalena in a new production of Andrea Chenier opposite Luciano Pavarotti, she has performed there over 150 times as Tosca, Aida, Norma, Adriana Lecouvreur, Turandot, Santuzza in Cavalleria Rusticana, Abigaille in Nabucco, Lisa in Pique Dame, Dolly in Sly, Giorgetta in Il Tabarro and Lady Macbeth in Macbeth.
In 1991 she made her Vienna State Opera debut in Andrea Chenier and has returned to perform Lisa in Pique Dame, Tosca, Aida, Elvira in Ernani, Lady Macbeth in Macbeth, Leonora in Il Trovatore and Abigaille in Nabucco.
Before her 1995 stage debut in the Royal Opera House, Covent Garden where she performed the title role in Fedora opposite Placido Domingo, she had already performed in a critically acclaimed concert performance of Ernani at the Barbican with the Royal Opera House company. This was followed by a highly successful recital at the Wigmore Hall. Her other appearances at Covent Garden include Tosca, concert performances of Andrea Chenier, Odabella in Attila and Lady Macbeth in Macbeth.
In 1996 Maria Guleghina’s debut in Arena di Verona was as Abigaille in Nabucco where she was awarded the “Prize of Giovanni Zanatello” for a sensational debut performer. She has since performed there on numerous occasions.
In 1997 Maria Guleghina made her Paris Opera debut with the title role in Tosca and has since been seen in this theatre as Lady Macbeth in Macbeth, Abigaille in Nabucco and Odabella in Attila.
Maria Guleghina has performed solo recitals all over the world including appearances at La Scala, Gran Teatre del Liceu, Lille, Sao Paolo, Wigmore Hall, Suntory Hall, Mariinsky Theatre, Osaka, Kyoto, Hong Kong, Rome, Teatro Colon, Teatro Bellas Artes and Moscow to name a few.
Many of the productions in which she has appeared have been broadcast on the radio as well as televised. They include Tosca, Pique Dame, Andrea Chenier, Sly, Nabucco, Cavalleria Rusticana, Il Tabarro, Norma, Turandot and Macbeth from the Metropolitan Opera, Tosca, Manon Lescaut and Un Ballo in Maschera from La Scala, Attila from Paris Opera, Nabucco from the Vienna State Opera and solo recitals from Japan, Barcelona, Moscow, Berlin and Leipzig. She has numerously performed with the world’s leading singers and conductors including Luciano Pavarotti, Placido Domingo, Leo Nucci, Renato Bruson, Jose Cura and Samuel Ramey, Gianandrea Gavazzeni, Riccardo Muti, James Levine, Zubin Mehta, Valery Gergiev, Fabio Luisi and Claudio Abbado.
Ms. Guleghina is the recipient of numerous prizes and awards including Puccini Prize as Best Puccini Performer, 2001 Bellini Prize, Giovanni Zanatello Prize for her debut at the Arena di Verona, Maria Zamboni gold medal, 1999 gold medal at the Osaka Festival, the Arte e Operosita nel mondo prize from Milan, etc. For her social engagement, she has been awarded the Orden of Holy Olga, the Highest Orden of the Russian Orthodox Church by Patriarch Alexis of Russia. Ms Guleghina is the honorary board member to the International Paralympic Committee as well as a Goodwill Ambassador to Unicef. Most recently Mrs Guleghina has been bestowed the Title of "People's Artist" of North Ossetia and Alania.
Sign in to our website using your Facebook or Google+ account.
Why Do You Need Our Travel Expert
Contact our experts, and they will help you to plan your best trip to Russia, with attention to every detail!
Our Experts have been in the travel industry for many years, guarantee to offer first class customer service, excellent value for money and unbiased advice. They are standing by to find and build your dream holiday to one of the world's most fascinating destinations - Russia. Your personal Travel Expert will guide you through each stage of the travel process, from choosing a program that fits you best to support during your trip.
Just tell us your e-mail, and we'll take care of everything!
Your tour request has been received. Thank you ! We have sent you the confirmation message to [email]
Please make sure that you receive this message (sometimes e-mail messages may go to the spam/junk mail). If you did not get this message, it means you will not get message with the tours' selection as well. If you use a Yahoo!, Gmail, AOL or Hotmail, we recommend to add request@uvisitrussia.comto your address book.
We recommend to leave your phone number. If we will not heard back that you received the e-mail with the tours' selection, we will contact you by phone. And you will not miss the best tour for you.
Thank you ! Your request for Travel Expert assistance has been sent. We will e-mail you within 1 hour.
Sorry, some changes needed
Add your E-mail
There was a problem with your request
Missing contact person. Please correct and try again.