Untitled query #32834

SQL

USE commonswiki_p;
describe user;
describe revision;
select * from user where user_name in ["Petwoe", "Schurdl", "Kries"];

SELECT /* SLOW_OK */ DISTINCT rev_user_text AS username, user.user_registration as registration, COUNT(image.img_name) as img_count 
    FROM revision, image, page, categorylinks, user
    WHERE page.page_id=categorylinks.cl_from
        AND image.img_name = page.page_title
        and revision.rev_page = page.page_id
        and revision.rev_parent_id = 0
        AND categorylinks.cl_to = "Media_from_WikiDaheim_2017_in_Austria/all" 
        and user.user_id = revision.rev_user
    GROUP BY username 
    ORDER BY img_count DESC limit 300;
SQL

Checking query status...
