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-05-14' AND tmp.date<='2024-06-03' AND tmp.perf_id=64) 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-05-14' AND '2024-06-03' AND tmp.perf_id=64) 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<>64 AND tp.id_base=532 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<>64 AND tp.id_base=532 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





	18 December 2018, 19:00 - Pietro Mascagni "Cavalleria Rusticana" (opera in one act) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mikhailovsky Theater 18 December 2018, 19:00 - Pietro Mascagni "Cavalleria Rusticana" (opera in one act)
18December
19:00
2018 | Tuesday
Opera
Mikhailovsky Theater, Saint Petersburg
Duration: 1 hour 45 minutes
World premiere: Mikhailovsky Theater, 25 January 2008

Cavalleria rusticana is the short opera that has all the elements of a grand opera compressed into a single highly dramatic time span. The story of love, lust, blood-feud and betrayal played out against the pageantry of the Easter celebrations in a Sicilian village delivers an emotional wallop because of the youthful vigour and musical wealth of its great score which includes the glorious Easter Hymn and the deeply moving Intermezzo. Mascagni was never to repeat his youthful success but this brief work is enough to ensure his immortality.

Libretto by Giovanni Targioni-Tozzetti and Guido Menasci after the novel by Giovanni Verga 

Stage Director: Liliana Cavani
Stage Designer: Dante Ferretti
Costume Designer: Gabriella Pescucci
Director: Marina Bianchi
Assistant to Stage Designer: Leila Fteita
Musical Director of the production: Daniele Rustioni
Artistic Director of the Production: Elena Obraztsova
Artistic Director and Principal Conductor of the Chorus: Vladimir Stolpovskikh
Principal Pianist: Irina Dayneko
Chorus Masters: Alexey Dmitriev, Sergey Tsyplenkov
Curator of the project: Yulia Prokhorova
Consultant in the Italian language: Daria Mitrofanova
Surtitles: Margarita Kunitsyna-Tankevich
Stage Manager: Olga Kokh 

A disciple of Luchino Visconti, the world-famous cinema director, the creator of The Night Porter, Liliana Cavani has directed many opera stage productions. The famous Ravenna music festival saw her productions of Cavalleria rusticana by Pietro Mascagni (1996) and Pagliacci (1998) by Ruggiero Leoncavallo. Cavani’s attention to Mascagni and Leoncavallo could be explained by her interest in verismo — a style in Italian opera that started in 1890. The ultimate simplicity of the subjects taken by the verists from the ordinary life are typical for that kind of the operas. Ordinary life never lacks tragedies. The intense plot jammed into one action — premonition of a catastrophe and bloody payoff — couldn’t fail to attract Liliana Cavani. “Cinema is a sort of psychoanalysis for me”, the director says. Opera productions are psychoanalytical too. In her production of Cavalleria rusticana Liliana Cavani doesn’t confine herself to a sentimental story of a love triangle, she involves the audience into the production, makes them witnesses and accomplices of love, betrayal, murder.

SYNOPSIS

Sicilian village morning is brightened by the holiday preparations: it is Easter. Modest landscape blossoms with the song of a handsome young man Turiddu, who glorifies his beloved Lola. All Italian passion vibrates in his voice. Unfortunately, neither the happiness of a great holiday nor the nature’s harmony could console Santuzza rejected by Turiddu. His affection was a fleeting passion — an indemnity for Lola’s betrayal. Santuzza, who carries Turiddu’s baby under her heart, maddened from jealousy and sorrow doesn’t dare to step into the temple to find comfort in its walls. In desperate seeking for Turiddu she rushes to his mother Lucia, the mistress of the tavern.
Alfio — Lola’s husband — is happy: the things are going well, his beautiful wife decided not to wait for beloved Turiddu’s return who became a soldier, instead she preferred a stable life with Alfio — the richest man in the village. However, everyone besides him knows hardly had insulted Turiddu turned Santuzza’s head, when Lola remembered her passion. Santuzza has no defenders, even Lucia cannot console her. Desperation brings her to Alfio: but only for a second she finds relief for her soul — while telling him about the faithlessness of Lola and Turiddu. An unexpected grief of a betrayed husband finds its only way out — in cold revenge.A cheering crowd on the way from Easter service enters Lucia’s tavern to have a glass of wine. Turiddu offers a drink to Alfio but the rival’s wine could only poison Alfio, so he denies the glass. Turiddu splashes out the glass and challenges Alfio for a duel: according to Sicilian manners, Turiddu bites Alfio’s ear. Wine whispers Turiddu about his close death and sudden remorse remind him of his responsibilities. Turiddu is willing to wash away Santuzza’s disgrace with his own blood — the disgrace of the girl, who fell as a victim of his offended pride. Ready to deal with his rival, full of remorse — Turiddu entrusts Santuzza to his mother Lucia’s care for ever.

Casts & Credits

Composer: Pietro Mascagni
Opera company: Mikhailovsky Opera
Mezzo soprano: Ildiko Komlosi
Costume Designer: Gabriella Pescucci
Director: Marina Bianchi
Musical Director: Daniele Rustioni
Production: Liliana Cavani
Set Designer: Dante Ferretti
Composer: Pietro Mascagni
Opera company: Mikhailovsky Opera
Mezzo soprano: Ildiko Komlosi
Costume Designer: Gabriella Pescucci
Director: Marina Bianchi
Musical Director: Daniele Rustioni
Production: Liliana Cavani
Set Designer: Dante Ferretti