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





	Roland Olbeter (Set  Designer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Roland Olbeter (Set Designer)

Roland Olbeter (Set Designer)

Scenographer and rob art. Lives and works in Barcelona since 1986.

Formally trained as a concert violinist and naval constructor, has worked extensively for the theatre, the opera, as well as for sound and movement installations.

His work has a technical sophistication most uncommon in the visual art and theatre. He was a Maat Collective Member together with Franc Aleu and Pere Tantiсб. His work focuses on the creation of impossible artefacts. He has collaborated in multiple scenography from the Barcelona Olympic games in 92, to collaborations with Bigas Luna, Jaume Plensa, Alfred Arribas, Enric Miralles and Xavier Mariscal, among others. He has designed many main pieces for La Fura dels Baus and Marcel·lн Antъnez.

He developed and directed the chamber opera Orlando Furioso for 5 music robots and soprano with music by Michael Gross.

He designed the thematic Pavillon OIKOS for EXPO 2008 in Zaragoza and is realising the 4 operas by Richard Wagner The Ring of the Nibelung, together with Carlos Padrisa and Franc Aleu.

At this moment he is preparing an automatic puppet theatre situated in a container with music by Kats Chernin

Roland Olbeter official website www.olbeter.com