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=88) 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=88) 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<>88 AND tp.id_base=529 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<>88 AND tp.id_base=529 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





	14 October 2018, 19:00 - Peter Tchaikovsky "The Sleeping Beauty" (ballet in three acts and a prologue) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mikhailovsky Theater 14 October 2018, 19:00 - Peter Tchaikovsky "The Sleeping Beauty" (ballet in three acts and a prologue)
14October
19:00
2018 | Sunday
Classical ballet
Mikhailovsky Theater, Saint Petersburg
Duration: 2 hours 40 minutes
World premiere: Mikhailovsky Theater, 16 December 2011

From the simplicity and intimacy of the famous fairy tale on which it is based, the ballet opens out into a spectacle of grand virtuosity, generous and incomparable displays of technique, ravishing stagecraft and unapologetic theatrical ostentation. The Sleeping Beauty has long been considered an almost ideal instance of the integration of music and dance and it is arguably the greatest of the Tchaikovsky-Petipa collaborations. Its breadth of musical and choreographic vision, its incorporation of so many dance styles and traditions into one radiant whole and its combination of sophistication and accessibility make it a classical ballet nonpareil.

Libretto by Nacho Duato after Ivan Vsevolozhsky and the fairy tale by Charles Perrault

Choreography: Nacho Duato
Stage Designer, Costume Designer: Angelina Atlagić
Lighting Design: Brad Fields
Assistant to Stage Designer adapting the artistic solutions to technical performance: Oleg Molchanov
Assistants to Stage Designer: Magdalena Vlajić, Branko Cvijić
Costume Technology: Alla Marusina
Choreographer’s Assistant: Tony Fabre
Répétiteurs: Zhanna Ayupova, Elvira Khabibullina, Kirill Myasnikov, Denis Tolmachov

Choreographer Nacho Duato has discovered new meanings, emotional nuances, and graceful imagery in the captivating music of Tchaikovsky and the magical story by Charles Perrault, so familiar to all of us since childhood. Inspired by the choreography of his great predecessor, Marius Petipa, Duato occasionally refers to him, with respect or light irony, without contradicting him. The grandeur of the classical style gets shaken up: it is as if a serious symphony orchestra has suddenly allowed itself some light, jazzy twists. 
The ballet’s designers have created a space on stage which allows the audience to feel as if they are right inside the fairy tale, in the world of the fairies. Set against a background of flowering roses, the ballet’s characters sometimes resemble birds or butterflies. The wicked fairy, Carabosse, is portrayed as a vampish beauty, faithfully served by wily cockroaches with shining backs. In the finale, though, the evil spells are undone, and kindness and love win out. „In our time, adults, too, need fairy tales. They help us to return to something important and personal: the child within us.“ The production team are sure that this is true, and audiences gladly share their view.

SYNOPSIS

Prologue

King Florestan and Queen are celebrating the christening of their daughter, Princess Aurora.
The court is waiting for the appearance of the King and the Queen. Catalabutte, the Master of Ceremonies, is revising the guest list. The feast begins. The Lilac Fairy, the godmother of the Princess, appears surrounded by good fairies.
Frightened servants herald the arrival of the evil Fairy Carabosse, who hasn’t been invited by mistake of Catalabutte. King and Queen are worried expecting the worst. Enraged Carabosse escorted by her monstrous entourage arrives. How did they dare to forget her? Carabosse willing to revenge predicts that Princess Aurora will become the most beautiful and the smartest of all the princesses but once she will prick her finger with a needle and die.
The Lilac Fairy alleviates the prophecy of Carabosse. Princess Aurora shall not die, as Carabosse wished but will fall in a deep sleep and shall be awakened by a young Prince enchanted by the sleeping beauty. 

Act I

Princess Aurora has turned sixteen. King and Queen are celebrating her birthday. Noble guests are coming to the palace to seek Aurora’s hand. The princes are introduced to Princess Aurora. She is nice to all of them, ready to dance with everyone but she doesn’t favour any of them. An old lady with a strange thing in her hands attracts Aurora’s attention. The Princess takes the needle from the old lady and starts playing and dancing with it. Suddenly she pricks her finger and falls senseless. The old lady is the Fairy Carabosse. She is triumphant.
The Lilac Fairy alleviates the prophecy of Carabosse : Princess Aurora shall not die but fall asleep for one hundred years. And everybody in the kingdom will fall asleep after her. In one hundred years the Princess will be awakened and the magic condemnation will lose its power.

Act II

One hundred years has passed. Prince Désiré, his friends and courtiers are hunting in the forest. Once Prince Désiré is alone, the Lilac Fairy appears. She tells him about the Princess. The Prince is longing to see the Princess in reality.
The Lilac Fairy and Prince Désiré are sailing in a boat to the sleeping castle. A dense forest is around them. Τhe evil Fairy Carabosse and her servants are in the garden. Suddenly they hear the music signifying the appearance of the Lilac Fairy. Carabosse has no might against the Lilac Fairy.
Prince Désiré finds Princess Aurora. When he kisses the sleeping beauty, Aurora awakes.

Act III

King Florestan’s palace. The wedding of Princess Aurora and Prince Désiré is celebrated.
Many guests are coming to congratulate the newlyweds: the fairy-tale characters, fairies and princes. The happy newlyweds are dancing. The Lilac Fairy appears in the palace. All her kind promises have come true!