zonas/album -> 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.Pag, HtmTxt.title FROM HtmMedia, HtmTxt, HtmPage WHERE HtmPage.ParId='60' AND HtmMedia.tipo='image' AND HtmTxt.Pag=HtmMedia.Pag AND HtmPage.Pag=HtmMedia.Pag AND HtmTxt.lang=(SELECT lang FROM HtmTxt WHERE HtmTxt.Pag=HtmTxt.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 HtmMedia.Pag ORDER BY HtmMedia.Mid DESC LIMIT 0, 1

zonas/albuns -> 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, HtmTxt.title, HtmMedia.Mid, HtmMedia.Pag FROM HtmMedia, HtmTxt, HtmPage, HtmLog WHERE HtmPage.Pag!='' AND HtmMedia.tipo='image' AND HtmTxt.Pag=HtmMedia.Pag AND HtmLog.Pag=HtmMedia.Pag AND HtmPage.Pag=HtmMedia.Pag AND HtmPage.ParId=60 AND HtmTxt.lang=(SELECT lang FROM HtmTxt WHERE HtmTxt.Pag=HtmTxt.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 HtmMedia.Pag ORDER BY HtmMedia.ord
António Pinho Vargas - Fotografias
António Pinho Vargas - Fotografias

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

Fotografias

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