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





	11 February 2020, 19:00 - Peter Tchaikovsky "Swan Lake" (fantasy ballet in three acts (four scenes)) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theater 11 February 2020, 19:00 - Peter Tchaikovsky "Swan Lake" (fantasy ballet in three acts (four scenes))
11February
19:00
2020 | Tuesday
Classical ballet
Mariinsky Theater, Saint Petersburg
Duration: 3 hours 10 minutes
World premiere: Kirov Theatre, Leningrad, Russia, 8 March 1950

Swan Lake, the treasure of the Russian Classical Ballet ballet, form the basis of the classical ballet repertoire of the Mariinsky Theater: more than a hundred years ago, it was choreographed by Marius Petipa and is considered to be a hallmark of the Mariinsky Ballet - the Main Ballet Stage of the Russian Empire. This classical masterpiece was performed almost uncountable number of times at the Mariinsky Theatre and in the course of numerous tours.

Libretto - Vladimir Begichev, Vasily Geltzer
Costume design: Galina Solovyova

World premiere: 20 February 1877, Bolshoi Theatre, Moscow (choreography by Julius Reisinger)
Premiere in St Petersburg: 15 January 1895, Mariinsky Theatre (choreography by Lev Ivanov and Marius Petipa)
Premiere of Konstantin Sergeyev’s version: 8 March 1950, Kirov Theatre, Leningrad

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. 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
Choreography: Lev Ivanov
Ballet company: Mariinsky (Kirov) Ballet
Conductor: Gavriel Heine
Costume Designer: Galina Solovieva
Libretto: Vasily Geltzer
Set Designer: Igor Ivanov
Set Designer: Simon Virsaladze
Stage Director: Konstantin Sergeyev
Choreography: Marius Petipa
Choreography: Konstantin Sergeyev
Choreography: Lev Ivanov
Ballet company: Mariinsky (Kirov) Ballet
Conductor: Gavriel Heine
Costume Designer: Galina Solovieva
Libretto: Vasily Geltzer
Set Designer: Igor Ivanov
Set Designer: Simon Virsaladze
Stage Director: Konstantin Sergeyev