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=105) 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=105) 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<>105 AND tp.id_base=514 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<>105 AND tp.id_base=514 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





	19 March 2021, 19:00 - Giuseppe Verdi "Il trovatore" (opera in four acts ) - concert performance - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theatre - Mariinsky II 19 March 2021, 19:00 - Giuseppe Verdi "Il trovatore" (opera in four acts ) - concert performance
19March
19:00
2021 | Friday
Opera
Mariinsky Theatre - Mariinsky II, Saint Petersburg
Duration: 2 hours 45 minutes

Il trovatore (The Troubadour) is an opera in four acts by Giuseppe Verdi to an Italian libretto by Salvadore Cammarano, based on the play El trovador (1836) by Antonio Garcia Gutierrez. Cammarano died in mid-1852 before completing the libretto. This gave the composer the opportunity to propose significant revisions, which were accomplished under his direction by the young librettist Leone Emanuele Bardare, and they are seen largely in the expansion of the role of Leonora. The opera was first performed at the Teatro Apollo, Rome, on 19 January 1853 where it "began a victorious march throughout the operatic world". Today, in its Italian version, it is given very frequently and is a staple of the standard operatic repertoire.

Music by Giuseppe Verdi
Libretto by Salvatore Cammarano

The first production in St. Petersburg: November 21, 1855, the Bolshoi Kamenny Theater
Premiere of the production of Pier Luigi Pizzi: December 27, 2013

Il trovatore (The Troubadour) is an opera in four acts by Giuseppe Verdi to an Italian libretto by Salvadore Cammarano, based on the play El trovador (1836) by Antonio Garcia Gutierrez. Cammarano died in mid-1852 before completing the libretto. This gave the composer the opportunity to propose significant revisions, which were accomplished under his direction by the young librettist Leone Emanuele Bardare, and they are seen largely in the expansion of the role of Leonora.

The opera was first performed at the Teatro Apollo, Rome, on 19 January 1853 where it "began a victorious march throughout the operatic world". Today, in its Italian version, it is given very frequently and is a staple of the standard operatic repertoire.

Pier Luigi Pizzi on his production of the opera
In my opinion, Il trovatore is a stunning example of Verdian melodrama, a point of reference for many other composers in the 19th century. The perfection of the opera’s musical form, its engaging plot, vivid choral scenes and the unusual beauty of the melodies allowed Verdi to convey with great power human passions including love, hate and jealousy as well as revenge and death.
Returning once again to this opera, so adored by many, and doing so at a mature age, I plan to focus on the psychology of the characters. I will also focus particularly on the intense dramatic story being told. The characters of the protagonists seem to me to create a strong impression.
Azucena is, of course, the lead female character: she treacherously fans the flames of the conflict between Manrico and the Conte di Luna, two brothers unaware of their blood ties, and awakens feelings of rivalry and mutual hatred between them.
I find that the Conte di Luna is another protagonist on whom Verdi bestowed the most noble and passionate arias. The insistence with which he seeks out his lost brother, the ardent passion he feels for Leonora, his fervent desire and his malice at unrequited feelings make the Conte di Luna a powerful dramatic character.
In comparison with him, Manrico, who has the privilege of performing the opera’s most famous aria, remains vulnerable and immature, young and inexperienced  – a mere pawn in the hands of the gypsy woman. Of Leonora it could be said that she is one of the most romantic characters in the history of opera. Two arias that Verdi assigned to this role  – Tacea la notte placida and D’amor sull ali rosee  – rouse the most incredibly tender thoughts for this courageous woman who resolves to sacrifice herself for the sake of love.
This opera stirs powerful emotions in me, and I would like to convey this noble feeling to the audience.

Casts & Credits

Composer: Giuseppe Verdi
Choreography: Emil Faski
Lighting Designer: Vincenzo Raponi
Musical Director: Maestro Valery Gergiev
Musical Preparation: Marina Mishuk
Musical Preparation: Alla Brosterman
Principal Chorus Master: Pavel Teplov
Set Designer: Pier Luigi Pizzi
Stage Director: Pier Luigi Pizzi
Composer: Giuseppe Verdi
Choreography: Emil Faski
Lighting Designer: Vincenzo Raponi
Musical Director: Maestro Valery Gergiev
Musical Preparation: Marina Mishuk
Musical Preparation: Alla Brosterman
Principal Chorus Master: Pavel Teplov
Set Designer: Pier Luigi Pizzi
Stage Director: Pier Luigi Pizzi