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 (590612,592234,593872,595577,597274,598960,600636,602317,603989,605652,607306,608951,610598,612282,613959,615626,617281,618923,620556,622183,623802,625431,627052,628663,630263,631856,633443,635021,636588,638146,639695,641228,642753,644270,645781,647283,648778,650277,651765,653246,654718,656179,657630,659085,660527,661960,663384,664801,666211,667654,669080,670521,671953,673377,674788,676190,677585,678995,680396,681788,683170,684542,685894,687234,688541,689840,691126,692402,693672,694924,696163,697389,698602,699804,700998,702187,703379,704560,705724,706874,708013,709140,710271,711419,712557,713690,714810,715919,717017,718105,719183,720249,721304,722362,723424,724476,725519,726552,727578,728595,729602,730602,731594,732581,733575,734562,735541,736508,737480,738444,739401,740354,742317,744290,746261,748216,750198,752180,755059,757932,760798,763664,766523,769376,772222,775061,777896,780727,783562,786392,789218,792040,794854,797663,800468,803269,806065,808854,811636,814415,817189,819956,822716,825467,828212,830953,833692,836426,839159,841884,844599,847338,850071,852800,855530,858255,860975,863686,866392,869082,871766,874448,877123,879808,882488,885171,887843,890505,893169,895828,898475,901123,903759,906382,908998,911608,914245,916955,919655,922339,925039,927731,930444,933152,935859,938567,941295,944008,946709,949411,952118,954810,957495,960155,962800,965440,968072,970704,973326,1453208,1454728,1456240,1457745,1459239,1460718,1462184,1463640,1465086,1466518,1467940,1469349,1470743,1472124,1473492,1474851,1476197,1477548,1478921,1480305,1481677,1483039,1484395,1485739,1487074,1488398,1489704,1490999,1492285,1493599,1494904,1496201,1497498,1498801,1500094,1501377,1502653,1503921,1505182,1506435,1507682,1508919,1510147,1511378,1512603,1513831,1515052,1516275,1517490,1518696,1519899,1521095,1522285,1523468,1524643,1525811,1526972,1528127,1529276,1530421,1531562,1532697,1533829,1534957,1536081,1537200,1538313,1539450,1540580,1541705,1542824,1543935,1545040,1546138,1547223,1548296,1549359,1550417,1551465,1552504,1553545,1554580,1555607,1556625,1557635,1558643,1559641,1560999,1562348,1564191,1566024,1567854,1570771,1573663,1576544,1579419,1582278,1585125,1587963,1590798,1593623,1596480,1599351,1602211,1605059,1607898,1610734,1613558,1616381,1619181,1621973,1624747,1627516,1630279,1633025,1635823,1638649,1641490,1644319,1647133,1649944,1652813,1655672,1658520,1661357,1664180,1666999,1669799,1672658,1675510,1678363,1681195,1684024,1686838,1689694,1692547,1695313,1698074,1700827,1703571,1706309,1709080,1711842,1714626,1717401,1905938,1908079,1908177,1910236,1910334,1912389,1912484,1914553,1914649,1916772,1916867,1918976,1919072,1921178,1921273,1923375,1923470,1925581,1925704,1927826,1927950,1930061,1930184,1932283,1932406,1934488,1934611,1936688,1936809,1938882,1939005,1941065,1941188,1943239,1943364,1945403,1945528,1947557,1947683,1949697,1949824,1951831,1951958,1953962,1954089,1956041,1956168,1958110,1958237,1960167,1960293,1962208,1962336,1964241,1964367,1966268,1966392,1968288,1968415,1970301,1970427,1972314,1972440,1974318,1974445,1976310,1976438,1978289,1978417,1980258,1980384,1982255,1982382,1984243,1984369,1986226,1986352,1988196,1988318,1990157,1990279,1992105,1992227,1994044,1994166,1995978,1996100,1997904,1998026,1999823,1999945,2001732,2001854,2003628,2003750,2005511,2005633,2007386,2007517,2009269,2009397,2011150,2011281,2013021,2013150,2014867,2014995,2016699,2016827,2018517,2018645,2020326,2020457,2022131,2022262,2023929,2024057,2025927,2026055,2027922,2028050,2029908,2030035,2031879,2032010,2033841,2033972,2035800,2035931,2037750,2037881,2039693,2039824,2041625,2041753,2043543,2043673,2045447,2045577,2047343,2047473,2049230,2049360,2051108,2051237,2052978,2053108,2054935,2055064,2056976,2057103,2059014,2059144,2061045,2061175,2063069,2063199,2065084,2065214,2067091,2067221,2069089,2069219,2071088,2071218,2073075,2073205,2075052,2075182,2077021,2077151,2079025,2079155,2081021,2081151,2083008,2083138,2084940,2085070,2086862,2086992,2088773,2088903,2090680,2090810,2092581,2092711,2094472,2094601,2096351,2096480,2098216,2098345,2100177,2100306,2102128,2102257,2104218,2106173,2108119,2110054,2111978,2113890,2115793,2117688,2119575,2121452,2123319,2125171,2127012,2128846,2130672,2132488,2134295,2136089,2137871,2139716,2141550,2143375,2145189,2146993,2148787,2150567,2152334,2199754,2201283,2202831,2204366,2205892,2207419,2208941,2210452,2211951,2213654,2215349,2217034,2218820,2221061,2223293,2225513,2227720,2229916,2232101,2234279,2236689,2239308,2242219,2245388,2248551,2251704,2254849,2257985,2261111,2264228,2267334,2270432,2273542,2276678,2279819,2282953,2286099,2289237,2292367,2295488,2298603,2298850,2301724,2301971,2304851,2305098,2307995,2308242,2311163,2311410,2314326,2314573,2317485,2317732,2320639,2320886,2323786,2324033,2326924,2327171,2330054,2330301,2333165,2333412,2336267,2336514,2339371,2339618,2342461,2342708,2345568,2345815,2348667,2348916,2351777,2352045,2354896,2355164,2358003,2358271,2361106,2361375,2364201,2364470,2367286,2367555,2370360,2370629,2373425,2373694,2376475,2376744,2379513,2379782,2382545,2382814,2385571,2385840,2388593,2388908,2391653,2391971,2394709,2395027,2397752,2398070,2400781,2401099,2403799,2404117,2406813,2407131,2409818,2410136,2412813,2413131,2415800,2416118,2418814,2419132,2421816,2422134,2424807,2425125,2427793,2428111,2430770,2431088,2433737,2434055,2436694,2437012,2439640,2439958,2442576,2442893,2445502,2445820,2448423,2448741,2451333,2451651,2454236,2454544,2457120,2457428,2459999,2460307,2462863,2463171,2465718,2466026,2468595,2468904,2471533,2471842,2474447,2474756,2477390,2477699,2480322,2480631,2483240,2483549,2486148,2486457,2489051,2489388,2491984,2492321,2494908,2495242,2497822,2498156,2500723,2501057,2503611,2503945,2506487,2506821,2509353,2509687,2512214,2512549,2515069,2515406,2517919,2518257,2520762,2521100,2523594,2523932,2526414,2526752,2529227,2529565,2532035,2532373,2534836,2535174,2537630,2537969,2540424,2540763,2543208,2543547,2545981,2546320,2548747,2549086,2551552,2551891,2554348,2554687,2557159,2557498,2559962,2560301,2562751,2563090,2565519,2565866,2568285,2568632,2571123,2571463,2573945,2574285,2576759,2577099,2579560,2579908,2582357,2582705,2585139,2585487,2587910,2588258,2590678,2591026,2593437,2593785,2596188,2596536,2598930,2599278,2601659,2602007,2604375,2604723,2607082,2607430,2609785,2610133,2612479,2612827,2615203,2615551,2617920,2618268,2620627,2620975,2623319,2623667,2626001,2626348,2628682,2629029,2631347,2631694,2634014,2634361,2636660,2637007,2639641,2642262,2644871,2647472,2650060,2652639,2655206,2657758,2660292,2662807,2665308,2667795,2670258,2672709,2675140,2677552,2679944,2682320,2684687,2687049,2689404,2691748,2694076,2696449,2696494,2698607,2699534,2699579,2701681,2702610,2702656,2704763,2705686,2705733,2707835,2708733,2708780,2710879,2711776,2711823,2713912,2714807,2714854,2716935,2717827,2717874,2720005,2720892,2720939,2723123,2724000,2724047,2726228,2727099,2727146,2729317,2730186,2730233,2732420,2733285,2733332,2735530,2736388,2736435,2738621,2739475,2739522,2741703,2742552,2742599,2744775,2745612,2745659,2747826,2748653,2748700,2750856,2751682,2751729,2753883,2754708,2754755,2756911,2757729,2757775,2759938,2760750,2760796,2762960,2763766,2763812,2765969,2766765,2766811,2768959,2769749,2769795,2771933,2772722,2772768,2774903,2775687,2775733,2777900,2778676,2778722,2780884,2781657,2781703,2783932,2784745,2784791,2787023,2787831,2787877,2790102,2790901,2790947,2793161,2794005,2796226,2797080,2799295,2800142,2802354,2803197,2805403,2806171,2808370,2809127,2811314,2812061,2814238,2814983,2817188,2820169,2823141,2826123,2829092,2832043,2834973,2837906,2840834,2843752,2845191,2846619,2848038,2849446,2852303,2853723,2855137,2856547,2857950,2859346,2860733,2862109,2864886,2867663,2869041,2870421,2871799,2873171,2874535,2875892,2877238,2878583,2879955,2882731,2885496,2888237,2890963,2893677,2896369,2899057,2901756,2904418,2907016,2909610,2912219,2914810,2917396,2919976,2922544,2925106,2927653,2930181,2932691,2935197,2937703,2940206,2942703,2945191,2947661,2950110,2952562,2955004,2957490,2959965,2962427,2964865,2967285,2969700,2972119,2974511,2976892,2979257,2981637,2984008,2986373,2988753,2991125,2993493,2995848,2998186,3000506,3002824,3005120,3007352,3009544,3011725,3013882,3016026,3018165,3020356)) 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





	Alexander Ramm (Cello) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Alexander Ramm (Cello)

