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 (2283113,2283138,2286259,2286284,2289397,2289422,2292527,2292552,2295648,2295673,2298763,2298788,2301884,2301909,2305011,2305036,2308155,2308180,2311323,2311348,2314486,2314511,2317645,2317670,2320799,2320824,2323946,2323971,2327084,2327109,2330214,2330239,2333325,2333350,2336427,2336452,2339531,2339556,2342621,2342646,2343041,2345728,2345753,2346148,2348829,2348854,2349249,2351958,2351983,2352378,2355077,2355102,2355497,2358184,2358209,2358604,2361288,2361313,2361708,2364383,2364408,2364803,2367468,2367493,2367888,2370542,2370567,2370962,2373607,2373632,2374027,2376657,2376682,2377077,2379695,2379720,2380115,2382727,2382752,2383147,2385753,2385778,2386173,2388797,2388837,2389241,2391857,2391899,2392304,2394913,2394955,2395360,2397956,2397998,2398403,2400985,2401027,2401432,2404003,2404045,2404450,2407017,2407059,2407464,2410022,2410064,2410469,2413017,2413059,2413464,2416004,2416046,2416451,2419018,2419060,2419465,2422020,2422062,2422467,2425011,2425053,2425458,2427997,2428039,2428444,2430974,2431016,2431421,2433941,2433983,2434388,2436898,2436940,2437345,2439844,2439886,2440291,2442781,2442822,2443226,2445707,2445749,2446153,2448628,2448670,2449074,2451538,2451580,2451984,2454429,2454471,2454877,2457313,2457355,2457761,2460192,2460234,2460640,2463056,2463098,2463504,2465911,2465953,2466359,2468789,2468831,2469237,2471727,2471769,2472175,2474641,2474683,2475089,2477584,2477626,2478032,2480516,2480558,2480964,2483434,2483476,2483882,2486342,2486384,2486790,2489245,2489287,2489736,2492178,2492220,2492669,2495102,2495144,2495594,2498016,2498058,2498508,2500917,2500959,2501409,2503805,2503847,2504297,2506681,2506723,2507173,2509547,2509589,2510039,2512408,2512450,2512901,2515265,2515307,2515758,2518116,2518158,2518609,2520959,2521001,2521452,2523791,2523833,2524284,2526611,2526653,2527104,2529424,2529466,2529917,2532232,2532274,2532725,2535033,2535075,2535526,2537828,2537870,2538321,2540622,2540664,2541115,2543406,2543448,2543899,2546179,2546221,2546672,2548945,2548987,2549438,2551750,2551792,2552243,2554546,2554588,2555039,2557357,2557399,2557850,2560160,2560202,2560653,2562949,2562991,2563442,2565723,2565768,2566218,2568489,2568534,2569024,2571322,2571364,2571856,2574144,2574186,2574678,2576958,2577000,2577492,2579767,2579809,2580305,2582564,2582606,2583102,2585346,2585388,2585884,2588117,2588159,2588655,2590885,2590927,2591423,2593644,2593686,2594182,2596395,2596437,2596933,2599137,2599179,2599675,2601866,2601908,2602404,2604582,2604624,2605120,2607289,2607331,2607827,2609992,2610034,2610530,2612686,2612728,2613266,2615410,2615452,2615990,2618127,2618169,2618707,2620834,2620876,2621414,2623526,2623568,2624106,2626207,2626249,2626787,2628888,2628930,2629467,2631553,2631595,2632132,2634220,2634262,2634799,2636866,2636908,2637447,2639500,2639542,2640081,2642121,2642163,2642702,2644730,2644772,2645315,2647331,2647373,2647916,2649919,2649961,2650504,2652498,2652540,2653083,2655065,2655107,2655650,2657617,2657659,2658202,2660151,2660193,2660736,2662666,2662708,2663251,2665167,2665209,2665752,2667654,2667696,2668239,2670117,2670159,2670702,2672568,2672610,2673153,2674999,2675041,2675584,2677411,2677453,2677996,2679803,2679845,2680388,2682179,2682221,2682764,2684546,2684588,2685131,2686908,2686950,2687493,2689263,2689305,2689847,2691607,2691649,2692191,2693935,2693977,2694519,2696252,2696255,2696258,2696261,2696264,2696320,2696999,2699403,2700080,2702473,2703161,2705549,2706239,2708596,2709286,2711639,2712329,2714670,2715359,2717690,2718426,2720755,2721505,2724613,2727712,2730799,2733915,2737011,2740098,2743176,2746236,2749277,2752306,2755333,2758353,2761375,2764390,2767389,2770373,2773346,2776311,2779300,2782297,2785385,2788471,2791541,2794599,2797674,2800737,2803792,2806766,2809722,2812656,2815578,2818561,2821537,2824509,2827485,2830444,2833386,2836313,2839247,2842171,2850748,2863381,2866158,2881232,2884004,2886757,2889492,2892215,2894918,2897607,2900304,2902995,2905579,2908171,2910788,2913386,2915974,2918564,2921137,2923702,2926256,2928792,2931311,2933819,2936319,2938827,2941330,2943824,2946302,2948764,2951211,2953658,2956147,2958630,2961099,2963548,2965979,2968397,2970813,2973213,2975602,2977979,2980369,2982745,2985114,2987498,2989876,2992252,2994615,2996965,2999299,3001617,3003934,3006224,3008450,3010638,3012806,3014958,3017102,3019290,3021435,3022912,3024381,3025837,3027283,3028721,3030153,3031575,3032987,3034585,3036171,3037746,3039313,3040872,3042422,3043964,3045499,3047022,3048534,3050039,3051547,3053045)) 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





	Elisso Virsaladze (Piano) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Elisso Virsaladze (Piano)

