Wikipedians by WikiProject tracking

SQL

-- Nonexistent
select page_title from page cat where page_namespace=14 and page_title like "WikiProject_%_members" 
and not exists (select 1 from page where page_namespace=4 and page_title=replace(cat.page_title,"_members",""))
and cat.page_title not rlike ".*task_?force.*";

select page_title from page cat where page_namespace=14 and page_title like "WikiProject_%_participants" 
and not exists (select 1 from page where page_namespace=4 and page_title=replace(cat.page_title,"_participants",""));
-- Redirect
select page_title from page cat where page_namespace=14 and page_title like "WikiProject_%_members" 
and exists (select 1 from page where page_namespace=4 and page_title=replace(cat.page_title,"_members","") and page_is_redirect=1)
and not exists (select 1 from templatelinks where tl_from=cat.page_id and tl_title="Category_redirect");

select page_title from page cat where page_namespace=14 and page_title like "WikiProject_%_participants" 
and exists (select 1 from page where page_namespace=4 and page_title=replace(cat.page_title,"_participants","") and page_is_redirect=1)
and not exists (select 1 from templatelinks where tl_from=cat.page_id and tl_title="Category_redirect");

-- Not a proper project was tried but every single page except one dab page and two soft redirects
-- ended uo being misfiled proper projects I can't be bothered to fix

-- Defunct
select concat("Category:",page_title," members") from categorylinks join page on page_id=cl_from where cl_to="Defunct_WikiProjects" 
and exists (select 1 from page cat where page_namespace=14 and 
            cat.page_title=concat(page.page_title, "_members"));
            
select concat("Category:",page_title," participants") from categorylinks join page on page_id=cl_from where cl_to="Defunct_WikiProjects" 
and exists (select 1 from page cat where page_namespace=14 and 
            cat.page_title=concat(page.page_title, "_participants"));
-- Inactive
select page_title from categorylinks join page on page_id=cl_from where cl_to="Inactive_WikiProjects" 
and exists (select 1 from page cat where page_namespace=14 and 
            cat.page_title=concat(page.page_title, "_members"));
            
select page_title from categorylinks join page on page_id=cl_from where cl_to="Inactive_WikiProjects" 
and exists (select 1 from page cat where page_namespace=14 and 
            cat.page_title=concat(page.page_title, "_participants"));
-- Active
select page_title from categorylinks join page on page_id=cl_from where cl_to="Active_WikiProjects" 
and exists (select 1 from page cat where page_namespace=14 and 
            cat.page_title=concat(page.page_title, "_members"));
            
select page_title from categorylinks join page on page_id=cl_from where cl_to="Active_WikiProjects" 
and exists (select 1 from page cat where page_namespace=14 and 
            cat.page_title=concat(page.page_title, "_participants"));
SQL

Checking query status...