Alexander Ramm (Cello)

Recipient of the 1st prize at the IV Moscow Young Cellists’ Competition (2003).
Recipient of the 1st prize at the I Cambridge International Competition (2005).
Recipient of the Grand Prix at the Moscow Festival of Romantic Music (2006).
Recipient of the 4th prize at the VI International Cello Competition in the Republic of South Africa (2010).
Recipient of the 2nd prize at the III International Music Competition in Beijing (2010).
Recipient of the 1st prize at the I All-Russian Music Competition (2010).
Recipient of the 4th prize at the V International Antonio Janigro Cello Competition in Zagreb (2012).

Alexander Ramm was born in Vladivostok. In 2012 he graduated from the Moscow State Tchaikovsky Conservatoire (class of Professor Natalia Shakhovskaya), and he is currently a student at the Hochschule fьr Musik Hanns Eisler in Berlin (class of Frans Helmerson).
Has performed in concerts since the age of nine. Appears as a soloist and together with symphony orchestras. Has appeared on several occasions at the Great, Small and Rachmaninoff Halls of the Moscow Conservatoire.
Has participated in programmes of the St Petersburg House of Music including Russia’s Music Team – Participants of the Pyotr Tchaikovsky Competition (2011), NEXT: The Chosen Ones (Yekaterinburg, 2012), Young Talents of Russia (Lithuania, 2012), Embassy of Mastery (Linz, 2012) and Evenings in the English Hall (St Petersburg, 2012).