USE plwiktionary_p;

​

SET @timestamp = 20160130000000;

​

SELECT

    IFNULL(CONCAT("[[Special:Contribs/", rev_user_text, "]]"), "Total") AS "IP",

    COUNT(*) AS "edit count"

FROM

    revision

WHERE

    rev_user = 0 AND

    rev_timestamp > @timestamp AND

    NOT EXISTS (SELECT NULL FROM ipblocks WHERE ipb_address = rev_user_text) AND

    NOT EXISTS (SELECT NULL FROM tag_summary WHERE ts_rev_id = rev_id AND ts_tags LIKE "%mobile_edit%")

GROUP BY

    rev_user_text WITH ROLLUP

;