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=863) 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=863) 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<>863 AND tp.id_base=1979 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<>863 AND tp.id_base=1979 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





	,  - L. Cherubini "Medea" Opera in 3 acts - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Stanislavsky theatre , - L. Cherubini "Medea" Opera in 3 acts
|
Opera
Stanislavsky theatre, Moscow
Duration: 3 hours 20 minutes (two intermissions)
World premiere: 14 May 2015

Music  Luigi Cherubini
Libretto  François-Benoît Hoffman (italian version: Carlo Zangarini, recitatives: Franz Lachner)
Music Director and Conductor  Felix Korobov
Conductor  Timur Zangiev
Stage Director  Alexander Titel
Set Designer  Vladimir Arefiev
Costume Designer  Vladimir Arefiev
Lighting Designer  Evgeny Vinogradov
Principal Chorus Master  Stanislav Lykov
Overview

The opera Medea is one of the masterpieces of the French opera of the turn of the 18th century. It was composed by Luigi Cherubini, one of the founders of Paris Conservatory, whom Beethoven had called the best among his contemporary opera composers and who was a witness and chronicler of the French Revolution. The work he created is comparable in scale with the Greek myth he took for its base. Cherubini’s Medea, which belongs in the ranks of the greatest operatic tragedies, requires from the performers considerable vocal skills and impressive acting talent. 

Cherubini’s Medea experienced a second birth in the mid-20th century thanks to Maria Callas. Her performance of the part of Medea has become a legend of opera stage, and since then special qualifications have been required of performers of the title role. One of the reasons that the K. S. Stanislavsky and V. I. Nemirovich-Danchenko Music Theatre addressed the Cherubini opera was presence in the сompany of two female singers who possess powerful and expressive voices as well as brilliant acting individualities. The part of Medea in the new production are performed by the world-renowned soprano Hibla Gerzmava and one of the brightest stars of the Moscow opera scene Natalia Muradymova.

Сast
Music Director and Conductor 
Felix Korobov
Conductor 
Timur Zangiev
Medea 
Hibla Gerzmava
Natalia Muradymova
Neris 
Ksenia Dudnikova
Natalia Vladimirskaya
Glauce 
Daria Terekhova
Evgenia Afanasieva
Lilia Gaisina
Giasone 
Nikolay Erokhin
Najmiddin Mavlyanov
Creonte 
Felix Kudryavtsev
Roman Ulybin
Captain of the Guard 
Mikhail Golovushkin
Maxim Osokin

 

Synopsis

Act 1
Outside the palace of King Creon

Dirce is preparing for her wedding to Jason. However, with Medee's help, he had stolen the golden fleece and, in doing so, Medee had betrayed her family and established a relationship with him, the result of which was her two children. Although Jason had since abandoned Mйdйe, she reappears and demands that he return to her. Jason refuses and Medee curses him, swearing vengeance.

Act 2
Inside the palace

Despairing, Medee is encouraged to leave the city by her slave, Neris. However, Creon appears and orders that Medee leave. She asks for one more day with her children and, after the king agrees, she appears to be calmer and gives Neris two wedding presents to take to her rival.

Act 3
Between the palace and the temple

Neris brings the two children out to where Medee is waiting. Sounds of lamentation are heard from within the palace and it is discovered that one of Medee's wedding presents has poisoned Dirce. An angry crowd gathers and Neris, Medee, and the children take refuge in the temple. The two women reappear with Medee grasping a blood-stained knife with which she has killed her two children. The temple, to which Medee returns, goes up in flames.