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-06-03' AND tmp.date<='2024-06-23' AND tmp.perf_id=2566) 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-06-03' AND '2024-06-23' AND tmp.perf_id=2566) 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<>2566 AND tp.id_base=-1 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<>2566 AND tp.id_base=-1 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 March 2019, 19:00 - Boheme (Opera in Four Acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Stanislavsky theatre 1 March 2019, 19:00 - Boheme (Opera in Four Acts)
1March
19:00
2019 | Friday
Opera
Stanislavsky theatre, Moscow
Composer Giacomo Puccini
Libretto by Luigi Illica, Giuseppe Giacosa
Musical Director and Conductor Wolf Gorelik
Stage Director Alexander Titel
Set Design Yury Ustinov
Costume Design Irina Akimova
Conductor Maria Maksimchuk
Genre Opera
Number of acts 4
Language Italian
Original name La Boheme
Premiere January 7, 1996

Ў°Narrow streets of the Latin quarter, attics and bars, poor and merry students, colourfully dressed girls from cafЁ¦-chantants and fireworks of cracking jokes. And love, of courseЎ­Ў± Svetlana Savenko, "Literaturnaya gazeta"
Ў°If there were such a thing as an Oscar for Opera, this production would win it hands downЎ±. Corinne Dunne, Ў°Naples Daily NewsЎ±


Text in Italian by Giuseppe Giacosa and Luigi Illica, based on Henry MurgerЎЇs novel Scenes de la Vie de Boheme

Synopsis

ACT I.

In their Latin Quarter garret, the near-destitute artist Marcello and poet Rodolfo try to keep warm on Christmas Eve by feeding the stove with pages from RodolfoЎЇs latest drama. They are soon joined by their roommates - Colline, a young philosopher, and Schaunard, a musician, who brings food, fuel, and funds he has collected from an eccentric student. While they celebrate their unexpected fortune, the landlord, Benoit, comes to collect the rent. Plying the older man with wine, they urge him to tell of his flirtations, then throw him out in mock indignation at his infidelity to his wife. As his friends depart to celebrate at the Cafe Momus, Rodolfo promises to join them later, remaining behind to try to write. There is another knock at the door; the visitor is a pretty neighbor, Mimi, whose candle has gone out on the drafty stairway. No sooner does she enter than the girl feels faint; after reviving her with a sip of wine, Rodolfo helps her to the door and relights her candle. Mimi realizes she lost her key when she fainted, and, as the two search for it, both candles are blown out. In the darkness, Rodolfo finds the key and slips it into his pocket. In the moonlight the poet takes the girlЎЇs shivering hand, telling her his dreams ("Che gelida manina"). She then recounts her life alone in a lofty garret, embroidering flowers and waiting for the spring ("Mi chiamano Mimi"). RodolfoЎЇs friends are heard outside, urging him to join them; he calls back that he is not alone and will be along shortly. Expressing their joy in finding each other ("O soave fanciulla"), Mimi and Rodolfo embrace and slowly leave, arm in arm, for the cafe.

ACT II.

Amid the shouts of street hawkers, Rodolfo buys Mimi a bonnet near the Cafe Momus and then introduces her to his friends; they all sit down and order supper. The toy vendor Parpignol passes by, besieged by eager children. MarcelloЎЇs former sweetheart, Musetta, makes a noisy entrance on the arm of the elderly but wealthy Alcindoro. The ensuing tumult reaches its peak when, trying to regain MarcelloЎЇs attention, she sings a waltz about her popularity ("Quando meЎЇn voЎЇ"). She complains that her shoe pinches, sending Alcindoro off to fetch a new pair. The moment he is gone, she falls into MarcelloЎЇs arms and tells the waiter to charge everything to Alcindoro. Soldiers march by the cafe, and as the bohemians fall in behind, Alcindoro rushes back with MusettaЎЇs shoes.

ACT III.

At dawn on the snowy outskirts of Paris, a customs official admits farm women to the city. Merrymakers are heard within a tavern. Soon Mimi wanders in, searching for the place where Marcello and Musetta now live. When the painter emerges, she tells him of her distress over RodolfoЎЇs incessant jealousy ("O buon Marcello, aiuto!"). She says she believes it is best that they part. Rodolfo, who has been asleep in the tavern, wakes and comes outside. Mimi hides nearby, though Marcello thinks she has gone. The poet first tells Marcello that he wants to separate from his sweetheart, citing her fickleness; pressed for the real reason, he breaks down, saying that her coughing can only grow worse in the poverty they share. Overcome with tears, Mimi stumbles forward to bid her lover farewell ("Donde lieta usci") as Marcello runs back into the tavern hearing MusettaЎЇs laughter. While Mimi and Rodolfo recall past happiness, Musetta dashes out of the inn, quarreling with Marcello, who has caught her flirting ("Addio dolce svegliare"). The painter and his mistress part, hurling insults at each other, but Mimi and Rodolfo decide to remain together until spring.

ACT IV.

Now separated from their girlfriends, Rodolfo and Marcello lament their loneliness in their garret ("O Mimi, tu piЎм§Э non torni"). Colline and Schaunard bring a meager meal; to lighten their spirits the four stage a dance, which turns into a mock duel. At the height of the hilarity Musetta bursts in to tell them that Mimi is outside, too weak to come upstairs. As Rodolfo runs to her aid, Musetta relates how Mimi begged to be taken to her lover to die. The poor girl is made as comfortable as possible, while Musetta asks Marcello to sell her earrings for medicine and Colline goes off to pawn his overcoat, which for so long has kept him warm ("Vecchia zimarra"). Left alone ("Sono andati?"), Mimi and Rodolfo wistfully recall their meeting and their first happy days, but she is seized with violent coughing. When the others return, Musetta gives Mimi a muff to warm her hands and prays for her life. As she peacefully drifts into unconsciousness, Rodolfo closes the curtain to soften the light. Schaunard discovers that Mimi is dead, and when Rodolfo at last realizes it, he throws himself despairingly on her body, repeatedly calling her name.



Casts & Credits

Composer: Giacomo Puccini
Director: Alexander Titel
Musical Director: Wolf Gorelik
Composer: Giacomo Puccini
Director: Alexander Titel
Musical Director: Wolf Gorelik