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=636) 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=636) 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<>636 AND tp.id_base=770 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<>636 AND tp.id_base=770 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





	7 February 2018, 19:30 - The Maid of Pskov (opera in three acts). Nikolai Rimsky-Korsakov - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Saint Petersburg Mariinsky Theater 7 February 2018, 19:30 - The Maid of Pskov (opera in three acts). Nikolai Rimsky-Korsakov
			

			
				


    

        
7February

        
19:30

        
2018 | Wednesday

    

    

        
The Maid of Pskov (opera in three acts). Nikolai Rimsky-Korsakov

        
Opera

	
Mariinsky Theater, Saint Petersburg

            

    

            

    





        
    
Go to events list (All venues, -8)



    

        
Duration: 3 hours 10 minutes
World premiere: Mariinsky Theatre, St Petersburg, 1 January 1873

Music by Nikolai Rimsky-Korsakov 


Libretto by Nikolai Rimsky-Korsakov after the drama by Lev Mey



Performed in Russian 
The performance will have synchronised 
English supertitles 



Revival of the 1952 production (with sets by Fyodor Fyodorovsky) 

Musical Director: Valery Gergiev
Revival Stage Director: Yuri Laptev
Revival Designer: Vyacheslav Okunev
Costume Designer: Tatiana Noginova
Lighting Designer: Damir Ismagilov
Musical Preparation: Irina Soboleva
Principal Chorus Master: Andrei Petrenko


World premiere: January 1, 1873, the Mariinsky Theater, St. Petersburg
Premiere of the production: April 25, 2008, Mariinsky Theater, St. Petersburg


The performance comes with two intermissions


The Maid of Pskov, is an opera in three acts by Nikolai Rimsky-Korsakov. The libretto was written by the composer, and is based on the drama of the same name by Lev Mey. The story concerns the Tsar Ivan the Terrible and his efforts to subject the cities of Pskov and Novgorod to his will. The original version of the opera was completed in 1872, and received its premiere in 1873 in St. Petersburg, Russia. The third and final version was completed in 1892, and is considered "definitive". This version was made famous by Shalyapin (Chaliapin) in the role of Ivan the Terrible. It was introduced to Paris in 1909 by Dyagilev under the title Ivan the Terrible, on account of the dominance of his role.

Casts & Credits
Costume Designer: Tatiana Noginova
Lighting Designer: Damir Ismagilov
Musical Director: Maestro Valery Gergiev
Musical Preparation: Irina Soboleva
Principal Chorus Master: Andrei Petrenko
Revival Designer: Vyacheslav Okunev
Revival Stage Director: Yuri Laptev
Set  Designer: Vyacheslav Okunev
        

    

    

                
    
                    

        

            

                            

            

                            

        

    

	

        
Costume Designer: Tatiana Noginova
Lighting Designer: Damir Ismagilov
Musical Director: Maestro Valery Gergiev
Musical Preparation: Irina Soboleva
Principal Chorus Master: Andrei Petrenko
Revival Designer: Vyacheslav Okunev
Revival Stage Director: Yuri Laptev
Set  Designer: Vyacheslav Okunev
    

    

			

		





	


	

	

		


			

				

					Deals & Discounts 
					Subscribe to our email newsletter
				



				
				


			

			

		

		

	

	




 



	

		

			
    		

    

        

		
		
Award-winning
Group Tour Packages

        

        

		
Useful Links &
Company Information

        

        

        
    
		

	





	

		

			
© 2001 – 2024 by Northern Crown, Ltd. uVisitRussia and uVisitRussia.com are registered trademarks. Terms & Conditions  Privacy Policy