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





	Sergei Gritsai (Choreography) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Sergei Gritsai (Choreography)

Sergei Gritsai (Choreography)

• Honoured Artist of the Russian Federation
• Recipient of the State Prize of Russia
• Prize-winner at All-Union Choreographersґ Competitions (1984, 1988)
• Recipient of the Golden Mask prize for the production of Lost in the Stars (Theatre on Liteiny)

Graduated from the Vaganova Academy of Russian Ballet and from the choreography department of the Leningrad State Rimsky-Korsakov Conservatoire in 1984, in addition to completing Advanced Directing Courses of the Ministry of Culture in 1986.
Has worked with directors including Grigory Kozlov, Grigory Dityatkovsky, Alexander Galibin and Sergei Spivak as well as Andrei Konchalovsky and Yuri Alexandrov and conductor Valery Gergiev at the Mariinsky Theatre.
Has worked with theatres in Germany, the Netherlands, Switzerland, the UK, Italy, Spain and the USA.