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='LF964M' AND a.supplierId=4600) OR ( a.articleSearch IN ('06332', '16453', '25985', '26305', '26306', '19274') AND a.supplierId=4683) OR (a.articleSearch='E10811M' AND a.supplierId=220) OR (a.articleSearch='AFF1112' AND a.supplierId=4337) OR (a.articleSearch='0084015912' AND a.supplierId=4995) OR (a.articleSearch='EFP1810' AND a.supplierId=194) OR (a.articleSearch='ADM52349' AND a.supplierId=350) OR ( a.articleSearch IN ('0986580951', '1582804081', '1582804091') AND a.supplierId=30) OR ( a.articleSearch IN ('229025011001Z', 'A2C5334557880', 'A2C5336460680', 'A2C80027900Z') AND a.supplierId=83) OR (a.articleSearch='CBA7513' AND a.supplierId=4334) OR (a.articleSearch='FG214012B1' AND a.supplierId=89) OR ( a.articleSearch IN ('FTC007N', 'GACC096BSCN', 'GACC096HLLN', 'GACC096MRLN') AND a.supplierId=4882) OR (a.articleSearch='1120020004' AND a.supplierId=4345) OR ( a.articleSearch IN ('EF4030', 'XFP8145') AND a.supplierId=4344) OR ( a.articleSearch IN ('770191A', '775238', '775238A') AND a.supplierId=234) OR (a.articleSearch='02SKV770' AND a.supplierId=4969) OR (a.articleSearch='1671038880' AND a.supplierId=4391) OR (a.articleSearch='34604' AND a.supplierId=101) OR ( a.articleSearch IN ('72513', '72513AS') AND a.supplierId=441) OR (a.articleSearch='960941' AND a.supplierId=4379) OR (a.articleSearch='FM72141A' AND a.supplierId=6456) OR (a.articleSearch='401003863' AND a.supplierId=4524) OR (a.articleSearch='8TF358106081' AND a.supplierId=4734) OR (a.articleSearch='65453512' AND a.supplierId=72) OR ( a.articleSearch IN ('133389', '2503389') AND a.supplierId=449) OR (a.articleSearch='GIP511' AND a.supplierId=4726) OR ( a.articleSearch IN ('7507143', '7507143E') AND a.supplierId=341) OR (a.articleSearch='39347' AND a.supplierId=269) OR (a.articleSearch='FS25004' AND a.supplierId=4378) OR (a.articleSearch='LIFETIMEFILTER' AND a.supplierId=287) OR (a.articleSearch='LFP435' AND a.supplierId=6518) OR (a.articleSearch='FDB1906' AND a.supplierId=4501) OR (a.articleSearch='519700000191' AND a.supplierId=4723) OR (a.articleSearch='22789' AND a.supplierId=133) OR (a.articleSearch='MFFZ420' AND a.supplierId=6270) OR (a.articleSearch='430166' AND a.supplierId=403) OR ( a.articleSearch IN ('77143', '77143E') AND a.supplierId=244) OR ( a.articleSearch IN ('770191A', '775238', '775238A') AND a.supplierId=342) OR (a.articleSearch='2250080' AND a.supplierId=94) OR (a.articleSearch='7149190006' AND a.supplierId=144) OR (a.articleSearch='AP44001' AND a.supplierId=6495) OR ( a.articleSearch IN ('PF3954', 'PFP422', 'PFP482') AND a.supplierId=4558) OR (a.articleSearch='700661190' AND a.supplierId=5) OR (a.articleSearch='40010202' AND a.supplierId=4686) OR ( a.articleSearch IN ('QF16A00048', 'QF16A00075') AND a.supplierId=4339) OR (a.articleSearch='QFP1020' AND a.supplierId=57) OR (a.articleSearch='1382F0020' AND a.supplierId=6358) OR ( a.articleSearch IN ('FC1013', 'FH1005') AND a.supplierId=4410) OR (a.articleSearch='SC7063P' AND a.supplierId=225) OR ( a.articleSearch IN ('72513', '72513AS') AND a.supplierId=27) OR (a.articleSearch='SKFU0410019' AND a.supplierId=6357) OR ( a.articleSearch IN ('SFM1079', 'SFP1079', 'VSFF1070') AND a.supplierId=4771) OR (a.articleSearch='1001609SX' AND a.supplierId=4595) OR (a.articleSearch='50934604' AND a.supplierId=151) OR (a.articleSearch='304543' AND a.supplierId=301) OR (a.articleSearch='2044700894' AND a.supplierId=4999) OR ( a.articleSearch IN ('V102477', 'V10091332', 'V25090017') AND a.supplierId=183) OR (a.articleSearch='348752' AND a.supplierId=21) OR ( a.articleSearch IN ('320900460', '320901203') AND a.supplierId=4275) OR ( a.articleSearch IN ('WG1013085', 'WG1025676', 'WG1430401', 'WG1778560', 'WG1822567', 'WG1964976', 'WG2017267') AND a.supplierId=4832) OR ( a.articleSearch IN ('312109', '312239', '313527') AND a.supplierId=6347) OR (a.articleSearch='KP3003' AND a.supplierId=4894) OR (a.articleSearch='JNYB1302' AND a.supplierId=6274)
    -- Быстрая группировка вместо тяжелого DISTINCT по текстовым полям
    GROUP BY m.manufacturerName, ao.oemSearch, ao.oemnumber, ps.id
An internal server error occurred.