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=162) 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=162) 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<>162 AND tp.id_base=1415 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<>162 AND tp.id_base=1415 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





	15 December 2019, 12:00 - The Golden Cockerel (opera (fable in persona) in three acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theatre - Mariinsky II 15 December 2019, 12:00 - The Golden Cockerel (opera (fable in persona) in three acts)
15December
12:00
2019 | Sunday
Opera
Mariinsky Theatre - Mariinsky II, Saint Petersburg
Duration: 3 hours
World premiere: The Sergei Zimin Private Russian Opera, Moscow, 24 September 1909

Music by Nikolai Rimsky-Korsakov
Libretto by Vladimir Belsky after the tale by Alexander Pushkin

Musical Director: Valery Gergiev 
Stage Director and Costume Designer: Anna Matison 
Production Designers: Anna Matison and Sergei Novikov 
Lighting Designer: Alexander Sivayev 
Video Graphics Designer: Kirill Malovichko
Principal Chorus Master: Andrei Petrenko 
Musical Preparation: Larisa Gergieva 
Choreographer: Maxim Petrov

World premiere: 24 September 1909, the Sergei Zimin Private Russian Opera, Moscow
Premiere at the Mariinsky Theatre: 14 February 1919
Premiere of this production: 25 December 2014, Mariinsky-II, St Petersburg

The performance has two intervals

SYNOPSIS

The action unfolds in the Thrice-Tenth Kingdom in fantastical times.

Introduction
The Astrologer appears. He addresses the audience:
Here before you an old tale
Will be brought to life by maskers.
The tale is a lie but includes a hint,
A lesson for good, fine fellows...

The crowd is assembled behind him. In fear the people gather near a tower on top of which a sentry stands. The Astrologer makes a gesture and the scene is transformed into Dodon’s kingdom.

Act I
A “meeting” of the boyars’ council is underway at the palace. The Tsar turns to the boyars for advice on how to protect his kingdom from attack. His eldest son proposes moving the army away from the border and placing it around the capital. The boyars and the Tsar noisily approve this plan. The old voivode Polkan has doubts as to the decision being the proper one. The Tsar’s youngest son proposes dismissing the army altogether and reassembling it should the enemy appear. Dodon is delighted! Polkan, however, rejects this proposal too. The duma council does not know what decision to take. Then the boyars propose divining the future using beans or dregs of kvass.
The Astrologer appears. He gives Dodon a magical Golden Cockerel which will always warn of any danger. The Tsar promises the Astrologer any reward he desires:
Your first desire
I will fulfil as my own.

The Astrologer departs. In line with custom the people assemble near the tower, where the Golden Cockerel now stands instead of the sentry. Pacified, Dodon goes to bed. The Golden Cockerel sends Dodon a vision in his peaceful sleep – a vision of an enchanting woman. As soon as the Tsar has fallen in love with this vision the Cockerel cries out “Take care, be on guard!” Much ado and fuss. The Tsar equips his forces, headed by his sons, and himself goes to sleep. His enchanting vision comes back once more. But the Cockerel again warns him of danger. Dodon, assembling an army of old men and invalids, sets out for battle together with Polkan.

Act II
Night. At the bottom of a deep ravine into which Dodon’s army has descended the Tsar is appalled to see his sons are dead – they have stabbed one another with their swords. Day dawns, and a brightly coloured tent appears before Dodon. A beautiful woman emerges from the tent; it is the Queen of Shemakha, whose song greets the rising sun. Dodon is captivated by her beauty and singing. With cunning tricks and deceit, the crafty beauty flatters Dodon and he proposes marriage to the Queen. She accepts. Changing her clothes and dressing Dodon in oriental garb (he is now as humble as a slave!), together with the remains of Dodon’s troops and her own retinue comprising various freaks, the Queen sets out for the capital.

Act III
Life in the capital is unsettled. The Cockerel has fallen strangely quiet and clouds have formed. All are gripped by panic. Suddenly the Golden Cockerel is on its guard – Dodon approaches. Before the stunned people a procession of freaks and monsters passes by – the retinue of the Queen of Shemakha. And there she is herself with Dodon, whose people barely recognise him...
The Astrologer appears. He reminds the Tsar of the latter’s promise and asks him for the Queen of Shemakha. Dodon attempts to make the elderly Astrologer see reason, but the latter insists on his rights. Enraged, Dodon strikes his forehead with a staff and the Astrologer drops to the ground. To the gloating laughter of the Queen, the Cockerel pecks the Tsar’s forehead. Thunder peals. Dodon’s entire kingdom vanishes in flames and clouds of smoke.

Conclusion
Once the smoke is dispelled the same tower, the confused populace and a fallen crown can be seen.
The Astrologer is still alive – he will never die. And now he finishes the tale he began earlier:
That’s how the story has ended...
But the bloody denouement,
However onerous it may be,
Should not cause you to worry.

And behind his back we see the people crowded around the tower. But at the top of the tower there is no sentry, no Cockerel and no Tsar...

Casts & Credits

Conductor: Zaurbek Gugkaev
Bass-baritone: Denis Begansky
Mezzo soprano: Elena Vitman
Soprano: Anna Shulgina
Musical Director: Maestro Valery Gergiev
Musical Preparation: Larisa Gergieva
Principal Chorus Master: Andrei Petrenko
Conductor: Zaurbek Gugkaev
Bass-baritone: Denis Begansky
Mezzo soprano: Elena Vitman
Soprano: Anna Shulgina
Musical Director: Maestro Valery Gergiev
Musical Preparation: Larisa Gergieva
Principal Chorus Master: Andrei Petrenko