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=9) 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=9) 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<>9 AND tp.id_base=535 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<>9 AND tp.id_base=535 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





	18 September 2022, 18:00 - Peter Tchaikovsky "The Queen of Spades" (Opera in three acts, seven scenes) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mikhailovsky Theater 18 September 2022, 18:00 - Peter Tchaikovsky "The Queen of Spades" (Opera in three acts, seven scenes)
18September
18:00
2022 | Sunday
Duration: 3 hours 30 minutes
World premiere: Mikhailovsky Theater, 23 May 1982

One of the most popular operas by Pyotr Tchaikovsky, The Queen of Spades, was composed in a very short period of time and became a unique masterpiece reflecting its author’s preoccupation. Tchaikovsky accepted the commission to write an opera based on the short story by Alexander Pushkin in 1889. Herman, a poor officer, is desperately in love with Lisa, a heiress to the rich old Countess. One day he learns that the Countess knows the secret of the three winning cards. Herman becomes obsessed with obtaining the secret. He tries to find out the secret, however, the old lady dies of fright. The loss of hope drives Herman mad. Soon the ghost of the Countess appears and names the secret three cards: Three, Seven, Ace. The madman rushes to the casino. Passion overcomes reason: “What’s our life? A game!” The only gain of the miserable lover is death.

Performed in Russian

Libretto by Modest Tchaikovsky after the novel by Alexander Pushkin 

Stage Director: Stanislav Gaudasinsky
Stage Designer: Semyon Pastukh
Costume Designer: Galina Solovyova
Lighting Designer: Mikhail Mekler
Choreographer: Nikita Dolgushin
Principal Pianist: Natalia Dudik 

The Mikhailovsky Chorus
Artistic Director and Principal Conductor of the Chorus: Vladimir Stolpovskikh
Chorus Masters: Alexey Dmitriev, Sergey Tsyplenkov

Children’s Choir of St Petersburg TV and Radio
Principal Chorus Master: Igor Gribkov 

Director: Margarita Kunitsyna-Tankevich
Stage Manager: Olga Kokh

This production has graced our stage for more than three decades. The aesthetics of this production, closely tied to operatic tradition, have become a symbol of the esteem in which the classics are held. The sights of St. Petersburg and magnificent palace interiors form the backdrop against which Pushkin’s mystical tale unfolds. Symbols of the real world, such as the latticework of the Summer Garden, form a natural setting for the hero’s wild fantasies, within which the hero falls completely beneath the sway of his feverish senses. Caught up in a succession of supernatural events, he loses all touch with time. Tchaikovsky’s inspired music captures the inevitability of his imminent destruction.

SYNOPSIS

Act I

Scene 1
Summer gardens in St Petersburg. It’s early spring. People are strolling in the alleys. Everybody is happy with the first sunny day. Herman is gloomy. He is desperately in love but his beloved one is a noble lady and she can’t get married to a poor officer. Prince Yeletsky announces his soon wedding: he’s marrying the granddaughter of the old countess. He introduces Lisa to his friends. Herman is in despair: prince’s fiancée is the object of his passion. Tomsky tells a fantastic story of the countess who learned the secret of three winning cards. Herman’s friends mockingly suggest that he find out the countess’s secret at cards. Thunderstorm begins... Herman swears that while he is alive, he will never let the prince marry his beloved girl.

Scene 2
Lisa’s bedroom. Her friends celebrate Lisa’s engagement. At last Lisa is alone. All her thoughts are about a mysterious stranger. Suddenly Herman appears. Lisa listens to his confessions passionately. Sudden appearance of the countess interrupts the date. Herman remembers the Tomsky’s story. Now Herman wants to live, to know the card secret from the countess, to be happy...

Act II

Scene 3
A rich nobleman is throwing a ball. All the evening Herman’s friends scoff at him, asking him whether he will be the third to learn the secret of the three cards and if he will marry his beloved. After the pastoral, Herman sees the countess. When Lisa gives him the keys to her bedroom which connects to the countess’s Herman thinks it is an omen. Tonight he will learn the secret of the three cards, and knowing it, will win Lisa’s hand.

Scene 4
Countess’s bedroom. Herman looks at the portrait of the young countess obsessively. Hearing the steps he hides. The countess enters escorted by her toadeaters. The countess looks at her portrait and recalls her past days. She falls asleep in the armchair. Herman reveals himself begging her to reveal the secret of the three cards. The countess who has grown dumb with fright says nothing. Herman frightens her with a gun — and the frightened old woman falls dead. All his hopes are lost all, he goes nearly mad.

Act III

Scene 5
Barracks at night. Herman rereads Lisa’s request about a meeting. His imagination draws him pictures of the countess’s death and funeral. He sees her ghost and she tells him the secret of the three cards: «The three, the seven, the ace!»

Scene 6
Lisa is waiting for Herman at the embankment. It’s midnight already. Herman appears. Lisa is terrified to hear all his mad ideas, she tries to invoke his mind — all in vain. Possessed with the idea of using the secret of the three cards, Herman pushes Lisa away and leaves for the gambling house. Lisa decides to commit suicide.

Scene 7
The players are gambling in the casino. Suddenly Herman enters and to everybody’s surprise wins two large stakes betting on the three and the seven. Drunk with his luck Herman bets all his money on the ace. But instead of the expected ace he sees the queen of spades. He can define the features of the dead countess on the card; her smile seems to be mocking at him. Growing mad Herman decides to commit suicide. He sees a ghost of Lisa and dies saying her name.

Casts & Credits

Opera company: Mikhailovsky Opera
Principal Chorus Master: Alexandr Chernov
Opera company: Mikhailovsky Opera
Principal Chorus Master: Alexandr Chernov