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='03691' AND a.supplierId=4664) OR ( a.articleSearch IN ('111343', '109709') AND a.supplierId=301) OR ( a.articleSearch IN ('24740', '24768', '24784', '80781') AND a.supplierId=4598) OR (a.articleSearch='17389' AND a.supplierId=317) OR ( a.articleSearch IN ('130067510', '130068110', '130069210') AND a.supplierId=323) OR ( a.articleSearch IN ('4023', '4863') AND a.supplierId=208) OR (a.articleSearch='1J0711256' AND a.supplierId=6366) OR (a.articleSearch='462412' AND a.supplierId=405) OR (a.articleSearch='4810' AND a.supplierId=4834) OR (a.articleSearch='SSR0007' AND a.supplierId=6443) OR (a.articleSearch='T403691' AND a.supplierId=4667) OR (a.articleSearch='633933' AND a.supplierId=4970) OR ( a.articleSearch IN ('160820K', '160825K', '162118') AND a.supplierId=4730) OR (a.articleSearch='148008' AND a.supplierId=4425) Запчасти для Корейских, Японских и Европейских Автомобилией
Например: 263002y500, oc90, 96353002, Введите VIN своего автомобиля например U5yhc512bal239396
Главная -> Каталог -> Vw (пасажирский) -> Vw PASSAT (3A2, 35I) ->Vw 2.0 16V, 01.1994- 08.1996, , 150 ->Управление передач