SELECT
  m.id, m.numero, m.ano, m.tipo, m.titulo, m.created_at
FROM materias m
WHERE m.autor_id = :usuario_id
  AND DATE(m.created_at) BETWEEN :data_ini AND :data_fim
ORDER BY m.created_at DESC