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





	Dmitry Belyanushkin (Stage Director) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Dmitry Belyanushkin (Stage Director)

Dmitry Belyanushkin (Stage Director)

Born in Saransk.
In 2012 he completed his studies at the Russian Academy of the Performing Arts (GITIS) (faculty of music theatre, Alexander Titel and Igor Yazulovich studio), and started post graduate work.
In 2011, he produced Monteverdi’s opera L’incoronazione di Poppea at the GITIS Academic Theatre (together with Tatiana Mitkalyova and Murat Kalovy).

In 2011 and 2012, he participated in the Creative Laboratories of Opera House Producers under the direction of Olga Ivanova (Moscow) and in the Laboratory-Training for Young Opera Producers (Krasnoyarsk).

Since 2011, he has been collaborating with the Stanislavsky and Nemirovich-Danchenko Music Theatre.
As assistant producer he took part in the Theatre’s productions of the following operas: Mozart’s Die Zauberfloete (director Alexander Titel, 2011) and Prokofiev’s War and Peace (director Alexander Titel, 2012).
He did productions of Elena Langer’s opera Songs at the Well (world premiиre) and Lera Auerbach’s opera The Blind (Russian premiиre), under the auspices of the Laboratory of Contemporary Opera project (2012). He was the director of the following concerts of old music: Pleasures of Versailles, From Telemann to Sans-Souci, Under the Patronage of the Muses (2012).

In 2012, he did a production of Poulenc’s opera La voix humaine for the Voronezh State Theatre of Opera and Ballet.

In 2013, he produced The Queen of Spades for the Yakushev State Music Theatre (Saransk) and he also produced the Christmas Concert at the Ekaterinburg Theatre of Opera and Ballet.

He was a recipient of the Grand prix at the NANO-opera (2013), 1st International Competition of Young Opera Producers.