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 ('CR4019AM', 'CR4019AM025') AND a.supplierId=4460) OR ( a.articleSearch IN ('77089608', '77089618') AND a.supplierId=432) OR ( a.articleSearch IN ('03268', '045330') AND a.supplierId=4651) OR (a.articleSearch='TDI1891' AND a.supplierId=195) OR (a.articleSearch='ATB2044' AND a.supplierId=42) OR (a.articleSearch='DT26212' AND a.supplierId=4881) OR (a.articleSearch='1611884080' AND a.supplierId=4391) OR (a.articleSearch='FU15101' AND a.supplierId=236) OR (a.articleSearch='T42200' AND a.supplierId=6665) OR ( a.articleSearch IN ('7143114025MM', '7143114STD') AND a.supplierId=202) OR ( a.articleSearch IN ('CR040800', 'CR040801') AND a.supplierId=238) OR ( a.articleSearch IN ('LD0019', 'LDK0345') AND a.supplierId=4501) OR ( a.articleSearch IN ('B4019', 'B4227CP') AND a.supplierId=6420) OR ( a.articleSearch IN ('AST1274', 'ASTK1141') AND a.supplierId=6874) OR (a.articleSearch='KTD4028' AND a.supplierId=4655) OR ( a.articleSearch IN ('RKT1274', 'RKTK1141') AND a.supplierId=4330) OR (a.articleSearch='VKMA06212' AND a.supplierId=50) OR ( a.articleSearch IN ('WG1019357', 'WG1019358', 'WG1032224', 'WG1094502', 'WG1094503', 'WG2005217') AND a.supplierId=4832) Запчасти для Корейских, Японских и Европейских Автомобилией
Например: 263002y500, oc90, 96353002, Введите VIN своего автомобиля например U5yhc512bal239396
Главная -> Каталог -> Renault (пасажирский) -> Renault 9 (L42_) ->Renault 1.7 (L42E), 06.1987- 12.1988, , 94 ->Шатун