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





	14 October 2021, 19:30 - Adolphe Adam "Giselle" (fantastic ballet in two acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theater 14 October 2021, 19:30 - Adolphe Adam "Giselle" (fantastic ballet in two acts)
14October
19:30
2021 | Thursday
Classical ballet
Mariinsky Theater, Saint Petersburg
Duration: 2 hours 10 minutes
World premiere: Royal Academy of Music, 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.

The Performance has one intermission

Giselle (French: Giselle ou les Wilis) is a ballet in two acts with a libretto by Jules-Henri Vernoy de Saint-Georges and Theophile Gautier, music by Adolphe Adam, and choreography by Jean Coralli and Jules Perrot. The librettist took his inspiration from a poem by Heinrich Heine. The ballet tells the story of a lovely peasant girl named Giselle who has a passion for dancing, and when she finds out the man she loves is engaged to someone else she dies of a broken heart.

Libretto: Vernoy de Saint-Georges, Theophile Gautier and Jean Coralli
World premiere: 28 June 1841, Theatre de l’Academie Royal de Musique, Paris
Premiere in St Petersburg: 18 December 1842, Bolshoi Theatre
Premiere Marius Petipa’s version: 5 February 1884, Bolshoi Theatre, St’Petersburg

Synopsis

Act I

Count Albert has fallen in love with a peasant girl, Giselle, though she is ignorant of his rank and believes him to be a simple villager staying in a nearby cottage. Giselle has another suitor, Hans, a gamekeeper, who is suspicious and jealous of Albert. Albert arrives to court Giselle. The young lovers´ encounter is interrupted by Hans, who warns Giselle against trusting this unknown admirer, but Giselle does not heed his advice, and Albert drives Hans away. The sound of horns announces the arrival of a hunting party, amongst whom are Albert´s betrothed, Princess Bathilde, and her father. By chance, they are seeking rest and refreshment in the village, and Bathilde, charmed by Giselle´s innocence and beauty, gives her a gold necklace. When the hunting party retires, the peasants begin to celebrate the new vintage, but Hans has meanwhile searched Albert´s cottage and discovered his sword, proof of his identity. At the height of the festivities, he unmasks Albert. However, Giselle does not believe her lover´s deception. Hans then summons the hunters, who bow before their Count, while Bathilde fondly greets the embarrassed young nobleman. The shock unsettles Giselle´s reason; in her madness, she relives her love for Albert and then, heartbroken, dies.

Act II

Hans enters in sorrow. He has come at midnight to visit Giselle´s tomb in the forest, but is frightened away by the approach of the Willis, the ghosts of girls who died on the eve of their wedding; arising at night from their tombs, they will dance any man they encounter to death. Myrtha, the Queen of the Wilis, summons Giselle from her tomb and initiates her into their order, but the Willis disperse at the arrival of Albert and his attendant, who are seeking Giselle´s grave. As the young Count grieves at the tomb, Giselle appears; unbelieving, he tries to catch her, but she eludes his grasp. At last, touched by Albert´s sincere grief and despair, she forgives him. Hans enters, pursued by the Wilis, who drive him to his death in the lake and then surround Albert, whom Myrtha insists must dance to death. He begs Myrtha for mercy, and Giselle pleads for him, but the Queen is adamant and, as Albert dances, Giselle tries to sustain him with her love. Dawn breaks; with the daylight, the Wilis´ power is at an end and they disappear, leaving Albert to bid a last farewell to Giselle.

Characters

Giselle - a young, pretty seamstress with a weak heart who falls in love with Albrecht.

Albrecht - the romantic hero. A prince who is in love with Giselle but is engaged to Bathilde.

Hilarion - the village gamekeeper who is in love with Giselle.

Berthe - Giselle's mother. Wilred - Albrecht's squire.

Bathilde - Albrecht's fiancee. Myrta - the queen of the wilis.

Casts & Credits

Composer: Adolphe Adam
Choreography: Marius Petipa
Choreography: Jean Coralli
Choreography: Jules Perrot
Ballet company: Mariinsky (Kirov) Ballet
Musical Director: Valery Ovsyanikov
Costume Designer: Irina Press
Set Designer: Igor Ivanov
Composer: Adolphe Adam
Choreography: Marius Petipa
Choreography: Jean Coralli
Choreography: Jules Perrot
Ballet company: Mariinsky (Kirov) Ballet
Musical Director: Valery Ovsyanikov
Costume Designer: Irina Press
Set Designer: Igor Ivanov