rendered paste body+----+-------------+----------+------+----------------------+---------+---------+------------------------------------------------------+-------+----------------------------------------------+
| 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.ACCOUNTS.ACCT_ID | 10 | |
+----+-------------+----------+------+----------------------+---------+---------+------------------------------------------------------+-------+----------------------------------------------+