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=62) 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=62) 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<>62 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<>62 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





	15 March 2019, 19:00 - Peter Tchaikovsky "Eugene Onegin" (lyric opera in three acts, seven scenes) Production by Yuri Temirkanov (1982) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theater 15 March 2019, 19:00 - Peter Tchaikovsky "Eugene Onegin" (lyric opera in three acts, seven scenes) Production by Yuri Temirkanov (1982)
Duration: 3 hours 50 minutes
World premiere: Kirov Theatre of Opera and Ballet, Leningrad, 13 November 1982

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.

Synopsis

Time: The 1820s

Place: In the country, and in St. Petersburg

ACT 1

Scene 1: The garden of the Larin country estate
Madame Larina (mezzo-soprano) and the nurse (mezzo-soprano) are sitting outside: her two daughters, Tatyana (soprano) and younger sister Olga (contralto), can be heard from inside the house. A group of peasants sing a comic song about the serenading of a miller's daughter. Tatyana is reading a romantic novel and quite absorbed by it, but her mother tells her that real life is very different from such stories. Visitors arrive: Olga's fiancй Lensky (tenor), a young 18 year-old poet, and his friend Eugene Onegin (baritone), a 23 year-old world-weary St Petersburg 'drawing-room automaton' (Nabokov). Lensky introduces Onegin to the Larin family. Onegin is initially surprised that Lensky has chosen the extrovert Olga rather than her romantic elder sister. Tatyana for her part is immediately and strongly attracted to Onegin.

Scene 2: Tatyana's room
Tatyana confesses to her nurse that she is in love. Left alone she writes a letter to Onegin driven by the realization that she is fatally and irreversibly drawn to him (the celebrated 'Letter Scene'). When the old woman returns Tatyana asks her to arrange for the letter to be sent to Onegin.

Scene 3: Another part of the estate
Onegin arrives to see Tatyana and give her his answer to her letter. He explains, not unkindly, that he is not a man who loves easily and is unsuited to marriage. Tatyana is crushed and unable to reply.

ACT 2

Scene 1: The ballroom of the Larin house
Tatyana's name-day party. Onegin is irritated with the country people who gossip about him and Tatyana, and with Lensky for persuading him to come. He decides to avenge himself by dancing and flirting with Olga. Lensky becomes extremely jealous. Olga is insensitive to her fiancй and apparently attracted to Onegin. There is a diversion while the elderly French tutor Monsieur Triquet sings some couplets in honour of Tatyana, after which the quarrel between Lensky and Onegin becomes more intense. Lensky renounces his friendship with Onegin in front of all the guests, and challenges Onegin to a duel, which the latter is forced, with many misgivings, to accept.

Scene 2: On the banks of a wooded stream, early morning
Lensky is waiting for Onegin, and sings of his uncertain fate and his love for Olga. Onegin arrives. They are both reluctant to go ahead with the duel but lack the power to stop it. Onegin shoots Lensky dead.

ACT 3

Scene 1: At a ball in the house of a rich nobleman in St Petersburg
Three years have passed. After traveling extensively all around Europe, Onegin reflects on the emptiness of his life and his remorse over the death of Lensky. Prince Gremin (bass) enters with his wife, Tatyana, now transformed into a grand, aristocratic beauty. Gremin sings of his great happiness with Tatyana, and re-introduces Onegin to her. Onegin is deeply impressed by Tatyana, and is suddenly injected with life and realizing that he is also in love with her.

Scene 2: Reception room in Prince Gremin's house
Tatyana has received a letter from Onegin. Onegin enters and begs for her love and her pity. Tatyana wonders why he is now attracted to her. Is it because of her social position? Onegin is adamant that his passion is real and absolute. Tatyana, moved to tears, reflects how near they once were to happiness but nevertheless asks him to leave. She admits she still loves him, but that their union can never be realized, as she is now married. Despite her unhappiness about her marriage and lack of passion for her husband, she will remain faithful to him. Onegin implores her, but she finally leaves him alone in his despair.

Casts & Credits

Conductor: Zaurbek Gugkaev
Baritone: Alexei Markov
Musical Preparation: Irina Soboleva
Principal Chorus Master: Andrei Petrenko
Set Designer: Igor Ivanov
Stage Director: Maestro Yury Temirkanov
Conductor: Zaurbek Gugkaev
Baritone: Alexei Markov
Musical Preparation: Irina Soboleva
Principal Chorus Master: Andrei Petrenko
Set Designer: Igor Ivanov
Stage Director: Maestro Yury Temirkanov