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=157) 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=157) 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<>157 AND tp.id_base=528 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<>157 AND tp.id_base=528 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





	13 March 2019, 19:00 - Pyotr Tchaikovsky "Eugene Onegin" (lyric scenes in three acts). Stage Director - Vasily Barkhatov - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mikhailovsky Theater 13 March 2019, 19:00 - Pyotr Tchaikovsky "Eugene Onegin" (lyric scenes in three acts). Stage Director - Vasily Barkhatov
13March
19:00
2019 | Wednesday
World premiere: Maly Theatre, Moscow, 17 March 1879

Tchaikovsky’s Eugene Onegin is a radiant example of Russian Lyric Opera. A deeply moving tale packed with big tunes, dances and a heart-stopping duel. As with his ballets, Tchaikovsky brings many symphonic elements to the music, plush orchestrations and highly melodic arias. Onegin is a uniquely Russian opera with a universality that has made it globally popular. None of the characters are easy to associate with and yet the events and their actions ring horribly true.
Eugene Onegin

lyric scenes in three acts
music by Pyotr Tchaikovsky

Libretto by Pyotr Tchaikovsky and Konstantin Shilovsky after the novel in verse by Alexander Pushkin
Musical Director of the production and §іonductor: Vasily Petrenko
Stage Director: Vasily Barkhatov
Stage Designer: Zinovy Margolin
Costume Designer: Mariya Danilova
Lighting Designer: Damir Ismagilov
Artistic Director and Principal Conductor of the Chorus: Vladimir Stolpovskikh
Assistant to Musical Director: Anatoly Rybalko
Assistants to Stage Director: Jurate Sodite, Vyacheslav Kalyuzhny
Principal Pianists: Irina Daineko, Alexander Pakuev
Stage Manager: Olga Kokh
Assistant to Stage Manager: Elena Piskunova
Assistant to Stage Director responsible for the Chorus: Tatiana Zelinskaya

Synopsis
Scene 1

The village. The LarinsЎЇ neighbour Lensky, OlgaЎЇs suitor, suddenly arrives with his friend Onegin ЎЄ a young man, who has recently come from the capital. The arrival of the new visitor perturbs the LarinsЎЇ life. The new guest is welcomed with interest. Onegin discredits LenskyЎЇs choice of fiancЁ¦e. Tatiana is deeply moved by her meeting with Onegin.

Scene 2

At night. Seeing TatianaЎЇs confusion, the Nanny tries to distract and comfort her. When sheЎЇs alone, Tatiana writes a letter to Onegin. She thinks him to be her only one. At dawn, Tatiana asks the Nanny to deliver the letter to Onegin.

Scene 3

Tatiana anxiously awaits a response to her confession. Onegin arrives. HeЎЇs moved by TatianaЎЇs sincerity, but canЎЇt return her affection. Tatiana is shocked. She hears him out with deep sadness.

Scene 4

TatianaЎЇs name day. Lensky has persuaded his friend to come to the Larins, but everything there irritates and bores Onegin. He decides to hurt Lensky and starts courting Olga ostentatiously. Lensky is angered by OneginЎЇs behaviour; a quarrel breaks out. Attention of the mob makes Lensky challenge Onegin to a duel.

Scene 5

The duel. Lensky is waiting for Onegin. HeЎЇs thinking about life with anguish and pain. Onegin is late; he doesnЎЇt want to bring the conflict to end. Former friends doubt their decision. But itЎЇs too late and their escape routes are cut off. A shot is heard. Lensky falls dead.

Scene 6

Ceremonial reception of Gremin and his wife. After a long absence, Onegin returns to city life and meets Tatiana. She is married to Gremin and is the centre of attention. Onegin is astonished by TatianaЎЇs transformation. Gripped by memories he decides to secure a meeting with her.

Scene 7

Onegin has secured a meeting with Tatiana. His speech is full of remorse. Tatiana recalls their first meeting. She is still in love with him, but her decision is final. She asks Onegin to leave her.

Casts & Credits

Opera company: Mikhailovsky Opera
Artistic Director: Vladimir Stolpovskikh
Costume Designer: Maria Danilova
Lighting Designer: Damir Ismagilov
Principal Chorus Master: Vladimir Stolpovskikh
Set Designer: Zinovy Margolin
Stage Director: Vasily Barkhatov
Opera company: Mikhailovsky Opera
Artistic Director: Vladimir Stolpovskikh
Costume Designer: Maria Danilova
Lighting Designer: Damir Ismagilov
Principal Chorus Master: Vladimir Stolpovskikh
Set Designer: Zinovy Margolin
Stage Director: Vasily Barkhatov