New users of WikiDaheim 2018

SQL

USE commonswiki_p;

SELECT /* SLOW_OK */ DISTINCT rev_user_text AS user, COUNT(image.img_name) as img_count 
    FROM logging, revision, image, page, categorylinks 
    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 logging.user = revision.user
        and logging.log_action = 'create' AND logging.log_type = 'newusers'
        and log_timestamp > 20180630220000
        AND categorylinks.cl_to = "Media_from_WikiDaheim_2018_in_Austria/all" 
    GROUP BY user 
    ORDER BY img_count DESC;
SQL

Checking query status...
