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





	Adam Silverman (Lighting Designer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Adam Silverman (Lighting Designer)

Adam Silverman (Lighting Designer)

Adam Silverman works in opera, theatre and dance.

Recent productions include The Bull and Giselle for the Fabulous Beast Dance Theatre; Siegfried with English National Opera; Das Schatzgraber for Oper Frankfurt; The Queen of Spades for the Bayerische Staatsoper; One Touch of Venus and the Eight Little Greats season at Opera North; the premiere of the play Five Gold Rings for the Almeida Theatre; Imeneo for Glimmerglass Opera; Jenufa for Houston Grand Opera; La traviata for the New Israeli Opera; the premiere of the musical Beauty and the Beast for the Royal Shakespeare Company and the play A Day in the Death of Joe Egg on Broadway.


© State Academic Mariinkiy Opera and Ballet theatre