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 ('1830128', '73005', '73128', '1830005') AND a.supplierId=4005) OR ( a.articleSearch IN ('330085', '330116', '330126', '555027', '555027A', '661138', '661277', '886058') AND a.supplierId=234) OR ( a.articleSearch IN ('MHG40', 'MHG25', 'MHG55', 'TSE12') AND a.supplierId=287) OR ( a.articleSearch IN ('530005', '530128') AND a.supplierId=4006) OR ( a.articleSearch IN ('6148100000', '3141362102') AND a.supplierId=144) OR ( a.articleSearch IN ('PE13177', 'PE13024', 'PE13158') AND a.supplierId=4558) OR (a.articleSearch='12101041' AND a.supplierId=4657) OR ( a.articleSearch IN ('AEGR617', 'ASTR104') AND a.supplierId=374) OR ( a.articleSearch IN ('51901', '52090') AND a.supplierId=6558) OR ( a.articleSearch IN ('155027N', '751015N', '751051N') AND a.supplierId=80) OR (a.articleSearch='XS2587' AND a.supplierId=4975) OR (a.articleSearch='150000400' AND a.supplierId=257) OR (a.articleSearch='700095' AND a.supplierId=298) OR (a.articleSearch='105578' AND a.supplierId=4495) OR (a.articleSearch='959014' AND a.supplierId=300) OR ( a.articleSearch IN ('AS2078', 'AS2083', 'AV6020') AND a.supplierId=4737) OR ( a.articleSearch IN ('140026410', '150008610', '150039510', '150101410', '150108410') AND a.supplierId=323) OR ( a.articleSearch IN ('PES0193', 'PGR4038') AND a.supplierId=4337) OR (a.articleSearch='0034012759' AND a.supplierId=4995) OR ( a.articleSearch IN ('ST028', 'ST037', 'ST116', 'GR059', 'GR064', '710775D0') AND a.supplierId=6444) OR (a.articleSearch='90036' AND a.supplierId=208) OR (a.articleSearch='EGR0047' AND a.supplierId=6010) OR (a.articleSearch='ADJ137203' AND a.supplierId=350) OR (a.articleSearch='BTS3000' AND a.supplierId=475) OR ( a.articleSearch IN ('0250201952', '0280122005', '0280130026', '0280130055', '0280130107', '0332514120', '0280130023', '0280130068', '0332514103', '0332514130') AND a.supplierId=30) OR ( a.articleSearch IN ('BSG25840008', 'BSG65836005', 'BSG65840028', 'BSG65840029') AND a.supplierId=4455) OR ( a.articleSearch IN ('WS2519', 'WS2587', 'WS3130') AND a.supplierId=215) OR (a.articleSearch='757556' AND a.supplierId=405) OR ( a.articleSearch IN ('323804015001D', '323805009001D') AND a.supplierId=83) OR ( a.articleSearch IN ('CGR4643', 'CGR4643C', 'CGR4954C', 'CIN9421', 'CKJ1614', 'CRP4021', 'CRP5580', 'CRP5590', 'CST9394', 'CST9544', 'CST9577', 'CST9582', 'CST9586', 'CST9592') AND a.supplierId=4334) OR ( a.articleSearch IN ('EG1028812B1', 'EG1028815B1', 'HDC101', 'HDC108', 'HDC122', 'HDC128', 'TS1023912B1', 'TS10250', 'TS10271') AND a.supplierId=89) OR ( a.articleSearch IN ('1301002', '1301012') AND a.supplierId=253) OR ( a.articleSearch IN ('EGR042AN', 'EGR042N', 'EGR042R') AND a.supplierId=4882) OR (a.articleSearch='DS1005' AND a.supplierId=471) OR ( a.articleSearch IN ('1040300019', '1040300023') AND a.supplierId=4345) OR ( a.articleSearch IN ('725871', '760503') AND a.supplierId=355) OR (a.articleSearch='295001' AND a.supplierId=211) OR ( a.articleSearch IN ('EV0006', 'EV0037', 'XTS7705', 'XTS7743', 'XTS8092') AND a.supplierId=4344) OR (a.articleSearch='ENT500043' AND a.supplierId=6889) OR (a.articleSearch='14SKV015' AND a.supplierId=4969) OR ( a.articleSearch IN ('32230', '33010') AND a.supplierId=240) OR ( a.articleSearch IN ('01651', '04675', '12746', '14420', '17695', '39544', '47703') AND a.supplierId=101) OR (a.articleSearch='TSN22850' AND a.supplierId=271) OR (a.articleSearch='FTS3000' AND a.supplierId=407) OR ( a.articleSearch IN ('244021', '244085', '285580', '285590', '82355', '82582', '8301614', '834609', '834643', '83609AS', '83643', '83643AS', '83643R') AND a.supplierId=441) OR (a.articleSearch='EGR12131' AND a.supplierId=235) OR ( a.articleSearch IN ('880205701', '880205803') AND a.supplierId=6484) OR ( a.articleSearch IN ('930061', '992041') AND a.supplierId=4379) OR ( a.articleSearch IN ('CP21101', 'CP73100', 'GV25710005', 'GV40710001', 'VE1022') AND a.supplierId=6456) OR (a.articleSearch='120000041' AND a.supplierId=4524) OR (a.articleSearch='182001' AND a.supplierId=4819) OR ( a.articleSearch IN ('4RV008188081', '4RV008188111', '4RV008188161', '6NU010171711', '6PT009107161', '6PT009107361') AND a.supplierId=4734) OR ( a.articleSearch IN ('70511041', '70511110', '70671411', '75614059') AND a.supplierId=72) OR ( a.articleSearch IN ('132045', '132050', '132053', '132060', '132090', '2502045', '2502050', '2502053', '2502060', '2502090') AND a.supplierId=449) OR ( a.articleSearch IN ('7472033', '7472447', '7518002B', '7518002E', '7518045', '7518045E', '7518502', '9101614', 'H7244021', 'H7285580', 'H7285590') AND a.supplierId=341) OR ( a.articleSearch IN ('14922', '52820', '53027', '55450', '80524') AND a.supplierId=269) OR (a.articleSearch='458009' AND a.supplierId=262) OR (a.articleSearch='EGR0400' AND a.supplierId=156) OR (a.articleSearch='1500400' AND a.supplierId=481) OR (a.articleSearch='AGR5555034' AND a.supplierId=138) OR ( a.articleSearch IN ('1193102200', '1293100800') AND a.supplierId=268) OR (a.articleSearch='KP002' AND a.supplierId=185) OR (a.articleSearch='ECT2002' AND a.supplierId=201) OR ( a.articleSearch IN ('862610014', '881324102') AND a.supplierId=286) OR ( a.articleSearch IN ('163223Z', '163301Z', '50042Z') AND a.supplierId=387) OR (a.articleSearch='8851525' AND a.supplierId=4546) OR ( a.articleSearch IN ('LEGR156', 'LGPR004', 'LWS010', 'LWS207', 'LWS238') AND a.supplierId=6518) OR (a.articleSearch='AGR0058' AND a.supplierId=117) OR ( a.articleSearch IN ('SNB117', 'SNB224', 'SNB809') AND a.supplierId=4501) OR (a.articleSearch='OEV010014' AND a.supplierId=4658) OR ( a.articleSearch IN ('171916011040', '571822112056') AND a.supplierId=4723) OR ( a.articleSearch IN ('83708', '88000', '88704') AND a.supplierId=133) OR ( a.articleSearch IN ('210123', '210124', '270163') AND a.supplierId=403) OR ( a.articleSearch IN ('EEGOP29', 'EPS1830005', 'EPS1830128') AND a.supplierId=4773) OR ( a.articleSearch IN ('01614', '7244021', '7285580', '7285590', '82033', '82447', '88002B', '88002E', '88045', '88045E', '88502', '88545') AND a.supplierId=244) OR (a.articleSearch='93006' AND a.supplierId=4664) OR ( a.articleSearch IN ('0892012', '0905007', '0905025') AND a.supplierId=94) OR ( a.articleSearch IN ('LVCT210', 'LVCT400', 'LVER161', 'VCT138') AND a.supplierId=4564) OR ( a.articleSearch IN ('3029', '4001', '4051') AND a.supplierId=320) OR (a.articleSearch='N5620503' AND a.supplierId=248) OR (a.articleSearch='98227' AND a.supplierId=123) OR ( a.articleSearch IN ('00295', '00296', '21602', '35097') AND a.supplierId=4683) OR (a.articleSearch='PTA5100012' AND a.supplierId=6457) OR (a.articleSearch='JAPEGR0400' AND a.supplierId=4652) OR ( a.articleSearch IN ('722414080', '722414010', '722515010') AND a.supplierId=5) OR ( a.articleSearch IN ('QF25A00031', 'QF25A00075', 'QF25A00078', 'QF25A00081') AND a.supplierId=4339) OR ( a.articleSearch IN ('XEGR6', 'XEMS3', 'XTT141', 'XTT20') AND a.supplierId=57) OR ( a.articleSearch IN ('1145E0035', '830C0013', '830C0018') AND a.supplierId=6358) OR (a.articleSearch='0963710' AND a.supplierId=4623) OR ( a.articleSearch IN ('3250015', '3256017') AND a.supplierId=260) OR ( a.articleSearch IN ('E534413', 'E534454') AND a.supplierId=6377) OR (a.articleSearch='105600' AND a.supplierId=263) OR ( a.articleSearch IN ('244021', '244085', '28557', '285580', '285590', '82355', '82582', '8301614', '834609', '834643', '83609AS', '83643', '83643AS', '83643R') AND a.supplierId=27) OR ( a.articleSearch IN ('SKCTS0850012', 'SKCTS0850017', 'SKEGR0770034') AND a.supplierId=6357) OR (a.articleSearch='T493006' AND a.supplierId=4667) OR ( a.articleSearch IN ('0125024SX', '0125090SX', '0604008SX', '0604010SX', '201019SX', '201039SX', '201043SX') AND a.supplierId=4595) OR ( a.articleSearch IN ('37933770', '40230003', '40904675', '40917695', '40939544', '40947703', '50914420', '70912746') AND a.supplierId=151) OR (a.articleSearch='BP101' AND a.supplierId=6312) OR ( a.articleSearch IN ('202328', '202366') AND a.supplierId=301) OR (a.articleSearch='347002' AND a.supplierId=4970) OR ( a.articleSearch IN ('862610014', '881324102') AND a.supplierId=108) OR (a.articleSearch='0840042' AND a.supplierId=209) OR ( a.articleSearch IN ('TR00548', 'TR00570') AND a.supplierId=4949) OR ( a.articleSearch IN ('13621284397', '13621357414') AND a.supplierId=4999) OR ( a.articleSearch IN ('700005', '700019') AND a.supplierId=21) OR (a.articleSearch='VE90036' AND a.supplierId=4425) OR ( a.articleSearch IN ('V20720443', 'V25710005', 'V40630009', 'V406300091', 'V40710001', 'V40720320', 'V40720322') AND a.supplierId=183) OR ( a.articleSearch IN ('98450000101', '99191783001') AND a.supplierId=4346) OR (a.articleSearch='2141003' AND a.supplierId=303) OR ( a.articleSearch IN ('240670008', '240670014', '240670016', '330690011', '330690017', '330690066', '330690545', '330690740', '330690748', '410580016', '410580218') AND a.supplierId=4275) OR ( a.articleSearch IN ('WG1014780', 'WG1015231', 'WG1026770', 'WG1054658', 'WG1409970', 'WG1429634', 'WG1429759', 'WG1430054', 'WG1445339', 'WG1445352', 'WG1486231', 'WG1492388', 'WG1492418', 'WG1494470', 'WG1496171', 'WG1498977', 'WG1498985', 'WG1498990', 'WG1499607', 'WG1499628', 'WG1748866', 'WG1749919', 'WG1749924', 'WG1749926', 'WG1795619', 'WG1795713', 'WG1795973', 'WG1837871', 'WG1937659', 'WG1966125', 'WG1966133', 'WG2015728') AND a.supplierId=4832) OR ( a.articleSearch IN ('130137', '320417', '320421', '320995', '520039', '550093') AND a.supplierId=6347) OR (a.articleSearch='TSE12' AND a.supplierId=382) -- Быстрая группировка вместо тяжелого DISTINCT по текстовым полям GROUP BY m.manufacturerName, ao.oemSearch, ao.oemnumber, ps.id An internal server error occurred.