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=2201) 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=2201) 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<>2201 AND tp.id_base=2208 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<>2201 AND tp.id_base=2208 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





	21 July 2018, 12:00 - Cesare Pugni "La Fille du Pharaon" (Ballet in three acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Bolshoi theatre - Historic Stage 21 July 2018, 12:00 - Cesare Pugni "La Fille du Pharaon" (Ballet in three acts)
21July
12:00
2018 | Saturday
Classical ballet
Bolshoi theatre - Historic Stage, Moscow
Duration: 2 hours 45 minutes
World premiere: Bolshoi theatre, Moscow, Russia, 5 May 2000

Libretto by Jean-Henry Saint-Georges
and Maurice Petipa after the story Le roman de la momie
by Theophile Gautier,
version by Pierre Lacotte

Author of the score’s version: Alexander Sotnikov
Choreographer: Pierre Lacotte
(after the ballet of the same name by Marius Petipa)
Designer: Pierre Lacotte
Lighting Designer: Mikhail Sokolov

The Russian Daughter of Two Frenchmen
“A Dream from the Past” — such was the sign, written in bold letters so it was visible through the thick clouds covering the stage, that appeared at the end of the prologue to the ballet La Fille du Pharaon, at its premiere performance in 1862. And this was followed by a grandiose spectacle, the like of which had never been seen by imperial ballet. Here there was something for all tastes. A desert storm, a lion-hunt, various chases, several suicide attempts, a fantastic celebration of all the world’s rivers and also of nereids and nymphs at the bottom of the majestic Nile. The cast included an English aristocrat traveler, his servant, a Sancho Panza-like character, a Nubian King, Armenian merchants who, after smoking opium, had found themselves in Ancient Egypt...And in the heavens there appeared Egyptian gods, under the command of Osiris and Isis.

La Fille du Pharaon was immensely popular with the public. To obtain a box for a performance of this ballet, which started at 7.30 in the evening and ended just before midnight, was considered a great feat. La Fille had a long and happy performance history. First produced by Marius Petipa in 1862, at Petersburg’s Bolshoi Theatre, it was given several revivals. It was adored by Petersburg ballerinas, especially Mathilda Kshessinska who regarded the ballet as her ’personal property’ and shone in it not only by virtue of her technique, but also thanks to her Romanov Faberge diamonds. In La Fille, Kshessinska felt herself to be the ’queen of the ball’.

La Fille du Pharaon was danced to acclaim in Moscow too. In 1864, the ballet was transferred from Petersburg to Moscow’s Bolshoi Theatre. But in Soviet times it was considered to be ideologically immature and, dropped from the repertoire, it was virtually forgotten.

Pierre Lacotte, the famous researcher into our ballet legacy, who has breathed new life into more than one forgotten masterpiece of past centuries, had long ago been fired with enthusiasm by the idea of resurrecting Petipa’s mighty, pseudo-Egyptian fresco: ever since, in fact, he had begun to realize the fascinating discoveries to be made by the would-be restorer of ancient ballets, an art genre that one might think did not lend itself to restoration.

The second birth of La Fille du Pharaon took place in Moscow in the year 2000 — the reconstruction was undertaken by Pierre Lacotte in answer to an exclusive commission from the Bolshoi Theatre.

La Fille’s third birth, may be considered to be the video recording of this production taken by the French Bel Air Media Company.

Casts & Credits

Composer: Cesare Pugni
Ballet company: Bolshoi Ballet
Conductor: Pavel Klinichev
Choreographic version: Pierre Lacotte
Designer: Pierre Lacotte
Musical Director: Alexander Sotnikov
Composer: Cesare Pugni
Ballet company: Bolshoi Ballet
Conductor: Pavel Klinichev
Choreographic version: Pierre Lacotte
Designer: Pierre Lacotte
Musical Director: Alexander Sotnikov