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 (20012,21447,21499,22953,24405,25890,26201,27606,30351,31832,590574,592195,593835,595540,597237,598924,600599,602281,603952,605616,607269,608914,610560,612244,613921,615588,617243,618885,620518,622145,623764,625393,627014,628625,630225,631818,633405,634983,636550,638108,639654,641190,642713,644230,645743,647245,648740,650239,651727,653208,654680,656141,657592,659047,660490,661922,663346,664763,666173,667614,669042,670483,671915,673339,674750,676152,677544,678957,680358,681750,683132,684504,685856,687196,688503,689802,691088,692364,693631,694886,696125,697351,698564,699766,700960,702151,703343,704524,705688,706838,707977,709104,710222,711370,712508,713641,714761,715870,716968,718056,719134,720200,721255,722313,723375,724427,725470,726503,727529,728546,729553,730553,731545,732532,733526,734513,735492,736459,737431,738395,739352,740301,742269,744242,746207,748168,750150,752132,755011,757884,760750,763614,766473,769325,772171,775011,777846,780677,783512,786342,789168,791990,794809,797618,800423,803224,806020,808809,811592,814371,817145,819912,822671,825423,828169,830910,833649,836381,839111,841836,844555,847294,850027,852756,855486,858211,860931,863643,866344,869034,871718,874401,877080,877501,879764,880185,882444,882867,882957,885127,885550,885640,887798,888221,888311,890462,890884,890975,893122,893546,893638,895780,896204,896296,898430,898853,898943,899042,901075,901498,901590,901687,903711,904134,904226,904323,906335,906758,906850,906947,908950,909373,909465,909562,911563,911985,912075,912174,914200,914622,914712,914811,916909,917332,917424,917519,919608,920030,920122,920219,922294,922716,922808,922905,924994,925416,925508,925604,927686,928108,928225,928322,930399,930821,930939,931036,933104,933530,933651,933747,935813,936239,936360,936456,938514,938973,939091,939188,941238,941699,941814,941914,943951,944412,944526,944627,947115,947235,947331,949825,949941,950040,952530,952645,952745,955224,955340,955439,957907,958026,958123,960568,960685,960783,963216,963333,963430,965853,965970,966068,968488,968605,968703,971120,971236,971335,973743,973859,973958,976358,976476,976573,978972,979089,979186,981570,981686,981785,984158,984273,984373,986785,986901,987001,989407,989523,989623,992022,992139,992238,994631,994747,994850,997230,997350,997448,999818,999937,1000036,1002400,1002519,1002618,1004980,1005097,1005199,1007549,1007668,1007770,1010112,1010231,1010332,1012664,1012783,1012916,1015234,1015355,1015486,1017790,1017909,1018042,1020337,1020456,1020589,1022883,1023004,1023135,1025422,1025541,1025674,1027957,1028076,1028209,1030487,1030607,1030739,1032998,1033117,1033250,1035493,1035612,1035745,1037982,1038100,1038236,1040468,1040586,1040722,1042946,1043066,1043201,1045417,1045536,1045671,1047878,1047997,1048132,1050328,1050448,1050587,1052764,1052884,1053023,1055192,1055313,1055449,1057618,1057739,1057875,1060037,1060158,1060286,1062442,1062562,1062694,1064839,1064960,1065088,1067225,1067348,1067473,1069600,1069724,1069852,1071967,1072089,1072216,1074364,1074487,1074615,1076751,1076872,1077000,1079127,1079248,1079376,1081492,1081612,1081743,1083843,1083964,1084095,1086183,1086305,1086433,1088506,1088628,1088756,1090840,1090960,1091088,1093168,1093287,1093416,1095482,1095602,1095730,1097782,1097902,1098030,1100065,1100185,1100313,1102337,1102457,1102585,1104596,1104714,1104841,1106833,1106951,1107083,1109048,1109171,1109298,1111243,1111365,1111491,1113420,1113541,1113667,1115577,1115699,1115829,1117721,1117839,1117968,1119856,1119974,1120102,1121986,1122105,1122237,1124124,1124243,1124375,1126319,1126438,1126570,1128511,1128649,1128794,1130724,1130862,1131007,1132920,1133058,1133203,1135111,1135248,1135400,1137315,1137455,1137606,1139516,1139656,1139805,1141711,1141850,1142000,1143898,1144037,1144185,1146075,1146213,1146363,1148239,1148377,1148527,1150394,1150532,1150681,1152545,1152683,1152832,1154690,1154829,1154980,1156966,1157115,1159135,1159282,1161290,1161437,1163430,1163578,1165562,1165709,1167699,1167847,1169829,1169976,1171951,1172097,1174066,1174214,1176212,1176360,1178347,1178495,1180475,1180623,1182594,1182742,1184704,1184852,1186814,1186964,1188920,1189070,1191019,1191170,1193109,1193258,1195188,1195336,1197264,1197412,1199329,1199477,1201390,1201538,1203445,1203593,1205493,1205641,1207530,1207678,1209559,1209707,1211598,1211745,1213629,1213777,1215651,1215799,1217660,1217808,1219654,1219802,1221637,1221785,1223613,1223761,1225732,1227725,1229739,1231751,1233745,1235732,1237713,1239681,1241637,1243620,1245596,1247553,1249538,1251516,1253497,1255472,1257441,1259401,1261348,1263282,1265207,1267137,1269057,1270966,1272864,1274748,1276613,1278472,1280327,1282171,1399781,1401535,1403277,1405010,1406732,1408452,1410189,1411916,1413685,1415445,1417192,1418930,1420657,1422374,1424077,1425766,1427440,1429104,1430754,1432394,1434025,1435641,1437248,1438869,1440477,1442079,1443673,1445257,1446830,1448394,1449946,1451486,1453016,1454536,1456054,1457554,1459046,1460525,1461991,1463447,1464893,1466325,1467747,1469156,1470550,1471931,1473299,1474658,1476004,1477355,1478703,1480087,1481459,1482820,1484176,1485520,1486855,1488179,1489485,1490780,1492066,1493380,1494685,1495982,1497276,1498579,1499872,1501155,1502431,1503699,1504960,1506213,1507460,1508697,1509925,1511147,1512372,1513600,1514821,1516044,1517259,1518465,1519664,1520860,1522050,1523233,1524408,1525576,1526737,1527892,1529041,1530186,1531327,1532463,1533595,1534723,1535847,1536966,1538079,1539216,1540346,1541471,1542590,1543701,1544806,1545904,1546989,1548062,1549125,1550182,1551230,1552269,1553310,1554345,1555372,1556390,1557400,1558408,1559406,1560764,1562113,1563956,1565789,1567614,1892817,1894889,1896972,1897158,1899107,1899293,1899413,1901255,1901441,1901561,1903392,1903578,1903698,1905519,1905706,1905826,1907664,1907848,1907970,1909821,1910005,1910127,1912156,1912276,1914319,1914436,1916537,1916657,1918741,1918863,1920943,1921063,1923140,1923260,1925346,1925466,1927591,1927711,1929826,1929947,1932048,1932168,1934253,1934373,1936451,1936572,1938647,1938767,1940832,1940952,1943007,1943127,1945171,1945291,1947326,1947444,1949466,1949585,1951600,1951719,1953731,1953851,1955810,1955930,1957879,1957999,1959936,1960053,1961979,1962096,1964009,1964129,1966036,1966156,1968054,1968175,1970069,1970189,1972082,1972202,1974083,1974205,1976080,1976197,1978059,1978176,1980026,1980146,1982021,1982142,1984011,1984131,1985994,1986114,1987964,1988084,1989925,1990045,1991873,1991993,1993812,1993932,1995745,1995867,1997672,1997792,1999591,1999711,2001620,2003516,2005399,2007275,2009157,2011039,2012910,2014755,2016587,2018405,2020217,2022022,2023817,2025815,2027810,2029796,2031768,2033730,2035689,2037639,2039582,2041513,2043433,2045337,2047233,2049121,2050999,2188799,2190331,2191850,2193362,2194862,2196391,2197919,2199439,2200968,2202516,2204051,2205576,2207103,2208625,2210136,2211635,2213338,2215033,2216718,2218504,2220745,2222977,2225201,2227408,2229604,2231789,2233967,2236378,2238997,2241906,2245076,2248239,2251392,2254537,2257673,2260799,2263916,2267022,2270120,2273223,2276332,2279473,2282607,2283135,2285753,2286281,2288891,2289419,2292021,2292549,2295142,2295670,2298260,2298785,2301381,2301906,2301975,2302000,2304508,2305033,2305102,2305127,2305182,2307652,2308177,2308246,2308271,2308326,2308372,2310820,2311345,2311414,2311439,2311494,2311540,2313983,2314508,2314577,2314602,2314657,2314703,2317142,2317667,2317736,2317761,2317816,2317862,2320296,2320821,2320890,2320915,2320970,2321016,2323445,2323968,2324037,2324062,2324117,2324163,2326583,2327106,2327175,2327200,2327255,2327301,2329713,2330236,2330305,2330330,2330385,2330431,2332824,2333347,2333416,2333441,2333496,2333542,2335926,2336449,2336518,2336543,2336598,2336644,2339022,2339553,2339622,2339647,2339702,2339748,2342118,2342643,2342712,2342737,2342792,2342838,2343059,2345225,2345750,2345819,2345844,2345899,2345945,2346166,2348324,2348851,2348920,2348945,2349000,2349046,2349267,2351420,2351980,2352049,2352074,2352129,2352175,2352396,2354539,2355099,2355168,2355193,2355248,2355294,2355515,2357646,2358206,2358275,2358300,2358355,2358401,2358622,2360747,2361310,2361379,2361404,2361459,2361505,2361726,2363842,2364405,2364474,2364499,2364554,2364600,2364821,2366927,2367490,2367559,2367584,2367639,2367685,2367906,2370001,2370564,2370633,2370658,2370713,2370759,2370980,2373066,2373629,2373698,2373723,2373778,2373824,2374045,2376116,2376679,2376748,2376773,2376828,2376874,2377095,2379154,2379717,2379786,2379811,2379866,2379912,2380133,2382186,2382749,2382818,2382843,2382898,2382944,2383165,2385213,2385775,2385844,2385869,2385924,2385970,2386191,2388228,2388832,2388912,2388937,2388992,2389038,2389259,2391290,2391894,2391975,2392000,2392055,2392101,2392322,2394346,2394950,2395031,2395056,2395111,2395157,2395378,2397389,2397993,2398074,2398099,2398154,2398200,2398421,2400418,2401022,2401103,2401128,2401183,2401229,2401450,2403436,2404040,2404121,2404146,2404201,2404247,2404468,2406450,2407054,2407135,2407160,2407215,2407261,2407482,2409455,2410059,2410140,2410165,2410220,2410266,2410487,2412450,2413054,2413135,2413160,2413215,2413261,2413482,2415436,2416041,2416122,2416147,2416202,2416248,2416469,2418450,2419055,2419136,2419161,2419216,2419262,2419483,2421452,2422057,2422138,2422163,2422218,2422264,2422485,2424443,2425048,2425129,2425154,2425209,2425255,2425476,2427429,2428034,2428115,2428140,2428195,2428241,2428462,2431011,2431092,2431117,2431172,2431218,2431439,2433978,2434059,2434084,2434139,2434185,2434406,2436935,2437016,2437041,2437096,2437142,2437363,2439881,2439962,2439987,2440042,2440088,2440309,2442817,2442897,2442922,2442977,2443023,2443244,2445744,2445824,2445849,2445904,2445950,2446171,2448665,2448745,2448770,2448825,2448871,2449092,2451575,2451655,2451680,2451735,2451781,2452002,2454466,2454548,2454573,2454628,2454674,2454895,2457350,2457432,2457457,2457512,2457558,2457779,2460229,2460311,2460336,2460391,2460437,2460658,2463093,2463175,2463200,2463255,2463301,2463522,2465948,2466030,2466055,2466110,2466156,2466377,2468826,2468908,2468933,2468988,2469034,2469255,2471764,2471846,2471871,2471926,2471972,2472193,2474678,2474760,2474785,2474840,2474886,2475107,2477621,2477703,2477728,2477783,2477829,2478050,2480553,2480635,2480660,2480715,2480761,2480982,2483471,2483553,2483578,2483633,2483679,2483900,2486379,2486461,2486486,2486541,2486587,2486808,2489282,2489394,2489432,2489487,2489533,2489754,2492215,2492327,2492365,2492420,2492466,2492687,2495139,2495248,2495290,2495345,2495391,2495612,2498053,2498162,2498204,2498259,2498305,2498526,2500954,2501063,2501105,2501160,2501206,2501427,2503842,2503951,2503993,2504048,2504094,2504315,2506718,2506827,2506869,2506924,2506970,2507191,2509584,2509693,2509735,2509790,2509836,2510057,2512446,2512555,2512597,2512652,2512698,2512919,2515303,2515412,2515454,2515509,2515555,2515776,2518154,2518263,2518305,2518360,2518406,2518627,2520997,2521106,2521148,2521203,2521249,2521470,2523829,2523938,2523980,2524035,2524081,2524302,2526649,2526758,2526800,2526855,2526901,2527122,2529462,2529571,2529613,2529668,2529714,2529935,2532270,2532379,2532421,2532476,2532522,2532743,2535071,2535180,2535222,2535277,2535323,2535544,2537866,2537975,2538017,2538072,2538118,2538339,2540660,2540769,2540811,2540866,2540912,2541133,2543444,2543553,2543595,2543650,2543696,2543917,2546217,2546326,2546368,2546423,2546469,2546690,2548983,2549092,2549134,2549189,2549235,2549456,2551788,2551897,2551939,2551994,2552040,2552261,2554584,2554693,2554735,2554790,2554836,2555057,2557395,2557504,2557546,2557601,2557647,2557868,2560198,2560307,2560349,2560404,2560450,2560671,2562987,2563096,2563138,2563193,2563239,2563460,2565763,2565871,2565914,2565970,2566016,2566237,2568529,2568637,2568680,2568762,2568822,2569043,2571360,2571469,2571511,2571593,2571653,2571874,2574182,2574291,2574333,2574415,2574475,2574696,2576996,2577105,2577147,2577229,2577289,2577510,2579805,2579914,2579956,2580039,2580102,2580323,2582602,2582711,2582753,2582836,2582899,2583120,2585384,2585493,2585535,2585618,2585681,2585902,2588155,2588264,2588306,2588389,2588452,2588673,2590923,2591032,2591074,2591157,2591220,2591441,2593682,2593791,2593833,2593916,2593979,2594200,2596433,2596542,2596584,2596667,2596730,2596951,2599175,2599284,2599326,2599409,2599472,2599693,2601904,2602013,2602055,2602138,2602201,2602422,2604620,2604729,2604771,2604854,2604917,2605138,2607327,2607436,2607478,2607561,2607624,2607845,2610030,2610139,2610181,2610264,2610327,2610548,2612724,2612833,2612875,2612958,2613023,2613284,2615448,2615557,2615599,2615682,2615747,2616008,2618165,2618274,2618316,2618399,2618464,2618725,2620872,2620981,2621023,2621106,2621171,2621432,2623564,2623673,2623715,2623798,2623863,2624124,2626245,2626354,2626396,2626479,2626544,2626805,2628926,2629035,2629077,2629159,2629224,2629485,2631591,2631700,2631742,2631824,2631889,2632150,2634258,2634367,2634409,2634491,2634556,2634817,2636904,2637013,2637056,2637139,2637204,2637465,2639538,2639647,2639690,2639773,2639838,2640099,2642159,2642268,2642311,2642394,2642459,2642720,2644768,2644877,2644920,2645004,2645072,2645333,2647369,2647478,2647521,2647605,2647673,2647934,2649957,2650066,2650109,2650193,2650261,2650522,2652536,2652645,2652688,2652772,2652840,2653101,2655103,2655212,2655255,2655339,2655407,2655668,2657655,2657764,2657807,2657891,2657959,2658220,2660189,2660298,2660341,2660425,2660493,2660754,2662704,2662813,2662856,2662940,2663008,2663269,2665205,2665314,2665357,2665441,2665509,2665770,2667692,2667801,2667844,2667928,2667996,2668257,2670155,2670264,2670307,2670391,2670459,2670720,2672606,2672715,2672758,2672842,2672910,2673171,2675037,2675146,2675189,2675273,2675341,2675602,2677449,2677558,2677601,2677685,2677753,2678014,2679841,2679950,2679993,2680077,2680145,2680406,2682217,2682326,2682369,2682453,2682521,2682782,2684584,2684693,2684736,2684820,2684888,2685149,2686946,2687055,2687098,2687182,2687252,2687511,2689301,2689410,2689452,2689536,2689606,2689865,2691645,2691754,2691796,2691880,2691950,2692209,2693973,2694082,2694124,2694208,2694278,2694537,2696314,2696391,2696455,2696508,2696609,2696695,2697022,2699397,2699476,2699540,2699593,2699694,2699779,2700102,2702467,2702547,2702616,2702671,2702775,2702863,2703184,2705543,2705623,2705692,2705748,2705852,2705940,2706262,2708590,2708670,2708739,2708795,2708899,2708987,2709309,2711633,2711713,2711782,2711838,2711942,2712030,2712352,2714664,2714744,2714813,2714869,2714973,2715060,2715382,2717684,2717764,2717833,2717889,2717993,2718081,2718449,2720829,2720898,2720954,2721058,2721146,2721528,2723937,2724006,2724062,2724166,2724254,2724636,2727036,2727105,2727161,2727265,2727353,2727735,2730123,2730192,2730248,2730352,2730440,2730822,2733222,2733291,2733346,2733460,2733555,2733938,2736325,2736394,2736449,2736563,2736658,2737034,2739412,2739481,2739536,2739650,2739745,2740121,2742489,2742558,2742613,2742727,2742822,2743199,2745549,2745618,2745673,2745787,2745882,2746259,2748590,2748659,2748714,2748828,2748923,2749300,2751619,2751688,2751743,2751857,2751952,2752329,2754645,2754714,2754769,2754885,2754979,2755356,2757667,2757735,2757789,2757905,2757999,2758376,2760688,2760756,2760810,2760926,2761019,2761398,2763772,2763826,2763942,2764034,2764413,2766771,2766825,2766941,2767033,2767412,2769755,2769809,2769925,2770017,2770396,2772728,2772782,2772898,2772990,2773369,2775693,2775747,2775863,2775955,2776334,2778682,2778736,2778852,2778944,2779323,2781663,2781717,2781833,2781925,2782327,2784751,2784805,2784921,2785013,2785415,2787837,2787891,2788007,2788099,2788501,2790907,2790961,2791077,2791169,2791571,2793965,2794019,2794135,2794227,2794629,2797040,2797094,2797210,2797302,2797704,2800156,2800272,2800364,2800767,2803211,2803327,2803419,2803822,2806185,2806301,2806393,2806796,2809141,2809257,2809349,2809752,2812075,2812191,2812283,2812686,2814997,2815113,2815205,2815608,2817980,2818096,2818188,2818591,2820956,2821072,2821164,2821567,2823928,2824044,2824136,2824539,2827020,2827112,2827515,2829979,2830071,2830474,2832921,2833013,2833416,2835848,2835940,2836343,2838782,2838874,2839277,2841706,2841798,2842201,2850280,2850372,2850782,2862918,2863010,2863415,2865695,2865787,2866192,2880856,2881266,2883628,2884038,2886386,2886790,2889120,2889525,2891843,2892248,2894546,2894951,2897235,2897640,2899932,2900337,2902623,2903028,2905207,2905612,2908204,2910821,2913419,2916007,2918597,2921170,2923735,2926289,2928825,2931344,2933852,2936352,2938860,2941363,2943857,2946335,2948797,2951244,2953691,2956180,2958663,2961132,2963581,2966012,2968430,2970846,2973246,2975635,2978012,2980402,2982778,2985147,2987531,2989909,2992285,2994648,2996998,2999332,3001654,3003968,3006258,3008484,3010672,3012840,3014992,3017136,3019324,3021461,3022938,3024407,3025863,3027309,3028747,3030179,3031601,3033013,3034611,3036197,3037772,3039339,3040898,3042448,3043990,3045525,3047048,3048560,3050065,3051573,3053071,3054556,3056032,3057497,3058950,3060395,3123209,3124901,3126581,3128251,3129910,3131562,3133206,3134842,3136478,3138103,3139719,3141328,3142928,3144522,3146107,3150184,3151728,3153265,3154793,3156313,3157825,3159325,3160814,3162296,3163771,3165238,3166720,3168117,3169504,3170884,3172258,3173626,3174986,3176387,3177783,3179257,3180727,3182194,3183655,3185118,3186576,3188030,3189477,3190920,3192359,3194052,3195739,3197522)) 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





	Valery Polyansky (Conductor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Valery Polyansky (Conductor)
			

																
Valery Polyansky (Conductor)

														
				


        




    

        Valeri Polyansky  was born in 1949 in Moscow. After completing the musical college Polyansky enters the Moscow Conservatoire, starting his studies with professor B.I.Kulikov (choral conducting). At this time Polyanky’s interests went far beyond his basic specialty: he was attracted first of all by that special powerful musical synthesis, which appears while merging choir with orchestra. Polyansky attends simultaneously two different faculties: besides taking choral conducting he attends symphonic conducting (his teacher here was the well-known musician O.Dimitriadi). During his post-graduate course the fate brings him together with Gennady Rozhdestvensky. While being a student, Valeri Polyansky works in the Operetta Theatre, where he conducts the main repertoire. 

In 1977 he was invited as a conductor to the Bolshoi Theatre where together with Gennady Rozhdestvensky took part in the production of Shostakovich’s opera “Katerina Izmailova”. While being at the head of the State Chamber Choir, Polyansky productively worked with the leading symphonic collectives both in Russia and abroad. He repeatedly performed with orchestras of Belarus, Iceland, Finland, Taiwan, Turkey, Germany and Holland. He also conducted the Tchaikovsky’s opera “Eugene Onegin” at the Goteborg Musical Theatre in Sweden. For many years he is Chief Conductor of the Opera Nights Festival in Goteborg.



Since 1992 he is Chief Conductor and Artistic Director of the State Symphony Capella of Russia both symphonic orchestra and choir, numbering more than 200 artists. According to specialists marks, Polyansky’s creative practice is a rare example of a musician who combines skillful technique of choral and symphonic conducting.



In the repertoire of the State Symphony Capella there are works of different stylistic trends and currents: baroque, classics, romanticism, impressionism and contemporary works. And in all cases, as music critics emphasize, musicians led by Polyansky succeed in achieving accuracy and clearness of style, while remaining faithful to the spirit of the composition they perform.



Polyansky boasts a great number of musical recordings with the leading international recording labels. Among them are compositions by Tchaikovsky, Taneev, Glazunov, Skryabin, Bruckner, Dvorak, Reger, Prokofiev, Schostakovich and many others. Polyansky has also recorded all symphonic and choral compositions by S.Rachmaninov, and the 8th Symphony by A.Schnittke, issued by English firm Chandos in 2001, which was awarded “Best Recording of the Year”.
        

    

    

            


			

		





	


	

	

		


			

				

					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