archivist

mysql> EXPLAIN SELECT
    -> a.id,
    -> a.headline,
    -> a.body,
    -> a.byline,
    -> a.bytitle,
    -> a.inserted,
    -> CONCAT('/ap/',REPLACE(REPLACE(REPLACE(a.headline,'.',''),'\'',''),' ','_')) AS url
    -> FROM
    -> sl_ap_articles a
    -> WHERE
    -> a.id IN (SELECT id FROM sl_ap_articles WHERE MATCH (headline,body) AGAINST ( 'louisville "churchill downs" "university of kentucky" "university of louisville" lexmark "frankfort kentucky" "little rock" "university of arkansas" "walmart" sams ozarks "ozark mountains" "bill clinton" "mike huckabee" "hope arkansas" chattanooga nashville memphis "vanderbilt university" "university of tennessee" ornrl "oak ridge national research laboratory" "ut vols" fedex bredesen "tenn care" raleigh "chapel hill" durham "wake forest university" "university of north carolina" "duke university" duke tarheels "atlanta georgia" "Center for Disease Contol" atlanta "delta airlines" "atlanta journal constitution" augusta "university of georgia" "georgia state university" "georgia tech" "emory university" "jimmy carter" savannah "miami florida" "orlando florida" tallahassee "tampa bay" crist "daytona beach" "south beach" "fort lauderdale" "west palm beach" "key west" destin everglades "university of florida" "florida state university" orlando "disney world" "birmingham alabama" auburn birmingham tuscaloosa montgomery Alabama Arkansas Florida Georgia Kentucky Louisiana Mississippi "North Carolina" "South Carolina" Tennessee Virginia "West Virginia" Texas' IN BOOLEAN MODE))
    -> ORDER BY
    -> inserted DESC
    -> LIMIT 2;
+----+--------------------+----------------+-----------------+---------------+----------+---------+------+------+--------------------------+
| id | select_type        | table          | type            | possible_keys | key      | key_len | ref  | rows | Extra                    |
+----+--------------------+----------------+-----------------+---------------+----------+---------+------+------+--------------------------+
|  1 | PRIMARY            | a              | index           | NULL          | inserted |       4 | NULL | 8967 | Using where              |
|  2 | DEPENDENT SUBQUERY | sl_ap_articles | unique_subquery | PRIMARY,body  | PRIMARY  |       4 | func |    1 | Using index; Using where |
+----+--------------------+----------------+-----------------+---------------+----------+---------+------+------+--------------------------+