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=143) 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=143) 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<>143 AND tp.id_base=493 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<>143 AND tp.id_base=493 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





	17 November 2018, 18:00 - Richard Wagner "Lohengrin" romantic opera in three acts (revival of the 1999 production) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theatre - Mariinsky II 17 November 2018, 18:00 - Richard Wagner "Lohengrin" romantic opera in three acts (revival of the 1999 production)
17November
18:00
2018 | Saturday
Opera
Mariinsky Theatre - Mariinsky II, Saint Petersburg
Duration: 4 hours 35 minutes
World premiere: Mariinsky Theatre, St Petersburg, 1 July 1999

Lohengrin is a romantic opera in three acts composed and written by Richard Wagner, first performed in 1850. The story of the eponymous character is taken from medieval German romance, notably the Parzival of Wolfram von Eschenbach and its sequel, Lohengrin, written by a different author, itself inspired by the epic of Garin le Loherain. It is part of the Knight of the Swan tradition. The opera has proved inspirational towards other works of art. Among those deeply moved by the fairy-tale opera was the young King Ludwig II of Bavaria. 'Der Märchenkönig' ('The Fairy-tale King') as he was dubbed later built his ideal fairy-tale castle and dubbed it "New Swan Stone," or "Neuschwanstein", after the Swan Knight. It was King Ludwig's patronage that later gave Wagner the means and opportunity to build a theatre for, compose and stage his epic cycle, the Ring of the Nibelung. The most popular and recognizable part of the opera is the Bridal Chorus known better as "Here Comes the Bride", played at weddings in the West.

Music by Richard Wagner
Libretto by the composer

Musical Director - Valery Gergiev
Renewal directors: Marina Mishuk and Alexander Maskalin
Scenography - Evgeny Lysyk
Production designer - Tadej Ryndzak (based on sketches by E. Lysyk)
Costume designer - Oksana Zinchenko (based on sketches by E. Lysyk)
Lighting Designer - Yegor Kartashov
Responsible accompanist - Marina Mishuk
The main choirmaster is Andrei Petrenko
Chorus Master of Children's Choir - Irina Yatseemirskaya

Synopsis

Act 1

King Henry the Fowler has arrived in Brabant where he has assembled the German tribes in order to expel the Hungarians from his dominions. He also needs to settle a dispute involving the disappearance of the child-Duke Gottfried of Brabant. The Duke's guardian, Count Friedrich von Telramund, has accused the Duke's sister, Elsa, of murdering her brother in order to become the Duchess of Brabant. He calls upon the King to punish Elsa and to make him, Telramund, the new Duke of Brabant, since he is the next of kin to the late Duke, after having renounced his right to Elsa's hand in matrimony, having taken Ortrud instead.
The King calls for Elsa to answer Telramund's accusation. She enters, surrounded by her attendants. She does not answer to the King's inquiries, only lamenting her brother's fate. The King declares that he cannot resolve the matter and defers it to God's judgment through ordeal by combat. Telramund, a strong and seasoned warrior, agrees enthusiastically. When the King asks Elsa who shall be her champion, Elsa describes a knight she has beheld in her dreams (Narrative: "Alone in dark days").
Twice the Herald sounds the horn in summons, without response. Elsa sinks to her knees and prays to God. A boat drawn by a swan appears on the river and in it stands a knight in shining armour. He disembarks, dismisses the swan, respectfully greets the king, and asks Elsa if she will have him as her champion. Elsa kneels in front of him and places her honour in his keeping. He asks but one thing in return for his service: she is never to ask him his name or where he has come from. Elsa agrees to this.
Telramund's people advise him to withdraw because he cannot prevail against the Knight's powers, but he proudly refuses and the combat area is prepared. The company prays to God ("Herr und Gott") for victory for the one whose cause is just. Ortrud privately expresses confidence that Telramund will win. The combat commences. The unknown knight defeats Telramund but spares his life. Taking Elsa by the hand, he declares her innocent and asks for her hand in marriage. The crowd exits, cheering and celebrating.

