+----+-------------+----------+------+----------------------+---------+---------+--------------------------------------  ----------------+-------+----------------------------------------------+
| id | select_type | table    | type | possible_keys        | key     | key_len | ref                                                    | rows  | Extra                                        |
+----+-------------+----------+------+----------------------+---------+---------+--------------------------------------  ----------------+-------+----------------------------------------------+
|  1 | SIMPLE      | ACCOUNTS | ALL  | ACCT_DUPLICATE       | NULL    | NULL    | NULL                                                   | 16895 | Using where; Using temporary; Using filesort |
|  1 | SIMPLE      | INVOICES | ref  | PRIMARY,COLLECTOR_ID | PRIMARY | 14      | PORTER.ACCOUNTS.COLLECTOR_ID,PORTER.A  CCOUNTS.ACCT_ID |    10 |                                              |
+----+-------------+----------+------+----------------------+---------+---------+--------------------------------------  ----------------+-------+----------------------------------------------+