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 (589964,591584,593223,594929,596626,598311,599988,601668,603341,605003,606658,608303,609941,611625,613303,614970,616625,618267,1385246,1387050,1388844,1390624,1392393,1394153,1395931,1397697,1399454,1399781,1401206,1401535,1402948,1403277,1404681,1405010,1406404,1406732,1408125,1408452,1409849,1410189,1411576,1411916,1413326,1413685,1415086,1415445,1416836,1417192,1418571,1418930,1420298,1420657,1422015,1422374,1423718,1424077,1425407,1425766,1427081,1427440,1428745,1429104,1430395,1430754,1432035,1432394,1433666,1434025,1435282,1435641,1436887,1437248,1438508,1438869,1440116,1440477,1441717,1442079,1443311,1443673,1444895,1445257,1446471,1446830,1448035,1448394,1449587,1449946,1451127,1451486,1452657,1453016,1454177,1454536,1455686,1456054,1457188,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,1901255,1901441,1903392,1903578,1905519,1905706,1907664,1907848,1909821,1910005,1912156,1914319,1916537,1918741,1920943,1923140,1925346,1927591,1929826,1932048,1934253,1936451,1938647,1940832,1943007,1945171,1947326,1949466,1951600,1953731,1955810,1957879,1959936,1961979,1964009,1966036,1968054,1970069,1972082,1974083,1976080,1978059,1980026,1982021,1984011,1985994,1987964,1989925,1991873,1993812,1995745,1997672,1999591,2283135,2286281,2289419,2292549,2295670,2298785,2301906,2305033,2308177,2308436,2311345,2311604,2314508,2314767,2317667,2317926,2320821,2321080,2323968,2324227,2327106,2327365,2330236,2330495,2333347,2333606,2336449,2336708,2339553,2339812,2342643,2342902,2343059,2345750,2346009,2346166,2348851,2349110,2349267,2351980,2352239,2352396,2355099,2355358,2355515,2358206,2358465,2358622,2361310,2361569,2361726,2364405,2364664,2364821,2367490,2367749,2367906,2370564,2370823,2370980,2373629,2373888,2374045,2376679,2376938,2377095,2379717,2379976,2380133,2382749,2383008,2383165,2385775,2386034,2386191,2388832,2389102,2389259,2391894,2392165,2392322,2394950,2395221,2395378,2397993,2398264,2398421,2401022,2401293,2401450,2404040,2404311,2404468,2407054,2407325,2407482,2410059,2410330,2410487,2413054,2413325,2413482,2416041,2416312,2416469,2419055,2419326,2419483,2422057,2422328,2422485,2425048,2425319,2425476,2428034,2428305,2428462,2431011,2431282,2431439,2433978,2434249,2434406,2436935,2437206,2437363,2439881,2440152,2440309,2442817,2443087,2443244,2445744,2446014,2446171,2448665,2448935,2449092,2451575,2451845,2452002,2454466,2454738,2454895,2457350,2457622,2457779,2460229,2460501,2460658,2463093,2463365,2463522,2465948,2466220,2466377,2468826,2469098,2469255,2471764,2472036,2472193,2474678,2474950,2475107,2477621,2477893,2478050,2480553,2480825,2480982,2483471,2483743,2483900,2486379,2486651,2486808,2489282,2489597,2489754,2492215,2492530,2492687,2495139,2495455,2495612,2498053,2498369,2498526,2500954,2501270,2501427,2503842,2504158,2504315,2506718,2507034,2507191,2509584,2509900,2510057,2512446,2512762,2512919,2515303,2515619,2515776,2518154,2518470,2518627,2520997,2521313,2521470,2523829,2524145,2524302,2526649,2526965,2527122,2529462,2529778,2529935,2532270,2532586,2532743,2535071,2535387,2535544,2537866,2538182,2538339,2540660,2540976,2541133,2543444,2543760,2543917,2546217,2546533,2546690,2548983,2549299,2549456,2551788,2552104,2552261,2554584,2554900,2555057,2557395,2557711,2557868,2560198,2560514,2560671,2562987,2563303,2563460,2565763,2566080,2566237,2568529,2568886,2569043,2571360,2571717,2571874,2574182,2574539,2574696,2576996,2577353,2577510,2579805,2580166,2580323,2582602,2582963,2583120,2585384,2585745,2585902,2588155,2588516,2588673,2590923,2591284,2591441,2593682,2594043,2594200,2596433,2596794,2596951,2599175,2599536,2599693,2601904,2602265,2602422,2604620,2604981,2605138,2607327,2607688,2607845,2610030,2610391,2610548,2612724,2613115,2613284,2615448,2615839,2616008,2618165,2618556,2618725,2620872,2621263,2621432,2623564,2623955,2624124,2626245,2626636,2626805,2628926,2629316,2629485,2631591,2631981,2632150,2634258,2634648,2634817,2636904,2637296,2637465,2639538,2639930,2640099,2642159,2642551,2642720,2644768,2645164,2645333,2647369,2647765,2647934,2649957,2650353,2650522,2652536,2652932,2653101,2655103,2655499,2655668,2657655,2658051,2658220,2660189,2660585,2660754,2662704,2663100,2663269,2665205,2665601,2665770,2667692,2668088,2668257,2670155,2670551,2670720,2672606,2673002,2673171,2675037,2675433,2675602,2677449,2677845,2678014,2679841,2680237,2680406,2682217,2682613,2682782,2684584,2684980,2685149,2686946,2687339,2687511,2689301,2689693,2689865,2691645,2692037,2692209,2693973,2694365,2694537,2696314,2696797,2697022,2699397,2699882,2700102,2702467,2702965,2703184,2705543,2706040,2706262,2708590,2709087,2709309,2711633,2712130,2712352,2714664,2715160,2715382,2717684,2718181,2718449,2721246,2721528,2724354,2724636,2727453,2727735,2730540,2730822,2733655,2733938,2736758,2737034,2739845,2740121,2742923,2743199,2745983,2746259,2749024,2749300,2752053,2752329,2755080,2755356,2758100,2758376,2761125,2761398,2764140,2764413,2767139,2767412,2770123,2770396,2773096,2773369,2776061,2776334,2779050,2779323,2782031,2782327,2785119,2785415,2788205,2788501,2791275,2791571,2794333,2794629,2797408,2797704,2800470,2800767,2803525,2803822,2806499,2806796,2809455,2809752,2812389,2812686,2815311,2815608,2818294,2818591,2821270,2821567,2824242,2824539,2827218,2827515,2830177,2830474,2833119,2833416,2836046,2836343,2838980,2839277,2841904,2842201,2850478,2850782,2863115,2863415,2865892,2866192,2880961,2881266,2883733,2884038,2886491,2886790,2889226,2889525,2891949,2892248,2894652,2894951,2897341,2897640,2900038,2900337,2902729,2903028,2905313,2905612,2907905,2908204,2910522,2910821,2913120,2913419,2915708,2916007,2918298,2918597,2920871,2921170,2923436,2923735,2925991,2926289,2928527,2928825,2931046,2931344,2933554,2933852,2936054,2936352,2938562,2938860,2941065,2941363,2943559,2943857,2946037,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)) 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
State Symphony Capella of Russia (Orchestra) - uVisitRussia
Music Director and
Chief Conductor—
Valeri Polyansky.
The State Symphony Capella of Russia was founded in 1991 as a result of merger of USSR State Chamber Choir under Valeri Polyansky and State Symphony Orchestra of USSR Ministry of Culture headed by Gennady Rozhdestvensky. The Capella’s first performance with Dvorak’s cantata “The Wedding Shirts” under Rozhdestvensky, held on December 27th, 1991 in the Grand Hall of Moscow Conservatoire, had an outstanding success as if setting from the very beginning the creative level of the collective and determining its professional class. In 1992 Valeri Polyansky became a new artistic director and a chief conductor of the troupe. Polyanky’s Symphony Capella consists of two musical bodies which being in organic unity work out a creative autonomy (concert programs, recordings, tour plans of their own). Due to its special structure, the Capella has the opportunity to refer to many wonderful models of classical music—masses and oratorios, requiems and cantatas—which are to be performed by soloists, choir and orchestra. In the Capella’s programs there are such masterpieces of the world musical culture as Masses by Mozart and Schubert, Bruckner and Liszt, Requiems by Verdi, Cherubini, Brahms, Mozart, Dvorak, Britten, Schnittke, Rachmaninov’s Bells, Stravinsky’s Wedding, etc. A whole series of works were actually recovered by Polyansky from scenic oblivion.
The Symphony Orchestra has its own prehistory, first appearing in 1957 and directed in turn by S.Samosud, Y.Aranovich, M.Shostakovich, G.Rozhdestvensky. When headed the Capella in 1992, Valeri Polyansky knew how to fascinate musicians by those perspectives which were opened due to the merger with choir. Common work of orchestra and choir is alternated by its’ separate concert performances. The repertoire of the orchestra covers in general a few centuries of Russian and international music. Despite this, there is a constant replenishment in the concert programs with new works. At the same time the orchestra of Valeri Polyansky rangs among the finest Russian symphonic collectives. The orchestra is a frequent and desired guest in many countries worldwide. In these last years the tours of the orchestra have had a great success in USA and Europe.
Flexibility of phrasing, rich and warm sounding, nobility of expression, skillfully balanced sounding of orchestral groups, richness and fineness of nuancing. Another aspect marked in reviews is a close creative unity and mutual understanding between orchestra and conductor.
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.