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-15' AND tmp.date<='2024-06-04' AND tmp.perf_id=2614) 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-15' AND '2024-06-04' AND tmp.perf_id=2614) 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<>2614 AND tp.id_base=2836 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<>2614 AND tp.id_base=2836 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





	10 May 2020, 19:00 - Nikolai Rimsky-Korsakov "Sadko" (Opera in seven scenes) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Bolshoi theatre - Historic Stage 10 May 2020, 19:00 - Nikolai Rimsky-Korsakov "Sadko" (Opera in seven scenes)
10May
19:00
2020 | Sunday
Opera
Bolshoi theatre - Historic Stage, Moscow
Conductor TO BE ANNOUNCED
Director DMITRY TCHERNIAKOV
Set Design DMITRY TCHERNIAKOV
Costume Design ELENA ZAITSEVA
Lighting Design GLEB FILSHTINSKY
Chief Chorus Master VALERY BORISOV


Libretto by Nikolai Rimsky-Korsakov and Vladimir Belskybased on Russian bylinas

Sadko is an opera in seven scenes by Nikolai Rimsky-Korsakov. The libretto was written by the composer, with assistance from Vladimir Belsky, Vladimir Stasov, and others. Rimsky-Korsakov was first inspired by the bylina of Sadko in 1867, when he completed a tone poem on the subject, his Op. 5. After finishing his second revision of this work in 1891, he decided to turn it into a dramatic work.

The music is highly evocative, and Rimsky-Korsakov's famed powers of orchestration are abundantly evident throughout the score. According to the Soviet critic Boris Asafyev, writing in 1922, Sadko constitutes the summit of Rimsky-Korsakov's craft. From the opus 5 tone poem the composer quoted its most memorable passages, including the opening theme of the swelling sea, and other themes as leitmotives – he himself set out to "utilize for this opera the material of my symphonic poem, and, in any event, to make use of its motives as leading motives for the opera".


Performance history

The composer was closely involved in the "assiduous" rehearsals, and he "drilled the orchestra with great care, together with [the conductor] Esposito who proved a very fair musician". Rimsky also corrected errors in the score and worked hard with the chorus. Apart from the Sea-King singer "whom I could not endure" he approved of all the solo singers and singled out Zabyela, who "sang magnificently" and Syekar-Rozhanski.

The world premiere took place on 7 January 1898 (O.S. 26 December 1897), presented by the Russian Private Opera at the Solodovnikov Theatre in Moscow. Its conductor was Eugenio Esposito, the brother of Michele Esposito, with scenic designers Konstantin Korovin and Sergey Malyutin. The production was financed by the railway tycoon Savva Mamontov; this was the first time that one of Rimsky-Korsakov's operas was staged by a commercial theatre rather than the Imperial Theatres. The St. Petersburg premiere followed 26 January 1901 at the Mariinsky Theatre, conducted by Eduard Nápravník, with scenic design by Apollinary Vasnetsov.

In 1906, the opera was presented at the Bolshoi Theatre in Moscow conducted by Vyacheslav Suk, with scenic design by Konstantin Korovin. The first US performance occurred at the Metropolitan Opera in New York on 25 January 1930 in French with Tullio Serafin, followed a year later by the first performance in London in June 1931.

A truncated production was mounted in Monte Carlo in 1921, conducted by Victor de Sabata, with Dimitri Smirnov in the title role. Revivals took place at the Bolshoi in 1935, 1949 and 1963. A production at the Berlin Staatsoper in 1947 featured Ludwig Suthaus, Erna Berger and Margarete Klose. Aleksandr Ptushko directed a film of the opera in 1952 with the music but without singing. A new production by Alexei Stepaniuk for the Mariinsky Theatre in 1993 was later toured to Paris (Théâtre des Champs-Élysées) and recorded.

Sadko is rarely performed today outside the Russian Federation. However there was a new production in Amsterdam (2017), and one is scheduled for Bratislava (2018). Also in 2018, a rare U.S. series of performances is scheduled for March in Silver Spring, Maryland. Sung in Russian with English supertitles, the production is produced by Bel Cantanti Opera Company, led by BCO artistic director Dr. Katerina Souvorova in collaboration with The Four Seasons Dancers (directed by Elena Indrokova-Jones) and The Olney Ballet (directed by Patricia Berrend). Designer Ksenia Litvak. Sadko: Patrick Cook, Lyubava: Viktoriya Vita Koreneva, Volkhova: Katie Manukyan. Stage direction by Gregory Scott Stuart.