SELECT DISTINCT m.manufacturerName cross_brand, ao.oemSearch, ao.oemnumber, ps.id FROM article a /*LEFT JOIN supplier s ON s.supplierId=a.supplierId*/ 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 p.id=ps.product_id AND ps.supplier_id IN (223) WHERE ( a.articleSearch IN ('70933961') AND a.supplierId=151) OR ( a.articleSearch IN ('40901') AND a.supplierId=4598) OR ( a.articleSearch IN ('148832', '148834') AND a.supplierId=317) OR ( a.articleSearch IN ('MT9561') AND a.supplierId=478) OR ( a.articleSearch IN ('50949') AND a.supplierId=208) OR ( a.articleSearch IN ('BEM3524') AND a.supplierId=475) OR ( a.articleSearch IN ('011067') AND a.supplierId=405) OR ( a.articleSearch IN ('80001466') AND a.supplierId=140) OR ( a.articleSearch IN ('4492') AND a.supplierId=4834) OR ( a.articleSearch IN ('FT52211') AND a.supplierId=4938) OR ( a.articleSearch IN ('33961') AND a.supplierId=101) OR ( a.articleSearch IN ('FEM3524') AND a.supplierId=407) OR ( a.articleSearch IN ('FZ90833') AND a.supplierId=4467) OR ( a.articleSearch IN ('EM0001') AND a.supplierId=6443) OR ( a.articleSearch IN ('519332') AND a.supplierId=373) OR ( a.articleSearch IN ('532A22') AND a.supplierId=239) OR ( a.articleSearch IN ('030607010085') AND a.supplierId=4723) OR ( a.articleSearch IN ('33043') AND a.supplierId=133) OR ( a.articleSearch IN ('400501') AND a.supplierId=403) OR ( a.articleSearch IN ('04892') AND a.supplierId=4664) OR ( a.articleSearch IN ('2140300052') AND a.supplierId=144) OR ( a.articleSearch IN ('1226029', '1226030') AND a.supplierId=198) OR ( a.articleSearch IN ('26235', '26296') AND a.supplierId=331) OR ( a.articleSearch IN ('PSE3178') AND a.supplierId=4558) OR ( a.articleSearch IN ('PCM269') AND a.supplierId=4655) OR ( a.articleSearch IN ('R52030') AND a.supplierId=4303) OR ( a.articleSearch IN ('RH111019') AND a.supplierId=6892) OR ( a.articleSearch IN ('325895') AND a.supplierId=23) OR ( a.articleSearch IN ('9001925') AND a.supplierId=260) OR ( a.articleSearch IN ('T404892') AND a.supplierId=4667) OR ( a.articleSearch IN ('2518320SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('364235') AND a.supplierId=4970) OR ( a.articleSearch IN ('395461') AND a.supplierId=4730) OR ( a.articleSearch IN ('VE50949') AND a.supplierId=4425) OR ( a.articleSearch IN ('WG1393385', 'WG1755685') AND a.supplierId=4832) Запчасти для Корейских, Японских и Европейских Автомобилией
Например: 263002y500, oc90, 96353002, Введите VIN своего автомобиля например U5yhc512bal239396
Главная -> Каталог -> Fiat (пасажирский) -> Fiat PUNTO (188_) ->Fiat 1.8 130 HGT (188.738, .718), 09.1999- 03.2012, , 130 ->Подвеска