EXPLAIN SELECT pl.*, p.affiliate FROM purchaseledger pl INNER JOIN purchase p ON pl.purchase_id=p.id 
WHERE p.liveon >= '2008-01-25 00:00:00' and p.liveon <= '2008-02-01 23:59:59'
                        and pl.status='a'
                        and p.status<>'d'
                        order by created desc;

+----+-------------+-------+--------+-----------------------+---------+---------+---------------------------+--------+-----------------------------+
| id | select_type | table | type   | possible_keys         | key     | key_len | ref                       | rows   | Extra                       |
+----+-------------+-------+--------+-----------------------+---------+---------+---------------------------+--------+-----------------------------+
|  1 | SIMPLE      | pl    | ALL    | purch_id,purchase_id  | NULL    |    NULL | NULL                      | 257312 | Using where; Using filesort |

|  1 | SIMPLE      | p     | eq_ref | PRIMARY,status_liveon | PRIMARY |       4 | store_wtso.pl.purchase_id |      1 | Using where                 |
+----+-------------+-------+--------+-----------------------+---------+---------+---------------------------+--------+-----------------------------+