CSD G14 dabpages watchlist

SQL

SELECT p1.page_title, pl_title, 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 category
  join categorylinks on cl_to = cat_title and cl_type = 'page'
  where cat_title rlike '^list|[^a-z]list' collate utf8_general_ci
  or cat_title in ("All_disambiguation_pages", "All_set_index_articles")
)
AND p1.page_namespace = 0 AND p1.page_is_redirect = 0
AND p1.page_title not like 'MOS:%'
GROUP BY p1.page_title
HAVING p1.page_title LIKE '%\_(disambiguation)' AND links < 2 OR links < 1
ORDER BY links

/*
SELECT p1.page_title, pl_title, COUNT(pl_title) as links
FROM page p1 join categorylinks on cl_from = p1.page_id and cl_type = 'page'
join category on cl_to = cat_title
and (cat_title in ("All_disambiguation_pages", "All_set_index_articles")
    or cat_title rlike '^list|[^a-z]list' collate utf8_general_ci)
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_namespace = 0 AND p1.page_is_redirect = 0
GROUP BY p1.page_title
HAVING p1.page_title LIKE '%\_(disambiguation)' AND links < 2 OR links < 1
ORDER BY links
*/
SQL

Checking query status...
