zonas/medias -> 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.Pag FROM HtmMedia, HtmTxt, HtmPage, HtmLog WHERE HtmPage.Pag!='451' 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
Novas Fotografias
Novas Fotografias

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

Novas Fotografias

com Orquestra
com Orquestra

Novas Fotografias

prev
  • Novas Imagens
  • Playing
  • Em Coimbra
  • Novas Imagens
  • Novas Imagens
  • Novas Imagens
  • Playing
  • Novas Imagens
  • Novas Imagens
  • com Orquestra
next
© 2013 António Pinho Vargas. Reservados todos os direitos. All rights reserved.
Desenvolvido por Luis_Pinto @ Cowork, Design Carlos Pinto