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=625) 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=625) 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<>625 AND tp.id_base=1792 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<>625 AND tp.id_base=1792 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





	25 May 2019, 12:00 - Arif Melikov "The Legend of Love" (ballet in three acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Bolshoi theatre - Historic Stage 25 May 2019, 12:00 - Arif Melikov "The Legend of Love" (ballet in three acts)
25May
12:00
2019 | Saturday
Classical ballet
Bolshoi theatre - Historic Stage, Moscow
World premiere: 23 October 2014

Libretto: Nazim Khikmet
Presented with two intervals.

Synopsis

Act I

Scene 1
The royal apartments of Queen Mekhmene Banu are plunged in mourning - her young sister, Shireen, is dying. The Vizier and the courtiers are full of anxiety. Mekhmene Banu is in despair. A Stranger, who appears out of the blue, says he will cure the Princess but, in return, Mekhmene Banu must sacrifice her beauty. In order to save the life of her sister whom she loves deeply, Mekhmene Banu accepts the Stranger’s cruel terms. Shireen is brought back to life.

Scene 2
In the palace garden, the young court painter, Ferkhad, suddenly comes across Queen Mekhmene Banu and Princess Shireen who are taking a walk, surrounded by courtiers and the palace guard. The two sisters exchange gazes with Ferkhad and love for the young painter is born in their hearts. The procession moves off. Ferkhad is entranced by the beauty of the young Shireen. In the hope of seeing Ferkhad, Shireen secretly returns to the garden The two young people are greatly attracted to each other.

Act II

Scene 3
Mekhmene Banu is overcome by passion for Ferkhad. Nothing can distract her thoughts from the handsome youth. She realizes in despair that now she has lost her beauty, she will be unable to win his love.

Scene 4
The young Shireen dreams of happiness with her loved one: the thought that they may soon meet gives her great joy and also fills her with anxiety. Ferkhad makes his way into Shireen’s chamber and the lovers elope from the palace. Torn by jealousy, Mekhmene Banu orders that the lovers be seized. The fugitives are caught. The lovers’ pleas that they be granted their happiness are in vain. Mekhmene Banu sets Ferkhad an impossible task: in order to win Shireen, he must first bore a hole through the iron mountain which blocks the way to a water source. For the sake of his love, Ferkhad is willing to attempt the impossible. He bids farewell to Shireen.

Act III

Scene 5
The populace are tormented by thirst. As each day passes there is less and less water. And without water there can be no life. In order to attain water the mountain has to be destroyed.

Scene 6
Ferkhad, who is in the mountains, dreams that he has gained access to the water and before him he sees his beloved Shireen.

Scene 7
Mekhmene Banu is tormented by her passion and love for Ferkhad. She dreams she is beautiful again and that Ferkhad loves her. Shireen breaks into Mekhmene Banu’s reveries. She implores her sister to recall Ferkhad.

Scene 8
A great hope has brought the populace to the mountains. If Ferkhad manages to accomplish the impossible, their lives will be saved. Queen Mekhmene Banu and Shireen appear surrounded by their suite. Overcome by happiness at their meeting, the lovers throw themselves into each other’s arms. The Queen is prepared to give Ferkhad the hand of Shireen, but the former feels that he cannot go back on his duty. Mekhmene Banu and Shireen are full of respect for the great altruism of Ferkhad who is ready to sacrifice his personal happiness for the sake of his people.

Casts & Credits

Choreography: Yuri Grigorovich
Ballet company: Bolshoi Ballet
Conductor: Pavel Klinichev
Artistic Director: Maestro Yuri Grigorovich
Costume Designer: Simon Virsaladze
Musical Director: Alexander Kopylov
Choreography: Yuri Grigorovich
Ballet company: Bolshoi Ballet
Conductor: Pavel Klinichev
Artistic Director: Maestro Yuri Grigorovich
Costume Designer: Simon Virsaladze
Musical Director: Alexander Kopylov