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





	Gleb Filshtinsky (Lighting Designer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Gleb Filshtinsky (Lighting Designer)

Gleb Filshtinsky (Lighting Designer)

Born in Leningrad. Graduated from the stage direction faculty of the St Petersburg Academy of Theatrical Art, specialising in theatre set design.
Has worked as a lighting designer on over 190 music and drama productions in Russia and abroad. Has created the lighting for numerous show programmes and light and pyrotechnic shows. Over the years, he has worked as principal lighting designer with the St Petersburg Theatre of Youth Art, the St Petersburg Bryantsev Young Spectators? Theatre, the St Petersburg Drama and Comedy Theatre on Liteiny and the Tovstonogov Bolshoi Drama Theatre.


© State Academic Mariinkiy Opera and Ballet theatre
Born in Leningrad. Graduated from the stage direction faculty of the St Petersburg Academy of Theatrical Art, specialising in theatre set design.
Has worked as a lighting designer on over 190 music and drama productions in Russia and abroad. Has created the lighting for numerous show programmes and light and pyrotechnic shows. Over the years, he has worked as principal lighting designer with the St Petersburg Theatre of Youth Art, the St Petersburg Bryantsev Young Spectators? Theatre, the St Petersburg Drama and Comedy Theatre on Liteiny and the Tovstonogov Bolshoi Drama Theatre.
In 1996, together with Yevgeny Ginsburg, he established the creative workshop Lighting for Theatre.

Gleb Filshtinsky?s works have been awarded numerous prizes, among them:
• the Latvian National Prize for Theatre (Teresa Racken, Dailas Theatre, Riga, 1996),
•the St Petersburg STS TV channel prize (The Little Chestnut Tree, St Petersburg Drama and Comedy Theatre on Liteiny, 1997),
•the St Petersburg Teatral society prize (Lost in the Stars, St Petersburg Drama and Comedy Theatre on Liteiny and Fedra, St Petersburg Tovstonogov Bolshoi Drama Theatre, 2000),
•the National Prize of Estonia for Theatre (Fathers and Sons, Drama Theatre, Tallinn, 2003),
• the Golden Mask, Russia?s highest theatre prize (The Rake?s Progress, Bolshoi Theatre, Moscow, 2004).

Currently works with both the Mariinsky and the Alexandrinsky Theatres. His most recent works at the Mariinsky Theatre include The Legend of the Invisible City of Kitezh and the Maiden Fevronia (Musical Director and Conductor: Valery Gergiev; Stage Director and Designer: Dmitry Chernyakov, 2001), Otello (Musical Director and Conductor: Valery Gergiev; Stage Director: Yuri Alexandrov, 2001), Boris Godunov (Musical Director: Valery Gergiev; Stage Director: Viktor Kramer, 2002), Der Ring des Nibelungen (Artistic Supervisor of the productions: Valery Gergiev, 2002-2003), The Nose and The Tsar?s Bride (Musical Director and Conductor: Valery Gergiev; Stage Director: Yuri Alexandrov, 2004), The Snow Maiden (Musical Director and Conductor: Valery Gergiev; Stage Director: Alexander Galibin, 2004), Carmen (Musical Director and Conductor: Valery Gergiev; Stage Director: Alexei Stepanyuk, 2005) and Tristan und Isolde (Musical Director and Conductor: Valery Gergiev; Stage Director: Dmitry Chernyakov, 2005).

Member of the Union of Theatre Workers of Russia and the All-Russian Association of Lighting Designers.


© State Academic Mariinkiy Opera and Ballet theatre