Public feed
#887920
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 |
+----+-------------+-------+--------+-----------------------+---------+---------+---------------------------+--------+-----------------------------+