Error:
SELECT
g.id, g.datacriacao, g.titulo,g.descricao, g.urlamigavel, g.idcategorias, c.titulo as categoria, c.urlamigavel as urlcategoria, i.imagem
FROM
informativo AS g
LEFT JOIN informativoimagens AS i ON (g.imagem = i.id)
LEFT JOIN informativocategorias AS c ON (g.idcategorias = c.id )
where
c.status = 1 and g.status = 1 and g.id not in ("")
ORDER BY
g.datacriacao desc, g.titulo, c.titulo
limit 4
Error:
select distinct id, datacriacao, titulo, descricao, ano,mes, dia,dataextenso,link,imagem from (
(
select * from programacao where mes = date_format(now(), '%m') and dia >= date_format(now(), '%d') and ano = date_format(now(), '%Y') and status = 1
)union all(
select * from programacao where mes = date_format(now(), '%m') and ano = date_format(now(), '%Y') and destaque = 1 and status = 1
)
) as resultado
where
dia >= date_format(now(), '%d')
order by dia
limit 8
