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





	Jonathan Kent (Stage Director) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Jonathan Kent (Stage Director)

Jonathan Kent (Stage Director)

Jonathan Kent established the Almeida Theatre as a full-time producing house with Ian McDiarmid in 1990. He was joint artistic director for 12 years. His productions included: Ibsen´s When We Dead Awaken, Dryden´s All for Love, Euripides´ Medea (also West End and Broadway), Anthony Burgess´ new version of Griboyedov´s Chatsky, Bernhard´s The Showman, Moliere´s The School for Wives, Louis Mellis and David Scinto´s Gangster No. 1, Moliere´s Tartuffe, David Hare´s versions of The Life of Galileo, The Rules of the Game, Ivanov, John Byrne´s version of Gogol´s The Government Inspector, Nicholas Wright´s version of Pirandello´s Naked and Shakespeare´s The Tempest. His production of Hamlet also opened at the Hackney Empire, before transferring to Broadway.
Jonathan directed Richard II and Coriolanus in repertoire for the Almeida at Gainsborough Studios. The two productions toured to New York and Tokyo.
In 1998 Jonathan opened a season for the Almeida at the Albery Theatre in the West End with two Racine tragedies in repertoire – Phиdre (in a new version by Ted Hughes) and Britannicus, both of which toured to New York. He closed the season with his revival of David Hare´s Plenty.
The Almeida at King´s Cross season opened in 2001 with Jonathan´s production of Lulu by Frank Wedekind, (also Kennedy Centre, Washington DC). Other King´s Cross productions included David Hare´s new version of Chekhov´s Platonov, Faith Healer by Brian Friel and King Lear.
Other theatre credits include Corneille´s Le Cid David Hare´s new version of Brecht´s Mother Courage and her Children and Martin Crimp´s new version of Marivaux The False Servant, all for the National Theatre.
He directed Man of La Mancha on Broadway (2002), Hamlet in Japan and London (2003), Hecuba at the Donmar Warehouse (2004), Edward Bond´s Lear at the Sheffield Crucible (2005) and Hugh Whitemore´s new version of Pirandello´s As You Desire Me in the West End (2005/6) and Brian Friel´s Faith Healer on Broadway (2006). Operas include: Katya Kabanova at Santa Fe (2003), A Child of our Time at the ENO (2005), Lucio Silla Santa Fe (2005), Tosca Royal Opera House (2006) and Tom Ades´s The Tempest Santa Fe (2006).
Current projects include Elektra (Mariinsky), The Turn of the Screw (Glyndebourne), a season at the Haymarket, The Marriage of Figaro and The Letter (Santa Fe), Oedipus (National) and The Fairy Queen (Glyndebourne).