SELECT DISTINCT
m.manufacturerName AS cross_brand,
ao.manufacturerId,
ao.oemSearch,
ao.oemnumber,
ps.id AS supplier_product_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 ('202068', '202075') AND a.supplierId=225) OR ( a.articleSearch IN ('176353000', '179163000', '179164000') AND a.supplierId=485) OR ( a.articleSearch IN ('PLS2521', 'PLS25215', 'PLC215W') AND a.supplierId=4558) OR ( a.articleSearch IN ('12498B2', '12498CP', '12498LLECOB2', '12498LLECOCP', '12498VPB2', '12499B2', '12499CP', '12499LLECOB2', '12499LLECOCP', '12499VPB2', '12496LLECOCP', '12496NAB2', '12496NACP', '12496SVB2', '12496SVS2', '12499EDBW', '12594B2', '12594CP', '12821', '12821B2', '12821CP', '12821LLECOB2', '12821LLECOCP', '12822CP') AND a.supplierId=75) OR ( a.articleSearch IN ('032101', '032107', '032109', '032201', '032207', '032219') AND a.supplierId=21) OR (a.articleSearch='LP1100' AND a.supplierId=4894) OR ( a.articleSearch IN ('60000241', '60000241C', '60000619', '60000619C') AND a.supplierId=257) OR ( a.articleSearch IN ('91348', '91351') AND a.supplierId=4495) OR ( a.articleSearch IN ('150111310', '150111410', '150113110') AND a.supplierId=323) OR ( a.articleSearch IN ('1321', '1341') AND a.supplierId=4995) OR ( a.articleSearch IN ('9500080', '9500081', 'LID10046', 'LID10047', 'LID10048', 'LID10050', 'LID10057', 'LID10059') AND a.supplierId=253) OR ( a.articleSearch IN ('1184550', '725379', '978125', '978130') AND a.supplierId=355) OR ( a.articleSearch IN ('EB0380SB', 'EB0380SC', 'EB0380TB', 'EB0380TC', 'EB0382SB', 'EB0382SC', 'EB0382TB', 'EB0382TC', 'EB0386TC', 'EB0388TC') AND a.supplierId=4344) OR ( a.articleSearch IN ('1616431280', '1616431380') AND a.supplierId=4391) OR ( a.articleSearch IN ('B1100', 'B1400') AND a.supplierId=271) OR ( a.articleSearch IN ('8GA002071121', '8GA002071123', '8GA002073121', '8GA002073123', '8GA002073137', '8GA002073271', '8GA002073281', '8GA006841121', '8GA006841123', '8GD002078121', '8GD002078123', '8GD002078221', '8GM002091181') AND a.supplierId=4734) OR ( a.articleSearch IN ('DI0241', 'DI0241C', 'DI0619', 'DI0619C') AND a.supplierId=156) OR ( a.articleSearch IN ('600241', '600241C', '600619', '600619C') AND a.supplierId=481) OR (a.articleSearch='1195901400' AND a.supplierId=268) OR ( a.articleSearch IN ('LLB380', 'LLB380LLPX2', 'LLB380PX2', 'LLB380T', 'LLB382', 'LLB382LLPX2', 'LLB382PX2', 'LLB382T') AND a.supplierId=4501) OR (a.articleSearch='008506100000' AND a.supplierId=4723) OR ( a.articleSearch IN ('L551', 'L560', 'L751', 'L760') AND a.supplierId=6270) OR ( a.articleSearch IN ('780020SET', '780021SET', '780022', '780022SET') AND a.supplierId=403) OR ( a.articleSearch IN ('VBU380', 'VBU382') AND a.supplierId=4564) OR (a.articleSearch='02918' AND a.supplierId=4683) OR ( a.articleSearch IN ('VG0304303', 'VG0324103', 'VG0324104', 'VG9504054', 'VG9504154', 'VW0304303', 'VW0324103', 'VW0324104', 'VW9504054', 'VW9504154') AND a.supplierId=340) OR ( a.articleSearch IN ('0961847', '0961850') AND a.supplierId=4623) OR ( a.articleSearch IN ('2010', '2014', '2525', '2525L') AND a.supplierId=45) OR ( a.articleSearch IN ('9939038SX', '9939039SX', '9939040SX', '9939046SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('B52101', 'B52201') AND a.supplierId=356) OR ( a.articleSearch IN ('104493', '104494') AND a.supplierId=301) OR ( a.articleSearch IN ('8858109', '8858110', '8858117') AND a.supplierId=209) OR ( a.articleSearch IN ('V99840001', 'V99840003', 'V99840004', 'V99840005', 'V99840009') AND a.supplierId=183)
Запчасти для Корейских, Японских и Европейских Автомобилией
Запчасти для Корейских, Японских, Китайских автомобилей.
Запчасти для Корейских, Японских, Китайских автомобилей. г.Челябинск
