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=2539) 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=2539) 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<>2539 AND tp.id_base=-1 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<>2539 AND tp.id_base=-1 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





	11 February 2019, 19:00 - Peter Tchaikovsky "The Enchantress" (opera in four acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theatre - Mariinsky II 11 February 2019, 19:00 - Peter Tchaikovsky "The Enchantress" (opera in four acts)
11February
19:00
2019 | Monday
Opera
Mariinsky Theatre - Mariinsky II, Saint Petersburg
Duration: 3 hours 40 minutes

Production by David Pountney

Libretto by Ippolit Shpazhinsky after his own play (1885)

Stage Director: David Pountney
Set Designer: Robert Innes-Hopkins
Lighting Designer: Mimi Sherin

Premiere: 2003 February, Lisbon
Premiere at the Mariinsky Theatre: 2003 June

The Enchantress (or The Sorceress)(Russian: Charodeyka) is an opera in 4 acts by Pyotr Tchaikovsky. The opera was composed between 1885 - 1887 in Maidanovo, Russia. The libretto was written by Ippolit Shpazhinsky, and is based on his drama of the same title. The opera was first performed in St Petersburg in 1887.

Synopsis

The action takes place at the last quarter of the 15th century at the tavern and brothel near Nizhny Novgorod. Nastasia (Kuma), the charming owner of the inn, has made herself an enemy in rejecting the devious Mamyrov, the right-hand man of the local governor Nikita Danilovich Kurliatev. He spreads the gossip that Nastasia is an enchantress, and every man whom she meets falls for her. Yuri, Nikita’s son, begins to frequent the inn, as does his father, who falls madly in love with Nastasia (without any success), who threatens her that he will reach his goal by whatever means. Mamyrov confronts Nikita’s wife, Evpraksia, with the truth, while her son – not yet personally involved with Nastasia – swears to avenge his mother. While confronting Nastasia he learns that it is he whom she loves. They both plan to flee during the night not knowing that, by now, Mamyrov has worked out an elaborate plot to wreak his revenge on Nastasia as well as on Nikita and his family with devastating effect.

  • Characters

    Provided by Wikipedia - The Enchantress

    Casts & Credits

    Composer: Andrey Petrov
    Conductor: Zaurbek Gugkaev
    Costume Designer: Tatiana Noginova
    Musical Director: Maestro Valery Gergiev
    Musical Preparation: Irina Soboleva
    Principal Chorus Master: Andrei Petrenko
    Composer: Andrey Petrov
    Conductor: Zaurbek Gugkaev
    Costume Designer: Tatiana Noginova
    Musical Director: Maestro Valery Gergiev
    Musical Preparation: Irina Soboleva
    Principal Chorus Master: Andrei Petrenko