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-13' AND tmp.date<='2024-05-03' AND tmp.perf_id=255) 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-13' AND '2024-05-03' AND tmp.perf_id=255) 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<>255 AND tp.id_base=171 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<>255 AND tp.id_base=171 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





	13 November 2019, 19:00 - Peter Tchaikovsky "Swan Lake" (ballet in two acts, four scenes) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Bolshoi theatre - Historic Stage 13 November 2019, 19:00 - Peter Tchaikovsky "Swan Lake" (ballet in two acts, four scenes)
13November
19:00
2019 | Wednesday
Classical ballet
Bolshoi theatre - Historic Stage, Moscow
Duration: 2 hours 45 minutes
World premiere: 2 March 2001

There’s a good reason why Swan Lake is so often called the ‘ballet of all ballets’. The combination of pure romanticism, the story about love and deception and Tchaikovsky’s famous ballet music all continue to reach new generations of audiences. Swan Lake was Pyotr Il’yich Tchaikovsky's first score for ballet. Its 1877 premiere was poorly received, but it has since become one of the most loved of all ballets. The twinned role of the radiant White Swan and the scheming, duplicitous Black Swan tests the full range of a ballerina's powers, particularly in the two great pas de deux of Acts II and III. Other highlights include the charming Dance of the Little Swans performed by a moonlit lake and sweeping ballroom waltzes in the splendour of the royal palace.

Scenes in choreography by Marius Petipa, Lev Ivanov, Alexander Gorsky used

Libretto by Yuri Grigorovich after scenario by Vladimir Begichev and Vasily Geltser

Presented with one interval.

 

 

 

Synopsis

Act I

Scene 1
In an old German castle, the birthday of Prince Siegfried is being celebrated; today he comes of age. He is congratulated by his mother, the Princess Mother, friends and courtiers. In a majestic ceremony, Siegfried is made a knight. From this day on a sense of duty, valor will be the guiding principles in his life.

The last toasts are pronounced in his honor, young girls, his contemporaries, try to attract his attention, but Siegfried is overcome by emotions of a different order. He dreams of a pure, ideal love. The festivities draw to an end, the guests depart, leaving the prince alone with his thoughts in the gathering dusk. Night falls. Siegfried is conscious of the presence of a shadow at his side, it is as if some mysterious force is beckoning to him. It is the Evil Genius, or Fate itself, who has come to reveal some perturbing secrets to the Prince. Submitting to the powerful pull of his invisible companion’s presence and full of anxious foreboding, Siegfried succumbs to the ideal world of his dreams…

Scene 2
Lured by the Evil Genius, Siegfried finds himself on the banks of a mysterious lake. In the shimmering patches of moonlight on the water, visions of bewitched swan maidens rise up before him. Siegfried catches sight of Odette, the most beautiful of the maidens. He is spell-bound, deeply struck by her beauty. At long last, he has found his romantic ideal of love. He swears to Odette that he will love her forever and be faithful to her.

Act II

Scene 3
Prospective brides-to-be are arriving at the Princess Mother’s castle. The Prince must chose one of them to be his wife. But Siegfried can think of nothing but Odette and his meeting of her. He dances in an offhand way with the well-born maidens. Not one of them can compare to his ideal.

Suddenly, a mysterious knight arrives at the ball accompanied by a ravishingly beautiful young girl and a suite of black swans. It is the Evil Genius and Odile, Odette’s double. Struck by their resemblance, Siegfried hurries towards Odile. The Evil Genius is putting the Prince’s sentiments to the test. Siegfried is enchanted by the perfidious Odile who manages to disarm him of all his doubts. He announces Odile to be his chosen bride. At this very moment, the throne room is plunged in darkness and a vision of the beautiful Odette appears before the assembled company.
Siegfried realizes that he has become a plaything in the hands of Fate. Hoping to atone for his betrayal, he rushes in despair after the receding image of the white swan.

Scene 4
Night-time. A deep gloom overhangs the lake. Odette brings the tragic news; the Prince has broken his vow of faithfulness to her. Siegfried’s conscience is deeply troubled; he hurries towards Odette begging for her forgiveness. Odette forgives the youth but she is no longer mistress of her own fate.

The Evil Genius summons up a storm which disperses, plays havoc with, the heroes of our tale, making it impossible for them to unite. Made weak by his single combat with Fate, Siegfried tries in vain to hold on to the vanish image. As dawn breaks, he finds himself alone on the empty banks of the lake of his dreams.