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 (590027,590056,590091,590464,590497,590690,591647,591676,591711,592085,592118,592311,593286,593315,593350,593724,593757,593950,594992,595022,595054,595430,595463,595656,596689,596719,596751,597127,597160,597353,598375,598404,598437,598813,598847,599038,600051,600081,600113,600489,600522,600715,601732,601761,601794,602170,602204,602397,603404,603434,603466,603842,603875,604068,605067,605100,605128,605505,605539,605732,606721,606751,606783,607159,607192,607385,608366,608396,608428,608804,608837,609030,610004,610034,610066,610442,610481,610679,611688,611718,611750,612126,612165,612363,613366,613396,613427,613803,613842,614040,615033,615063,615094,615470,615509,615707,616688,616717,616750,617126,617165,617361,618330,618360,618391,618767,618806,619004,619963,619993,620024,620400,620439,620637,621590,621619,621652,622028,622067,622264,623209,623239,623270,623646,623685,623883,624819,624849,624880,625266,625314,625512,626440,626470,626501,626887,626935,627133,628051,628081,628112,628498,628546,628744,629651,629681,629712,630098,630146,630344,631244,631274,631305,631691,631739,631937,632831,632861,632892,633278,633326,633524,634409,634439,634470,634856,634904,635102,635976,636006,636037,636423,636471,636669,637534,637564,637595,637981,638029,638227,639080,639109,639143,639529,639576,639772,640616,640646,640677,641063,641111,641309,642144,642173,642207,642593,642636,642831,643693,643723,644110,644153,644348,645203,645236,645621,645667,645860,646706,646737,647123,647169,647364,648201,648232,648618,648664,648859,649700,649731,650117,650163,650358,651188,651219,651605,651651,651846,652669,652700,653086,653132,653327,654141,654172,654558,654604,654799,655602,655633,656019,656065,656260,657084,657470,657516,657711,658539,658925,658971,659166,659984,660368,660412,660607,661414,661800,661846,662041,662838,663224,663270,663465,664255,664641,664687,664882,665665,666051,666097,666292,667492,667537,667731,668920,668966,669161,670361,670407,670602,671793,671839,672034,673217,673263,673458,674628,674674,674869,676030,676076,676271,677422,677466,677664,678802,678856,679076,680203,680257,680477,681595,681649,681869,682977,683031,683251,684349,684403,684623,685706,685755,685975,687046,687095,687315,688350,688402,688622,689649,689701,689921,690935,690987,691207,692211,692263,692483,693479,693531,693751,694733,694785,695005,695972,696024,696244,697198,697250,697470,698411,698463,698683,699613,699665,699885,700807,700859,701079,701994,702049,702275,703186,703241,703467,704367,704422,704648,705537,705591,705812,706687,706741,706962,707826,707880,708101,708954,709007,709228,710072,710125,710381,711220,711273,711529,712358,712411,712666,713492,713544,713799,714611,714664,714919,715720,715773,716028,716818,716871,717126,717906,717959,718214,718984,719037,719292,720050,720103,720358,721105,721158,721413,722163,722216,722471,723225,723278,723533,724277,724330,724585,725320,725373,725628,726353,726406,726661,727378,727432,727687,728395,728449,728704,729402,729456,729711,730402,730456,730711,731394,731448,731703,732381,732435,732690,733375,733429,733684,734362,734416,734671,735341,735395,735650,736308,736362,736617,737280,737334,737589,738244,738298,738553,739202,739255,739511,740150,740202,740461,742118,742170,742426,744091,744143,744402,746056,746108,746367,748017,748069,748331,749999,750051,750313,751981,752033,752295,754860,754912,755174,757733,757785,758046,760599,760651,760912,763464,763516,763776,766323,766375,766635,769174,769226,769489,772020,772072,772335,774860,774912,775175,777695,777747,778010,780526,780578,780842,783362,783414,783675,786191,786244,786507,789017,789071,789333,791839,791893,792155,794658,794712,794969,797467,797521,797778,800272,800326,800582,803074,803126,803382,805868,805923,806179,808657,808712,808968,811441,811495,811750,814220,814274,814529,816994,817048,817303,819761,819814,820070,822520,822573,822829,825272,825325,825581,828018,828071,828327,830759,830812,831068,833498,833551,833807,836230,836283,836539,838960,839012,839272,841737,841996,844459,844713,847198,847452,849930,850185,852659,852914,855389,855644,858114,858369,860834,861089,863544,863801,866245,866505,868935,869194,871619,871878,874302,874563,876982,877243,879667,879924,882604,885287,887958,890622,893285,895943,898590,901237,903872,906496,909111,911723,914360,917072,919769,922454,925154,927849,930562,933268,935977,938701,941425,944137,946842,949543,952250,954942,957627,960287,962936,965571,968206,970837,973460,976076,978691,981289,983878,986504,989126,991740,994352,996951,999539,1002119,1004698,1007267,1009832,1012382,1014954,1017508,1020055,1022601,1025138,1027669,1030196,1032705,1035200,1037689,1040459,1042937,1045408,1047869,1050319,1052755,1055182,1057608,1060027,1062433,1064829,1067219,1069592,1071959,1074354,1076741,1079117,1081483,1083835,1086173,1088496,1090830,1093158,1095472,1097772,1100056,1102328,1104585,1106822,1109038,1111236,1113413,1115571,1117710,1119845,1121975,1124113,1126308,1128502,1130713,1132914,1135099,1137305,1139505,1141701,1143887,1146062,1387115,1387133,1388909,1388927,1390689,1390707,1392458,1392476,1394218,1394236,1395996,1396014,1397762,1397780,1399519,1399537,1401271,1401289,1403013,1403031,1404746,1404764,1406469,1406487,1408190,1408207,1409914,1409931,1411641,1411658,1413391,1413408,1415151,1415168,1416897,1416915,1418636,1418653,1420363,1420380,1422080,1422097,1423783,1423800,1425472,1425489,1427146,1427163,1428810,1428827,1430460,1430477,1432100,1432117,1433731,1433748,1435347,1435364,1436952,1436969,1438573,1438590,1440181,1440198,1441782,1441799,1443376,1443393,1444960,1444977,1446536,1446552,1448100,1448116,1449652,1449668,1451192,1451208,1452722,1452738,1453280,1453303,1454242,1454258,1454800,1454823,1455751,1455767,1456312,1456335,1457253,1457269,1457817,1457840,1458746,1458762,1459311,1459334,1460225,1460241,1460790,1460813,1461691,1461707,1462256,1462279,1463147,1463163,1463712,1463735,1464593,1464609,1465158,1465181,1466025,1466041,1466590,1466613,1467447,1467463,1468012,1468035,1468856,1468872,1469421,1469444,1470250,1470266,1470815,1470838,1471631,1471647,1472196,1472219,1473015,1473564,1473587,1474374,1474923,1474946,1475720,1476269,1476292,1477071,1477620,1477643,1478997,1479020,1480381,1480404,1481753,1481776,1483115,1483138,1484471,1484494,1485815,1485838,1487150,1487173,1488474,1488497,1489780,1489803,1491075,1491098,1492361,1492384,1493675,1493698,1494980,1495003,1496277,1496300,1497575,1497598,1498878,1498901,1500171,1500194,1501454,1501477,1502730,1502753,1503998,1504021,1505259,1505282,1506512,1506535,1507759,1507782,1508996,1509019,1510224,1510247,1511457,1511480,1512682,1512705,1513909,1513934,1515130,1515154,1516353,1516377,1517568,1517592,1518774,1518798,1519977,1520001,1521173,1521197,1522363,1522387,1523545,1523569,1524720,1524744,1525888,1525912,1527049,1527073,1528204,1528228,1529353,1529377,1530498,1530522,1531639,1531663,1532775,1532799,1533907,1533931,1535035,1535059,1536159,1536183,1537278,1537302,1538399,1538430,1539536,1539567,1540666,1540698,1541791,1541823,1542910,1542942,1544021,1544053,1545126,1545158,1546224,1546255,1547309,1547340,1548382,1548413,1549445,1549476,1550501,1550533,1551549,1551581,1552588,1552620,1553629,1553663,1554666,1554700,1555693,1555727,1556711,1556745,1557721,1557755,1558729,1558763,1559727,1559761,1561085,1561119,1562434,1562468,1564277,1564311,1566110,1566144,1567938,1567969,1570858,1570891,1573751,1573784,1576630,1576664,1579504,1579538,1582364,1582398,1585211,1585245,1588051,1588083,1590884,1590918,1593709,1593743,1596564,1596603,1599435,1599474,1602296,1602335,1605143,1605182,1607984,1608024,1610819,1610858,1613645,1613682,1616461,1616501,1619265,1619304,1622055,1622095,1624831,1624870,1627600,1627639,1630358,1630396,1633105,1633143,1635909,1635945,1638733,1638772,1641574,1641613,1644401,1644440,1647215,1647255,1650031,1650071,1652900,1652940,1655756,1655796,1658604,1658644,1661441,1661481,1664264,1664304,1667079,1667119,1669883,1669923,1672742,1672782,1675594,1675634,1678443,1678482,1681281,1681320,1684106,1684145,1686922,1686965,1689779,1689823,1692631,1692674,1695401,1695441,1698158,1698201,1700911,1700954,1703655,1703698,1706393,1706438,1709164,1709209,1711926,1711969,1714710,1714753,1717485,1717528,1720247,1720290,1722998,1723038,1725735,1725778,1728470,1728513,1731196,1731239,1733904,1733947,1736603,1736646,1739291,1739334,1741965,1742008,1744629,1744672,1747287,1747330,1749936,1749979,1752578,1752621,1755211,1755254,1757834,1757875,1760445,1760486,1763049,1763090,1765647,1765690,1768282,1770867,1773443,1776017,1778576,1781125,1783667,2298837,2301958,2305085,2308229,2311397,2314560,2317719,2320873,2324020,2327158,2330288,2333399,2336501,2339605,2342695,2343118,2345802,2346225,2348903,2349326,2352032,2352455,2355151,2355574,2358258,2358681,2361362,2361785,2364457,2364880,2367542,2367965,2370616,2371039,2373681,2374104,2376731,2377154,2379769,2380192,2382801,2383224,2385827,2386250,2388895,2389318,2391958,2392381,2395014,2395437,2398057,2398480,2401086,2401509,2404104,2404527,2407118,2407541,2410123,2410546,2413118,2413541,2416105,2416528,2419119,2419542,2422121,2422544,2425112,2425535,2428098,2428521,2431075,2431498,2434042,2434465,2436999,2437422,2439945,2440368,2442880,2443303,2445807,2446230,2448728,2449151,2451638,2452061,2454531,2454954,2457415,2457838,2460294,2460717,2463158,2463581,2466013,2466436,2468891,2469314,2471829,2472252,2474743,2475166,2477686,2478109,2480618,2481041,2483536,2483959,2486444,2486867,2489366,2489813,2492299,2492746,2495219,2495671,2498133,2498585,2501034,2501486,2503922,2504374,2506798,2507250,2509664,2510116,2512526,2512978,2515383,2515835,2518234,2518686,2521077,2521529,2523909,2524361,2526729,2527181,2529542,2529994,2532350,2532802,2535151,2535603,2537946,2538398,2540740,2541192,2543524,2543976,2546297,2546749,2549063,2549515,2551868,2552320,2554664,2555116,2557475,2557927,2560278,2560730,2563067,2563519,2565842,2566297,2568608,2569103,2571440,2571933,2574262,2574755,2577076,2577569,2579885,2580382,2582682,2583179,2585464,2585961,2588235,2588732,2591003,2591500,2593762,2594259,2596513,2597010,2599255,2599752,2601984,2602481,2604700,2605197,2607407,2607904,2610110,2610607,2612804,2613343,2615528,2616067,2618245,2618784,2620952,2621491,2623644,2624183,2626325,2626864,2629006,2629544,2631671,2632209,2634338,2634876,2636984,2637524,2639618,2640158,2642239,2642779,2644848,2645392,2647449,2647993,2650037,2650581,2652616,2653160,2655183,2655727,2657735,2658279,2660269,2660813,2662784,2663328,2665285,2665829,2667772,2668316,2670235,2670779,2672686,2673230,2675117,2675661,2677529,2678073,2679921,2680465,2682297,2682841,2684664,2685208,2687026,2687570,2689381,2689924,2691725,2692268,2694053,2694596,2696418,2697097,2699503,2700175,2702577,2703258,2705653,2706336,2708700,2709383,2711743,2712426,2714774,2715456,2717794,2718523,2720859,2721602,2723967,2724710,2727066,2727809,2730153,2730896,2733252,2734012,2736355,2737108,2739442,2740195,2742519,2743273,2745579,2746333,2748620,2749374,2751649,2752403,2754675,2755430,2757697,2758450,2760718,2761472,2763734,2764487,2766733,2767486,2769717,2770470,2772690,2773443,2775655,2776408,2779397,2782426,2785514,2788600,2791670,2794728,2797803,2800866,2803921,2806895,2809851,2812785,2815707,2818690,2821666,2824638,2827614,2830573,2833515,2836442,2839376,2842300,2850886,2863519,2866296,2881376,2884148,2886895,2889630,2892353,2895056,2897745,2900442,2903133,2905717,2908309,2910926,2913524,2916112,2918702,2921275,2923840,2926394,2928930,2931449,2933958,2936458,2938966,2941469,2943963,2946441,2948903,2951350,2953797,2956286,2958767,2961236,2963685,2966116,2968534,2970950,2973350,2975739,2978116,2980506,2982882,2985251,2987635,2990013,2992389,2994752,2997102,2999436,3001759,3004074,3006364,3008590,3010778,3012946,3015098,3017242,3019430,3021539,3023016,3024485,3025941,3027387,3028825,3030257,3031679,3033091,3034689,3036275,3037850,3039417,3040976,3042526,3044068,3045603,3047126,3048638,3050143,3051651,3053149,3054634,3056110,3057575,3059028,3060473,3061910,3063645,3065371,3067086,3068788,3070481,3072165,3073840,3075505,3077163,3078824,3080476,3082119,3083751,3085373)) 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
Moscow Philharmonic Orchestra (Orchestra) - uVisitRussia
The Orchestra was founded in 1951 by Samuel Samosud and at different periods its chief conductors and artistic directors were such outstanding musicians as Nathan Rakhlin (1957-1960), Kirill Kondrashin (1960-1976), Dmitry Kitayenko (1976-1990), Vassily Sinaisky (1991-1996) and Mark Ermler (1996-1998). In 1973 the orchestra obtained the status of an “academic orchestra”. In 1998, People’s Artist of the USSR, Professor Yuri Simonov became its Music Director and Chief Conductor.
From the season 2004-2005 the position of assistant to Maestro Simonov is given to Eduard Dyadyura.
The Orchestra performed with all the best Soviet conductors as well as some outstanding guest conductors such as Lorin Maazel, Charles Munch, Igor Markevitch, Kurt Sanderling, Igor Stravinsky, Zubin Mehta, Krzysztof Penderecki, to name a few, who all left an indelible mark on the orchestra’s history of success.
The Orchestra’s guest soloists such as Isaac Stern, Yehudi Menuhin, Artur Rubinstein, Glenn Gould, Maurizio Pollini and many others, praised highly the orchestra’s inspired performance, their fine sense of ensemble, and artistic unity. In Russia and on its tours abroad, the orchestra performed together with such a great Russian musicians as David Oistrakh, Sviatoslav Richter, Emil Gilels, Mstislav Rostropovich and Galina Vishnevskaya. They passed on their love and respect for the Orchestra to next generation of musicians such as Victor Tretyakov, Yuri Bashmet, Nikolay Petrov, Vladimir Krainev, Mikhail Petukhov, Nikolai Lugansky and many others.
The geography of the orchestra tours covers more than fifty countries. It gave performences at the best concert halls of the world: Carnegie Hall and Every Fisher Hall in New York, Royal Hall and Albert Hall in London, Musikverein and Opera House in Vienna, the Festival Hall of Herbert von Karajan in Salzburg, Concertgebouw in Amsterdam, Teatro Colon in Buenos Aires, the best philharmonic halls in Berlin, Munich, Chicago, Oslo, Stockholm, Prague, Washington, Montreal, Paris, Madrid, Tokyo, Osaka, Seoul, Hong Kong and elsewhere. Always on the road, the orchestra is holding out for a variety of genres and styles offering a fascinating combination of technical perfection and expressiveness and artistic presentation. It has participated regularly in the most prestigious music festivals of Europe, and has performed in over 5000 concerts. In 1999-2003 Maestro Simonov led the orchestra on a series of highly successful tours of Great Britain and the United States, Germany, Italy, the Czech Republic, Slovenia, France, Poland, Croatia, Austria, Romania, Hungary, Japan and Southeast Asia. The season 2004-2005 included new American and Japanese tours, as well as Prague Autumn and Russian Winter Festivals. In the season 2005-2006 will be new Russian, Spain, UK and Korea tours.
The Orchestra has made over 300 recordings. During last two years, several CDs of Tchaikovsky—“Swan Lake” large suite (compiled by Yuri Simonov) and Italian Capriccio; Rachmaninov—Symphony No.2 and “The Rock”; Prokofiev—“Romeo and Julia” large suite (compiled by Yuri Simonov); Beethoven—Symphonies No. 1, 4, 9 were issued, all live from the Grand Hall of the Moscow Conservatoire.
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.