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





	Ivan Vasiliev (Choreography) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Ivan Vasiliev (Choreography)

Ivan Vasiliev (Choreography)

Born in Vladivostok, he studied at the Dnepropetrovsk Ballet School in Ukraine and later at the Belarus State Ballet School in Minsk, graduating in 2006. While still a student, Vasiliev danced Basilio in Don Quixote and Ali in Le Corsaire with the Belarus National Ballet. In 2006, he was invited to join the Bolshoi Ballet as a Soloist, making his debut with the Company, at the age of 17, as Basilio in Don Quixote. He was promoted to Principal Dancer in 2010. In 2011, he joined the Mikhailovsky Ballet as a Principal Dancer. Vasiliev’s repertoire with the Mikhailovsky includes principal roles in Don Quixote, Giselle, The Sleeping Beauty, Romeo and Juliet, La Fille mal gardée, La Bayadère, Laurencia, La Sylphide, The Flames of Paris, Le Halte de cavalerie, and Class Concert. His awards include medals at the international ballet competitions in Varna, Moscow, and Perm. He is also the winner of the Triumph Youth Prize, British Critics’ Circle National Dance Awards in the category Spotlight and as Best Male Dancer, and the Benois de la Danse Award for his performance in Le Corsaire and The Flames of Paris (2009). In 2011, he received Grand Prix at the International Dance Open Festival. In 2014, he was awarded the title of Honored Artist of Russia.