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





	Zinovy Margolin (Set  Designer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Zinovy Margolin (Set Designer)

Zinovy Margolin (Set Designer)

Recipient of the silver medal at the International exhibition of stage design Prague Quadrennial (1995).
Recipient of Russia?s theatre prize the Golden Mask (2005).
Recipient of the Golden Sofit (2004).

Graduated from the Byelorussian Academy of Arts in 1982. Was engaged as the principal designer with the Byelorussian Youth Theatre and has designed productions for the Moscow Russian Army Theatre (The Winded Horse) and St Petersburg?s Grand Drama Theatre (Les Caprices de Marianne, Californian Suite and The Dresser).
From 1998 to 2000, was the principal designer with the St Petersburg Chamber Opera Company, where he designed productions including Die Weise von Liebe und Tod des Cornets Christoph Rilke and The Queen of Spades.
Among his most recent works are Boris Godunov (National Academic Opera Theatre of the Republic of Byelorussia, 2001), the musical Nord-Ost (Moscow, 2002), Le Boulevard du Crime (Yevgeny Vakhtangov Theatre, 2003), Il barbiere di Siviglia (Rostov Musical Theatre, 2003), Lady Macbeth of Mtsensk (Rostov Musical Theatre, 2004) and The Rape of Lucretia (St Petersburg Chamber Opera, 2004).
His works for the Mariinsky Theatre: The Nose (2004), The Tsar?s Bride, with Dmitry Chernyakov - Tristan und Isolde (2005).