Primary topic set-index articles

SQL

SELECT
  CONCAT("[[",si.page_title,"]]") AS SetIndex,
  b.cl_to AS SiType,
  CONCAT("[[",dab.page_title,"]]") AS Dab
FROM page AS si
LEFT JOIN categorylinks AS b ON b.cl_from=si.page_id AND b.cl_to LIKE "%name%"
JOIN categorylinks AS a ON a.cl_from=si.page_id AND a.cl_to IN ("All_set_index_articles")
JOIN page AS dab ON dab.page_namespace=0 AND dab.page_title = CONCAT(si.page_title, "_(disambiguation)")
JOIN page_props  ON pp_page=dab.page_id  AND pp_propname="disambiguation"
WHERE si.page_namespace=0
GROUP BY SetIndex

SQL

Checking query status...