SELECT p1.page_title, GROUP_CONCAT(pl_title SEPARATOR ', '), COUNT(pl_title) as links

FROM page p1 LEFT JOIN pagelinks ON pl_from = p1.page_id AND pl_namespace = 0

AND pl_title IN (select p2.page_title from page p2 where p2.page_namespace = 0)

-- LEFT JOIN page p2 ON p2.page_title = pl_title AND p2.page_namespace = 0

WHERE p1.page_id IN (

  select cl_from from categorylinks

  where cl_to in ("All_disambiguation_pages", "All_set_index_articles") and cl_type = 'page'

)

AND p1.page_namespace = 0 AND p1.page_is_redirect = 0

AND p1.page_title not like 'MOS:%'

AND p1.page_id not in (

  select tl_from from templatelinks where tl_target_id in (

    select lt_id from linktarget where lt_title = 'One_other_topic' and lt_namespace = 10

  )

)

GROUP BY p1.page_title

-- HAVING p1.page_title LIKE '%\_(disambiguation)' AND links < 2 OR links < 1

HAVING links < 2

ORDER BY links