österreichbezogen and hard-working

SQL

#USE dewiki_p;

SELECT /* SLOW_OK */ DISTINCT a1.actor_name AS user, u1.user_editcount, COUNT(r1.rev_parent_id) as oe_edit_count, COUNT(r1.rev_parent_id)/u1.user_editcount as ratio, DATE_FORMAT(u1.user_registration,'%Y-%m-%d') as registered_since
    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
         join user as u1 on u1.user_id = a1.actor_user

    WHERE
        r1.rev_timestamp >= DATE_FORMAT(DATE_ADD(CURRENT_TIMESTAMP(), INTERVAL -4 week),'%Y%m%d000000')
        and u1.user_registration >= DATE_FORMAT(DATE_ADD(CURRENT_TIMESTAMP(), INTERVAL -4 year),'%Y%m%d000000')
        AND a1.actor_name NOT LIKE "%bot%" AND actor_name NOT LIKE "%Bot%"
        AND cl1.cl_to = "Wikipedia:österreichbezogen" 
    GROUP BY user 
    having oe_edit_count > 5
    ORDER BY oe_edit_count DESC limit 500;
SQL

Checking query status...
