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=24) 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=24) 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<>24 AND tp.id_base=515 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<>24 AND tp.id_base=515 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





	3 March 2019, 19:00 - Giuseppe Verdi "La Traviata" (Opera in 2 acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mikhailovsky Theater 3 March 2019, 19:00 - Giuseppe Verdi "La Traviata" (Opera in 2 acts)
3March
19:00
2019 | Sunday
Opera
Mikhailovsky Theater, Saint Petersburg
Duration: 2 hours 30 minutes
World premiere: Mikhailovsky Theater, 24 February 1995

The most lyrical Verdi’s work is La traviata, based on the novel by Alexandre Dumas, fils The Lady of the Camellias. The title La traviata means literally The Fallen Woman, or perhaps more figuratively, The Woman Who Goes Astray. The title character of the play is Marguerite Gautier, who is based on Marie Duplessis, the real-life lover of author Dumas, fils. Duplessis was both a popular courtesan and the hostess of a salon, where politicians, writers, and artists gathered for socializing. Alexandre Dumas, père allegedly insisted on his son splitting up with Duplessis: and when he returned to Paris, she had already died of consumption. Since its debut as a play, numerous editions have been performed at theatres around the world. Giuseppe Verdi attended the Paris première of the play and soon turned to composing the opera. When Dumas, fils heard La traviata, he said: “Nobody would have remembered my Lady of the Camellias in 50 years but for Verdi, who made it immortal”.

Libretto by Francesco Maria Piave after the play La dame aux Camélias by Alexandre Dumas fils 

Stage Director: Stanislav Gaudasinsky
Stage Designer: Vyacheslav Okunev
Lighting Designer: Mikhail Mekler
Director: Margarita Kunitsyna-Tankevich
Choreography: Stanislav Gaudasinsky, Evgeny Myasishchev
Artistic Director and Principal Conductor of the Chorus: Vladimir Stolpovskikh
Principal Pianist: Natalia Dudik
Chorus Masters: Alexey Dmitriev, Sergey Tsyplenkov
Surtitles: Margarita Kunitsyna-Tankevich
Stage Manager: Olga Kokh 

It is no exaggeration to say that La traviata is the best known and most loved opera in the world. A connoisseur of human emotion, Verdi’s music so precisely conveys the many shades of emotion, that the feelings seep unimpeded into the heart of the listener, forcing one to live through the story along with the heroine.
La traviata is based on the famous novel The Lady of the Camellias by Alexandre Dumas, fils. Contemporaries claimed that the novel was a fictionalized account of the real story of the author’s relationship with Marie Duplessis. With her intelligence and beauty, the young courtesan conquered Parisian high society as well as the young Dumas himself, who was drawn to her for her sincerity and the beauty of her soul. And though the word ‘traviata’ means, in translation from the Italian, ‘fallen woman’, the opera La traviata is a story about how a person is elevated by love. This contrast serves as a foothold in the whirlpool of feelings which immerses the audience in this wonderful performance.

SYNOPSIS

Act I

Scene 1
Violetta Valery, a courtesan, throws a lavish party at her salon to celebrate her recovery from an illness. A guest of hers, Alfredo Germont falls in love with Violetta at first sight. On guests’ request Alfredo gives a toast — a drinking song. From the next room, the orchestra begins to play and the guests move there to dance waltz. Violetta feels dizzy and Alfredo stays with her. He convinces to change her lifestyle and declares his love for her.
At first Violetta rejects him with jokes but at the end when Alfredo is about to leave, she gives him a flower and promises a date. As the guests leave, Violetta recollects Alfredo’s declarations: she’s fallen in love for the first time in her life.

Scene 2
Alfredo and Violetta live together in a country house outside Paris. They are happy in the peaceful countryside. Annina, the maid, interrupts Alfredo’s dreaming announcing that Violetta sells everything she owns to support their country life. Alfredo is shocked to learn this and leaves for Paris immediately to settle matters himself.
Violetta is looking through the letters: she has received an invitation from her friend, Flora, inviting her to a ball in Paris. Violetta indifferently lays it aside. Alfredo’s father, Giorgio Germont, arrives. He accuses Violetta of destroying his son’s life and reputation. Violetta is desperate: her love to Alfredo is her only happiness. Her life is very short, she’s death-sick. She finally agrees to leave Alfredo. Violetta writes a farewell letter to Alfredo. Alfredo returns to find weeping Violetta, and after her leaving he finds the letter. Giorgio asks his son to come back to his family in Provence, but Alfredo wouldn’t listen: he’s noticed Flora’s invitation to the ball. Now he’s sure that Violwhile they lived together. etta has left him forever. Jealous Alfredo rushes to Paris.

Act II

Scene 3
A party at Flora’s house. Alfredo is playing cards among other guests. Violetta arrives with Baron Douphol. Flora is happy to see her but Violetta feels terrible at the ball: she’s concerned about Alfredo. He picks a quarrel with Baron. Violetta is worried; she tries to prevent a duel. But Alfredo humiliates Violetta in front of the guests and then throws his money at her for her ‘services’ while they lived together. 

Scene 4
Violetta whose tuberculosis has worsened is fading. She has been left by all the friends. Dr. Grenville is trying to encourage her but Violetta knows she’s going to die. She asks the maid to distribute the money to the poor and stays alone to read Giorgio Germont’s letter: he announces the soon arrival of Alfredo. Now Alfredo knows everything: Giorgio has told him about Violetta’s sacrifice.
Annina rushes in the room to tell Violetta of the arrival of Alfredo. The lovers are reunited. Alfredo suggests that they leave Paris and start a new life together. But it is too late; Violetta knows her time is up though she doesn’t want to die at the moment. The old Germont understands that his consent to their marriage is belated to save Violetta. Violetta dashes to Alfredo and dies in his arms. 

Casts & Credits

Composer: Giuseppe Verdi
Opera company: Mikhailovsky Opera
Musical Director: Andrei Anikhanov
Principal Chorus Master: Alexandr Chernov
Set Designer: Vyacheslav Okunev
Composer: Giuseppe Verdi
Opera company: Mikhailovsky Opera
Musical Director: Andrei Anikhanov
Principal Chorus Master: Alexandr Chernov
Set Designer: Vyacheslav Okunev