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=16) 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=16) 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<>16 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

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<>16 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





	6 August 2019, 20:00 - Swan Lake (Fantasy ballet in three acts and four scenes) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Hermitage Theatre 6 August 2019, 20:00 - Swan Lake (Fantasy ballet in three acts and four scenes)
6August
20:00
2019 | Tuesday
Classical ballet
Hermitage Theatre, Saint Petersburg
Duration: 2 hrs 30 min

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.

Ballet "Swan Lake" is the troupe of the St. Petersburg Theater "Russian Ballet". 

The performance is accompanied by the Governor's symphonic orchestra. 

"Swan Lake" - the most famous in the world of ballet performances. And the music and choreography of this ballet has for a long time considered to be universally recognized masterpieces, one of the great achievements of Russian culture. A White Swan will forever remain a symbol of Russian ballet, the symbol of its beauty and grandeur. 

The repertoire of the theater "Russian Ballet" this show has an important place, a fairy tale about the Swan Princess Odette and Prince Siegfried does not leave anyone indifferent spectator. 

Carefully preserved original choreography. Immortal music of Tchaikovsky, colorful sets and costumes, brilliant dance ballet troupe - all this attracts the attention of the public and provides notices. 

On stage - actors of theater "Russian Ballet". The theater was founded in 1990 by the soloists of the Mariinsky Theater ballet artists belonging to the dynasty, which has more than 100 years. Over seventy of world tour, conducted more than 4,000 ballet for 23 years of existence of the company, about one million enthusiastic spectators who attended performances - all records in the world of theater art, belonging to St. Petersburg Theater "Russian Ballet". The basis of popularity and demand of the theater - the preservation of the original choreography of classical ballets, professional troupes, the highest level of performance, colorful decorations and gorgeous costumes. 

Ballet "Swan Lake" has two intermissions.

Synopsis

ACT I

Scene one
The terrace of 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 assembles 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.

Small Swans Dancefrom "Swan Lake" balletmusic and video

Night is fast approaching and the guests take leave, Siegfried is finally 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 having stepped ashore turn into beautiful young girls Siegfried about to draw his crossbow stops fascinated by their beauty. Odette the swan princess is startled by Siegfrieds presence, he assures her no harm will come to her. Odette tells him of her terrible plight. Tells him of her high birth and how she has fallen under the spell of be a swan and only in the hours of darkness to assume her human form. She tells him she is bound for eternity by the spell unless an unblemished youth swears eternal fidelity and marries her. Siegfried realizes his destiny has changed. Day is breaking, the swans are again swimming 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 noblewoman 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 until a fanfare announces the arrival of more guests. Rothbart disguised as a knight sweeps in with his daughter Odille, Siegfried is dazzled by her beauty and her resemblance to Odette, swears his love and fidelity... 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 Rothbarts devilish trickery. Siegfried fleeing from the ball arrives at the shore begging Odette’s forgiveness and telling of his undying love for her. Rothbart appears and he and his black swans battle with Siegfried and the forces of good until the light of the dawn breaks and the forces of evil are vanquished. The rising sun gives birth to new life, happiness and love.

Casts & Credits

Choreography: Marius Petipa
Choreography: Konstantin Sergeyev
Artistic Director: Stanislav Gorkovenko
Libretto: Vasily Geltzer
Choreography: Marius Petipa
Choreography: Konstantin Sergeyev
Artistic Director: Stanislav Gorkovenko
Libretto: Vasily Geltzer