Optimizing a MySQL query which currently hits 129,000 rows, and uses a filesort. FAIL. Similar Entries Twitter