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_namespace = 118
-- 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, page_id from page
-- where page_is_redirect = 0 and page_namespace = 0
-- and page_id in (select cl_from from categorylinks where cl_to like 'Redirects\_%')
-- limit 10;

select * from categorylinks
where cl_from in (61617582, 37071444, 62350699, 38847787, 38285519);

-- select distinct cl_to from categorylinks where cl_to like 'Redirects\_%'
SQL

Checking query status...
