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='145' 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
Nocturno/Diurno em Moscovo
Nocturno/Diurno em Moscovo

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

Nocturno/Diurno em Moscovo

16 de Janeiro 2009 15:24

10 de Novembro 2009 20:01
23 de Outubro 2009 14:52
05 de Outubro 2009 13:13
05 de Outubro 2009 13:12
04 de Agosto 2009 14:41
04 de Junho 2009 23:28
28 de Abril 2009 09:18
28 de Abril 2009 09:02
28 de Janeiro 2009 15:22
16 de Janeiro 2009 15:24
16 de Janeiro 2009 15:22
© 2013 António Pinho Vargas. Reservados todos os direitos. All rights reserved.
Desenvolvido por Luis_Pinto @ Cowork, Design Carlos Pinto