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-03-18' AND tmp.date<='2024-04-07' AND tmp.perf_id=97) 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-03-18' AND '2024-04-07' AND tmp.perf_id=97) 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<>97 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<>97 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





	24 December 2023, 15:30 - Peter Tchaikovsky "The Nutcracker" (ballet in three acts with an epilogue). Choreography by Vasily Vainonen - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theater 24 December 2023, 15:30 - Peter Tchaikovsky "The Nutcracker" (ballet in three acts with an epilogue). Choreography by Vasily Vainonen
24December
15:30
2023 | Sunday
Duration: 2 hours 45 minutes
World premiere: Mariinsky Theatre, St Petersburg, Russia, 18 February 1934

Christmas wouldn't be Christmas without The Nutcracker. Come and enjoy Mary and Franz's wonderful adventures as they meet a magician with strange secrets, join an army of valiant toy soldiers to fight a villainous Mouse King and take a trip to a land where everything is made of sweets. This really is an evening of magic: classical ballet at its most visually entrancing, with something to appeal to everyone, young and old. Tchaikovsky's sparkling, effervescent score contains a wealth of famous melodies, and the production is a visual delight from start to finish. Come and experience some special magic this Christmas and into the New Year.
Ballet in three acts with an epilogue
Music by Pyotr Tchaikovsky
Choreography by Vasily Vainonen (1934)
Set Designer: Simon Virsaladze (1954)
Libretto by Marius Petipa based on the story by E.T.A. Hoffmann

Performance by the Vaganova Academy of Russian Ballet

Premiere: 18 February 1934, Kirov Theatre of Opera and Ballet (Mariinsky), Leningrad
Premiere of the revival (designed by Simon Virsaladze): 21 March 1954, Kirov Theatre of Opera and Ballet (Mariinsky), Leningrad

SYNOPSIS

Act I 
The action takes place in an old German town at the start of the last century but one. Night is falling. It is Christmas Eve and the streets are busy and festive. Drosselmeyer, an eccentric inventor and toy maker loved by children, is among those invited to see the Christmas tree at the large, brightly lit house of Herr Stahlbaum.
The drawing room in Herr Stahlbaumґs house is beautifully decorated. The guests assemble. Drosselmeyer enters carrying presents.
The party is ready to start. The children rush in.
There is a game of blind manґs buff and Drosselmeyer takes part. He is blindfolded. Masha, Herr Stahlbaumґs young daughter, is the first to be caught.
After the games, there is dancing. Now dressed as a magician, Drosselmeyer does magic tricks and puts on a puppet show–The Mouse King Wishes to Kidnap the Princess, but the Courageous Nutcracker Kills the Mouse King and Saves the Princess.
Drosselmeyerґs ideas seem inexhaustible. He makes clockwork toys including a clown, a doll and a blackmail dance for the children. The Nutcracker, however, is Mashaґs favourite.
Franz takes the Nutcracker from Masha and the head comes off in his hands. Drosselmeyer quickly mends the Nutcracker. Masha cuddles and comforts her damaged favourite. It is late and the guests must depart. The party comes to an end with some dances.
Masha says goodnight to the Nutcracker and the candles on the tree are extinguished. Mashaґs nanny takes her to bed.

Act II 
Masha goes to bed and falls asleep. She dreams that mice have taken over the drawing room. They are headed by the Mouse King.
The Nutcracker leads the tin soldiers in the attack. Masha follows him. Overcoming her fear, she throws her slipper at the Mouse King at a decisive point in the battle, thus saving the Nutcracker. The Mouse King has been defeated and disappears together with his troops.
Drosselmeyer turns Masha and the Nutcracker into a beautiful Prince and Princess. They are caught up in a blizzard and their journey to a fairy-tale land begins.

Act III 
Masha and the Nutcracker are sailing along a magical river. The Nutcracker drives away some bats and clears the way to an enchanted island.
Celebrations begin. Masha and the Nutcracker are delighted. They dance and celebrate with the others.

Epilogue
Masha is asleep in bed. It will soon be morning. Her magical dream is over. Masha awakes.

 

Casts & Credits

Choreography: Marius Petipa
Choreography: Vasily Vaynonen
Ballet company: Mariinsky (Kirov) Ballet
Libretto: Marius Petipa
Set Designer: Simon Virsaladze
Choreography: Marius Petipa
Choreography: Vasily Vaynonen
Ballet company: Mariinsky (Kirov) Ballet
Libretto: Marius Petipa
Set Designer: Simon Virsaladze