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





	Christoph Forey (Lighting Designer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Christoph Forey (Lighting Designer)

Christoph Forey (Lighting Designer)

Lighting Designer

Born in France, Christoph Forey has designed the lighting for numerous opera, dance and theatre productions since 1985.
Theatre credits with director Bruno Boeglin include such productions as Roberto Zucco by Bernard-Marie Koltes.

Lighting Designer

Born in France, Christoph Forey has designed the lighting for numerous opera, dance and theatre productions since 1985.
Theatre credits with director Bruno Boeglin include such productions as Roberto Zucco by Bernard-Marie Koltes.

Since his first collaboration in 1996 on a production of Hamlet at the Grand Theatre de Geneve, he has worked with directors Patrice Caurier and Moshe Leiser on a number of other opera productions including Carmen, Fidelio, Mahagonny, Leonore, Der Rosenkavalier, Ariane et Barbe-Bleue, Jenufa and Der Ring des Niebelungen at the Grand Theatre de Geneve, Orphee et Euridyce and La cenerentolaat the Royal Opera House in London, The Nose by Shostakovich at the Opera de Lausanne and Lucia di Lammermoor at the Theatre du Chatelet.
He has also worked with directors Silviu Purarete (Parsifal in Edinburgh with Scottish Opera)and Gunther Kramer (Ariadne auf Naxos at the Theatre du Chatelet, Paris).