Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Fobtv
.
Toggle Highlighting
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" 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 GROUP_CONCAT(DISTINCT change_tag_def.ctd_name) NOT LIKE "%mw-reverted%" AND GROUP_CONCAT(DISTINCT change_tag_def.ctd_name) NOT LIKE "%mw-rollback%" AND GROUP_CONCAT(DISTINCT change_tag_def.ctd_name) NOT LIKE "%mw-undo%" ORDER BY `Kích thước thay đổi` DESC LIMIT 20 UNION ALL (SELECT "Jason", "2", "3", "4")
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...