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-05-21' AND tmp.date<='2024-06-10' AND tmp.perf_id=2025) 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-05-21' AND '2024-06-10' AND tmp.perf_id=2025) 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<>2025 AND tp.id_base=2028 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<>2025 AND tp.id_base=2028 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" ballet in three acts. St. Petersburg Tchaikovsky Ballet Theatre - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Moscow Moscow theatre "New Opera" ,  - "Swan Lake" ballet in three acts. St. Petersburg Tchaikovsky Ballet Theatre
			

			
				


    

        

        

        
 | 

    

    

        
"Swan Lake" ballet in three acts. St. Petersburg Tchaikovsky Ballet Theatre

        
Classical ballet

	
Moscow theatre "New Opera", Moscow

            

    

            

    





        
    
Go to events list (All venues, -2)



    

        
St. Petersburg Tchaikovsky Ballet Theatre
Conductor Vasily Valitov
Choreographers Marius Petipa, Lev Ivanov
Recommended for 6+
Act I
Scene one
The terrace of the castle is filled with joy and merriment — Prince Siegfried is celebrating his coming of age, his courtiers congratulate him while his mischievous jester entertains the assembled guests. The servants announce the arrival of his mother the queen, she presents her son with a crossbow for the hunt. The queen reminds her son that at tomorrow coming of age ball he will have to choose a bride. The night is approaching fast and when the guests are gone, Siegfried is finally left alone with his thoughts and premonitions of what the future may bring. In the twilight, a flock of swans pass over and he rushes to the lake.
 
Scene two
At the lake in the heart of the forest, the swans step ashore and turn into beautiful young girls. About to draw his crossbow, Siegfried stops fascinated by their beauty. Odette the swan princess is startled by Siegfried’s presence, he assures her no harm will come to her. Odette tells him of her terrible plight. She tells him of her high birth and how she has fallen under the spell of being a swan and only in the hours of darkness she is able to assume her human form. She tells him she is bound to be a swan for eternity by the spell unless an unblemished youth swears his eternal fidelity and marries her. Siegfried realizes his destiny has changed. The day is breaking, the swans are swimming again on the lake, Odette bids a sad farewell, Siegfried is left desolate.
 
Act II
Scene three
The coming of age ball commences at the castle. The young noblewomen whom the Queen has chosen as prospective brides are presented to Prince Siegfried, he shows no interest thinking only of Odette. The entertainment and merrymaking continue and a fanfare announces the arrival of more guests. Wicked wizard Rothbart disguised as a knight sweeps in with his daughter Odille, Siegfried is dazzled by her beauty and her resemblance to Odette. Bewitched and tempted by her charms he swears his love and fidelity to her. Henceforth she is regarded as his bride. Rothbart the sorcerer triumphs in his deception. Siegfried horrified at what he has done rushes from the ball and into the night.
 
Act III
Scene four
At the lakeside Odette tells her fellow swans of Rothbart’s devilish trickery. Siegfried emerges at the shore begging Odette for forgiveness and swearing his undying love for her. Rothbart is making attempts to separate beloved ones. Siegfried and the forces of good battle with Rothbart until the dawn breaks and the forces of evil are vanquished. The rising sun gives birth to a new life, happiness and love.
        

    

    

                
    
                    

        

            

                            

            

                            

        

    

	

            

    

			

		





	


	

	

		


			

				

					Deals & Discounts 
					Subscribe to our email newsletter
				



				
				


			

			

		

		

	

	




 



	

		

			
    		

    

        

		
		
Award-winning
Group Tour Packages

        

        

		
Useful Links &
Company Information

        

        

        
    
		

	





	

		

			
© 2001 – 2024 by Northern Crown, Ltd. uVisitRussia and uVisitRussia.com are registered trademarks. Terms & Conditions  Privacy Policy