Elisso Virsaladze (Piano)

Elisso Virsaladze grew up in Tiflis, in a family long involved in the art and culture of Georgia. She received her first piano lessons from her grandmother, Professor Anastasia Virsaladze. After attending the conservatory, she left her native city for Moscow, where, at the age of twenty, she won third prize in the Tchaikovsky Competition.

In Moscow, she continued her studies with Heinrich Neuhaus and Yakov Zak. These gifted teachers had not only a deep influence on her artistic development, but also immersed her in the renowned tradition of Russian piano pedagogy. It is therefore not surprising that she is recognised today as an exceptional teacher whose students have won sensational recognition at competitions. Elisso Virsaladze is a professor at the Moscow conservatory and at the Munich Musikhochschule; she is regularly invited as juror to the major international competitions, including those in Japan, Portugal, Santander, the Geza Anda in Zurich, the Rubinstein in Tel Aviv and the Tchaikovsky in Moscow. Forthcoming competitions at which Miss Virsaladze will adjudicate are those in Santander (2005), Munich (2006) and Brussels (2007).

She is deeply committed to the composers of the late 18th and 19th centuries, especially Mozart, Beethoven, Chopin and Schumann. At the age of twenty-four, she won the first prize at the Schumann Competition in Zwickau, and she has been described by the international press as one of the great contemporary interpreters of Schumann.

Miss Virsaladze is also well-known for her wide repertoire up to and including modern Russian composers. The Soviet Union has honoured her with its highest artistic awards.

Elisso Virsaladze regularly performs in London, Milan, Rome, Paris, Lisbon, Berlin and Barcelona; duo concerts with Natalia Gutman have taken place in cities including, in Europe, Vienna, Berlin, Brussels, Madrid, Munich, Milan, Geneva and Lausanne. In chamber music and with orchestras such as the St Petersburg and the Royal Philharmonic Orchestras, she has toured North America, Japan and Europe extensively, in addition to her appearances with the major orchestras in France, Germany, Italy, Spain, Switzerland, the USA and other countries. Miss Virsaladze has worked with conductors such as Rudolf Barshai, Kyril Kondrashin, Riccardo Muti, Kurt Sanderling, Wolfgang Sawallisch, Evgeny Svetlanov, Juri Temirkanov and Antoni Wit.