Dates SQL

console.sql

SELECT * FROM asterisk.cdr main
WHERE DATE(main.calldate) BETWEEN '2015-07-01' AND '2015-07-30'
AND main.record_id IN (
  SELECT item.record_id FROM asterisk.cdr item
  WHERE item.calldate IS NOT NULL
        AND HOUR(item.calldate) BETWEEN '8:00:00' AND '21:00:00'
);


SELECT * FROM asterisk.cdr;


SELECT item.record_id FROM asterisk.cdr item
WHERE item.calldate IS NOT NULL
      AND HOUR(item.calldate) BETWEEN '8:00:00' AND '21:00:00';