SELECT
    calldate as FECHA_LLAMADAS,
    clid as CLIENTE,
    disposition as ESTADO
FROM
    cdr
WHERE
    calldate >= DATE_SUB(NOW(), INTERVAL 1 HOUR) AND
    disposition="NO ANSWER"