Wikipedians by WikiProject tracking

SQL

-- 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"));
select concat("Category:",page_title," contributors") 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, "_contributors"));
-- 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"));
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, "_contributors"));
-- 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"));
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, "_contributors"));
-- 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",""));
SQL

Checking query status...
