SQL
AخA
USE bnwikisource_p;
SELECT page_title,rev_comment_id,rev_id,rev_page,rev_comment_id,rev_timestamp
FROM revision JOIN page ON page_id = rev_page
WHERE
page_namespace=104 AND
rev_comment_id RLIKE '^/\\\* ' AND
rev_timestamp > 20161231235999 AND rev_timestamp < 20170731235999
ORDER BY rev_timestamp
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.