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





	Joaquin Rodrigo (Composer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Joaquin Rodrigo (Composer)

Joaquin Rodrigo (Composer)

Composer
Joaquin Rodrigo Vidre (22 November 1901 – 6 July 1999) was a Spanish composer of classical music and a virtuoso pianist. Despite being blind from an early age, he achieved great success. Rodrigo is considered to be among the composers most responsible for popularizing classical guitar music, and his Concierto de Aranjuez is one of the pinnacles of the Spanish and guitar concerto repertoire.

Life
He was born in Sagunto, Valencia, and lost his sight almost completely at the age of three after contracting diphtheria. He began to study piano and violin at the age of eight, but despite being best known for his guitar music, he never mastered the instrument himself.

Rodrigo studied music under Francisco Antich in Valencia and under Paul Dukas in Paris. After briefly returning to Spain, he went to Paris again to study musicology, first under Maurice Emmanuel and then under Andre Pirro. In 1925 he received Spain‘s National Prize for Orchestra for Cinco piezas infantiles [Five Children‘s Pieces]. From 1947 Rodrigo was a professor of music history, holding the Manuel de Falla Chair of Music in the Faculty of Philosophy and Letters, at Complutense University of Madrid.

His most famous work, Concierto de Aranjuez, was composed in 1939 in Paris. It is a concerto for solo classical guitar and orchestra. The central adagio movement is one of the most recognizable in 20th century classical music, featuring the interplay of guitar with English horn. Miles Davis adapted this movement for his 1960 album Sketches of Spain.

The success of this concerto led to commissions from a number of prominent soloists, including the flautist James Galway and the cellist Julian Lloyd Webber with his Cello Concerto. In 1954 Rodrigo composed Fantasia para un gentilhombre at the request of Andres Segovia. His Concierto Andaluz, for four guitars and orchestra, was commissioned by Celedonio Romero for himself and his three sons.

In 1991, Rodrigo was raised to the nobility by King Juan Carlos; he was given the title Marques de los Jardines de Aranjuez [Marquis of the Gardens of Aranjuez]. He received the prestigious Prince of Asturias Award—Spain‘s highest civilian honor—in 1996. He was named Commander of the Order of Arts and Letters by the French government in 1998.

He married Victoria Kamhi, a Turkish-born pianist, on 19 January 1933, in Valencia. Their daughter, Cecilia, was born 27 January 1941. Rodrigo died in 1999 in Madrid at the age of 97. Joaquin Rodrigo and his wife Victoria are buried at the cemetery at Aranjuez.