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=1999) 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=1999) 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<>1999 AND tp.id_base=2004 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<>1999 AND tp.id_base=2004 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





	10 March 2021, 19:00 - Peter Tchaikovsky "Sleeping Beauty" (ballet-fierie in three acts with a prologue and apotheosis) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theater 10 March 2021, 19:00 - Peter Tchaikovsky "Sleeping Beauty" (ballet-fierie in three acts with a prologue and apotheosis)
10March
19:00
2021 | Wednesday
Duration: 3 hours 55 minutes
World premiere: Mariinsky Theatre, St Petersburg, Russia, 3 January 1890

Tchaikovsky's second and longest ballet failed to take off in the composer's lifetime but is now a worldwide favourite.Tchaikovsky's second ballet was premiered in 1890 at the Mariinsky Theatre in St. Petersburg. It is his longest ballet, lasting nearly three hours without intervals.Despite being aware that his Swan Lake had met with little enthusiasm, Tchaikovsky enthusiastically accepted the commission to write a ballet based on Charles Perrault's La Belle au bois dormant via a version by the Brothers Grimm.Tchaikovsky's ballet focussed in on the two main conflicting forces of good - the Lilac Fairy - and evil - Carabosse. Each has their own theme, which runs through the entire work, providing a thread to the plot. Act III however takes a complete break from the two motifs and instead places focus on the individual characters at the various court dances.At the première, Tsar Alexander III summoned Tchaikovsky to the imperial box and made the simple remark 'Very nice,' which seemed to have irritated the composer, who was probably expecting more effusive appreciation.The ballet's premiere received more favourable accolades than Swan Lake from the press but Tchaikovsky sadly did not live long enough to witness his work become an instant success in theatres outside of Russia. Many of his best tunes were later turned into songs in the Walt Disney animated feature version, made in 1959.

Libretto: Ivan Vsevolozhsky and Marius Petipa, after tales: Charles Perrault

Set design: Heinrich Levogt, Mikhail Bocharov, Ivan Andreev, Konstantin Ivanov and Matvei Shishkov
Costumes: Ivan Vsevolozhsky

The revival team:
Choreography staged: Sergei Vikharev
Set design reproduced: Andrei Voitenko
Costumes reproduced: Elena Zaitseva
Assistant Set designers: Boris Kaminsky and Andrei Sevbo
Archive research and co-ordination: Pavel Gershenzon

World premiere: 3 January 1890, Mariinsky Theatre, St Petersburg
Premiere of the revival: 30 April 1999, Mariinsky Theatre, St Petersburg

Synopsis

Prologue

King Florestan XIV and the Queen are celebrating the birth of Princess Aurora. In the palace preparations are underway for a ban­quet. Master of Ceremonies Catalabutte is checking the list of guests. Guests and members of the court arrive and congratulate the king and queen. The Lilac Fairy and the Good Fairies present their gifts to the infant princess, endowing her with the finest human attributes.

Suddenly a great noise is heard: the wicked and powerful Carabosse Fairy appears. Catalabutte has forgotten to invite her to the banquet. The Master of Ceremonies is out of his mind with anxiety for his mis­take may result in dire misfortune for the Princess in her future life. In a fit of anger Carabosse foretells that Aurora will die young from pricking her finger with a knitting spindle. All are overcome by despair. But the Lilac Fairy forces Carabosse to leave the palace and predicts a reprieve from death for Aurora: "In a hundred years’ time the princess, and the whole kingdom, will be awakened to happiness by a handsome prince".

Act I

It is Princess Aurora’s sixteenth birthday. Four princes have come to court her. The King and Queen urge her to make a choice. But Aurora, who is full of youth and the joys of life, refuses to listen to her parents’ entreaties. At the height of the festivities and old woman comes up to Aurora and, unnoticed, hands her a knitting spindle. Trusting Aurora takes it and continues to dance. Suddenly she stops dancing and gazes in horror at her finger which she has accidentally pricked with the spin­dle. Aurora is overcome by deadly cold and she dies. The old woman throws off her hood - it is Fairy Carabosse! Whirling about maliciously, she disappears in a cloud of smoke. A dreadful misfortune has overtak­en the kingdom.

The Lilac Fairy appears: she has the power to mitigate evil! Aurora has­n’t died, she has fallen asleep for a hundred years. She will be woken up by the passionate kiss of a handsome prince. The Lilac Fairy puts the whole kingdom to sleep for a hundred years.

Act II

Scene 1
A century has passed. Prince Desire is hunting on his domain, but he is not particularly engrossed in the chase. He is haunted by a beautiful dream.
Suddenly the Lilac Fairy appears before the Prince. She summons a vision of Aurora surrounded by ethereal nerdish. Enchanted, the Prince hurries after the vision but, on a command from the Lilac Fairy, it disap­pears.

Desire implores the Lilac Fairy to search for the beautiful maiden who has captivated his heart. The Lilac Fairy and the Prince set sail in the magic boat and make for the bewitched royal castle.

Scene 2
Darkness and desolation reign in the sleeping kingdom. It is guarded by the wicked Carabosse Fairy.
The Lilac Fairy and Prince Desire approach rapidly. Fairy Carabosse and her retinue try to hide Aurora, but the Prince catches sight of her. Captivated by Aurora, he kisses her tenderly. And the evil spell is broken! Carabosse and her retinue disappear. Aurora wakes up, and with her the whole kingdom. The Princess gazes at her deliverer and love is born in her heart. Desire asks the King and Queen for Aurora’s hand.

Act III

The wedding of Aurora and Desire. The Fairy-tale Characters have come to the celebrations: Princess Florine and Blue Bird, Puss in Boots and White Cat, Red Riding Hood and the Wolf, Cinderella and the Prince.

Apotheosis

The Lilac Fairy and her retinue give their blessing for a happy life to the bride and groom.

Casts & Credits

Choreography: Marius Petipa
Choreography: Sergei Vikharev
Ballet company: Mariinsky (Kirov) Ballet
Dancer: Alina Somova
Dancer: Oxana Skorik
Costume Designer: Elena Zaitseva
Designer: Andrei Voitenko
Libretto: Marius Petipa
Lighting Designer: Vladimir Lukasevich
Musical Director: Maestro Valery Gergiev
Set Designer: Simon Virsaladze
Choreography: Marius Petipa
Choreography: Sergei Vikharev
Ballet company: Mariinsky (Kirov) Ballet
Dancer: Alina Somova
Dancer: Oxana Skorik
Costume Designer: Elena Zaitseva
Designer: Andrei Voitenko
Libretto: Marius Petipa
Lighting Designer: Vladimir Lukasevich
Musical Director: Maestro Valery Gergiev
Set Designer: Simon Virsaladze