Miscellany

select DATE(x.calldate), (select count(*) FROM cdr WHERE dst='09065753601' AND date(calldate) = date(x.calldate)) AS foo from cdr x WHERE calldate < ADDDATE(now(),INTERVAL 1 DAY) AND calldate >= SUBDATE(now(),INTERVAL 7 DAY) GROUP BY DATE(x.calldate) ORDER BY x.calldate DESC;mysql> explain cdr;+-------------+--------------+------+-----+---------------------+-------+| Field       | Type         | Null | Key | Default             | Extra |+-------------+--------------+------+-----+---------------------+-------+| uniqueid    | varchar(32)  | NO   |     |                     |       | | userfield   | varchar(255) | NO   |     |                     |       | | accountcode | varchar(20)  | NO   | MUL |                     |       | | src         | varchar(80)  | NO   |     |                     |       | | dst         | varchar(80)  | NO   | MUL |                     |       | | dcontext    | varchar(80)  | NO   |     |                     |       | | clid        | varchar(80)  | NO   |     |                     |       | | channel     | varchar(80)  | NO   |     |                     |       | | dstchannel  | varchar(80)  | NO   |     |                     |       | | lastapp     | varchar(80)  | NO   |     |                     |       | | lastdata    | varchar(80)  | NO   |     |                     |       | | calldate    | datetime     | NO   | MUL | 0000-00-00 00:00:00 |       | | duration    | int(11)      | NO   |     | 0                   |       | | billsec     | int(11)      | NO   |     | 0                   |       | | disposition | varchar(45)  | NO   |     |                     |       | | amaflags    | int(11)      | NO   |     | 0                   |       | +-------------+--------------+------+-----+---------------------+-------+16 rows in set (0.00 sec)