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 (590428,592049,593688,595393,597090,598777,600452,602134,603805,605469,607122,608767,610405,612089,613766,615433,617089,618730,620363,621991,623609,625219,626840,628451,630051,631644,633231,634809,636376,637934,639481,641016,642545,644062,645573,647076,648571,650070,651558,653039,654511,655972,657423,658878,660321,661753,663177,664594,666004,667444,668873,670314,671746,673170,674581,675983,677375,678755,680156,681548,682930,684302,685661,687001,688309,689608,690894,692170,693437,694692,695931,697157,698370,699572,700766,701953,703145,704326,705496,706646,707785,708913,710031,711179,712317,713450,714570,715679,716777,717865,718943,720009,721064,722122,723184,724236,725279,726312,727337,728354,729361,730361,731353,732340,733334,734321,735300,736267,737239,738203,739160,740110,742077,744051,746016,747976,749958,751940,754819,757693,760559,763423,766282,769134,771980,774820,777655,780486,783321,786151,788977,791799,794617,797426,800231,1453303,1454823,1456335,1457840,1459334,1460813,1462279,1463735,1465181,1466613,1468035,1469444,1470838,1472219,1473587,1474946,1476292,1477643,1479020,1480404,1481776,1483138,1484494,1485838,1487173,1488497,1489803,1491098,1492384,1493698,1495003,1496300,1497598,1498901,1500194,1501477,1502753,1504021,1505282,1506535,1507782,1509019,1510247,1511480,1512705,1513934,1515154,1516377,1517592,1518798,1520001,1521197,1522387,1523569,1524744,1525912,1527073,1528228,1529377,1530522,1531663,1532799,1533931,1535059,1536183,1537302,1538430,1539567,1540698,1541823,1542942,1544053,1545158,1546255,1547340,1548413,1549476,1550533,1551581,1552620,1553663,1554700,1555727,1556745,1557755,1558763,1559761,1561119,1562468,1564311,1566144,1567969,1570891,1573784,1576664,1579538,1582398,1585245,1588083,1590918,1593743,1596603,1599474,1602335,1605182,1608024,1610858,1613682,1616501,1619304,1622095,1624870,1627639,1630396,1633143,1635945,1638772,1641613,1644440,1647255,1650071,1652940,1655796,1658644,1661481,1664304,1667119,1669923,1672782,1675634,1678482,1681320,1684145,1686965,1689823,1692674,1695441,1698201,1700954,1703698,1706438,1709209,1711969,1714753,1717528,1720290,1723038,1725778,1728513,1731239,1733947,1736646,1739334,1742008,1744672,1747330,1749979,1752621,1755254,1757875,1760486,1763090,1765690,1768282,1770867,1773443,1776017,1778576,1781125,1783667,1908140,1910296,1912446,1914611,1916829,1919036,1921235,1923432,1925647,1927895,1930130,1932349,1934555,1936753,1938948,1941131,1943307,1945471,1947626,1949767,1951901,1954032,1956111,1958180,1960238,1962281,1964311,1966336,1968359,1970371,1972384,1974388,1976381,1978360,1980328,1982325,1984313,1986296,1988264,1990225,1992173,1994112,1996045,1997972,1999891,2001800,2003696,2005579,2007459,2009339,2011223,2013093,2014937,2016769,2018587,2020399,2022204,2023999,2025997,2027992,2029980,2031949,2033911,2035870,2037820,2039763,2041695,2043614,2045518,2047414,2049301,2051179,2053049,2055006,2057045,2059085,2061116,2063140,2065155,2067162,2069160,2071159,2073146,2075123,2077092,2079096,2081092,2083079,2085011,2086933,2088844,2090751,2092652,2094542,2096421,2098286,2100247,2102198,2104159,2106114,2108060,2109995,2111919,2113831,2115734,2117629,2119516,2121393,2123260,2125112,2126953,2128787,2130613,2132429,2187192,2188731,2190263,2191782,2193294,2194794,2196323,2197848,2199368,2200897,2202445,2203980,2205507,2207032,2208554,2210065,2211564,2213269,2214964,2216649,2218435,2220676,2222908,2225130,2227337,2229533,2231718,2233896,2236308,2238927,2241835,2245006,2248169,2251322,2254467,2257603,2260729,2263846,2266952,2270050,2273149,2276258,2279399,2282533,2285679,2288817,2291947,2295068,2298185,2301306,2304433,2307577,2310745,2313908,2317067,2320221,2323370,2326508,2329638,2332749,2335851,2338947,2342043,2345150,2348249,2351345,2354464,2357571,2360672,2363767,2366852,2369926,2372991,2376041,2379079,2696359,2696529,2699444,2699614,2702514,2702692,2705590,2705769,2708637,2708816,2711680,2711859,2714711,2714890,2717731,2717910,2720796,2720975,2723904,2724083,2727003,2727182,2730090,2730269,2733189,2733370,2736292,2736473,2739379,2739560,2742456,2742637,2745697,2748738,2751767,2754793,2757813,2760834,2763850,2766849,2769833,2772806,2775771,2778760,2781741,2784829,2787915,2790985,2794043,2797118,2800180,2803235,2806209,2809165,2812099,2815021,2818004,2820980,2823952,2826928,2829887,2832829)) 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 Krylov (Violin soloist) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Sergei Krylov (Violin soloist)

