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





	Alla Brosterman (Musical Preparation) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Alla Brosterman (Musical Preparation)

Alla Brosterman (Musical Preparation)

Born in the Primorsky Region. Graduated in piano studies from the Moldavian Conservatoire in 1966.
From 1968-1976, worked at the Moldavian Theatre of Opera and Ballet.
In 1976, was engaged at the Musorgsky Theatre of Opera and Ballet, working on productions of the operas Eugene Onegin, The Snow Maiden, The Queen of Spades, Boris Godunov, Khovanshchina and The Golden Cockerel.

Has been a chorus master with the Mariinsky Theatre since 1989. Has worked on productions of the operas Don Carlos, Otello, Madama Butterfly, Tosca, The Miserly Knight, La forza del destino, Aida, Turandot, La traviata and Samson et Dalila.

Has performed in many of Russia?s greatest concert venues and abroad with singers such as Maria Bieshu, Lyubov Kazarnovskaya, Vladimir Galuzin and Larisa Diadkova.
At the Mariinsky Theatre, works with soloists including Olga Borodina, Nikolai Putilin, Tatiana Novikova, Larisa Diadkova, Vladimir Galuzin, Alexander Gergalov, Irina Gordei, Gennady Bezzubenkov and Sergei Alexashkin.
Also works with young Mariinsky Theatre singers, among them Mikhail Petrenko, Yevgeny Nikitin, Irina Mataeva and Tatiana Pavlovskaya.

In 1996, worked at Tel Aviv?s International Vocal Arts Institute, where she collaborated on a production of the opera Iolanta.
Has toured with the Mariinsky Theatre to the USA, Great Britain, Germany, Italy, Belgium, the Netherlands, Spain and Israel.

© State Academic Mariinkiy Opera and Ballet theatre