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=433) 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=433) 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<>433 AND tp.id_base=507 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<>433 AND tp.id_base=507 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





	8 June 2018, 19:00 - Georges Bizet "Carmen" opera in 4 acts - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Bolshoi theatre - Historic Stage 8 June 2018, 19:00 - Georges Bizet "Carmen" opera in 4 acts
8June
19:00
2018 | Friday
Opera
Bolshoi theatre - Historic Stage, Moscow
Duration: 3 hours 10 minutes
World premiere: Theater "Opera-Comique" (France), 3 March 1875

No man can resist Carmen’s gypsy charms, but when she’s ready to move on, watch out! A riveting drama of love and jealousy, filled with famously alluring melodies and captivating dances, Carmen is one of the world’s most popular operas. With dazzling bursts of color, a thrilling production brings the sights and sounds of Seville to life, from the dusty town center to the clamor of the bullring. Bizet’s immortal score overflows with one delight after another, a music lover’s hit parade of opera’s most intoxicating melodies.

Music: George Bizet

Libretto: Henri Meilhac and Ludovic Halevy revised by Ernest Guiraud after the novel by Prosper Merimee
Music Director: Tugan Sokhiev
Stage Director: Alexei Borodin
Set Designer: Stanislav Benediktov
Costume Designer: Valentina Komolova
Lighting Designer: Damir Ismagilov
Chorus Master: Valery Borisov
Choreographers: Ricardo Castro, Rosario Castro
Director of Stage Movement: Andrei Ryklin

 Synopsis

ACT I.

In a square in Seville, townspeople and soldiers relax in the summer sun. Micaela arrives in search of her sweetheart, Don Jose, a corporal. A fellow officer, Morales, tells her Jose will be there later, then offers himself as a substitute, but she leaves hastily. As the guard changes, children parade, imitating the soldiers ("Avec la garde montante"), whose number now includes Jose. At the sound of the noon bell, girls from the cigarette factory come to smoke and chat ("Dans l’air"). Carmen, a Gypsy who works in the factory, flirts with the local men, airing her philosophy of life: love is a wild bird that cannot be tamed (Habanera: "L’amour est un oiseau rebelle"). Sullen and distracted, Jose sits apart. Drawn by his indifference, Carmen tosses him a flower from her bodice as the work bell calls the girls back inside. Micaela returns to give Jose news of his mother, who has sent him a kiss, which the girl delivers shyly ("Parle-moi de ma mиre"). No sooner has she left than a disturbance is heard in the factory: Carmen is involved in a fight. The girls run out, arguing over who started it. Lt. Zuniga orders Jose to arrest Carmen, but she resists their questions with brazen nonchalance. Her wrists bound, she is left alone with Jose, who forbids her to speak to him. Instead, she flirts with him by singing "to herself" about Lillas Pastia’s inn and the rendezvous she might make with "a certain officer" who has taken her fancy (Seguidilla: "Prиs des remparts de Sйville"). Jose, intoxicated, agrees to let her escape in exchange for the promised rendezvous; when she pushes him to the ground and runs off, he is arrested for his negligence.

ACT II.

A month later, at Lillas Pastia’s, Carmen regales the customers with a Gypsy song ("Les tringles des sistres tintaient"). The matador Escamillo arrives, boasting of his exploits in the arena ("Votre toast"). He is immediately attracted to Carmen, who puts off his amorous advances. When the inn closes, Dancaire and Remendado try to convince Frasquita, Mercйdиs and Carmen to accompany them on their next smuggling trip. The girls are game, except for Carmen, who says she is in love with Jose and is awaiting his return from prison (quintet: "Nous avons en tete"). The others laugh at her, then depart as Jose is heard approaching. Carmen sings and dances for him, but when a distant bugle sounds the retreat, he says he must return to the barracks. Carmen angrily mocks him, saying he doesn’t love her, and he replies by telling her how he has kept the flower she threw, the scent of its wilted blossom conjuring up her image in his prison cell ("La fleur que tu m’avais jetйe"). He refuses her suggestion that he join her wild mountain life, but when Zuniga breaks in, looking for Carmen, Jose loses his temper and attacks his superior. Carmen summons the other Gypsies, who throw the lieutenant out. Jose, now an outlaw, has no choice but to join their band.

ACT III.

In their mountain hideout, the smugglers congratulate themselves on their successful trade, but Jose is unhappy. Carmen finds his homesickness tiresome and occupies herself with her friends, reading fortunes in the cards. Frasquita foresees a lover for herself, Mercйdиs a rich husband, but Carmen sees only death ("En vain pour eviter"). The Gypsies leave Jose as lookout, and Micaela enters, frightened but determined to find him ("Je dis que rien ne m’epouvante"). She hides at the sound of a shot, fired by Jose as a warning to Escamillo, who has come looking for Carmen. The two men start to fight but are separated by the Gypsies. Escamillo invites them all to his next bullfight and leaves. Remendado discovers Micaela, who has come to beg Jose to return home to his ailing mother. Carmen dismisses him willingly, but Jose, convinced she wants to be rid of him in order to take up with Escamillo, vows to find her again after he has seen his mother.

ACT IV.

In Seville’s Plaza de Toros, the crowd gathers for the bullfight, hailing Escamillo. He and Carmen declare their love, and he enters the ring. Carmen’s friends warn that Jose has been spotted nearby, looking desperate, but she is a fatalist and defiantly remains in the square to face him. He enters ("C’est toi?") and begs her to return to him, saying there is still time for them to start again. She replies that everything is finished between them, tossing his ring in his face as the crowd is heard cheering the triumphant Escamillo. When Carmen tries to run past Jose into the arena, he stabs her, then falls by her body in despair.


Casts & Credits

Composer: Georges Bizet
Opera company: Bolshoi Opera
Conductor: Anton Grishanin
Baritone: Ilya Kutyukhin
Mezzo soprano: Julia Mazurova
Soprano: Anna Aglatova
Lighting Designer: Damir Ismagilov
Musical Director: Tugan Sokhiev
Composer: Georges Bizet
Opera company: Bolshoi Opera
Conductor: Anton Grishanin
Baritone: Ilya Kutyukhin
Mezzo soprano: Julia Mazurova
Soprano: Anna Aglatova
Lighting Designer: Damir Ismagilov
Musical Director: Tugan Sokhiev