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





	Jacques Offenbach (Composer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Jacques Offenbach (Composer)

Jacques Offenbach (Composer)

The son of a Cologne synagogue cantor, Offenbach and his violinist brother Julius were trained at the Paris Conservatoire, and Jacques Offenbach thereafter found employment initially as a cellist at the Opera-Comique followed by a successful early career as a virtuoso on the instrument, for which he wrote a number of works, including a Concerto militaire and a Concertino. He was for five years conductor at the Theatre Francais, but in 1855 rented his own theatre, where his early light-hearted stage-works were performed. He continued a successful career devoted largely to operetta and operas comiques until his death in 1880.
Of nearly a hundred lighter pieces for the stage, Orphee aux enfers (Orpheus in the Underworld) is best known, in particular for its famous can-can. Other operettas include La belle Helene (Fair Helen) and La vie parisienne. Of a weightier cast is Offenbach‘s final opera, Les contes d‘Hoffmann (The Tales of Hoffmann), completed after the composer‘s death by Bizet‘s friend Guiraud and based, as the title suggests, on stories by E.T.A. Hoffmann, including the tale of Dr. Coppelius and his life-like creation, the doll Coppelia.