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 (2298822,2301943,2305070,2308214,2311382,2314545,2317704,2320858,2324005,2327143,2330273,2333384,2336486,2339590,2342680,2345787,2348888,2352017,2355136,2358243,2361347,2364442,2367527,2370601,2373666,2376716,2379754,2382786,2385812,2388880,2391943,2394999,2398042,2401071,2404089,2407103,2410108,2413103,2416090,2419104,2422106,2425097,2428083,2431060,2434027,2436984,2439930,2442865,2445792,2448713,2451623,2454516,2457400,2460279,2463143,2465998,2468876,2471814,2474728,2477671,2480603,2483521,2486429,2489342,2492275,2495200,2498114,2501015,2503903,2506779,2509645,2512507,2515364,2518215,2521058,2523890,2526710,2529523,2532331,2535132,2537927,2540721,2543505,2546278,2549044,2551849,2554645,2557456,2560259,2563048,2565823,2568589,2571421,2574243,2577057,2579866,2582663,2585445,2588216,2590984,2593743,2596494,2599236,2601965,2604681,2607388,2610091,2612785,2615509,2618226,2620933,2623625,2626306,2628987,2631652,2634319,2636965,2639599,2642220,2644829,2647430,2650018,2652597,2655164,2657716,2660250,2662765,2665266,2667753,2670216,2672667,2675098,2677510,2679902,2682278,2684645,2687007,2689362,2691706,2694034,2696392,2699477,2702548,2705624,2708671,2711714,2714745,2717765,2720830,2723938,2727037,2730124,2733223,2736326,2739413,2742490,2745550,2748591,2751620,2754646,2757668,2760689)) 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





	Vladimir Jurowski (Conductor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Vladimir Jurowski (Conductor)

Vladimir Jurowski (Conductor)

Born in Moscow as a son of conductor Mikhail Jurowski, Vladimir Jurowski completed the first part of his musical studies in his native town at the Music College of the Moscow Conservatory. In 1990 he moved with his family to Germany where he continued his studies at High Schools of Music in Dresden and in Berlin, studying conducting with Rolf Reuter and vocal coaching with Semion Skigin.

In 1995 he made his international debut at the Wexford Festival, where he conducted Rimsky-Korsakov’s May Night. The same year saw his brilliant debut at the Royal Opera House Covent Garden in Nabucco.

In the season 1996/97 Jurowski has joined the ensemble of Komische Oper Berlin. A season later he has been given the title of First Kapellmeister of this theatre. He continued working at the Komische Oper on a permanent basis until 2001. Since 1997 Vladimir Jurowski has been a guest at some of the world‘s leading musical institutions such as the Royal Opera House Covent Garden, Teatro La Fenice di Venezia, Opera Bastille de Paris, Theatre de la Monnaie Bruxelles, Maggio Musicale Festival Florence, Rossini Opera Festival Pesaro, Edinburgh Festival, Semperoper Dresden, Teatro Comunale di Bologna (where he has served as Principal Guest Conductor between 2000 and 2003). In 1999 he debuted at the Metropolitan Opera New York with Rigoletto and has returned on numerous occasions since.

During recent seasons he made highly successful debuts with such orchestras as the Los Angeles Philharmonic, Berlin Philharmonic, Rotterdam Philharmonic and the Russian National Orchestra, and most recently with the Pittsburgh Symphony and the Philadelphia Orchestra.

Recent operatic highlights have included The Queen of Spades at the Metropolitan Opera, Parsifal and Wozzeck at the Welsh National Opera, War and Peace at the Opera National de Paris as well as Die Zauberflцte, La Cenerentola and Otello at Glyndebourne Opera. This season Vladimir Jurowski made his debut at La Scala conducting Eugene Onegin.

Recent/future symphonic engagements include concerts with the London Philharmonic, Oslo Philharmonic and the Russian National Orchestra as well as debuts with the Dresden Staatskapelle and the Royal Concertgebouw Orchestra.

Jurowski’s discography includes the first ever recording of the cantata Exile by Giya Kancheli for ECM (1994), L’etoile du Nord by Meyerbeer for Naxos-Marco Polo (1996), Werther by Massenet for BMG (1999), and recently released live recordings of works by Rachmaninov, M.-A.Turnage and Tchaikovsky on London Philharmonic Orchestra’s own label. His first of a series of recordings with the Russian National Orchestra, featuring Tchaikovsky‘s Suite No. 3 and Stravinsky‘s Divertimento from Le baiser de la fйe, was released on PentaTone Classics last year and was followed by the recording of Shostakovich Symphonies No 1 & 6 released earlier this year.

In January 2001 Vladimir Jurowski commenced his position as Music Director of the Glyndebourne Festival Opera and in 2003 was appointed Principal Guest Conductor of the London Philharmonic Orchestra and a member of the Russian National Orchestra Conductor Collegium. Last year he has also been appointed Principal Guest Conductor of the Russian National Orchestra. It has recently been announced that Vladimir Jurowski will become London Philharmonic Orchestra‘s twelfth Principal Conductor starting in September 2007.