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 (-1)) 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





	Alexander Petrov (Stage Director) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Alexander Petrov (Stage Director)

Alexander Petrov (Stage Director)

Honoured Artist of Russia, Professor.
Artistic Director and Principal Stage Director of the "Zazerkalye" State Childrenґs Music Theatre.
Graduated from the opera directing faculty of the Leningrad State Rimsky-Korsakov Conservatoire.
From 1974-1987 worked at the St Petersburg State Academic Musorgsky Theatre of Opera and Ballet, where he staged Iolanta, Ferdinand the Great (degree production), Rigoletto, Gianni Schicchi and The Man of La Mancha.
In 1979 he staged the first production in Russia of Menottiґs opera The Medium.
In 1977 he staged Kabalevskyґs opera Colas Breugnon at the Stara Zagora Theatre (Bulgaria). He has staged productions for theatres in Krasnoyarsk, Tbilisi, Khabarovsk, Minsk and Odessa.

In St Petersburg he has staged productions for the Tovstonogov Academic Grand Drama Theatre, the Bryantsev Young Viewersґ Theatre, the State Academic Akimov Comedy Theatre and the State Academic Theatre "On Liteiny". At the Mariinsky Theatre, he has staged the operas Love for Three Oranges (1991) and Le Rossignol (1995).
In 1987 together with conductor Pavel Bubelnikov, he established a childrenґs music theatre (now the "Zazerkalye" State Childrenґs Music Theatre). At the "Zazerkalye" Theatre he has staged over twenty productions including Die Zauberflote, The Shepherdess and the Chimney Sweep, The Christmas Mystery, Lґelisir dґamore, La Boheme and The Soldierґs Tale. His productions of The Village in the Snuff-Box, A Musical Album for Children, Noahґs Ark and Finist the Bright Falcon received awards from the Russian Federation Theatre Workersґ Union in the category "Best production of the year".
In 1993 the "Zazerkalye" Theatre and the US opera company Operafest (Boston) staged a co-production of Menottiґs The Medium, which has been performed in the USA and at the Hermitage Theatre in St Petersburg.