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 (3466525,3468705,3470873,3473031,3475187,3477336,3479484,3481623,3483752,3485872,3487984,3490093,3492221,3494345,3496463,3498614,3500759,3502894,3505025,3507148,3509270,3511384,3513492,3515585,3517675,3519765,3521842,3523913,3525968,3528024,3530081,3534224,3536264,3538295,3540319,3542386,3544444,3546487,3548519,3550553,3552595,3554627,3556666,3558690,3560704,3570803,3572815,3574825,3576734,3578637,3580534,3582430,3584288,3586145,3848175,3848404,3848629,3848851,3849072,3849291,3907345,3908034,3908721,3909405,3910085,3910774,3911462,3912144,3912828,3913508,3914187,3914859,3915540,3916216,3916892,3917565,3918234,3918909,3919599,3926411,3927075,3927732,3928390,3929045,3929699,3930347,3930997,3931639,3932282,3932923,3953301,3953918)) 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 (Conductor) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Timur Zangiev (Conductor)

Timur Zangiev (Conductor)

Honoured Artist of the Republic of North Ossetia-Alania

Timur Zangiev was born in 1994. He began to study music at the age of three, and at the age of seven he conducted the Symphony Orchestra of the Vladikavkaz Philharmonic for the first time.

In 2011 he entered the Moscow State Tchaikovsky Conservatoire (class of Gennady Rozhdestvensky), already having experience of appearing with Russia's leading orchestras, among them the Mariinsky Orchestra, the State Academic Chamber Orchestra of Russia, the Moscow Virtuosi and the Novaya Rossiya ensemble.

As a first-year student at the conservatoire he took part in the International Eliso Virsaladze Music Festival in Telavi, the festivals Debussy and His Time in Moscow and High Music Days in Samara and he began to collaborate with the Academic Stanislavsky and Nemirovich-Danchenko Moscow Musical Theatre.

In 2017 he graduated from the Moscow State Conservatoire and started to work as a guest conductor at the Togliatti Philharmonic. He is currently a staff conductor with the Academic Stanislavsky and Nemirovich-Danchenko Moscow Musical Theatre. His repertoire includes over thirty opera and ballet productions in addition to many symphonic opuses.

Recent engagements include concerts with the Russian National Orchestra and the National Philharmonic Orchestra of Russia, Mayerling (with Sergei Polunin), Don Giovanni and La Bohème (with Hibla Gerzmava), Iolanta (with Mariinsky Opera soloists) and Tosca (with Mariinsky Opera soloists, the Mariinsky Chorus and Orchestra and Maria Guleghina). Engagements for the current season include performances with the State Academic Symphony Orchestra of Russia “Evgeny Svetlanov” in the Moscow State Philharmonic Society, the Tchaikovsky Symphony Orchestra in the Great Hall of the Moscow State Conservatory and with Ailen Pritchin in the Togliatti Philharmonic.
Information for January 2019