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-23' AND tmp.date<='2024-05-13' AND tmp.perf_id=67) 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-23' AND '2024-05-13' AND tmp.perf_id=67) 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<>67 AND tp.id_base=790 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<>67 AND tp.id_base=790 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 October 2019, 19:00 - Gaetano Donizetti "L`elisir d`amore (Love Drink)" opera-buffa in two acts - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mikhailovsky Theater 8 October 2019, 19:00 - Gaetano Donizetti "L`elisir d`amore (Love Drink)" opera-buffa in two acts
8October
19:00
2019 | Tuesday
Duration: 2 hours 40 minutes
World premiere: Mikhailovsky Theater, 27 May 2008

Libretto by Felice Romani based on the French libretto by Eugène Scribe

Stage Director: Fabio Sparvoli
Stage Designer: Mauro Carosi
Costume Designer: Odette Nicoletti
Lighting Designer: Vinicio Cheli
Assistant to Stage Director: Barbara Di Lieto
Assistant to Costume Designer: Luigi Benedetti
Musical Director of the production: Daniele Rustioni
Artistic Director and Principal Conductor of the Chorus: Vladimir Stolpovskikh
Principal Pianist: Marc Vayner
Chorus Masters: Alexey Dmitriev, Sergey Tsyplenkov
Director: Vyacheslav Kalyuzhny
Consultant in the Italian language: Daria Mitrofanova
Surtitles: Margarita Kunitsyna-Tankevich
Stage Manager: Olga Kokh 

 

Even when the prima donna is German, the tenor stammers, and the basso buffo bleats like a goat, a masterpiece can be born, and that’s how Gaetano Donizetti’s L’elisir d’amore first saw the light of the day in 1832. Felice Romani wrote the Italian libretto, after Eugène Scribe’s libretto for Daniel Auber’s Le philtre (1831). Shy and poor Nemorino has no chance with popular and rich Adina. Especially now that dashing officer Belcore arrived in town! Things change, however, when Dulcamara, with his magic potion, manages to settle all the problems.
Notwithstanding the hurry, the opera turned out wonderfully: the amusing storyline and light melodies created a work that has long been beloved of audiences.
Recommended for family viewing

SYNOPSIS

Peasants of an Italian village are having rest after the farm work. Adina, a pretty country belle, is sitting aside reading a book. The book tells the story of Tristan and Isolde and a wonderful elixir that brings the heart into obsessive passion. A young farmer Nemorino, desperately in love with Adina, is keeping an eye on her.
Belcore, a recruiting sergeant, arrives in the village at the head of a regiment of soldiers. To Nemorino’s horror, Belcore makes a proposal to Adina. The coquette doesn’t know who to choose, as her heart seems to be silent. A colorful wagon has come to the village — that is Dr Dulcamara, a peripatetic quack, selling different potions and arcana. Nemorino purchases a bottle allegedly containing “the elixir of love”, ordinary wine in reality. Eager to give it a try, Nemorino swallows the magic potion. The effect shows at once. Half-drunk, he flirts with girls making Adina jealous.
Adina, being piqued, declares she will marry Belcore. Nemorino, in despair, seeking Adina’s love wants to buy another bottle of the elixir but he’s short of money. Belcore enlists him in the army and thus Nemorino secures the necessary money. Now he’s able to get the magic elixir.
Gianetta brings stunning news: Nemorino’s uncle has died, leaving him sole heir. Now the young peasant is a desirable date mate. All the girls surround Nemorino with attention, which he thinks is due to the elixir. Its efficacy has been proved — everybody loves him. Adina is jealous but when she learns that Nemorino has sold his freedom to win her, she is deeply moved and realizes she loves him. She buys back his enlistment papers and finally admits her love. The lovers are happy. Dulcamara hasn’t expected such efficacy of his elixir and such fame and promises to come back with new stock of magic potions. Belcore is sure he’ll find another fiancée and leaves the village. The peasants see the sergeant and his soldiers off.

Casts & Credits

Opera company: Mikhailovsky Opera