Foo and Foos are different articles

Find Wikipedia articles where "foo" and "foos" are different articles.  Will use this list to determine where links to [[foos]] should be changed to [[foo]]s.  (e.g. changing [[peanuts]] to [[peanut]]s when linking to the food instead of the comic strip).

SQL

USE enwiki_p;
SELECT singular.page_title singulartitle, derived.page_title pluraltitle
FROM page singular
INNER JOIN 
  (SELECT plural.page_title FROM page plural WHERE plural.page_title LIKE '%s' AND plural.page_title NOT LIKE '%\_%'
      AND plural.page_title > 'A'
      AND plural.page_namespace=0 AND plural.page_is_redirect=0) derived
  ON derived.page_title = CONCAT(singular.page_title,'s')
WHERE singular.page_namespace=0 AND singular.page_is_redirect=0
ORDER BY singular.page_title
LIMIT 500 OFFSET 500

SQL

Checking query status...