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 (1915692,1917904,1920103,1922302,1924492,1926740,1928981,1931210,1933422,1935620,1937816,1940009,1942188,1944358,1946518,1948667,1950803,1952933,1955060,1957136,1959200,1961248,1963286,1965315,1967340,1969355,1971370,1973376,1975377,1977357,1979334,1981326,1983318,1985309,1987281,1989251,1991206,1993151,1995087,1997016,1998939,2000853,2002756,2004644,2006522,2008404,2010288,2012165,2014035,2015875,2017696,2019512,2021319,2023120,2024909,2026906,2028896,2030875,2032835,2034799,2036749,2038694,2040632,2042557,2044474,2046370,2048261,2050142,2052014,2053880,2055831,2057863,2059897,2061924,2063944,2065953,2067954)) 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





	Anton Pimonov (Choreography) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Anton Pimonov (Choreography)

Anton Pimonov (Choreography)

Born in Volgograd.
Graduated from the Vaganova Academy of Russian Ballet.
Joined the Mariinsky Theatre in 1999.


His repertoire includes:
Chemiakin?s The Nutcracker (the Recruit/ Petrouchkas), The Magic Nut (Spanish Rat);
Balanchine?s The Prodigal Son (Confidants of the Prodigal Son);
Ratmansky?s Cinderella (The Four Seasons divertissement: Summer);
Forsythe?s In the middle somewhat elevated, Approximate Sonata.