Page protections by type on fr.wiki 21-22

SQL

#SELECT COUNT(DISTINCT log_title) FROM logging
SELECT COUNT(DISTINCT log_title),
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 log_params
END AS protection_type
FROM logging
WHERE log_type = 'protect'
AND log_action = 'protect'
AND log_timestamp BETWEEN 20210101000000 AND 20220101000000
GROUP BY protection_type
SQL

Checking query status...
