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=118) 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=118) 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<>118 AND tp.id_base=510 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<>118 AND tp.id_base=510 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





	6 December 2020, 19:00 - Giacomo Puccini "Tosca" (Opera in 3 Acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theatre - Mariinsky II 6 December 2020, 19:00 - Giacomo Puccini "Tosca" (Opera in 3 Acts)
6December
19:00
2020 | Sunday
Opera
Mariinsky Theatre - Mariinsky II, Saint Petersburg
Duration: 3 hours 10 minutes
World premiere: Mariinsky Theatre, 23 October 1994

Classics of the Italian Opera. This heart-wrenching opera is a tragic tale of love and loss. Though the opera is full of beautiful arias, one of it's most well-known aria's is Vissi d'arte.Tosca sings that though she has been faithful to the Lord and lived her life as loving as she possibly could, she was still rewarded with misfortune.

Music by Giacomo Puccini
Libretto by Luigi Illica and Giuseppe Giacosa after the play of the same name by Victorien Sardou

Musical Director: Valery Gergiev
Stage Director: Paul Curran 
Set Designer and Costume Designer: Paul Edwards
Lighting Designer: David Jaques
Musical Preparation: Alla Brosterman
Principal Chorus Master: Andrei Petrenko
Children’s Chorus Master: Irina Yatsemirskaya

World premiere: 14 January 1900, Teatro Costanzi, Rome
Russian Premiere: 1900, Odessa Opera House, the Italian Private Company
First performed at the Mariinsky Theatre: 4 April 1902, the Lyubimov Private Company
First Mariinsky Theatre production: 23 October 1994
Second Mariinsky Theatre production: 31 May 2007
The Performance has two intermissions

SYNOPSIS
The Church of Sant’Andrea della Valle, Rome

Angelotti, former Consul of the Republic of Rome and now a political prisoner who has escaped from prison, enters exhausted. He hides in the chapel of his sister, the Marchesa Attavanti. The artist Cavaradossi is working on an image of Mary Magdalene. The Sacristan is shocked that the painting resembles a woman in his congregation. Cavaradossi denies the resemblance: only Tosca occupies his thoughts and his brush could paint the features of no-one else. After the Sacristan leaves Angelotti emerges from the chapel. He knows the artist and trusts him, and so he begs for assistance. Hearing Tosca’s voice, he hides again. The singer notices the painting of Mary Magdalene resembles the Marchesa Attavanti. Tosca’s jealousy erupts but the artist manages to pacify her. Floria leaves and Cavaradossi offers the fugitive refuge in his home. Gunshots are heard – the escape has been discovered. The men hurry away.
A celebratory mass begins. Scarpia, chief of police of Rome, and police agent Spoletta are among the worshippers. They are interested in the Attavanti Chapel where they expect to discover Angelotti, but find a fan left there by the Marchesa and an empty food basket. Seeing Tosca return to the church in the hopes of seeing her beloved again, Scarpia decides to seize his opportunity. He cunningly provokes Floria’s jealousy. When she runs out of the church, Scarpia sends police agents after her, believing that the infuriated Tosca will lead them to the artist’s secret hiding place.

The Farnese Palace
Scarpia is in his apartments awaiting news from his agents. His expectations are only half fulfilled: Tosca did lead them to Cavaradossi who has now been arrested but Angelotti remains at liberty. Scarpia hopes to torture the artist into revealing the truth and orders Tosca be brought to him. The chief of police himself begins Cavaradossi’s interrogation but to no avail. The artist manages to whisper to Tosca to keep the secret at all cost. He is led off to be tortured. His groans and screams make Floria lose her self-control and she reveals the secret hiding place in the garden. Scarpia orders an end to the torture.
In agony, Cavaradossi is thrown at Tosca’s feet by the soldiers. He hears the chief of police and understands that the secret has been revealed. He curses Tosca. Scarpia orders that he be taken away and executed in the morning. In answer to Tosca’s pleas, he says he will spare Cavaradossi’s life if she will be his. In Tosca’s presence the chief of police gives an ambiguous command and issues a pass for her and Cavaradossi, allowing them to leave Rome. Tosca, however, does not realise that the execution will be real. Scarpia runs towards Tosca and, defending herself, she kills him. Staring at the corpse in horror, she carefully removes the pass from Scarpia’s hand and slips out of the palace.

The platform of the Castel Sant’Angelo
Cavaradossi’s execution is to take place here. Overwrought, Tosca rushes in and explains it is to be a mock execution. Mario has to play his part well so the soldiers suspect nothing, and then they can flee the city. The soldiers appear. They fire and the artist falls to the ground. Floria calls his name in vain. Realising he is dead, Tosca throws herself from the parapet.

Casts & Credits

Composer: Giacomo Puccini
Baritone: Alexei Markov
Musical Preparation: Alla Brosterman
Principal Chorus Master: Andrei Petrenko
Principal Chorus Master: Dmitry Ralko
Composer: Giacomo Puccini
Baritone: Alexei Markov
Musical Preparation: Alla Brosterman
Principal Chorus Master: Andrei Petrenko
Principal Chorus Master: Dmitry Ralko