Fork of
Most edited pages
by DHN
This query is marked as a draft
This query has been published
by DHN.
SQL
AخA
USE viwiki_p;
SELECT
MIN(rc_timestamp) AS timestamp,
CONCAT('[[', rc_title, ']]') AS page,
MAX(rc_new_len) - MIN(rc_old_len) AS diff,
MAX(rc_new_len) AS new_len,
MAX(rc_new_len)/MIN(rc_old_len) AS increase_ratio
FROM recentchanges
WHERE rc_namespace = 0 -- Chỉ tính không gian chính
AND DATEDIFF(CURDATE(), rc_timestamp) < 14
AND rc_new_len > 5000
GROUP BY rc_title
ORDER BY increase_ratio DESC LIMIT 100;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.