Untitled query #73431

SQL

select
	page_id,
    page_title,
    page_namespace,
    actor_name,
    count(actor_id) as contribs,
    (
        select count(ug_user)
        from user_groups
        where ug_user = user_id and ug_group = "sysop"
    ) as is_sysop
from page
	left join categorylinks ON cl_from = page_id
    inner join revision on rev_page = page_id
    inner join actor on rev_actor = actor_id
    left join user on user_id = actor_user
where
	page_is_redirect = 0 and
    (page_namespace != 0 or rev_timestamp >= 20230101000000) and
    (page_namespace != 0 or rev_timestamp <= 20230101235959) and
    (page_namespace = 0 or page_latest = rev_id) and
    cl_to in ("Pisarze_katoliccy") and
    (page_namespace != 0 or user_id not in (
        select ug_user
        from user_groups
        where ug_group = "bot"
    ))
group by
	actor_id, page_id
;
SQL

Checking query status...
