select distinct pd.products_name, p.products_id, p.products_model from products p, products_to_categories pc, products_description pd where pc.categories_id IN (123, 602, 596, 597, 598, 599, 600, 601) AND p.products_id = pc.products_id AND pd.products_id = p.products_id AND language_id = 4 order by p.products_model