WikiDaheim correctors 2019 (after first revision)

Fork of WikiDaheim correctors 2019 (after first revision) by Herzi Pinki

This query is marked as a draft This query has been published by Herzi Pinki.

Count the number of edits on WikiDaheim images after upload. This will include edits on own previously uploaded images as well as edits on images of other users.

SQL

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
        and user_groups.ug_user = actor.actor_id
        and user_groups.ug_group = 'bot'
        AND categorylinks.cl_to = "Media_from_WikiDaheim_2019_in_Austria/all" 
    GROUP BY user 
    ORDER BY edit_count DESC limit 200;

SQL

Checking query status...