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=27) 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=27) 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<>27 AND tp.id_base=527 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<>27 AND tp.id_base=527 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





	29 November 2020, 12:00 - Peter Tchaikovsky "Iolanta" (Opera in 2 Acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mikhailovsky Theater 29 November 2020, 12:00 - Peter Tchaikovsky "Iolanta" (Opera in 2 Acts)
29November
12:00
2020 | Sunday
Opera
Mikhailovsky Theater, Saint Petersburg
Duration: 2 hours 10 minutes
World premiere: Mikhailovsky Theater, 14 July 2005

Iolanta – Pyotr Ilyich Tchaikovsky's last opera – was written two years before the composer’s death. In 1884 Tchaikovsky read the one-act play King Rene’s Daughter by the Danish dramatist Henrik Hertz. The poetic story of Iolanta who has been blind from birth and is cured of her ailment through love inspired Tchaikovsky, who was looking for a subject for a short, lyrical opera. The eternal gloom in which Iolanta lives peacefully becomes a symbol of spiritual blindness and the source of deep pain for those close to her. Love ignites her heart’s desire to see the world and inspires her courage to undergo the pain that will enable her to see. At the request of the composer, his brother Modest Ilyich Tchaikovsky wrote an operatic libretto after the plot of King Rene’s Daughter. The opera was written between July and December 1891, and the premiere took place at the Mariinsky Theatre on 6 December 1892. It is believed that the composer’s philosophical intentions are reflected in the plot of the opera, as he had a keen interest in the philosophy of Spinoza. Whether that is the case or not Iolanta stands apart from Tchaikovsky’s other works because of its unusual "otherworldly" plot and the touching, light and serene music.

Libretto by Modest Tchaikovsky after the play King Renè’s Daughter by Henrik Hertz 

Stage Director: Sergey Shepelyov
Stage and Costume Designer: Vyacheslav Okunev
ighting Designer: Mikhail Mekler
Artistic Director and Principal Conductor of the Chorus: Vladimir Stolpovskikh
Director: Vyacheslav Kalyuzhny
Principal Pianist: Maria Kopyseva
Chorus Masters: Alexey Dmitriev, Sergey Tsyplenkov
Stage Manager: Elena Piskunova

Performed in Russian

Pyotr Tchaikovsky found the inspiration for his last opera in a tale of medieval France. Iolanta, the daughter of King René, has been blind since birth, but is unaware of her misfortune. Cradled in loving care, she lives a quiet, happy life, in ignorance of her blindness, until a young knight happens to enter her home. In a very literal sense, the opera celebrates love and its curative powers. Indeed, it is only after she falls in love, experiences spiritual pain, and overcomes her fear, that Iolanta is able to see. In the finale, the choir extols the universe, the light of reason, morality, and purity. The production is bathed in light, which heightens its delicate musical lyricism and reinforces the story’s main theme of the victory of light over darkness.

SYNOPSIS

Act I

Southern France, Provence. Iolanta, blind from birth, is the only daughter of King René. She is the fiancée of Robert, Duke of Burgundy. Iolanta’s father hopes to have his daughter cured by the time of the wedding and it has been announced that Iolanta is being educated in a Spanish nunnery.
René doesn’t want his daughter to know about her ailment. He’s forbidden to make any mentions of the light, colours, sights: she shouldn’t know about her blindness. Everybody is kind and tender to Iolanta but she’s been inexplicably sad lately.
Ibn-Hakia, a famous Moorish physician, has been invited to the castle. He states that Iolanta can be cured but only in case she is informed of her blindness and has a desire to see. The king refuses the treatment, fearing for Iolanta’s happiness.

Act II

Two friends, knight Vaudémont and count Robert have lost their way and suddenly come to the King René’s castle. Robert announces to Vaudémont his love to beautiful Mathilde, countess of Lorraine. But since childhood he’s been engaged to Iolanta, King René’s daughter.
Vaudémont encounters Iolanta who is asleep. Stunned by her beauty he falls in love.
Iolanta hears the voices and wakes up: they rarely have guests in the castle. The young men explain that they have come here by chance. Robert leaves to find his people, Iolanta and Vaudémont stay alone. He confesses his sudden love to her.
He discovers Iolanta’s blindness and her ignorance of the fact and explains light and color to her. The couple is discovered by the king, the physician and Iolanta’s friends. They find out that the secret has been revealed to the girl. The king is desperate, Ibn-Hakia, however, is sure that it’ll save Iolanta.
Iolanta can’t wish to see, as she doesn’t know what it is. The king threatens to kill Vaudémont if the physician’s treatment fails. Iolanta is ready to do anything to save the knight. Vaudémont asks the King to marry his daughter who refuses as his daughter has been engaged since her childhood.
Robert returns to find out that Vaudémont’s beloved girl is his fiancée. Vaudémont begs Robert to admit his love to Mathilde. The king cancels the wedding contract. Ibn-Hakia takes off a bandage from Iolanta’s eyes: she can see now. She’s frightened, she can’t recognize anybody. King René comforts Iolanta and offers her a reliable partner: Vaudémont who pledges fidelity to Iolanta. Everybody glorifies God.

Casts & Credits

Opera company: Mikhailovsky Opera
Principal Chorus Master: Alexandr Chernov
Production: Sergey Shepelev
Set Designer: Vyacheslav Okunev
Opera company: Mikhailovsky Opera
Principal Chorus Master: Alexandr Chernov
Production: Sergey Shepelev
Set Designer: Vyacheslav Okunev