SELECT DISTINCT p.id, p.name, i.base_filename, p.description, p.sale_price_inc_vat, p.wide, p.competition, p.supplier, m.name, p.seo FROM products p, product_category pc, categories c LEFT JOIN manufacturers m ON p.manufacturer = m.id LEFT JOIN images i ON p.primary_image = i.id WHERE p.hidden != 1 && p.exclude_from_listings != 1 && pc.category = c.id && pc.category IN (1,4,5,8,9,72,73,78,80,145,75,77,161,162,163,164,177,179,201,202,92,146) && pc.product = p.id ORDER BY p.sale_price_inc_vat DESC, p.ord ASC