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-18' AND tmp.date<='2024-06-07' AND tmp.perf_id=2256) 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-18' AND '2024-06-07' AND tmp.perf_id=2256) 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<>2256 AND tp.id_base=-1 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


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<>2256 AND tp.id_base=-1 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





	29 August 2018, 19:00 - Mikhail Glinka "A life for the Tsar" (Opera in concert) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Moscow Moscow theatre "New Opera" 29 August 2018, 19:00 - Mikhail Glinka "A life for the Tsar" (Opera in concert)
			

			
				


    

        
29August

        
19:00

        
2018 | Wednesday

    

    

        
Mikhail Glinka "A life for the Tsar" (Opera in concert)

        
Opera

	
Moscow theatre "New Opera", Moscow

            

    

            

    





        
    
Go to events list (All venues, -8)



    

        
Synopsis
(Note that the Act IV and the Epilogue contain more than one set of stage decor.) 
Act I. 
On a street in the village of Domnino, Antonida is eager to marry Sobinin, but her father Susanin refuses permission until a Russian has been duly chosen to take the Tsar’s throne. When Sobinin informs him that the Grand Council in Moscow has chosen a Tsar, everyone celebrates. 
Act II. 
 In a sumptuous hall in Poland, the nobility are celebrating the Polish dominance over the Russians with singing and dancing. Suddenly a messenger comes in, with the news that Mikhail Romanov has been selected as the Tsar of Russia and is now in hiding. The Poles vow to overthrow him. 
Act III. 
In Susanin’s cottage. Susanin and his adopted son Vanya pledge to defend the new Tsar. Susanin blesses Sobinin and Antonida on their upcoming wedding. A detachment of Polish soldiers bursts in, demanding to know where the Tsar is hiding. Susanin, in order to protect the Tsar, tells Vanya aside that he will lead them off the trail, and sends Vanya off to warn him. Pretending to help them, Susanin goes off with the Poles. Antonida is devastated. Sobinin gathers some men to go on a mission to rescue Susanin. 
Act IV. 
In a dense forest, Sobinin reassures his men of the rightness of their mission. Night falls. In a part of the forest near a monastery, Vanya knocks at the gates and alerts the inhabitants to spirit the Tsar away. Into an impassable, snow-covered area of the forest Susanin has led the suspicious Polish troops. The Poles sleep while Susanin waits for the dawn and bids farewell to his children. A blizzard sets in, and when day breaks, the Poles awake. When they realize that Susanin has deceived them, they kill him. 
Epilogue. 
Across the stage walks a crowd of people, celebrating the triumph of the new Tsar. Alone in their own solemn procession, Antonida, Sobinin, and Vanya mourn Susanin. A detachment of Russian troops comes upon them and, after discovering their connection with Susanin, comforts them. The scene changes to Red Square, where the people proclaim glory to the Tsar and to Susanin’s memory. 
Casts & Credits
Composer: Mikhail Glinka
Lighting Designer: Damir Ismagilov
Principal Chorus Master: Valery Borisov
Set  Designer: Zinovy Margolin
Stage Director: Evgeny Pisarev
        

    

    

                
    
                    

        

            

                            

            

                            

        

    

	

        
Composer: Mikhail Glinka
Lighting Designer: Damir Ismagilov
Principal Chorus Master: Valery Borisov
Set  Designer: Zinovy Margolin
Stage Director: Evgeny Pisarev
    

    

			

		





	


	

	

		


			

				

					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