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 ('6432810', '6471810', '6139810', '6140810', '6141810', '6142810', '6143810', '6145810', '6147810', '6149810') AND a.supplierId=362) OR ( a.articleSearch IN ('1046227') AND a.supplierId=253) OR ( a.articleSearch IN ('27025401', '27025402', '31025401', '31025402') AND a.supplierId=4841) OR ( a.articleSearch IN ('13133781') AND a.supplierId=138) OR ( a.articleSearch IN ('55010414') AND a.supplierId=4965) OR ( a.articleSearch IN ('00431061') AND a.supplierId=78) OR ( a.articleSearch IN ('L1365', 'L1366') AND a.supplierId=4572) OR ( a.articleSearch IN ('AD0267513', 'AD0267524') AND a.supplierId=340) OR ( a.articleSearch IN ('15422', '15423', '58230', '58231', '58232', '58233', '58234', '58236', '58238', '58240') AND a.supplierId=4680) OR ( a.articleSearch IN ('L1365', 'L1366') AND a.supplierId=4582) OR ( a.articleSearch IN ('30201091', '30201101') AND a.supplierId=61) OR ( a.articleSearch IN ('0346836', '0346837') AND a.supplierId=36) Запчасти для Корейских, Японских и Европейских Автомобилией
Например: 263002y500, oc90, 96353002, Введите VIN своего автомобиля например U5yhc512bal239396
Главная -> Каталог -> Audi (пасажирский) -> Audi A4 Avant (8W5, 8WD, B9) ->Audi 40 TFSI Mild Hybrid quattro, 06.2020- выпускается, , 204 ->Остекление / зеркала