Untitled query #73454

SQL

select
	page_id,
    page_title,
    page_namespace,
    actor_name,
    count(actor_id) as contribs
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
    INNER JOIN user ON user_id = actor_user
where
	page_is_redirect = 0 and
    (page_namespace != 0 or rev_timestamp >= 20230401000000) and
    (page_namespace = 0 or page_latest = rev_id) and
    cl_to in ("Pałac_Kultury_i_Nauki") AND
	user_id NOT IN (
    	SELECT ug_user
        FROM user_groups
        WHERE ug_group = "bot"
    )
group by
	actor_id, page_id
order by
	contribs desc;
SQL

Checking query status...
