SELECT m.manufacturerName AS cross_brand, ao.oemSearch, ao.oemnumber, ps.id FROM article a INNER JOIN ( SELECT articleNumber, supplierId, manufacturerId, oemSearch, oemnumber FROM article_oem GROUP BY articleNumber, supplierId, manufacturerId, oemSearch, oemnumber ) 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 (223) WHERE ( a.articleSearch IN ('BSG65995006', 'BSG65922085') AND a.supplierId=4455) OR ( a.articleSearch IN ('1270700100', '1280150200') AND a.supplierId=268) OR ( a.articleSearch IN ('13214', '19522', '43290') AND a.supplierId=4683) OR (a.articleSearch='PC5001' AND a.supplierId=4558) OR (a.articleSearch='80415' AND a.supplierId=4598) OR (a.articleSearch='52551' AND a.supplierId=6558) OR ( a.articleSearch IN ('100083110', '100083310', '110163310') AND a.supplierId=323) OR (a.articleSearch='PAB0020' AND a.supplierId=4337) OR (a.articleSearch='764039' AND a.supplierId=405) OR ( a.articleSearch IN ('131802', '92131802') AND a.supplierId=4871) OR (a.articleSearch='S332' AND a.supplierId=4572) OR (a.articleSearch='324003' AND a.supplierId=4536) OR (a.articleSearch='C0001BO' AND a.supplierId=283) OR (a.articleSearch='84819' AND a.supplierId=4664) OR (a.articleSearch='01365221' AND a.supplierId=6447) OR (a.articleSearch='C0001BO' AND a.supplierId=343) OR (a.articleSearch='122140' AND a.supplierId=263) OR (a.articleSearch='999073' AND a.supplierId=4582) OR (a.articleSearch='T484819' AND a.supplierId=4667) OR (a.articleSearch='2997504SX' AND a.supplierId=4595) OR ( a.articleSearch IN ('205234', '206055', '206218') AND a.supplierId=301) OR (a.articleSearch='814024601' AND a.supplierId=108) OR (a.articleSearch='580237' AND a.supplierId=6347) -- Быстрая группировка вместо тяжелого DISTINCT по текстовым полям GROUP BY m.manufacturerName, ao.oemSearch, ao.oemnumber, ps.id Запчасти для Корейских, Японских и Европейских Автомобилией
Например: 263002y500, oc90, 96353002, Введите VIN своего автомобиля например U5yhc512bal239396
Главная -> Каталог -> Opel (пасажирский) -> Opel KADETT E Наклонная задняя часть (T85) ->Opel 1.4 i (C08, C48, D08, D48), 01.1990- 08.1991, , 60 ->Крышки/капоты/двери/люк крыши/складная крыша