Miscellany

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