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





	Igor Grinevich (Set  Designer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Igor Grinevich (Set Designer)

Igor Grinevich (Set Designer)

Recipient of the State Prize of Russia.
Honoured Artist of Russia.

Since 1985 has been Principal Designer of the Novosibirsk State Academic Theatre of Opera and Ballet. Prior to Novosibirsk, he worked as Principal Designer for the Chelyabinsk State Theatre of Opera and Ballet, the Komi State Musical Theatre and theatres in Moscow, Oryol, Krasnodar, Kazan, Ufa, Yerevan and Alma-Ata. He has been invited to stage works in Japan and Egypt numerous times. Has created the sets and costumes for over one hundred productions in various genres including opera, ballet, drama, operetta and gala concerts. He mostly works on operas and ballets, throughout Russia and abroad.
Among works he has designed for the Novosibirsk Academic Theatre of Opera and Ballet are Hot Snow, Les Contes d?Hoffmann, Il barbiere di Siviglia, Prince Igor, La traviata, La boheme , Young David, Rusalka, La voix humaine, The Tsar?s Bride, Carmen, Rigoletto, Peer Gynt, Coppelia, Stepan Razin, Swan Lake, The Sleeping Beauty, The Nutcracker, The Marriage of Balzaminov and Bournonville?s Conservatoire, or Caprices of a Ballet-master.
Igor Grinevich has worked with such directors as Bargatuni, Alexandrov, Isaakian, Raku and Chernyakov and choreographers including Gusev, Aleksidze, Gordeyev, Budarin and Vikharev. In addition to work for theatre, Igor Grinevich also does painting and graphics, and has taken part in exhibitions in Moscow and Germany. Many works by Igor Grinevich are in private collections both in Russia and abroad.
Performances designed at the Mariinsky Theatre: Carmen (production by Alexei Stepanyuk, 2005).

© State Academic Mariinkiy Opera and Ballet theatre
Recipient of the State Prize of Russia.
Honoured Artist of Russia.

Since 1985 has been Principal Designer of the Novosibirsk State Academic Theatre of Opera and Ballet. Prior to Novosibirsk, he worked as Principal Designer for the Chelyabinsk State Theatre of Opera and Ballet, the Komi State Musical Theatre and theatres in Moscow, Oryol, Krasnodar, Kazan, Ufa, Yerevan and Alma-Ata. He has been invited to stage works in Japan and Egypt numerous times. Has created the sets and costumes for over one hundred productions in various genres including opera, ballet, drama, operetta and gala concerts. He mostly works on operas and ballets, throughout Russia and abroad.
Among works he has designed for the Novosibirsk Academic Theatre of Opera and Ballet are Hot Snow, Les Contes d?Hoffmann, Il barbiere di Siviglia, Prince Igor, La traviata, La boheme , Young David, Rusalka, La voix humaine, The Tsar?s Bride, Carmen, Rigoletto, Peer Gynt, Coppelia, Stepan Razin, Swan Lake, The Sleeping Beauty, The Nutcracker, The Marriage of Balzaminov and Bournonville?s Conservatoire, or Caprices of a Ballet-master.
Igor Grinevich has worked with such directors as Bargatuni, Alexandrov, Isaakian, Raku and Chernyakov and choreographers including Gusev, Aleksidze, Gordeyev, Budarin and Vikharev. In addition to work for theatre, Igor Grinevich also does painting and graphics, and has taken part in exhibitions in Moscow and Germany. Many works by Igor Grinevich are in private collections both in Russia and abroad.
Performances designed at the Mariinsky Theatre: Carmen (production by Alexei Stepanyuk, 2005).

© State Academic Mariinkiy Opera and Ballet theatre