SELECT GroupID, GroupName,coalesce(Category,'Uncategorized Groups') AS Category FROM tbl_SEC_Groups LEFT OUTER JOIN tbl_SEC_Categories c ON (tbl_SEC_Groups.CategoryID = c.CategoryID) WHERE tbl_SEC_Groups.OwnerID = 201 AND tbl_SEC_Groups.FSL_TableCode = 'MFR'' AND ModVisibility LIKE AND ( OR GroupID = ) ORDER BY SortRank, Category, GroupName