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

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<>197 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





	7 January 2018, 12:00 - The Tale of Tsar Saltan, of His Son the Renowned and of the Beautiful Swan-Princess (Opera in  4 acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Moscow Stanislavsky theatre 7 January 2018, 12:00 - The Tale of Tsar Saltan, of His Son the Renowned and of the Beautiful Swan-Princess (Opera in 4 acts)
Duration: 2 hours 35 minutes (one intermission)
World premiere: 29 August 1997

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.
Sung In:
Russian
FOR VIEWERS OVER THE AGE OF 6
Music  Nikolay Rimsky-Korsakov
Libretto  Vladimir Belsky
Music Director  Ara Karapetyan
Conductor 
Evgeny Brazhnik
Timur Zangiev
Stage Director  Alexander Titel
Set Designer  Yury Ustinov
Costume Designer  Irina Akimova
Overview

All characters and objects are played by actors, choir and extras – trees, cows, goats, sea monsters, church domes and the “wonder-town” itself. This warm and kindhearted world appears on an empty stage as a day-dream of its authors and the audience. It is a game offered to and enthusiastically taken up by the audience that makes the opera lively, airy, vivid and funny. 

Valeriy Kitchin, "Izvestya"



Сast
Conductor 
Evgeny Brazhnik
Timur Zangiev
Tsar Saltan 
Denis Makarov
Roman Ulybin
Tsaritsa Militrisa 
Irina Vashchenko
Olga Guryakova
Maria Makeeva
Tsarevich Gvidon 
Vladimir Dmitruk
Alexander Nesterenko
Artem Safronov
Kirill Zolochevsky
Tsarevna Swan-Bird 
Evgenia Afanasieva
Lilia Gaisina
Daria Terekhova
Tkachikha 
Larisa Andreeva
Veronika Vyatkina
Natalia Zimina
Anastasia Khoroshilova
Povarikha 
Evgenia Afanasieva
Lilia Gaisina
Olga Lutsiv-Ternovskaya
Valeria Zaitseva
Babarikha 
Ella Feyginova
Irina Chistyakova
Natalia Zimina
Courier 
Andrey Baturkin
Dmitry Zuev
Dmitry Kondratkov
Ilya Pavlov
Petr Sokolov
Skomorokh 
Mikhail Golovushkin
Kirill Kapachinskikh
Felix Kudryavtsev
Vladimir Svistov
Old Grandfather 
Chingis Ayusheev
Sergey Balashov
Evgeny Liberman
First Sailor
Chingis Ayusheev
Evgeny Liberman
Second Sailor
Dmitry Kondratkov
Petr Sokolov
Alexey Shishlyaev
Dmitry Zuev
Third Sailor
Mikhail Golovushkin
Kirill Kapachinskikh
Felix Kudryavtsev
Denis Makarov
Roman Ulybin

 

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.