Samsung felső burkolat
laptop felső burkolat, notebook felső burkolat, netbook felső burkolat
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,22) AND a.visibility = 'global' AND pa.term_id = 17769 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,22) AND a.visibility = 'global' AND pa.term_id = 13358 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,22) AND a.visibility = 'global' AND pa.term_id = 4976 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,22) AND a.visibility = 'global' AND pa.term_id = 14721 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,22) AND a.visibility = 'global' AND pa.term_id = 13009 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,22) AND a.visibility = 'global' AND pa.term_id = 31828 ORDER BY a.ordered ASC, a.title_eng ASC
laptop felső burkolat, notebook felső burkolat, netbook felső burkolat
laptop felső burkolat, notebook felső burkolat, netbook felső burkolat