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





	Peter J. Hall (Costume Designer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Peter J. Hall (Costume Designer)

Peter J. Hall (Costume Designer)

Born in Bristol, Great Britain. Studied at the West of England College of Art in Bristol. Made his professional debut in Zeffirelliґs production of Romeo and Juliet at the English National Opera in 1959. He has subsequently worked with the Royal Shakespeare Company, the American Ballet Theatre, the Chicago Lyric Opera, Covent Garden (costumes for Otello, Simon Boccanegra and Stiffelio) and the Metropolitan Opera (costumes for Aida, La bohиme, Boris Godunov, Ernani, La forza del destino, Lohengrin, Otello, I puritani, Tosca, Un ballo in maschera and Die Fledermaus).At the Dallas Opera he has designed over forty productions. He has worked in major cities such as Milan (La Scala), Vienna (Staatsoper), Buenos Aires, Sidney, Venice and Rome. He has received awards in the USA, Italy and Argentina.