zonas/obras -> Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'antonio9_sitio.HtmTxt.title' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT HtmPage.seccao, HtmTxt.title, HtmTxt.txt, YEAR(PObras.data), HtmTxt.canonico, HtmMedia.thumb FROM HtmTxt,HtmCat,PObras,HtmPage LEFT JOIN (HtmMedia) ON (HtmMedia.Pag=HtmPage.Pag AND HtmMedia.classf='pag' AND HtmMedia.tipo='image') WHERE HtmPage.seccao='discos' AND HtmCat.Cat='5' AND HtmTxt.Pag=HtmPage.Pag AND HtmCat.Pag=HtmPage.Pag AND PObras.Pag=HtmPage.Pag AND HtmPage.stat IN ('dst','pub') AND HtmTxt.lang=(SELECT lang FROM HtmTxt WHERE HtmTxt.Pag=HtmPage.Pag ORDER BY CASE WHEN HtmTxt.lang = 'pt' THEN 1 WHEN HtmTxt.lang = 'en' THEN 2 WHEN HtmTxt.lang = 'pt' THEN 3 ELSE 4 END ASC LIMIT 1) GROUP BY HtmPage.Pag ORDER BY PObras.data DESC
Graffiti [just Forms], Six Portraits of Pain, Acting Out
Graffiti [just Forms], Six Portraits of Pain, Acting Out

Compositor, Músico, Ensaísta, Investigador do CES, Professor na ESML

Graffiti [just Forms], Six Portraits of Pain, Acting Out

Graffiti [just Forms], Six Portraits of Pain,
2008
Numérica NUM 1166
Graffiti [just forms]:
Live recording, 23/09/2007, Casa da Música, Porto
Porto National Orchestra, Baldur Brönnimann (conductor)

Six Portraits of Pain:
Studio recording, 19/04/2007, Casa da Música, Porto
Remix Ensemble, Anssi Karttunen (cello), Frank Ollu (conductor)

Acting Out:
Live recording, 23/02/2002, Culturgest, Lisbo
Porto National Orchestra, Miguel Henriques (piano), Elizabeth Davies (percussion), Martin André (conductor)

Credits

Cello - Anssi Karttunen (tracks: 2)
Composed By - António Pinho Vargas
Conductor - Baldur Brönnimann (tracks: 1), Franck Ollu (tracks: 2), Martin André (tracks: 3)
Design [Graphic Design] - André Cruz (2)
Edited By, Mixed By - Fernando Rocha (tracks: 1, 2)
Ensemble - Remix Ensemble (tracks: 2)
Liner Notes [English Translation] - Richard Brunner (2)
Liner Notes [Portuguese] - Augusto M. Seabra
Mastered By - Fernando Rocha
Orchestra - Orquestra Nacional do Porto (tracks: 1, 3)
Percussion - Elizabeth Davis (4) (tracks: 3)
Piano - Miguel Henriques (2) (tracks: 3)
Producer [Musical Production] - António Pinho Vargas (tracks: 1), Fredrick Gifford (tracks: 2)
Recorded By - Fernando Nunes (tracks: 3), Joăo Nuno Silva (tracks: 2), Rui Borges (2) (tracks: 3)


Discografia de António Pinho Vargas

© 2013 António Pinho Vargas. Reservados todos os direitos. All rights reserved.
Desenvolvido por Luis_Pinto @ Cowork, Design Carlos Pinto