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='85483' AND a.supplierId=123) OR (a.articleSearch='330082' AND a.supplierId=4654) OR ( a.articleSearch IN ('310030', '310029') AND a.supplierId=422) OR (a.articleSearch='098114N' AND a.supplierId=80) OR (a.articleSearch='GA200442' AND a.supplierId=4688) OR (a.articleSearch='FD7503' AND a.supplierId=247) OR (a.articleSearch='0116010330' AND a.supplierId=4995) OR (a.articleSearch='EFO078' AND a.supplierId=4585) OR (a.articleSearch='05051002' AND a.supplierId=313) OR (a.articleSearch='25552601' AND a.supplierId=78) OR (a.articleSearch='47003' AND a.supplierId=205) OR ( a.articleSearch IN ('FD1073300', 'FD7503') AND a.supplierId=340) OR (a.articleSearch='8100007' AND a.supplierId=61) OR (a.articleSearch='696362' AND a.supplierId=21) OR (a.articleSearch='V25011542' AND a.supplierId=183) OR (a.articleSearch='WG1720108' AND a.supplierId=4832) Запчасти для Корейских, Японских и Европейских Автомобилией
Например: 263002y500, oc90, 96353002, Введите VIN своего автомобиля например U5yhc512bal239396
Главная -> Каталог -> Ford (пасажирский) -> Ford MONDEO III (B5Y) ->Ford 2.0 TDCi, 10.2001- 03.2007, , 130 ->Система воздушного охлаждения