USE plwiktionary_p;

​

SET @start = 20160101000000;

SET @end = 20160801000000;

SET @min_edits = 10;

​

SELECT

    actor_name AS "IP", actor_user,

    COUNT(*) AS "edit count"

FROM

    revision INNER JOIN actor ON actor_id = rev_actor

WHERE

    #actor_user = 0 AND

    rev_timestamp > @start /*AND

    rev_timestamp < @end*/ /*AND

    NOT EXISTS (SELECT NULL FROM change_tag INNER JOIN change_tag_def ON ctd_id = ct_tag_id WHERE ct_rev_id = rev_id AND ctd_name = "mobile_edit")*/

GROUP BY

    actor_name WITH ROLLUP

HAVING

    COUNT(*) > @min_edits

;