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=41) 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=41) 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<>41 AND tp.id_base=537 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<>41 AND tp.id_base=537 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





	7 November 2019, 19:00 - Don Giovanni (dramma giocoso in two acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theater 7 November 2019, 19:00 - Don Giovanni (dramma giocoso in two acts)
7November
19:00
2019 | Thursday
Opera
Mariinsky Theater, Saint Petersburg
Duration: 3 hours 25 minutes
World premiere: Mariinsky Theatre, St Petersburg, 28 November 1999

MAN, MYTH, OR MONSTER? Mozart’s multifaceted portrait of an unrepentant Casanova has fascinated audiences since its 1787 premiere. To this day it endures as opera’s ultimate cautionary tale about the human cost of unbridled lust. Featuring varied, evocative, and absolutely glorious music from overture to epilogue, a dynamic set of distinctively drawn characters, and a shocking, unforgettable finale, “the Don” stands apart as Mozart’s boldest masterpiece.

Production by Johannes Schaaf
Libretto by Lorenzo da Ponte
Stage Director: Johannes Schaaf
Designer: Ralph Koltai
Lighting Designer: Paul Pyant
Principal Chorus Master: Andrei Petrenko
Musical Preparation: Natalia Mordashova

Premiere of this production: 28 November 1999, Mariinsky Theatre, St Petersburg

Performed in Italian

The Performance has one intermission

Synopsis

ACT I:

Seville, 1600s. At night, outside the Commendatore’s palace, Leporello grumbles about his duties as servant to Don Giovanni, a dissolute nobleman. Soon the masked Don appears, pursued by Donna Anna, the Commendatore’s daughter, whom he has tried to seduce. When the Commendatore himself answers Anna’s cries, he is killed in a duel by Giovanni, who escapes. Anna now returns with her fiancй, Don Ottavio. Finding her father dead, she makes Ottavio swear vengeance on the assassin.

At dawn, Giovanni flirts with a high-strung traveler outside a tavern. She turns out to be Donna Elvira, a woman he once seduced in Burgos, who is on his trail. Giovanni escapes while Leporello distracts Elvira by reciting his master’s long catalog of conquests. Peasants arrive, celebrating the nuptials of their friends Zerlina and Masetto; when Giovanni joins in, he pursues the bride, angering the groom, who is removed by Leporello. Alone with Zerlina, the Don applies his charm, but Elvira interrupts and protectively whisks the girl away. When Elvira returns to denounce him as a seducer, Giovanni is stymied further while greeting Anna, now in mourning, and Ottavio. Declaring Elvira mad, he leads her off. Anna, having recognized his voice, realizes Giovanni was her attacker.

Dressing for the wedding feast he has planned for the peasants, Giovanni exuberantly downs champagne.

Outside the palace, Zerlina begs Masetto to forgive her apparent infidelity. Masetto hides when the Don appears, emerging from the shadows as Giovanni corners Zerlina. The three enter the palace together. Elvira, Anna and Ottavio arrive in dominoes and masks and are invited to the feast by Leporello.

During the festivities, Leporello entices Masetto into the dance as Giovanni draws Zerlina out of the room. When the girl’s cries for help put him on the spot, Giovanni tries to blame Leporello. But no one is convinced; Elvira, Anna and Ottavio unmask and confront Giovanni, who barely escapes Ottavio’s drawn sword.

ACT II:

Under Elvira’s balcony, Leporello exchanges cloaks with Giovanni to woo the lady in his master’s stead. Leporello leads Elvira off, leaving the Don free to serenade Elvira’s maid. When Masetto passes with a band of armed peasants bent on punishing Giovanni, the disguised rake gives them false directions, then beats up Masetto. Zerlina arrives and tenderly consoles her betrothed.

In a passageway, Elvira and Leporello are surprised by Anna, Ottavio, Zerlina and Masetto, who, mistaking servant for master, threaten Leporello. Frightened, he unmasks and escapes. When Anna departs, Ottavio affirms his confidence in their love. Elvira, frustrated at her second betrayal by the Don, voices her rage.

Leporello catches up with his master in a cemetery, where a voice warns Giovanni of his doom. This is the statue of the Commendatore, which the Don proposes Leporello invite to dinner. When the servant reluctantly stammers an invitation, the statue accepts.

In her home, Anna, still in mourning, puts off Ottavio’s offer of marriage until her father is avenged.

Leporello is serving Giovanni’s dinner when Elvira rushes in, begging the Don, whom she still loves, to reform. But he waves her out contemptuously. At the door, her screams announce the Commendatore’s statue. Giovanni boldly refuses warnings to repent, even in the face of death. Flames engulf his house, and the sinner is dragged to hell.

Among the castle ruins, the others plan their future and recite the moral: such is the fate of a wrongdoer.

Casts & Credits

Choreography: Gali Abaidulov
Conductor: Zaurbek Gugkaev
Soprano: Anna Denisova
Lighting Designer: Paul Pyant
Musical Director: Maestro Valery Gergiev
Musical Preparation: Natalia Mordashova
Principal Chorus Master: Andrei Petrenko
Stage Director: Johannes Schaaf
Choreography: Gali Abaidulov
Conductor: Zaurbek Gugkaev
Soprano: Anna Denisova
Lighting Designer: Paul Pyant
Musical Director: Maestro Valery Gergiev
Musical Preparation: Natalia Mordashova
Principal Chorus Master: Andrei Petrenko
Stage Director: Johannes Schaaf