Article page protections by type on fr.wiki 21-22

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 >= '20220101000000'
AND log_timestamp < '20230101000000'
AND log_namespace = 0 -- limit it to the article namespace
GROUP BY protection_type
SQL

Checking query status...
