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='6' 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
Nuno Pinto - Clarinete Solo
Nuno Pinto - Clarinete Solo

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

Nuno Pinto - Clarinete Solo

Nuno Pinto - Clarinete Solo
2010
Miso Music: mcd022.09
ALEXANDRE DELGADO - Langará (1992)
JOÃO PEDRO OLIVEIRA - Integrais II * (1986, rev. 1993)
PAULO BRANDÃO - Colibri (1989)
CLOTILDE ROSA - Divertimento (1987)
ANTÓNIO PINHO VARGAS - Três Fragmentos (1985/6, rev. 1994)
RICARDO RIBEIRO - Intensités * (2001, rev. 2006)
SÉRGIO AZEVEDO - On the Edge * (2008)
SÉRGIO AZEVEDO- Três Peças para cl.solo * (2006)
VIRGÍLIO MELO - Upon a Ground I * (1987)
CÂNDIDO LIMA - Ncáãncôua * (1995)

Gravado entre 14 e 17 de Julho de 2008
Recorded between 14th and 17th July of 2008

www.misomusic.com


Outros Discos

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