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

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<>201 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





	,  - "Lohengrin" - R.Wagner (Opera in three acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Moscow theatre "New Opera" , - "Lohengrin" - R.Wagner (Opera in three acts)
|
Opera
Moscow theatre "New Opera", Moscow
Duration: 3 hours 40 minutes
World premiere: Moscow theatre "New Opera", 28 February 2008

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 Director: Jan Latham-Koenig
Conductors: Jan Latham-Koenig, Valery Kritskov, Evgeny Samoilov
Stage Director: Kasper Holten
Stage Director assistant: Mette Hedegaard
Set and Costume Designer: Steffen Aarfing
Lighting Designer: Jesper Kongshaug
Chief choirmaster: Natalya Popovich
Choirmaster: Yulia Senyukova

Performed in German

For the first time in 70 years, Richard Wagner’s Lohengrin has been staged in Moscow. The old tale of Lohengrin, the mysterious knight of the Holy Grail, is romantic and, at the same time, frightening. The knight plays a decisive role both in the fate of Elsa, who is slanderously accused of having murdered her missing brother, and of the country plunged into chaos. He comes to Elsa's rescue and is ready to lead the country on condition that she never asks his name or origin. The girl breaks her oath, asking her beloved to reveal his mystery. Lohengrin discloses his identity, bringing Elsa’s brother back to her, but has to leave her for ever.
 

To work on its production of the opera, the Novaya Opera Theatre has invited Maestro Jan Latham-Koenig, a leading European conductor and a connoisseur of Wagnerian style, who many times conducted Lohengrin in different opera houses of the world. The maestro has always considered Wagner a special composer because of his unique music personality. What interests him in Lohengrin is not only the splendid music, but also the opera’s philosophic and historical aspects. According to Latham-Koenig, the production of Wagner’s Lohengrin in Novaya Opera is an important cultural event.

 

Novaya Opera’s Lohengrin has been produced by director Kasper Bech Holten and set designer Steffen Aarfing of the Danish Royal Opera, who scored a tremendous success with their staging of the four-opera cycle The Ring of the Nibelung at the Danish Royal Opera in 2003–2006.

 

Says Kasper Holten:
“The opera “Lohengrin” is interesting from two viewpoints. First, it is a love story in which a woman tries to love a man whom she will never be able to fully understand. Second, it is a story of a society in crisis, searching for a new way of development. The main hero, who at first looks bright and brilliant, may turn out not to be the one we are taking him for. As the story progresses, we begin to doubt whether he is really a hero”.