Sergei Krylov (Violin soloist)

Born in Moscow into a family of musicians, Sergei Krylov started studying the violin at the age of five and he gave his first concert after only one year. At ten he made his debut with orchestra and started performing at major venues in Russia, China, Poland, Finland and Germany. When he was only sixteen years old he recorded Mozart’s Concerto K 219 and a number of programmes for Soviet radio and television.

At a very young age he won the first Prize at the International Competition “R. Lipizer” and then went on to study with Salvatore Accardo; he became well known to the international public after being awarded the First Prize at both the “A. Stradivari” Competition in Cremona and at the “Fritz Kreisler” Competition in Vienna. Following these successes he has embarked on a brilliant career, performing at the Radio France Auditorium in Paris, the Berlin and Munich Philharmonie, the Wien Musikverein and Konzerthaus, Athens’ Megaron Centre, Tokyo’s Suntory Hall, the Santander and Granada Festivals, Prague’s Spring Festival, the Teatro Colon in Buenos Aires and at La Scala in Milan. He made his debut with the English Chamber Orchestra at the Barbican Centre in 2001 and was afterwards invited to perform under the baton of Vladimir Ashkenazy on a several occasions. Sergey Krylov has appeared with some of the world’s most prestigious orchestras, such as the Vienna Symphony Orchestra, the English Chamber Orchestra, the Camerata Academica Salzburg, the Orchestre de Chambre de Lausanne, the Czech Philharmonie, the Orchestra “Giuseppe Verdi” in Milan, the Orchestra della Radio di Lugano and I Solisti Veneti.

He has performed with many directors, including James Judd, Jutaka Sado, Dmitry Kitaenko, Saulus Sondezkis, Zoltan Kocsis, Ralf Gothoni, Muhai Tang, Franz Welser-Most, Vladimir Ashkenazy and Mstislav Rostropovich.

In 2004 Rostropovich invited him to play the Beethoven and Tchaikovsky Concertos at the Auditorium National de Madrid, in Parma and at the Tonhalle in Zurich. Besides his activity with the orchestra, Sergej Krylov is active in the field of chamber music and solo violin recitals and during recent years has played alongside Yuri Bashmet, Maxim Vengerov, Nabuko Imai, David Geringas, Stefania Mormone, Bruno Canino, Mikhail Rudy and Lilya Zilberstein.

The 2006/07 season will be full of important engagements including recitals in Italy (Accademia di Santa Cecilia in Rome, Palermo, Ravenna, etc.) and in Germany, concerts in trio with Misha Maisky and Yefim Bronfman. He will perform as soloist with orchestras like the St. Petersburg Philharmonic, the Hamburg Philharmonische Staatsorchester, the Taipei National Symphony Orchestra and will appear in the opening concert of the Dublin’s RTE Symphony Orchestra.

His discography includes recordings for EMI, Melodya and Agora.