Kuwiki bots, sorted by edit count

Fork of Kuwiki users no bots, sorted by edit count by Balyozxane

This query is marked as a draft This query has been published by Balyozxane.

SQL

SELECT 
    ROW_NUMBER() OVER (ORDER BY user.user_editcount DESC) AS row_number,
    user.user_name,
    user.user_editcount,
    ugs.ug_group
FROM 
    user
LEFT JOIN 
    user_groups ugs ON ugs.ug_user = user.user_id
LEFT JOIN 
    user_groups ugs_bot ON ugs_bot.ug_user = user.user_id AND ugs_bot.ug_group = 'bot'
WHERE 
    ugs_bot.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...