Users in privileged groups

SQL

select u.user_name a, ia, b, os, cu ,
    (case when ia is not null then 1 else 0 end +
    case when b is not null then 1 else 0 end +
    case when cu is not null then 1 else 0 end +
    case when os is not null then 1 else 0 end) groupcount

from user u inner join user_groups ug on ug.ug_user = u.user_id and ug.ug_group = 'sysop'
left join (
    select u.user_name ia from user u inner join user_groups ug on ug.ug_user = u.user_id and ug.ug_group = 'interface-admin'
) uia on u.user_name = uia.ia
left join (
    select u.user_name b from user u inner join user_groups ug on ug.ug_user = u.user_id and ug.ug_group = 'bureaucrat'
) ub on u.user_name = ub.b
left join (
    select u.user_name os from user u inner join user_groups ug on ug.ug_user = u.user_id and ug.ug_group = 'oversight'
) uos on u.user_name = uos.os
left join (
    select u.user_name cu from user u inner join user_groups ug on ug.ug_user = u.user_id and ug.ug_group = 'checkuser'
) ucu on u.user_name = ucu.cu

order by groupcount desc;
SQL

Checking query status...
