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=193) 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=193) 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<>193 AND tp.id_base=1974 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<>193 AND tp.id_base=1974 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





	28 November 2018, 19:00 - L`elisir d`amore (The Elixir of Love)  Comic opera in 2 acts - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Stanislavsky theatre 28 November 2018, 19:00 - L`elisir d`amore (The Elixir of Love) Comic opera in 2 acts
28November
19:00
2018 | Wednesday
Duration: 2 hours 30 minutes
World premiere: 25 July 1998

Music  Gaetano Donizetti
Libretto  Felice Romani
Music Director  Wolf Gorelik
Conductor 
Felix Korobov
Maria Maksimchuk
Stage Director  Lyudmila Naletova
Set Designer  Viktor Arkhipov
Costume Designer  Viktor Arkhipov
World premiere: May 12, 1832
Teatro della Canobbiana, Milan

The first production at the 
Stanislavsky and Nemirovich-Danchenko 
Moscow Academic Music Theatre: June 16, 1964

Premiere of the new production: July 25, 1998
Overview

"Marvelously detailed staging by Lyudmila Naletova that captures at every turn both the work’s pathos and its humor. Designer Viktor Arkhipov aids Naletova with a riot of color in sets and costumes, vaguely – but only very vaguely – suggesting the composer’s own native northern Italy…"

Raymond Stults
The Moscow Times

Сast
Conductor 
Felix Korobov
Maria Maksimchuk
Adina 
Hibla Gerzmava
Daria Terekhova
Lilia Gaisina
Nemorino 
Liparit Avetisyan
Nurlan Bekmukhambetov
Belcore 
Andrey Baturkin
Alexey Shishlyaev
Dulcamara 
Roman Ulybin
Gianetta 
Evgenia Afanasieva
Valeria Zaitseva

 

Synopsis

ACT I.

Basque country, c. 1830. Adina, wealthy owner of a local farm, her friend Giannetta and a group of peasants are resting beneath a shade tree on her estate. At a distance Nemorino, a young villager, laments he has nothing to offer Adina but love. The peasants urge their mistress to read them a story — how Tristan won the heart of Isolde by drinking a magic love potion. No sooner has Adina done so than Sgt. Belcore swaggers in with his troop. The soldier’s conceit amuses her, but he is not dissuaded from asking her hand in marriage. Saying she will think it over, she orders refreshments for his comrades. When Adina and Nemorino are left alone, he awkwardly declares his love. She tells him his time would be better spent looking after his ailing uncle than mooning over her, for she is fickle as a breeze.

In the town piazza, villagers hail the traveling salesman Dr. Dulcamara, who proclaims the virtues of his patent medicine. Since it is inexpensive, the villagers buy eagerly. When they have gone, Nemorino asks Dulcamara if he sells the elixir of love described in Adina’s book. Pulling out a bottle of Bordeaux, the charlatan declares this is the very draught. Though it costs him his last cent, Nemorino buys the wine and hastily drinks it. Adina enters to find him tipsy; certain of winning her love, he pretends indifference. To punish him, Adina flirts with Belcore, who, informed that he must return to his garrison, persuades her to marry him at once. Horrified, Nemorino begs Adina to wait one more day, but she ignores him and invites the entire village to her wedding feast. Nemorino rushes away, moaning that he has been ruined by Dulcamara’s elixir.

ACT II.

At a local tavern, the pre-wedding supper is in progress. Dulcamara, self-appointed master of ceremonies, sits with the bridal couple. Adina’s mind is distracted by the doctor, who suggests they blend their voices in a barcarole about a gondoliera and her wealthy suitor. When the duet ends, Adina goes off with Belcore to sign the marriage contract; the guests disperse. Remaining behind, Dulcamara is joined by Nemorino, who begs for another bottle of elixir; his pleas are rejected, because he has no money. Belcore returns, annoyed that Adina has postponed the wedding until nightfall; he spies Nemorino and asks why he is so sad. The youth explains his financial plight, whereupon the sergeant persuades him to join the army and receive a bonus awaiting all volunteers. Belcore leads the perplexed Nemorino off to sign him up, enabling him to buy more elixir.

Peasant girls, gathered in the square, hear from Giannetta that Nemorino’s uncle has died and willed him a fortune. When the youth reels in, giddy from a second bottle of wine, they besiege him with attention; unaware of his new wealth, he believes the elixir finally has taken effect. Adina and Dulcamara arrive in time to see him leave with a bevy of beauties, and she, angry that he has sold his freedom to Belcore, grows doubly furious. Hoping to sell Adina a bottle of elixir, Dulcamara claims that Nemorino’s popularity is due to the magic potion. Adina replies she will win him back through her own charms. Reentering alone in a pensive mood, Nemorino takes heart because of a tear he has seen on Adina’s cheek, but when she appears, he acts disinterested. She confesses she bought back his enlistment papers because she loves him.

Back in the piazza, Belcore marches in to find Adina affianced to Nemorino; declaring that thousands of women await him, he accepts the situation philosophically. Attributing Nemorino’s happiness and inheritance to the elixir, Dulcamara quickly sells more bottles before making his escape.