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=133) 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=133) 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<>133 AND tp.id_base=777 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<>133 AND tp.id_base=777 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





	12 October 2018, 19:30 - Attila (dramma lirico in a prologue and three acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theatre - Mariinsky II 12 October 2018, 19:30 - Attila (dramma lirico in a prologue and three acts)
12October
19:30
2018 | Friday
Opera
Mariinsky Theatre - Mariinsky II, Saint Petersburg
Duration: 2 hours 20 minutes
World premiere: Mariinsky Theatre, St Petersburg, 13 July 2010

Music by Giuseppe Verdi 
Libretto by Temistocle Solera
Director: Arturo Gama
Set Designer: Frank Schloessman
Lighting Designer: Eugene Hanzburg
Costume Designers: Frank Schlossman and Hanne Loosen

World premiere: 17 March 1846, La Fenice, Venice
Premiere of this production: 13 July 2010, Mariinsky Theatre, St Petersburg
Synopsis
Prologue
Scene 1: The ruined city of Aquileia
Attila and his victorious horde are surprised to see a group of women spared as prisoners of war. Their leader, Odabella, asks why the Huns' women remain at home (Allor che i forti corrono / "While your warriors rush to their swords like lions"). Attila, impressed by her courage, offers a boon and she asks for her sword to avenge the death of her father at Attila's own hand (Da te questo or m'и concesso / "O sublime, divine justice by thee is this now granted"). The Roman envoy Ezio asks for an audience and proposes a division of the empire: Avrai tu l'universo, Resti l'Italia a me / "You may have the universe, but let Italy remain mine". Attila denounces him as a traitor to his country.
Scene 2: A swamp, the future site of Venice
A boat bearing Foresto and other survivors arrives; he thinks of the captive Odabella (Ella in poter del barbaro / "She is in the barbarian's power!") but then rouses himself and the others to begin building a new city (Cara patria giа madre e reina / "Dear homeland, at once mother and queen of powerful, generous sons").
Act 1
Scene 1: A wood near Attila's camp
Odabela laments her father and Foresto (Oh! Nel fuggente nuvolo / "O father, is your image not imprinted on the fleeting clouds?...") believing the latter to be dead. When he appears, she is put on the defensive, denying any infidelity and reminding him of the biblical Judith. The couple is reunited: Oh, t'inebria nell'amplesso / "O vast joy without measure")
Scene 2: Attila's tent
Attila awakes and tells Uldino of a dream in which an old man stopped him at the gates of Rome and warned him to turn back (Mentre gonfiarsi l'anima parea / "As my soul seemed to swell"). In the daylight, his courage returns and he orders a march (Oltre quel limite, t'attendo, o spettro / "Beyond that boundary I await you, O ghost!"). However, when a procession of maidens clad in white approaches, singing a Christian hymn, he recognizes the Roman bishop Leo as the old man of his dream, and collapses in terror.
Act 2
Ezio's camp
Ezio has been recalled, after a peace has been concluded. He contrasts Rome's past glory with the child emperor Valentine (Dagl'immortali vertici / "From the splendid immortal peaks of former glory"). Recognizing the incognito Foresto among the bearers of an invitation to a banquet with Attila, he agrees to join forces (E' gettata la mia sorte / "My lot is cast, I am prepared for any warfare" ). At the banquet, Foresto's plot to have Uldino poison Attila is foiled by Odabella, jealous of her own revenge. A grateful (and unsuspecting) Attila declares she shall be his wife, and places the unmasked Foresto in her custody.
Act 3
The forest
Uldino informs Foresto about the plans for the wedding of Odabella and Attila; Foresto laments Odabella's apparent betrayal (Che non avrebbe il misero / "What would that wretched man not have offered for Odabella). Ezio arrives with a plan to ambush the Huns; when Odabella comes Foresto accuses her of treachery, but she pleads for his trust. Attila finds the three and recognizes their betrayal. As Roman soldiers approach, Odabella stabs him with the sword he had given her. The three conspirators cry that the people have been avenged.

Casts & Credits

Composer: Giuseppe Verdi
Conductor: Christian Knapp
Costume Designer: Hanne Loosen
Lighting Designer: Mark Jonathan
Lighting Designer: Yevgeny Ganzburg
Musical Preparation: Alla Brosterman
Musical Preparation: Ilona Yansons
Principal Chorus Master: Dmitry Ralko
Set Designer: Frank Schloessman
Stage Director: William Friedkin
Composer: Giuseppe Verdi
Conductor: Christian Knapp
Costume Designer: Hanne Loosen
Lighting Designer: Mark Jonathan
Lighting Designer: Yevgeny Ganzburg
Musical Preparation: Alla Brosterman
Musical Preparation: Ilona Yansons
Principal Chorus Master: Dmitry Ralko
Set Designer: Frank Schloessman
Stage Director: William Friedkin