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





	Umberto Giordano (Composer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Umberto Giordano (Composer)

Umberto Giordano (Composer)


Composer


Umberto Giordano (August 28, 1867 – November 12, 1948) was an Italian composer, mainly of opera.

He was born in Foggia in Puglia, Italy and studied under Paolo Serrao at the Conservatoire of Naples. His first opera Marina, was written for the competition staged by the music publishers Casa Sonzogno for the best one-act opera, remembered today because it marked the beginning of Italian verismo; the winner was Mascagni‘s Cavalleria Rusticana. Giordano, the youngest candidate, placed sixth among seventy-three with Marina, which generated enough interest for Sonzogno to commission an opera to be staged in the 1891-92 season.

The result was Mala Vita, a gritty verismo opera concerning a labourer who vows to reform a prostitute if he is cured of his tuberculosis. This caused something of a scandal when performed at the Teatro Argentina, Rome, in February 1892. It played successfully at Vienna, Prague and Berlin.

Giordano tried a more romantic approach with his next opera, Regina Diaz (1894), but this was also a failure, taken off the stage after just two performances.

Giordano then moved to Milan, and returned to verismo with his best-known work, Andrea Chenier (1896), based on the life of the French poet, Andre Chenier. Fedora (1898), based on Victorien Sardou‘s play, featured a scarcely-known young tenor, Enrico Caruso; it was also a success, and is still performed today. His later works are much less known, but occasionally revived.

The most important theater in Foggia has been dedicated to Umberto Giordano, in which Andrea Chenier was lately performed. A square in Foggia is also dedicated to him, with many statues representing his more famous works.


[edit] Other works
Il Voto (1902)
Siberia (1903, revised 1927)
Marcella (1907)
Mese mariano (1910)
Madame Sans-Gene (1915)
La cena delle beffe (1924)
Il Re (1929)
La festa del Nilo (incomplete)
Retrieved from

Provided by Wikipedia - Umberto Giordano