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-05-14' AND tmp.date<='2024-06-03' AND tmp.perf_id=1896) 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-05-14' AND '2024-06-03' AND tmp.perf_id=1896) 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<>1896 AND tp.id_base=1897 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

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<>1896 AND tp.id_base=1897 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





	29 November 2017, 19:00 - Peter Tchaikovsky "Nutcracker and the Mouse King" (ballet in 2 acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Bolshoi theatre - Small Stage 29 November 2017, 19:00 - Peter Tchaikovsky "Nutcracker and the Mouse King" (ballet in 2 acts)
29November
19:00
2017 | Wednesday
Classical ballet
Bolshoi theatre - Small Stage, Moscow
Duration: 2 hours 15 minutes approx.

Ballet by Christian Spuck after the eponymous fairy tale by E.T.A. Hoffmann

Choreography: Christian Spuck

Stage design: Rufus Didwiszus

Costumes: Buki Shiff

Light-Design: Martin Gebhardt

Chorus master: Ernst Raffelsberger

Dramaturgy: Michael Küster, Claus Spahn

Ballet: Ballett Zürich, Junior Ballett

Anyone who thinks of Piotr Tchaikovsky’s ballet music for The Nutcracker will immediately hear the magical sound of the celesta that accompanies the famous dance of the sugar plum fairy, and will see before their mind’s eye the splendour of a room decorated for Christmas, dancing snowflakes and the momentum of the waltz of the flowers. Tchaikovsky’s music is imaginative, vivid and incisive, and has made the Nutcracker one of the most popular works of the ballet repertoire. Behind the catchy melodies is the story of the girl Marie, who – under the spell of Christmas present-giving – works herself up into an eerie, feverish dream during which toy figures and sweetmeats come to life and become involved in a battle with dangerous mice, at the end of which the victorious wooden nutcracker emerges as Marie’s Prince Charming. The plot of The Nutcracker is based on a fairy tale by E.T.A. Hoffmann, which lost much of its darkly romantic mystery in its adaptation as a ballet libretto. The second act of the ballet, for example, consists only of a divertissement that has almost no plot, featuring a colourful sequence of dances and stage effects. Hoffmann, by contrast, continues to develop the plot and tells a fairy tale within the fairy tale (which is omitted in the ballet) and to oscillate cleverly between imagination and reality. In his new production of this large-scale classic ballet, Christian Spuck is more interested in the fantastical nature of the original story than in the delightful Christmas fairy tale. He combines Tchaikovsky’s music with the demonic, humour, the bizarre and the diverse range of figures that inhabit Hoffmann’s story.

Casts & Credits

Choreography: Christian Spuck
Ballet company: Bolshoi Ballet
Ballet company: Ballett Zurich
Choreography: Christian Spuck
Ballet company: Bolshoi Ballet
Ballet company: Ballett Zurich