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 (1915675,1917886,1920086,1922285,1924475,1926723,1928965,1931194,1933408,1935607,1937803,1939991,1942170,1944341,1946501,1948650,1950785,1952917,1955044,1957120,1959184,1961233,1963271,1965299,1967320,1969338,1971350,1973361,1975357,1977343,1979314,1981312,1983304,1985289,1987267,1989237,1991193,1993131,1995069,1996999,1998919,2000833,2002736,2004629,2006502,2008390,2010275,2012152,2014016,2015856,2017684,2019493,2021300,2023101,2024895,2026887,2028877,2030856,2032822,2034780,2036736,2038681,2040619,2042545,2044455,2046354,2048242,2050125,2051998,2053861,2055812,2057848,2059881,2061908)) 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





	Gioacchino Rossini (Composer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Gioacchino Rossini (Composer)

Gioacchino Rossini (Composer)

Gioacchino Antonio Rossini was born in Pesaro, Italy in 1792 to musician parents. He learned the horn and singing and began his operatic writing at the age of 18 when he wrote a one-act comedy for Venice. He began to receive further commissions from Bologna, Venice and Milan. Rossini was prolific in his writing, composing up to seven operas in the span of 16 months.
Rossini‘s operas, both buffa and seria, showed his mastery of the bel canto (beautiful singing) school of composition. With florid lines, vocal embellishments, incredible speed and spontaneity, Rossini created some of the most unforgettable music in the operatic repertoire.
His first operas to win international acclaim were the serious Tancredi (1813) and the commedia dell‘arte L‘italiana in Algeri (1813). The latter work showed Rossini‘s youthful exuberance and diligence (he completed the opera at the age of 21 and in 27 days). In 1815, Rossini was hired as musical and artistic director for the Teatro San Carlo in Naples by impresario Domenico Barbaia. He composed Elisabetta, Regina d‘Inghilterra (Elizabeth, Queen of England) for soprano, Isabella Colbran (Barbaia‘s mistress, later to become Rossini‘s wife). A rather unremarkable opera, save for the overture which Rossini borrowed from his earlier, less successful opera Aureliano in Palmira. This was a trick he would repeat less than two years later where the music would find overwhelming success as the overture to Il Barbiere di Siviglia (The Barber of Seville).
It is quite probable that Beaumarchais‘ play Il Barbiere di Siviglia (The Barber of Seville) had already been in Rossini‘s mind as subject matter for his next opera. Barber was already a successful opera by composer Paisiello (Rossini publicly extolled the virtues of Paisiello‘s score). Within two months of signing the contract, Rossini‘ Barber was ready to premiere in Rome in 1816. The premiere was less than stellar with both stage mishaps and fervid Paisiello followers creating disturbances in the audience. Future performances were much smoother and Barber became admired by such composers as Beethoven, Verdi and Richard Strauss.
The next few years saw Otello (1816), La Cenerentola (Cinderella - 1817) and La Gazza Ladra (The Thieving Magpie ­ 1817). By 1822, Isabella Colbran and Rossini were married although they were not happy for very long. Rossini continued composing at a dramatic rate with seven more operas between the years 1817 and 1823. In 1823, Rossini composed Semiramide based on Voltaire‘s tragedy. Isabella created the title role and it would be the last opera Rossini would compose in Italy.
The Rossinis moved to Paris in 1823 where Rossini would compose Le Siege de Corinthe (1826), Le Compte Ory (1825) and Guillaume Tell (1829). Guillaume Tell is considered to be Rossini‘s finest opera containing some of his most inspired music, elaborate orchestrations, spectacular ballets and processions. Apparently, Rossini felt this to be the pinnacle of his operatic career and at the age of 37 stopped writing opera for the remainder of his life. He and Isabella left Paris in 1837 to live in Italy where he suffered from neurasthenia (a mental disorder with psychosomatic symptoms). Isabella died in 1845 and the next year, Rossini married Olympe Pelissier. By 1855, he and Olympe returned to Paris where he seemed to regain his health and began composing again for piano and voice.
Rossini died on November 13, 1868 in Passy, France as a universally honored composer. Il Barbiere di Siviglia remains one of the most performed operas in the world and many companies are now performing and recording some of Rossini‘s more obscure works.