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-13' AND tmp.date<='2024-06-02' AND tmp.perf_id=2374) 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-13' AND '2024-06-02' AND tmp.perf_id=2374) 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<>2374 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<>2374 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





	,  - Ceremony of presenting the Russian opera award "CASTA DIVA" - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Moscow Moscow theatre "New Opera" ,  - Ceremony of presenting the Russian opera award "CASTA DIVA"
			

			
				


    

        

        

        
 | 

    

    

        
Ceremony of presenting the Russian opera award "CASTA DIVA"

        
Opera

	
Moscow theatre "New Opera", Moscow

            

    

            

    





        
    
Go to events list (All venues, -13)



    

        
I Part
 
Nikolai Rimsky-Korsakov
Aria Lyubasha "Here, to what I have lived ..." from the opera "The Tsar's Bride"
 
Performed by Nadezhda Babintseva
 
Pyotr Tchaikovsky
Arioso Herman "I do not know her name" from the opera "The Queen of Spades"
 
Performed by Oleg Dolgov
 
Pietro Mascagni
Romance Santuzza "Voi lo sapete" from the opera "Rural honor"
 
Performed by Nadezhda Babintseva
 
Giacomo Puccini
Aria Kalaf "Nessun dorma" from the opera "Turandot"
 
Performed by Oleg Dolgov
 
Georges Bizet
Duet Carmen and Jose "C'est toi! ... C'est moi!" From the opera "Carmen"
 
Performed by Nadezhda Babintseva and Oleg Dolgov
 
Giuseppe Verdi
Aria Violetta "E strano! ... Ah, fors'è lui ..." from the opera "La Traviata"
 
Performed by Nadezhda Pavlova
 
Giacomo Puccini
Rudolph's aria "She gelida manina" from the opera "La Boheme"
 
Performed by Alexey Tatarintsev
 
Giuseppe Verdi
The duet of Violetta and Alfred "Ah si, da un anno ... Un di felice, eterna" from the opera "La Traviata".
 
Performed by: Nadezhda Pavlova and Alexei Tatarintsev
 
II Part
 
Giuseppe Verdi
Aria Ezio "Dagl'immortali vertici" from the opera "Attila"
 
Performed by Vasily Ladyuk
 
Charles Gounod
Cavatina Romeo "Ah! Lève-toi, soleil!" From the opera "Romeo and Juliet"
 
Performed by Alexey Tatarintsev
 
Georges Bizet
Duet of Nadir and Zurgi from the opera "Pearl Seekers"
 
Performed by: Alexey Tatarintsev and Vasily Ladyuk
 
Alexander Borodin
Aria Konchak "Is it good, prince?" From the opera "Prince Igor"
 
Performed by Dmitry Ulyanov
 
Luigi Cherubini
Aria Medea "Numi, venite a me, inferni Dei!" From the opera of the same name
 
Performed by Natalia Muradymova
 
Charles Gounod
Mephistopheles' coupons "Le veau d'or est toujours debout" from the opera "Faust"
 
Performed by Dmitry Ulyanov
 
Richard Wagner
Aria Elizabeth's "Dich, teure Halle" from the opera "Tannhäuser"
 
Performed by Natalia Muradymova
 
Giuseppe Verdi
Duet of Aida and Amonasro "Ciel, mio padre!" From the opera "Aida"
 
Performed by: Natalia Muradymova and Sergei Leiferkus
 
Giuseppe Verdi
Aria Iago "Credo in un Dio crudel" from the opera "Othello"
 
Performed by Sergei Leiferkus
        

    

    

                
    
                    

        

            

                            

            

                            

        

    

	

            

    

			

		





	


	

	

		


			

				

					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