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 (1453233,1454753,1456265,1457770,1459264,1460743,1462209,1463665,1465111,1466543,1467965,1469374,1470768,1472149,1473517,1474876,1476222,1477573,1478950,1480334,1481706,1483068,1484424,1485768,1487103,1488427,1489733,1491028,1492314,1493628,1494933,1496230,1497527,1498830,1500123,1501406,1502682,1503950,1505211,1506464,1507711,1508948,1510176,1511409,1512634,1513862,1515083,1516306,1517521,1518727,1519930,1521126,1522316,1523497,1524672,1525840,1527001,1528156,1529305,1530450,1531591,1532724,1533856,1534984,1536108,1537227,1538340,1539477,1540607,1541732,1542851,1543962,1545067,1546165,1547250,1548323,1549386,1550446,1551494,1552533,1553574,1554609,1555636,1556654,1557664,1558672,1559670,1561028,1562377,1564220,1566053,1567874,1570796,1573689,1576573,1579446,1582307,1585154,1587992,1590827,1593652,1596509,1599380,1602239,1605088,1607927,1610762,1613587,1616402,1619210,1621999,1624776,1627545,1630301,1633048,1635849,1638678,1641519,1644343,1647157,1649971,1652840,1655701,1658549,1661386,1664209,1667019,1669828,1672687,1675539,1678384,1681223,1684050,1686867,1689722,1692576,1695341,1698103,1700856,1703600,1706338,1709109,1711871,1714655,1717430,1720192,1722938,1725680,1728415,1731141,1905943,1908087,1908127,1910244,1910283,1912397,1912435,1914558,1914597,1916780,1916818,1918986,1919025,1921186,1921224,1923383,1923421,1925589,1925634,1927833,1927879,1930068,1930114,1932291,1932336,1934497,1934543,1936696,1936736,1938890,1938935,1941073,1941118,1943247,1943294,1945411,1945458,1947566,1947612,1949706,1949753,1951839,1951887,1953972,1954018,1956051,1956097,1958120,1958166,1960177,1960224,1962220,1962264,1964251,1964296,1966276,1966319,1968299,1968344,1970311,1970356,1972324,1972369,1974329,1974371,1976321,1976364,1978300,1978343,1980268,1980313,1982265,1982312,1984253,1984298,1986236,1986281,1988206,1988250,1990167,1990211,1992115,1992159,1994054,1994098,1995990,1996034,1997914,1997958,1999833,1999877,2001742,2001786,2003638,2003682,2005521,2005565,2007399,2007446,2009279,2009327,2011162,2011208,2013034,2013082,2014877,2014925,2016709,2016757,2018527,2018575,2020338,2020385,2022143,2022190,2023939,2023987,2025937,2025985,2027932,2027980,2029919,2029967,2031891,2031939,2033853,2033901,2035812,2035860,2037762,2037810,2039705,2039753,2041635,2041683,2043554,2043602,2045458,2045506,2047354,2047402,2049242,2049289,2051120,2051167,2052989,2053037,2054946,2054994,2056988,2057033,2059025,2059073,2061056,2061104,2063080,2063128,2065095,2065143,2067102,2067150,2069100,2069148,2071099,2071147,2073086,2073134,2075063,2075111,2077032,2077080,2079036,2079084,2081032,2081080,2083019,2083067,2084951,2084999,2086873,2086921,2088784,2088832,2090691,2090739,2092592,2092640,2094483,2094530,2096362,2096409,2098227,2098274,2100188,2100235,2102139,2102186,2104100,2104147,2106055,2106102,2108001,2108048,2109983,2111907,2113819,2115722,2117617,2119504,2121381,2123248,2125100,2126941,2187204,2188743,2190275,2191794,2193306,2194806,2196335,2197860,2199380,2200909,2202457,2203992,2205519,2207044,2208566,2210077,2211576,2213281,2214976,2216661,2218447,2220688,2222920,2225142,2227349,2229545,2231730,2233908,2236320,2238939,2241847,2245018,2248181,2251334,2254479,2257615,2260741,2263858,2266964,2270062,2273161,2276270,2279411,2282545,2285691,2288829,2291959,2295080,2298197,2301318,2304445,2305209,2307589,2308353,2310757,2311521,2313920,2314684,2317079,2317843,2320233,2320997,2323382,2324144,2326520,2327282,2329650,2330412,2332761,2333523,2335863,2336625,2338959,2339729,2342055,2342819,2345162,2345926,2348261,2349027,2351357,2352156,2354476,2355275,2357583,2358382,2360684,2361486,2363779,2364581,2366864,2367666,2369938,2370740,2373003,2373805,2376053,2376855,2379091,2379893,2382123,2382925,2385150,2385951,2388165,2389019,2391227,2392082,2395138,2398181,2401210,2404228,2407242,2410247,2413242,2416229,2419243,2422245,2425236,2428222,2431199,2434166,2437123,2440069,2443004,2445931,2448852,2451762,2454655,2457539,2460418,2463282,2466137,2469015,2471953,2474867,2477810,2480742,2483660,2486568,2489514,2492447,2495372,2498286,2501187,2504075,2506951,2509817,2512679,2515536,2518387,2521230,2524062,2526882,2529695,2532503,2535304,2538099,2540893,2543677,2546450,2549216,2552021,2554817,2557628,2560431,2563220,2565996,2568798,2571631,2574453,2577267,2580076,2582873,2585655,2588426,2591194,2593953,2596704,2599446,2602175,2604891,2607598,2610301,2612995,2615719,2618436,2621143,2623835,2626516,2629196,2631861,2634528,2637176,2639810,2642431,2645042,2647643,2650231,2652810,2655377,2657929,2660463,2662978,2665479,2667966,2670429,2672880,2675311,2677723,2680115,2682491,2684858,2687220,2689574,2691918,2694246,2696656,2699741,2702823,2705900,2708947,2711990,2715020,2718041,2721106,2724214,2727313,2730400,2733513,2736616,2739703,2742780,2745840,2748881,2751910,2754938,2757958,2760979,2763994,2766993,2769977,2772950,2775915,2778904,2781885,2784973,2788059,2791129,2794187,2797262,2800324,2803379,2806353,2809309,2812243,2815165,2818148,2821124,2824096,2827072,2830031,2832973,2835900,2838834,2841758,2850332,2862970,2865747,2880816,2883588,2886346)) 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
Sergey Ivanovich skripka was borne on 5 October, 1949. Its first musical formation was obtained in the special musical school of Kharkov city, and then in the Kharkov institute of skills, after finishing him in 1972 in the specialty "choirmaster". Simultaneously it worked in the operatic studio, where acquired the first experiment of professional dirizherskoy work. Sergey Ivanovich skripka was borne on 5 October, 1949. Its first musical formation was obtained in the special musical school of Kharkov city, and then in the Kharkov institute of skills, after finishing him in 1972 in the specialty "choirmaster". Simultaneously it worked in the operatic studio, where acquired the first experiment of professional dirizherskoy work. + + in 1973 of Sergey skripk entered into the Moscow state conservatory im. Tschaikovsky into professor Leo Ginsburg‘s class, which brought up such most important conductors as Vladimir Fedoseev, Aleksandr Lazarev, Dmitriy kitayenko et al. Occupations in the class of this outstanding teacher, and are later - in it - in the assistenture- practice period, they became for the young musician the present school of craftsmanship. + + its creative achievements toward the end of the instruction in the conservatory itself professor Leo Ginsburg estimated as follows: "Ckripka Sergey Ivanovich - conductor, who possesses the completely final professional extent of outfitting. His performance of the works of the most varied styles is characterized by large thorough consideration, it is creatively valuable. During its concert appearances it showed a good artistic temperament. On the rehearsals it appeared itself as leader, who easily contacts with the association, which knows how to rationally work and to be achieved results, necessary to it. It accompanies easily and conveniently for the soloist ". + + this characteristic opened before the young conductor of possibility for the concert- theatrical activity. It passed both to Moscow and in different cities of the former USSR, and in 1991 conductor with the great success performed on tour around Switzerland cities with the symphonic orchestra of the Moscow city of Zhukovskiy, whom he leads since 1975. they carry ouied also a large quantity of concerts and records with the well-known soloists (Mikhail pletnev, Yuri korchinskiy, Constantine Shcherbakov, Dmitriy khvorostovskiy, Mikhail bezverkhniy, Sergey sudzilovskiy, love Kazarnovskaya, etc.) and with the most important orchestras, in particular, with the orchestra of the Moscow philharmonic society of Sergey skripk it wrote down the oratorio Of stepana of Degtarev "Minin and Pozharskiy". + + the basic creative activity of conductor Sergey skripkya passes to joint operation with the Russian state symphonic orchestra of cinematography, with which it, beginning from 1977, writes music to the motion pictures and speaks in the concerts, including abroad (1991, Berlin, the "military requiem" of Britten; 1992, Frankfurt am Main, the requiem of Mozart and Devyataya is Beethoven‘s symphony; 1998, Hungary, Tunisia and Denmark). + + since 1993 of Sergey skripk is artistic leader and chief conductor of the named orchestra. In 1998 to it is awarded honorable title "people artist of the Russian Federation". + + one additional face of the creative interests of Sergey skripkya - work with the young musicians. Under its control were prepared the concert programs of the international youth symphonic orchestra of international musical camp in the city of Tver, university orchestra of the Scottish city of Aberdeen, student orchestra of the Russian academy of music of the name Of gnesinykh. Here Sergey skripka teaches since 1980, being the professor of the department of orchestral conducting. + + the repertoire list of conductor Sergey skripkya is very extensive. It includes the works of different styles and genres. Is noticeable its gravity to the classical and romantic styles, and also to the redkoispolnyayushchimsya works ("the name-day" overture of Beethoven, symphony Mi-bemol6 the major key Of p.I.Chaykovskogo, etc.). For the first time in THE USSR it carried out oratorio "passions according to Mark" Of r.Kayzera, and also were carried out the first records to the CDS of the works Of r.Gliera, A.Mosolova, V.Shebalina and E.Denisova. +
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.