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 (732009,732028,732993,733013,733980,733999,734962,734981,735937,735954,736917,736931,737885,737899,738844,738859,739796,739812,741766,741783,743742,743759,745711,745728,747673,747693,749657,749677,751639,751659,753621,753641,756497,756517,759366,759387,762233,762254,765096,765117,767952,767973,770801,770822,773644,773664,776481,776501,779314,779334,782150,782170,784983,785003,787811,787831,790639,790655,793459,793475,796266,796281,799073,799088,801876,801891,804673,804689,807466,807481,810253,810268,813034,813049,815810,815825,818581,818596,821344,821360,824100,824116,826849,826865,829592,829609,832334,832349,835067,835084,837796,837813,840523,840540,843246,843262,845991,846007,848727,848743,851458,851474,854190,854207,856918,856936,859640,859658,862357,862375,865069,865082,867776,870460,873143,875826,902641,905269,907885,910499,913110,915742,918445,921138,923817,926513,929230,931939,934646,937351,940082,942800,945505,948207,950913,953612,956302,958979,1006294,1008861,1011420,1014000,1016561,1019111,1021658,1024194,1024203,1026729,1026738,1029259,1029268,1031674,1031784,1031793,1034178,1034287,1034296,1036668,1036777,1036786,1039157,1039266,1039274,1039298,1041641,1041750,1041758,1041782,1044117,1044226,1044234,1044258,1046584,1046693,1046705,1046725,1049041,1049150,1049162,1049182,1051485,1051594,1051605,1051626,1053915,1054024,1054035,1054056,1056342,1056451,1056462,1056483,1058764,1058874,1058884,1058905,1061173,1061282,1061293,1061314,1063574,1063683,1063694,1063715,1065967,1066077,1066088,1066109,1068348,1068459,1068470,1068491,1070718,1070829,1070840,1070861,1073118,1073229,1073240,1073261,1075511,1075622,1075633,1075654,1077894,1078005,1078015,1078037,1080376,1080386,1080408,1082736,1082746,1082768,1085081,1085089,1085113,1087410,1087422,1087443,1089729,1089739,1089761,1092059,1092068,1092091,1094381,1094390,1094413,1096691,1096703,1096724,1098987,1098999,1099021,1101264,1101276,1101298,1103535,1103547,1103569,1105787,1105796,1105819,1108014,1108024,1108047,1110221,1110231,1110254,1112408,1112417,1112441,1114576,1114585,1114609,1116728,1116738,1116760,1118864,1118873,1118896,1121004,1121026,1123144,1123167,1125280,1125300,1127491,1129712,1131916,1134107,1256683,1258648,1260603,1262545,1264472,1266395,1268320,1270234,1272138,1274031,1275907,1277766,1279621,1281470,1283310,1285140,1286961,1288763,1290544,1292356,1294163,1295962,1297758,1299539,1301305,1303051,1304805,1306544,1308279,1310003,1311725,1313648,1315581,1317515,1317648,1319438,1319571,1321347,1321487,1323256,1323389,1325148,1325288,1327023,1327163,1329023,1330879,1332761,1334634,1336500,1338353,1340190,1342012,1343824,1345631,1347436,1349228,1351010,1352907,1354799,1354846,1355106,1356674,1356721,1356981,1358536,1358585,1358850,1360394,1360441,1360706,1362242,1362287,1362554,1364080,1364124,1364394,1365903,1365949,1366218,1367714,1367760,1367823,1368030,1369521,1369566,1369629,1369836,1371321,1371366,1371427,1371636,1373107,1373158,1373213,1373421,1374882,1374933,1374989,1375196,1376786,1376841,1377048,1378620,1378675,1378882,1380440,1380495,1380702,1382254,1382309,1382517,1384068,1384123,1384331,1385876,1385931,1386139,1387676,1387730,1387939,1389465,1389523,1389732,1391297,1391506,1393060,1393269,1394839,1395046,1396608,1396817,1398368,1398577,1400117,1400326,1401867,1402076,1403604,1403812,1405330,1405538,1407053,1407261,1408989,1410719,1412443,1414206,1415959,1417700,1419430,1421150,1422865,1424560,1426242,1427910,1429567,1431209,1432845,1434467,1436077,1437706,1439320,1440922,1442517,1444108,1445692,1447261,1448820,1450364,1451897,1453418,1454933,1456438,1457936,1459423,1460895,1462358,1483432,1483449,1484781,1484796,1486119,1486133,1487448,1487462,1488765,1488779,1488863,1490064,1490080,1490165,1491354,1491370,1491455,1492636,1492652,1492754,1493947,1493964,1494066,1495248,1495263,1495367,1496540,1496556,1496658,1497833,1497849,1497951,1499131,1499147,1499249,1500419,1500435,1500537,1501697,1501714,1501816,1502969,1502985,1503087,1504231,1504248,1504350,1505491,1505507,1505609,1506740,1506756,1506858,1507982,1507998,1508100,1509212,1509233,1509330,1510439,1510455,1510557,1511668,1511684,1511786,1512890,1512906,1513009,1514113,1514134,1514232,1515340,1515361,1515459,1516559,1516580,1516678,1517771,1517787,1517890,1518973,1518989,1519092,1520171,1520192,1520289,1521366,1521382,1521485,1522553,1522569,1522672,1523732,1523748,1523851,1524904,1524920,1525023,1526070,1526088,1526190,1527227,1527243,1527346,1528379,1528395,1528498,1529526,1529542,1529645,1530669,1530685,1530788,1531808,1531824,1531927,1532942,1532958,1533061,1534072,1534088,1534191,1535198,1535214,1535317,1536319,1536335,1536438,1537435,1537451,1537554,1538575,1538591,1538694,1539708,1539724,1539827,1540837,1540852,1540954,1541959,1541974,1542076,1543074,1543090,1543193,1544181,1544197,1544300,1545283,1545299,1545402,1546375,1546391,1546494,1547455,1547471,1547574,1548523,1548539,1548642,1549581,1549601,1549698,1550632,1550653,1550751,1551695,1551795,1552740,1552840,1553781,1553882,1554814,1554916,1555939,1556949,1557962,1558967,1559961,1561314,1563008,1564844,1566671,1569311,1572209,1575094,1577971,1580838,1583691,1586530,1589366,1592194,1595019,1597893,1600757,1677047,1679889,1682724,1685542,1688400,1691258,1694029,1696793,1699550,1702299,1705038,1707811,1710577,1713339,1716118,1718888,1721641,1724383,1727122,1729854,1732565,1735269,1737964,1740649,1802484,1802538,1804922,1804975,1807343,1807396,1809746,1809797,1812127,1812178,1814485,1814533,1816831,1816879,1819152,1819201,1821449,1821502,1823721,1823774,1825969,1826021,1828193,1828245,1830395,1830447,1832583,1832635,1834784,1834834,1836975,1837026,1839159,1839209,1841377,1843531,1845671,1847824,1849976,1852122,1854262,1856404,1858531,1860647,1862762,1864873,2105010,2106960,2108899,2110828,2112750,2112764,2114655,2114669,2116553,2116570,2118445,2118461,2120325,2120342,2122212,2124072,2125918,2197102,2197128,2197524,2197547,2198628,2198656,2199050,2199072,2200152,2200183,2200584,2200606,2201674,2201705,2202138,2202161,2203212,2203241,2203679,2203702,2204743,2204772,2205209,2205232,2206266,2206298,2206738,2206760,2207794,2207825,2208264,2208287,2209309,2209340,2209779,2209802,2210812,2210844,2211283,2211306,2212305,2212336,2212819,2212857,2214006,2214036,2214519,2214557,2215692,2215723,2216208,2216246,2217376,2217406,2217890,2217933,2219156,2219185,2219728,2219800,2221388,2221423,2221963,2222035,2223617,2223646,2224190,2224262,2225830,2225859,2226403,2226475,2228031,2228061,2228605,2228676,2230220,2230249,2230794,2230866,2232399,2232430,2232973,2233045,2234817,2234846,2235390,2235462,2237436,2237470,2238012,2238083,2240348,2240382,2240923,2240994,2243524,2243558,2244099,2244171,2246692,2246726,2247267,2247338,2249851,2249880,2250424,2250497,2252998,2253028,2253571,2253644,2256136,2256169,2256712,2256784,2259267,2259296,2259842,2259915,2262388,2262416,2262963,2263035,2265500,2265529,2266075,2266147,2268602,2268631,2269177,2269249,2271695,2271722,2272269,2272341,2274807,2274834,2275382,2275454,2277952,2277979,2278527,2278598,2281089,2281115,2281662,2281735,2284237,2284268,2284812,2284884,2287381,2287407,2287954,2288027,2290514,2290540,2291087,2291160,2293638,2293665,2294213,2294284,2296758,2296789,2297331,2297404,2299879,2299910,2300455,2300517,2300527,2303010,2303042,2303584,2303647,2303657,2306157,2306185,2306733,2306793,2306805,2309326,2309354,2309902,2309962,2309974,2312491,2312518,2313065,2313127,2313139,2315652,2315680,2316227,2316288,2316300,2318809,2318837,2319384,2319444,2319456,2321956,2321989,2322535,2322595,2322605,2325103,2325131,2325674,2325736,2325748,2328237,2328265,2328809,2328870,2328882,2331363,2331392,2331925,2331986,2331998,2334470,2334497,2335031,2335093,2335105,2337568,2337600,2338130,2338192,2338203,2340668,2340697,2341229,2341290,2341302,2343777,2343805,2344339,2344401,2344413,2346882,2346909,2347442,2347505,2347516,2349979,2350006,2350544,2350607,2350618,2353102,2353130,2353670,2353732,2353744,2356217,2356246,2356785,2356846,2356857,2359320,2359349,2359888,2359949,2359960,2362419,2362448,2362987,2363048,2363059,2365538,2366077,2366138,2366149,2368621,2369153,2369216,2369225,2371691,2372222,2372286,2372295,2374747,2375283,2375344,2375354,2377791,2378327,2378388,2378398,2380826,2381359,2381423,2381431,2383854,2384390,2384452,2384462,2387410,2387470,2387480,2390474,2390534,2390545,2393534,2393595,2393606,2396586,2396647,2396657,2399622,2399682,2399692,2402641,2402705,2402713,2405656,2405719,2405727,2408667,2408728,2408738,2411668,2411730,2411740,2414658,2414722,2414730,2417680,2417743,2417752,2420688,2420751,2420761,2423684,2423744,2423754,2426674,2426735,2426745,2429657,2429718,2429728,2432629,2432689,2432699,2435592,2435652,2435663,2438544,2438604,2438614,2441482,2441545,2441553,2444410,2444473,2444481,2447334,2447397,2447405,2450249,2450310,2450320,2453155,2453216,2453226,2456043,2456104,2456114,2458930,2458992,2459003,2461802,2461865,2461875,2464657,2464721,2464729,2467528,2467597,2467607,2470432,2470519,2470530,2473349,2473434,2473448,2476296,2476384,2476395,2479236,2479323,2479334,2482160,2482247,2482258,2485070,2485157,2485168,2487976,2488063,2488074,2490913,2491001,2491012,2493841,2493926,2493940,2496761,2496849,2496860,2499672,2499757,2499772,2502567,2502652,2502666,2505446,2505534,2505545,2508316,2508399,2508415,2511175,2511263,2511275,2514035,2514123,2514135,2516889,2516977,2516989,2519738,2519823,2519838,2522579,2522662,2522677,2525406,2525489,2525504,2528218,2528306,2528318,2531031,2531115,2531130,2533836,2533919,2533933,2536632,2536717,2536731,2539431,2539514,2539529,2542221,2542305,2542320,2545002,2545087,2545100,2547768,2547851,2547865,2550573,2550660,2550674,2553373,2553460,2553474,2556188,2556273,2556289,2558995,2559082,2559097,2561795,2561882,2561896,2564578,2564664,2564678,2567348,2567433,2567448,2570183,2570270,2570282,2573012,2573096,2573111,2575831,2575916,2575930,2578641,2578725,2578740,2581449,2581534,2581549,2584239,2584324,2584339,2587012,2587101,2587112,2589782,2589868,2589883,2592546,2592634,2592646,2595300,2595387,2595400,2598048,2598131,2598147,2600784,2600869,2600885,2603507,2603595,2603608,2606217,2606302,2606317,2608920,2609008,2609021,2611620,2611705,2611721,2614348,2614433,2614448,2617067,2617153,2617168,2619781,2619870,2619882,2622483,2622571,2622585,2625169,2625254,2625270,2627853,2627938,2627954,2630523,2630611,2630625,2633192,2633282,2633298,2635844,2635935,2635951,2638487,2638578,2638594,2641116,2641209,2641223,2643732,2643824,2643841,2646341,2646433,2646450,2648938,2649029,2649047,2651524,2651615,2651632,2654099,2654191,2654207,2656665,2656756,2656771,2659212,2659303,2659318,2661738,2661832,2661845,2664247,2664338,2664353,2666743,2666834,2666851,2669218,2669313,2669326,2671672,2671775,2671789,2674117,2674218,2674234,2676539,2676642,2676655,2678944,2679045,2679059,2681328,2681427,2681442,2683700,2683798,2683814,2686064,2686166,2686178,2688424,2688522,2688538,2690775,2690873,2690889,2693112,2693211,2693226,2695432,2695535,2695546,2698162,2698292,2698310,2701236,2701366,2701384,2704318,2704448,2704466,2707390,2707520,2707538,2710433,2710564,2710582,2713473,2713604,2713621,2716497,2716626,2716643,2719563,2719696,2719713,2722651,2722814,2722831,2725752,2725916,2725934,2728841,2729005,2729023,2731927,2732100,2732123,2732166,2735037,2735210,2735233,2735276,2738128,2738301,2738324,2738367,2741210,2741383,2741406,2741449,2744282,2744455,2744478,2744521,2747333,2747506,2747529,2747572,2750363,2750536,2750559,2750602,2753390,2753563,2753586,2753629,2756418,2756591,2756614,2756657,2759431,2759605,2759632,2759678,2762446,2762620,2762648,2762696,2765455,2765629,2765657,2765705,2768445,2768619,2768647,2768695,2771419,2771593,2771621,2771669,2774389,2774563,2774591,2774639,2777348,2777522,2777551,2777602,2780332,2780506,2780535,2780586,2783357,2783531,2783562,2783615,2786438,2786612,2786643,2786696,2789517,2789691,2789722,2789775,2792576,2792750,2792781,2792834,2795632,2795806,2795838,2795892,2798701,2798875,2798907,2798961,2801760,2801934,2801966,2802020,2804810,2804984,2805016,2805070,2807777,2807951,2807983,2808037,2810721,2810895,2810927,2810981,2813645,2813819,2813851,2813905,2816561,2816735,2816767,2816821,2819541,2819716,2819748,2819802,2822511,2822686,2822718,2822772,2825493,2825668,2825700,2825754,2828462,2828637,2828669,2828723,2831413,2831588,2831620,2831674,2834343,2834518,2834550,2834604,2837266,2837441,2837473,2837527,2840193,2840369,2840401,2840455,2843110,2843287,2843319,2843373,2844549,2844726,2844758,2844812,2846154,2846186,2846240,2847573,2847605,2847659,2848981,2849013,2849067,2851835,2851867,2851921,2853255,2853287,2853341,2854668,2854700,2854754,2856078,2856110,2856164,2857481,2857513,2857567,2858877,2858909,2858963,2860264,2860296,2860350,2861640,2861672,2861726,2864416,2864448,2864502,2867193,2867225,2867279,2868566,2868598,2868652,2869945,2869977,2870031,2871321,2871353,2871407,2872692,2872724,2872778,2874057,2874089,2874143,2875414,2875446,2875500,2876760,2876792,2876846,2878108,2878135,2878189,2879480,2879507,2879561,2882256,2882283,2882337,2885021,2885048,2885102,2887762,2887789,2887843,2890490,2890517,2890571,2893204,2893231,2893285,2895896,2895923,2895977,2898581,2898608,2898662,2901307,2901361,2903991,2904045,2906570,2906624,2909156,2909210,2911819,2914410,2916995,2919576,2922143,2924701,2927248,2929776,3022134,3023606,3025072,3026522,3027958,3029397,3030824,3030838,3032237,3032253,3033643,3033662,3035234,3035251,3036816,3036833,3038385,3038402,3039962,3041512,3043056,3132680,3134320,3135960,3137593,3139214,3140826,3142430,3144024,3145614,3147194,3147830,3148460,3149084,3149708,3151255,3152794,3154327,3155850,3157366,3158873,3160367,3161852,3163329,3164801,3166264,3167695,3169089,3170474,3171851,3173222,3174587,3175989,3177323,3177387,3177703,3177740,3178713,3178777,3179099,3179150,3180185,3180249,3180571,3180622,3181653,3181717,3182039,3182090,3183119,3183183,3183498,3183538,3184582,3184646,3184963,3185003,3186043,3186107,3186424,3186464,3187500,3187564,3187881,3187921,3188951,3189015,3189332,3189372,3190397,3190454,3190777,3190817,3191835,3191895,3192218,3192258,3193273,3193334,3193695,3193782,3194965,3194981,3195024,3195386,3195472,3196747,3196767,3196809,3197172,3197258,3198723,3198740,3198787,3199147,3199232,3200690,3200709,3200751,3201073,3201113,3202390,3202407,3202448,3202771,3202811,3204081,3204101,3204142,3204464,3204504,3205773,3205789,3205837,3206154,3206194,3207459,3207478,3207522,3207841,3207881,3209139,3209156,3209202,3209521,3209561,3210812,3210831,3210876,3211194,3211234,3212530,3212549,3212594,3212913,3212953,3214234,3214254,3214297,3214617,3214657,3215930,3215946,3215987,3216313,3216353,3217622,3217641,3217683,3218007,3218047,3219311,3219327,3219369,3219695,3219735,3220989,3221008,3221051,3221374,3221414,3222655,3222675,3222717,3223047,3223089,3224338,3224382,3224712,3224756,3225968,3226015,3226341,3226385,3227584,3227629,3227957,3228001,3229201,3229244,3229574,3229618,3230868,3231197,3231241,3232484,3232813,3232857,3234090,3234422,3234466,3235689,3236021,3236065,3237273,3237605,3237649,3238848,3239175,3239219,3240410,3240742,3240786,3242017,3242345,3242389,3243612,3243936,3243980,3245193,3245518,3245562,3246792,3247120,3247164,3248379,3248706,3248750,3250276,3250320,3251841,3251885,3253444,3253488,3255128,3255235,3257138,3257247,3259149,3259257,3261147,3261255,3263129,3263236,3265109,3265217,3267103,3267208,3269106,3269260,3271194,3271351,3273320,3273477,3275430,3275587,3277523,3277680,3279615,3279770,3281749,3281904,3283470,3283678,3283702,3283876,3284033,3285589,3285794,3285823,3285999,3286153,3287738,3287946,3287972,3288147,3288302,3289873,3290080,3290107,3290282,3290436,3291990,3292198,3292222,3292396,3292553,3294093,3294298,3294327,3294503,3294658,3296194,3296401,3296428,3296601,3296757,3298287,3298495,3298520,3298694,3298851,3300370,3300576,3300607,3300780,3300935,3302448,3302650,3302681,3302857,3303012,3304509,3304717,3304745,3304919,3305075,3306559,3306766,3306794,3306969,3307124,3308604,3308811,3308841,3309015,3309170,3310646,3310853,3310880,3311056,3311210,3312679,3312888,3312911,3313083,3313239,3314901,3314931,3315103,3315257,3316918,3316942,3317114,3317268,3318918,3318943,3319116,3319270,3320900,3320930,3321102,3321258,3322885,3322915,3323087,3323243,3325034,3325062,3325234,3325389,3327308,3327333,3327506,3327660,3329693,3329720,3329893,3330048,3332071,3332103,3332276,3332429,3334437,3334467,3334642,3334795,3336795,3336819,3336993,3337147,3339138,3339168,3339342,3339497,3341480,3341511,3341686,3341839,3343818,3343850,3344021,3344176,3346179,3346207,3346380,3346534,3348527,3348559,3348731,3348886,3350868,3350894,3351069,3351223,3353186,3353219,3353390,3353546,3355512,3355536,3355710,3355865,3357835,3357867,3357975,3358058,3358215,3360182,3360212,3360320,3360403,3360577,3362544,3362575,3362683,3362765,3362939,3364898,3364928,3365035,3365119,3365294,3367238,3367267,3367377,3367460,3367633,3369570,3369598,3369706,3369789,3369964,3371897,3371924,3372032,3372115,3372289,3374216,3374241,3374351,3374431,3374607,3376524,3376554,3376661,3376745,3376919,3378833,3378859,3378969,3379049,3379224,3381130,3381157,3381265,3381347,3381522,3383400,3383426,3383533,3383617,3383791,3385680,3385711,3385817,3385901,3386075,3387949,3387979,3388088,3388168,3388345,3390209,3390238,3390345,3390428,3390604,3392463,3392490,3392596,3392680,3392854,3394700,3394727,3394836,3394917,3395091,3396923,3396949,3397056,3397140,3397313,3399135,3399162,3399273,3399355,3399529,3401333,3401364,3401473,3401557,3401731,3403526,3403556,3403665,3403746,3403921,3405708,3405735,3405844,3405927,3406102,3407872,3407905,3408012,3408094,3408288,3410038,3410069,3410178,3410259,3410453,3412188,3412213,3412321,3412404,3412598,3414351,3414380,3414491,3414574,3414766,3416497,3416528,3416636,3416721,3416914,3418638,3418669,3418777,3418862,3419055,3420766,3420791,3420898,3420984,3421177,3422861,3422894,3423000,3423086,3423278,3424975,3425082,3425167,3425360,3427034,3427140,3427226,3427419,3429075,3429184,3429267,3429462,3431100,3431209,3431292,3431486,3433112,3433221,3433302,3433497,3435224,3435306,3435500,3437218,3437302,3437495,3439201,3439283,3439476,3441165,3441249,3441441,3443129,3443210,3443404,3445103,3445184,3445379,3447257,3447340,3447532,3449403,3449485,3449678,3451544,3451624,3451819,3453675,3453756,3453951,3455794,3455876,3456070,3457920,3457999,3458195,3460046,3460124,3460327,3462182,3462262,3462463,3464307,3464386,3464589,3466456,3466538,3466738,3468635,3468716,3468917,3470804,3470885,3471085,3472960,3473041,3473241,3475117,3475196,3475397,3477268,3477348,3477550,3479413,3479494,3479697,3481553,3481633,3481830,3483683,3483766,3483963,3485808,3485888,3486085,3487918,3487997,3488195,3490025,3490105,3490248,3490323,3492153,3492235,3492377,3492450,3494356,3494498,3494573,3496472,3496617,3496689,3498625,3498769,3498840,3500770,3500913,3500985,3502904,3503049,3503120,3505036,3505180,3505250,3507160,3507303,3507378,3509282,3509426,3509497,3511396,3511540,3511610,3513502,3513648,3513719,3515599,3515742,3515816,3517687,3517832,3517905,3519775,3519916,3519991,3521853,3521995,3522068,3523922,3524067,3524138,3525984,3526127,3526199,3528035,3528178,3528251,3530096,3530240,3530312,3532141,3532284,3532356,3534180,3534323,3534396,3536219,3536362,3536436,3538250,3538335,3538394,3538465,3540357,3540414,3540489,3542430,3542486,3542557,3544483,3544543,3544615,3546525,3546582,3546657,3548564,3548620,3548694,3550594,3550654,3550724,3552634,3552693,3552766,3554668,3554729,3554801,3556710,3556766,3556840,3558733,3558790,3558864,3560747,3560802,3560875,3562749,3562807,3562880,3564753,3564809,3564880,3566768,3566827,3566900,3568781,3568838,3568912,3570800,3570858,3570930,3571056,3572810,3572866,3572938,3573065,3574823,3574878,3574953,3575078,3576731,3576787,3576860,3576985,3578630,3578689,3578762,3578890,3580530,3580587,3580662,3580789,3582426,3582472,3582526,3582650,3584286,3584330,3584385,3584512,3586187,3586244,3586366,3588041,3588096,3588222,3589894,3589949,3590072,3591743,3591798,3591922,3593587,3593642,3593769,3595548,3595621,3595752,3597540,3597613,3597743,3599517,3599590,3599717,3601474,3601549,3601679,3603425,3603497,3603628,3605362,3605435,3605564,3607285,3607363,3607491,3609207,3609281,3609408,3611189,3611315,3613084,3613215,3615006,3615134,3616922,3617049,3617490,3618831,3618960,3619399,3620731,3620857,3621303,3622630,3622757,3623202,3624520,3624651,3625092,3626399,3626529,3626972,3628268,3628396,3628838,3630128,3630256,3630700,3631989,3632115,3632559,3633839,3633967,3634413,3635685,3635812,3636254,3637518,3637648,3638090,3639342,3639470,3639914,3641155,3641283,3641724,3642959,3643086,3643528,3644751,3644880,3645323,3646540,3646667,3647110,3648317,3648445,3648888,3650218,3650659,3651975,3652418,3653721,3654165,3655461,3655906,3657194,3657636,3658914,3659365,3660637,3661094,3662360,3662821,3664077,3664533,3665779,3666238,3667475,3667934,3669164,3669621,3670841,3671300,3672515,3672975,3674182,3674639,3675836,3676295,3677480,3677936,3679117,3679576,3680752,3681211,3682384,3682841,3684007,3684466,3685625,3686085,3687235,3687694,3688837,3689294,3690431,3690890,3692023,3692481,3693606,3694064,3695179,3695639,3696752,3697210,3698304,3698764,3699850,3700308,3701389,3701848,3702922,3703379,3704905,3706424,3707935,3709429,3710918,3712402,3713879,3715348,3716813,3718275,3719729,3721175,3722617,3724052,3725483,3726905,3728321,3729732,3731133,3732526,3733913,3735287,3736656,3738019,3739373,3740718,3742056,3743384,3744707,3746023,3747330,3748630,3749919,3751202,3752479,3753744,3755005,3756258,3757513,3758758,3759998,3761231,3762457,3763676,3764894,3766104,3767306,3768501,3769688,3770082,3770471,3770856,3771237,3771618,3771995,3772370,3772744,3773111,3773478,3773847,3774214,3774579,3774942,3775303,3775662,3776019,3776372,3776720,3777072,3777421,3777766,3778106,3778441,3778771,3779096,3779426,3779752,3780073,3780389,3780704,3781015,3781320,3781620,3781917,3782209,3782497,3782780,3783065,3783347,3783626,3783902,3784174,3784445,3784711,3784973,3785231,3785486,3785779,3786113,3786444,3786794,3787140,3787482,3787821,3788156,3788489,3788818,3789144,3789467,3789785,3790101,3790414,3790725,3791032,3791336,3791637,3791934,3792229,3792521,3792810,3793097,3793380,3793659,3793934,3794207,3794476,3794742,3795006,3795268,3795527,3795781,3796048,3796313,3796575,3796834,3797089,3797339,3797583,3797825,3798063,3798298,3798530,3798761,3798987,3799207,3799426,3799642,3799856,3800067,3800276,3800481,3800684,3800886,3801086,3801283,3801477,3801668,3801854,3802032,3802209,3802384,3802556,3802725,3802892,3803055,3803211,3803372,3803535,3803696,3803854,3804009,3804159,3804303,3804446,3804585,3804720,3804851,3804979,3836771,3837030,3837287,3837544,3837797,3838053,3838310,3838562,3838816,3839069,3839319,3839567,3839811,3840053,3840291,3840546,3840829,3841108,3841383,3841655,3841922,3842184,3842444,3842711,3842976,3843239,3843497,3843751,3844002,3844259,3844514,3860821,3861618,3862408,3863200,3863987,3864769,3865549,3866326,3867105,3867874,3868645,3869412,3870179,3870942,3871701,3873187,3873943,3874698,3875445,3876197,3876943,3877685,3878430,3879168,3879912,3880653,3881396,3882141,3882879,3883620,3884364,3885100,3885835,3886574,3887306,3888040,3888769,3889501,3890226,3890948,3891670,3892384,3893102,3893815,3894532,3895251,3907316,3908005,3908691,3909374,3910055,3910744,3911430,3912115,3912797,3953328,3953943,3954558,3955167,3955775,3956373,3956998,3963666,3964239,3964810,3965378,3965961)) ORDER BY date ASC, ves DESC, time ASC LIMIT 10
ERROR: (#1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'offset, tt.address FROM U_ticketsTmp tmp LEFT JOIN ticket_theatre tt ON tt.id...' at line 1





	Vladimir Galuzin (Tenor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Vladimir Galuzin (Tenor)
			

																
Vladimir Galuzin (Tenor)

														
				


        




    

        Vladimir Galuzin (Tenor) – recipient of the Casta Diva Russian opera prize as "Singer of the Year" for his interpretation of Herman in Tchaikovskyґs The Queen of Spades (1999).

Born in Rubtsovsk (Altai Region). Graduated from the Novosibirsk Conservatoire in 1984.
 Soloist with the Novosibirsk Theatre of Operetta from 1980 – 1988.
Soloist with the Novosibirsk Theatre of Opera and Ballet from 1988 – 1989 and subsequently with the St Petersburg Chamber Opera Company.
 Mariinsky Theatre soloist since 1990.

Guest performer at the Netherlands Opera, the Royal Opera House, Covent Garden, and the Opйra Bastille, as well as at theatres in Vienna, Florence, Milan, Salzburg, Madrid, Amsterdam, Dresden and New York.Vladimir Galuzin is a frequent guest at international festivals in Bregenz (Germany), Edinburgh (Scotland), Salzburg (Austria), Moncerrato (Spain), Verona (Italy) and Oranje (France).One of his most recent performances at the Mariinsky Theatre was as Calaf in Turandot in March 2005. Mariinsky Theatre audio and video recordings with Philips and NHK include Khovanshchina (Andrei Khovansky), Sadko (Sadko), The Fiery Angel (Agrippa of Nettesheim) and The Maid of Pskov (Mikhailo Tucha).        

    

    

            


			

		





	


	

	

		


			

				

					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