Pages in all namespaces creation protected as Grawp titles

This query is marked as a draft This query has been published by ಮಲ್ನಾಡಾಚ್ ಕೊಂಕ್ಣೊ.

SQL

SELECT
  rev_user_text,
  SUM(CASE WHEN p1.page_is_redirect = 0 THEN 1 ELSE 0 END) AS notredir,
  SUM(CASE WHEN p1.page_is_redirect = 1 THEN 1 ELSE 0 END) AS redir,
  SUM(CASE WHEN p1.page_is_redirect = 0 THEN 1 ELSE 0 END) + 
  SUM(CASE WHEN p1.page_is_redirect = 1 THEN 1 ELSE 0 END) AS total
FROM revision_userindex
JOIN s51334__enwiki_first_page_revisions_p.page AS p2
ON rev_id = p2.page_first_revision_id
JOIN page AS p1
ON p1.page_id = p2.page_id
GROUP BY rev_user_text
ORDER BY total DESC
LIMIT 10000;

SQL

Checking query status...