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=2613) 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=2613) 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<>2613 AND tp.id_base=2732 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

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<>2613 AND tp.id_base=2732 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





	,  - "Giselle" (Ballet in two acts) Alexei Ratmansky Choreographic version - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Bolshoi theatre - Historic Stage , - "Giselle" (Ballet in two acts) Alexei Ratmansky Choreographic version
|
Classical ballet
Bolshoi theatre - Historic Stage, Moscow

Synopsis

Act I

A small, peaceful village, bathed in sunlight. It is inhabited by simple, artless people. Giselle, a young peasant girl, is re­joicing in the sun, the blue sky, the singing of the birds and, most of all, in the happiness of pure, trusting love which has lit up her life. She is in love and is confident that she is loved. The gamekeeper, who is in love with Giselle, tries in vain to per­suade her that Albrecht, her loved one, is not a peasant at all but a nobleman in disguise and that he is deceiving her.

The gamekeeper manages to steal into the cottage which Albrecht is renting in the village and here he finds a silver sword with a coat of arms on it. Now the gamekeeper knows for sure that Albrechtis concealing his noble origins.

A party of distinguished noblemen, attended by a sumptuous suite, seek rest and refreshment in the village after the hunt. The peasants give their guests a cordial welcome.

Albrecht is embarrassed by this unexpected meeting: he tries to hide the fact he knows them for, in their company, is his betrothed, Bathilde. Meanwhile the gamekeeper shows everyone Albrecht’s sword and, unmasking him, tells them of the latter’s deceit. Giselle is shocked to the core by the perfidy of her loved one. The pure, crystal-clear world of her faith, hopes and dreams has been destroyed.She goes mad and dies.

Act II

Night-time. The ghostly forms of the Wilis, died brides, appear among the graves of the village church yard which is bathed in moonlight. “Dressed inbridal gowns and garlands of flow­ers...The irresistibly beautiful Wilis danced to the light of the moon. And as they felt the time given them for dancing was running out and that they had again toreturn to their icy graves, their dancing became more and more impassioned and ra­pid...” (Heinrich Heine).

The Wilis catch sight of the gamekeeper who, suffering from pangs of conscience, has come to visit Giselle’s grave. At the command of Myrtha, the unrelenting Queen of the Wilis, the Wilis encirclethe gamekeeper and make him dance until he drops lifeless, to the ground.

Albrecht too, is unable to forget Giselle. And, at dead of night, he co­mes to her grave. The Wilis immedi­ately encircle the youth. Albrecht is now threatened by the same horrify­ing fate as the gamekeeper. But the shadow of Giselle now appears and her eternal and self-sacrificing love protects and saves Albrecht from the anger of the Wilis.

The ghostly, white forms of the Wilis vanish with the first rays of the rising sun. And Giselle’s ethereal shadow va­nishes too, but Giselle will always be alive in Albrecht’s memory — theever-present regret for a lost love, a love that is stronger than death.