Permission Group Report

select list.code as "Permission", pgt.name as "Group", TRUE as "Have"
        from permission.grp_perm_map map
        join permission.perm_list list on list.id = map.perm
        join permission.grp_tree pgt on pgt.id = map.grp
        where pgt.parent in (3,4,5,178,157) and pgt.usergroup = true
        order by 1, 2;