Finding entries for a DAB page

SQL

USE fawiki_p;
SELECT CONCAT ('# [[',p1.page_title,']]'),concat(mid(p1.page_title, 1, locate('_(', p1.page_title)),'('),count(p1.page_title)
FROM page AS p1
WHERE p1.page_namespace=0
AND p1.page_is_redirect=0
AND p1.page_title LIKE "_%\_(%"

AND mid(p1.page_title, 1, locate('_(', p1.page_title) - 1) IN (
  SELECT mid(page_title, 1, locate('_(', page_title) - 1)
  FROM page
  WHERE page_namespace = 0
  and page_is_redirect = 0
  GROUP BY page_title
#      having count(mid(page_title, 1, locate('_(', page_title) - 1)) > 1
) 

ORDER BY p1.page_title
LIMIT 500;
SQL

Checking query status...
