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 "Tổng kích thước trang", (CAST(rev2.rev_len AS INT) - CAST(revision.rev_len AS INT)) AS "Kích thước thay đổi"
FROM revision
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
WHERE page.page_namespace = 0 AND
revision.rev_timestamp between REPLACE(format(date_sub(now(), INTERVAL 1 MONTH), "yyyyMMddHHmmssffff"), ",", "") and REPLACE(format(now(), "yyyyMMddHHmmssffff"), ",", "")
ORDER BY `Kích thước thay đổi` DESC
LIMIT 20
SQL

Checking query status...
