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
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Moscow Philharmonic Orchestra (Orchestra)

Moscow Philharmonic Orchestra (Orchestra)

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.