USE plwiktionary_p;

​

SELECT

    -- a.rev_user_text

    rev_user_text,

    COUNT(*)

FROM (

    SELECT

        -- COUNT(*)

        rev_user_text

    FROM

        revision

    WHERE

        rev_user = 0 AND

        rev_timestamp > 20160101000000 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)

    LIMIT

        11

) AS a

/*WHERE

    a > 10*/

;