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=123) 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=123) 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<>123 AND tp.id_base=775 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<>123 AND tp.id_base=775 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





	21 February 2019, 19:00 - Dmitry Shostakovich "The Nose" (opera in three acts and ten scenes) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theatre - Mariinsky II 21 February 2019, 19:00 - Dmitry Shostakovich "The Nose" (opera in three acts and ten scenes)
21February
19:00
2019 | Thursday
Opera
Mariinsky Theatre - Mariinsky II, Saint Petersburg
Duration: 2 hours 25 minutes
World premiere: Mariinsky Theatre, St Petersburg, Russia, 10 April 2004

Music: Dmitry Shostakovich
Production by Yury Alexandrov

Libretto by Yevgeny Zamyatin, Georgy Ionin, Alexander Preis and the composer after the short story by Nikolai Gogol

Performed in Russian

Musical Director: Valery Gergiev
Stage Director: Yuri Alexandrov
Set Designer: Zinovy Margolin
Costume Designer: Maria Danilova
Lighting Designer: Gleb Filshtinsky
Principal Chorus Master: Andrei Petrenko
Musical Preparation: Irina Soboleva

World premiere – 18 January 1930, State Academic Maly Opera Theatre, Leningrad
Premiere at the Mariinsky Theatre – 10 April 2004

The Performance has one intermissions

SYNOPSIS

Act I
Scene 1. Either in a dream or in reality, the barber Ivan Yakovlevich is doing his hateful job in a drunken stupor.
Scene 2. Ivan Yakovlevich and his wife Praskovia are taken aback to find a nose in a bread roll.
Scene 3. The panic-stricken barber tries to dispose of the evidence.
Scene 4. When he wakes up in the morning, Major Kovalev discovers his nose has disappeared.
Scene 5. Inside Kazan Cathedral, Major Kovalev unexpectedly meets his nose and tries to speak to it.

Act II
Scene 6. A newspaper advertisements department: Kovalev tries to submit an advertisement about the disappearance of his nose. Unsuccessfully.
Scene 7. Kovalev's apartment. The major's footman Ivan is relaxing quietly, and Kovalev's despair increases.

Act III
Scene 8. A coaching-inn. The district constable is giving instructions to his men to capture the travelling Nose. A procession of travellers enters: a mother and father with their two sons, Ivan Ivanovich and Pyotr Fyodorovich, an elderly lady surrounded by hangers-on and a bread roll seller. Suddenly the nose appears. In the confusion, they manage to catch it.
Scene 9. Kovalev's apartment. The district constable brings Kovalev his Nose and, on receiving his reward, disappears. In vain, the major tries to put the Nose back on his face. A doctor arrives but is unable to help Kovalev. Kovalev and his friend Yaryzhkin suspect the guilty party to be staff-officer Podtochina, acting in revenge for Kovalev's contempt for her daughter. The friends write a letter to Podtochina, which Ivan the footman delivers. Ivan returns with an answer and Kovalev understands that the women are innocent.
Scene 10. A street. A rumour is spreading over the city that Kovalev's Nose has run away. The horrific tale has captured the imagination of the whole city: Everyone, including the eminent merchant Khorzev-Mirza, is discussing the event in the most animated fashion. Unexpectedly Major Kovalev joins the melee: his nose is exactly where it should be.

ABOUT THE PRODUCTION

Shostakovich's phantasmagorical opera has only been staged in Russia at Leningrad's Maly Opera Theatre in 1930 (the world premiere) and at the Boris Pokrovsky Chamber Music Theatre in Moscow in 1974. Unlike his predecessors, Yuri Alexandrov did not regard The Nose as a satire of the tsarist regime or the bourgeoisie - his production at the Mariinsky Theatre had the secondary title of Passions for Kovalev. Apropos, the true hero of the production was not Kovalev, but the Nose itself, which appeared before the audience in many guises all at once: a prop nose of real-life proportions, a rubber canvas in the form of a nose, a dancer sewn into an elastic white bag and, finally, the Tenor-Nose that arises from the grave in the form of Napoleon.
Alexandrov admitted that "This piece by Gogol, the great mystifier and at the same time a great Russian sufferer, is seriously complex. I have made it even more complex." Here we have a circus, ROSTA posters, a chief of police dressed in Gogol's overcoat the size of a three-storey building and Sirin and Alkonost, soaring over a biblical-like crowd in Kazan Cathedral. The director used the same method employed at the Mariinsky Theatre five years earlier with Semyon Kotko: witty grotesque and the creation of a hypertrophied and at times riotous libretto of the on-stage plot. Combined with the staccato-arrangement of Shostakovich's constantly twisting and sparkling score, the result is rather extravagant. The "pivot" of this colourful and kaleidoscopic spectacle came with Zinovy Margolin's sets - an upside-down St Petersburg courtyard. At key moments in the opera a video backdrop is revealed and the plot unfolds in a stunning metallic tunnel - "a combination of Tatlin's Tower pushed on its side with urban catacombs inhabited by American thrillers."
Bogdan Korolyok

Casts & Credits

Conductor: Pavel Smelkov
Baritone: Sergei Romanov
Costume Designer: Maria Danilova
Lighting Designer: Gleb Filshtinsky
Musical Director: Maestro Valery Gergiev
Musical Preparation: Irina Soboleva
Principal Chorus Master: Andrei Petrenko
Set Designer: Zinovy Margolin
Stage Director: Yuri Alexandrov
Conductor: Pavel Smelkov
Baritone: Sergei Romanov
Costume Designer: Maria Danilova
Lighting Designer: Gleb Filshtinsky
Musical Director: Maestro Valery Gergiev
Musical Preparation: Irina Soboleva
Principal Chorus Master: Andrei Petrenko
Set Designer: Zinovy Margolin
Stage Director: Yuri Alexandrov