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





	Max Bruch (Composer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Max Bruch (Composer)

Max Bruch (Composer)

Max Bruch

1838-1920

Max Christian Friedrich Bruch (January 6, 1838, Cologne - October 2, 1920, Friedenau, Berlin now district) - German composer and conductor.

 

Son of singer Wilhelmina Bruch, from which received first music lessons. He studied under Ferdinand Hiller (1853-1857), then studied in Leipzig Carl Reinecke.

 

In 1862-1864 gg. worked in Mannheim, here he wrote the opera "Lorelei" (1863). The second edition of the cantata "Fridtjof" (1864) brought the first success Bruch. In 1865-1867 gg. muzikdirektor in Koblenz, in the 1867-1870 biennium. the head of the court orchestra of Sondershausen, then worked in Berlin and Bonn. In 1880-1883 gg. Liverpool led the orchestra of the Royal Philharmonic Society - one of the UK's leading music groups; subsequently again returned to the UK as a conductor, having risen for two years (1898-1900) at the helm of the Scottish Orchestra.

 

In 1890-1910 gg. taught at the Berlin High School of Music, where his students included, in particular, Ottorino Respighi, Oscar Strauss and Ralph Vaughan Williams.

 

In life, Bruch certain popularity enjoyed his large-scale choral canvases - "Odyssey" (1872) and "Cross Fire" (German: Das Feuerkreuz; 1899.). Over time, however, the focus of the performers and the audience were mostly symphonic works by Bruch: his violin concertos (especially the first - Op 26, 1868 - part of the standard violin repertoire.) "Scottish Fantasy" for violin and orchestra ( Op. 46, 1880), the play "Kol Nidrei" for cello and orchestra (Op. 57, 1881) on the topic of Jewish liturgical music (especially the psalm itself Kol Nidrei).