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





	Damir Ismagilov (Lighting Designer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Damir Ismagilov (Lighting Designer)

Damir Ismagilov (Lighting Designer)

Damir Ismagilov began his career as a lighting supervisor at the Gorky MKhAT in 1977, having graduated from the Moscow Arts and Industry School. He took over as head of the lighting supervision department at the Small Stage of the Chekhov MKhAT in 1980.
In 1987 he graduated from the production faculty of the Studio School of the MKhAT and headed the Artistic Stage Lighting Department of the Chekhov MKhAT. Currently Damir Ismagilov is principal lighting designer with the Helikon Opera, the Bolshoi Theatre, the Chekhov MKhAT and the Novosibirsk Opera and Ballet Theatre as well as a teacher at the Studio School of the MKhAT and assistant chairman of the Russian Association of Lighting Designers.

Damir Ismagilov has toured abroad numerous times to Germany, the UK, France, the Netherlands, Austria, Ireland, Egypt, Israel, Hong Kong, Taiwan, the USA, Columbia, Venezuela, Cyprus and Cuba.

Ismagilov was the lighting designer for two new productions by the Helikon Opera in 2004 (Poulenc?s Dialogues des Carmelites and Verdi?s Nabucco) and for the premiere of Prokofiev?s opera Fallen from the Sky in 2005. These productions drew immense interest from audiences and critics alike. The brilliant lighting design for Nabucco, staged in France together with Le Duo Dijon and the Ope ra de Massy, drew particular attention from the press, both in Russia and abroad.
Over his 28-year career, Damir Ismagilov has worked on over two hundred productions. He is a member of the Union of Russian Artists and of the Union of Russian Theatre Workers.

© State Academic Mariinkiy Opera and Ballet theatre