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='51' AND HtmMedia.classf='pag' AND HtmMedia.tipo='image' GROUP BY HtmMedia.Pag LIMIT 0, 1

zonas/criticas -> Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'antonio9_sitio.HtmTxt.canonico' 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.canonico, T.menu, HtmTxt.title, HtmTxt.txt, YEAR(HtmLog.actual), HtmTxt.canonico, HtmMedia.thumb FROM HtmTxt,HtmLog,PCategorias,HtmTxt T,HtmCat,HtmPage LEFT JOIN (HtmMedia) ON (HtmMedia.Pag=HtmPage.Pag AND ((HtmMedia.classf='pag' AND HtmMedia.tipo='image') OR (HtmMedia.classf='vid' AND HtmMedia.tipo='emb'))) WHERE HtmPage.seccao='criticas' AND HtmCat.Pag=HtmPage.Pag AND PCategorias.Cat=HtmCat.Cat AND HtmTxt.Pag=HtmPage.Pag AND HtmLog.Pag=HtmPage.Pag AND HtmPage.stat='dst' 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) AND T.Pag=PCategorias.Pag AND T.lang=(SELECT lang FROM HtmTxt WHERE HtmTxt.Pag=PCategorias.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 HtmLog.actual DESC
António Pinho Vargas - Criticas
António Pinho Vargas - Criticas

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

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