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-14' AND tmp.date<='2024-06-03' AND tmp.perf_id=989) 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-14' AND '2024-06-03' AND tmp.perf_id=989) 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<>989 AND tp.id_base=1078 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<>989 AND tp.id_base=1078 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





	14 March 2019, 18:30 - Mikhail Glinka "A life for the Tsar" opera in four acts with an epilogue - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theatre - Mariinsky II 14 March 2019, 18:30 - Mikhail Glinka "A life for the Tsar" opera in four acts with an epilogue
14March
18:30
2019 | Thursday
Opera
Mariinsky Theatre - Mariinsky II, Saint Petersburg
Duration: 4 hours 05 minutes
World premiere: Bolshoi Theatre, St Petersburg, 9 December 1836

Music by Mikhail Glinka
Libretto by Yegor Rosen
Musical Director: Valery Gergiev
Stage Director and Set Designer: Dmitri Tcherniakov
Costume Designers: Dmitri Tcherniakov, Olga Lukina
Choreographer: Sergei Vikharev
Lighting Designer: Gleb Filshtinsky
Principal Chorus Master: Andrei Petrenko
Musical Preparation: Natalia Mordashova

World premiere: December 9, 1836, Petersburg Bolshoi Theater
Premiere of the production: May 30, 2004, Mariinsky Theater, St. Petersburg

The performance has two intervals

SYNOPSIS

Act I
Ivan Susanin, his daughter Antonida and his adopted son Vanya are living happily among close friends and family in a remote part of Russia. Antonida is waiting for her fiancй Bogdan Sobinin to return from fighting enemies. Sobinin brings joyful news of Russia’s victories and asks Susanin to postpone his marriage to Antonida no longer. But Susanin considers the time is not right for celebrations and happiness: there is no peace and the future is uncertain. Only the news that there is a young Tsar stirs up the people and gives Susanin and his family hopes for the future.

Act II
The enemies assemble at a banquet in a magnificent hall. They are all anticipating an easy victory. News of the young Tsar arrives and the feast ends. The decision is made to send a detachment and capture the Tsar.

Act III
The Susanin family is looking forward to a happy future, with preparations for the wedding and guests arriving. The beauty and isolation of their lives is suddenly disturbed by the arrival of the foreign detachment. Their persuasions, threats, blackmail and bribery reveal to Susanin their dark plan – they intend to discover the Tsar’s secret hiding-place. Then Susanin makes a courageous decision: he will leave with the enemies. But he will lead them not to the Tsar but deep into an impassable forest.
In despair at her father’s departure, Antonida is unmoved by both her friends’ arrival and her fiancй’s promise to find her father. Sobinin assembles the villagers and they set off to follow Susanin.

Act IV
Night. Sobinin attempts to follow the enemies and Susanin, but a snow-storm has obliterated their tracks.
Vanya manages to convey the danger that threatens the Tsar – at dawn the enemies will discover Susanin’s betrayal and find the true path that leads to the Tsar. Everyone prepares to defend themselves.
The enemy detachment, having been led on a false trail through the impenetrable forest, collapses exhausted. Susanin alone has the energy to go on. Knowing death is close, he recalls with courage all his family and bids them farewell. The enemies begin to comprehend their position and demand an explanation from Susanin. Susanin admits his desperate decision to sacrifice himself. Realising death is unavoidable, the enemies kill Susanin in fury.

Epilogue
Deeply mourning the loss of Susanin, his family arrives at festivities to celebrate the saving of the young Tsar.

Casts & Credits

Composer: Mikhail Glinka
Choreography: Sergei Vikharev
Costume Designer: Olga Lukina
Lighting Designer: Gleb Filshtinsky
Musical Director: Maestro Valery Gergiev
Musical Preparation: Natalia Mordashova
Principal Chorus Master: Andrei Petrenko
Composer: Mikhail Glinka
Choreography: Sergei Vikharev
Costume Designer: Olga Lukina
Lighting Designer: Gleb Filshtinsky
Musical Director: Maestro Valery Gergiev
Musical Preparation: Natalia Mordashova
Principal Chorus Master: Andrei Petrenko