SELECT DISTINCT m.manufacturerName AS cross_brand, ao.manufacturerId, ao.oemSearch, ao.oemnumber, ps.id AS supplier_product_id, ps.supplier_id AS real_supplier_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 ('203558', '617030', '802416', '817070') AND a.supplierId=373) OR (a.articleSearch='822484' AND a.supplierId=300) OR ( a.articleSearch IN ('CV0215A', 'DS1428R') AND a.supplierId=478) OR (a.articleSearch='1652' AND a.supplierId=318) OR ( a.articleSearch IN ('607648', '6551290') AND a.supplierId=311) OR (a.articleSearch='C120327' AND a.supplierId=186) OR (a.articleSearch='DA108362' AND a.supplierId=224) OR ( a.articleSearch IN ('CI3314', 'FI3461', 'PE3316') AND a.supplierId=316) OR (a.articleSearch='312882' AND a.supplierId=262) OR (a.articleSearch='DS52364' AND a.supplierId=283) OR (a.articleSearch='302015100112' AND a.supplierId=4723) OR (a.articleSearch='491463' AND a.supplierId=403) OR ( a.articleSearch IN ('151648', '171290') AND a.supplierId=121) OR (a.articleSearch='18162830' AND a.supplierId=4653) OR (a.articleSearch='CVJ574210' AND a.supplierId=378) OR (a.articleSearch='G1C027PC' AND a.supplierId=4690) OR (a.articleSearch='PNG72617' AND a.supplierId=6381) OR (a.articleSearch='DS52364' AND a.supplierId=343) OR ( a.articleSearch IN ('C242R', 'C274R', 'CV1528N', 'FI259R', 'FI259RN', 'C243R') AND a.supplierId=4607) OR (a.articleSearch='854010117' AND a.supplierId=108) Запчасти для Корейских, Японских и Европейских Автомобилией
Например: 263002y500, oc90, 96353002, Введите VIN своего автомобиля например U5yhc512bal239396
Главная -> Каталог -> Fiat (пасажирский) -> Fiat FIORINO Фургон/универсал (225_) ->Fiat 1.4 (225BXA1A, 225BXF1A), 11.2007- выпускается, , 73 ->Приводной вал