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-05-14' AND tmp.date<='2024-06-03' AND tmp.perf_id=1210) 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-05-14' AND '2024-06-03' AND tmp.perf_id=1210) 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<>1210 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<>1210 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





	,  - AIDA Opera in concert - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Moscow theatre "New Opera" , - AIDA Opera in concert
|
Opera
Moscow theatre "New Opera", Moscow

Synopsis

Overview: Aida, an Ethiopian princess, is captured and brought into slavery in Egypt. A military commander, RadamЁЁs, struggles to choose between his love for her and his loyalty to the Pharaoh. To complicate the story further, RadamЁЁs is loved by the Pharaoh's daughter Amneris, although he does not return her feelings.

Act 1
Scene 1: A hall in the King's palace; through the rear gate the pyramids and temples of Memphis
Ramfis, the high priest of Egypt, tells RadamЁЁs, the young warrior, that war with the Ethiopians seems inevitable, and RadamЁЁs expresses the hope that he can be chosen as the Egyptian commander. (Ramfis, RadamЁЁs : Si, corre voce I'Etiope ardisca / "Yes, it is rumored that Ethiopia dares once again to threaten our power").
RadamЁЁs dreams both of gaining victory on the battle field and of Aida, the Ethiopian slave, with whom he is secretly in love (RadamЁЁs: Se quel guerrier io fossi!...Celeste Aida / "Heavenly Aida"). Aida, who is also secretly in love with RadamЁЁs, is the captured daughter of the Ethiopian King Amonasro, but her Egyptian captors are unaware of her true identity. Her father has invaded Egypt to deliver her from servitude.
Amneris, the daughter of the Egyptian King enters the hall. She too loves RadamЁЁs, but fears that his heart belongs to someone else (RadamЁЁs, Amneris: Quale insolita gioia nel tuo sguardo / "In your looks I trace a joy unwonted").
Then Aida appears and, when RadamЁЁs sees her, Amneris notices that he looks disturbed. She suspects that Aida could be her rival, but she is able to hide her jealousy and approaches her (Amneris, Aida, RadamЁЁs: Vieni, o diletta, appressati / "Come, O delight, come closer").
The King enters, along with the High Priest, Ramfis, and the whole palace court. A messenger announces that the Ethiopians, led by King Amonasro, are marching towards Thebes. The King declares war and also proclaims RadamЁЁs to be the man chosen by the goddess Isis as leader of the army (The King, Messenger, RadamЁЁs, Aida, Amneris, chorus: Alta cagion v'aduna / "Oh fate o'er Egypt looming"). Upon receiving the mandate from the King, RadamЁЁs proceeds to the temple of Vulcan to take up the sacred arms (The King, RadamЁЁs, Aida, Amneris, chorus: Su! del Nilo al sacro lido / "On! Of Nilus' sacred river, guard the shores").

Alone in the hall, Aida is torn between her love for her father, her country, and RadamЁЁs. (Aida: Ritorna vincitor / "Return a conqueror").
Scene 2: Inside the Temple of Vulcan Solemn ceremonies and dances by the priestesses take place (High Priestess, chorus, RadamЁЁs: Possente Ftha...Tu che dal nulla / "O mighty Ptah.") followed by the installation of RadamЁЁs to the office of commander-in-chief. (High Priestess, chorus, RadamЁЁs: Immenso Ftha .. Mortal, diletto ai Numi / "O mighty one, guard and protect!"). All present in the temple pray for the victory of Egypt and protection for their warriors (Nume, custode e vindice/ "Hear us, O guardian deity").

Act 2
Scene 1: The chamber of Amneris
Dances and music to celebrate RadamЁЁs' victory take place (Chorus, Amneris: Chi mai fra gli inni e i plausi / "Our songs his glory praising"'). However, Amneris is still in doubt about RadamЁЁs' love and wonders whether Aida is in love with the young warrior. She tries to forget her doubt, entertaining her worried heart with the dance of Moorish slaves (Chorus, Amneris: Vieni: sul crin ti piovano / "Come bind your flowing tresses").

When Aida enters the chamber, Amneris asks everyone to leave. By falsely telling Aida that RadamЁЁs has died in the battle, she tricks her into professing her love for him. In grief, and shocked by the news, Aida confesses that her heart belongs to RadamЁЁs eternally (Amneris, Aida: Fu la sorte dell' armi a' tuoi funesta / "The battle's outcome was cruel for your people...").
This confession fires Amneris with rage, and she plans on taking revenge on Aida. Ignoring Aida's pleadings, (Amneris, Aida, chorus: Su! del Nilo al sacro lido / "Up! at the sacred shores of the Nile") Amneris leaves her alone in the chamber.
Scene 2: The grand gate of the city of §ґ§з§Ц§Т§Ц§г

RadamЁЁs returns victorious and the troops march into the city (Chorus, Ramfis: Gloria all'Egitto, ad Iside / "Glory to Egypt, to Isis!"). The Egyptian king decrees that on this day the triumphant RadamЁЁs may have anything he wishes. The Ethiopian captives are rounded up and Amonasro appears among them. Aida immediately rushes to her father, but their true identities are still unknown to the Egyptians, save for the fact that they are father and daughter. Amonasro declares that the Ethiopian king (he himself) has been slain in battle. Aida, Amonasro and the captured Ethiopians plead with the Egyptian King for mercy, but the Egyptians call for their death (Aida, Amneris, RadamЁЁs, The King, Amonasro, chorus: Che veggo! .. Egli? .. Mio padre! .. Anch'io pugnai / "What do I see?.. Is it he? My father?").
As his reward from the King, RadamЁЁs pleads with him to spare the lives of the prisoners and to set them free. Gratefully, the King of Egypt declares RadamЁЁs to be his successor and to be his daughter's betrothed (Aida, Amneris, RadamЁЁs, The King, Amonasro, chorus: O Re: pei sacri Numi! .. Gloria all'Egitto / "O King, by the sacred gods..."). Aida and Amonasro remain as hostages to ensure that the Ethiopians do not avenge their defeat.

