SELECT p.* FROM products as p, brands as b, products_oem as o WHERE p.brand_id=b.id and p.status=1 and o.oem='60810076' and p.id=o.product_id GROUP BY p.id
Toplam 3 ürün bulunmaktadır.