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
FROM page_restrictions
WHERE pr_type = "edit"
GROUP BY pr_type, pr_level;


## Count
SELECT count(*)
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");

## Output the top by page_len 1000 protected pages
SELECT page_title
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 1000;
SQL

Checking query status...
