Untitled query #73486

SQL

SELECT
	#DISTINCT
    #cl_to,
    page_id,
    page_title,
    page_namespace,
    actor_name,
    #rev_id,
    COUNT(DISTINCT rev_id) as contribs,
    actor_id,
    (
        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 <= 20230131235959) AND
    (page_namespace = 0 OR page_latest = rev_id) AND
    cl_to IN ('Konwertyci_na_katolicyzm','Niezależne_Kościoły_katolickie','Pisarze_katoliccy') AND
    page_id NOT IN (0,161653,5096580,340959,141245) AND
    (page_namespace != 0 OR user_id NOT IN (
        SELECT ug_user
        FROM user_groups
        WHERE ug_group = "bot"
    )) AND
    actor_name = "MOs810"
GROUP BY
    actor_id, page_id;
SQL

Checking query status...
