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-21' AND tmp.date<='2024-06-10' AND tmp.perf_id=2838) 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-21' AND '2024-06-10' AND tmp.perf_id=2838) 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<>2838 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<>2838 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





	12 July 2020, 19:00 - "Tchaikovsky Opera Gala" In commemoration of Pyotr Tchaikovsky's 180th birthday - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Moscow Stanislavsky theatre 12 July 2020, 19:00 - "Tchaikovsky Opera Gala" In commemoration of Pyotr Tchaikovsky's 180th birthday
			

			
				


    

        
12July

        
19:00

        
2020 | Sunday

    

    

        
"Tchaikovsky Opera Gala" In commemoration of Pyotr Tchaikovsky's 180th birthday

        
Concert

	
Stanislavsky theatre, Moscow

            

    

            

    





        
    
Go to events list (All venues, -5)



    

        
In commemoration of Pyotr Tchaikovsky's 180th birthday
PROGRAM:
Act I
Chorus of girls "Na more utushka kupalas" from the opera "Voevoda"
Duet of Undina and Gulbrand from the opera "Undine"
Performed by Maria Makeeva and Nikolai Lizogubov
Arioso Natalia from the opera "Oprichnik"
Performed by Natalya Petrozhitskaya
Scene of the oath of Andrey Morozov from the opera "Oprichnik"
Performed by Nikolai Erokhin, Anton Zaraev, Anastasia Khoroshilova
Duet of Solokha and Bes from the opera "Cherevichki"
Performed by Larisa Andreeva and Roman Ulybin
Aria of Vakula from the opera "Cherevichki"
Performed by Chingis Ayusheev
Aria of John from the opera "The Maid of Orleans"
Performed by Ksenia Dudnikova
Symphonic intermission "Poltava battle" from the opera "Mazepa"
Scene and duet of Maria and Mazepa from the opera "Mazepa"
Performed by Natalya Muradymova and Alexey Shishlyaev
The execution scene of Kochubey and Iskra from the opera "Mazepa"
Performed by Felix Kudryavtsev and Kirill Matveev
Act II
Dance of buffoons from music to the drama of A.N. Ostrovsky "The Snow Maiden"
Arioso Warrior from the cantata "Moscow"
Performed by Natalya Zimina
Duet from the unfinished opera "Romeo and Juliet"
Performed by Daria Terekhova and Vladimir Dmitruk
Lensky’s aria from the opera "Eugene Onegin"
Performed by Alexander Nesterenko
Prince’s aria from the opera "The Enchantress"
Performed by Andrey Baturkin
Scene and duet of Kuma and Knyazhich from the opera "The Enchantress"
Performed by Elena Guseva and Nikolai Erokhin
Quintet from the opera "The Queen of Spades"
Artists will be announced later.
Arioso Robert from the opera "Iolanta"
Performed by Stanislav Lee
Scene and duet of Iolanta and Vodemon from the opera "Iolanta"
Performed by Elena Bezgodkova and Najmiddin Mavlyanov
The final ensemble and choir from the opera "Iolanta"
        

    

    

                
    
                    

        

            

                            

            

                            

        

    

	

            

    

			

		





	


	

	

		


			

				

					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