SQL
AخA
SELECT COUNT(rev_id) AS count
FROM revision
WHERE rev_parent_id = 0
AND rev_page IN (SELECT page_id FROM page WHERE page_namespace = 0)
AND TIMESTAMP(rev_timestamp) BETWEEN(SYSDATE() - INTERVAL 1 MONTH) AND SYSDATE()
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.
Query status: stopped
This query was stopped