SELECT DISTINCT a.id,a.title,a.title_eng,a.description,a.fieldtype,a.values, pa.value FROM attribute a LEFT JOIN products_attribute pa ON pa.item_id = a.id WHERE a.attr_group_id IN (1,32) AND a.visibility = 'global' AND pa.term_id = 9889 ORDER BY a.ordered ASC, a.title_eng ASC