Untitled query #78567

SQL

SET @PAGELENGTH_MIN = 10000;
SET @PAGE_CREATION_START = "2021-11-01";
SET @REGISTRATION_START = "2020-01-01";
SET @ARTICLE_SPACE = 0;
SET @TALK_SPACE = 1;

SELECT user_name,count(*) as pages
FROM page pageA,revision,categorylinks,page pageB,actor,user#,ipblocks
where pageB.page_title = pageA.page_title
and cl_from=pageA.page_id
and cl_to in ("Japanese_female_rugby_union_players")
#and revision.rev_timestamp > @PAGE_CREATION_START
and revision.rev_page = pageB.page_id
and revision.rev_parent_id = 0  # NEW PAGE CREATION
and revision.rev_actor = actor.actor_id
and user.user_id = actor.actor_user
#and user.user_registration > @REGISTRATION_START
and pageA.page_namespace = @ARTICLE_SPACE
and pageB.page_namespace = @ARTICLE_SPACE 
and pageB.page_is_redirect = 0
#and pageB.page_len < @PAGELENGTH_MIN
#and not exists(
    # Filter out blocked users 
#    select 1 from ipblocks 
#    where user_id=ipb_user # BLOCKED USER
#)

group by user_name
ORDER BY pages desc #revision.rev_timestamp desc
limit 150
SQL

Checking query status...
