SELECT
	DATE(calldate),
	COUNT(*)
FROM cdr
WHERE
	dst='09065753601'
	AND NOW() - INTERVAL 7 DAY <= calldate
	AND calldate < NOW() - INTERVAL 6 DAY
UNION
SELECT
	DATE(calldate),
	COUNT(*)
FROM cdr
WHERE
	dst='09065753601'
	AND NOW() - INTERVAL 6 DAY <= calldate
	AND calldate < NOW() - INTERVAL 5 DAY
UNION
SELECT
	DATE(calldate),
	COUNT(*)
FROM cdr
WHERE
	dst='09065753601'
	AND NOW() - INTERVAL 5 DAY <= calldate
	AND calldate < NOW() - INTERVAL 4 DAY
UNION
SELECT
	DATE(calldate),
	COUNT(*)
FROM cdr
WHERE
	dst='09065753601'
	AND NOW() - INTERVAL 4 DAY <= calldate
	AND calldate < NOW() - INTERVAL 3 DAY
UNION
SELECT
	DATE(calldate),
	COUNT(*)
FROM cdr
WHERE
	dst='09065753601'
	AND NOW() - INTERVAL 3 DAY <= calldate
	AND calldate < NOW() - INTERVAL 2 DAY
UNION
SELECT
	DATE(calldate),
	COUNT(*)
FROM cdr
WHERE
	dst='09065753601'
	AND NOW() - INTERVAL 2 DAY <= calldate
	AND calldate < NOW() - INTERVAL 1 DAY
UNION
SELECT
	DATE(calldate),
	COUNT(*)
FROM cdr
WHERE
	dst='09065753601'
	AND NOW() - INTERVAL 1 DAY <= calldate
	AND calldate < NOW()
UNION
SELECT
	DATE(calldate),
	COUNT(*)
FROM cdr
WHERE
	dst='09065753601'
	AND NOW() <= calldate
	AND calldate < NOW() + INTERVAL 1 DAY;