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





	Vyacheslav Okunev (Set  Designer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Vyacheslav Okunev (Set Designer)

Vyacheslav Okunev (Set Designer)

Born in Leningrad. Studied at the Leningrad State Institute of Theatre, Music and Cinematography (studio of I. Segal). While still a student, was invited to work with the Maly Opera and the Kirov Theatres. Has worked as a set and costume designer on over two hundred productions since 1975.

© State Academic Mariinkiy Opera and Ballet theatre
Born in Leningrad. Studied at the Leningrad State Institute of Theatre, Music and Cinematography (studio of I. Segal). While still a student, was invited to work with the Maly Opera and the Kirov Theatres. Has worked as a set and costume designer on over two hundred productions since 1975.

Major works include: Love for Three Oranges, Sadko (after sketches by K. Korovin), Le nozze di Figaro, Mazepa (after sketches by A. Konstantinovsky), Khovanshchina and Petrouchka at the Mariinsky Theatre; La Sylphide and Russian Hamlet at the Bolshoi Theatre; Eugene Onegin and The Falcon at the St Petersburg Chamber Opera Company; recent productions of the Boris Eifman State Academic Ballet Theatre; and Tosca, Carmen, La traviata and Rigoletto at the State Academic Musorgsky Theatre of Opera and Ballet. Over the years he has worked with the Theatre Royal in Glasgow, the Greek National Opera, the National Theatres in Seoul and Tokyo and the Teatro Cagliari in Italy.

© State Academic Mariinkiy Opera and Ballet theatre