Primary topic set-index articles

SQL

SELECT
  CONCAT("[[",si.page_title,"]]") AS SetIndex,
  /*GROUP_CONCAT(b.cl_to SEPARATOR ", ")*/b.cl_to AS SiType,
  CONCAT("[[",dab.page_title,"]]") AS Dab
FROM page AS si
JOIN categorylinks AS a ON a.cl_from=si.page_id AND a.cl_to IN ("All_set_index_articles")
LEFT JOIN categorylinks AS b ON b.cl_from=si.page_id AND b.cl_to LIKE "%name%"
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...
