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=1127) 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=1127) 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<>1127 AND tp.id_base=1793 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<>1127 AND tp.id_base=1793 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





	31 March 2018, 13:00 - "Le Rossignol" conte lyrique in three acts - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theater 31 March 2018, 13:00 - "Le Rossignol" conte lyrique in three acts
31March
13:00
2018 | Saturday
Opera
Mariinsky Theater, Saint Petersburg
Duration: 45 minutes
World premiere: Mariinsky Theatre, St Petersburg, Russia, 22 March 1995

Stravinsky's Le Rossignol (The Nightingale) is a "musical fairy tale" based on the story by Hans Christian Andersen. It is an opera in three acts, scored for full orchestra with optional guitar and mandolin parts. According to Stravinsky, he chose a Hans Christian Andersen tale out of nostalgia for his boyhood. It is considered a short work for an opera--about forty-five minutes--and its three acts, as Eric White notes, are more like three scenes in a single-act opera.

Music by Igor Stravinsky
Libretto by Igor Stravinsky and Stepan Mitussov, after the story The Emperor Nightingale by Hans Christian Andersen

Musical Director: Valery Gergiev
Stage Director: Alexander Petrov
Set Designer: Vladimir Firer
Lighting Designer: Vladimir Lukasevich
Musical Preparation: Natalia Mordashova
Principal Chorus Master: Andrei Petrenko
Ballet Mistress: Irina Novik

SYNOPSIS

The action takes place in China in fairy-tale times.

Act I

The seashore just before dawn. In his boat, a fisherman is singing a song and listening to the trill of the Nightingale. The beautiful birdsong makes him forget his troubles. Courtiers approach the shore. They are burning with desire to hear the wondrous birdsong of which they have heard so much from the Cook. The Emperor himself, on learning of this beautiful bird hiding in his forest, has decreed it be found and brought to the palace. A cow moos and a frog croaks, and the courtiers take these to be the song of the Nightingale, but the Cook convinces them this is not so. The courtiers promise to make the Cook the Emperor&rsquo;s personal chef if only they can find the bird. At last the Nightingale appears. He agrees readily to set off for the palace and sing for the Emperor.

Act II

The servants are decorating the palace with festive lanterns. The Cook tells everyone about the Nightingale: he is small and plain, but his song draws tears to the eyes. A grand procession arrives, servants bearing the Celestial Ruler under a canopy. The Nightingale sings and his beautiful trills enthral the Emperor. He wishes to award his singer with a golden slipper, but the Nightingale refuses: the best reward for him is to see tears of joy in the eyes of his listeners. Ambassadors arrive from Japan. They present the Emperor with their own nightingale &ndash; a mechanical one. It can repeat one and the same melody without ever getting tired. While all listen in delight to the mechanical bird, the living one flies away. Furious, the Emperor orders him to be banished from China, and the Japanese nightingale begins to sing &ldquo;on the Emperor&rsquo;s bedside table with his singer first on the left.

Act III

It is night. The Emperor is seriously ill and Death appears in his chambers. It wears the Emperor&rsquo;s crown on its head and in its hands holds his sabre and standard. The ghosts of deeds gone-by appear and insistently make themselves known. The Emperor wants to drown out their persistent voices and summons musicians, but suddenly the Nightingale flies in. Charmed by his singing, Death returns the crown, sabre and standard to the Emperor. It vanishes, and strength returns to the Emperor. The Celestial Ruler wishes to reward his saviour richly, but the Nightingale needs no repayment. He promises to come to the palace every night and sing for the Emperor. The courtiers, who have come to honour the memory of their late ruler, find him alive and well. In the distance, the fisherman can be heard singing.

Casts & Credits

Composer: Igor Stravinsky
Choreography: Michel Fokine
Conductor: Zaurbek Gugkaev
Costume Designer: Vladimir Firer
Lighting Designer: Vladimir Lukasevich
Musical Director: Maestro Valery Gergiev
Musical Preparation: Natalia Mordashova
Principal Chorus Master: Andrei Petrenko
Stage Director: Alexander Petrov
Composer: Igor Stravinsky
Choreography: Michel Fokine
Conductor: Zaurbek Gugkaev
Costume Designer: Vladimir Firer
Lighting Designer: Vladimir Lukasevich
Musical Director: Maestro Valery Gergiev
Musical Preparation: Natalia Mordashova
Principal Chorus Master: Andrei Petrenko
Stage Director: Alexander Petrov