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 ('10089', '09401', '10101', '103214', '10824', '14941', '14945', '37597') AND a.supplierId=101) OR ( a.articleSearch IN ('22407184S', '22407019S', '22421010S', '22421011S') AND a.supplierId=4727) OR ( a.articleSearch IN ('4342450100', '4342400400') AND a.supplierId=268) OR ( a.articleSearch IN ('MB1504', 'SM1018', 'SM1503', 'SM1504', 'SM1507', 'SM1514', 'SM1528') AND a.supplierId=85) OR ( a.articleSearch IN ('34107', '33150', '331502', '33156', '33163', '33166', '34100', '34101', '341012', '34110', '34111') AND a.supplierId=133) OR ( a.articleSearch IN ('F83032', 'F85488', 'F85492', 'F85813', 'F86329', 'F86339', 'F86376', 'F88088', 'F86377') AND a.supplierId=129) OR ( a.articleSearch IN ('35865', '11749', '11456') AND a.supplierId=4683) OR ( a.articleSearch IN ('4001602', '4001620', '4005300', '2654001') AND a.supplierId=260) OR ( a.articleSearch IN ('M25504', 'KB65503', 'KB65504', 'KB65507', 'KB65514', 'KB65528', 'KB65550', 'KB65543') AND a.supplierId=110) OR ( a.articleSearch IN ('45610', '45611', '45612', '45627', '45633', '45634', '45635', '45636', '45653') AND a.supplierId=4598) OR ( a.articleSearch IN ('18674', '18698', '18834') AND a.supplierId=317) OR ( a.articleSearch IN ('30315', '30498') AND a.supplierId=4576) OR ( a.articleSearch IN ('SMA0022', 'SMA0136', 'SMA0248') AND a.supplierId=257) OR (a.articleSearch='FT1937' AND a.supplierId=4737) OR ( a.articleSearch IN ('110105710', '110105810', '110116210', '110202010', '210368010') AND a.supplierId=323) OR (a.articleSearch='4408040' AND a.supplierId=4306) OR ( a.articleSearch IN ('0011016866', '0011022637', '0011028875', '0011028882', '0011028930') AND a.supplierId=4995) OR ( a.articleSearch IN ('043465B', '043514B', '043515B', '043594B', '043758B', '043765B', '043801B', '047951B') AND a.supplierId=49) OR ( a.articleSearch IN ('SM7306', 'SM7310', 'SM7321', 'SM9539') AND a.supplierId=478) OR (a.articleSearch='12288724' AND a.supplierId=16) OR ( a.articleSearch IN ('50204', '52221', '5689', '59008', '59009', '59010', '59026', '59065', '59137', '59200', '59224', '6267') AND a.supplierId=208) OR ( a.articleSearch IN ('87384L', '87943A', '87401A') AND a.supplierId=14) OR ( a.articleSearch IN ('BSM5074', 'BSM5075', 'BSM5171', 'BSM5233') AND a.supplierId=475) OR ( a.articleSearch IN ('5432500QAA', '7700426450') AND a.supplierId=6366) OR (a.articleSearch='BSG75700026' AND a.supplierId=4455) OR ( a.articleSearch IN ('020129', '020471', '020928', '021318', '021319', '021320', '021343') AND a.supplierId=405) OR ( a.articleSearch IN ('700426450', '700827436', '760025850') AND a.supplierId=6411) OR ( a.articleSearch IN ('CTSM9029', 'CTSM9124') AND a.supplierId=421) OR ( a.articleSearch IN ('80000948', '80000968', '80001664', '80003824') AND a.supplierId=140) OR (a.articleSearch='153003' AND a.supplierId=6479) OR ( a.articleSearch IN ('BSJ10073', 'BSJ10078', 'BSJ30011') AND a.supplierId=89) OR ( a.articleSearch IN ('D600016', 'D600024', 'D600148', 'D600190') AND a.supplierId=186) OR ( a.articleSearch IN ('AF02003', 'B1046', 'C4001', 'C4005', 'C5005') AND a.supplierId=4396) OR (a.articleSearch='1441207' AND a.supplierId=253) OR ( a.articleSearch IN ('7324048', '7324050', '7324087') AND a.supplierId=4135) OR ( a.articleSearch IN ('22SM022', '22SM023', '22ST606', '22ST608') AND a.supplierId=4003) OR (a.articleSearch='1638384180' AND a.supplierId=4391) OR ( a.articleSearch IN ('713039220', '814008510', '814008810', '814009210', '815004730', '815007430') AND a.supplierId=192) OR ( a.articleSearch IN ('SS3046', 'SS7930', 'SS9082', 'SS9086') AND a.supplierId=267) OR ( a.articleSearch IN ('10368', '10627', '1953', '2543', '2566') AND a.supplierId=4834) OR ( a.articleSearch IN ('FT12003', 'FT12226') AND a.supplierId=4938) OR (a.articleSearch='RNBLOG' AND a.supplierId=4674) OR ( a.articleSearch IN ('SM34010', 'SMB24002') AND a.supplierId=271) OR ( a.articleSearch IN ('FSM5074', 'FSM5075', 'FSM5171', 'FSM5233') AND a.supplierId=407) OR ( a.articleSearch IN ('FL2921J', 'FL4377J', 'FL4381J') AND a.supplierId=236) OR ( a.articleSearch IN ('GK243', 'GK244', 'GK523') AND a.supplierId=4639) OR ( a.articleSearch IN ('SM0082', 'SM0083', 'SM0112', 'SM0146', 'SM0389', 'SM0430') AND a.supplierId=6443) OR ( a.articleSearch IN ('510762', '510763S', '510777', '513958S', '514253', '532251S', '532720S', '532806S') AND a.supplierId=373) OR (a.articleSearch='J4421002' AND a.supplierId=72) OR ( a.articleSearch IN ('200003', '590584', '597153', '599041') AND a.supplierId=239) OR ( a.articleSearch IN ('SM0022', 'SM0136', 'SM0248') AND a.supplierId=156) OR ( a.articleSearch IN ('SMJ0022', 'SMJ0136', 'SMJ0248') AND a.supplierId=481) OR (a.articleSearch='BM43001' AND a.supplierId=6786) OR ( a.articleSearch IN ('209015', '209024', '209261') AND a.supplierId=185) OR ( a.articleSearch IN ('850025903', '850025908') AND a.supplierId=286) OR ( a.articleSearch IN ('21003Z', '21600Z', '21602Z', '21630Z') AND a.supplierId=387) OR ( a.articleSearch IN ('4092057', '4095150', '4095152') AND a.supplierId=4546) OR ( a.articleSearch IN ('1214301', '2951701', '3140701', '12143', '29517', '31407') AND a.supplierId=35) OR ( a.articleSearch IN ('MA1090LR', 'MA1152LR', 'MA5010LR') AND a.supplierId=4600) OR ( a.articleSearch IN ('030607010752', '030607010760', '030607010761') AND a.supplierId=4723) OR ( a.articleSearch IN ('A7R009MT', 'A7R021MT', 'A7R026MT', 'A7R031', 'A7R031MT', 'A7R051MT') AND a.supplierId=4427) OR ( a.articleSearch IN ('180015070', '180015280', '8200651172SETMS') AND a.supplierId=358) OR ( a.articleSearch IN ('721656', '722109', '722529', '722789', '723306') AND a.supplierId=403) OR (a.articleSearch='MRP2B03' AND a.supplierId=4773) OR ( a.articleSearch IN ('02769', '04110', '04153', '04180', '05457', '05766') AND a.supplierId=4664) OR ( a.articleSearch IN ('6490039', '6490040', '6490042', '6490043', '6490139', '6490223', '6490229', '6490233', '6490234', '6490238', 'KB65507', 'WMF0105', 'WMF0107', 'WMF3615', 'WMF7677', 'WMF8403', 'WMF9529', 'KB65504') AND a.supplierId=94) OR ( a.articleSearch IN ('16140420002', '16146410003', '16146410004', '16146410004S', '16146410005S') AND a.supplierId=144) OR ( a.articleSearch IN ('DB31155', 'DB31161') AND a.supplierId=6495) OR (a.articleSearch='137100091' AND a.supplierId=6376) OR ( a.articleSearch IN ('L25903', 'L25908', 'MK018', 'MK020', 'MK100') AND a.supplierId=4752) OR (a.articleSearch='RESB9988' AND a.supplierId=134) OR (a.articleSearch='LVSM1089' AND a.supplierId=4564) OR ( a.articleSearch IN ('673901', '673903', '673908', '683901', '683910') AND a.supplierId=127) OR (a.articleSearch='ADRE002' AND a.supplierId=6355) OR ( a.articleSearch IN ('SMB400300', 'SMK300500', 'SMK301500', 'SMK302300', 'SMK302900', 'SMK303700', 'SMK305800') AND a.supplierId=378) OR ( a.articleSearch IN ('31606', '316062', '31607', '316072', '32736', '327362', '32742', '327422', '32743', '327432', '32744', '327442', '36540', '36541', '36568', '36572', '365722', '36790', '367902', '36936', '369362', '36959') AND a.supplierId=331) OR ( a.articleSearch IN ('PSE1345', 'PSE4004', 'PSE40309', 'PSE4342', 'PSE4489', 'PSE4568', 'PSE4601') AND a.supplierId=4558) OR ( a.articleSearch IN ('BAB5504', 'KSA021', 'KSA022', 'KSA027', 'PCM055', 'PCM061') AND a.supplierId=4655) OR (a.articleSearch='23140514' AND a.supplierId=4686) OR ( a.articleSearch IN ('EMA3195', 'EMA5045', 'EMA5055', 'EMA6007', 'EMR4947', 'EMR5027', 'EMR6007', 'EMR6014', 'QAM112') AND a.supplierId=57) OR ( a.articleSearch IN ('R52194', 'R55129', 'R55129K', 'R59837', 'R59887K') AND a.supplierId=4303) OR ( a.articleSearch IN ('BCRESM004', 'BCRESM010', 'BCRESM014', 'BCST27', 'BCST48', 'BCST49') AND a.supplierId=6698) OR ( a.articleSearch IN ('825506', '825509', '825509S', '825515', '829701S', '865501') AND a.supplierId=23) OR ( a.articleSearch IN ('801001', '802310', '802078') AND a.supplierId=32) OR (a.articleSearch='BS21002' AND a.supplierId=6377) OR ( a.articleSearch IN ('70001K', '70010K', '70064K') AND a.supplierId=6322) OR ( a.articleSearch IN ('805411', '805416') AND a.supplierId=135) OR ( a.articleSearch IN ('VKDA35600', 'VKDA35600T', 'VKDA35601', 'VKDA35601T', 'VKDA35607', 'VKDA35607T', 'VKDA35633', 'VKDA35633T', 'VKDA35636', 'VKDA35636T') AND a.supplierId=50) OR ( a.articleSearch IN ('413360', '413392') AND a.supplierId=6363) OR ( a.articleSearch IN ('T402769', 'T404110', 'T404153', 'T404180', 'T405457', 'T405766') AND a.supplierId=4667) OR ( a.articleSearch IN ('1217432SX', '1237094SX', '2617121SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('60103214', '60540001', '60540013', '60550003', '60550008', '60560003', '60914945', '60937597') AND a.supplierId=151) OR ( a.articleSearch IN ('6301795', '6301797', '6302150') AND a.supplierId=4758) OR ( a.articleSearch IN ('BU6615', 'KSU6614', 'KSU6615', 'KSU6618', 'KSU6639') AND a.supplierId=6312) OR ( a.articleSearch IN ('TED38590', 'TED79655') AND a.supplierId=4593) OR ( a.articleSearch IN ('RESM004', 'RESM010', 'RESM014', 'ST27', 'ST48', 'ST49') AND a.supplierId=4414) OR ( a.articleSearch IN ('700109', '700131', '700353', '701935') AND a.supplierId=301) OR (a.articleSearch='SA0157' AND a.supplierId=4772) OR ( a.articleSearch IN ('785064', '785067', '785323') AND a.supplierId=4970) OR ( a.articleSearch IN ('850025903', '850025908') AND a.supplierId=108) OR ( a.articleSearch IN ('JSL204', 'JSL205', 'JSP523') AND a.supplierId=4501) OR ( a.articleSearch IN ('10448', '10484', '10484B', '10493B', '10503', '10699', '10701', '10701B', '10704', '10758', '10759') AND a.supplierId=6311) OR ( a.articleSearch IN ('391058', '391700CU', '392751') AND a.supplierId=4730) OR ( a.articleSearch IN ('V460332', 'V460333') AND a.supplierId=183) OR ( a.articleSearch IN ('17866', '44007', '44008', '44009', '44021', '44064', '44106', '44133', 'VE50204', 'VE52221', 'VE5689', 'VE6267') AND a.supplierId=4425) OR ( a.articleSearch IN ('WG1795810', 'WG1994904', 'WG2034188', 'WG2034280') AND a.supplierId=4832) OR ( a.articleSearch IN ('GM2049', 'GM2446') AND a.supplierId=4894)
    -- Быстрая группировка вместо тяжелого DISTINCT по текстовым полям
    GROUP BY m.manufacturerName, ao.oemSearch, ao.oemnumber, ps.id
An internal server error occurred.