SELECT DISTINCT m.manufacturerName AS cross_brand, ao.oemSearch, ao.oemnumber, ps.id FROM ( VALUES ({13279}, 4683), ({27166}, 4683), ({54019}, 6558), ({150115510}, 323), ({CAC3095}, 4334), ({CAC3098}, 4334), ({660249}, 234), ({16SKV403}, 4969), ({610634A2}, 441), ({610834A2}, 441), ({SE73028}, 6456), ({3100436}, 341), ({3100438}, 341), ({280348}, 403), ({280363}, 403), ({31436}, 244), ({31438}, 244), ({115155}, 301), ({V10771011}, 183), ({V10771065}, 183), ({99591342501}, 4346), ({99591343401}, 4346), ({99591801301}, 4346), ({461860213}, 4275), ({461860324}, 4275) ) AS search_list(search_art, search_sup) INNER JOIN article a ON a.articleSearch = search_list.search_art AND a.supplierId = search_list.search_sup 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) Запчасти для Корейских, Японских и Европейских Автомобилией
Например: 263002y500, oc90, 96353002, Введите VIN своего автомобиля например U5yhc512bal239396
Главная -> Каталог -> Audi (пасажирский) -> Audi A4 Avant (8ED, B7) ->Audi 2.0 TFSI, 11.2004- 06.2008, , 200 ->Центральный замок