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=1093) 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=1093) 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<>1093 AND tp.id_base=1513 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<>1093 AND tp.id_base=1513 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





	23 May 2019, 19:00 - Alexander Dargomyzhsky "The Stone Guest" (Opera in two acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Bolshoi theatre - Small Stage 23 May 2019, 19:00 - Alexander Dargomyzhsky "The Stone Guest" (Opera in two acts)
23May
19:00
2019 | Thursday
Opera
Bolshoi theatre - Small Stage, Moscow
Duration: 2 hours 5 minutes
World premiere: Bolshoi theatre - Small Stage, 11 March 2016

The Stone Guest is an opera in three acts by Alexander Dargomyzhsky from a libretto taken almost verbatim from Alexander Pushkin's play of the same name which had been written in blank verse and which forms part of his collection Little Tragedies.

It was first performed at the Mariinsky Theatre, Saint Petersburg, 16 February 1872.

According to the composer's wishes, the last few lines of tableau 1 were composed by Cesar Cui, and the whole was orchestrated by Nikolai Rimsky-Korsakov. Many years later, Rimsky-Korsakov revised his own orchestration of the opera, rewrote a few of Dargomyzhsky's own original passages, and added an orchestral prelude. This version, completed in 1903 and first performed in 1907 at the Bolshoi Theatre, is now considered the standard version.

Libretto by the composer after Alexander Pushkin's play of the same name

Music Director: Anton Grishanin
Stage Director: Dmitry Belyanushkin
Set Designer: Victor Shilkrot
Costume Designer: Irena Belousova
Lighting Designer: Evgeny Vinogradov
Video Projection: Dmitri Martynov

Synopsis

Act I

Scene One
Don Juan, banished from Madrid for killing the Commander de Solva, has secretly returned. Accompanied by his servant Leporello, he hides near a monastery outside Madrid. Remembering his past affairs, he plans to get in the city to continue his adventures. The Monk tells him that Doña Anna, the widow of the Commander, visits the cemetery every day. Don Juan sees Doña Anna and feels an urge to get to know her.

Scene Two
Laura is having a party; many of the guests are people she never met before. She entertains them with singing. One of the songs is based on a poem by Don Juan, Laura’s former lover. The quick-tempered Don Carlos gets enraged, which almost ruins the conspiring guests’ plan. Laura resumes her singing, but it it clear to her that the guests did not come to hear her songs. Laura makes everyone but Don Carlos leave. Him she seduces and thus learns that there is a conspiracy against Don Juan. Presently Don Juan appears.

Don Carlos insists that the inevitable duel should take place on the spot. Don Juan kills Don Carlos. Laura shows Don Juan a list of conspirators. Their privacy is violated by the conspirators’s assault, but Don Juan manages to escape.

Act II

Don Juan hides in the monastery disguised as a hermit. Doña Anna comes there every day to visit her husband’s grave. Don Juan introduces himself to her as Don Diego. Doña Anna agrees to receive him at her place the next day. Leporello tries to warn his master by hinting that the Commander's death was not forgiven and that the trap is set. Don Juan challenges his fate: he invites the Commander, an embodiment of the tyranny and total control, to join him on his next day’s rendezvous. Leporello begs forgiveness for his betrayal, because it is clear for him now that Don Juan knows it was he who brought the conspirators to Laura’s.

Act III

A room at Doña Anna’s. She spent a night with Don Juan, but now he has to leave her. Unable to conceal the truth any longer, he confesses that he killed her husband and that he loves her with all his heart. Doña Anna cannot hate him; instead she realizes that she loves him in return. Don Juan aspires for a new rendezvous, but the men of ‘the stone guest’ have already tracked him down. Not surrendering, Don Juan extends his hand to them as a token of love and freedom. They kill him.