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=868) 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=868) 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<>868 AND tp.id_base=916 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

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<>868 AND tp.id_base=916 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





	26 October 2019, 13:00 - Adolphe Adam "Le Corsaire" (Ballet in 2 Acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mikhailovsky Theater 26 October 2019, 13:00 - Adolphe Adam "Le Corsaire" (Ballet in 2 Acts)
26October
13:00
2019 | Saturday
Classical ballet
Mikhailovsky Theater, Saint Petersburg
Duration: 2 hours 40 minutes
World premiere: 4 December 1993

Synopsis


The storm sinkes a ship of corsairs.



ACT 1

Scene 1

A leader of the corsairs Conrad appears save at the shore of an island. He also saved corsair Birbanto that lost his consciousness. Conrad gets ashore and also faints. Fisherwomen come to the shore. Among them are two friends - Medora and Gulnare. Medora sees the corsairs. She tries to make Conrad come to himself. As soon as Conrad opens his eyes he remembers everything that has happened with him. He tries to call his friends but all invane. Turkish soldiers look for rescued corsairs. The girls manage to hide Conrad and Birbanto but they are captured by the enemy. They are transported to the ship op the merchant Akhmet who sells slaves.



Scene 2
The Turkish port. Slave’s market. Akhmet starts selling the captured girls. Most slaves get the richest person Seyd the Pacha-Pacha also buys Gulnare. Akhmet especially praises the beauty of Medora. An Arab sheik appears. A great bargain begins between Sheik and Seyd the Pacha. Sheik stoppes bargain and gives a chance to Seyd the Pacha to buy Medora. In triumph the Pacha asks his rival who is he. As an answer he takes of his bunus - everybody are shock. They recognize the famous corsaire Conrad. The treat of all the turks is alive! Slaves become free and corsairs escape. Birbanto tries to steal sacks with jewelry but the Turks catch him and he is about to betray his comrades out of cowardliness.

Scene 3
Conrad fells in love with Medora. He shows her his vast estate. Conrad orders his corsairs to return girls to their homes and gives them generous presents.
The corsairs are not satisfied and they try to dispute the order of Conrad. Birbanto is especially excited. He wants to devide the girls and all the gaing between corsairs. Conrad doesn’t want to listen to them. His power dominates over Birbanto and his friends. Akhmet offers to put to sleep Conrad with the help of special medicine and to take his revenge of him returning Medora to Seyd the Pacha.
Akhmet gives Conrad a flower with a sleeping - poison. Conrad smells the flower and falls asleep immediately. Medora calls for help, but only conspirators come to her calls...

ACT 2

Scene 4

On board of the ship of Seyd the Pacha. Seyd the Pacha has a feast in his harem. Akhmet and Birbanto takes Medora here. A dervise and his servant come to the harem - they are Conrad and Ali who decided to set Medora free.
Birbanto recognizes Conrad. They start fighting and corsairs win. Free slaves and girls rejoice. The ship is sailing to free shores.

CAST
Medora.
Gulnare.
Conrad, leader of corsairs.
Ali, friend of Conrad.
Akhmet.
Birbanto, assistant of Conrad.

Seyd the Pacha.
Turks officer
Classical trio
Solo in the orchestra


Photos



Casts & Credits

Composer: Andrey Petrov
Composer: Adolphe Adam
Composer: Cesare Pugni
Composer: Leo Delibes
Composer: Riccardo Drigo
Choreography: Marius Petipa
Ballet company: Mikhailovsky Ballet
Set Designer: Simon Virsaladze
Composer: Andrey Petrov
Composer: Adolphe Adam
Composer: Cesare Pugni
Composer: Leo Delibes
Composer: Riccardo Drigo
Choreography: Marius Petipa
Ballet company: Mikhailovsky Ballet
Set Designer: Simon Virsaladze