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=1693) 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=1693) 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<>1693 AND tp.id_base=-1 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<>1693 AND tp.id_base=-1 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





	1 July 2020, 20:00 - Modern Dance Ballet of Boris Eifman. "Russian Hamlet" Music: Ludwig van Beethoven, Gustav Mahler - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Russian State Pushkin Academy Drama Theater (Alexandrinsky Theatre) (established 1756) 1 July 2020, 20:00 - Modern Dance Ballet of Boris Eifman. "Russian Hamlet" Music: Ludwig van Beethoven, Gustav Mahler
1July
20:00
2020 | Wednesday
Classical ballet
Russian State Pushkin Academy Drama Theater (Alexandrinsky Theatre) (established 1756), Saint Petersburg
Duration: 1 hours 42 minutes
World premiere: The Alexandrinsky Theater, April 26, 2017

In this ballet Boris Eifman refers to the life story of Prince Paul, later becoming Emperor Paul I of Russia. Here the choreographer does not endeavour to simply stage this well-known plot borrowed from the history of the Romanov’s dynasty – the struggle for power between Empress Catherine the Great and her son – but with psychological insight so characteristic of his style tries to offer a philosophical view and analysis of how political power distorts human relations and brings a human personality to a collapse turning a crown prince into a half-madman.

Prologue

Catherine is humiliated by the drunken debauchery of her husband, Tsar Peter III. Her Court Favorite aids her in staging a coup against the Emperor. Little Prince Paul becomes an involuntary witness to the murder of his father.

Act I

We are in the Russian Royal Court Chambers in the middle of 18th century. Young Prince Paul feels alone among the hypocritical courtiers, in the atmosphere filled with empty chatter of the maids, gossip and intrigue, His mother – the Empress – is inaccessible, always shielded by her Favorite.

Catherine keeps her son away from the throne – for her, power is indivisible.

The Favorite's attempts to accustom the Prince to the depravity of Court life do not bring the expected results, and so the Empress decide that an early marriage must distract him from any thought of inheriting the throne.

Paul is happy with his wife, but she is filled with ambitious plans – she dreams of power and pressures him to fight for the throne of Russia. The Empress discovers the young bride's intentions. Lies and treachery are commonplace in the struggle for power, and Catherine's next scheme destroys Prince's happy life in marriage – his wife becomes Favorite's prey. But even that is not enough: the death of his beloved is the full price paid for her pursuit of the throne.

Paul is scared in the midst of the endless chain of betrayals and crimes.

 

Act II

The events of the past haunt Paul; his fantasies intertwine with reality. The hostile labyrinths of the Royal Palace frighten him and take away the hope of breaking free from the power of the Empress, who still keeps the Heir away from the slate affairs. Paul finds gratification of his ambitions only in the world of toy soldiers, which he loved since childhood, in the neat military ranks governed by order. But, realizing that this is only an illusion of power, he, for the first time, decides to stand up to his mother – and is crushed again.

The Ghost of his father, surrounded by black knights, is calling Paul to revenge. Agonizing memories of the murder ignite the son's rage, which seeks a way out.

The Royal Palace continues inventing new forms of entertainment. Catherine the Great presides over a masked all, which soon turns into an orgy. The favorite spectacle of the Royal Court is a theatre play, but this time the actors perform a scene, in which a wife and her lover kill her husband. The Empress is furious – everything points to her role in the murder of Peter III. She tears the mask off the actor who played the murderous wife, revealing Prince Paul.

The Empress broods. Many sacrifices have been made in the struggle for power, and there is no peace in her soul. The Favorite is also in turmoil. With his caresses, he tries to reclaim his power, but in vain – his rule has ended, and he must leave the political scene…
The Heir is restless dreaming of revenge. In his fantasies Paul takes the coveted revenge – the Favorite dies in the arms of the ghost of Peter III, whom he had murdered.

In the whirlwind of fantastic images, Paul sees the Empress – now it is in her turn, he only has to wave his sword… but he cannot raise his arm to deal о deathly blow to his mother.

One vision is replaced by another – and the Empress is alone again. Her price for the throne is a complete spiritual isolation. She is separated from her son by the wall of hatred, which she herself has erected. The image of the Tsar, whom she had murdered, does not leave her alone, tortures, suffocates her…

Even in his daydreams, ascension to the throne does not bring joy to Paul – he is not destined to attain the glory of his mother. And as soon as his illusions dissipate, Paul understands: he is only a shadow of his dreams, a reflection of his own phantasmagorias…

“Boris Eifman’s ‘Russian Hamlet’ is too much. It is excessive, shamelessly theatrical, torrid, sexy and over the top. It is also very beautiful. It could only have come from Russia and it is not to be missed.”