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-20' AND tmp.date<='2024-06-09' AND tmp.perf_id=986) 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-20' AND '2024-06-09' AND tmp.perf_id=986) 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<>986 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<>986 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





	6 February 2018, 19:30 - Evening of one-act ballets: Sacre. Concerto DSCH - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Saint Petersburg Mariinsky Theatre - Mariinsky II 6 February 2018, 19:30 - Evening of one-act ballets: Sacre. Concerto DSCH
			

			
				


    

        
6February

        
19:30

        
2018 | Tuesday

    

    

        
Evening of one-act ballets: Sacre. Concerto DSCH

        
Classical ballet

	
Mariinsky Theatre - Mariinsky II, Saint Petersburg

            

    

            

    





        
    
Go to events list (All venues, -3)



    

        Concerto DSCH 

Music by Dmitry Shostakovich 
Choreographer: Alexei Ratmansky
Assistant Choreographer: Tatiana Ratmanskaya 
Lighting Designer: Mark Stanley 
Costume Designer: Holly Hynes 

Concerto DSCH is a ballet by Alexei Ratmansky choreographed for the New York City Ballet to the music of Dmitri Shostakovich's Piano Concerto No. 2 in F Major, Op. 102 (1957). The premiere took place on Thursday, May 29th, 2008 at the New York State Theater, Lincoln Center. The ballet's title derives from the composer's use of DSCH as a motif in allusion to his own name.

Le Sacre du printemps 
choreography by Sasha Waltz. 

German choreographer Sasha Waltz will be staging her original version of Le Sacre du printemps to music by Igor Stravinsky for the Mariinsky Ballet Company as part of a joint project between the Mariinsky Theatre and Paris’ Theatre des Champs Elysees 

Music by Igor Stravinsky 
Musical Director and Conductor: Valery Gergiev 
Choreographer: Sasha Waltz 
Production Designers: Pia Maier Schriever, Sasha Waltz 
Costume Designer: Bernd Skodzig 
Lighting Designer: Thilo Reuther 
Co-production by Sasha Waltz & Guests GmbH and the Mariinsky Theatre 
 

Premiere of the ballet with choreography by Sasha Waltz: 13 May 2013, Mariinsky Theatre, St Petersburg
Casts & Credits
Composer: Igor Stravinsky
Choreography: Alexei Ratmansky
Choreography: Sasha Waltz
Ballet company: Mariinsky (Kirov) Ballet
Conductor: Alexei Repnikov
Lighting Designer: Thilo Reuther
Musical Director: Maestro Valery Gergiev
        

    

    

                
    
                    

        

            

                            

            

                            

        

    

	

        
Composer: Igor Stravinsky
Choreography: Alexei Ratmansky
Choreography: Sasha Waltz
Ballet company: Mariinsky (Kirov) Ballet
Conductor: Alexei Repnikov
Lighting Designer: Thilo Reuther
Musical Director: Maestro Valery Gergiev
    

    

			

		





	


	

	

		


			

				

					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