What are the "top" current protected pages

SQL

# Total 
SELECT COUNT(*) as total FROM page_restrictions;

# Stats breakdown
SELECT COUNT(*) as counts, pr_type, pr_level, page_namespace
FROM page_restrictions
LEFT JOIN page 
ON pr_page = page_id
WHERE pr_type = "edit"
GROUP BY pr_type, pr_level, page_namespace;


## Count how many we have
SELECT count(*), pr_level, IF(pr_expiry = "infinity", "infinity", "not infinity") pr_expiry_
FROM page_restrictions
LEFT JOIN page 
ON pr_page = page_id
WHERE 
  pr_type = "edit" 
  AND page_namespace = 0 
GROUP by pr_level, pr_expiry_;

## Output the top by page_len 1000 protected pages
SELECT page_title, page_len
FROM page_restrictions
LEFT JOIN page 
ON pr_page = page_id
WHERE 
  pr_type = "edit" 
  AND page_namespace = 0 
  AND pr_expiry = "infinity"
  AND pr_level IN ("extendedconfirmed")
ORDER BY page_len DESC
LIMIT 2000;
SQL

Checking query status...
