To determine if a Group Member has a particular permission/power

SELECT osgrouprolemembership.AgentID
    , ((BIT_OR(osrole.Powers) & 1099511627776) > 0) as IsAccountable
	, ((BIT_OR(osrole.Powers) & 4096) > 0) as CanLandDeed
	, ((BIT_OR(osrole.Powers) & 131072) > 0) as CanPlaceInFindPlaces

FROM osgrouprolemembership JOIN osrole ON (osgrouprolemembership.GroupID = osrole.GroupID 
AND osgrouprolemembership.RoleID = osrole.RoleID)

WHERE osgrouprolemembership.GroupID = '$groupID'

GROUP BY osgrouprolemembership.AgentID