SELECT DISTINCT
p.id, p.title, p.link, p.price, p.brand_id,
b.title as brand_title, b.logo as brand_logo
FROM products_oem po1
INNER JOIN products_oem po2 ON po1.link = po2.link AND po2.product_id != 526987
INNER JOIN products p ON p.id = po2.product_id
INNER JOIN brands b ON b.id = p.brand_id
WHERE po1.product_id = 526987
AND p.stocks > 0
AND p.price > 0
GROUP BY p.brand_id
ORDER BY p.price ASC