MOS redirect check

SQL

use enwiki_p;
#First query: "WP:MOS:" redirects where no "MOS:" redirect exists
select page_title, rd_title, rd_namespace from page join redirect on page_id = rd_from
where page_is_redirect = 1 and page_namespace = 4 and page_title like "MOS:%"
and page_title not in (select page_title from page where page_namespace = 0);
                       
#Second query: "WP:MOS:" redirects where no "WP:MOS" redirect exists
select page_title, rd_title, rd_namespace from page join redirect on page_id = rd_from
where page_is_redirect = 1 and page_namespace = 4 and page_title like "MOS:%"
and replace(page_title,"MOS:","MOS") not in (select page_title from page where page_namespace = 4);

#Third query: "WP:MOS" redirects where no "MOS:" redirect exists
select page_title, rd_title, rd_namespace from page join redirect on page_id = rd_from
where page_is_redirect = 1 and page_namespace = 4 and page_title like "MOS%" and page_title not regexp "MOS(:|-|\/)"
and replace(page_title,"MOS","MOS:") not in (select page_title from page where page_namespace = 0);

#Fourth query: "WP:MOS" redirects where no "WP:MOS:" redirect exists
select page_title, rd_title, rd_namespace from page join redirect on page_id = rd_from
where page_is_redirect = 1 and page_namespace = 4 and page_title like "MOS%" and page_title not regexp "MOS(:|-|\/)"
and replace(page_title,"MOS","MOS:") not in (select page_title from page where page_namespace = 4);

#Fifth query: "MOS:" redirects where no "WP:MOS:" redirect exists
select page_title, rd_title, rd_namespace from page join redirect on page_id = rd_from
where page_is_redirect = 1 and page_namespace = 0 and page_title like "MOS%"
and page_title not in (select page_title from page where page_namespace = 4);

#Sixth query: "MOS:" redirects where no "WP:MOS" redirect exists
select page_title, rd_title, rd_namespace from page join redirect on page_id = rd_from
where page_is_redirect = 1 and page_namespace = 0 and page_title like "MOS%"
and replace(page_title,"MOS:","MOS") not in (select page_title from page where page_namespace = 4);
SQL

Checking query status...
