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-13' AND tmp.date<='2024-05-03' AND tmp.perf_id=616) 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-13' AND '2024-05-03' AND tmp.perf_id=616) 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<>616 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<>616 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





	8 August 2019, 19:00 - Swan Lake - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Russian National Ballet Theatre 8 August 2019, 19:00 - Swan Lake
8August
19:00
2019 | Thursday
Classical ballet
Russian National Ballet Theatre, Moscow
Duration: 2 hours 19 minutes
World premiere: Mariinsky Theater, 1895

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.

Swan Lake ballet"in 2 acts, 4 scenes
 Music - P.I. Tchaikovsky. Director of production - Vyacheslav Gordeev. Choreography - L. Ivanova, A. Gorsky, M. Petipa, V. Gordeev.
 "Swan Lake" - an outstanding ballet for the music of the brilliant Russian composer Pyotr Ilyich Tchaikovsky in the recognized classical production of Marius Petipa was presented to the public on the stage of the Mariinsky Theater in 1895. Since then, the romantic images of "Swan Lake" excite both adults and young spectators, inspire the creativity of choreographers and choreographers around the world. This great work, widely known and beloved by the public of different countries, symbolizing ballet art in general, became the property of the golden fund of world culture. Ballet "Swan Lake" - a story about the eternal and beautiful love, betrayal, good and evil.The plot is an old German legend about a beautiful girl, Odette, who was turned into a white swan. Only unselfish love and faithfulness can remove from it the spell. Romantic young man, Prince Siegfried falls on a magical lake, sees Odette finds in her his ideal, he falls in love and gives the oath of allegiance. But on the way to the embodiment of the prince's dream is the Evil Genius ..."Swan Lake" in the repertoire of the "Russian Ballet" theater occupies a special place. In the production of Vyacheslav Gordeev, carefully storing the great classics, there is an individual handwriting of the choreographer, his creative pulse. The ballet has a happy ending, it continues to please the hearts and souls of the audience - good triumphs.

Synopsis

ACT I

The Garden of Prince Siegfried’s Castle

Prince Siegfried has come of age and entered upon a new world of affairs of war and the burdens of manhood. It is the day for leaving behind the whims and caprice of youth. A happy day for the Prince, although touched by anxiety. The kindly jester and tutor who have been the Prince’s loving companions since his childhood are the first to congratulate him. He greets his companions and joyfully accepts the congratulations of all the residents of the Castle.

The Prince’s subjects come from far and wide to take part in the festivities. They confer upon him the sword and sceptre of authority and swear allegiance to their new ruler. Henceforth, Prince Siegfried holds their lives and properties in his hands and is also responsible for increasing their wealth and adding to their glory. Something is troubling the Prince. However, he hastens to his mother, the Princess Mother of the Realm, kneels before her and begs for her advice and assistance. The festivities continue, but the Prince is overcome by a desire to be alone, far from his guests.

ACT II

A Lakeside

A wild lakeside, completely deserted. This is where the evil sorcerer conceals the maidens he has changed into swans. The sorcerer and his evil spell can be destroyed only if a young man falls truly and faithfully in love with the most beautiful of the swan maidens, Odette. But how can this happen, with the evil sorcerer ever alert and watchful over his captives?

Suddenly the Prince appears at the lakeside. His gaze alights on Odette and he is transfixed, dazzled by her beauty, and overcome by the aura of evil in which she is entrapped. The sorcerer tries to keep the swan maidens away from the prince to prevent an encounter between him and Odette. But Siegfried follows the beautiful swan maiden. Who is she? The swan maidens are cloaked in silence, how can they be saved? How can he penetrate the secret that surrounds them and rescue them from their captivity? The Prince is completely overcome by the incomparable and exquisite delicacy of Odette, the Prince swears that he will return and free her from the evil spell.

ACT III

The Great Hall of Prince Siegfried’s Castle

The castle resounds to the clamor of festivities. Renowned Princesses from Hungary, Russia, Spain, Italy and Poland are presented to the Prince. He must choose one of them as his bride, in order to strengthen his authority and consolidate his power. However, in none of these royal heiresses does he find a maiden comparable to Odette, to whom he has lost his heart. He rejects them all.

The evil sorcerer appears with a Princess remarkably like the Prince’s beloved. He bewitches the Prince into believing that this domineering and cunning maiden is in fact the Queen of the Swans. Even her name, Odile, sounds like Odette to the Prince’s ears. He chooses her as his bride and at the same time he sees a vision of Odette and he understands that the evil sorcerer and his daughter Odile have tricked him and in despair he leaves the palace.

ACT IV

The Lakeside

Night falls again on the Swan Lake. The swan maidens are anxious, for if the Prince does not fulfill his vow to set them free, they will be doomed to everlasting captivity. The sorcerer raises a raging storm to conceal the Swan Lake behind a screen of dark clouds, But the Prince rushes headlong through the storm to Odette. The sorcerer attempts to conceal her from him, but no power can stop the young man whose heart is so full of love.

The Prince overcomes all obstacles, and the spell cast by the evil sorcerer is dashed forever on the rock of true love.

Casts & Credits

Choreography: Marius Petipa
Artistic Director: Evgeny Amosov
Artistic Director: Vladimir Moiseyev
Choreography: Marius Petipa
Artistic Director: Evgeny Amosov
Artistic Director: Vladimir Moiseyev