Fork of
Untitled query #1621
by EpochFail
This query is marked as a draft
This query has been published
by Xiplus.
SQL
x
SELECT rc_this_oldid AS rev_id, rc_cur_id AS page_id
FROM recentchanges
WHERE
rc_timestamp < DATE_FORMAT(DATE_SUB(NOW(), INTERVAL 2 DAY), "%Y%m%d%H%I%S") AND
rc_type = 0
ORDER BY RAND()
LIMIT 70000;
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.