CSD G14 redirects watchlist

SQL

/*
select count(distinct page_id) from category
join categorylinks on cl_to = cat_title and cl_type = 'page'
join page on cl_from = page_id and page_namespace = 0
where cat_title rlike '^list|[^a-z]list' collate utf8_general_ci
or cat_title in ("All_disambiguation_pages", "All_set_index_articles");
*/

select p1.page_title, p2.page_title from redirect
join page p1 on p1.page_id = rd_from and p1.page_is_redirect = 1 and p1.page_namespace = 0
join page p2 on p2.page_title = rd_title and p2.page_namespace = rd_namespace and p2.page_is_redirect = 0 and p2.page_namespace = 0
where rd_namespace = 0 and p1.page_title like "%\_(disambiguation)"
and p2.page_id not 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")
);
SQL

Checking query status...
