stalled - Quarry

SQL

#USE commonswiki_p;

SELECT /* SLOW_OK */ DISTINCT actor_name AS user, COUNT(revision.rev_parent_id) as edit_count 
    FROM actor, /*user_groups,*/ revision, page, categorylinks 
    WHERE page.page_id=categorylinks.cl_from
        AND actor.actor_id = revision.rev_actor
        and revision.rev_page = page.page_id
        # LOWER does not work
        AND actor_name NOT LIKE "%bot%" AND actor_name NOT LIKE "%Bot%"
        /*and user_groups.ug_user = actor.actor_id
        and user_groups.ug_group != 'bot'*/
        AND (
          categorylinks.cl_to = "Ort_im_Bezirk_Amstetten" OR
          categorylinks.cl_to = "Ort_im_Bezirk_Baden_(Niederösterreich)" OR
          categorylinks.cl_to = "Ort_im_Bezirk_Bruck_an_der_Leitha" OR
          categorylinks.cl_to = "Ort_im_Bezirk_Gänserndorf" OR
          categorylinks.cl_to = "Ort_im_Bezirk_Gmünd" OR
          categorylinks.cl_to = "Ort_im_Bezirk_Hollabrunn" OR
          categorylinks.cl_to = "Ort_im_Bezirk_Horn" OR
          categorylinks.cl_to = "Ort_im_Bezirk_Korneuburg" OR
          categorylinks.cl_to = "Ort in der Statutarstadt_Krems_an_der_Donau" OR
          categorylinks.cl_to = "Ort_im_Bezirk_Krems-Land" OR
          categorylinks.cl_to = "Ort_im_Bezirk_Lilienfeld" OR
          categorylinks.cl_to = "Ort_im_Bezirk_Melk" OR
          categorylinks.cl_to = "Ort_im_Bezirk_Mistelbach" OR
          categorylinks.cl_to = "Ort_im_Bezirk_Mödling" OR
          categorylinks.cl_to = "Ort_im_Bezirk_Neunkirchen" OR
          categorylinks.cl_to = "Ort_im_Bezirk_Sankt_Pölten-Land" OR
          categorylinks.cl_to = "Ort_im_Bezirk_Scheibbs" OR
          categorylinks.cl_to = "Ort in der Statutarstadt_St._Pölten" OR
          categorylinks.cl_to = "Ort_im_Bezirk_Tulln" OR
          categorylinks.cl_to = "Ort_im_Bezirk_Waidhofen_an_der_Thaya" OR
          categorylinks.cl_to = "Ort in der Statutarstadt Waidhofen_an_der_Ybbs" OR
          categorylinks.cl_to = "Ort_im_Bezirk_Wiener_Neustadt-Land" OR
          categorylinks.cl_to = "Ort_im_Bezirk_Zwettl"        )
    GROUP BY user 
    ORDER BY edit_count DESC limit 200;
SQL

Checking query status...
