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





	Irkin Gabitov (Director) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Irkin Gabitov (Director)

Irkin Gabitov (Director)

Director

Graduated from the Musical Theatre Directing Faculty of the Leningrad Conservatoire (course of Professor Tikhomirov and I. Glikman).
Director

Graduated from the Musical Theatre Directing Faculty of the Leningrad Conservatoire (course of Professor Tikhomirov and I. Glikman).
Principal Director of the Kazakh Abai Theatre of Opera and Ballet (Alma-Ata) from 1984 to 1988, where he staged the operas Maria Stuardo, Eugene Onegin, Carmen and Oratorio Pathetique.

Stage Director at the Mariinsky Theatre since 1988. Has staged the operas Kashchei the Deathless, Tosca and Prince Igor (complete original version). Worked as assistant director on the opera War and Peace (at the Mariinsky Theatre in 2000 and at the Metropolitan Opera in 2002).

At Mariinsky Theatre festivals and on tour, he has staged Prince Igor (Greece), Don Carlo (Genova, Italy), Salammbo (Merida, Spain), Tosca and Prince Igor (Savonlinna, Finland) and Maddalena (Mikkeli, Finland).

His most recent work for the Mariinsky Theatre was an open-air production of the opera Turandot in Vyborg (2002).