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=25) 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=25) 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<>25 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

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





	6 November 2019, 19:30 - Herman von Lovenskjold "La Sylphide" (ballet in two acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theater 6 November 2019, 19:30 - Herman von Lovenskjold "La Sylphide" (ballet in two acts)
6November
19:30
2019 | Wednesday
Classical ballet
Mariinsky Theater, Saint Petersburg
Duration: 1 hour 40 minutes
World premiere: Mariinsky Theatre, St Petersburg, Russia, 01 December 1981

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.

Music: Herman von Lovenskjold
Choreography: August Bournonville (1836)

Libretto: Adolphe Nourrit
Revised version: Elsa Marianne von Rosen (1981)
Set design: Vyacheslav Okunev
Costume design: Irina Press

World premiere: 28 November 1836, Royal Opera Theatre, Copenhagen
Premiere at the Mariinsky (Kirov) Theatre: 1 December 1981, Leningrad

The Performance has one intermission

 SYNOPSIS

 Act I

On the eve of his wedding, James, a young Scotsman, sees a vision of an enchanting, winged sylph. She is an ethereal spirit of the air who has fallen in love with him. James is captivated by the beautiful sylph but, as he tries to touch her, she disappears into thin air. A party of guests and friends arrive with Effie, Jamesґ bride-to-be. James is distracted, still haunted by the memory of the sylph.
Lost in thought, he gazes at the spot where she vanished. In his mind he can still see her and reaches out as though she is still there. It is, however, Old Madge, the village sorceress, whose hideous figure steps out of the shadows instead of the beautiful sylph. Her revolting appearance and ravaged face cast a shadow over the celebrations. Jamesґ initial fear turns to anger and Effie tries to calm him. Old Madge starts to tell Effieґs fortune. She predicts that Effie will marry not James, but his friend Gurn, a Scottish peasant, who is also in love with her. James loses his temper and sends Old Madge away. The party resumes and, in the general dancing and merrymaking, everyone soon forgets the unpleasant scene. At the height of the party, the sylph reappears. She beckons to James and they vanish together. Effie is heartbroken.

Act II
Outside a cave in the forest, Old Madge is busy casting evil spells. She traces a magic circle on the ground and places a cauldron in it, which begins to boil. Old Madge begins conjuring things up from the huge cauldron. Other witches hurry to join her and together they conjure up a magic scarf, which is incredibly beautiful but deadly poisonous. The witches depart.
James and the sylph arrive, very much in love. She shows James her magic kingdom and then flies away. James is left all alone and Old Madge reappears. She asks if he needs any help, and produces the magic scarf. She explains that if he puts the scarf around the sylphґs shoulders, she will never be able to fly again and will be his forever on earth. James seizes the scarf and goes in search of the sylph. However, when he finds her and places the scarf on her shoulders, he is horrified to see that it causes her great pain. In front of his stricken gaze, her wings fall to the ground and then in agony she sinks lifeless at his feet. Mourning sylphs appear and carry their dead friend away, over the treetops and out of sight. The sound of bagpipes and the joyful ringing of bells break the silence in the forest. A bridal procession is glimpsed through the trees: it is a triumphant Gurn leading Effie to the church.

Casts & Credits

Composer: Andrey Petrov
Choreography: August Bournonville
Ballet company: Mariinsky (Kirov) Ballet
Conductor: Boris Gruzin
Dancer: Igor Kolb
Dancer: Yana Selina
Costume Designer: Irina Press
Set Designer: Vyacheslav Okunev