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=40) 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=40) 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<>40 AND tp.id_base=778 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

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<>40 AND tp.id_base=778 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





	22 February 2020, 18:00 - Modest Musorgsky "Khovanshchina" (folk musical drama in five acts, six scenes) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theater 22 February 2020, 18:00 - Modest Musorgsky "Khovanshchina" (folk musical drama in five acts, six scenes)
22February
18:00
2020 | Saturday
Duration: 4 hours 40 minutes
World premiere: Mariinsky Theatre, St Petersburg, 1 May 2000

New stage version: Yury Alexandrov (2000)

Libretto by the composer
Orchestrated: Dmitry Shostakovich
Stage Director - Leonid Baratov
Set Designer - Fedor Fedorovsky

Performed in Russian

Khovanshchina (Hovanscina, sometimes rendered The Khovansky Affair) is an opera (subtitled a ’national music drama’) in five acts by Modest Mussorgsky. The work was written between 1872 and 1880 in St. Petersburg, Russia. The composer wrote the libretto based on historical sources.

Synopsis

Act I

Moscow. Red Square. Shaklovity, a Boyar, dictates an anonymous letter to the Tsar, warning of a rebellion by Khovansky (captain of the Streltsy Guards) and the Old Believers. Ivan Khovansky arrives and promises a crowd of people to defend the Tsar against treachery. Andrey Khovansky, Ivan’s son, chases in Emma, a German girl, but is fended off by Marfa, an Old Believer. Andrey threatens to kill Emma, but is prevented by the arrival of Dosifey, the leader of the Old Believers. Marfa leaves with Emma.

Act II

Summer Study of Prince Vasily Golitsyn. Marfa tells the prince’s fortune, saying that he will fall from power. After she leaves, Golitsyn orders his servants to kill her. Ivan Khovansky appears to complain that Golitsyn has interfered with the Boyars, but Dosifey enters and persuades the two to work together. Marfa, who has been saved by the Tsar’s guards, reappears, followed by Shaklovity, who tells the group that the Tsar has been warned of their opposition to him.

Act III

The Streltsi Quarter, South of the Moscow River.Marfa is overheard singing of her love by Susanna, a fellow Old Believer. Marfa admits to Dosifey that she loves Andrey Khovansky.

Act IV

Scene 1
A Richly Furnished Chamber in Ivan Khovansky’s Mansion. Khovansky is warned by a servant of Golitsyn that he is in danger, but Khovansky ignores the warning and watches his servant girls dance. Shaklovity enters and murders Khovansky.

Scene 2
Moscow. The Red Square before the Cathedral of Vasiliy the Blessed. Golitsyn is led into exile. Dosifey mourns the conspirators’ downfall. Marfa offers sanctuary to Andrey with the Old Believers. The Streltsy are led to their execution. Peter, through an agent, intervenes to pardon them (which is not in agreement with historical fact).

Act V

A Pine Forest. A Secluded Monastery. A Moonlit Night. Dosifey and his followers prepare to immolate themselves. As Dosifey, Marfa, Andrey and the Old Believers perish in the flames of a burning chapel, Peter’s soldiers arrive in a vain attempt to capture them.

Casts & Credits

Choreography: Dmitry Korneyev
Conductor: Pavel Smelkov
Baritone: Nikolai Putilin
Mezzo soprano: Olga Borodina
Costume Designer: Tatiana Noginova
Lighting Designer: Vladimir Lukasevich
Musical Director: Maestro Valery Gergiev
Musical Preparation: Marina Mishuk
Principal Chorus Master: Andrei Petrenko
Revival Stage Director: Yuri Laptev
Set Designer: Fyodor Fyodorovsky
Set Designer: Vyacheslav Okunev
Stage Director: Leonid Baratov
Choreography: Dmitry Korneyev
Conductor: Pavel Smelkov
Baritone: Nikolai Putilin
Mezzo soprano: Olga Borodina
Costume Designer: Tatiana Noginova
Lighting Designer: Vladimir Lukasevich
Musical Director: Maestro Valery Gergiev
Musical Preparation: Marina Mishuk
Principal Chorus Master: Andrei Petrenko
Revival Stage Director: Yuri Laptev
Set Designer: Fyodor Fyodorovsky
Set Designer: Vyacheslav Okunev
Stage Director: Leonid Baratov