Act 2
Night in the courtyard outside the cathedral
Telramund and Ortrud, banished, listen unhappily to the distant party-music. Ortrud reveals that she is a pagan witch (daughter of Radbod Duke of Frisia), and tries to revive Telramund's courage, assuring him that her people (and he) are destined to rule the kingdom again. She plots to induce Elsa to violate the mysterious knight's only condition.
When Elsa appears on the balcony in the twilight before dawn she hears Ortrud lamenting and pities her. While Elsa descends to open the castle door, Ortrud prays to her pagan gods, Wodan and Freia, for malice, guile, and cunning, in order to deceive Elsa and restore pagan rule to the region. When Elsa appears, Ortrud warns her that since she knows nothing about her rescuer, he could leave her any time, as suddenly as he came, but Elsa is sure of the virtues of her rescuer.
The sun rises and the people assemble. The Herald announces that Telramund is now outlawed due to the false trial, and that anyone who follows Telramund is an outlaw by the law of the land. In addition, he announces that the king has offered to make the unnamed knight the Duke of Brabant; however, the Knight has declined the title, and prefers to be known only as "Protector of Brabant". The Herald further announces that the Knight will lead the people to glorious new conquests, and will celebrate the marriage of him and Elsa. Behind the crowd, four noblemen quietly express misgivings to each other because the Protector of Brabant has rescinded their privileges and is calling them to arms. Telramund appears, and, concealing himself from the crowd, draws these four knights aside and assures them that he will regain his position and stop the Knight, by accusing him of sorcery.
As Elsa and her attendants are about to enter the church, Ortrud, as part of her retinue, challenges Elsa to tell who her husband is, and to explain why anyone should follow him. The King enters with the Knight. Elsa tells both of them that Ortrud was interrupting the ceremony. The Knight tells Ortrud to go back into the crowd, then takes Elsa to the wedding. The King leads at the front of the couple. When they are about to go inside the church (once more), Telramund also enters. He pleads to the king that his defeat in combat was invalid because the Knight did not give his name (trial by combat traditionally being open only to established citizens), then accuses him of sorcery. The Knight refuses to reveal his identity and claims that only one person in the world has the right to know his origin – his beloved Elsa and no other person. Elsa, though visibly shaken and uncertain, assures him of her confidence. King Henry refuses Telramund's questioning of the Knight's name to the Knight, and the nobles of Brabant and Saxony praise and give respect to the Knight. Elsa, not seeing her beloved, falls back to the crowd where Ortrud and Telramund take her and try to intimidate her, but the Knight forces both to leave the ceremony. The Knight consoles Elsa. Finally, the King, the Knight and Elsa, together with the men and women around, go forward. Elsa takes one last look at the banished Ortrud, then they enter the church.

Act 3
Scene 1: The bridal chamber
Elsa and her new husband are ushered in with the well-known bridal chorus, and the couple express their love for each other. Ortrud's words, however, are impressed upon Elsa, she laments that her name sounds so sweet in her husband's lips but she cannot utter his name, afterwards she asks him to confide on her his name to keep it secret, when no one is around, but at all instances he refuses, finally, despite his warnings, she asks her husband the fatal questions. Before the Knight can answer, Telramund and his four recruits rush into the room in order to attack him. The knight defeats and kills Telramund. Then, he sorrowfully turns to Elsa and asks her to follow him to the king, to whom he will now reveal his mystery.
Scene 2: On the banks of the Scheldt (as in Act 1)
The troops arrive equipped for war. Telramund's corpse is brought in, Elsa comes forward, then the Knight. He tells the King that Elsa has broken her promise and he discloses his identity by telling the story of the Holy Grail, on Monsalvat, and reveals himself as Lohengrin, Knight of the Holy Grail and son of King Parsifal sent to protect an unjustly accused woman. The rules of the Holy Grail determine that Knights of the Grail must remain anonymous, retiring from all human sight if their identity is revealed; so the time for his return has come.
As he sadly bids farewell to his beloved bride, the swan reappears. Lohengrin tells Elsa that if she had maintained her oath, she could have recovered her lost brother, and gives her his sword, horn and ring, for he is to become the future leader of Brabant. Then, when Lohengrin tries to get in the boat, Ortrud appears. She tells Elsa that the swan who drove Lohengrin to the bank was actually Gottfried, Elsa's brother, on whom she put a curse by transforming him into a swan. The people consider Ortrud guilty of witchcraft. Lohengrin prays and the swan turns into another form, a young Gottfried. He elects him as the Duke of Brabant. Ortrud sinks as she sees Gottfried and her plans thwarted.
A dove descends from heaven and, taking the place of the swan at the head of the boat, leads Lohengrin to the castle of the Holy Grail. Elsa is stricken with grief and falls to the ground dead.

Casts & Credits

Composer: Richard Wagner
Lighting Designer: Vladimir Lukasevich
Musical Director: Maestro Valery Gergiev
Musical Preparation: Marina Mishuk
Principal Chorus Master: Andrei Petrenko
Composer: Richard Wagner
Lighting Designer: Vladimir Lukasevich
Musical Director: Maestro Valery Gergiev
Musical Preparation: Marina Mishuk
Principal Chorus Master: Andrei Petrenko