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=2616) 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=2616) 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<>2616 AND tp.id_base=2827 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<>2616 AND tp.id_base=2827 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





	11 March 2020, 19:00 - Henry Purcell "Dido And Aeneas" Opera in 3 acts - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Bolshoi theatre - Small Stage 11 March 2020, 19:00 - Henry Purcell "Dido And Aeneas" Opera in 3 acts
11March
19:00
2020 | Wednesday
Opera
Bolshoi theatre - Small Stage, Moscow
Conductor CHRISTOPHER MOULDS
Director VINCENT HUGUET
Set Design AURÉLIE MAESTRE
Costume Design CAROLINE DE VIVAISE
Lighting Design BERTRAND COUDERC
Chief Chorus Master VALERY BORISOV

Libretto by Nahum Tate based on Book IV of Virgil’s Aeneid
Prologue by Maylis de Kerangal

Premiere 7 July 2018,
Festival international d`art lyrique d`Aix-en-Provence (France)

Dido and Aeneas is an opera in a prologue and three acts, written by the English Baroque composer Henry Purcell with a libretto by Nahum Tate. The dates of the composition and first performance of the opera are uncertain. It was composed no later than July 1688, and had been performed at Josias Priest's girls' school in London by the end of 1689. Some scholars argue for a date of composition as early as 1683. The story is based on Book IV of Virgil's Aeneid. It recounts the love of Dido, Queen of Carthage, for the Trojan hero Aeneas, and her despair when he abandons her. A monumental work in Baroque opera, Dido and Aeneas is remembered as one of Purcell's foremost theatrical works. It was also Purcell's only true opera, as well as his only all-sung dramatic work. One of the earliest known English operas, it owes much to John Blow's Venus and Adonis, both in structure and in overall effect. The influence of Cavalli's opera Didone is also apparent.

Synopsis

Act 1

Dido's court

The opera opens with Dido in her court with her attendants. Belinda is trying to cheer up Dido, but Dido is full of sorrow, saying 'Peace and I are strangers grown'. Belinda believes the source of this grief to be the Trojan Aeneas, and suggests that Carthage's troubles could be resolved by a marriage between the two. Dido and Belinda talk for a time: Dido fears that her love will make her a weak monarch, but Belinda and the Second Woman reassure her that "The hero loves as well." Aeneas enters the court, and is at first received coldly by Dido, but she eventually accepts his proposal of marriage.

Act 2

Scene 1: The cave of the Sorceress

The Sorceress/Sorcerer is plotting the destruction of Carthage and its queen, and summons companions to help with evil plans. The plan is to send her "trusted elf" disguised as Mercury, someone to whom Aeneas will surely listen, to tempt him to leave Dido and sail to Italy. This would leave Dido heartbroken, and she would surely die. The chorus join in with terrible laughter, and the Enchantresses decide to conjure up a storm to make Dido and her train leave the grove and return to the palace. When the spell is prepared, the witches vanish in a thunderclap.

Scene 2: A grove during the middle of a hunt

Dido and Aeneas are accompanied by their train. They stop at the grove to take in its beauty. A lot of action is going on, with attendants carrying goods from the hunt and a picnic possibly taking place, and Dido and Aeneas are together within the activity. This is all stopped when Dido hears distant thunder, prompting Belinda to tell the servants to prepare for a return to shelter as soon as possible. As every other character leaves the stage, Aeneas is stopped by the Sorceress's elf, who is disguised as Mercury. This pretend Mercury brings the command of Jove that Aeneas is to wait no longer in beginning his task of creating a new Troy on Latin soil. Aeneas consents to the wishes of what he believes are the gods, but is heart-broken that he will have to leave Dido. He then goes off-stage to prepare for his departure from Carthage.

Act 3

The harbour at Carthage

Preparations are being made for the departure of the Trojan fleet. The sailors sing a song, which is followed shortly by the Sorceress and her companions' sudden appearance. The group is pleased at how well their plan has worked, and the Sorceress sings a solo describing her further plans for the destruction of Aeneas "on the ocean". All the characters begin to clear the stage after a dance in three sections, and then disperse.

The palace

Dido and Belinda enter, shocked at Aeneas’ disappearance. Dido is distraught and Belinda comforts her. Suddenly Aeneas returns, but Dido is full of fear before Aeneas speaks, and his words only serve to confirm her suspicions. She derides his reasons for leaving, and even when Aeneas says he will defy the gods and not leave Carthage, Dido rejects him for having once thought of leaving her. After Dido forces Aeneas to leave, she states that "Death must come when he is gone." The opera and Dido's life both slowly come to a conclusion, as the Queen of Carthage sings her last aria, "When I am laid in Earth", also known as "Dido's Lament." The chorus and orchestra then conclude the opera once Dido is dead by ordering the "cupids to scatter roses on her tomb, soft and gentle as her heart. Keep here your watch, and never, never part."