WikiDaheim correctors 2024 (after first revision)

SQL

#USE commonswiki_p;

SELECT /* SLOW_OK */ DISTINCT actor_name AS user, COUNT(revision.rev_parent_id) as edit_count 
    FROM
    	image
        JOIN page AS page_img ON image.img_name = page_img.page_title
        JOIN categorylinks ON page_img.page_id = categorylinks.cl_from
        JOIN revision ON revision.rev_page = page_img.page_id
        JOIN actor ON actor.actor_id = revision.rev_actor
        JOIN revision as revision0 ON revision.rev_page = revision0.rev_page
    WHERE
        revision.rev_parent_id > 0
        and revision0.rev_parent_id = 0
        and revision.rev_actor != revision0.rev_actor
        # LOWER does not work
        AND actor_name NOT LIKE "%bot%" AND actor_name NOT LIKE "%Bot%"
        /*and user_groups.ug_user = actor.actor_id
        and user_groups.ug_group != 'bot'*/
        AND categorylinks.cl_to = "Media_from_WikiDaheim_2024_in_Austria/all" 
    GROUP BY user 
    ORDER BY edit_count DESC limit 200;
SQL

Checking query status...
