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-13' AND tmp.date<='2024-06-02' AND tmp.perf_id=277) 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-13' AND '2024-06-02' AND tmp.perf_id=277) 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<>277 AND tp.id_base=2588 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<>277 AND tp.id_base=2588 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





	,  - Richard Wagner "TRISTAN UND ISOLDE" Music drama in three acts - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Moscow theatre "New Opera" , - Richard Wagner "TRISTAN UND ISOLDE" Music drama in three acts
|
Opera
Moscow theatre "New Opera", Moscow
Duration: 4 hours 40 minutes
World premiere: Moscow theatre "New Opera", 18 May 2013

Tristan and Isolde (in German Tristan und Isolde) is an opera in 3 acts by the composer Richard Wagner.First performed in 1865, Tristan and Isolde is one of Wagner’s best loved operas. Based on a medieval legend, it’s a romantic tragedy of love and death, told through sublime music.

To the 200th Anniversary from the Birth of Richard Wagner

Music Director: Jan Latham-Koenig
Conductors: Jan Latham-Koenig, Vasily Valitov
Stage Director: Nicola Raab
Set and Costume Designer: George Souglides
Lighting Designer: Aivar Salikhov
Choirmaster: Yulia Senyukova

Performed in German

Tristan und Isolde is one of Wagner’s most poignant operas, the peak of the romantic art, the ideal of beauty and expression in music. Its Moscow premiere at the Novaya Opera, the fourth in its Russian history, was the highlight of the 2012–2013 season.
The production was staged by opera director Nicola Raab and designer George Souglides. For the chief conductor Jan Latham-Koenig Tristan und Isolde became his second Wagnerian project at the Novaya Opera after his production of Lohengrin, which was highly acclaimed by the public and critics alike.
In her version Nicola Raab used the sketches made by the famous designer Alfred Roller in 1903 for the legendary production of the opera at the Vienna State Opera staged and conducted by Gustav Mahler.
The podium is taken by Novaya Opera Chief Conductor Jan Latham-Koenig, a connoisseur and brilliant interpreter of Wagnerian music.

“In Tristan Wagner uses a surprisingly modern music idiom. From the very beginning he conducts a revolution opening the way to the music of the 20th century. In this opera there is no traditional overture; of course there is a prelude, but it immediately takes you to another dimension. This happens partly because of its unusual chromatic nature and partly because its depth cardinally differs from any piece that Wagner had composed before. The composer combines his revolutionary approach to the opera with a particular measure of ecstasy in the key musical moments. I mean primarily the love duet. The characters come through several stages of this ecstasy. At first the intensity of emotion rises towards the moment of their meeting; after that Isolde is waiting for Tristan together with Brangäne at the beginning of the second act and Brangäne should signal that he may come. Wagner begins the second act very cleverly. He composed it in Venice in summer, and without realizing it he makes the spectators dizzy with a feeling of a sultry summer Venetian night. The music is saturated with the sound of the sea and makes you almost feel splashes of sea water. The last stage of the love duet is when the characters finally set up a meeting andfly into each other’s arms… The music becomes hysterical, which had not happened to Wagner before. The orchestra is rampaging, expressly, in an exaggerating manner. During the first five minutes the music is so fast, passionate and gasping that it seems the two lovers cannot believe that they are in each other’s arms…When lovers meet after a long parting, the first moments are exactly such as Wagner described them. Then everything gradually calms down… they fall into deep calm dreamy ecstasy, which is interrupted by Brangäne’s terrible warning about the coming day,and Tristan and Isolde must be careful. Preoccupied with themselves, the lovers do not realize it. And for the first time sounds the theme that comes again later in “Isolde’s Death” at the end of the opera when they declare claim their everlasting love, pronouncing each other’s names. But it is intellectual love with a lot of conversation. Here Toscanini’s comment comes to your mind. He conducted this opera several times and once he said: “These Germans are incredible.If they were Italians, they would already have had many children. But as they are Germans, they are still talking it over.”
Jan Latham-Koenig