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='60811266' and p.id=o.product_id GROUP BY p.id
Toplam 4 ürün bulunmaktadır.