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=232) 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=232) 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<>232 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

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<>232 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





	24 August 2017, 19:00 - Il Trovatore - G.Verdi (Opera in two acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Moscow theatre "New Opera" 24 August 2017, 19:00 - Il Trovatore - G.Verdi (Opera in two acts)
24August
19:00
2017 | Thursday
Opera
Moscow theatre "New Opera", Moscow
Duration: 2 hours 30 minutes
World premiere: Moscow theatre "New Opera", 16 December 2012

Il Trovatore (The Troubadour) was one of Verdi’s best-loved operas even during the composer’s lifetime. The opera received a rapturous reception when it was performed for the first time on 19 January 1853 at the Teatro Apollo in Rome and Guiseppe Verdi himself called it his most popular work. Together with La Traviata and Rigoletto the opera is still one of Verdi’s most-performed and popular operas worldwide. The plot is set in the gloomy atmosphere of 15th century Spain and tells the romantic love story of Leonora and her troubadour Manrico. An opera full of love and hate, heroism and revenge.

Opera in two acts Music Director Jan Latham-Koenig
Conductors Jan Latham-Koenig, Evgeny Samoilov, Dmitry Volosnikov, Laurent Campellone
Stage Director Marco Gandini
Set Designer Italo Grassi
Costume Designer Simona Morresi
Lighting Designer Virginio Levrio
Choirmasters Natalya Popovich, Andrey Lazarev

Il trovatore, composed by Giuseppe Verdi in 1853, is one of his most popular operas. It is a romantic drama with an intricate plot and deathly mysteries, passions of love and fierce duels, vengeance and a tragic denouement. Unaware of their kinship, two brothers, Count di Luna and the troubadour Manrico, are bitter rivals in their fight for power and love for Countess Leonora. Ridden by jealousy and vengeance, di Luna kills his own brother whom he has been looking for all his life as he promised to his now deceased father. 

Basing his opera on the play El Trovador by the Spanish playwright Antonio Garcia Gutierrez, Verdi created vivid musical portraits of the characters conveyed by the fabulously melodious arias and duets. These are the gypsy Azucena, who keeps the fateful secret of Manrico’s birth and is torn between her boundless motherly love and vengeance, the perfidious Count di Luna, the noble Manrico and his faithful beloved Leonora. They are supplemented by the picturesque figures of the gypsies, monks, soldiers, and the Count’s courtiers expressed in the splendid choruses. The verve and gorgeousness of Verdi’s score will be displayed to the audience by Novaya Opera’s Chief Conductor Jan Latham-Koenig.
 
To stage one of Verdi’s most mysterious masterpieces, the Novaya Opera Theatre has invited an Italian production team, including stage director Marco Gandini, set designer Italo Grassi and costume designer Simona Morresi, who have worked together before on successful projects.
 
Marco Gandini has worked in the major Italian opera houses (Teatro alla Scala in Milan, Rome Opera, San Carlo Theatre in Naples, La Fenice in Venice) and internationally at the Metropolitan Opera in New York, Israeli Opera in Tel Aviv, opera houses in Los Angeles and Washington, the Royal Opera House in London, Teatro Real in Madrid, Teatro Liceu in Barcelona, Mariinsky Theatre in St. Petersburg. The sets for most of his productions have been designed by Italo Grassi. A few years ago the team was joined by costume designer Simona Morresi, who in 2011 took part in the production of Verdi’s Falstaff (in Tokyo) and Simon Boccanegra (in Seoul). Il trovatore in Novaya Opera will be the third project of the creative team.


Marco Gandini, stage director:
“This opera has three main components: the world of Count di Luna, the world of Leonora and the world of the gypsies Manrico and Azucena. These are the three intonations, three colours, three images of Il trovatore. That is why the central element of the scenery will be three towers, each with three sides. They all are different, symbolizing the main characters’ worlds. The costumes will be in line with the epoch.When I work with singers, whether Italian or international, I do not just tell them how they should move on stage; I devote much time to achieving pronunciation clarity and understanding the gist of the story, as I believe that the integrity of a stage image, the facial and body mobility of a character depend on the speech, understanding and appropriation of both the musical and the literary text of an opera”.

Composer: Giuseppe Verdi
Composer: Giuseppe Verdi