österreichbezogen and hard-working

SQL

USE dewiki_p;

SELECT /* SLOW_OK */ DISTINCT a1.actor_name AS user, COUNT(r1.rev_parent_id) as edit_count 
    FROM page AS p1
         JOIN categorylinks AS cl1 ON p1.page_id=cl1.cl_from
         join revision as r1 on p1.page_id = r1.rev_page
         join actor as a1 on a1.actor_id = r1.rev_actor
    WHERE
        # rev_timestamp >= 20200101000000 
        # (week, -2, GETDATE())
        rev_timestamp >= DATE_FORMAT(DATE_ADD(CURRENT_TIMESTAMP(), INTERVAL -2 Week),'%Y%m%d000000')
        and edit_count > 5
        AND a1.actor_name NOT LIKE "%bot%" AND actor_name NOT LIKE "%Bot%"
        AND cl1.cl_to = "Wikipedia:österreichbezogen" 
    GROUP BY user 
    ORDER BY edit_count DESC limit 500;
SQL

Checking query status...
