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='FT20075' AND a.supplierId=4938) OR ( a.articleSearch IN ('26347', '26350', '40057') AND a.supplierId=101) OR (a.articleSearch='3361501' AND a.supplierId=35) OR (a.articleSearch='1006200007' AND a.supplierId=144) OR ( a.articleSearch IN ('20926347', '20926350', '20940056', '20940057') AND a.supplierId=151) OR ( a.articleSearch IN ('27206', '272061') AND a.supplierId=317) OR (a.articleSearch='506649' AND a.supplierId=300) OR (a.articleSearch='D9314' AND a.supplierId=351) OR (a.articleSearch='0035014361' AND a.supplierId=4995) OR (a.articleSearch='047524B' AND a.supplierId=49) OR (a.articleSearch='7523KM' AND a.supplierId=208) OR (a.articleSearch='BSG3277' AND a.supplierId=475) OR ( a.articleSearch IN ('760300', '760353') AND a.supplierId=405) OR (a.articleSearch='TBR4250' AND a.supplierId=89) OR (a.articleSearch='510068' AND a.supplierId=4512) OR (a.articleSearch='841022730' AND a.supplierId=192) OR (a.articleSearch='VWRKB001' AND a.supplierId=4674) OR (a.articleSearch='FSG3277' AND a.supplierId=407) OR ( a.articleSearch IN ('860600601', '860601401', '860602401') AND a.supplierId=6484) OR ( a.articleSearch IN ('540417S', '540440') AND a.supplierId=373) OR (a.articleSearch='355644' AND a.supplierId=178) OR (a.articleSearch='355644' AND a.supplierId=262) OR (a.articleSearch='850010034' AND a.supplierId=286) OR (a.articleSearch='690954' AND a.supplierId=403) OR ( a.articleSearch IN ('10246', '11246') AND a.supplierId=4664) OR (a.articleSearch='L10034' AND a.supplierId=4752) OR (a.articleSearch='K150237' AND a.supplierId=134) OR ( a.articleSearch IN ('0902360', '1211429') AND a.supplierId=198) OR ( a.articleSearch IN ('G82010', 'LM10100S') AND a.supplierId=129) OR ( a.articleSearch IN ('33335', '33335A', '33335ATE', '33335TE', '37438', '37438TE') AND a.supplierId=331) OR (a.articleSearch='02340' AND a.supplierId=4683) OR (a.articleSearch='I6B005PC' AND a.supplierId=4690) OR (a.articleSearch='PSE6381' AND a.supplierId=4558) OR (a.articleSearch='191B0047' AND a.supplierId=6358) OR ( a.articleSearch IN ('305036', '305038') AND a.supplierId=135) OR (a.articleSearch='VKJP2142' AND a.supplierId=50) OR (a.articleSearch='84078' AND a.supplierId=6363) OR (a.articleSearch='SKBSA1280046' AND a.supplierId=6357) OR ( a.articleSearch IN ('T410246', 'T411246') AND a.supplierId=4667) OR (a.articleSearch='1300432SX' AND a.supplierId=4595) OR ( a.articleSearch IN ('111905', '501314') AND a.supplierId=301) OR (a.articleSearch='850010034' AND a.supplierId=108) OR (a.articleSearch='JBE363' AND a.supplierId=4501) OR (a.articleSearch='V200975' AND a.supplierId=183) OR (a.articleSearch='VE7523KM' AND a.supplierId=4425) OR (a.articleSearch='44221768701' AND a.supplierId=4346) OR ( a.articleSearch IN ('280457', '280459', '380071') AND a.supplierId=6347) Запчасти для Корейских, Японских и Европейских Автомобилией
Например: 263002y500, oc90, 96353002, Введите VIN своего автомобиля например U5yhc512bal239396
Главная -> Каталог -> Vw (пасажирский) -> Vw AMAROK c бортовой платформой/ходовая часть (S1B, S6B, S7B) ->Vw 2.0 TDI, 09.2011- 10.2016, , 140 ->Гофрированный кожух / прокладки