Unnamed

mysql> EXPLAIN  SELECT
    ->                                                         (c.billsec/60) AS ttime,
    ->                                                         c.dst AS dest,
    ->                                                         UNIX_TIMESTAMP(c.calldate) AS ctime,
    ->                                                         c.accountcode AS accountcode,
    ->                                                 
    ->                                                         n.rc AS city,
    ->                                                         n.region AS state
    ->                                                 FROM
    ->                                                         cdr c
    ->                                                 LEFT JOIN
    ->                                                         npanxx n
    ->                                                 ON
    ->                                                         c.dst LIKE CONCAT(n.npanxx,"%")
    ->                                                 WHERE
    ->                                                         c.lastapp = 'Dial'
    ->                                                 AND  
    ->                                                         c.disposition = 'ANSWERED'
    ->                                                 AND
    ->                                                         c.accountcode IS NOT NULL
    ->                                                 AND
    ->                                                         c.accountcode NOT LIKE ''
    ->                                                 AND
    ->                                                         (c.src = '7094' OR c.userfield = '7094')
    ->                                                AND
    ->                                                         (c.calldate BETWEEN '2008-04-11 00:00:00' AND '2008-04-11 23:59:59')
    -> ;
+----+-------------+-------+------+---------------+------+---------+------+--------+-------------+
| id | select_type | table | type | possible_keys | key  | key_len | ref  | rows   | Extra       |
+----+-------------+-------+------+---------------+------+---------+------+--------+-------------+
|  1 | SIMPLE      | c     | ALL  | NULL          | NULL | NULL    | NULL | 115780 | Using where | 
|  1 | SIMPLE      | n     | ALL  | NULL          | NULL | NULL    | NULL | 975934 |             | 
+----+-------------+-------+------+---------------+------+---------+------+--------+-------------+
2 rows in set (0.00 sec)