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.date>='2024-04-22' AND tmp.date<='2024-05-12' AND tmp.perf_id=224) ORDER BY date ASC, ves DESC, time ASC
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

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.date>='' AND tmp.date NOT BETWEEN '2024-04-22' AND '2024-05-12' AND tmp.perf_id=224) ORDER BY date ASC, ves DESC, time ASC
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

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.date>='' AND tmp.perf_id<>224 AND tp.id_base=171 AND tmp.city_id=1 ORDER BY date ASC, ves DESC, time ASC
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

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.date>='' AND tmp.perf_id<>224 AND tp.id_base=171 AND tmp.city_id=2 ORDER BY date ASC, ves DESC, time ASC
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





	,  - Swan Lake - P.Tchaikovsky (Ballet in three acts).The State Classic Ballet Theatre - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Moscow theatre "New Opera" , - Swan Lake - P.Tchaikovsky (Ballet in three acts).The State Classic Ballet Theatre
|
Classical ballet
Moscow theatre "New Opera", Moscow
Duration: 2 hours 40 minutes

There’s a good reason why Swan Lake is so often called the ‘ballet of all ballets’. The combination of pure romanticism, the story about love and deception and Tchaikovsky’s famous ballet music all continue to reach new generations of audiences. Swan Lake was Pyotr Il’yich Tchaikovsky's first score for ballet. Its 1877 premiere was poorly received, but it has since become one of the most loved of all ballets. The twinned role of the radiant White Swan and the scheming, duplicitous Black Swan tests the full range of a ballerina's powers, particularly in the two great pas de deux of Acts II and III. Other highlights include the charming Dance of the Little Swans performed by a moonlit lake and sweeping ballroom waltzes in the splendour of the royal palace.

Choreographic version by Nataliya Kasatkina, Vladimir Vasilyov
Set Designer: Tim Goodchild
Costume Designer: Kim Baker
The Orchestra of the Novaya Opera Theatre
Conductors: Vasily Valitov, Evgeny Samoilov, Valery Kritskov


The Kasatkina and Vasilyov State Academic Classical Ballet Theatre(Moscow Classical Ballet)

This production was premiered in 1988 during a tour of the State Academic Theatre of Classical Ballet in Great Britain. This was the first Anglo-Russian joint production in the history of Russian ballet. The choreographic version and performance were done by the Russian side, the State Academic Theatre of Classical Ballet.
The set design was made by Tim Goodchild, one of the most renowned British designers, while Kim Baker was responsible for the costumes.
The main roles in the first showing were performed by Vera Timashova and the brilliant Vladimir Malakhov.
More than thirty years ago Great Britain applauded the Bolshoi Theatre’s production of Swan Lake, which is known in Russia as “old Moscow Swan Lake” (choreography by Marius Petipa, Lev Ivanov, Alexander Gorsky, Asaf Meserer). This nearly forgotten version of the ballet became the basis for the production by the State Academic Theatre of Classical Ballet. Many marvelous “pieces” of the old version of Swan Lake were carefully reconstructed,as were the original ideas of Marius Petipa in the first act of the ballet. The newly created parts delicately and thoughtfully follow the style of the famous production.
While preparing the production Natalia Kasatkina and Vladimir Vasilyov consulted with Nikolay Fadecheev (one of the best-known Princes of the Bolshoi Theatre), the famous ballerina Marina Semenova and Asaf Meserer.
Russian ballet critic Elena Lutskaya described the producers’ work as “a lesson in modern treatment of classical heritage”.
The production has successfully been shown in the USA, Turkey, Japan, France, and Italy.