district redirs

SQL

select page_title,page_touched from page join redirect on page_id=rd_from where page_namespace=0 and page_is_redirect=1 and page_title like "%District%" and rd_title=replace(page_title,"District","district") and page_id not in (select cl_from from categorylinks where cl_to="Redirects_from_other_capitalisations") order by page_touched asc;
select page_title,page_touched from page join redirect on page_id=rd_from where page_namespace=0 and page_is_redirect=1 and page_title like "%Subdistrict%" and rd_title=replace(page_title,"Subdistrict","subdistrict") and page_id not in (select cl_from from categorylinks where cl_to="Redirects_from_other_capitalisations") order by page_touched asc;
SQL

Checking query status...
