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





	7 August 2019, 19:00 - Pyotr Tchaikovsky "Swan Lake" (ballet in two acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Bolshoi theatre - Historic Stage 7 August 2019, 19:00 - Pyotr Tchaikovsky "Swan Lake" (ballet in two acts)
7August
19:00
2019 | Wednesday
Classical ballet
Bolshoi theatre - Historic Stage, Moscow
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.

ACT I
Scene one
The terrace of castle is filled with joy and merriment - Prince Siegfried is celebrating his coming of age, his courtiers congratulate him while his mischievous jester entertains the assembles guests. The servants announce the arrival of his mother the queen, she presents her son with a crossbow for the hunt. The queen reminds her son that at tomorrow coming of age ball he will have to choose a bride. Night is fast approaching and the guests take leave, Siegfried is finally alone with his thoughts and premonitions of what the future may bring. In the twilight a flock of swans pass over and he rushes to the lake.

Scene two
At the lake in the heart of the forest, the swans having stepped ashore turn into beautiful young girls Siegfried about to draw his crossbow stops fascinated by their beauty. Odette the swan princess is startled by Siegfrieds presence, he assures her no harm will come to her. Odette tells him of her terrible plight. Tells him of her high birth and how she has fallen under the spell of be a swan and only in the hours of darkness to assume her human form. She tells him she is bound for eternity by the spell unless an unblemished youth swears eternal fidelity and marries her. Siegfried realizes his destiny has changed. Day is breaking, the swans are again swimming on the lake, Odette bids a sad farewell, Siegfried is left desolate.

ACT II
Scene three
The coming of age ball commences at the castle. The young noblewoman whom the Queen has chosen as prospective brides are presented to Prince Siegfried, he shows no interest thinking only of Odette. The entertainment and merrymaking continue until a fanfare announces the arrival of more guests. Rothbart disguised as a knight sweeps in with his daughter Odille, Siegfried is dazzled by her beauty and her resemblance to Odette, swears his love and fidelity... Rothbart the sorcerer triumphs in his deception.
Siegfried horrified at what he has done rushes from the ball and into the night.

ACT III
Scene four
At the lakeside Odette tells her fellow swans of Rothbarts devilish trickery. Siegfried fleeing from the ball arrives at the shore begging Odette‘s forgiveness and telling of his undying love for her. Rothbart appears and he and his black swans battle with Siegfried and the forces of good until the light of the dawn breaks and the forces of evil are vanquished. The rising sun gives birth to new life, happiness and love.