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-23' AND tmp.date<='2024-05-13' AND tmp.perf_id=367) 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-23' AND '2024-05-13' AND tmp.perf_id=367) 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<>367 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

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<>367 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





	5 January 2018, 12:00 - "The Nutcracker. Opera " on the music by Tchaikovsky - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Moscow theatre "New Opera" 5 January 2018, 12:00 - "The Nutcracker. Opera " on the music by Tchaikovsky
5January
12:00
2018 | Friday
Opera
Moscow theatre "New Opera", Moscow
World premiere: 24 December 2014

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.
Idea: Alla Sigalova Paul Kaplevich
Musical version Igor Kadomtsev
Music director and conductor Dmitri Jurowski
Libretto: Alla Sigalova, Demyan Kudryavtsev, Paul Kaplevich
Director and choreographer Alla Sigalova
Art director Nikolai Simonov
Costume designer Paul Kaplevich
Lighting by Ivar Salihov
Performed in Russian

Will be many miracles: a huge chandelier turn into a glowing Christmas tree decoration will become the city center, bathroom, bedroom. Mouse King, Snow and unusual effects appear using the original video projections. In addition, the set designer Nikolai Simonov "play" with scales: small dolls and big people.
Protagonists, Masha and the Nutcracker, will play two artists - an adult and a child singer. The play will be attended by the children's choir, and Alla Sigalova not exclude plastic numbers.
 
Costumes Paul Kaplevich conceived as an attraction. Spanish costume doll turns into a huge fan of Drosselmeyer vest - in the wings, the Chinese doll becomes three Chinese idol "see nothing, hear nothing, nothing will not tell anyone." During snowfall snowflakes or choir outfits like stray to the side from the wind and blizzard.
Children will be "balls": in robes, skirts with hoops, outlandish hats. Adults seem to contrast and extended long as Gothic spiers. Primary colors - pastel and gold complex.