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





	Georgy Aleksidze (Choreography) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Georgy Aleksidze (Choreography)

Georgy Aleksidze (Choreography)

(b Tbilisi, 7 Jan. 1941)

Soviet-Georgian dancer and choreographer. He studied at Moscow Ballet School with A. Messerer and made his debut at the Tbilisi Opera in 1961. He then went to study at the Choreographers' Faculty of Leningrad Conservatory with F. Lopukhov and created his first ballet in 1966 for the newly created Chamber Ballet. Inspired by New York City Ballet's first visit to the Soviet Union in 1962 he was one of the first Soviet choreographers to create plotless ballets, though his output has also included several dramatic works. In 1968 he created Oresteia (mus. Falik) for the Kirov followed by The Scythian Suite (mus. Prokofiev, 1969). From 1967 he also taught at the Leningrad Conservatory and from 1972 to 1980 he was artistic director and chief choreographer of the Tbilisi Opera Ballet. His many works for the company included Variations on a Theme by Mozart (mus. Chopin), Classical Symphony (mus. Prokofiev), and Berikoaba (mus. Kvernadse, all 1973), Coppйlia (1975), Nutcracker (1977), and Medea (mus. Gabichvadze, 1978). From 1980 to 1983 he was chief choreographer at Perm Theatre of Opera and Ballet, after which he worked at the opera studio of the Leningrad Conservatory (1983–5). In 1985 he returned to Tbilisi where he created several works including Swan of Tuonela (mus. Sibelius, 1988) and Concerto Grosso (mus. Schnitke, 1989). In 1992 he founded a small company attached to the St Petersburg Cappella for which he choreographed many works.