SELECT
    id as Identificador,
    fecha as Fecha, 
    DAY(fecha) as Dia, 
    MONTH(fecha) as Mes, 
    YEAR(fecha) as Ano,
    Hora as Hora,
    usuario_login as Usuario,
    accion as Accion
FROM core_auditoria
WHERE 1=1
LIMIT 0,5000
