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=2271) 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=2271) 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<>2271 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


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<>2271 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





	11 July 2018, 19:00 - Music and libretto by Khristof Pliev "Kosta" opera in two acts. Performance by the Republic of North Ossetia; Alania Branch of the Mariinsky Theatre - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Saint Petersburg Mariinsky Theater 11 July 2018, 19:00 - Music and libretto by Khristof Pliev "Kosta" opera in two acts. Performance by the Republic of North Ossetia; Alania Branch of the Mariinsky Theatre
			

			
				


    

        
11July

        
19:00

        
2018 | Wednesday

    

    

        
Music and libretto by Khristof Pliev "Kosta" opera in two acts. Performance by the Republic of North Ossetia; Alania Branch of the Mariinsky Theatre

        
Opera

	
Mariinsky Theater, Saint Petersburg

            

    

            

    





        
    
Go to events list (All venues, -13)



    

        
Music and libretto by Khristof Pliev
Stage Director: Anatoly Galaov
Musical Director: Larisa Gergieva
 
"Kosta" - the folk heroic-epic musical drama in 3 acts,  7 scenes by Christopher Pliev. The libretto by Maxim Tsagaraev and Joachim Sharoev. The premiere took place in 1960 at the Bolshoi Theater of the USSR in the framework of the Decade of Ossetian Art and Literature.
 
History of creation
Christopher Pliev conceived the opera as a musical offering to the great Ossetian poet, artist and educator Kosta Levanovich Khetagurov, timed to the centenary of his birth. The authors of the libretto are Maxim Tsagaraev and Joachim Sharoev (who also directed the premiere performance). The plotline of the opera is based on real events from the life of Khetagurov.
Initially, the opera was one act (in 5 scenes). It was first staged in 1960 at the Bolshoi Theater of the USSR, at the Decade of Ossetian Literature and Art. Opera was highly appreciated by both viewers and critics, the newspaper "Soviet Culture" wrote rave reviews. Adoptive and critical comments on the opera prompted Christopher Pliev to continue working on the opera, substantially reworking and expanding it. As a result, the new version of the opera resulted in three acts and seven scenes. In this form, it was already staged on the stage of the North Ossetian Musical Theater, in 1962. 
Also in the new edition of the opera, it was staged in 1974 in Moscow, on the stage of the Stanislavsky and Nemirovich-Danchenko Moscow Music Theatre during the Decade of Ossetian Art and Literature in Moscow.
Opera for more than 25 years has opened seasons in the North Ossetian musical theatre.
 
Characters
Costa, baritone
Mother of the orphans, soprano
Kubadi, bass
Mother Earth, mezzo-soprano
Anna Tsalikova, soprano
Varvara Schroeders, soprano
Lieutenant-General Kokhanov, bass
Adjutant, tenor
Prince Dzakhsor, baritone
She sang, a tenor
        

    

    

                
    
                    

        

            

                            

            

                            

        

    

	
    

			

		





	


	

	

		


			

				

					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