SELECT /* SLOW_OK */ DISTINCT actor_name AS user, COUNT(image.img_name) as img_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

    WHERE

        categorylinks.cl_to = "Media_from_WikiDaheim_2025_in_Austria_not_for_prejury"

        and revision.rev_parent_id = 0

​

    GROUP BY user 

    ORDER BY img_count DESC limit 300;