Kuwiki users no bots, sorted by edit count

This takes into account bots that don't have official bot status, but are nonetheless members of Categorie:Roboți Wikipedia. It also tells whether an account is an admin or a bot.

SQL

SELECT 
    user.user_name,
    user.user_editcount 
FROM 
    user
LEFT JOIN 
    user_groups ugs ON ugs.ug_user = user.user_id AND ugs.ug_group = 'bot'
WHERE 
    ugs.ug_user IS NULL
    AND user.user_name NOT IN (
        SELECT REPLACE(page_title, "_", " ") AS user_name 
        FROM categorylinks
        INNER JOIN page ON categorylinks.cl_from = page.page_id
        WHERE page_namespace = 2 
        AND cl_to = "Botên_Wîkîpediyayê"
    )
    AND user.user_name NOT LIKE '%bot%'
    AND user.user_name NOT LIKE '%Bot%'    
    AND user.user_name NOT LIKE '%CommonsDelinker%'    
ORDER BY user_editcount DESC
LIMIT 100;

SQL

Checking query status...