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 where page_namespace=0 and page_is_redirect=0 and page_title like "%district%" and replace(page_title,"district","District") not in (select page_title from page where page_namespace=0 and page_is_redirect=1);
SQL

Checking query status...
