SQL
AخA
USE dewiki_p;
SELECT
FLOOR(page_random*100) / 100 AS bucket, COUNT(*) AS pages
FROM page
JOIN (
SELECT DISTINCT rev_page
FROM revision
WHERE rev_parent_id = 0
AND rev_timestamp < '2006') AS oldpages
ON page.page_id = oldpages.rev_page
GROUP BY bucket
ORDER BY bucket LIMIT 10000;
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.