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=135) 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=135) 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<>135 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<>135 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 March 2019, 19:30 - Giacomo Puccini "Tosca" (Opera in 3 Acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Hermitage Theatre 6 March 2019, 19:30 - Giacomo Puccini "Tosca" (Opera in 3 Acts)
6March
19:30
2019 | Wednesday
Opera
Hermitage Theatre, Saint Petersburg
World premiere: Teatro Costanzi, Rome, 14 January 1900

Victorien Sardou’s drama La Tosca was created for the great actress Sarah Bernhardt. Puccini saw Sardou’s play when it was touring Italy in 1889 and, after some vacillation, obtained the rights to turn the work into an opera six years later. Turning the wordy French play into a succinct Italian opera took four years, during which the composer repeatedly argued with his librettists and publisher. The work is a melodramatic piece set in Rome in June 1800, with the Kingdom of Naples’s control of Rome threatened by Napoleon’s invasion of Italy. It contains depictions of torture, murder and suicide, yet also includes some of Puccini’s best-known lyrical arias, and has inspired memorable performances from many of opera’s leading singers. The dramatic force of Tosca and its characters continues to fascinate both performers and audiences, and the work remains one of the most frequently performed operas.
Music by Giacomo Puccini
Libretto by Luigi Illica and Giuseppe Giacosa after the play of the same name by Victorien Sardou


Mariinsky Theatre Chorus, Children’s Chorus and Symphony Orchestra
Principal Chorus Master: Andrei Petrenko
Children’s Chorus Master: Dmitry Ralko
Musical Preparation: Alla Brosterman

Synopsis

Act I

Cesare Angelotti, an escaped political prisoner, runs into the church of Sant’Andrea della Valle to hide in the Attavanti family chapel. At the sound of the Angelus, the Sacristan enters to pray. He is interrupted by Mario Cavaradossi, who has come to work on his portrait of Mary Magdalene - inspired by the Marchesa Attavanti, Angelotti’s sister. Mario contrasts the beauty of the blond Marchesa with that of the woman he loves, the raven-haired singer Floria Tosca ("Recondita armonia").

Angelotti ventures out and is recognized by Mario, who gives him food and hurries him back into the chapel as Tosca is heard calling outside. She jealously questions Mario, then prays and reminds him of their rendezvous that evening ("Non la sospiri la nostra casetta"). Recognizing the Marchesa’s likeness in the painting, she explodes with renewed suspicions, but he reassures her ("Qual’occhio al mondo"). When she has left, Mario summons Angelotti as a cannon signals that the police have discovered the escape; the two flee to Mario’s villa.

Napoleon’s army is supposed to have suffered defeat, and the Sacristan returns with choirboys who are about to sing a Te Deum. Their excitement is silenced by the entrance of Baron Scarpia, chief of the secret police, in search of Angelotti. When Tosca comes back looking for Mario, she encounters Scarpia, who shows her the Attavanti crest on a fan he has just found. Thinking Mario faithless, Tosca tearfully vows vengeance and leaves as the church resounds with the Te Deum. Scarpia has the diva trailed, scheming to get her in his power ("Va, Tosca!").

Act II

In the Farnese Palace, Scarpia anticipates the pleasure of bending Tosca to his will ("Ha piu forte sapore").
The spy Spoletta arrives, not having found Angelotti; to placate the baron, he brings in Mario, who is interrogated while Tosca is heard singing at a royal gala downstairs. She enters as her lover is being taken to an adjoining room for torture. Unnerved by Scarpia’s questioning and Mario’s screams, she reveals Angelotti’s hiding place.

Mario is carried in; realizing what has happened, he rages at Tosca, but the gendarme Sciarrone rushes in to announce that Napoleon has won the Battle of Marengo, a defeat for Scarpia’s side. Mario shouts his defiance ("Vittoria!").

Tosca yields to Scarpia in exchange for her lover’s life. Fighting him off, she protest her fate to God, having dedicated her life to art and love ("Vissi d’arte").

Spoletta interrupts: faced with capture, Angelotti has killed himself. Tosca, forced to decide, agrees to Scarpia’s proposition. The baron pretends to order a mock execution for the prisoner, after which he is to be free. Spoletta leaves.

Scarpia prepares a document of safe-conduct for the lovers. When he embraces her, Tosca stabs him with a knife, wrenches the document from his fingers and, placing candles at his head and a crucifix on his chest slips quietly out.

Act III

The voice of a shepherd is heard as church bells toll the dawn. Mario is led to the roof of Castel Sant’Angelo prison to await execution; he bribes the jailer to convey a farewell note to Tosca. Writing it, overcome with memories of love, he gives way to despair ("E lucevan le stele").

Suddenly Tosca runs in, filled with the story of her recent adventure. Mario caresses the hands that committed the murder for his sake ("O dolci mani"), and the two hail the future.

As the firing squad appears, the diva coaches Mario on how to fake his death convincingly; the soldiers fire and depart. Tosca urges Mario to hurry, but when he fails to move, she discovers that Scarpia’s treachery has transcended the grave: the bullets were real.

Spoletta rushes in to arrest Tosca. She climbs the battlements and, crying that she will meet Scarpia before God, leaps to her death.

Composer: Giacomo Puccini
Composer: Giacomo Puccini