Wikipedians by WikiProject tracking

SQL

select * from pagelinks where pl_from=64258150 and pl_namespace=6
-- Exclude redlinks
and exists (select 1 from page where page_namespace=6 and page_title=pl_title 
            -- Exclude OTRS files
            and not exists (select 1 from templatelinks where tl_from=page_id and tl_namespace=10 and tl_title="OTRS_permission"));
-- Exclude F6 deletions
and not exists (select 1 from revision join comment_revision on comment_text=rev_comment_id
                join actor_revision on actor_id=rev_actor
                where page_namespace=6 and page_title=pl_title and actor_name="Whpq" and comment_text like "%F6%")
SQL

Checking query status...
