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=136) 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=136) 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<>136 AND tp.id_base=530 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<>136 AND tp.id_base=530 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





	4 November 2017, 13:00 - Peter Tchaikovsky "The Nutcracker" (Ballet in 2 Acts).Choreography by Nacho Duato - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mikhailovsky Theater 4 November 2017, 13:00 - Peter Tchaikovsky "The Nutcracker" (Ballet in 2 Acts).Choreography by Nacho Duato
4November
13:00
2017 | Saturday
Classical ballet
Mikhailovsky Theater, Saint Petersburg
Duration: 2 hours 15 minutes
World premiere: Mikhailovsky Theater, 12 December 2013

Every year during the Christmas season, thousands of children and their parents visit the theatre to see The Nutcracker, probably the all-time favourite in holiday entertainment. The Nutcracker premiered at the Maryinsky Theatre in St. Petersburg, Russia on December 18, 1892. The choreography was by Lev Ivanov after Marius Petipa, who fell ill before beginning to choreograph and passed on his choreographic plan to Ivanov, and the score was composed by Pyotr Ilyich Tchaikovsky. Italian ballerina Antoinetta Dell’Era and Russian premiere danseur Pavel Gerdt performed the lead roles of The Sugar Plum Fairy and Prince Coqueluche. The ballet was performed as a double premiere with Tchaikovsky’s final opera Iolanta. Tchaikovsky was initially reluctant to write the score for The Nutcracker finding the libretto based on E.T.A. Hoffmann’s children’s tale, The Nutcracker and the King of the Mice, lacking in fantasy. Nevertheless, this production would ultimately become Tchaikovsky’s most popular work.

Libretto by Marius Petipa after the fairytale by E. T. A. Hoffmann revised by Nacho Duato 

Choreographer: Nacho Duato
Stage Designer: Jérôme Kaplan
Lighting Designer: Brad Fields
Costume Technology: Alla Marusina
Choreographer’s Assistants: Tony Fabre, Gentian Doda
Répétiteurs: Zhanna Ayupova, Elvira Khabibullina, Kirill Myasnikov, Denis Tolmachov 

 

The Nutcracker is a two-act ballet, originally choreographed by Marius Petipa and Lev Ivanov with a score by Pyotr Ilyich Tchaikovsky. The libretto is adapted from E.T.A. Hoffmann's story The Nutcracker and the Mouse King.

Although the original production was not a success, the twenty-minute suite that Tchaikovsky extracted from the ballet was. However, the complete Nutcracker has enjoyed enormous popularity since the late 1960s and is now performed by countless ballet companies, primarily during the Christmas season, especially in the U.S. Major American ballet companies generate around 40 percent of their annual ticket revenues from performances of The Nutcracker.

Tchaikovsky's score has become one of his most famous compositions, in particular the pieces featured in the suite.

SYNOPSIS

ACT I

Christmas Eve. In a few hours, the clock will strike midnight — a time of magic and of dreams. Our story begins as the loving but mysterious uncle Drosselmeyer gathers all the children at the family party to give them Christmas presents: a beautiful Princess, a handsome Prince and a wicked Mouse King. Finally, the surprise gift, the Nutcracker doll, Drosselmeyer gives to his godchild Masha. Masha is fascinated by the Nutcracker. She cuddles and comforts her favorite toy. As the evening grows late, the guests depart and the Stahlbaum family retires for the evening. Masha, worried about her beloved Nutcracker, sneaks back to the tree to check on him, falling asleep with him in her arms. As the clock strikes midnight strange things begin to happen. The toys around the tree come to life while the room fills with an army of mice, led by the wicked Mouse King. As the Nutcracker awakens, he leads his army of toy soldiers into battle with the mice. The Mouse King drops to the floor and the mice run away, carrying off their leader’s lifeless body. The Nutcracker turns into a Prince and takes Masha on a journey to the Magic Land, where they are welcomed by dancing snowflakes.

ACT 2

The toys of the Magic Land are celebrating the victory over the Mouse King. They dance different dances from all over the world. Masha and Prince are happy. Masha knows that she has to leave this wonderful dream but it will stay with her forever.

Casts & Credits

Choreography: Nacho Duato
Ballet company: Mikhailovsky Ballet
Conductor: Igor Tomashevsky
Choreography: Nacho Duato
Ballet company: Mikhailovsky Ballet
Conductor: Igor Tomashevsky