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-05-14' AND tmp.date<='2024-06-03' AND tmp.perf_id=2221) 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-05-14' AND '2024-06-03' AND tmp.perf_id=2221) 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<>2221 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

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<>2221 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





	30 October 2018, 19:30 - Evening of one-act ballets: Chopiniana. Divertissement. Le Reveil de Flore (The Awakening of Flora). - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theater 30 October 2018, 19:30 - Evening of one-act ballets: Chopiniana. Divertissement. Le Reveil de Flore (The Awakening of Flora).
30October
19:30
2018 | Tuesday

"Chopiniana"

Choreographic composition in one act 

Music: Frederic Chopin (suite of piano pieces orchestrated: Alexander Glazunov and Maurice Keller)
Choreography: Michel Fokine (1908)
Scenario: Michel Fokine
Revised version: Agrippina Vaganova (1931)
Set design based on original sketches: Orest Allegri 

World premiere: 8 March 1908, Mariinsky Theatre, St Petersburg 

Running time: 35 minutes

ABOUT THE PRODUCTION

“In 1906, when rehearsing the production of the first version of Chopiniana performed to Glazunov’s orchestration of Chopin’s music, I created for Pavlova and Obukhov – my friend from the ballet school – a waltz in C Sharp Minor, which was specially orchestrated by Glazunov at our request as an addition to the suite. 
The sylph – winged hope – flies into a romantic garden lit by the moon. She is followed by a young man. It was dancing in the style of Taglioni, in the style of that long-forgotten time when ballet was governed by poetry, when a dancer rose en pointe not to demonstrate the steel-like arch of her foot but in order to create the impression of lightness, barely touching the ground, something ethereal and fantastical. In this dance there is not one pirouette, not a single trick. But how poetic, how beautiful and how engaging was this duet in the air! The audience was enchanted, as was I. Pavlova made such a powerful impression on me that I wondered about staging an entire ballet in this style. And by the time her next gala performance came round I had created the ballet Les Sylphides. If, back then, she had not danced Chopin’s waltz so brilliantly, so enchantingly, I would never have created this ballet.” 
Michel Fokine. Hightlights from the article Memoirs of a Ballet-Master

"Le Reveil de Flore (The Awakening of Flora)"

Music by Riccardo Drigo
Choreography by Marius Petipa and Lev Ivanov (1894)
Scenery Academician Mikhail Bocharov
Costumes by Eugene Ponomarev

(reconstruction of the performance of 1894)
The authors of the reconstruction:
Conductor Pavel Bubelnikov
Choreographer Sergey Vikharev
Artist and stage set designer Mikhail Shishlyannikov
Costume Designer Irina Korovina
Lighting Designer Vladimir Lukasevich

ABOUT THE PRODUCTION

Scene 1-st. Danse de Diane (Dance of Diana). Night. Flora and her nymphs in deep sleep; Diana, the goddess of the night, protects their peace. With the approach of dawn in the air, freshness is felt. Diana hides in the clouds.
Scene 2-nd. Entree d'Aquilon, La rosee.  Akvilon sweeps over the terrain; his sharp impulse awakens the sleeping ones and makes them seek refuge in the foliage. The appearance of a cold dew leads Flora into despair, and she begs the Aurora to come to their aid.
Scene 3rd. Arrivee d'Aurore (Appearance of Aurora), Valse (Waltz). Aurora comforts Flora with tender caresses and announces that she is followed by the god of the day - Apollo, who will put an end to their torment.
Scene 4th. Entree d'Apollon, Zephyre, Cupidon et les Amours (Quit of Apollo, Zephyr, Cupid and Cupids), Pas d'action. When the luminous Apollo appears, everything comes to life. Admired by the beauty of the flower goddess, he kisses her. At the call of the god of the day, the light and gentle breeze of Zephyr flies into the arms of his beloved Flora. "You must be his friend," Apollo tells her. "That's the will of the gods." Everyone is delighted. Cupid, cupids and nymphs rejoice in the happiness of lovers.
Scene 5. Arrivee de Mercure, Ganymede et Hebe (The Appearance of Mercury, Ganymede and Geba) Mercury, the messenger of the gods, announces the arrival of Ganymede. Flore and Zephyr bring a bowl of nectar and declare that Jupiter will grant them eternal youth.
Scene 6 Cortege (Bacchanalia), Grand Pas. Procession: The Chariot of Bacchus and Ariadne, accompanied by Bacchante, Satyrs, Fauns, Sylvans.
Apotheosis. Olympus. Jupiter, Juno, Neptune, Vulcan, Minerva, Ceres, Mars, Pluto, Proserpine, Venus.