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-23' AND tmp.date<='2024-05-13' AND tmp.perf_id=1117) 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-23' AND '2024-05-13' AND tmp.perf_id=1117) 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<>1117 AND tp.id_base=2543 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<>1117 AND tp.id_base=2543 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





	,  - Wolfgang Amadeus Mozart "Die Zauberflote" opera in two acts - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mikhailovsky Theater , - Wolfgang Amadeus Mozart "Die Zauberflote" opera in two acts
|
Opera
Mikhailovsky Theater, Saint Petersburg
Duration: 3 hours
World premiere: Mikhailovsky Theater, 22 March 2016

Libretto by Emanuel Schikaneder 

Original staging, sets, costumes, and lighting: Pet Halmen Staging by Éric Vigié
Musical Director of the production: Mikhail Tatarnikov
Artistic Director and Principal Conductor of the Chorus: Vladimir Stolpovskikh
Director’s Assistants: Jean-Philippe Guilois, Yulia Prokhorova
Conductor’s Assistant: Igor Tomashevsky
Principal Pianist: Alexander Pakuev
Chorus Masters: Alexey Dmitriev, Sergey Tsyplenkov
Pianists: Maria Kopyseva, Maria Mikirtumova
Music Style and Language Consultant: Eytan Pessen
Dialogues in translation by Galina Burkova Surtitles: Margarita Kunitsyna-Tankevich
Stage Manager: Olga Kokh
Assistants to Stage Manager: Elena Piskunova, Vyacheslav Kalyuzhny 

 

Mozart’s opera Die Zauberflöte is performed on the Mikhailovsky’s stage in a version first seen at the Opéra de Lausanne in 2010. The well-known German stage designer and director Pet Halmen decided to shift the opera’s setting to the Duchess Anna-Amalia Library in Weimar, home to a priceless collection of rare books and librettos. And although the idea for this arose following a terrible fire that broke out at the library in 2004, destroying most of the rare volumes stored there, many critics in Europe deemed the production to be one of the most vivacious and harmonious interpretations of Die Zauberflöte in the modern era.

Recommended for family viewing

SYNOPSIS

ACT I

A fairy dale. Tamino, a handsome prince, is pursued by a serpent. He asks the gods to save him and faints. Three ladies, attendants of the Queen of the Night, appear and kill the serpent. They find the unconscious prince attractive, and each of them tries to convince the other two to leave. After arguing, they leave together. Tamino wakes up and sees Papageno, a bird-catcher, who complains he has no girlfriend. Tamino thinks that Papageno killed the serpent. Papageno happily takes the credit. The three ladies suddenly reappear and place a padlock over Papageno’s mouth as a warning not to lie. They give Tamino a portrait of the Queen of the Night’s daughter Pamina who has been captured by the evil sorcerer Sarastro. Tamino falls in love with Pamina and vows to rescue her.
The Queen of the Night appears and promises Tamino that Pamina will be his if he rescues her from Sarastro. The ladies remove the padlock from Papageno’s mouth and give Tamino a magic flute, which has the power to change sorrow into joy. They tell Papageno to go with Tamino and give him magic bells for protection. Tamino and Papageno set forth to Sarastro’s temple guided by three child-spirits.
Sarastro’s palace. Monostatos, a blackamoor and chief of the slaves, orders the slaves to chain Pamina and leave him alone with her. Papageno enters. Monostatos and Papageno are each terrified by the other’s strange appearance and both flee. Papageno returns and announces to Pamina that her mother has sent Tamino to save her. Pamina offers sympathy and hope to Papageno, who longs for a wife.
The three child-spirits lead Tamino to Sarastro’s temple. An old priest tells Tamino that Sarastro is not evil and that he should not trust the Queen of the Night. Tamino plays his magic flute and hears Papageno’s pipes. Papageno and Pamina enter. Monostatos and his slaves try to recapture them, but Papageno plays his magic bells making Monostatos dance. Sarastro enters, with a crowd of followers. Pamina confesses that she tried to escape, and Sarastro receives her kindly. Monostatos brings in Tamino and tells Sarastro that he caught Papageno and Pamina and demands a reward. Sarastro, however, punishes Monostatos. He announces that Tamino must undergo trials of wisdom in order to become worthy as Pamina’s husband.

ACT II

Tamino and Papageno are led in by two priests for the first trial. The priests swear them to silence. The three ladies tempt Tamino and Papageno to speak. Papageno cannot resist answering the ladies, but Tamino remains aloof. The ladies withdraw in confusion.
Pamina is asleep. Monostatos approaches and tries to kiss her, when the Queen of the Night appears. She gives Pamina a dagger, ordering her to kill Sarastro, and leaves. Monostatos tries to force Pamina’s love by threatening to reveal the Queen’s plot, but Sarastro enters and drives him off. Pamina begs Sarastro to forgive her mother. He reassures her that revenge and cruelty have no place in his domain.
Tamino and Papageno are led in by priests, who remind them that they must remain silent. Papageno complains of thirst. An old woman enters and offers Papageno a cup of water. He teasingly asks whether she has a boyfriend. She replies that his name is Papageno and disappears. The three child-spirits bring in food, the magic flute, and the bells. Tamino plays the flute, and Pamina appears. She tries to speak with him, but Tamino, bound by his vow of silence, cannot answer her. Pamina thinks that he no longer loves her and leaves in despair.
The priests celebrate Tamino’s successes so far. Sarastro instructs Pamina and Tamino to bid each other farewell before the greater trials ahead. They exit and Papageno enters. The priests grant his request for a glass of wine and he expresses his desire for a wife. The elderly woman reappears and warns him that unless he immediately promises to marry her, he will be imprisoned forever. When Papageno promises to love her faithfully, she is transformed into the young and pretty Papagena. The priests declare that Papageno is not yet worthy of her.
The three child-spirits hail the dawn. They observe Pamina, who is contemplating suicide because she believes Tamino has abandoned her. The child-spirits reassure her of Tamino’s love.
Two men in armour lead in Tamino. Pamina declares her intention to undergo the remaining trials with him. Protected by the magic flute, they pass unscathed through fire and water. Papageno despairs at having lost Papagena and decides to hang himself. The three child-spirits stop him and advise to play his magic bells to summon Papagena. She appears. The happy couple plan their future and dream of the many children they will have together.
Monostatos, the Queen of the Night, and her three ladies plot to destroy the temple but are magically cast out into eternal night. Sarastro announces the sun’s triumph over the night.