Untitled query #78567

SQL

SET @PAGELENGTH_MIN = 7500;
SET @PAGE_CREATION_START = "2022-11-01";
SET @REGISTRATION_START = "2022-01-01";
SET @ARTICLE_SPACE = 0;
SET @TALK_SPACE = 1;
SET @CAT = "Category:European rugby union players";
SET @CAT_UNDERSCORE = REPLACE(@CAT," ","_");

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 = @CAT_UNDERSCORE
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 = @TALK_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...
