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=893) 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=893) 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<>893 AND tp.id_base=907 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<>893 AND tp.id_base=907 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





	24 January 2018, 19:00 - Peter Tchaikovsky "Eugene Onegin" (Opera in 3 Acts). Directed by Andrey Zholdak - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mikhailovsky Theater 24 January 2018, 19:00 - Peter Tchaikovsky "Eugene Onegin" (Opera in 3 Acts). Directed by Andrey Zholdak
24January
19:00
2018 | Wednesday
Duration: 3 hours 45 minutes
World premiere: Mikhailovsky Theater, 26 October 2012

Eugene Onegin is an opera ("lyrical scenes") in 3 acts (7 scenes), by Peter Tchaikovsky. The libretto was written by Konstantin Shilovsky and the composer and his brother Modest, and is based on the novel in verse by Alexander Pushkin.

Eugene Onegin is a well-known example of lyric opera; the libretto very closely follows Pushkin's original, retaining much of his poetry, to which Tchaikovsky adds music of a dramatic nature. The story concerns a selfish hero who lives to regret his blasй rejection of a young woman's love and his careless incitement of a fatal duel with his best friend.

The opera was first performed in Moscow in 1879. There are several recordings of it, and it is regularly performed. The work's title refers to the protagonist.

Stage Director: Andriy Zholdak
Music Director: Mikhail Tatarnikov
Set Designers: Monika Pormale, Andriy Zholdak
Costumes: MAREUNROL’S (Rolands Peterkops and Marite Mastina-Peterkopa)
Light: AJ Weissbard
Dramaturgy: Dmitry Renansky
Assistant to Stage Director: Sergey Patramanskiy
Assistant to Music Director: Aleksey Niaga
Assistant to Set Designers: Elena Zykova
Assistant to Light Designer: Pamela Cantatore
Chorus Master: Vladimir Stolpovskikh
Production team coordinator: Kathya Zholdak
Executive Producer: Alexander Arkhipov



Eugene Onegin, a story about the Russian soul for the attentive listener, is the calling card of Russian opera around the world. At the Mikhailovsky Theatre, avant-garde director Andriy Zholdak presented a radical reading of the opera which audiences found shocking, and stunningly insightful. The play provoked a highly emotional reaction and has continued to be the subject of heated debate throughout its theatric history. „Tchaikovsky’s psychological theatre has been transformed into a different system of expression, one of figurative metaphors,“ wrote theatre critics, struck by the unconventional production. „The performance’s figurative system intensifies feeling, reveals what is hidden and turns emotion into passion.“ In turn, the director compares the score of Onegin with a forest after the rain, when drops of water remain on the foliage of the trees: „Every measure of Tchaikovsky’s music is saturated with this moisture, eroticism, and tenderness.“ The monochrome aesthetic proves to be an effective artistic touch, with the white color gradually yielding its position to the black, turning into complete darkness in the finale. The scenery, full of icy symbolism, announces the inevitable doom hanging over the heroes.

The performance is awarded with the National Theatre Award Golden Mask in three categories: “Best Opera Production”, “Best Opera Director” (Andriy Zholdak), “Best Light Designer in Musical Theatre” (AJ Weissbard).

SYNOPSIS

Scene 1
The Larins’ house. A neighbour of the Larins’, Lensky, Olga’s suitor, suddenly brings a new guest, his friend Onegin — a young man, who has recently arrived 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, her nurse 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 her nurse to deliver the letter to Onegin.

Scene 3
In the daytime. Tatiana anxiously awaits a response to her confession. Onegin arrives. He’s moved by Tatiana’s sincerity, but can’t return her affection.

Scene 4
Tatiana’s name day. Lensky has persuaded his friend to come to the Larins, but everything there irritates Onegin. He decides to hurt Lensky and starts courting Olga ostentatiously. Olga’s readiness to accept Onegin’s courtship makes Lensky desperate. He quarrels with Onegin and challenges him to a duel.

Scene 5
In the morning. Lensky is waiting for Onegin. He’s thinking about life with anguish and pain. Onegin, who is late, 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. Lensky is shot dead.

Scene 6
Years have passed. After a long absence Onegin returns to city life and meets Tatiana. She is married and is the centre of attention. Onegin is shocked by her changed attitude towards him. Tatiana’s dramatic change and her inaccessibility arouse strong passion in him.

Scene 7
Onegin has secured a meeting with Tatiana. His speech is full of remorse. He demands her affection and makes her admit her love. But she has decided to change her life. Onegin is left in despair. 

Casts & Credits

Opera company: Mikhailovsky Opera
Director: Andrey Zholdak
Musical Director: Mikhail Tatarnikov
Principal Chorus Master: Vladimir Stolpovskikh
Opera company: Mikhailovsky Opera
Director: Andrey Zholdak
Musical Director: Mikhail Tatarnikov
Principal Chorus Master: Vladimir Stolpovskikh