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





	Astor Piazzolla (Composer) - uVisitRussia
	
						

				
				
				


				
				



				
				
				
				
			
			
		
				
			
Home Theaters Astor Piazzolla (Composer)

Astor Piazzolla (Composer)

Born: 11 March 1921, Mar del Plata (Argentina)
Died: 4 July 1992, Buenos Aires (Argentina)

From 1924 till 1937 Astor Piazzolla lived in New York with his parents. In 1930 he started playing the bandoneon. Later also studied piano with a student of Rachmaninov, Bela Wilda. When he returned to Argentina in 1937 he began to perform in an orchestra. In 1940 he continued his studies with Alberto Ginastera. His first orchestra was created in 1947. In 1955 he received a scholarship from the Frenach Government, which he used to study with Nadia Boulanger. She advised him to follow his origins in music. Back in Argentina Piazzolla founded two groups: "El Octeto de Buenos Aires" and "La Orquesta de Cuerdas". Despite the bad critisisms, he stuck to the music he liked.

In 1958 Piazzolla was in New York for two years, with many recordings on radio, tv and records. Back in Argentina he formed a quintet. He always thought a tango was music to listen to rather than to dance on. During the 1960‘s his music became more and more appreciated. Many artists have recorded his compositions, and he has won many prices. In 1993 he received a Grammy Award for his composition "Oblivion", which many consider Piazzolla‘s most beautiful work.