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
LEFT JOIN change_tag ON change_tag.ct_rev_id = revision.rev_id
LEFT JOIN change_tag_def ON change_tag.ct_tag_id = change_tag_def.ctd_id
LEFT JOIN page ON (revision.rev_page = page.page_id)
LEFT JOIN revision AS rev2 ON (revision.rev_parent_id = rev2.rev_id)
LEFT JOIN actor ON revision.rev_actor = actor.actor_id
WHERE change_tag_def.ctd_name NOT IN ("mw-reverted")
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
ORDER BY `Kích thước thay đổi` DESC
LIMIT 20
SQL

Checking query status...
