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=1663) 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=1663) 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<>1663 AND tp.id_base=1806 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<>1663 AND tp.id_base=1806 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





	6 October 2018, 19:30 - Richard Strauss "Salome" one act opera - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theatre - Mariinsky II 6 October 2018, 19:30 - Richard Strauss "Salome" one act opera
6October
19:30
2018 | Saturday
Opera
Mariinsky Theatre - Mariinsky II, Saint Petersburg
Duration: 1 hour 40 minutes
World premiere: Mariinsky Theatre, St Petersburg, Russia, 6 June 1924

Richard Strauss brought an extravagant intensity to his adaptation of Oscar Wilde’s play Salomé. The glitter of Herod’s palace, the flicker of torches and the pale light of the moon are all vividly evoked in a sumptuously rich score. When Salome had its premiere in Dresden in 1905 it received 38 curtain calls and established Strauss as a first-rank opera composer. Gustav Mahler called it ‘one of the most important works of our day’.

Music by Richard Strauss
Libretto by the composer based on the play by Oscar Wilde in German translation Hedwig Lachmann

Musical Director - Valery Gergiev
Director-producer - Marat Gatsalov
Production designer - Monica Pormale
Costume designers: Rolands Peterkops, Marite Mastina-Peterkop (MAREUNROL'S)
Lighting Designer - Alexander Naumov
Artist-videography - Katrina Neiburg
Responsible accompanist - Marina Mishuk

World premiere: December 9, 1905, Semperoper, Dresden
Russian premiere: June 6, 1924, the State Academic Opera and Ballet Theater (Mariinsky Theater), Leningrad
Premiere of the production: February 9, 2017

The play is without intermission

SYNOPSIS

Moonlight night. The young guard Narraboth in love glances at Salome, feasting with the guests of King Herod. The page of Herodias, struck by an unusual moon, warns a friend of danger. From the dungeon the voice of the prophet announcing the coming of the Son of God is heard: "When He comes, the deserted dwellings will rejoice, the blind will see, the deaf will hear."

Pursued by the greedy eyes of his stepfather, Salome leaves the meal. The terrible words of Iokanaan arouse her curiosity, the princess wants to look at the prisoner. She tenderly asks for this Narried, and he, unable to resist her charms, violates the order of the Tetrarch.

Iokanaan denounces Herod and Herodias, who are mired in sins and lust, he calls on them to repent. Lusting for his touch and kiss, Salome tries to approach the prophet, but he rejects "the daughter of Sodom." Struck by what he saw, Narraboth kills himself. With curses, Ioanaan retires to his dungeon.

Persecuted by nightmarish visions, brought to hysteria, the Tetrarch searches for a stepdaughter. He offers Salome wine and wonderful fruits, a place for a feast near him. But she indifferently rejects his courtship. Again the terrible prophecies of Iokanaan are heard. Herodias asks him to extradite him to the Jews, but Herod is afraid to give such an order, for he believes Iokanaan is a saint. The Nazarenes testify of the miracles of the Messiah, seen by them. Tetrarch in the hope of distracting from oppressive thoughts persuades the stepdaughter to dance for him and for this pleasure promises to fulfill any of her wishes. Taking the oath from Herod, Salome begins the dance of the seven veils.

Herod is delighted, he asks about the reward. Salome wants the head of Ioanaana. Feeling mischief, Herod tries to pay off, but the princess insists on her. The Tetrarch has to fulfill his promise. Salome receives the head of Ioanaana.