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=275) 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=275) 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<>275 AND tp.id_base=850 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<>275 AND tp.id_base=850 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





	4 March 2019, 19:00 - L`italiana in Algeri (The Italian Girl in Algiers) an operatic dramma giocoso in two acts by Gioachino Rossini - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Stanislavsky theatre 4 March 2019, 19:00 - L`italiana in Algeri (The Italian Girl in Algiers) an operatic dramma giocoso in two acts by Gioachino Rossini
World premiere: 28 May 2013



Composer
Gioachino Rossini
Libretto by Angelo Anelli
Musical Director and Conductor Felix Korobov
Stage Director Evgeny Pisarev
Set Design Zinovy Margolin
Costume Design Viktoria Sevryukova
Conductor Vyacheslav Volich
Principal Chorus Master Stanislav Lykov
Choreography Albert Albert
Lighting Damir Ismagilov


Synopsis

Act 1

In the palace of the Bey of Algiers. Elvira (soprano), accompanied by her slave Zulma (mezzo), regrets the loss of the love of her husband, the Turkish Bey Mustafа (bass). Left alone with Haly (bass), Captain of the Corsairs, Mustafа reveals his plan to marry Elvira off to Lindoro, his Italian slave. The Bey is bored with his submissive harem, desiring a new challenge to his virility: he wants an Italian girl! Haly must find one! Lindoro (tenor) enters alone and sings about Isabella, his true love, 'Languir per una bella'. Mustafа comes in to explain about Lindoro's impending marriage. The enthusiastic Bey describes the attractions of the match, while Lindoro struggles to refuse.

The scene changes to the seashore where a ship has been wrecked in a storm. Its passengers include Isabella (contralto), in search of Lindoro, and Taddeo (bass), her travelling companion and would-be lover. Isabella enters with a sorrowful cavatina 'Cruda sorte! Amor tiranno!', however she is not afraid and will master the situation. Haly and his men take them prisoner. She passes off Taddeo as her uncle. Haly is delighted to learn she is an Italian! Exactly what the Bey wanted! Left to consider their fate, Isabella is irritated by Taddeo's jealousy of Lindoro, but they resolve to join forces.

Back in the palace, Lindoro and Elvira do not wish to marry, but Mustafа offers Lindoro passage on a ship returning to Italy - if he takes Elvira. Lindoro agrees, admitting a vague possibility of marrying her in Italy. Haly enters with news of the arrival of the Italian beauty. Mustafа is elated, 'Giа d'insolito ardore nel petto agitare'.

Surrounded by eunuchs, Mustafа receives Isabella in a grand hall. He is enchanted. At that moment, Lindoro, Elvira and Zulma arrive to say goodbye to Mustafа. Lindoro and Isabella are astonished to come face to face. Recovering herself, Isabella asks about Elvira, learning she is Mustafа's ex-wife, to be remarried to Lindoro!

Act 2

In the palace. Elvira and Zulma (who have remained in Algiers after all) note Isabella's skill with men. Mustafа reveals his strategy. Lindoro is now installed as Isabella's servant and his informer, Taddeo will also be induced to help. Elvira and Zulma must tell Isabella he is coming to take coffee with her!

Isabella and Lindoro are alone. He explains that he had no intention of marrying Elvira. They agree to escape together and Lindoro sings of his happiness, 'Ah come il cor di giubilo'. Mustafа enters with a reluctant Taddeo, acclaimed by the Turks as 'Lord Kaimakan'. He dislikes interceding with Isabella for the Bey, but is frightened to refuse.

In her apartment, Isabella is dressing in Turkish style. Zulma and Elvira deliver Mustafа's message: he is coming for coffee. Isabella orders three cups. Elvira should wait in a side room. As Mustafа approaches, Isabella sings a romantic cavatina, 'Per lui che adoro'. She will receive him. Mustafа tells Taddeo to leave when he sneezes. Isabella greets Mustafа warmly and he sneezes, but Taddeo ignores the signal. Isabella calls for coffee and then - to Mustafа's horror and amazement - invites Elvira to join them.

Elsewhere in the palace, Haly sings in praise of the women of Italy, 'Le femmine d'Italia'. The Italians enter and Taddeo reveals to a surprised Lindoro that he is not her uncle but her lover, himself unaware of the other man's true identity. Lindoro tells Mustafа that Isabella will declare him her adored 'pappataci' [literally a 'silent eater': a man unable to resist the opposite sex]. This, as Lindoro explains, is an Italian custom and a great honour, as the 'pappataci' enjoy an idyllic life dedicated to eating, drinking and sleeping. Zulma and Haly speculate about Isabella's real intentions and the quantity of alcohol ordered for the ceremony.

In her apartment, Isabella addresses the Italian slaves who will be 'pappataci' in the ceremony. She will lead them to freedom, 'Pensa alla patria'. The ceremony begins, Mustafа is delighted with his new honour and changes into appropriate costume. Isabella explains his obligations. He must swear an oath of eating, drinking, and keeping silent, repeating the words after Taddeo. Following that his oath is tested, under provocation by Isabella and Lindoro.

A European ship lies alongside the palace: time to escape! Taddeo finally realizes who Lindoro is, but decides to go along with them anyway. Elvira, Zulma and Haly find the Bey still acting as a mad 'pappataci'. Suddenly recovering his sanity, Mustafа calls his troops but they are all drunk. The Italians bid farewell and Mustafа begs Elvira's forgiveness. No more Italian girls for him!

 

 
 



Casts & Credits

Choreography: Albert Albert
Costume Designer: Viktoria Sevryukova
Lighting Designer: Damir Ismagilov
Musical Director: Felix Korobov
Principal Chorus Master: Stanislav Lykov
Set Designer: Zinovy Margolin
Stage Director: Evgeny Pisarev
Choreography: Albert Albert
Costume Designer: Viktoria Sevryukova
Lighting Designer: Damir Ismagilov
Musical Director: Felix Korobov
Principal Chorus Master: Stanislav Lykov
Set Designer: Zinovy Margolin
Stage Director: Evgeny Pisarev