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=51) 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=51) 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<>51 AND tp.id_base=534 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<>51 AND tp.id_base=534 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





	9 February 2019, 19:30 - Ruggero Leoncavallo "Pagliacci" (opera in two acts and a prologue) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theater 9 February 2019, 19:30 - Ruggero Leoncavallo "Pagliacci" (opera in two acts and a prologue)
9February
19:30
2019 | Saturday
Opera
Mariinsky Theater, Saint Petersburg
Duration: 1 hour 15 minutes
World premiere: Mariinsky Theatre, St Petersburg, Russia, 3 April 2006

The opera Pagliacci is an excellent opera to see. Pagliacci has all the elements of a successful opera and provides a good introduction to what is the opera? Because of its popularity as an opera, Pagliacci pizza outlets have sprung up around the world. The Pagliacci pizza menu sometimes even mirrors the opera theme. In Italian, I Pagliacci means “Clowns”, whereas Il Pagliacci translates as “The Clowns”. For this reason, Pagliacci, the opera, is sometimes referred to as the Italian opera about clowns and is one of the most famous Italian operas.

Music: Ruggero Leoncavallo
Production by Isabelle Partiot-Pieri

Libretto by the composer (performed in Italian)

Stage Director and Set Designer: Isabelle Partiot-Pieri
Lighting Designer: Vladimir Lukasevich

World premiere: May 21, 1892, the theater Dal Verme (Dal Verme), Milan
Premiere of the opera at the Mariinsky Theater: November 23, 1893
Premiere of the production at the Mariinsky Theater: April 3, 2006

The play is without intermission

Synopsis

PROLOGUE

Before the curtain rises Tonio appears dressed as a clown. He explains to the audience what they are about to see on stage. "Real are the tears and suffering that you are to see!" Tonio exclaims. "After all, an actor loves and hates just like everyone else, and a passionate heart beats beneath his clownish attire."

ACT I

The drama begins. A company of travelling comedians arrives in a small Italian village. The villagers joyfully greet Canio, the leader of the company, his actress wife Nedda, Tonio the clown and Beppe the actor. The performance will be in the evening, so one of the villagers suggests the comedians pass their time in the tavern. Canio and Beppe agree readily and ask Tonio to go too, but he declines. He is nursing a grievance against the companyґs jealous leader for offending him. Canioґs jealousy is justified. In the village that they have come to Nedda has a lover – the young peasant Silvio. Left alone, Nedda dreams of meeting him. Having sneaked up unnoticed, Tonio declares his love for her. Nedda responds to the hideous clownґs declarations with derisive laughter, cooling his passions with a lash of a whip. Impotent with rage Tonio leaves, threatening revenge. Meanwhile, despite the danger, Silvio appears, sincerely and lovingly devoted to Nedda. He implores her to abandon her life on the road and run away with him. Suddenly the wrathful voice of the companyґs leader is heard, Canio having rushed back to call for the offended clown. Silvio, however, manages to flee unrecognised. Canio insists that Nedda name her lover, but to no avail. Then he leaps at her with a knife. Beppe pulls Canio off and Tonio calms him, saying that the fugitive will return for the performance and there he will somehow give himself away. The show will begin soon…

ACT II

A merry crowd of villagers awaits the start of the entertainment. Tonio and Beppe show the audience to their seats; Silvio is among them. The plot being acted out is similar to the events in the actorsґ own lives. Taddeo (Tonio) loves Colombina (Nedda), but she loves Arlecchino (Beppe). Pagliaccio (Canio) interrupts their rendezvous. Colombinaґs words of farewell to Arlecchino shock Canio – they are the same words Nedda spoke to her lover as he left. His jealousy flares up once more and in a fit of fury he stabs Nedda to death and then Silvio, who leaps onto the stage on hearing his loverґs dying scream.
"La commedia и finita!" exclaims Tonio.

Casts & Credits

Conductor: Gavriel Heine
Lighting Designer: Vladimir Lukasevich
Musical Preparation: Alla Brosterman
Principal Chorus Master: Pavel Petrenko
Principal Chorus Master: Dmitry Ralko
Stage Director: Isabelle Partiot-Pieri
Conductor: Gavriel Heine
Lighting Designer: Vladimir Lukasevich
Musical Preparation: Alla Brosterman
Principal Chorus Master: Pavel Petrenko
Principal Chorus Master: Dmitry Ralko
Stage Director: Isabelle Partiot-Pieri