zonas/image -> Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'antonio9_sitio.HtmMedia.Mid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT HtmMedia.Mid, HtmMedia.titulo, HtmMedia.linkode FROM HtmMedia WHERE HtmMedia.Pag='219' AND HtmMedia.classf='pag' AND HtmMedia.tipo='image' GROUP BY HtmMedia.Pag LIMIT 0, 1

zonas/anos -> Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'antonio9_sitio.HtmLog.actual' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT HtmPage.seccao, YEAR(HtmLog.actual) FROM HtmTxt,HtmLog,HtmPage WHERE HtmPage.seccao='news' AND HtmTxt.Pag=HtmPage.Pag AND HtmLog.Pag=HtmPage.Pag AND HtmPage.stat IN ('pub','arq') 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 YEAR(HtmLog.actual) ORDER BY HtmLog.actual DESC
Prémio José Afonso Dia 20  António Pinho Vargas, piano solo, Recreios da Amadora às 21.30
Prémio José Afonso  Dia 20  António Pinho Vargas, piano solo, Recreios da Amadora às 21.30

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

Prémio José Afonso Dia 20  António Pinho Vargas, piano solo, Recreios da Amadora às 21.30

05 de Maio 2012 13:46

Outras Notícias

27 de Agosto 2012 21:12

António Pinho Vargas vence  Prémio Universidade de Coimbra 2012

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