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 (1908205,1910362,1912514,1914677,1916897,1919100,1921303,1923500,1925743,1927987,1930222,1932445,1934648,1936846,1939044,1941227,1943403,1945567,1947723,1949864,1951998,1954128,1956207,1958276,1960332,1962374,1964405,1966430,1968450,1970465,1972478,1974485,1976478,1978457,1980422,1982417,1984407,1986390,1988362,1990323,1992271,1994210,1996143,1998070,1999989,2001898,2003794,2005677,2007561,2009441,2011325,2013194,2015039,2016871,2018689,2020500,2022305,2024101,2026099,2028094,2030079,2032051,2034013,2035975,2037925,2039868,2041797,2043716,2045620,2047516,2049405,2051283,2053151,2055109,2057148,2059187,2061218,2063242,2065257,2067264,2069262,2071261,2073248,2075225,2077194,2079198,2081194,2083181,2085113,2087035,2088946,2090853,2092754,2094644,2096523,2098388,2100349,2102300,2104261,2106216,2108162,2110097,2112021,2113933,2115836,2117731,2119618,2121495,2123362,2125214,2127055,2128889,2130715,2132531,2134338,2136132,2137915,2139759,2141593,2143418,2145232,2147036,2148830,2150610,2152377,2154135,2155884,2157622,2159349,2161103,2162842,2164571,2166292,2298820,2301941,2305068,2308212,2311380,2314543,2317702,2320856,2324003,2327141,2330271,2333382,2336484,2339588,2342678,2345785,2348886,2352015,2355134,2358241,2361345,2364440,2367525,2370599,2373664,2376714,2379752,2382784,2385810,2388878,2391941,2394997,2398040,2401069,2404087,2407101,2410106,2413101,2416088,2419102,2422104,2425095,2428081,2431058,2434025,2436982,2439928,2442863,2445790,2448711,2451621,2454513,2457397,2460276,2463140,2465995,2468873,2471811,2474725,2477668,2480600,2483518,2486426,2489336,2492269,2495194,2498108,2501009,2503897,2506773,2509639,2512501,2515358,2518209,2521052,2523884,2526704,2529517,2532325,2535126,2537921,2540715,2543499,2546272,2549038,2551843,2554639,2557450,2560253,2563042,2565816,2568582,2571415,2574237,2577051,2579860,2582657,2585439,2588210,2590978,2593737,2596488,2599230,2601959,2604675,2607382,2610085,2612779,2615503,2618220,2620927,2623619,2626300,2628981,2631646,2634313,2636959,2639593,2642214,2644823,2647424,2650012,2652591,2655158,2657710,2660244,2662759,2665260,2667747,2670210,2672661,2675092,2677504,2679896,2682272,2684639,2687001,2689356,2691700,2694028,2696382,2699467,2702538,2705614,2708661,2711704,2714735,2717755,2720820,2723928,2727027,2730114,2733213,2736316,2739403,2742480,2745540,2748581,2751610,2754636)) 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





	Teodor Currentzis (Conductor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Teodor Currentzis (Conductor)

Teodor Currentzis (Conductor)

Biography
Born in Athens in 1972. He studied violin and music theory and, subsequently, classical singing at the Greek Conservatory and at the Athenaeum Conservatory. In 1987, he began his studies in orchestral conducting under maestro George Hadjinikos. In 1994-99, he studied conducting at the State conservatory of St. Petersburg, under the tutelage of Professor Ilya Musin.

In 1999, he was appointed Assistant of Yuri Temirkanov at the St. Petersburg Philharmonic Orchestra. In 2001, he participated in production of Falstaff at the Moscow’s Helikon-Opera, where he also conducted Aida.

At the Novosibirsk State Opera and Ballet Theatre

Since 2004, he has been Music Director and Principal Conductor of the Novosibirsk State Opera and Ballet Theatre, where he was music director of the following opera productions: Aida (director Dmitri Tcherniakov, 2004), Le Nozze di Figaro (director Tatjana Gurbaca, 2006), The Lady Macbeth of Mtsensk (director Henryk Baranowski, 2006), Don Carlo (concert performance, 2008), Macbeth (Novosibirsk State Opera and Ballet Theatre and Paris National Opera co-production, director Dmitri Tcherniakov, 2008), Haydn’s L'anima del filosofo, ossia Orfeo ed Euridice (Russian premiere, concert performance, 2009); and ballet productions: Stravinsky’s Le Baiser de la Fee (choreographer Alla Sigalova, 2003), Cinderella (choreographer Kirill Simonov, 2006).
In 2004, he founded the Musica Aeterna Ensemble and the New Siberian Singers Chamber Choir.


He collaborated with St. Petersburg Philharmonic Orchestra, Orchestra of the Mariynsky Theatre, Russian National Orchestra, Tchaikovsky Symphony Orchestra, Svetlanov Symphony Orchestra, Novaya Rossia Symphony Orchestra, Russian National Philharmonic Orchestra, Moscow Virtuosi State Chamber Orchestra, Moscow’s Chamber Orchestra Musica Viva, Greek National Orchestra, Sofia and Cleveland Festival Orchestras, Stuttgart Symphony Orchestra.
Teodor Currentzis appeared at the festivals in Colmar, Bangkok, London, Ludwigsburg, Loccum and Miami.
In 2008, he made his Paris Opera debut conducting Verdi's Don Carlo.

Since 2006, he has been one of the Art Directors of the Territory Modern Art Festival in Moscow.

Since 2009/10 season - Bolshoi Theatre Conductor in Residence.

Awards

A recipient of The Golden Mask National Theatre prize Special Awards for Cinderella at the Novosibirsk State Opera and Ballet Theatre (2007) and Le Nozze di Figaro at the Novosibirsk State Opera and Ballet Theatre (2008).