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='TM500110' AND a.supplierId=4924) OR (a.articleSearch='25342' AND a.supplierId=101) OR ( a.articleSearch IN ('181023', '181017') AND a.supplierId=4862) OR ( a.articleSearch IN ('05961', '05696') AND a.supplierId=4664) OR (a.articleSearch='06432' AND a.supplierId=4683) OR (a.articleSearch='30050015' AND a.supplierId=151) OR ( a.articleSearch IN ('11050032501', '11090246001') AND a.supplierId=4346) OR ( a.articleSearch IN ('10724', '10725') AND a.supplierId=4598) OR ( a.articleSearch IN ('130027010', '130042010') AND a.supplierId=323) OR (a.articleSearch='0023003570' AND a.supplierId=4995) OR ( a.articleSearch IN ('06A105263F', '06A109105C') AND a.supplierId=6366) OR ( a.articleSearch IN ('754626', '754631') AND a.supplierId=405) OR ( a.articleSearch IN ('10568', '10792') AND a.supplierId=4834) OR ( a.articleSearch IN ('AGI0009', 'CG0006') AND a.supplierId=6443) OR (a.articleSearch='1320346' AND a.supplierId=4546) OR (a.articleSearch='540545' AND a.supplierId=403) OR ( a.articleSearch IN ('T405696', 'T405961') AND a.supplierId=4667) OR (a.articleSearch='8129324SX' AND a.supplierId=4595) OR (a.articleSearch='108698' AND a.supplierId=301) OR ( a.articleSearch IN ('312509', '313991') AND a.supplierId=6347) Запчасти для Корейских, Японских и Европейских Автомобилией
Например: 263002y500, oc90, 96353002, Введите VIN своего автомобиля например U5yhc512bal239396
Главная -> Каталог -> Vw (пасажирский) -> Vw CADDY III универсал (2KB, 2KJ, 2CB, 2CJ) ->Vw 1.6, 04.2004- 05.2015, , 102 ->Шестерня коленвала