Wikipedians by WikiProject tracking

SQL

select page_title 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 page_title 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 page_title 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"));
            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"))
SQL

Checking query status...
