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-23' AND tmp.date<='2024-05-13' AND tmp.perf_id=1404) 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-23' AND '2024-05-13' AND tmp.perf_id=1404) 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<>1404 AND tp.id_base=1407 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<>1404 AND tp.id_base=1407 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





	4 February 2018, 19:00 - Herman von Lovenskjold "La Sylphide" (Ballet in 2 Acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mikhailovsky Theater 4 February 2018, 19:00 - Herman von Lovenskjold "La Sylphide" (Ballet in 2 Acts)
4February
19:00
2018 | Sunday
Classical ballet
Mikhailovsky Theater, Saint Petersburg
Duration: 1 hour 40 minutes
World premiere: The Maly Opera and Ballet Theatre, 29 November 1975

Libretto by Adolphe Nourrit and Filippo Taglioni

Choreography: August Bournonville
Staging: Elsa-Marianne von Rosen
Stage Design: Sergey Solomko
Costumes: Oleg Vinogradov
Revival of the choreography: Mikhail Messerer
Revival of the stage and costume design: Vyacheslav Okunev
Lighting: Alexander Kibitkin
Principal Pianist: Tamara Potapova
Répétiteurs: Tatiana Legat, Svetlana Efremova, Elvira Khabibullina, Kirill Myasnikov, Natalia Tsyplakova, Mikhail Sivakov

Première of the production at the Maly Opera and Ballet Theatre: 29 November 1975
Première of the revival: 12 November 2016 

The ballet, which has maintained the romantic dancing style for many years and became one of biggest theatrical legends of the 19th century, comes to our stage in Danish choreographer August Bournonville’s version. The illusiveness and unattainability of one’s dreams are revealed through the story of James, a young Scotsman. He has promised his heart to a girl from the local village but then comes across an enchanting spirit of the air, the sylph. Having forsaken everything on earth, the young man attempts to get close to this spectral beauty.

SYNOPSIS

James, Effie’s young finance, is sleeping in an armchair by the fireplace. Suddenly there appears a sylph, an airy spirit. She is fluttering around James and wakes him up with a kiss. James wants to catch the sylph, but she vanishes in the air. The young man cannot stop thinking of the fairy girl, he has just seen.

Madge, a witch, has come to the house to foretell the future of the young. She prophesies that James will not marry Effie. James makes the witch to leave the house, which she does, full of wishes to revenge. At the wedding party the sylph appears again, seen to nobody but James. She steals James’s wedding ring and vanishes again. James follows her, leaving Effie alone.

In the magic wood Madge is conjuring spells over the boiling pot. She is holding a scarf. Tired James has come to her: he cannot find the sylph. She comes and leaves again and again. Madge gives James a magic scarf that would help to captivate the sylph. When he finds her again, James puts the scarf around the sylph’s shoulders. The scarf is poisoned: her wings fall off, she is dying. Other sylphs carry her away. James is inconsolable.