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

	Roberto Aldorasi (Choreography) - uVisitRussia



Home Theaters Roberto Aldorasi (Choreography)

Roberto Aldorasi (Choreography)

Stage director, choreographer and theatre teacher Roberto Aldorasi studied folk dance history under Giuseppe Gala and took degrees in Theatre Anthropology and the History of Musical Theatre at the universities of Naples and Rome. Aldorasi gained his first experience as a theatre director under the guidance of Francesco Niccolini. He subsequently worked at the Odin Teatret in Holstebro (Denmark) together with Tage Larsen and Donald Kitt; he has worked on productions by Eugenio Barba of Ur-Hamlet and The Marriage of Medea among other theatre projects. In 2008 together with Pierangelo Pompa the choreographer founded the company Laboratorio di Altamira. Aldorasi has widely travelled throughout the Far East and the Pacific, studying the theory and technique of oriental theatre. He stages amateur performances and street dance shows in Italy, Denmark, France, Great Britain, Spain, Morocco, Senegal, Lebanon, Syria, the USA and Brazil.