Fork of Untitled query #14721 by جار الله
This query is marked as a draft This query has been published by Muhammad Abul-Futooh.

SQL

AخA
 
USE arwiki_p;
    SELECT CONCAT(actor_name) AS user_name, SUM(CAST(rev.rev_len as signed)-CAST(parent.rev_len as signed)) AS byte_count, COUNT(rev.rev_id) as edit_count
    FROM user 
    INNER JOIN revision rev ON user.user_id = rev.rev_actor
    INNER JOIN actor ON rev.rev_actor = actor.actor_id
    INNER JOIN revision parent
    ON rev.rev_parent_id = parent.rev_id
    INNER JOIN page
    ON page_id = parent.rev_page
    INNER JOIN comment
    on comment_id = rev.rev_comment_id
    WHERE actor_name IN (SELECT user_name FROM user_groups INNER JOIN user ON user_id = ug_user WHERE ug_group = 'editor' or 'autoreview') 
    and actor_name Not IN (SELECT user_name FROM user_groups INNER JOIN user ON user_id = ug_user WHERE ug_group = 'bot') 
    AND rev.rev_timestamp BETWEEN 20210601000000 AND 20210630235959
    AND parent.rev_timestamp BETWEEN 20210601000000 AND 20210630235959
    and ucase (actor_name) not like ucase (_utf8"%BOT") COLLATE utf8_general_ci
    and actor_name not like _utf8"بوت %" collate utf8_general_ci
    and page_namespace = 0
    and comment_text not like _utf8"%رجوع%" collate utf8_general_ci
    and comment_text not like _utf8"%استرجاع%" collate utf8_general_ci
    GROUP BY actor_name
    having byte_count > 0
    ORDER BY byte_count DESC
    LIMIT 50;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...