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-06-07' AND tmp.date<='2024-06-27' AND tmp.perf_id=2228) 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-06-07' AND '2024-06-27' AND tmp.perf_id=2228) 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<>2228 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<>2228 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





	25 May 2018, 19:00 - Staatskapelle Dresden. Soloist: Denis Matsuev (piano) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			

				

					

						




	















	

		
		


	
	
	












	
		


			

				
				

					
Home Theaters Saint Petersburg Mariinsky Theatre - Mariinsky II 25 May 2018, 19:00 - Staatskapelle Dresden. Soloist: Denis Matsuev (piano)
			

			
				


    

        
25May

        
19:00

        
2018 | Friday

    

    

        
Staatskapelle Dresden. Soloist: Denis Matsuev (piano)

        
Concert

	
Mariinsky Theatre - Mariinsky II, Saint Petersburg

            

    

            

    





        
    
Go to events list (All venues, -18)



    

        
PERFORMERS:


Soloist: Denis Matsuev (piano)


Staatskapelle Dresden
Conductor: Christian Thielemann



PROGRAMME: 
Carl Maria von Weber 
Overture to the opera Oberon


Franz Liszt 
Piano Concerto No. 2 in A major


Johannes Brahms 
Symphony No. 4 in E minor, Op. 98


About the performers


The Staatskapelle Dresden, one of the oldest orchestras in the world, traces its origins to the middle of the 16th century. At different times the Staatskapelle was headed by famous musicians, such as Heinrich Schütz, Johann Adolph Hasse, Carl Maria von Weber and Richard Wagner; in the 20th and 21st centuries – by conductors Fritz Reiner, Karl Böhm, Herbert Blomstedt, Giuseppe Sinopoli, and Bernard Haitink. The Staatskapelle Dresden has a many-year-long connection to Richard Strauss; nine of the composer’s operas were premiered at the Semperoper with the participation of the ensemble. The orchestra still takes part in the Semperoper productions recordings, tours abroad, and releases music. Recent additions include DVD and BluRay versions of Richard Wagner’s Lohengrin (featuring Anna Netrebko) and Die Walküre performances from the 2017 Salzburg Easter Festival.


Since 2012 Christian Thielemann has been chief conductor of the Staatskapelle Dresden. He started his career working as Herbert von Karajan's assistant; he went on to become Generalmusikdirektor of the Deutsche Oper Berlin. Thielemann has collaborated with many symphony and opera ensembles, including the Munich Philharmonic and the Vienna Philharmonic, the Philadelphia Orchestra, the Vienna State Opera, and the Metropolitan Opera. Christian Thielemann’s core repertoire consists of German and Austrian Romantic music. His performances of Richard Wagner’s operas (including the tetralogy Der Ring des Nibelungen) and those of Richard Strauss were critically acclaimed. Thielemann has been a regular at the Bayreuth Festival and the Salzburg Festival. Apart from operas, the conductor has recorded all of Ludwig van Beethoven’s and Robert Schumann’s symphonies, orchestra pieces and fragments from operas by Weber, Lortzing, Brahms, Bruckner, Pfitzner, Schoenberg and other composers.


The programme for the Mariinsk Theatre performance also features German music of the 19th century. The concert will open with the overture to the opera Oberon, which is the last opera of Carl Maria von Weber. Denis Matsuev, who has held the honorary position of artist-in-residence at the Staatskapelle Dresden since October 2017, will be the featured soloist for the virtuoso Piano Concerto No. 2 by Franz Liszt. This season the Russian pianist has already performed with the orchestra at the Semperoper multiple times. The second part of the concert will see the performance of Johannes Brahms’ Symphony No. 4, which is one of the pieces concluding the multi-year tradition of the Austrian-German Romantic symphonism.
        

    

    

                
    
                    

        

            

                            

            

                            

        

    

	
    

			

		





	


	

	

		


			

				

					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