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 ('71755', '71761') AND a.supplierId=123) OR ( a.articleSearch IN ('PRS2034', 'PRS2037') AND a.supplierId=4558) OR ( a.articleSearch IN ('0170150005', '0170150022') AND a.supplierId=4657) OR ( a.articleSearch IN ('93574', '93578') AND a.supplierId=422) OR ( a.articleSearch IN ('099190N', '099005N') AND a.supplierId=80) OR ( a.articleSearch IN ('101768', '102436', '102441') AND a.supplierId=4688) OR (a.articleSearch='160022510' AND a.supplierId=323) OR ( a.articleSearch IN ('PRD2938', 'PRD2943') AND a.supplierId=4337) OR ( a.articleSearch IN ('FD6098', 'FD6154', 'FDA6098') AND a.supplierId=247) OR ( a.articleSearch IN ('DCM1091', 'DCM1095') AND a.supplierId=253) OR ( a.articleSearch IN ('DR71755', 'DR71761') AND a.supplierId=4881) OR (a.articleSearch='669566' AND a.supplierId=234) OR ( a.articleSearch IN ('143048', '143050') AND a.supplierId=441) OR ( a.articleSearch IN ('06053001', '06053002') AND a.supplierId=313) OR ( a.articleSearch IN ('8FH351311571', '8FH351313231') AND a.supplierId=4734) OR ( a.articleSearch IN ('212B04', '212M04') AND a.supplierId=296) OR (a.articleSearch='1526300100' AND a.supplierId=268) OR (a.articleSearch='104700' AND a.supplierId=6207) OR ( a.articleSearch IN ('2530306154', '2550306098') AND a.supplierId=78) OR (a.articleSearch='9912050' AND a.supplierId=4546) OR ( a.articleSearch IN ('143048', '143050') AND a.supplierId=4399) OR ( a.articleSearch IN ('350218209000', '350218209003') AND a.supplierId=4723) OR (a.articleSearch='AH151000S' AND a.supplierId=287) OR (a.articleSearch='180045' AND a.supplierId=403) OR ( a.articleSearch IN ('52220', '58638') AND a.supplierId=205) OR (a.articleSearch='05692' AND a.supplierId=4683) OR ( a.articleSearch IN ('FD6098', 'FD6154', 'FDA6098') AND a.supplierId=340) OR ( a.articleSearch IN ('17600431', 'PR2540N1') AND a.supplierId=4686) OR ( a.articleSearch IN ('467H0040', '467H0051') AND a.supplierId=6358) OR ( a.articleSearch IN ('143048', '143050') AND a.supplierId=27) OR ( a.articleSearch IN ('SKHE0880039', 'SKHE0880050') AND a.supplierId=6357) OR ( a.articleSearch IN ('1035009SX', '1035022SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('44001', '46011') AND a.supplierId=6691) OR ( a.articleSearch IN ('D6G001TT', 'D6G002TT') AND a.supplierId=4466) OR (a.articleSearch='302109' AND a.supplierId=301) OR ( a.articleSearch IN ('812058', '812129') AND a.supplierId=21) OR ( a.articleSearch IN ('18006098', '18006154') AND a.supplierId=36) OR ( a.articleSearch IN ('WG2017069', 'WG2161916', 'WG2162253') AND a.supplierId=4832) OR ( a.articleSearch IN ('MK5002', 'MK5008') AND a.supplierId=4894) Запчасти для Корейских, Японских и Европейских Автомобилией
Например: 263002y500, oc90, 96353002, Введите VIN своего автомобиля например U5yhc512bal239396
Главная -> Каталог -> Ford (пасажирский) -> Ford ESCORT VI Turnier (GAL, ANL) ->Ford 1.3, 01.1995- 01.1999, , 60 ->Салонный теплообменник