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=922) 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=922) 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<>922 AND tp.id_base=936 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<>922 AND tp.id_base=936 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





	15 June 2019, 19:30 - Leo Delibes "Sylvia" ballet in three acts. Choreography by Frederick Ashton - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theater 15 June 2019, 19:30 - Leo Delibes "Sylvia" ballet in three acts. Choreography by Frederick Ashton
15June
19:30
2019 | Saturday
Classical ballet
Mariinsky Theater, Saint Petersburg
Duration: 2 hours 30 minutes
World premiere: Mariinsky Theatre, St Petersburg, Russia, April 3, 2014

Music by Leo Delibes
Choreography by Frederick Ashton

Choreography revived by Christopher Newton
Coaches for the Mariinsky Theatre production: Anna Trevienand Susan Jones
Set and Costume Design: Christopher and Robin Ironside
Additional Designs: Peter Farmer
Original Lighting: Mark Jonathan

World premiere of the ballet Sylvia (choreography by Louis Meranta) - June 14, 1876, Paris Opera, Paris
The premiere of the ballet in the choreography of Frederick Ashton - September 3, 1952, the Royal Opera House, London
Premiere at the Mariinsky Theater (choreography by Frederic Ashton) - April 3, 2014

Sylvia, originally Sylvia, ou La nymphe de Diane, is a full-length ballet in two or three acts, first choreographed by Louis Mйrante to music by Lйo Delibes in 1876. Sylvia is a typical classical ballet in many respects, yet it has many interesting features which make it unique. Sylvia is notable for its mythological Arcadian setting, creative choreographies, expansive sets and, above all, its remarkable score.
The ballet's origins are in Tasso's 1573 poem Aminta, which provides the basic plot of Delibes' work. Jules Barbier and Baron de Reinach[1] adapted this for the Paris Opera. The piano arrangement was composed in 1876 and the orchestral suite was done in 1880.
When Sylvia premiиred on Wednesday, June 14, 1876, at the Palais Garnier, it went largely unnoticed. In fact, the first seven productions of Sylvia were not commercially successful. It was the 1952 revival, choreographed by Sir Frederick Ashton, that popularized the ballet. Ashton's success set the stage for the 1997, 2004, 2005 and 2009 productions, all of which were based on his 1952 choreography.

Synopsis

Act I: A Sacred Woo

The ballet begins with a scene of worship as creatures of the forest dance before Eros. Aminta, a lowly shepherd, stumbles in on them, disrupting their ritual. Now Sylvia, the object of Aminta's desire, arrives on the scene with her posse of hunters to mock the god of love. Aminta attempts to conceal himself, but Sylvia eventually discovers her stalker and, inflamed, turns her bow towards Eros. Aminta protects the deity and is himself wounded. Eros in turn shoots Sylvia. She is hit, and though not badly wounded, the injury is enough to drive her offstage.
A hunter, Orion, is revealed to also have been watching Sylvia, when he is seen celebrating the unconscious Aminta. Orion conceals himself again as Sylvia returns; this time she is sympathetic towards Aminta. As the huntress laments over her victim, she is kidnapped by Orion and carried off. Peasants grieve over Aminta's figure until a cloaked Eros revives the shepherd. Eros reveals his true identity and informs Aminta of Orion's actions.

Act II: Orion's Island Cave

Captive in Orion's island hideout, Sylvia is tempted by him with jewels and wine to no avail. Sylvia now grieves over Aminta, cherishing the arrow pulled from her breast nostalgically. When Orion steals it from her, Sylvia gets her captor drunk until he is unconscious, whereby she retrieves her arrow and appeals to Eros for help. Sylvia's invocations are not in vain, for Eros quickly arrives and shows his summoner a vision of Aminta waiting for her. The duo depart for the temple of Diana, where Sylvia's love awaits.

Act III: The Sea Coast near the Temple of Diana

Aminta arrives at the temple of Diana to find a bacchanal but no Sylvia, who will soon arrive with Eros. After a few moments of mirth at the reunion, Orion shows up, seeking Sylvia. He and Aminta fight; Sylvia barricades herself in Diana's shrine and Orion attempts to follow. The goddess of the hunt, outraged at this act, smites Orion and denies Aminta and Sylvia congress. Compassionate Eros gives Diana a vision. The goddess reminisces over her own young love of Endymion, also a shepherd. Diana has a change of heart and repeals her decree. Aminta and Sylvia come together under the deities' good will.

Casts & Credits

Composer: Leo Delibes
Choreography: Frederick Ashton
Ballet company: Mariinsky (Kirov) Ballet
Conductor: Alexei Repnikov
Lighting Designer: Mark Jonathan