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.id IN (-1)) ORDER BY date ASC, ves DESC, time ASC LIMIT 10
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





	Carl Maria Fon Weber (Composer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Carl Maria Fon Weber (Composer)

Carl Maria Fon Weber (Composer)

Carl Maria von Weber, a cousin of Mozart‘s wife Constanze, was trained as a musician from his childhood, the son of a versatile musician who had founded his own travelling theatre company. He made a favourable impression as a pianist and then as a music director, notably in the opera-houses of Prague and Dresden. Here he introduced various reforms and was a pioneer of the craft of conducting without the use of violin or keyboard instrument. As a composer he won a lasting reputation with the first important Romantic German opera, Der Freischutz.
The opera Der Freischutz (The Marksman), first staged in Berlin in 1821, blends many of the ingredients typical of German Romanticism, simple peasant virtues mingling with the magic and latent evil of the forest, where the hero‘s magic bullets are forged at midnight. The grand heroic-Romantic opera Euryanthe is better known for its overture as is the opera Oberon, written for London in 1826.
Weber‘s two concertos and the concertino for clarinet were written for the clarinettist Heinrich Baermann. Weber also wrote two piano concertos and a Konzertstuck for piano and orchestra for his own use, as well as a useful Horn Concertino and Bassoon Concerto. His Aufforderung zum Tanze (Invitation to the Dance) is well known in an orchestral version of a work originally written for piano.
Weber‘s chamber music includes a Clarinet Quintet and a Grand Duo Concertant for clarinet and piano, successors to the concertos and concertino for Baermann.
Aufforderung zum Tanz (Invitation to the Dance) is a charming programme piece following the progress of an invitation to dance, as a young man escorts his partner to the dance-floor and engages in polite conversation. Weber‘s other piano compositions include four sonatas for the instrument.