Cleanup redirects

SQL

-- select page_title from page
-- where page_id in (select cl_from from categorylinks where cl_to in ('All_disambiguation_pages'))
-- and page_namespace = 118

-- select distinct cl_to from categorylinks
-- where cl_from in (select page_id from page where page_is_redirect = 1 and page_namespace = 118)

-- select page_namespace, page_title, rd_title from page
-- join redirect on rd_from = page_id
-- where page_is_redirect = 1
-- and page_id in (select cl_from from categorylinks where cl_to in ('All_disambiguation_pages', 'All_set_index_articles'));

-- select page_namespace, page_title, rd_title from page
-- join redirect on rd_from = page_id
-- where page_is_redirect = 0
-- and page_id in (select tl_from from templatelinks where tl_target_id in (select lt_id from linktarget where lt_title in ('R_from_ambiguous_term', 'R_from_incomplete_disambiguation', 'R_to_disambiguation_page') and lt_namespace = 10));

select page_title, rd_title, page_len from page, redirect
where rd_from = page_id and page_is_redirect = 1 and page_namespace = 0
order by page_len desc limit 10;
SQL

Checking query status...
