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 (590150,590562,590650,591770,592183,592271,593407,593822,593910,595111,595529,595617,596808,597226,597314,598495,598914,599000,600170,600588,600676,601851,602271,602356,603523,603941,604029,605185,605606,605691,606840,607258,607346,608485,608903,608991,610123,610549,610639,611807,612233,612323,613484,613910,614000,615151,615577,615667,616809,617231,617322,618448,618874,618964,620081,620507,620597,621711,622133,622224,623327,623753,623843,624937,625382,625472,626558,627003,627093,628169,628614,628704,629769,630214,630304,631362,631807,631897,632949,633394,633484,634527,634972,635062,636094,636539,636629,637652,638097,638187,639199,639642,639732,640734,641179,641269,642264,642704,642791,643781,644219,644309,645295,645730,645820,646794,647234,647324,648289,648729,648819,649788,650228,650318,651276,651716,651806,652757,653197,653287,654229,654669,654759,655690,656130,656220,657141,657581,657671,658596,659036,659126,660036,660480,660567,661471,661911,662001,662895,663335,663425,664312,664752,664842,665722,666162,666252,667160,667604,667691,668593,669031,669121,670034,670472,670562,671466,671904,671994,672890,673328,673418,674301,674739,674829,675703,676141,676231,677093,677533,677623,678475,678939,679036,679876,680340,680437,681268,681732,681829,682650,683114,683211,684022,684486,684583,685838,685935,687178,687275,688485,688582,689784,689881,691070,691167,692346,692443,693617,693710,694868,694965,696107,696204,697333,697430,698546,698643,699748,699845,700942,701039,702132,702230,703324,703422,704505,704603,705670,705767,706820,706917,707959,708056,709086,709183,710204,710324,711352,711472,712490,712610,713627,713743,714743,714863,715852,715972,716950,717070,718038,718158,719116,719236,720182,720302,721237,721357,722295,722415,723357,723477,724409,724529,725452,725572,726485,726605,727511,727631,728528,728648,729535,729655,730535,730655,731527,731647,732514,732634,733508,733628,734495,734615,735474,735594,736441,736561,737413,737533,738377,738497,739338,739454,740287,740403,742255,742371,744228,744344,746192,746309,748150,748270,750132,750252,752114,752234,754993,755113,757867,757986,760733,760852,763598,763715,766457,766574,769307,769427,772153,772273,774993,775112,777828,777947,780659,780778,783496,783613,786324,786443,789150,789269,791972,792091,794791,794903,797600,797712,800405,800517,803208,803318,806002,806114,808791,808903,811574,811686,814353,814465,817127,817240,819898,820007,822655,822765,825409,825518,828155,828264,830896,831005,833635,833744,836365,836475,839097,839206,841822,841931,844537,844650,847276,847389,850009,850122,852738,852851,855468,855581,858193,858306,860917,861026,863629,863738,866330,866439,869020,869129,871704,871813,874386,874498,877066,877177,879750,879861,882430,882541,885113,885224,887782,887894,890448,890559,893108,893219,895766,895877,898414,898526,901060,901172,903696,903808,906320,906432,908935,909047,909582,911547,911659,912193,912333,914184,914296,914830,914970,916892,917005,917540,917679,919594,919705,920239,920377,922280,922390,922925,923063,924979,925091,925625,925763,927672,927782,928339,928480,930385,930495,931053,931194,933090,933201,933765,933905,935799,935909,936473,936614,938628,939208,939348,941352,941931,942072,944065,944644,944785,946769,947349,947489,949470,950059,950199,952175,952763,952903,954869,955458,955598,957553,958140,958281,960213,960801,960942,962860,963451,963589,965498,966086,966227,968130,968721,968862,970762,971354,971494,973385,973977,974117,976002,976593,976732,978615,979206,979345,981213,981804,981943,983802,984392,984531,986429,987020,987159,989051,989642,989781,991665,992257,992397,994276,994871,995009,996875,997470,997608,999463,1000058,1000196,1002043,1002640,1002778,1005218,1005357,1007789,1007928,1010354,1010491,1012937,1013076,1015509,1015646,1018063,1018202,1020610,1020749,1023158,1023295,1025695,1025834,1028230,1028369,1030762,1030899,1033271,1033410,1035766,1035905,1038259,1038396,1040745,1040882,1043223,1043362,1045694,1045833,1048154,1048294,1050605,1050745,1053041,1053181,1055470,1055609,1057896,1058035,1060309,1060448,1062713,1062853,1065111,1065250,1067497,1067637,1069872,1070012,1072244,1072415,1074641,1074812,1077027,1077199,1079403,1079575,1081767,1081940,1084119,1084292,1086457,1086630,1088780,1088953,1091115,1091287,1093442,1093614,1095757,1095929,1098057,1098230,1100339,1100513,1102611,1102785,1104869,1105043,1107109,1107280,1109325,1109496,1111519,1111691,1113696,1113868,1115852,1116026,1117995,1118168,1120129,1120302,1122263,1122444,1124401,1124582,1126596,1126777,1128825,1129004,1131038,1131217,1133234,1133413,1135429,1135619,1137634,1137824,1139835,1140026,1142029,1142220,1144216,1144407,1146392,1146583,1148556,1148747,1150710,1150901,1152861,1153052,1155007,1155198,1157144,1157367,1159312,1159536,1161467,1161687,1163607,1163825,1165739,1165959,1167876,1168094,1170006,1170226,1172128,1172348,1174243,1174461,1176389,1176607,1178524,1178742,1180652,1180870,1182771,1182989,1184881,1185099,1186991,1187210,1189097,1189317,1191196,1191415,1193284,1193504,1195363,1195583,1197439,1197659,1199506,1199727,1201567,1201788,1203620,1203851,1205670,1205899,1207707,1207936,1209735,1209978,1211774,1212019,1213805,1214049,1215827,1216071,1217836,1218080,1219830,1220074,1221813,1222057,1223789,1224033,1225760,1226004,1227753,1227997,1229767,1230014,1231776,1232027,1233773,1234020,1235759,1236010,1237741,1237987,1239709,1239955,1241665,1241911,1243648,1243894,1245621,1245871,1247584,1247830,1249566,1249812,1251544,1251790,1253525,1253771,1255500,1255750,1257469,1257715,1259429,1259675,1261376,1261622,1263310,1263556,1265235,1265481,1267165,1267411,1269085,1269331,1270994,1271240,1272892,1273138,1274776,1275022,1276644,1276892,1278500,1278746,1280354,1280602,1282197,1282445,1284030,1284276,1285854,1286100,1287665,1287911,1289459,1289705,1291244,1291490,1293300,1295102,1296897,1298683,1300454,1302213,1303962,1305710,1307450,1309180,1310898,1312817,1314734,1316668,1318595,1320514,1322423,1324325,1326212,1328085,1329941,1331828,1333705,1335572,1337428,1339273,1341103,1342920,1344729,1346536,1348333,1350123,1352028,1353920,1355801,1357672,1359533,1361385,1363228,1365060,1366879,1368688,1370492,1372285,1374065,1375925,1377768,1379597,1381415,1383231,1385038,1401601,1403343,1405076,1406800,1408521,1410258,1411985,1413754,1415514,1417262,1418999,1420726,1422443,1424146,1425835,1427509,1429173,1430823,1432463,1434094,1434162,1435710,1435778,1437339,1437413,1438960,1439034,1440568,1440642,1442170,1442244,1443764,1443839,1445348,1445423,1446921,1446996,1448485,1448560,1450037,1450112,1451577,1451652,1453107,1453182,1454627,1454702,1456146,1456218,1457652,1457723,1459144,1459217,1460623,1460696,1462089,1462162,1463545,1463618,1464991,1465064,1466423,1466496,1467845,1467918,1469254,1469327,1470648,1470721,1472029,1472102,1473397,1473470,1474756,1474829,1476102,1476175,1477453,1477526,1478801,1478894,1480185,1480278,1481557,1481650,1482918,1483011,1484274,1484367,1485618,1485711,1486953,1487046,1488277,1488370,1489583,1489676,1490878,1490971,1492164,1492257,1493478,1493571,1494783,1494876,1496080,1496173,1497375,1497470,1498678,1498773,1499971,1500066,1501254,1501349,1502530,1502625,1503798,1503893,1505059,1505154,1506312,1506407,1507559,1507654,1508796,1508891,1510024,1510119,1511246,1511348,1512471,1512573,1513699,1513801,1514920,1515022,1516143,1516245,1517358,1517460,1518564,1518666,1519766,1519869,1520962,1521065,1522152,1522255,1523335,1523438,1524510,1524613,1525678,1525781,1526839,1526942,1527994,1528097,1529143,1529246,1530288,1530391,1531429,1531532,1532565,1532670,1533697,1533802,1534825,1534930,1535949,1536054,1537068,1537173,1538181,1538286,1539318,1539423,1540448,1540553,1541573,1541678,1542692,1542797,1543803,1543908,1544908,1545013,1546006,1546111,1547091,1547196,1548164,1548269,1549227,1549332,1550284,1550387,1551332,1551435,1552371,1552474,1553412,1553515,1554447,1554550,1555474,1555577,1556492,1556595,1557502,1557605,1558510,1558613,1559508,1559611,1560866,1560969,1562215,1562318,1564058,1564161,1565891,1565994,1567720,1567821,1570637,1570741,1573530,1573633,1576412,1576515,1579286,1579388,1582146,1582249,1584993,1585096,1587834,1587935,1590666,1590769,1593491,1593594,1596348,1596451,1599219,1599322,1602080,1602182,1604927,1605030,1607766,1607874,1610604,1610705,1613430,1613534,1616248,1616351,1619049,1619152,1621843,1621945,1624615,1624718,1627384,1627487,1630143,1630247,1632891,1632993,1635692,1635793,1638620,1641461,1644291,1647105,1649915,1652784,1655643,1658491,1661328,1664151,1666968,1669770,1672629,1675481,1678328,1681167,1683996,1686809,1689665,1692518,1695285,1698045,1892871,1894943,1897026,1899161,1901309,1903446,1905571,1907716,1909873,1912024,1914185,1916405,1918611,1920811,1923008,1925214,1927458,1929693,1931916,1934123,1936321,1938515,2191909,2193421,2194921,2196450,2197977,2199497,2201026,2202574,2204109,2205635,2207161,2208683,2210194,2211693,2213397,2215092,2216777,2218563,2220804,2223036,2225257,2227464,2229660,2231845,2234023,2236433,2239052,2241961,2245131,2248294,2251447,2254592,2257728,2260854,2263971,2267077,2270175,2273282,2276390,2279531,2282665,2285811,2288949,2292079,2295200,2298318,2301439,2304566,2307710,2308408,2310878,2311576,2314041,2314739,2317200,2317898,2320354,2321052,2323503,2324199,2326641,2327337,2329771,2330467,2332882,2333578,2335984,2336680,2339080,2339784,2342176,2342874,2345283,2345981,2348382,2349082,2351478,2352211,2354597,2355330,2357704,2358437,2360806,2361541,2363901,2364636,2366986,2367721,2370060,2370795,2373125,2373860,2376175,2376910,2379213,2379948,2382245,2382980,2385272,2386006,2388287,2389074,2391349,2392137,2394405,2395193,2397448,2398236,2400477,2401265,2403495,2404283,2406509,2407297,2409514,2410302,2412509,2413297,2415496,2416284,2418510,2419298,2421512,2422300,2424503,2425291,2427489,2428277,2430466,2431254,2433434,2434221,2436393,2437178,2439339,2440124,2442274,2443059,2445200,2445986,2448121,2448907,2451031,2451817,2453934,2454710,2456818,2457594,2459697,2460473,2462561,2463337,2465416,2466192,2468293,2469070,2472008,2474922,2477865,2480797,2483715,2486623,2489569,2492502,2495427,2498341,2501242,2504130,2507006,2509872,2512734,2515591,2518442,2521285,2524117,2526937,2529750,2532558,2535359,2538154,2540948,2543732,2546505,2549271,2552076,2554872,2557683,2560486,2563275,2566055,2568861,2571689,2574511,2577325,2580138,2582935,2585717,2588488,2591256,2594015,2596766,2599508,2602237,2604953,2607660,2610363,2613076,2615800,2618517,2621224,2623916,2626597,2629277,2631942,2634609,2637257,2639891,2642512,2645125,2647726,2650314,2652893,2655460,2658012,2660546,2663061,2665562,2668049,2670512,2672963,2675394,2677806,2680198,2682574,2684941,2687303,2689657,2692001,2694329,2696755,2699839,2702923,2706000,2709047,2712090,2715120,2718141,2721206,2724314,2727413,2730500,2733615,2736718,2739805,2742883,2745943,2748984,2752013,2755040,2758060,2761083,2764098,2767097,2770081,2773054,2776019,2779008,2781989,2785077,2788163,2791233,2794291,2797366,2800428,2803483,2806457,2809413,2812347,2815269,2818252,2821228,2824200,2827176,2830135,2833077,2836004,2838938,2841862,2850436,2863073,2865850,2880919,2883691,2886449,2889183,2891906,2894609,2897298,2899995,2902686,2905270,2907862,2910479,2913077,2915665,2918255,2920828,2923393,2925948,2928484)) 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
Sergei Skripka (Conductor) - uVisitRussia
Sergei Skripka was born in Kharkov, Russia in 1949, and began his musical studies at the local music school in that city. In 1972 he graduated from the Kharkov Institute of Arts, where he studied choral conducting. Following graduation, Skripka entered the Moscow State Tchaikovsky Conservatory, studying opera and symphony conducting under Professor Leo Ginsburg, with whom he likewise pursued two years of post-graduate work. Shortly after completing his studies in 1979, Skripka began his association with the Russian State Symphony Cinema Orchestra, eventually becoming its chief conductor and artistic director in 1993.
Skripka has conducted a great many of the orchestra‘s concerts and recordings, including those with famous soloists such as Mikhail Pletnyov, Dmitri Hvorostovksy, Sergei Sudzilovsky, and others. He has likewise overseen the orchestra during its tours abroad. He has conducted a number of new orchestral works by Russian composers such as Artemyev, Mosolov, and Shebalin - some of which are featured here at the Classical Archives.
In addition to his work with the Cinema Orchestra, moreover, Skripka regularly conducts - since 1979 - the Zhukovsky Symphony Orchestra, which has toured in Switzerland and Hungary. He is currently a professor of orchestral conducting at the Gnessin Academy in Moscow. He also holds the honor of being a People‘s Artist of Russia. We are pleased to feature this talented conductor and his distinguished and historic orchestra.
The Russian State Symphony Cinema Orchestra began in 1924 as the resident orchestra at Moscow‘s famous silent movie house, Ars. The success at this theater soon led to invitations for founding conductor D.Block to take the orchestra to other theaters - and to this day the orchestra has been associated with cinema. The association solidified when, during the 1930s and 40s, the orchestra recorded the music to classic Russian films by directors such Aisenshtein, Pudovkin, Alexandrov, and Pyriev - with music by Prokofiev, Shostakovich, Khachaturian, and others. Subsequent classic Russian films for which the Cinema Orchestra has recorded the soundtrack include "War and Peace", "Moscow Doesn‘t Believe in Tears" and "Burnt by the Sun" - which received an Oscar for Best Foreign Film in 1995. The orchestra has thus mastered the particular demands required in producing a film soundtrack, including the need to operate under tight time restrictions. The range of styles and size of forces is likewise easily accommodated, from the large symphonic scores of Schnittke to the jazz-based scores of Andrei Eshpai.
Beyond its work for film, the orchestra likewise plays a role in Moscow concert life, performing both standard works of the Russian and European repertoires, as well as modern works. The orchestra performs regularly in the Moscow State Philharmonic Society subscription concerts, as well as participates in various music festivals in Russia - including those dedicated to contemporary works. More recently the orchestra has toured outside Russia, traveling, for example, to Berlin in 1991, where they performed Shostakovich‘s 7th Symphony and the War Requiem of Britten; other tours included to Vienna, Frankfurt, and Tunis. Their long and distinguished career has led to numerous recordings, not only of film scores but likewise of non-film compositions, both of the "standard" repertory and contemporary works.
Over the years, the Russian State Symphony Cinema Orchestra has been led by a number of talented conductors, including A.Gauk, V.Nebolsin, and A.Roitman. Today, the orchestra is fortunate to be under the strong leadership of Sergei Skripka.
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.