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





	,  - Giselle (Fantasy ballet in two acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Hermitage Theatre , - Giselle (Fantasy ballet in two acts)
|
Classical ballet
Hermitage Theatre, Saint Petersburg
Duration: 2 hours
World premiere: Theatre de l'Academie Royal de Musique, Paris, 28 June 1841

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.

Presented with one interval.

Music: Adolphe Adam
Libretto: Vernoy de Saint-Georges, Theophile Gautier and Jean Coralli
Choreography: Jean Coralli, Jules Perrot and Marius Petipa
Symphony orchestra.
Conductor
- Stanislav Gorkovenko, People Honored Artist
- Pavel Bubelnikov, People Honored Artist
- Anatoly Rybalko
- Arkady Steinlukht
- Timur Gorkovenko


Running time: 2 hours (ballet with one break)
World premiere: 28 June 1841, Theatre de l'Academie Royal de Musique, Paris
Premiere in St Petersburg: 18 December 1842, Bolshoi (Kamenny) Theatre
Premiere Marius Petipa?s version: 5 February 1884, Bolshoi Theatre, St'Petersburg
Premiere at The Hermitage theatre: 18 May 1996

 

Synopsis

A Summary of the Performance
The ballet is based on an ancient legend about 'villisses' - brides, who die before their weddings. According to legend, villisses arise from their graves at midnight and dance as though they were trying to revive their maidenly dances and games that were so brutally interrupted by death. Any wayfarer who comes upon them while they are dancing are drawn into their wild group dances until they are so exhausted they fall dead at the end of the evening. This procedure is based upon the vindictive feelings, villisses have due to their own untimely deaths.

ACT 1
Opens in a happy, small, quiet village. Plain and simple people live there. Giselle, a young peasant maiden, delights in the sun, blue chirping birds, and above all happiness in a crystal pure love that brightens her life. She loves and believes that she is loved. There is a forester who also loves Giselle and tries to convince her that Albert, her chosen one, is not a simple peasant, but a disguised nobleman who is deceiving her.
This forester steals into Albert's house that he is renting in the village and finds a silver sword with embossed with a coat of arms. Now he is completely convinced that Albert is hiding his noble origin. He takes advantage of an opportunity to expose Albert when a group of/nobles arrive that are hunting nearby. The forester shows them Albert's sword and exposes his deceit. Giselle is shunned by her beloved's craftiness. Her pure and bright world collapses along with her faith, hopes and dreams and she dies of grief.

ACT 2
Shadowy villisses appear in the moonlight between graveyard tombs of the village cemetery. Dressed in their wedding owns, crowned with flowers, villisses dance irresistibly beautifully in the moonlight. Their dancing increases in passion and speed as they feel that the hour given them for dancing is coming to an end. Soon they must descend into their ice-cold graves once again...
The villisses notice the forester. Tortured by pangs of conscience, he has come to Giselle's grave. By order of Mirta, the implacable Queen of Villisses, they spin him in a ghostly dance until he drops lifelessly to the ground.
But Albert too cannot forget Giselle. In the dead of night he also comes to her grave. The villisses immediately surround the youth. The terrible lot of the forester now threatens Albert. But Giselle's ghost appears and her undying, selfless love protects Albert and saves him from the anger of the villisses...
With the first rays of rising sun, the white ghosts - the villisses - disappear. The light ghost of Giselle also vanishes but Gisselle will always live in Albert's memory as his eternal sorrow for his lost love forms a bond stronger than death.

Casts & Credits

Artistic Director: Stanislav Gorkovenko
Artistic Director: Stanislav Gorkovenko