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=1365) 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=1365) 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<>1365 AND tp.id_base=1561 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<>1365 AND tp.id_base=1561 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





	15 December 2017, 19:00 - Nikolai Rimsky-Korsakov  "The Snow Maiden" opera in four acts  - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Bolshoi theatre - Historic Stage 15 December 2017, 19:00 - Nikolai Rimsky-Korsakov "The Snow Maiden" opera in four acts
15December
19:00
2017 | Friday
Opera
Bolshoi theatre - Historic Stage, Moscow
Duration: 4 hours
World premiere: Mariinsky Theatre, St Petersburg , 10 February 1882

Music to my "Snow Maiden" amazing, I could not ever imagine a more suitable to her and so vividly expresses the poetry of Russian pagan cult, and this first snow and the cold, and then irresistibly passionate main character of the tale.

Alexander Ostrovsky

 

The Snow Maiden is an opera in four acts with a prologue by Nikolai Rimsky-Korsakov, composed during 1880–1881. The Russian libretto, by the composer, is based on the like-named play by Alexander Ostrovsky (which had premiered in 1873 with incidental music by Tchaikovsky).

The first performance of Rimsky-Korsakov's opera took place at the Mariinsky Theatre, Saint Petersburg on 29 January 1882 (OS; 10 February NS) conducted by Eduard Nápravník. By 1898 it was revised in the edition known today. It remained the composer's own favorite work.

The story deals with the opposition of eternal forces of nature and involves the interactions of mythological characters (Frost, Spring, Wood-Sprite), real people (Kupava, Mizgir'), and those in-between, i.e., half-mythical, half-real (Snow Maiden, Lel’, Berendey). The composer strove to distinguish each group of characters musically, and several individual characters have their own associated leitmotifs. In addition to these distinctions, Rimsky-Korsakov characterized the townspeople particularly with folk melodies. For a deeper understanding of this work from the composer's point of view, the reader is directed to his autobiography, as well as to his own incomplete analysis of the opera from 1905.

The Moscow premiere followed that of St. Petersburg three years later in 1885. It was presented by the Russian Private Opera (the Opera of Savva Mamontov in Moscow), conducted by Enrico Bevignani with scenic Design by Viktor Vasnetsov, Isaak Levitan, and Konstantin Korovin; Tsar Berendey – Grigoriy Erchov, Bermyata – Anton Bedlevitch, Spring Beauty – Vera Gnucheva, Grandfather Frost – Stepan Vlasov, The Snow Maiden – Nadejda Salina, Bobyl Bakula – G. Kassilov or Nikolay Miller, Lel – Tatyana Liubatovitch, Mizgir – Mikhail Malinin (Boris Mikhailovich Malinin and Marina Raskova’s father), Second Herald – M.Skuratovskiy.

The Bolshoi Theatre in Moscow presented the opera in 1893.

In March 2014 University College Opera presented a new English translation of The Snowmaiden in the Bloomsbury Theatre.