Topic on Talk:Quarry

Find list of new pages created in main space in a specified month? example: november, 2019

SELECT page_title, rev_timestamp, actor_name
FROM revision
JOIN page ON page_id = rev_page
JOIN actor_revision ON actor_id = rev_actor
WHERE rev_timestamp LIKE '201911%'
AND rev_parent_id = 0
AND page_namespace = 0
AND page_is_redirect = 0

This would be possible using Extension:Cargo.