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=214) 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=214) 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<>214 AND tp.id_base=496 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<>214 AND tp.id_base=496 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





	23 December 2019, 19:00 - "Snow maiden" Peter Tchaikovsky (ballet in 2 acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Stanislavsky theatre 23 December 2019, 19:00 - "Snow maiden" Peter Tchaikovsky (ballet in 2 acts)
23December
19:00
2019 | Monday
Classical ballet
Stanislavsky theatre, Moscow
Duration: 2 hours 15 minutes
World premiere: Mariinsky Theatre, St Petersburg, 06 November 1963

Although best known for his oriental fantasy Scheherazade, Rimsky-Korsakov principally considered himself a composer of opera. In his autobiography Chronicle of My Musical Life, he wrote, “Snegurochka is not only my best opera, but perhaps the best contemporary opera in general”. It was not a view shared by the press. “The critics treated Snegurochka with scant sympathy… I ‘possessed talent’ as a symphonist, but not as an operatic composer.”

Composer Pyotr Tchaikovsky
Libretto by Vladimir Burmeister
Choreography and Production Vladimir Burmeister
Set Design Vladimir Arefiev
Conductors Vladimir Basiladze, Georgy Zhemchuzhin
Revival Production Dmitry Bryantsev
Lighting  Ildar Bederdinov

"The Snow Maiden" was created by the outstanding choreographer Vladimir Burmeister under commission by the London Festival Ballet. In 1963, it was recreated on stage of the K. S. Stanislavsky and V. I. Nemirovich-Danchenko Music Theatre. Its plot is based on Alexander Ostrovsky’s play of the same title. The music score was compiled of various popular works by Tchaikovsky, such as the music for the Ostrovsky fairy-tale, Symphony no. 1 ("Winter Daydreams"), the Serenade for Strings, a piano sonata, etc. 

In 2001, a new stage version was created. The major changes concerned the stage design, which was made more modern. On December of the same year The Snow Maiden was shown in London during the Theatre’s guest performances. The latter were a success beyond all expectations; the influential newspaper The Independent counted them among the major cultural events of the season. 

Сast
Conductor 
Vladimir Basiladze
Roman Kaloshin
Snow Maiden 
Zhanna Gubanova
Anastasia Limenko
Anastasia Pershenkova
Ksenia Shevtsova
Father Frost / Tsar Berendey 
Stanislav Bukharaev
Nikita Kirillov
Mizgir 
Alexey Lyubimov
Sergey Manuylov
Dmitry Sobolevsky
Kupava 
Maria Beck
Natalia Kleymenova
Erika Mikirticheva
Valeria Mukhanova
Olga Sizykh
Natalia Somova
Lel 
Vladimir Dmitriev
Denis Perkovsky
Georgi Smilevski-jr.
Innokenty Yuldashev
Evgeny Zhukov
Skomorokh 
Denis Akinfeev
Vladimir Dmitriev
Dmitry Muravinets
Denis Perkovsky
Georgi Smilevski-jr.
Innokenty Yuldashev
Evgeny Zhukov