Act 3
On the banks of the Nile, near the Temple of Isis
Prayers are said (Chorus, Ramfis, Amneris: O tu che sei d'Osiride / "O thou who to Osiris art...") on the eve of Amneris and RadamЁЁs' wedding in the Temple of Isis. Outside, Aida waits to meet with RadamЁЁs as they had planned (Aida: Qui RadamЁЁs verra .. O patria mia / "Oh, my dear country!").
Amonasro appears and forces Aida to agree to find out the location of the Egyptian army from RadamЁЁs (Aida, Amonasro: Ciel, mio padre! .. Rivedrai le foreste imbalsamate / "Once again shalt thou gaze."). When he arrives, Amonasro hides behind a rock and listens to their conversation.
RadamЁЁs affirms that Aida is the person he will marry (Pur ti riveggo, mio dolce Aida .. Nel fiero anelito; Fuggiam gli ardori inospiti .. La, tra foreste vergini / "I see you again, my sweet Aida!"), and Aida convinces him to flee to the desert with her.
In order to make their escape easier, RadamЁЁs proposes that they use a safe route without any fear of discovery and he also reveals the location where his army has chosen to attack. Upon hearing this, Amonasro comes out of hiding and reveals his identity. RadamЁЁs feels dishonored. At the same time Amneris and Ramfis leave the temple and, seeing RadamЁЁs with their enemy, call the guards. Amonasro and Aida try to convince RadamЁЁs to escape with them, but he refuses and surrenders to the imperial guards.

Act 4
Scene 1: A hall in the Temple of Justice. To one side is the door leading to RadamЁЁs' prison cell
Amneris (L'aborrita rivale a me sfuggia / "My hated rival has escaped me") desires to save RadamЁЁs. She calls for the guard to bring him to her.
She asks RadamЁЁs to deny the accusations, but RadamЁЁs refuses. Certain that, as punishment, he will be condemned to death, Amneris implores him to defend himself, but RadamЁЁs firmly refuses. He is relieved to know Aida is still alive and hopes she has reached her own country (Amneris, RadamЁЁs: Gia i Sacerdoti adunasi / "Already the priests are assembling"). His decision hurts Amneris.
RadamЁЁs' trial takes place offstage; he does not reply to Ramfis' accusations and is condemned to death, while Amneris, who remains onstage, pleads with the priests to show him mercy. As he is sentenced to be buried alive, Amneris curses the priests while RadamЁЁs is taken away (Judgment scene, Amneris, Ramfis, and chorus: Ahime! .. morir mi sento / "Alas... I feel death").
Scene 2: The lower portion of the stage shows the vault in the Temple of Vulcan; the upper portion represents the temple §Ъ§д§г§Ц§Э§ж

RadamЁЁs has been taken into the lower floor of the temple and sealed up in a dark vault. Thinking that he is alone and hoping that Aida is in a safer place, he hears a sigh and then sees Aida. She has hidden herself in the vault in order to die with RadamЁЁs. (RadamЁЁs and Aida: La fatal pietra sovra me si chiuse. / "The fatal stone now closes over me.") They accept their terrible fate (RadamЁЁs: Morir! Si pura e bella / "To die! So pure and lovely!") and bid farewell to earth and its sorrows.[26] Above the vault in the temple of Vulcan, Amneris weeps and prays to the goddess Isis. In the vault below, Aida dies in RadamЁЁs' arms. (Chorus, Aida, RadamЁЁs, Amneris: Immenso Ftha / "Almighty Ptah.")

Casts & Credits

Composer: Giuseppe Verdi
Choirmaster producer: Natalya Popovich
Conductor: Evgeny Samoilov
Composer: Giuseppe Verdi
Choirmaster producer: Natalya Popovich
Conductor: Evgeny Samoilov