Users with rights who are tagged as banned [enwiki]

Fork of Blocked users with rights, summary mentions "ban" [enwiki] by Tamzin

This query is marked as a draft This query has been published by Tamzin.

SQL

SELECT ipb_address, GROUP_CONCAT(ug_group), ipb_expiry, ipb_sitewide, cl_to, comment_text
FROM user_groups
	JOIN ipblocks ON ug_user = ipb_user
	JOIN comment ON ipb_reason_id = comment_id
	INNER JOIN page ON page_title = REPLACE(ipb_address, ' ', '_') AND page_namespace = 2
    INNER JOIN categorylinks ON cl_from = page_id
WHERE ug_group != 'extendedconfirmed'
	AND (
      cl_to = 'Banned_Wikipedia_users'
      OR cl_to = 'Wikipedia_users_banned_for_repeated_sockpuppetry'
    )
    AND ipb_sitewide = 1
GROUP BY ipb_id
ORDER BY ipb_expiry DESC

SQL

Checking query status...