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





	Kirill Serebrennikov (Stage Director) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Kirill Serebrennikov (Stage Director)

Kirill Serebrennikov (Stage Director)

Stage Director
Costume Designer

Born in Rostov on Don in 1969.
Stage Director
Costume Designer

Born in Rostov on Don in 1969. Has worked in Rostov on Don since 1994. In Moscow he staged the first production of Sigarev?s Plasticine at the Centre of Drama and Directing under Alexander Kazantsev and Mikhail Roshchin. Other works staged in Moscow include Ravenhill?s Some Explicit Polaroids (Pushkin Theatre), the Presnyakov brothers? Terrorism and Playing the Victim, Gorky?s Meshane, Ostrovsky?s The Forest, Saltykov-Shchedrin?s The Golovlevs (Chekhov MKhAT (Moscow Artistic Academic Theatre)), Tennessee Williams? Sweet Bird of Youth, Kononov?s The Naked Pioneer (Sovremennik Theatre), Larsson?s AD (Centre of Drama and Directing under Alexander Kazantsev and Mikhail Roshchin), Lermontov?s The Demon (814 Theatre Association) and Honneger?s Jeanne d‘Arc au bucher (Moscow International House of Music as part of the festival Vladimir Spivakov Invites...).

Since 1991 he has worked in television and since 1998 in cinema. Has directed the films The Swallow, Secrets of Thunderstorm, Rostov-Papa, Naked, Diary of a Murderer and Bed Stories.
In 1999 Kirill Serebrennikov was awarded the TEFI National Television Prize. Recipient of the Triumph youth prize (2001), the Stanislavsky Prize (2005) and the Seagull and Crystal Turandot theatre prizes.