Fork of
Indef protected user talk pages
by Zhuyifei1999
This query is marked as a draft
This query has been published
by Anarchyte.
SQL
AخA
SELECT
LEFT(ipb_timestamp,4) AS Year,
COUNT(page_title) AS Total,
page_title AS Pages
FROM page_restrictions
INNER JOIN page ON pr_page = page_id
INNER JOIN ipblocks ON ipb_address = page_title
WHERE pr_type = 'edit'
AND pr_level = 'autoconfirmed'
AND page_namespace = 0
AND page_is_redirect = 1
AND NOT page_title LIKE '%/%'
GROUP BY LEFT(ipb_timestamp,4) DESC
;
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.