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





	7 April 2019, 12:00 - Nikolay Andreyevich Rimsky-Korsakov "The Tale of Tsar Saltan, of His Son the Renowned and of the Beautiful Swan-Princess" (opera in a prologue and four acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theater 7 April 2019, 12:00 - Nikolay Andreyevich Rimsky-Korsakov "The Tale of Tsar Saltan, of His Son the Renowned and of the Beautiful Swan-Princess" (opera in a prologue and four acts)
Duration: 3 hours
World premiere: Mariinsky Theatre, St Petersburg, 8 March 2005

One of the most sunny pieces of the world opera literature. Full of easy humor, it recreates charming features of a cheerful fairy tale by Pushkin, whose plot underlies the libretto. However, behind the unpretentiousness of the plot there is significant sense reflecting Russian political reality of the end of the 19th century. Intrigues of sisters of the young tsarina result in that she is sent in exile to a faraway island with her son Gwidon, but there, with the help Swan Princesses, the rescued Gwidon becomes the governor of the fine magic city where they are found by tsar Saltan who did not know about the plot. He is so overjoyed that he forgives the sisters of the tsarina.

Libretto by Vladimir Belsky after the folktale in verse of the same name by Alexander Pushkin

World Premiere: 21 October (3 November) 1900, Solodovnikov Theatre (Savva Mamontov’s Private Russian Opera), Moscow
Premiere at the Mariinsky Theatre: 2 March 1915
Premiere of this production: 8 March 2005, Mariinsky Theatre, St Petersburg

The Tale of Tsar Saltan (Skazka o care Saltane in transliteration) is an opera in four acts (six tableaux) with a prologue, by Nikolai Rimsky-Korsakov to a Russian libretto by Vladimir Ivanovich Belsky, based on the poem of the same name by Aleksandr Pushkin. The full title of both the opera and the poem in English is The Tale of Tsar Saltan, of his Son the Renowned and Mighty Bogatyr Prince Gvidon Saltanovich, and of the Beautiful Princess-Swan.

Synopsis

Prologue
On a wintry evening three sisters are sitting at spinning wheels. As Tsar Saltan overhears from outside the door, the oldest sister boasts that, if she were Tsaritsa, she would prepare a sumptuous feast; the middle sister would weave a grand linen; the youngest promises to bear a bogatyr as son for the Tsar. Saltan enters, chooses the third sister to be his bride, and takes her away. The old woman Babarikha devises a revenge for the two jealous older sisters: when the Tsar is away at war, a message will be sent to him that the child born to his Tsaritsa is not human, but a monster.

Act I

The Tsar has gone off to war. In his palace in Tmutarakan, the Tsaritsa has given birth to a son. She is despondent: there is no reply from her husband to the news of the birth of their child. Her sisters, who (with Babarikha) are now part of the court, the older sister as Cook, and the middle sister as Weaver, try to entertain her, as does the skomorokh and the Old Grandfather. But all this is to no avail. The young Tsarevich, who has been lulled to sleep during this scene, awakens and runs about, accompanied by his nurses, and the people wish God’s blessings upon him. Then a messenger stumbles in (he has been waylaid with drink by Babarikha). His message from the Tsar is read by the scribes: the Tsaritsa and her progeny must be placed in a barrel and thrown into the sea. Reluctantly the people carry out the Tsar’s command.

Act II

The Tsaritsa and her son Gvidon have landed on the island of Buyan and broken out of the barrel that they were trapped in. Gvidon has grown remarkably rapidly into a young man. In the course of searching for sustinence, Gvidon rescues a swan from being killed by a kite. The Swan-Bird in gratitude causes the city of Ledenets to arise magically on the island, and Gvidon is hailed by its inhabitants as its Prince.

Act III

Tableau 1
By the shore of Buyan, the merchant ships have left, and Gvidon laments his being separated from his father. The Swan-Bird finds a way to help him: she changes him into a bumblebee so that he can fly over the sea as a stowaway on Saltan’s ship to visit him incognito in Tmutarakan.

Tableau 2
The sailors arrive at Tmukarakan from their visit to Buyan. The sailors tell of the wonders of Gvidon’s island (the magically appearing city itself, a magic squirrel, and the thirty-three bogatyrs from the sea), but the two older sisters try to stop them from creating any interest in Saltan’s visiting the island; Gvidon stings each of the sisters in the brow. Babarikha then tries to trump the sailors by speaking of a fabulous Princess on the sea, to which Gvidon stings her in the eye and blinds her. Saltan decides to visit the island, but, in view of the havoc caused by the bumblebee, forbids that breed of insect from ever entering the palace again.

Act IV.

Tableau 1.
Gvidon, again by the seashore of Buyan, longs for a bride. The Swan-Bird appears. Gvidon tells her of the Princess that he heard about at Tmutarakan, and the Swan-Bird transforms into that very Princess. His mother and a chorus of maidens enter and bless the prospect of their wedding.

Tableau 2
Gvidon, with his mother aside, awaits the arrival of Saltan. When the ship arrives with Saltan and his retinue, the Tsar greets Gvidon (whom he does not yet know as his son), and expresses regret for his rash treatment of his wife. Although Gvidon tries to cheer him up with the three wonders, only the presence of Militrisa can assuage Saltan’s guilt. The Princess-Swan appears and reveals the Tsar’s long-lost wife. The older sisters beg forgiveness, which in his happiness Saltan grants; and everyone then joins in a rollicking celebration of the upcoming wedding of Gvidon and the Princess-Swan.

Casts & Credits

Costume Designer: Vladimir Firer
Lighting Designer: Vladimir Lukasevich
Musical Director: Maestro Valery Gergiev
Musical Preparation: Larisa Gergieva
Principal Chorus Master: Andrei Petrenko
Set Designer: Vladimir Firer
Stage Director: Alexander Petrov
Stage Director: Andrei Petrov
Costume Designer: Vladimir Firer
Lighting Designer: Vladimir Lukasevich
Musical Director: Maestro Valery Gergiev
Musical Preparation: Larisa Gergieva
Principal Chorus Master: Andrei Petrenko
Set Designer: Vladimir Firer
Stage Director: Alexander Petrov
Stage Director: Andrei Petrov