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,30) AND a.visibility = 'global' AND pa.term_id = 10363 ORDER BY a.ordered ASC, a.title_eng ASCSELECT 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,30) AND a.visibility = 'global' AND pa.term_id = 20901 ORDER BY a.ordered ASC, a.title_eng ASCSELECT 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,30) AND a.visibility = 'global' AND pa.term_id = 7538 ORDER BY a.ordered ASC, a.title_eng ASCSELECT 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,30) AND a.visibility = 'global' AND pa.term_id = 14810 ORDER BY a.ordered ASC, a.title_eng ASC