Untitled query #7631

SQL

USE plwiktionary_p;
-- http://www.analyticsmarket.com/freetools/ipregex
SET @IP_REGEX = "5\\.172\\.246\\.([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 "timestamp"
FROM
	revision
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",
    COUNT(rev_timestamp) AS "edit count"
FROM
	revision
WHERE
	rev_user = 0 AND
    rev_user_text RLIKE @IP_REGEX
GROUP BY
	rev_user_text WITH ROLLUP
LIMIT
	100
;
SQL

Checking query status...
