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





	Giovanna Avanzi (Costume Designer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Giovanna Avanzi (Costume Designer)

Giovanna Avanzi (Costume Designer)

Born in Milan. Studied at the Brera Academy of Fine Arts in Milan. Subsequently completed a specialised course in set and stage costume design at La Scala. Started working as an independent set designer with Haydn?s opera L?isola disabitata at Milan?s Litta Theatre and Paisiello?s La Molinara at La Scala. Has worked for various opera houses in Italy on productions of Gluck?s L?оle de Merlin, Mozart?s The Magic Flute and Massenet?s Don Quixote. Worked as assistant costume designer with director Hugo De Ana on productions of Verdi?s Nabucco and Don Carlos. Was also head of the sewing workshop at Verona?s Arena. Worked as costume designer with director Walter Le Molly in the course of last year. Productions staged in co-operation with him include a contemporary musical and Moliere?s comedy George Dandin and the operas Cosi fan tutte and Il trittico.

© State Academic Mariinkiy Opera and Ballet theatre