Untitled query #78097

SQL

SELECT Pg.page_title, Pr.page_title, rd_title, COUNT(*)
FROM page Pg
JOIN page Pr ON Pr.page_namespace=0 AND Pr.page_title=SUBSTRING_INDEX(Pg.page_title,"_(",1) AND Pr.page_is_redirect=1
JOIN redirect ON rd_from=Pr.page_id AND rd_title!=Pg.page_title
JOIN pagelinks ON pl_from_namespace=0 AND pl_namespace=0 AND pl_title=Pr.page_title
WHERE Pg.page_namespace=0 AND Pg.page_title REGEXP "_\\((genus|plant|insect|bug|moth)\\)" AND Pg.page_is_redirect=0
GROUP BY Pg.page_title, Pr.page_title, rd_title
HAVING COUNT(*)>250
SQL

Checking query status...
