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=19) 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=19) 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<>19 AND tp.id_base=444 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<>19 AND tp.id_base=444 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





	19 August 2022, 19:00 - Adolphe Adam "Giselle (Les Wilis)" (Ballet in 2 Acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mikhailovsky Theater 19 August 2022, 19:00 - Adolphe Adam "Giselle (Les Wilis)" (Ballet in 2 Acts)
19August
19:00
2022 | Friday
Classical ballet
Mikhailovsky Theater, Saint Petersburg
Duration: 2 hours 15 minutes
World premiere: Mikhailovsky Theater, 3 November 2007

The epitome of Romantic ballet, Giselle is a poignant tale of unrequited love, remorse, and forgiveness. The role of Giselle, often described as the Hamlet of the ballet world, requires an exquisite stylist with daring dramatic and technical skills. Giselle (by Marius Petipa) is one of the world's favorite romantic ballets, and tells the story of a beautiful village girl who falls in love with a powerful Count, who is disguises himself as a fellow villager. When Giselle learns of his deception and that their love will never be, her world falls apart and she descends into madness.

Libretto by Jules-Henri Vernoy de Saint Georges, Théophile Gautier, and Jean Coralli
Choreography by Jules Perrot, Jean Coralli, and Marius Petipa

Ballet Master: Nikita Dolgushin
Stage and Costume Design: Vyacheslav Okunev
Lighting Designer: Mikhail Mekler
Répétiteurs: Zhanna Ayupova, Evgenia Kostyleva, Yulia Makhalina, Evgeny Popov, Svetlana Efremova, Tatiana Legat, Elvira Khabibullina, Anna Razenko, Natalia Tsyplakova, Mikhail Sivakov 

 

The stage life of Giselle hasn’t been an easy one. After its premiere of 1841 featuring Carlotta Grisi and Lucien Petipa, the ballet was performed in France till 1863, when it disappeared from the repertoire. The ballet has been staged in St.Petersburg since 1842. At the beginning of the 20th century during the ground-breaking Diaghilev’s Russian Seasons, the French saw their national ballet, faithfully nurtured in Russia.
The Mikhailovsky Theatre’s the 2008 production of Giselle by Nikita Dolgushin, a specialist in historical works, managed to amaze both the public and the critics. Dolgushin, a noble Albrecht in his time as a dancer, inspired the creation of the ballet and delicately united dance and mime. He revealed the essence of the romantic ballet, the story of Giselle is told in the language of ballet classicism. Together with Viacheslav Okunev, who designed the epitome of romantic settings, Dolgushin made a production that was described by a British critic ‘an exemplary Giselle’.

SYNOPSIS

Act I

A young Count is in love with a peasant girl, Giselle. As he is disguised in peasant clothes Giselle takes him for a young man fr om a nearby village. A gamekeeper is also in love with Giselle. He tries to prove that Giselle’s lover is not the man he pretends to be. But Giselle will not listen.
The gamekeeper intrudes into the cottage wh ere the young Count changed his clothes and finds the Count’s sword. The sound of horns signifies that the hunters are coming. The Count’s betrothed and her father are among them. The noble lady is charmed by Giselle and gives the pretty peasant her necklace.
At the height of the peasants’ feast the gamekeeper appears. He accuses the Count of deceit and shows the Count’s sword as a proof. Giselle doesn’t believe it. The gamekeeper blows the horn and the Count’s betrothed greets the abashed Count. Giselle shocked by her lover’s deceit goes mad and dies.

Act II

Midnight. The gamekeeper comes to visit Giselle’s tomb. The Wilis are arising from their tombs and the young man runs to escape them. The Wilis force every man who comes to the cemetery at night to dance to his death.
The Queen of the Wilis summons the ghost of Giselle from her tomb: she’s one of the Wilis now. The Count comes to visit Giselle’s tomb. Seeing his sorrow and regret Giselle forgives him.

The Wilis are chasing the gamekeeper and having caught him push the young man into the lake. The Count is going to die too. In vain Giselle begs the Wilis to let him go: the Wilis are implacable. But the chime is heard: it’s daybreak. The Wilis are loosing their power as dawn breaks. The Count is forgiven and rescued. Giselle vanishes into the morning haze.

Casts & Credits

Composer: Adolphe Adam
Choreography: Marius Petipa
Choreography: Jean Coralli
Choreography: Jules Perrot
Choreography: Nikita Dolgushin
Ballet company: Mikhailovsky Ballet
Set Designer: Vyacheslav Okunev
Composer: Adolphe Adam
Choreography: Marius Petipa
Choreography: Jean Coralli
Choreography: Jules Perrot
Choreography: Nikita Dolgushin
Ballet company: Mikhailovsky Ballet
Set Designer: Vyacheslav Okunev