Global lock status of bnwiki special users

Fork of English Wiki:Wikidata QIDs by category on enwiki (articles only) by ZI Jony

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

SQL

use bnwiki_p;
SELECT user_name, gu_locked
FROM user
JOIN user_groups
	ON user_id = ug_user
LEFT JOIN centralauth_p.globaluser
	ON user_name = gu_name
WHERE ug_group = 'sysop' 
AND  ug_group = 'bureaucrat'
AND  ug_group = 'checkuser'
AND  ug_group = 'oversight'
AND  ug_group = 'interface-admin'
AND  ug_group = 'autopatrolled'
AND  ug_group = 'filemover'
AND  ug_group = 'reviewer'
AND  ug_group = 'rollbacker'
AND  ug_group = 'ipblock-exempt'
AND  ug_group = 'accountcreator'
AND  ug_group = 'import'
AND  ug_group = 'transwiki';

SQL

Checking query status...