Wikipedians by WikiProject tracking

SQL

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

SQL

Checking query status...