List of large edits in the last month

SQL

USE viwiki_p;
SELECT page.page_title AS "Tên trang", actor.actor_name AS "Thành viên sửa đổi", page.page_len AS "Kích thước trang hiện tại", (CAST(revision.rev_len AS INT) - CAST(rev2.rev_len AS INT)) AS "Kích thước thay đổi", GROUP_CONCAT(DISTINCT change_tag_def.ctd_name) AS rev_tag
FROM revision
INNER JOIN change_tag ON change_tag.ct_rev_id = revision.rev_id
INNER JOIN change_tag_def ON change_tag.ct_tag_id = change_tag_def.ctd_id
INNER JOIN page ON (revision.rev_page = page.page_id)
INNER JOIN revision AS rev2 ON (revision.rev_parent_id = rev2.rev_id)
INNER JOIN actor ON revision.rev_actor = actor.actor_id
AND page.page_namespace = 0 AND
revision.rev_timestamp between REPLACE(format(date_sub(now(), INTERVAL 1 MONTH), "yyyyMMddHHmmssffff"), ",", "") and REPLACE(format(now(), "yyyyMMddHHmmssffff"), ",", "")
GROUP BY revision.rev_id
HAVING rev_tag NOT LIKE "%mw-reverted%" AND rev_tag NOT LIKE "%mw-rollback%" AND rev_tag NOT LIKE "%mw-undo%"
ORDER BY `Kích thước thay đổi` DESC
LIMIT 20
SQL

Checking query status...
