SELECT a.attrID as attribute_id, a.attrDescription as attribute, g.attrDescription as category_name FROM tbl_PRD_Attributes a, tbl_PRD_AttributeLinks link INNER join tbl_PRD_Attributes g ON g.attrId = link.mstr_attrId WHERE a.OwnerID = AND a.FSL_TableCode = AND a.attrTypeID = 4 AND ( a.attrTypeID = link.child_attrTypeID AND link.child_attrID = a.attrid AND link.mstr_attrTypeID = 3 AND link.mstr_attrID IN ( SELECT DISTINCT a.attrID FROM tbl_PRD_Attributes a WHERE a.OwnerID = AND a.FSL_TableCode = ) )