select site_noticias.*, site_categoria_noticias.nome as categoria from (site_noticias left join site_categoria_noticias on site_categoria_noticias.codigo = site_noticias.cod_categoria) where site_noticias.codigo != '' and cod_gestao = '2' and ((concat(site_noticias.data, site_noticias.hora) <= '2022-05-2311:53') or (site_noticias.hora is null)) order by site_noticias.destaque desc, site_noticias.data desc, site_noticias.codigo desc limit 0, 10