SELECT DISTINCT m.manufacturerName AS cross_brand, ao.manufacturerId, ao.oemSearch, ao.oemnumber, ps.id AS supplier_product_id, -- Получаем 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 IN ('140030110', '140030010') AND a.supplierId=323) OR ( a.articleSearch IN ('BSG65720065', 'BSG65720087') AND a.supplierId=4455) OR (a.articleSearch='28059A' AND a.supplierId=317) OR (a.articleSearch='754604' AND a.supplierId=405) OR (a.articleSearch='96SKV081' AND a.supplierId=4969) OR (a.articleSearch='EMH622' AND a.supplierId=6665) OR ( a.articleSearch IN ('180755', '180756') AND a.supplierId=403) OR (a.articleSearch='98635' AND a.supplierId=4664) OR ( a.articleSearch IN ('6148060001', '6148060002') AND a.supplierId=144) OR ( a.articleSearch IN ('222805', '222806') AND a.supplierId=331) OR ( a.articleSearch IN ('PH4044', 'PH4045') AND a.supplierId=4558) OR ( a.articleSearch IN ('R18108', 'R18109') AND a.supplierId=4303) OR (a.articleSearch='T498635' AND a.supplierId=4667) OR ( a.articleSearch IN ('95322', '95323') AND a.supplierId=6311) OR ( a.articleSearch IN ('V401354', 'V401987') AND a.supplierId=183) Запчасти для Корейских, Японских и Европейских Автомобилией
Например: 263002y500, oc90, 96353002, Введите VIN своего автомобиля например U5yhc512bal239396
Главная -> Каталог -> Opel (пасажирский) -> Opel VECTRA B (J96) ->Opel 1.6 i 16V (F19), 10.1995- 04.2002, , 100 ->Соединительные элементы / провода