#USE commonswiki_p;

​

SELECT /* SLOW_OK */ DISTINCT actor_name AS user, COUNT(revision.rev_parent_id) as edit_count 

    FROM actor, /*user_groups,*/ revision, revision as revision0, image, page, categorylinks 

    WHERE page.page_id=categorylinks.cl_from

        AND actor.actor_id = revision.rev_actor

        AND image.img_name = page.page_title

        and revision.rev_page = page.page_id

        and revision.rev_parent_id > 0

        and revision0.rev_parent_id = 0

        and revision.rev_page = revision0.rev_page

        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;