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





	21 January 2020, 19:00 - I Pagliacci (opera in two acts with a prologue) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mikhailovsky Theater 21 January 2020, 19:00 - I Pagliacci (opera in two acts with a prologue)
21January
19:00
2020 | Tuesday
Opera
Mikhailovsky Theater, Saint Petersburg
Duration: 1 hour 50 minutes
World premiere: Mikhailovsky Theater, 27 November 2008

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.

Libretto by Ruggero Leoncavallo 

Stage Director: Liliana Cavani
Stage Designer: Dante Ferretti
Costume Designer: Gabriella Pescucci
Musical Director of the production: Daniele Rustioni
Lighting Designer: Gianni Mantovanini
Choreographer: Micha van Hoecke
Principal Pianist: Natalia Dudik 

The Mikhailovsky Chorus Artistic Director and Principal Conductor of the Chorus: Vladimir Stolpovskikh
Chorus Masters: Alexey Dmitriev, Sergey Tsyplenkov 

Children’s Choir of St Petersburg TV and Radio
Principal Chorus Master: Igor Gribkov 

Associate Stage Director: Marina Bianchi
Assistant to Stage Designer: Leila Fteita
Assistant to Costume Designer: Massimo Cantini
Panini Director: Yulia Prokhorova
Consultant in the Italian language: Daria Mitrofanova
Surtitles: Margarita Kunitsyna-Tankevich
Stage Manager: Olga Kokh 

Pagliacci is staged by the renowned stage director Liliana Cavani, who has already staged Cavalleria rusticana at the Mikhailovsky Theatre. She cooperated with the brilliant team of Dante Ferretti and Gabriella Pescucci.
The secret of the world success of Pagliacci is a combination of simplicity of the plot and great music. The movable feast of the itinerant artists ends in a sad way: husband kills his wife and her lover. And the audience is not quite sure till the very end if the tragedy is only theatrical or not.

SYNOPSIS

Clown Tonio addresses the audience from behind the curtain: he reminds the pubic that the piece which is going to be presented depicts the real life and sincere feelings of the characters. The point of his speech is the fact that actors are people, who love and suffer like everybody else.
The square is crowded with people. They welcome the commedia troupe entering the village. Everybody’s waiting for a funny performance, full of jokes and tricks. Canio, head of the troupe, promises not to disappoint the public and show them a play about the troubles of Pagliaccio. The villagers suggest drinking at the tavern before the performance. Canio and Beppo accept. Tonio stays with Nedda, Canio’s wife, hoping to confess his love. But she rejects the hapless admirer, striking him with a whip. Tonio is enraged, he seeks revenge. Soon he has a chance: he sees Silvio, who enjoys the mutual love of Nedda, coming to her. Nedda assents to Silvio’s solicitations and promises to leave her husband and flee with him. Tonio eavesdrops on their conversation. He can get revenge! Tonio immediately brings Canio to the place. Silvio manages to escape. Canio demands that Nedda tell him the name of her lover, but she refuses. He threatens her with a knife, but Beppo disarms him. Beppo insists that they prepare for the performance.
The crowd in the square has gathered for the performance. The play begins. Colombina has prepared dinner and awaits her lover Arlecchino, who soon serenades her from beneath her window. Colombina’s servant Taddeo returns from the market and confesses his love, but Colombina mocks him and lets in Arlecchino through the window. He boxes Taddeo’s ears and kicks him out of the room, and the audience laughs. The sweet date is interrupted by Colombina’s husband. Canio, playing the role of Pagliaccio, suffers from jealousy again. Unable to cope with the situation, he stabs Colombina-Nedda. Silvio rushes to help her but is also stabbed by Canio. ‘The comedy is over’, announces Tonio.

Casts & Credits

Opera company: Mikhailovsky Opera
Conductor: Pavel Petrenko
Costume Designer: Gabriella Pescucci
Set Designer: Dante Ferretti
Stage Director: Liliana Cavani
Opera company: Mikhailovsky Opera
Conductor: Pavel Petrenko
Costume Designer: Gabriella Pescucci
Set Designer: Dante Ferretti
Stage Director: Liliana Cavani