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

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<>192 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





	,  - Tosca (Opera in 3 acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Stanislavsky theatre , - Tosca (Opera in 3 acts)
|
Opera
Stanislavsky theatre, Moscow
Duration: 2 hours 45 minutes
World premiere: Teatro Costanzi, Rome, 30 January 2004

Libretto- L. Illica, V. Sardu and G. Jakoza after the play of the same name by V.Sardou Conductor-co-producer - Ara Karapetyan Director - Lyudmila Naletova Design - Natalia Stepanova
Music  Giacomo Puccini
Libretto  Luigi Illica & Giuseppe Giacosa
Music Director  Wolf Gorelik
Conductor  Vyacheslav Volich
Stage Director  Lyudmila Naletova
Set Designer  Elena Stepanova
Costume Designer  Elena Stepanova
Principal Chorus Master  Stanislav Lykov
Overview

 

Cruel and lustful Scarpia, tender Tosca, capricious and jealous but nothing if not loving and courageous, an only woman in the opera, Cavaradossi, a painter, fond of life and its joys with poetical naivety, an artful background, a combination of voluptuousness and trials, love for life and suppression – all the elements create a kind of a gravestone. Beauty and love celebrate victory, earned in torments in the face of death.

Gustavo Marchesi

Сast
Conductor 
Vyacheslav Volich
Floria Tosca 
Irina Vashchenko
Natalia Muradymova
Mario Cavaradossi 
Nikolay Erokhin
Najmiddin Mavlyanov
Arsen Sogomonyan
Baron Scarpia 
Evgeny Polikanin
Alexey Shishlyaev
Cesare Angelotti 
Roman Ulybin
Sacristan 
Maxim Osokin
Vladimir Svistov
Spoletta 
Evgeny Liberman
Valery Mikitsky
Sciarrone 
Mikhail Golovushkin
Felix Kudryavtsev
Jailer 
Mikhail Golovushkin
Felix Kudryavtsev

 

Synopsis

ACT I.

Cesare Angelotti, an escaped political prisoner, rushes into the church of Sant’ Andrea della Valle to hide in the Attavanti chapel. As he vanishes, an old Sacristan shuffles in, praying at the sound of the Angelus. Mario Cavaradossi enters to work on his portrait of Mary Magdalene - inspired by the Marchesa Attavanti (Angelotti’s sister), whom he has seen but does not know. Taking out a miniature of the singer Floria Tosca, he compares her raven beauty with that of the blonde Magdalene ("Recondita armonia"). The Sacristan grumbles disapproval and leaves. Angelotti ventures out and is recognized by his friend and fellow liberal Mario, who gives him food and hurries him back into the chapel as Tosca is heard calling outside. Forever suspicious, she jealously questions him, then prays, and reminds him of their rendezvous that evening at his villa ("Non la sospiri la nostra casetta?"). Suddenly recognizing the Marchesa Attavanti in the painting, she explodes with renewed suspicions, but he reassures her ("Qual’ occhio al mondo"). When she has gone, Mario summons Angelotti from the chapel; a cannon signals that the police have discovered the escape, so the two flee to Mario’s villa. Meanwhile, the Sacristan returns with choirboys who are to sing in a Te Deum that day. Their excitement is silenced by the entrance of Baron Scarpia, chief of the secret police, in search of Angelotti. When Tosca comes back to her lover, Scarpia shows her a fan with the Attavanti crest, which he has just found. Thinking Mario faithless, Tosca tearfully vows vengeance and leaves as the church fills with worshipers. Scarpia, sending his men to follow her to Angelotti, schemes to get the diva in his power ("Va, Tosca!").

ACT II.

In the Farnese Palace, Scarpia anticipates the sadistic 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 a cantata at a royal gala downstairs. She enters just as her lover is being taken to an adjoining room: his arrogant silence is to be broken under torture. Unnerved by Scarpia’s questioning and the sound of Mario’s screams, she reveals Angelotti’s hiding place. Mario is carried in; realizing what has happened, he turns on Tosca, but the officer Sciarrone rushes in to announce that Napoleon has won the Battle of Marengo, a defeat for Scarpia’s side. Mario shouts his defiance of tyranny ("Vittoria!") and is dragged to prison. Scarpia, resuming his supper, suggests that Tosca yield herself to him in exchange for her lover’s life. Fighting off his embraces, she protests her fate to God, having dedicated her life to art and love ("Vissi d’arte"). Scarpia again insists, but Spoletta interrupts: faced with capture, Angelotti has killed himself. Tosca, forced to give in or lose her lover, agrees to Scarpia’s proposition. The baron pretends to order a mock execution for the prisoner, after which he is to be freed; Spoletta leaves. No sooner has Scarpia written a safe-conduct for the lovers than Tosca snatches a knife from the table and kills him. Wrenching the document from his stiffening fingers and placing candles at his head and a crucifix on his chest, she slips from the room.

ACT III.

The voice of a shepherd boy is heard as church bells toll the dawn. Mario awaits execution at the Castel Sant’Angelo; 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 stelle"). Suddenly Tosca runs in, filled with the story of her recent adventures. Mario caresses the hands that committed murder for his sake ("O dolci mani"), and the two hail their 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. When Spoletta rushes in to arrest Tosca for Scarpia’s murder, she cries to Scarpia to meet her before God, then leaps to her death.