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=146) 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=146) 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<>146 AND tp.id_base=521 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<>146 AND tp.id_base=521 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





	29 January 2019, 19:00 - Modest Mussorgsky "Boris Godunov" opera in four acts with a prologue (version of 1872) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theater 29 January 2019, 19:00 - Modest Mussorgsky "Boris Godunov" opera in four acts with a prologue (version of 1872)
29January
19:00
2019 | Tuesday
Duration: 4 hours 5 minutes
World premiere: Mariinsky Theatre, St Petersburg, Russia, 27 January 1874

Mussorgsky’s Boris Godunov is Russia’s national epic: a tale of splendour, suffering, and the all-too human price of power. It’s one of the supreme achievements in Russian opera. If the Mariinsky is Russia’s national opera company, Mussorgsky’s Boris Godunov – premiered at the Mariinsky in 1874 - is surely Russia’s national opera. Certainly, few operas look more penetratingly at the soul of a nation: scenes of pageantry are undercut by private soul-searching and state-sanctioned murder. The opera paints Russia’s artistic self-image.

Synopsis
Prologue and Scene I
A courtyard of the Novodevichy Monastery outside Moscow. Guards and police officers are goading the people to pray that Boris Godunov will accept the throne. The Duma clerk Shchelkalov comes out and informs the people that Boris refuses to accept it. The police officer announces the Boyar’s order: “Be in the Kremlin tomorrow and await orders”.

Scene II
A square in the Moscow Kremlin. Boris’ coronation in the Cathedral of the Assumption. Boris appears amid bell-ringing to the people. He appears afraid of the burden of power.

Scene III
A cell in the Chudov Monastery. Monk Pimen is completing his chronicle of Russian history. The young novice, Grigory wakes from a bad dream; for the third time now he has seen himself ascend a steep staircase and look down from a great height over Moscow before falling.
Grigory listens to the story of Pimen’s earlier life asking particularly about the death of Tsarevich Dmitry in Uglich. Pimen recounts the murder of the boy, implicating Boris. “He would have been the same age as you and have ruled”, says Pimen. These words have a deep effect on Grigory, resulting in a brave and wild plan.

Scene IV
An inn on the Lithuanian border. Having run away from the monastery, Grigory, accompanied by the two wandering monks Missail and Varlaam, intends to cross the border. Grigory learns from the hostess how to slip into Lithuania, avoiding the border guards.
Police officers arrive at the inn looking for a fugitive who poses a danger to Muscovy. Only Grigory can read the warrant. He reads that the novice Grigory had run away from the Chudov monastery and the Tsar has ordered his capture. The warrant contains a description. To save himself Grigory reads out a description of Varlaam. Varlaam seizes the warrant and, struggling, slowly reads out the imperial decree. Grigory is recognised. He escapes.

Scene V
The Tsar’s apartments in the Moscow Kremlin. Fyo¬dor, Boris’ son, is studying while his sister Xenia mourns the death of her fiancй. The Tsar enters. He tries to console his daughter and takes interest in his son’s studies. All is not well with him. Boris knows that the people hate him and that he will be unable to attain their affection by any means.
Boris’ reflections are interrupted by the arrival of Shuisky. It is with great schadenfreude that he informs Boris that a Pretender has appeared in Lithuania. The name of the Tsarevich Dmitry unsettles Boris.
Boris orders Shuisky to fortify the Lithuanian border. He asks the Prince to confirm the Tsarevich’s death. Shuisky tells of the murder in detail. Surprised and terrified, Boris dismisses Shuisky. Alone with his conscience, he imagines he sees the ghost of the murdered child.

Scene VI
Outside St Basil’s Cathedral, Moscow. In poverty and hunger, the people await the end of the service. Inside the cathedral, Grigory is being denounced. The word is being passed that the Pretender’s forces are approaching Moscow.
Children outside the cathedral steal a kopeck from a Simpleton. He weeps. The Tsar and his entourage leave the cathedral. The people demand bread. The Tsar asks why the Simpleton is crying. “Some boys stole my kopeck, kill them like you had the young Tsarevich killed”. Boris asks the Simpleton to pray for him. “I cannot pray for Tsar Herod”.

Scene VII
The Granovitaya Chamber in the Moscow Kremlin. A meeting of the Council of Boyars to debate what action to bring against the Pretender. The others are disturbed that Shuisky is not present. He arrives at last. His tale of Boris’ sick visions is not believed. But Boris appears with the cry of “Be gone, be gone child!”. He addresses the Boyars. Shuisky interrupts him, suggesting he listen to an old man who wishes to divulge a secret. Pimen enters. He tells the Tsar that in Uglich there has been a miracle: a blind man recovered his sight at the grave of Tsarevich Dmitry. Boris cannot take this shock. Sensing that death is near, he calls his son…
To the tolling of bells, the dying Boris indicates Fyodor with the words “There is your Tsar…”

Casts & Credits

Lighting Designer: Vladimir Lukasevich
Musical Director: Maestro Valery Gergiev
Musical Preparation: Irina Soboleva
Principal Chorus Master: Andrei Petrenko
Production design: Nikolai Dvigubsky
Lighting Designer: Vladimir Lukasevich
Musical Director: Maestro Valery Gergiev
Musical Preparation: Irina Soboleva
Principal Chorus Master: Andrei Petrenko
Production design: Nikolai Dvigubsky