SELECT DISTINCT m.manufacturerName AS cross_brand, ao.manufacturerId, ao.oemSearch, ao.oemnumber, ps.id FROM article a LEFT JOIN article_oem ao ON ao.articleNumber = a.articleNumber AND ao.supplierId = a.supplierId LEFT JOIN manufacturer m ON m.manufacturerId = ao.manufacturerId LEFT JOIN products.brands b ON b.title = m.manufacturerName LEFT JOIN products.products p ON p.article = ao.oemSearch AND p.brand_id = b.id LEFT JOIN products.products_suppliers ps ON ps.product_id = p.id AND ps.supplier_id IN (224,226,223,225,227) WHERE ( a.articleSearch IN ('99451796302', '99451796402') AND a.supplierId=4353) OR ( a.articleSearch IN ('BSG90806004', 'BSG90806005') AND a.supplierId=4455) OR ( a.articleSearch IN ('VG9194353', 'VG9194354') AND a.supplierId=340) OR ( a.articleSearch IN ('5790939', '5790940') AND a.supplierId=36) Запчасти для Корейских, Японских и Европейских Автомобилией
Например: 263002y500, oc90, 96353002, Введите VIN своего автомобиля например U5yhc512bal239396
Главная -> Каталог -> Vw (пасажирский) -> Vw TRANSPORTER VI автобус (SGB, SGG, SGJ, SGC, SHB, SHJ, SHC) ->Vw 2.0 TDI, 04.2015- 08.2024, , 150 ->Отражатель