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=125) 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=125) 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<>125 AND tp.id_base=496 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<>125 AND tp.id_base=496 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





	2 February 2019, 19:00 - Nikolay Rimsky-Korsakov "The Snow Maiden" (springtime tale in a prologue and four acts) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theatre - Mariinsky II 2 February 2019, 19:00 - Nikolay Rimsky-Korsakov "The Snow Maiden" (springtime tale in a prologue and four acts)
2February
19:00
2019 | Saturday
Opera
Mariinsky Theatre - Mariinsky II, Saint Petersburg
Duration: 4 hours
World premiere: Mariinsky Theatre, St Petersburg, Russia, 26 April 2004

Although best known for his oriental fantasy Scheherazade, Rimsky-Korsakov principally considered himself a composer of opera. In his autobiography Chronicle of My Musical Life, he wrote, “Snegurochka is not only my best opera, but perhaps the best contemporary opera in general”. It was not a view shared by the press. “The critics treated Snegurochka with scant sympathy… I ‘possessed talent’ as a symphonist, but not as an operatic composer.”

Libretto by the composer,after the play by Alexander Ostrovsky

Performed in Russian

The Performance has two intermissions

World Premiere: 10 February (29 January) 1882, the Mariinsky Theatre, St Petersburg
Premiere of this production at the Mariinsky Theatre: 26 April 2004

The Snow Maiden (Snegurochka in transliteration) is an opera in four acts with a prologue by Nikolai Rimsky-Korsakov, composed during 1880-1881. The Russian libretto, by the composer, is based on the like-named play by Alexandr Ostrovsky (which had premiered in 1873 with incidental music by Tchaikovsky). The first performance of Rimsky-Korsakov’s opera took place at the Mariinsky Theatre, Saint Petersburg, 29 January 1882 (Old Style) under the conductorship of Eduard Nбpravnнk. By 1898 it was revised in the edition known today. It remained the composer’s own favorite work.

Synopsis

Prologue.

On Red Hill, near the Berendeyans’ trading quarter and Tsar Berendey’s capital. The fifteen-year-old Snow Maiden wants to live with the people in the nearby village, and her parents, Spring Beauty and Grandfather Frost, agree to let her be adopted by Bobyl’-Bakula and his wife.

Act I.

In the village of Berendeyevka, on the other side of the river. Snow Maiden is enchanted by Lel’s songs, but is saddened when he goes off with a group of other girls. Kupava enters and announces her own wedding to Mizgir’. The ceremony takes place, but then Mizgir’ notices Snow Maiden, becomes smitten with her, and begs her to love him. Kupava brings this affrontery before the villagers, and they advise her to go to the Tsar for redress.

Act II.

In Tsar Berendey’s palace. Kupava complains of Mizgir’ to Tsar Berendey, who decides to banish Mizgir’ to the forest. But these deliberations are disrupted by the appearance of the beautiful Snow Maiden. The Tsar asks her whom she loves, and she says, "no one." The Tsar declares that whoever successfully woos Snow Maiden will win both her and a royal reward. Although the maidens present Lel’ as the likely candidate, Mizgir’ swears that he will win Snow Maiden’s heart. The Tsar agrees to the contest as the people sing his praises.

Act III.

In a forest reserve, that evening. The people amuse themselves with song and dance. The Tsar invites Lel’ to choose a maiden. Despite Snow Maiden’s pleas, he kisses Kupava and goes off with her. Snow Maiden, left alone and disconsolate, wonders why Lel’ has rejected her. Suddenly Mizgir’ appears and tries once more to win her love. Frightened by his words, she runs off; but the Wood-Sprite tricks Mizgir’ to follow an apparition of Snow Maiden instead. Lel’ and Kupava enter, declaring their mutual love. Snow Maiden finds them and, seeing their happiness, at last truly wishes to have the capacity to love.

Act IV.

In the valley of Yarilo (the sun god), dawn is breaking the next day. Snow Maiden calls on her mother, Spring-Beauty, who appears from a lake surrounded by flowers. Spring gives her daughter a garland and warns her to stay out of the light of the sun. Spring and her retinue sink into the lake. Before Snow Maiden can enter the protection of the forest, Mizgir’ appears. No longer able to resist, she professes her love for him. The Berendeyans, in ritual bride-and-groom pairs, arrive to celebrate Yarilo’s Day. Before the Tsar Mizgir’ presents Snow Maiden as his bride. As she declares her love for Mizgir’, a bright ray of sunlight appears, and Snow Maiden bids farewell: the power to love is the source of her demise. To the astonishment of the people, she melts. The inconsolable Mizgir’ drowns himself in the lake. The Tsar calms the horrified Berendeyans with the fact that this event has ended the fifteen-year-long winter that has befallen them. In response the people strike up a stirring hymn to Yarilo.

Casts & Credits

Choreography: Galina Kaloshina
Costume Designer: Tatiana Noginova
Lighting Designer: Gleb Filshtinsky
Musical Director: Maestro Valery Gergiev
Musical Preparation: Larisa Gergieva
Principal Chorus Master: Andrei Petrenko
Set Designer: George Tsypin
Stage Director: Alexei Stepanyuk
Choreography: Galina Kaloshina
Costume Designer: Tatiana Noginova
Lighting Designer: Gleb Filshtinsky
Musical Director: Maestro Valery Gergiev
Musical Preparation: Larisa Gergieva
Principal Chorus Master: Andrei Petrenko
Set Designer: George Tsypin
Stage Director: Alexei Stepanyuk