Untitled query #74137

SQL

USE zhwiki_p;
SELECT DISTINCT page_title
FROM page basepage
#FROM pagelinks JOIN page ON pl_title=page_title
WHERE basepage.page_is_redirect=0
AND basepage.page_namespace=0
#AND page_title like "%(消歧%"
AND EXISTS (
  SELECT 1
  FROM page dabpage
  WHERE dabpage.page_title = CONCAT(basepage.page_title, " (消歧義)")
)
/*
AND pl_from IN (
  SELECT page_id
  FROM page
  WHERE page_is_redirect=0
  AND pl_from_namespace=0
)
AND pl_namespace=0
GROUP BY pl_title HAVING COUNT(pl_from) > 5
ORDER BY COUNT(pl_from) DESC;
*/
LIMIT 100;
SQL

Checking query status...
