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=55) 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=55) 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<>55 AND tp.id_base=794 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

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<>55 AND tp.id_base=794 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





	8 February 2020, 19:00 - Giuseppe Verdi "La forza del destino (Force of the fate)" (opera in four acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theater 8 February 2020, 19:00 - Giuseppe Verdi "La forza del destino (Force of the fate)" (opera in four acts)
8February
19:00
2020 | Saturday
Duration: 4 hours
World premiere: Mariinsky Theatre, St Petersburg, Russia, 7 July 1998

Libretto: Francesco Maria Piave based on the drama Don Alvaro, o La fuerza del sino by Angel de Saavedra

World premiere: 22 November 1862, Imperial (Bolshoi) Theatre, St Petersburg;
Premiere of this production: 7 July 1998, Mariinsky Theatre, St Petersburg

Performed in Italian

The Performance has two intermissions

La forza del destino (The Force of Destiny) is an Italian opera by Giuseppe Verdi. The libretto was written by Francesco Maria Piave based on a Spanish drama, Don Alvaro o La Fuerza de Sino (1835), by Бngel de Saavedra, Duke of Rivas, with a scene adapted from Friedrich Schiller’s Wallensteins Lager.

Synopsis

Setting: around 1850 in Spain and Italy.

Act I

Don Alvaro is a young nobleman from South America (presumably Peru) who is part Indian and who has settled in Seville, where, however, he is not very well thought of. He falls in love with Donna Leonora, the daughter of the Marquis of Calatrava, who, notwithstanding his love for his daughter, is determined that she shall marry only a man of the highest origin. Leonora, knowing her father’s aversion, and deeply in love with Alvaro, determines to elope with him, aided by her confidante, Curra. On the point of departure with him, she suddenly desires to see her father for a last time. Her father unexpectedly enters and discovers Alvaro; he threatens him with death, and Alvaro in order to remove any suspicion as to Leonora’s purity, offers to surrender himself to the Marquis. He flings down his pistol which goes off and mortally wounds the Marquis who dies cursing his daughter.

Act II

The Alcade, several peasant muleteers, and Don Carlo of Vargas, the brother of Donna Leonora, are gathered in the kitchen of an inn in the village of Hornachuelos. Don Carlo is searching for Don Alvaro to avenge the death of his father and is disguised as a student of Salamanca, under the fictitious name of Pereda. Leonora, in male attire arrives. During the supper, Preziosilla, a young gypsy, tells the young men’s fortunes and exhorts them to enlist in the war for Italy’s freedom, which all agree to do. In a very beautiful solo, Don Carlo tells them of his father’s death. Leonora overhears his song and barely escapes discovery by him. She takes refuge in a monastery where she tells the abbot her true name and that she intends to spend the remainder of her life in a hermitage. After the abbot has recounted the trials she will have to undergo, she departs for her cave.

Act III

Meanwhile Don Alvaro has joined the Spanish army under the name of Don Federico Herreros. One night he saves the life of Don Carlo who is serving in the same army under the name of Don Felix Bornos. They become close friends and go into battle side by side. In one of these engagements Don Alvaro is, as he supposes, mortally wounded, and confides to Don Carlo’s care a valise containing a bundle of letters which he is to destroy as soon as Don Alvaro dies. Don Carlo has sworn not to look at the contents of the letters; but he becomes suspicious of his friend, opens the valise and finds his sister’s picture. At that moment a surgeon brings word that Don Alvaro may recover. Don Carlo is overjoyed at the idea of revenging his father’s death. The scene changes to a camp near Velletri (Italy) where Don Carlo and Don Alvaro fight a duel, in which Don Alvaro thinks he has killed his opponent. In expiation, Don Alvaro vows to enter a monastery.

Act IV

Don Alvaro has entered the monastery at Hornachuelos, near which is Leonora’s cave, under the name of Father Raphael. Don Carlo arrives cured of his wound and forces him to fight. They choose the ground before Leonora’s cave; and Don Carlo is mortally wounded. Alvaro calls for help, and Leonora recognizing his voice rushes out, and seeing her brother dying, stoops over him; he thereupon stabs her to the heart. Don Alvaro flings himself to death from some rocks, before the monks arrive singing the Miserere.

Casts & Credits

Composer: Giuseppe Verdi
Baritone: Pavel Yankovsky
Bass-baritone: Alexander Gerasimov
Mezzo soprano: Natalia Yevstafieva
Mezzo soprano: Olga Savova
Costume Designer: Peter J. Hall
Designer: Andrei Voitenko
Lighting Designer: Howard Harrison
Musical Director: Maestro Valery Gergiev
Musical Preparation: Alla Brosterman
Principal Chorus Master: Andrei Petrenko
Stage Director: Elijah Moshinsky
Composer: Giuseppe Verdi
Baritone: Pavel Yankovsky
Bass-baritone: Alexander Gerasimov
Mezzo soprano: Natalia Yevstafieva
Mezzo soprano: Olga Savova
Costume Designer: Peter J. Hall
Designer: Andrei Voitenko
Lighting Designer: Howard Harrison
Musical Director: Maestro Valery Gergiev
Musical Preparation: Alla Brosterman
Principal Chorus Master: Andrei Petrenko
Stage Director: Elijah Moshinsky