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-05-14' AND tmp.date<='2024-06-03' AND tmp.perf_id=985) 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-05-14' AND '2024-06-03' AND tmp.perf_id=985) 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<>985 AND tp.id_base=1052 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<>985 AND tp.id_base=1052 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





	30 March 2018, 19:00 - "War and Peace" opera in two acts by Sergei Prokofiev - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

Home Theaters Saint Petersburg Mariinsky Theatre - Mariinsky II 30 March 2018, 19:00 - "War and Peace" opera in two acts by Sergei Prokofiev
30March
19:00
2018 | Friday
Opera
Mariinsky Theatre - Mariinsky II, Saint Petersburg
Duration: 3 hours 55 minutes
World premiere: 11 March 2000

opera in two acts (2000 Production)
Music: Sergey Prokofiev
Production by Andrei Konchalovsky

Libretto: Sergey Prokofiev and Mira Mendelson-Prokofieva
after the novel of the same name by Lev Tolstoy

Musical Director: Valery Gergiev
Director: Andrei Konchalovsky
Set Designer: George Tsypin
Costume Designer: Tatiana Noginova
Lighting Designer: James Ingalls
Principal Chorus Master: Andrey Petrenko
Musical Preparation: Irina Soboleva


Co-production with the Metropolitan Opera

2000 Production


… It was a performance about Russia and her vast lands and history. An opera about both Tolstoy and Prokofiev that has a contemporary Weltanschauung.

Irena Leina. Kultura

Konchalovsky's solution is brilliant: the action takes place on a convex dome like the curved surface of the Earth. This nicely reflects the circularity of the waltz music in the “peace” themes, while its ceaselessly changing landscape gives the “war” theme a dizzy, global feel. All this is splendidly cinematic: under swirling Turner skies , the battling armies and oppressed multitudes shunt endlessly to and fro while acts of casual brutality and hopeless heroism suggest war's pity, terror and confusion. Prokofiev's atmospheric music emerges in all its glory thanks to Gergiev's magic in the pit.

Michael Church. The Independent

Konchalovsky has brilliantly met the fundamental task: to stage a vivid, dynamic, visually intense production, to embody the heroic and patriotic idea of the opera without any false pathos. An entire gallery of Russian characters, living, unpretentious, natural and life-like, comes to life, contemplates, suffers and acts within the space of the opera. On the huge stage of the Mariinsky Theatre, rigged out with the new imported rotating circle, the stage director stealthily, like an army commander, has mixed up Russian and French regiments, a partisan division and the peasant militia, one after another recreating the Battle of Borodino, the Shevardino Redoubt, Moscow streets aflame and the shooting of French “arsonists”. The auditorium burst into applause when the pure starry sky was reproduced on the white synthetic back curtain of the stage, the Universe with its myriad stars, the impetuously rushing clouds of smoke, the white stone walls and golden cupolas of Moscow illumined by the flame. Also effective was the rousing “red cockerel” of the fire with its spreading wings.

Larisa Kazanskaya. Russian Music Gazette

This is a serious effort, influenced no doubt by the perceived tastes on the international audience that awaits it. And Konchalovsky has shunned any imposed outside “interpretation”. George Tsypin's sets emphasize the opera's cosmic nature by placing the action on a convex surface, apparently the top of a huge, mostly unseen globe. Tatyana Noginova's period costumes – especially the soldier's uniforms – are spectacular in their detail. The singing was splendid by any standard and little short of astonishing when one bears in mind that all 57 roles (after the cuts) are cast solely from the company.

George Loomis. Musical America

Your heart thumps when you hear the delicate, inexpressibly tender melody of the waltz and suddenly the stage rumbles and flies upwards under the feet of the dancing Natasha and Andrei, carrying off strange faces, figures frozen still, Sonya, Pierre, Akhrosimova, the entire disordered world in all its varied colours… And the director’s discovery so stuns us with its unexpected subtlety and the psychological truth comprising the very essence of Tolstoy’s deep words.

Olga Gladkova. Smena

Casts & Credits

Choreography: Sergei Gritsai
Mezzo soprano: Yekaterina Krapivina
Mezzo soprano: Yekaterina Sergeyeva
Conductor: Pavel Smelkov
Conductor: Zaurbek Gugkaev
Costume Designer: Tatiana Noginova
Director: Graham Vick
Director: Irkin Gabitov
Musical Director: Maestro Valery Gergiev
Musical Preparation: Irina Soboleva
Principal Chorus Master: Andrei Petrenko
Set Designer: George Tsypin
Set Designer: Paul Brown
Stage Director: Andrei Konchalovsky
Stage Director: Andrei Petrov
Choreography: Sergei Gritsai
Mezzo soprano: Yekaterina Krapivina
Mezzo soprano: Yekaterina Sergeyeva
Conductor: Pavel Smelkov
Conductor: Zaurbek Gugkaev
Costume Designer: Tatiana Noginova
Director: Graham Vick
Director: Irkin Gabitov
Musical Director: Maestro Valery Gergiev
Musical Preparation: Irina Soboleva
Principal Chorus Master: Andrei Petrenko
Set Designer: George Tsypin
Set Designer: Paul Brown
Stage Director: Andrei Konchalovsky
Stage Director: Andrei Petrov