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 (2298850,2301971,2305098,2308242,2311410,2314573,2317732,2320886,2324033,2327171,2330301,2333412,2336514,2339618,2342708,2345815,2348916,2352045,2355164,2358271,2361375,2364470,2367555,2370629,2373694,2376744,2379782,2382814,2385840,2388908,2391971,2395027,2398070,2401099,2404117,2407131,2410136,2413131,2416118,2419132,2422134,2425125,2428111,2431088,2434055,2437012,2439958,2442893,2445820,2448741,2451651,2454544,2457428,2460307,2463171,2466026,2468904,2471842,2474756,2477699,2480631,2483549,2486457,2489388,2492321,2495242,2498156,2501057,2503945,2506821,2509687,2512549,2515406,2518257,2521100,2523932,2526752,2529565,2532373,2535174,2537969,2540763,2543547,2546320,2549086,2551891,2554687,2557498,2560301,2563090,2565866,2568632,2571463,2574285,2577099,2579908,2582705,2585487,2588258,2591026,2593785,2596536,2599278,2602007,2604723,2607430,2610133,2612827,2615551,2618268,2620975,2623667,2626348,2629029,2631694,2634361,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,2699534,2702610,2705686,2708733,2711776,2714807,2717827,2720892,2724000,2727099,2730186,2733285,2736388,2739475,2742552,2745612,2748653,2751682,2754708,2757729,2760750,2763766,2766765,2769749,2772722,2775687,2778676,2781657,2784745,2787831,2790901)) 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





	Timur Zangiev (Musical Director) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Timur Zangiev (Musical Director)

Timur Zangiev (Musical Director)

Timur Zangiev was born in 1994 in Moscow. He started studying to become a symphony conductor at a musical school affiliated with the V. Gergiev Arts College in the city of Vladikavkaz, and made his debut with a symphony orchestra at the age of seven. 
 
Since 2005 he studied at Academic Music College of the Tchaikovsky State Conservatory of Moscow under the Honored Artist of Russia professor Anatoly Levin, and since 2011, at the Conservatory itself under the People’s Artist of the U.S.S.R. Gennadiy Rozhdestvensky. 

Mr. Zangiev has taken part in such festivals as Vladimir Spivakov’s Moscow Welcomes Friends (2005, 2006), Nikolai Petrov’s Kremlin the Musical (2007), Classical Music over the Volga (2009, 2010), and Dmitry Kogan’s The Days of Sublime Music, Eliso Virsaladze International Music Festival in Telavi (2012), the International festival “Debussy and His Time” in Moscow  (2012). He also toured in France. 

He has conducted the Mariinsky Orchestra, the Novaya Rossiya (New Russia) orchestra, the State Chamber Orchestra Virtuosi of Moscow, the State Academic Chamber Orchestra of Russia, the Concert Symphony Orchestra of the Moscow Conservatory, Philharmonic Orchestra of Monte-Carlo and many other orchestras in Russia. 

Mr. Zangiev was the Music Director and Conductor of the opera The Miser by V. Pashkevich in 2012 in the city of Togliatti. 

Since 2012 he acts as assistant conductor for the Moscow Stanislavsky and Nemirovich-Danchenko Music Theater. In that capacity he has taken part in the production of Songs at the Well. The Blind, Mayerling, Die lustige Witwe (The Merry Widow). He conducted the premiere performance of Songs at the Well.  In the season 2013-2014 he carried out the revival of the opera “Cosi fan tutte”. 

Since 2015 he has been a conductor for the Moscow Stanislavsky and Nemirovich-Danchenko Music Theatre.

Today he conducts "Il Barbiere di Seviglia", "Cosi fan tutte", "Manon", "Medea", "Mayerling", "Tatjana", "Orfeo ed Eueridice", "Il matrimonio segreto", "Don Giovanni" and the educational program for children “Introduction to the orchestra” at the Stanislavsky Music Theatre. 

 


Titles

  • (2015) Honoured Artist of the Republic of North Ossetia-Alania

Previous work experience

      • Stanislavsky and Nemirovich-Danchenko Moscow Academic Music Theatre (since 2012) (assitant conductor)
      • Stanislavsky and Nemirovich-Danchenko Moscow Academic Music Theatre (since 2015) (conductor)

Education

    • Moscow State Conservatory (since 2011)

Participation in competitions

  • (2015) II All-Russian Music Competition (III prize)