SELECT
pro.productID,
pro.`name`,
pro.brief_description,
cat.categoryID
FROM
MB_products AS pro
INNER JOIN MB_category_products AS cat ON cat.productID = pro.productID
WHERE
pro.enabled = 1
GROUP BY
pro.productID
HAVING MIN(pro.productID) = pro.productID