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=1389) 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=1389) 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<>1389 AND tp.id_base=1390 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<>1389 AND tp.id_base=1390 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





	20 August 2018, 20:00 - Pyotr Tchaikovsky "Swan Lake" fantasy ballet in three acts (four scenes) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theater 20 August 2018, 20:00 - Pyotr Tchaikovsky "Swan Lake" fantasy ballet in three acts (four scenes)
20August
20:00
2018 | Monday
Classical ballet
Mariinsky Theater, Saint Petersburg
Duration: 3 hours 10 minutes
World premiere: Bolshoi Theatre, Moscow, Russia, 8 March 1950

Swan Lake, the treasure of the Russian Classical Ballet ballet, form the basis of the classical ballet repertoire of the Mariinsky Theater: more than a hundred years ago, it was choreographed by Marius Petipa and is considered to be a hallmark of the Mariinsky Ballet - the Main Ballet Stage of the Russian Empire. This classical masterpiece was performed almost uncountable number of times at the Mariinsky Theatre and in the course of numerous tours.

Music by Pyotr Tchaikovsky
Libretto by Vladimir Begichev and Vasily Geltzer
Choreography by Marius Petipa and Lev Ivanov (1895)
revised choreography and stage direction: Konstantin Sergeyev (1950)

Set design by Igor Ivanov
Costume design by Galina Solovyova

World premiere: 20 February 1877, Bolshoi Theatre, Moscow (choreography by Julius Reisinger)
Premiere in St Petersburg: 15 January 1895, Mariinsky Theatre (choreography by Lev Ivanov and Marius Petipa)
Premiere of Konstantin Sergeyevґs version: 8 March 1950, Kirov Theatre of Opera and Ballet (Mariinsky), Leningrad

The performance has two intervals

“Swan Lake”

It is difficult to understand these days how it could have happened that the first show of the “Lake” in 1877, in Moscow’s Bolshoi, was a flop, and that it took many years for the ballet to achieve its worldwide cult status. The composer, Pyotr Ilych Tchaikovsky, never lived to see the ultimate success of his creation.

The story begins in 1875, when Bolshoi commissions a ballet score from the young but already famous composer. It was not yet customary practice –despite Tchaikovsky fame and previous successes, which included four symphonies, the now famous Piano Concerto and “Eugene Onegin” opera, the Imperial Theatres of the time would normally employ the composers on Imperial payroll, such as Cesare Pugni, Ludwig Minkus, and Riccardo Drigo. Keeping that in mind, Tchaikovsky did not embark on the course of a revolution in the Russian ballet, and studied the classic ballet scores assiduously, planning to produce a score that would be in tune with the established tradition but at the same time would sound new and interesting. The task of composition occupied him from May 1875 to April 1876. The story was a knightly fairy tale, and historians still debate the literary origins –some opt for Heine, some for Musaeus, a German fairy-tale writer, some for Russian folklore fairy tales, some even for Pushkin.

The first show took place on February 20, 1877, and was a flop. The critics reviled the chief choreographer, Wentsel Reisinger, and were short on praise for Polina (Pelageya) Karpakova, the first interpreter of the main female part. The failure of the first show was detrimental for the immediate reputation of the ballet itself, and for quite some time nobody dared to stage it again.

The situation changed after Tchaikovsky’s death. In 1893, Mariinka decided to revive the “Swan Lake”. A new version of the libretto and the music was to be produced by Modest Tchaikovsky, the composer’s brother, Ivan Vsevolzhsky, the director of the Imperial Theatres himself, and by Riccardo Drigo. The latter used the original music as a source material for a completely new score. The choreography was supervised by Marius Petipa and his pupil Lev Ivanov. The tradition claims that while Petipa was the father of the unique choreography of the new ballet, its truly Russian singing character is there thanks to Ivanov. The lake and swan scenes, famous for their perfection, are undoubtedly his alone. It was Ivanov who came up with the idea of enchanted ladies with their criss-crossed arms and heads tilted to one side, which every spectator immediately recognized for birds that sit with their wings folded. The very magical world of the swan lake was created by Ivanov. Petipa’s are the scenes of courtly dances and festivities and their intricate lace of waltzes and various dances – Spanish, Hungarian, Polish. Petipa also created an antipode for Ivanov’s White Queen of Swans –its black twin Odile, and its beautiful black pas-de-deux of the second act.

It was this particular stage version that came to be admired as the pinnacle of Russian ballet. This production, as none other, was the perfect setting for many famous dancers to showcase their art. The Swan Lake is a unique and perfect creation, and despite the changing musical and dancing fashions, the performance of Odette and Odile parts is still considered a touchstone for the mettle of any serious dancer. The White Swan is truly a symbol of Russian Ballet, of its beauty and magnificence.

SYNOPSIS

Act I 
Scene 1 
Prince Siegfried and his friends are celebrating his coming-of-age. The  Queen gives him a  crossbow and reminds him that the  time has come to consider marriage. At the  ball tomorrow he must choose a  bride. Night falls. The  guests depart. Siegfried is tormented by forebodings that are unclear. Seeing a  flock of white swans in the  sky the  Prince sets out for the  lake.

Scene 2
A lake in a  forest glade. On coming ashore the  swans are transformed into girls and Siegfried drops his crossbow, staggered by the  beauty of the  Swan Queen. Odette tells him that the  swan-maidens are under the  power of the  evil sorcerer von Rothbart and only the  power of wholehearted love can undo the  magic spell. Siegfried swears eternal love to Odette.

Act II 
A ball at the  castle. One after another, beauties from different countries appear before the  Prince, but not one of them can grasp his attention. Siegfried’s heart belongs to Odette. The  sounds of a  fanfare announce the  arrival of more guests. Disguised as a  noble knight, von Rothbart enters, and with him is his daughter Odile. Siegfried is struck dumb – this beautiful maiden is exactly like Odette! Odile gives the  Prince no time to come to his senses, she lures and bewitches him, and the  Prince is so attracted that he declares his love for her. Von Rothbart is triumphant. Understanding the  full horror of the  deception of which he has been the  victim, Siegfried rushes to the  lake and to Odette.

Act III 
Night. The  shore of the  lake. Odette is telling her friends about von Rothbart’s villainy and Siegfried’s betrayal. The  Prince appears and begs her forgiveness. Black swans sent by von Rothbart attempt to separate the  lovers, but Siegfried defeats the  sorcerer. The  powers of evil are at an end and the  rays of the  rising sun bring life, love and happiness...