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=287) 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=287) 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<>287 AND tp.id_base=538 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<>287 AND tp.id_base=538 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





	1 July 2018, 19:00 - Le Nozze di Figaro (Opera in four acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Bolshoi theatre - Small Stage 1 July 2018, 19:00 - Le Nozze di Figaro (Opera in four acts)
1July
19:00
2018 | Sunday
Opera
Bolshoi theatre - Small Stage, Moscow
Duration: 3 hours 15 minutes
World premiere: 25 April 2015

Le nozze di Figaro had its premiere in 1786 at the Burgtheater in Vienna. Lorenzo da Ponte – with whom Mozart later collaborated on Don Giovanni and Così fan tutte – created the libretto. It was based on Pierre Beaumarchais’ controversial play Le Mariage de Figaro, which was banned in Vienna due to its seditious content. David McVicar’s acclaimed production sets the action in a French chateau in 1830 on the eve of revolution, amplifying the opera’s undercurrents of class tension. The entire household is drawn into the notoriously complex plot, which covers all shades of human emotion: spirited playfulness, such as when Figaro sends Cherubino off to war in ‘Non più andrai’, is combined with heartfelt despair, such as the Countess’s grief at her husband’s infidelity in 'Dove sono i bei momenti'. But affection and fidelity prevail in this most warm-hearted of operas: the Count’s plea for forgiveness in the final act, ‘Contessa, perdono’, is one of the most moving moments in opera.

Libretto - Lorenzo da Ponte, after the comedy by Pierre-Augustin Caron de Beaumarchais

Music Director: William Lacey
Stage Director: Evgeny Pisarev
Set Designer: Zinovy Margolin
Costume Designer: Viktoria Sevryukova
Lighting Designer: Damir Ismagilov
Choreographer: Albert Alberts
Chorus Master: Valery Borisov 

Synopsis

Act I

Figaro and Susanna, servants to the Count and Countess Almaviva, are preparing for their wedding. Figaro is furious when he learns from his bride that the Count has tried to seduce her. He’s determined to have his revenge on his master.

Dr. Bartolo appears with his former housekeeper, Marcellina, who is equally determined to marry Figaro. She has a contract: Figaro must marry her or repay the money he borrowed. When Marcellina runs into Susanna, the two rivals exchange insults.

Susanna returns to her room and an adolescent boy, Cherubino, rushes in. Finding Susanna alone, he tells her he loves her — and every other woman in the house. The Count appears, again trying to seduce Susanna, and Cherubino hides. The Count then conceals himself as well when Basilio, the music teacher, approaches. Basilio tells Susanna that Cherubino has a crush on the Countess. This causes the Count to step forward in anger. He becomes even more enraged when he discovers Cherubino and realizes that his attempts to seduce Susanna have been overheard.

He chases Cherubino into the great hall where they are met by Figaro, who has assembled the entire household to sing the praises of their master. The Count is forced to bless the marriage of Figaro and Susanna. To spite them and to silence Cherubino, he orders the boy to join the army without delay. Figaro ironically tells Cherubino what to expect in the army — no flirting with girls, no fancy clothes, no money, just shells, cannons, bullets, marching, and mud.

Act II

In her bedroom, Rosina, the Countess, mourns the loss of love in her life. Encouraged by Figaro and Susanna, she agrees to set a trap for her husband: they will send Cherubino, disguised as Susanna, to a rendezvous with the Count that night and at the same time make him believe that the Countess is having an assignation with another man. Cherubino appears and the two women lock the door, then begin to dress him up as a girl. While Susanna steps into an adjoining room, the Count knocks and is annoyed to find the door locked. Cherubino shuts himself in the dressing room and the Countess lets her husband in. When there’s a sudden noise from the dressing room, the Count skeptical of his wife’s story that Susanna is in there. 
Taking his wife with him, he leaves to get tools to force the door. Meanwhile, Susanna, who has re-entered the room unseen and observed everything, helps Cherubino escape through the window before taking his place in the dressing room. When the Count and Countess return, both are astonished to find Susanna in there. All seems well until the gardener, Antonio, appears, complaining that someone has jumped from the window, ruining his flowers. Figaro, who has rushed in to announce that everything is ready for the wedding, improvises quickly, feigning a limp and pretending that it was he who jumped. At that moment Bartolo, Marcellina, and Basilio arrive, putting their case to the Count and waving the contract that obliges Figaro to marry Marcellina. Delighted, the Count declares that Figaro and Susanna’s wedding will be postponed.

Act III

Later in the day in the great hall, Susanna leads the Count on with promises of a rendezvous that night. He is overjoyed but then overhears Susanna conspiring with Figaro. In a rage, he declares he will have revenge.

The Countess, alone, recalls her past happiness. She’s determined to go through with the conspiracy against her husband, and she and Susanna compose a letter to him confirming the rendezvous with Susanna that evening in the garden under the pine trees. 
Marcellina, supported by a lawyer, Don Curzio, demands that Figaro pay his debt or marry her at once. Figaro replies that he can’t without the consent of his parents for whom he’s been searching for years, having been abducted as a baby. When he reveals a birthmark on his arm Marcellina realizes that he is her long-lost son, fathered by Bartolo. Seeing Figaro and Marcellina embrace, Susanna thinks her fiancé has betrayed her, but she is pacified when things are explained.

Cherubino, now dressed as a girl, appears with his girlfriend, Barbarina, the daughter of Antonio. Antonio, who has found Cherubino’s cap in the garden, also arrives and unmasks the young man. The Count is furious to discover that Cherubino has disobeyed him and is still in the house. But his anger is punctured by Barbarina—who reveals that the Count, when he attempted to seduce her, promised her anything she wanted. What she wants now is to marry Cherubino. The Count is forced to agree. A march is heard and the household assembles for Figaro and Susanna’s wedding. While dancing with the Count, Susanna hands him the letter, sealed with a pin.

Act IV

At night in the garden, Barbarina is in despair: she has lost the pin that the Count has asked her to take back to Susanna. When Figaro and Marcellina appear, Barbarina tells them about the planned rendezvous between the Count and Susanna. Thinking that his bride is unfaithful, Figaro rants against all women. He hides when Susanna and the Countess arrive, dressed in each other’s clothes. Alone, Susanna sings of love. She knows that Figaro is listening and enjoys making him think that she’s about to make love to the Count. Then she also conceals herself—in time to see Cherubino try to seduce the disguised Countess. The boy is chased away by the Count who wants to be alone with the woman he believes to be Susanna. Figaro, by now realizing what is going on, joins in the joke and declares his passion for Susanna in her Countess disguise. The Count returns. Finding Figaro with his wife, or so he thinks, he explodes with rage. At that moment, the real Countess steps forward and reveals her identity. Ashamed, the Count asks her pardon. After many moments of agonizing doubt, she forgives him and both couples are reunited.

Casts & Credits

Opera company: Bolshoi Opera
Soprano: Anna Aglatova
Lighting Designer: Damir Ismagilov
Set Designer: Zinovy Margolin
Stage Director: Evgeny Pisarev