SELECT
id_noticia,
titulo,
imagem,
DATE_FORMAT(data_hora_entrada,'%d') as dia,
DATE_FORMAT(data_hora_entrada,'%M') as mes,
DATE_FORMAT(data_hora_entrada,'%Y') as ano,
status
FROM tb_noticia WHERE status = 'P' ORDER BY data_hora_entrada DESC LIMIT 20, 10