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=37) 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=37) 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<>37 AND tp.id_base=501 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<>37 AND tp.id_base=501 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





	22 March 2020, 19:00 - Alexander Borodin. Prince Igor (opera in three acts with a prologue) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theater 22 March 2020, 19:00 - Alexander Borodin. Prince Igor (opera in three acts with a prologue)
22March
19:00
2020 | Sunday
Duration: 3 hours 35 minutes
World premiere: Mariinsky Theatre, St Petersburg, Russia, 23 October 1890

The libretto of the opera is based on the jewel of ancient Russian literature - The Tale of Igor's Campaign. Text and music were being written for 18 years but were finished by Nikolay Rimsky-Korsakov and Alexander Glazunov after the composer’s death. The opera also includes famous The Polovetsian Dances – a bright vocal-choreographic scene that has become a legend. For the 1890 premiere of Prince Igor the spirit of the wild dances was conveyed by choreographer Leo Ivanov, a co-author of the famous ballet Swan Lake.

Libretto by the composer based on Old Russian epos The Tale of Igor`s Raid
Performed in Russian

Stage Director: Yevgeny Sokovnin (1954)
Set Designers: Nina Tikhonova, Nikolai Melnikov (1954)
Polovtsian Dances choreography by Michel Fokine (1909)

World Premiere: 23 October (4 November) 1890, Mariinsky Theatre, St Petersburg;
Revival of the 1954 production: 8 December 2001, Mariinsky Theatre, St Petersburg

Prince Igor (Knaz’ Igor) is an opera in four acts with a prologue by Alexander Borodin. The libretto, adapted by the composer from the East Slavic epic The Tale of Igor’s Campaign, centers on a 12th-century Russian prince (Igor Svyatoslavich) and his campaigns against the invading Polovtsian tribes. The opera was first performed in St.Petersburg on November 4, 1890. In the USA the opera was first produced at the Metropolitan Opera House, New York, December 30, 1915.

Borodin left the opera incomplete at his death in 1887. Composition and orchestration was completed posthumously by Nikolai Rimsky-Korsakov and Alexander Glazunov. According to the printed score, the opera was completed as follows: Rimsky-Korsakov orchestrated the previously unorchestrated passages from the Prologue, Acts 1, 2, and 4, and the "Polovetsian March" which opens Act 3. Glazunov used what existing material was left to compose and orchestrate the rest of the third act; the often-repeated legend is that he also reconstructed and orchestrated the overture from memory after hearing the composer play it at the piano several times. (In his memoirs, Shostakovich quotes Glazunov as admitting to, in essence, writing the overture based on Borodin’s themes; this explanation appears to make more sense, because of the rather complex polyphonic nature of the overture, which would have made it virtually impossible to adequately render on the piano.)

Both the Overture to Prince Igor and the "Polovetsian Dances" (from Act II) are well-known concert standards. Together with the "Polovetsian March", they form the so-called "suite" from the opera.

Synopsis

ACT I

A Square in the Ancient Russian City of Putivl
Prince Igor, together with his son Vladimir and his army of warriors, is getting ready for a campaign against the nomadic Polovtsians who are launching devastating attacks on Russia virginal lands. The people greet Igor and the warriors and wish them victory.
Suddenly it gets dark - a solar eclipse begins. The people, the princes and the boyars regard this as an ill omen, an inauspicious sign, and advise Igor to put off the campaign. The Prince's wife Yaroslavna also implores him to stay at home. But Prince Igor is unbending. He is certain that his cause is just - he will defend Russia.
The prince bids farewell to his wife and tenderly consoles her, giving assurances that she need not worry about him and should await his victorious return. He entrusts Yaroslavna to the care of her brother, Prince Vladimir Galitsky, whom he appoints as his deputy in Putivl. Unnoticed, two warriors, Skula and Yeroshka, leave Igor; it is their intention to join the service of Prince Galitsky.
After being blessed, Igor and his detachment set off for the campaign.

OVERTURE

Evening in the Polovtsian Camp
The Polovtsian maidens are trying to amuse Konchakovna, the daughter of Khan Konchak, with songs and dances. All her thoughts are focussed on the captive youth - Prince Vladimir.
Konchakovna impatiently waits for a moment when she can see him.
Igor's son Vladimir appears, and is charmed by Konchakovna.
But Prince Igor does not wish even to hear of Vladimir's marriage. Konchak, however, agrees to marry his daughter to the Russian prince.
Prince Igor cannot sleep. He is oppressed by gloomy thoughts. It is not easy to overcome the shame of defeat and captivity. It is hard to accept the thought of his native land being enslaved. Igor passionately yearns for freedom in order to liberate Russia. He tenderly recalls his beloved wife Yaroslavna.
Suddenly Ovlur, a baptized Polovtsian, comes to him. He offers Igor his help to escape from captivity. But the latter refuses - a Russian prince ought not to flee.
The Polovtsian Khan Konchak bestows high honours on Igor as his honoured guest. He promises to free him if he agrees never to raise his sword against the Polovtsians again. But Igor rejects Konchak&rsquo;s proposal and does not hide his intentions: once free he will assemble his forces and make war against the Polovtsians once more.
The pride and valour of the Russian prince delight Konchak.
On the Khan's orders, the captive women and warriors entertain Igor to dispel his gloomy thoughts with dances glorifying the mighty Konchak.

ACT II

The Polovtsian Camp
Khan Gzak, sent on a campaign by Konchak, returns with captive Russians and rich plunder. Knowing of the disaster that has befallen his native Putivl, Prince Igor regrets his deeds and calls on the Russian princes to unite together. To save their native land, Igor conceives a plan to escape. Konchakovna raises the alarm. But Igor and Ovlur manage to take cover. The wrathful Polovtsians demand the death of his son Vladimir, but Konchak not only grants him pardon, but decides that Konchakovna may marry Vladimir into the bargain.

The City Walls of Putivl
In the morning, Yaroslavna, having abandoned all hopes of Igor&rsquo;s return, mourns his loss. Addressing the wind, the sun and the River Dnepr, she awaits their answer: where is Igor and what has happened to him? Yaroslavna's lament is repeated by the mournful song of the villagers who lament the destruction and scorching of the land.

The Court of Prince Vladimir Galitsky
Prince Galitsky is feasting at a lavishly laid table, with his servants led by Skula and Yeroshka. His power is limited - he would like to send Yaroslavna to a nunnery and become the Prince of Putivl by dethroning Prince Igor. Agitated maidens run into the courtyard. They beg Prince Galitsky to liberate their girlfriend who was taken by warriors into a chamber for amusement. But the prince drives the maidens out to the amusement of the drunken crowd.The drinking-bout reaches its culmination. Skula and Yeroshka, bribed by Prince Galitsky, together with the warriors whose boldness grows from the revelry incite the people to mutiny: "We shall depose Igor and elevate Vladimir to the throne! What do we have to fear?"

A Chamber in Yaroslavna's Terem Palace. Alarm
The Princess feels uneasy. Troublesome dreams and gloomy presentiments remain with her day and night. She has had no news from the Prince for a long time. And she sees the strife and plotting around her by the princes, even her own brother Vladimir has conceived some evil deed, hoping to dethrone Prince Igor and become the Prince of Putivl.
The sudden arrival of the girls whom Prince Galitsky has driven out from the court distracts Yaroslavna from her sad thoughts. The girls implore the Princess to defend them from their offender. Yaroslavna accuses her brother of treason and treachery, but she cannot reason with him. Called on by the Princess to answer, Prince Galitsky conducts himself impertinently, claiming power in Putivl.
The boyars arrive with gloomy news: Igor's armed force has been defeated and the Prince himself imprisoned with his son; the Russian princes wallow in dissent, while hordes of Polovtsians march on Russia. Disturbed by what she has heard, Yaroslavna wishes to interrogate the messengers herself. Meanwhile, Prince Galitsky and his servants seize the moment and stir up a rebellion. The alarm bell is heard, heralding danger - the Polovtsians are approaching Putivl. The boyars and the people are filled with resolve to defend their lands.

Casts & Credits

Composer: Andrey Petrov
Choreography: Michel Fokine
Conductor: Timur Zangiev
Baritone: Edem Umerov
Mezzo soprano: Olga Borodina
Director: Irkin Gabitov
Lighting Designer: Vladimir Lukasevich
Musical Director: Maestro Valery Gergiev
Musical Preparation: Irina Soboleva
Principal Chorus Master: Andrei Petrenko
Revival Designer: Vyacheslav Okunev
Revival Stage Director: Irkin Gabitov
Set Designer: Vyacheslav Okunev
Composer: Andrey Petrov
Choreography: Michel Fokine
Conductor: Timur Zangiev
Baritone: Edem Umerov
Mezzo soprano: Olga Borodina
Director: Irkin Gabitov
Lighting Designer: Vladimir Lukasevich
Musical Director: Maestro Valery Gergiev
Musical Preparation: Irina Soboleva
Principal Chorus Master: Andrei Petrenko
Revival Designer: Vyacheslav Okunev
Revival Stage Director: Irkin Gabitov
Set Designer: Vyacheslav Okunev