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

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





	7 March 2020, 19:00 - Pyotr Tchaikovsky "Mazeppa" (Opera in Concert Performance) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Bolshoi theatre - Historic Stage 7 March 2020, 19:00 - Pyotr Tchaikovsky "Mazeppa" (Opera in Concert Performance)
7March
19:00
2020 | Saturday
Opera
Bolshoi theatre - Historic Stage, Moscow
Conductor TUGAN SOKHIEV

Mazeppa, properly Mazepa is an opera in three acts (six scenes) by Pyotr Ilyich Tchaikovsky. The libretto was written by Victor Burenin and is based on Pushkin's poem Poltava, part of the cultural legacy of Mazeppa.

Mazeppa is a blood-thirsty tale of crazy love, abduction, political persecution, execution, and vengeful murder. The action takes place in Ukraine at the beginning of the 18th century. The protagonists are the historical figures Ivan Stepanovych Mazeppa (c. 1640–1709), the Hetman of the Ukrainian Cossacks, and Vasyl Leontiyovych Kochubey (c.1640–1708), a very prosperous Ukrainian nobleman and statesman.

Composition history

The opera was composed between June 1881 and April 1883. Mazeppa's libretto was based on Poltava, a narrative poem by Alexander Pushkin. Pushkin based his story on historical events at Poltava, the battle where Tsar Peter the Great defeated Swedish King Charles XII. Pushkin took some creative freedom in order to create powerful characters and grand passions. For example, Kochubey (the wealthy Cossack whose daughter elopes with Mazeppa) actually managed to successfully keep Mariya from him. He turned Mazeppa in to the Tsar four years after Mazeppa asked for her hand.

Tchaikovsky first mentioned the idea of an opera based on Poltava to his publisher in the summer of 1881. Soon, he became obsessed with Poltava's story of tragic love and political betrayal and quickly produced four numbers plus sketching a duet based on material from his symphonic poem Romeo and Juliet (this music later became Mazeppa and Mariya's Act 2 duet). Librettist Burenin followed Pushkin's poem, incorporating large excerpts from Poltava into his libretto, but Tchaikovsky was not very pleased with Burenin's work: he felt "no special enthusiasm for the characters", and went on to make some critical changes of his own, adding more of Pushkin's lines back in. Vasily Kandaurov contributed the text for Mazeppa's aria in Act 2, Scene 2.

The libretto was revised over and over again, even after the opera's premieres. Choosing to focus primarily on the love story at the heart of the opera, the composer added the character Andrei, a lovesick boy whose unrequited love for the beautiful Mariya gives her tragic fate a special poignancy. Mazeppa shares many characteristics with Tchaikovsky's Eugene Onegin: they both center on a young woman whose powerful love draws her into a catastrophic downward spiral.

Opera company: Bolshoi Opera
Conductor: Tugan Sokhiev
Bass-baritone: Nikolai Kazansky
Mezzo soprano: Nadezhda Serdyuk
Mezzo soprano: Yelena Manistina
Opera company: Bolshoi Opera
Conductor: Tugan Sokhiev
Bass-baritone: Nikolai Kazansky
Mezzo soprano: Nadezhda Serdyuk
Mezzo soprano: Yelena Manistina