191.83.128.0/17 IP range edits on eswiktionary

SQL

USE eswiktionary_p;
-- http://www.analyticsmarket.com/freetools/ipregex
SET @IP_REGEX = "^191\.83\.(1(2[8-9]|[3-9][0-9])|2([0-4][0-9]|5[0-5]))\.([0-9]|[1-9][0-9]|1([0-9][0-9])|2([0-4][0-9]|5[0-5]))$";

-- Ediciones de usuarios anónimos y su respectivo timestamp

SELECT
	rev_user_text AS "IP",
    rev_timestamp AS "timestamp",
    page_title,
    page_namespace
FROM
	revision INNER JOIN page ON rev_page = page_id
        
WHERE
	rev_user = 0 AND
    rev_user_text RLIKE @IP_REGEX
ORDER BY
	rev_timestamp
LIMIT
	100
;

-- Número de ediciones por cada usuario anónimo encontrado

SELECT
	IFNULL(rev_user_text, "Total") AS "IP",
    IF(log_type IS NOT NULL, 1, 0) AS "fue_bloqueado",
    COUNT(rev_timestamp) AS "edit count"
FROM
	revision
        LEFT JOIN logging ON
            log_type = "block" AND
            rev_user_text = log_title
WHERE
	rev_user = 0 AND
    rev_user_text RLIKE @IP_REGEX
GROUP BY
	rev_user_text WITH ROLLUP
LIMIT
	100
;
SQL

Checking query status...
