Fork of
[VeEs] New pages created with a hashtag (by a single user in a timespan)
by André Costa (WMSE)
This query is marked as a draft
This query has been published
by André Costa (WMSE).
SQL
AخA
SELECT COUNT(DISTINCT(r.rev_page)) as new_pages
FROM wikidatawiki_p.revision r
WHERE r.rev_timestamp > '20171001000001'
AND r.rev_timestamp < '20171115235959'
AND r.rev_user_text = 'AndreCostaWMSE-bot'
AND r.rev_comment LIKE '%#pe%'
AND r.rev_parent_id = 0
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.