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=183) 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=183) 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<>183 AND tp.id_base=517 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<>183 AND tp.id_base=517 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





	7 November 2019, 19:00 - Herman Lovenskjold "La Sylphide" (Ballet in two acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Bolshoi theatre - Small Stage 7 November 2019, 19:00 - Herman Lovenskjold "La Sylphide" (Ballet in two acts)
7November
19:00
2019 | Thursday
Classical ballet
Bolshoi theatre - Small Stage, Moscow
Duration: 1 hour 45 minutes
World premiere: 20 February, 2008

August Bournonville’s La Sylphide, set to a commissioned score by Herman Lovenskjold, premiered in Copenhagen in 1836, and has remained in the repertoire of the Royal Danish Ballet to this day. In creating La Sylphide, Bournonville used the Adolph Nourrit libretto which had underpinned Filippo Taglioni’s earlier version of this ballet, with music by Jean Schneitzhoeffer, which had premiered in Paris in 1832. Taglioni’s La Sylphide is often hailed as a landmark work which heralded the Romantic era. The romantic classic La Sylphide is a story of passion and unrequited love featuring an alluring fairy and a diabolical witch.

La Sylphide is the pearl of the romantic repertoire. The Oleg Vinogradov production, for many years a staple of the Bolshoi Theatre repertoire, is in need of renovation. The new production injects this classical ballet with the joie de vivre and beauty which are the hallmarks of the Bournonville style.

Johan Kobborg – one of the most distinguished dancers of his generation. On completing his studies at the Royal Danish Ballet School in 1991, he joined the Company. Having made his debut in La Sylphide, he was promoted to principal soloist. Since 1999, he has been principal dancer with London’s Royal Ballet. He has mounted several ballets by August Bournonville. La Sylphide, in his production, opened the 2005/06 season at Covent Garden. He has often danced in Bolshoi Theatre productions.

 

Synopsis

Act I

A Scottish manor house.
It is the morning of James’s marriage to Effie and he is asleep in his armchair. A winged figure, a Sylphide, is kneeling by his side. She kisses him on his forehead and he wakes up confused. Entranced by the vision of the Sylph, he attempts to capture her, but she escapes him; as she reaches the fireplace, she vanishes up the chimney. Troubled, he wakes his companions but none of them have seen her. Gurn, James’s rival, arrives and learns that James is infatuated with someone other than Effie.

The preparations for the wedding are in full swing. James hardly notices Effie; instead she is wooed by Gurn whom she ignores. James joins in the preparations but gradually realizes that, as Effie dreams more and more of the wedding, his own dreams go far beyond the walls of the manor house. 
An old woman, Madge, has slipped unnoticed into the hall to warm herself by the fire. James, sensing that she is a sinister presence, takes an immediate dislike to her and cannot bear to see her sitting where he last saw the Sylph. He orders her to leave but Effie calms him and persuades him to let Madge tell the fortunes of some of the guests. Madge prophesies that Effie will marry Gurn, and James, furious at this, threatens Madge, who curses him. Effie runs off to dress for the wedding leaving James alone and in turmoil.

The Sylph once again shows herself to James, declares her love for him and tells him that they belong together, Gurn enters and, believing that he may have caught James talking to another woman, attempts to reveal the situation to Effie but fails.

As the wedding festivities begin, the Sylph reappears and, unable to resist her enticements, James follows her into the forest. Effie is left broken-hearted.

Act II

A glade in the forest.
Deep in the forest, shrouded in mist, Madge is planning her revenge. She makes a veil, irresistible to all in a magic cauldron. As the fog lifts, James enters with the Sylph, who shows him her realm. She brings him berries and water but evades his embrace. To lift his spirits she calls on her sisters and the forest fills with sylphs, who dance for James. Try as he might, he is unable to catch the Sylph in his arms.

Effie and James’s companions reach the glade looking for him. Gurn finds James’s hat, but Madge convinces him to say nothing. He proposes to Effie and, encouraged by Madge, she accepts. Everyone leaves to prepare for the wedding of Effie and Gurn.

Meanwhile, James is desperately looking for the Sylph, and Madge convinces him that the veil she has made will enable him to catch her. The Sylphappears and, seeing the veil is totally captivated by it. She allows James to place it around her shoulders and as he does so, he kisses her. His embrace is fatal and the Sylph’s wings fall to the ground. In despair James sees what should have been his own wedding party in the distance. As Madge forces him to see what he has lost, he realizes that in trying to possess the unobtainable he has lost everything.

Casts & Credits

Choreography: August Bournonville
Choreography: Johan Kobborg
Ballet company: Bolshoi Ballet
Conductor: Alexei Bogorad
Ballet Soloist: Anna Nikulina
Designer: Peter Farmer
Lighting Designer: Damir Ismagilov
Musical Director: Pavel Klinichev