SQL
AخA
SELECT rev_id
FROM revision
JOIN actor on rev_actor = actor_id
WHERE rev_timestamp BETWEEN "20200801" AND "20210801"
AND (actor_user NOT IN (SELECT ug_user
FROM user_groups
WHERE ug_group = "bot")
OR actor_user IS NULL)
AND actor_name NOT REGEXP "([Bb]ot|AWB)$"
ORDER BY RAND()
LIMIT 20000;
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.