Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
Page protections by type on fr.wiki 21-22
by
MWang (WMF)
This query is marked as a draft
This query has been published
by
MWang (WMF)
.
Toggle Highlighting
SQL
#SELECT COUNT(DISTINCT log_title) FROM logging SELECT CASE WHEN log_params LIKE '%edit=autoconfirmed%' THEN 'edit_autoconfirmed' WHEN log_params LIKE '%edit=editextendedsemiprotected%' THEN 'edit_extendedconfirmed' WHEN log_params LIKE '%edit=sysop%' THEN 'edit_sysop' WHEN log_params LIKE '%create=autoconfirmed%' THEN 'create_autoconfirmed' WHEN log_params LIKE '%create=sysop%' THEN 'create_sysop' WHEN log_params LIKE '%create=editextendedsemiprotected%' THEN 'create_editextendedconfirmed' WHEN log_params LIKE '%move=autoconfirmed%' THEN 'move_autoconfirmed' WHEN log_params LIKE '%move=editextendedsemiprotected%' THEN 'move_extendedconfirmed' WHEN log_params LIKE '%move=sysop%' THEN 'move_sysop' ELSE 'other type' END AS protection_type, COUNT(DISTINCT log_title) AS num_articles, COUNT(1) AS num_protection_actions FROM logging WHERE log_type = 'protect' AND log_action = 'protect' AND log_timestamp >= '20210101000000' AND log_timestamp < '20220101000000' AND log_namespace = 0 -- limit it to the article namespace GROUP BY protection_type
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...