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 Simonov (Choreography) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Kirill Simonov (Choreography)

Kirill Simonov (Choreography)

Born in Petrozavodsk in 1975.
Graduated from the Vaganova Academy of Russian Ballet in 1995 (class of Vladilen Semenov) as well as the Academy?s choreography department (course of Professor Belsky).
Joined the Mariinsky Theatre in 1995.
Prize-winner at the Vaganova Prix competition in 1998.
Prize-winner at the Fyodor Lopukhov Choreography Competition in 1999 (Special Jury Prize for best musical decision for While You Were Asleep to music by Arvo Part.
Born in Petrozavodsk in 1975.
Graduated from the Vaganova Academy of Russian Ballet in 1995 (class of Vladilen Semenov) as well as the Academy?s choreography department (course of Professor Belsky).
Joined the Mariinsky Theatre in 1995.
Prize-winner at the Vaganova Prix competition in 1998.
Prize-winner at the Fyodor Lopukhov Choreography Competition in 1999 (Special Jury Prize for best musical decision for While You Were Asleep to music by Arvo Part.

At the Mariinsky Theatre he has performed the following roles:
Swan Lake (Jester), Romeo and Juliet (Jester), Nutcracker-doll (Simonov and Chemiakin?s staging of The Nutcracker), the Dance of the Jesters (The Legend of Love), Bandit (Roland Petit?s Carmen) and The Four Seasons Divertissement: Autumn (Alexei Ratmansky?s staging of Cinderella).
At the Novosibirsk Theatre of Opera and Ballet he staged the ballet Sonata to music by Scarlatti as well as the dances for Poulenc?s opera La Voix humaine.
At the Mariinsky Theatre he has staged the dances for Giuseppe Verdi?s Otello, directed by Yuri Alexandrov (2001), the one-act ballet Come in! and two ballets based on works by E. T. A. Hoffmann together with Mihail Chemiakin (costumes, sets and staging) - The Nutcracker (2001) and Princess Pirlipat, or Worthiness Punished (2003).
His ballet Madame Lionelli to music by Gavin Bryars and John Adams was premiered at the Albert Hall, London, in 2003.
In 2004, he staged the ballet Pulcinella to music by Stravinsky for the Novosibirsk Theatre of Opera and Ballet.
In 2004, he staged the dances for Poulenc?s opera La Voix humaine for the Karelia Musical Theatre (Petrozavodsk).


© State Academic Mariinkiy Opera and Ballet theatre