SELECT o.articlenumber, b.title as suppliername, o.supplierid, sup.id AS id FROM tecdoc2021.article_oem o /*INNER JOIN tecdoc2021.supplier s ON s.supplierid = o.supplierid*/ INNER JOIN tecdoc2021.article a ON a.articlenumber = o.articlenumber AND a.supplierid = o.supplierid INNER JOIN products.brands b ON b.offline_tecdoc_id = o.supplierid INNER JOIN LATERAL ( SELECT ps.id FROM products.products p INNER JOIN products.products_suppliers as ps ON ps.product_id = p.id WHERE p.article = a.articlesearch AND p.brand_id = b.main_id AND ps.supplier_id IN (223,225,226,224,227) AND ps.quantity > 0 LIMIT 1 ) sup ON true WHERE (( o.oemSearch IN ('14148190', '14152090') AND o.manufacturerId=3854) OR ( o.oemSearch IN ('02333045', '02333540', '02333730', '1297700611', '18EER270408', '18ZZ02333045', '3005978') AND o.manufacturerId=1) OR ( o.oemSearch IN ('207002547', 'D45080900', 'D45081300', 'E400148', 'SH2640', 'X671306000000', 'X825107045000', 'X825283299000', 'X825283480000') AND o.manufacturerId=1033) OR ( o.oemSearch IN ('4132221A', '4198674A') AND o.manufacturerId=912) OR ( o.oemSearch IN ('71739587') AND o.manufacturerId=255) OR ( o.oemSearch IN ('14145020', '14145090', '14148190', '14152090', '60800962', '71739587', '71771970', '71779057', '9406216658', '9406216968') AND o.manufacturerId=2) OR ( o.oemSearch IN ('YY00629', '02435002') AND o.manufacturerId=0) OR ( o.oemSearch IN ('0200370709', '0690370707') AND o.manufacturerId=881) OR ( o.oemSearch IN ('0353506', '1089036501', '1089057601', '1091036100', '1813000005', '1813000022', '1814000008', '181400010A', '3600136106', '3637367', '388450', '3981604', '448646', '5350642349') AND o.manufacturerId=917) OR ( o.oemSearch IN ('000045239', '165945097', '191953050C', '1C0943105', '1C0943105GRU', '1C0943106', '1C0943106GRU', '1H0949101', '1J0411315C', '1J0411315J', '2D0945095C', '2K0949117', '357949101', '4A0949101', '4D0949101', '5P0947111', '5P0947111Y20', '8X0945981', 'J7AZZZ90021', 'J8127089126', 'J9007599012', 'J9913211210', 'J9913212050', 'KDWHLO9236', 'KDWHLO9589', 'N0177102', 'N0177193', 'N0177195', 'N0177252', 'N0177322', 'N0177324', 'N0177326', 'N01775310', 'N0177532', 'N0177535', 'N0177538', 'N0177632', 'N0177632Z', 'N0177636', 'N0177642', 'N0177642Z', 'N0177643', 'N0177643Z', 'N10130001', 'N10320101', 'N10320102', 'N10320103', 'N10323001', 'N10566101', 'N10566103', 'Z046022', 'Z046027', 'Z046050', 'Z046056') AND o.manufacturerId=5) OR ( o.oemSearch IN ('02164220', 'KDWHLO9589', 'N10320101', 'N10320102') AND o.manufacturerId=2858) OR ( o.oemSearch IN ('128404152') AND o.manufacturerId=3773) OR ( o.oemSearch IN ('0026294', '0035164', '0141179', '0141181', '0141182', '0151620', '0151622', '0152962', '0152965', '0309671', '0395443', '0395445', '0395459', '0395470', '0397159', '0398942', '07119904789', '07119904790', '07119905013', '07119905345', '07119978340', '07119978370', '07119978373', '07500152965', '07509063574', '07509063578', '1354619', '1382496', '2165687', '2306150', '3436336', '51137004537', '51138236878', '63120026294', '63120035164', '63121354619', '63121354619S1', '63121382496', '63122165687', '63126904931', '63126926916', '63128361007', '63128361289', '63128523990', '63132306150', '63171386816', '63210151620', '63210151622', '63210152962', '63210309671', '63210395443', '63210395445', '63210395459', '63210395470', '63210397159', '63210398155', '63210398210', '63210398942', '63216926910', '63216926911', '63216926916', '63216926920', '63216926926', '63216926927', '63216926929', '63217160780', '63217160781', '63217160786', '63217160789', '63217160790', '63217160796', '63217160797', '63217160805', '63217160806', '63217160807', '63217162861', '63217162862', '63217164759', '63217217509', '63316962045', '63316963194', '63318363604', '6904931', '6926910', '6926911', '6926916', '6926926', '6926927', '6926929', '7119978340', '7119978370', '71199978340', '71199978373', '7160780', '7160781', '7160786', '7160789', '7160796', '7160797', '7160805', '7160807', '7162862', '7217509', '75000152965', '7509063574', '7509063578', '75099063578', '8361007', '8361289', '88100141179', '88100141181', '88100141182', '88100151629', '88100151630', '9063574', '9063578', '9905013', '9905345', '9978340', '9978370', '9978373') AND o.manufacturerId=16) OR ( o.oemSearch IN ('07119978373', '1382496', '3436336', '63121382496', '9978373') AND o.manufacturerId=3124) OR ( o.oemSearch IN ('05751014', '05751179', '05751267', '38051661') AND o.manufacturerId=660) OR ( o.oemSearch IN ('93175452') AND o.manufacturerId=819) OR ( o.oemSearch IN ('07073874', '140772015', '14148190', '190003452245', '244872', '2900359', '3131227R1', '398877', '470017', '7024794', '80398877', '80470017', '84058228', '98028276') AND o.manufacturerId=661) OR ( o.oemSearch IN ('03230800', '3230800', '9W3326') AND o.manufacturerId=937) OR ( o.oemSearch IN ('000000H7', '0000021W', '00000W5W', '2098201', '2098252', '2098345', '2098354', '2098458', '2098928', '21W', '90002486', '90002520', '90512338', '93169040', '93188009', '93190461', '93190466', '93190473', '9375452', 'H7') AND o.manufacturerId=138) OR ( o.oemSearch IN ('04865941AA', '04865941AC', '05104684AA', '154890AA', '21W', '5104684AA', '71739587', '71779057', 'L0000000H7', 'L0009006XS') AND o.manufacturerId=20) OR ( o.oemSearch IN ('1607699080', '1608368680', '1608386080', '1608386180', '1608386280', '1608386380', '1608386880', '1608386980', '1608387080', '1608387180', '1608704080', '1608704180', '1608753380', '1617923980', '21696', '621627', '621630', '621632', '621651', '621655', '621656', '621666', '621679', '621680', '621696', '621697', '621699', '6216A1', '6216A4', '6216E3', '630399', '6362R3', '6362Y9', '637133', '637135', '637153', '637211', 'BNL5124024') AND o.manufacturerId=21) OR ( o.oemSearch IN ('621627', '621651', '621655', '621656', '621660', '621665', '621666', '621696', '621697', '621699', '6216A1', '6216A4', '6216A8', '6216A9', '6216E3', '6216E4', '6216E5', '637133', '637211', '637233', '96826H', '96826HS') AND o.manufacturerId=804) OR ( o.oemSearch IN ('0001779060', '0002164220', '00148800', '00175800', '02157650', '02164220', '04540242', '11335600', '11335601', '11412070', '2335460', '6005029128', '7703097178', '7703097181', '7703097516') AND o.manufacturerId=750) OR ( o.oemSearch IN ('7701040849', '7701057737', '7703087187', '7703097171', '7703097178', '7703097181', '7703097516') AND o.manufacturerId=139) OR ( o.oemSearch IN ('21W', 'H7') AND o.manufacturerId=185) OR ( o.oemSearch IN ('0119021', '0119022', '0176042', '0616170', '0878003', '0878006', '0878013', '0882009', '119021', '1354854', '1354862', '1354863', '1354871', '1354888', '1426625', '1442611', '1525168', '1525962', '1528531', '1637337', '1669676', '176042', '5011791', 'MBU0382') AND o.manufacturerId=24) OR ( o.oemSearch IN ('21W', '9004951144') AND o.manufacturerId=25) OR ( o.oemSearch IN ('42108012', '42440912', '42440912WIRD261', '46000200', '46001800', '50737299', '64094740', '76961873', '97683573', '99575573') AND o.manufacturerId=821) OR ( o.oemSearch IN ('01592040') AND o.manufacturerId=2276) OR ( o.oemSearch IN ('001592040', '090011627') AND o.manufacturerId=751) OR ( o.oemSearch IN ('1617923980', '621651', '621697', '6216A1', '6216A4', '637133', '637211') AND o.manufacturerId=4468) OR ( o.oemSearch IN ('000000002723', '072601012130', '072601012190', '072601024131', '072601024701', '072601024702', '72601012190', 'A000000002723', 'A072601012130', 'A072601012190', 'A072601024131', 'A072601024701', 'A072601024702') AND o.manufacturerId=827) OR ( o.oemSearch IN ('1732172M1', '99700030230', '99707016350') AND o.manufacturerId=145) OR ( o.oemSearch IN ('007136') AND o.manufacturerId=5434) OR ( o.oemSearch IN ('3907271M1', 'D45080900', 'D450809000000', 'D45081300', 'E400000', 'E400000000000', 'F015900080100', 'X671306000000', 'X825107045000', 'X825283214000', 'X825283215000', 'X825283248000', 'X825283299000', 'X825283480000') AND o.manufacturerId=752) OR ( o.oemSearch IN ('10863090') AND o.manufacturerId=700) OR ( o.oemSearch IN ('1121444', '14145020', '14145090', '14148190', '14152090', '6087720521', '7093233041', '71718217', '71739587', '71741895', '71741900', '71779057', '7905527031', '7905527071', '9406216998') AND o.manufacturerId=35) OR ( o.oemSearch IN ('1013710', '1013711', '1013818', '1022342', '1066802', '1108913', '1109206', '1148422', '1202040', '1467659', '1494698', '1536494', '1591848', '1610595', '1610596', '1S7A13466AA', '2080258', '2U5A13N021AA', '32010159', '3426699', '3898059', '4329640', '4502332', '4599268', '4651964', '4659720', '4671368', '5013586', '5016713', '5018748', '5N6A13465AA', '5T2A13465AA', '6079730', '6090983', '6090984', '6137990', '6479205', '69AG13465CA', '73EG13009AA', '81AG13465AA', '81AG13465AAELB501', '81AG13466DA', '83BG13009AA', '83BG13465AA', '83BG13465AAELB930', '83BG13466AAELB926', '93BG13009AA', '93BG13009BA', '93BJ13009BA', '95FG13466AA', '95FG13466AAELB101', '980X13009AA', 'E5RY13466B', 'E9JY13466A', 'ELB101', 'ELB233', 'ELB23381AG13466DA', 'ELB23969AG13465CA', 'ELB486', 'ELB48693BG13009BA', 'ELB5000', 'ELB930', 'ELB9305G5A13465AA', 'F32Z13466K', 'F37D13465BA', 'F3TZ13466B', 'F4ZZ13466A', 'F5RZ13466C', 'F6DZ13466GA', 'F8RZ13466BA', 'N102564VX01', 'YM2113009DA') AND o.manufacturerId=36) OR ( o.oemSearch IN ('32010159', '81AG13465AA', '81AG13466BA', '83BG13465AA', '95FG13466AA') AND o.manufacturerId=776) OR ( o.oemSearch IN ('LSX0032002') AND o.manufacturerId=37) OR ( o.oemSearch IN ('090002486', '090002520', '090512338', '09271187', '11515298', '12533135', '13503427', '2098252', '2098345', '2098352', '2098354', '2098458', '2098580', '2098928', '2098946', '21019521', '25735604', '25911883', '43191200', '90002486', '90002520', '90013538', '90013538S1', '90114440', '90512338', '91145661', '91145674', '91146405', '91149650', '91155679', '91158331', '9117208', '9159284', '9271187', '93169007', '93169036', '93169040', '93169041', '93175452', '93176430', '93188009', '93190461', '93190462', '93190466', '93190471', '93190473', '93892657', '94051108', '94535545', '94536018') AND o.manufacturerId=753) OR ( o.oemSearch IN ('19346') AND o.manufacturerId=833) OR ( o.oemSearch IN ('00841009', '00841014', '01288020', '0841009N072601012190', '19741164', '19741180') AND o.manufacturerId=909) OR ( o.oemSearch IN ('00209600', '1277499', '283150', '400809000007') AND o.manufacturerId=957) OR ( o.oemSearch IN ('260317', '6501220295', '6501220299', '6502010093', '6502080093') AND o.manufacturerId=1500) OR ( o.oemSearch IN ('2098252', '43191200', '6777426', '9159284') AND o.manufacturerId=801) OR ( o.oemSearch IN ('025816', '030759', 'Z75588') AND o.manufacturerId=666) OR ( o.oemSearch IN ('21W', '33104SL5A02', '33110S1AG01', '33110S1AG51', '33110SMGE01', '33110SMGE01HE', '33111S6DG01HE', '33115S04G02', '33115SM4003', '33115SV4003', '33115SV4G01', '33115SYYJ01', '33115TF0G01', '33116S84A01', '33116S84A11', '33116SH3A01', '33116SL0003', '33116ST7003', '33116SV4A01', '33116SV4A01HE', '33119SAA013', '33119TA0003', '33301SA0741', '33301ST3E01', '33302S04G02', '34103S2K003', '34253SP0003', '34253SZ3003', '34295S6DE01', '34295SJ8003', '34295SMGE01', '34306MN5701', '34306SH3003', '34351657921', '34351SN7G00', '34901S6DG01', '34901S6DG01HE', '34908KS3900', '34908SB6003', '34908SB6741', 'H7') AND o.manufacturerId=45) OR ( o.oemSearch IN ('030759', '0417337', '041733700', '0417343', '041734300', '0417382', '0864935', '1017212', '1053969', '1053986', '1209410', '120941000', '1278879', '160317021017212', '1608677', '1758324', '417343', '417382', '864935') AND o.manufacturerId=2170) OR ( o.oemSearch IN ('1864221008', '1864221008E', '1864221008L', '1864221008N', '1864305009', '1864305009N', '1864421058N', '1864735006', '1864755007', '1864755007K', '1864755007L', '1864755007S', '1864761566', '1864761566E', '1864761566L', '1864955009', '21LN50410', '21W', '3077215500L', 'H7', 'S1864755007L') AND o.manufacturerId=183) OR ( o.oemSearch IN ('000000000H7', '00000000H7', '0000000H7', '01121444', '10863090', '10863190', '1102550', '1121444', '1121448', '14145090', '14148190', '16847791', '413262400001', '42559773', '445142103', '500001016', '500022390', '5003097032', '5003097055', '503129491', '503138535', '503470723', '503645192', '7301661', '7703097171', '7703097181', '8191432', '8191455', '9981178', 'H7') AND o.manufacturerId=55) OR ( o.oemSearch IN ('21W', 'C2N1716', 'H7') AND o.manufacturerId=56) OR ( o.oemSearch IN ('72010005', '842003031') AND o.manufacturerId=837) OR ( o.oemSearch IN ('21W') AND o.manufacturerId=882) OR ( o.oemSearch IN ('2604175', '57M6274', '57M7014', '57M7086', '57M7166', '57M7615', 'CC119178', 'L150689', 'WZ2604175', 'Z75588') AND o.manufacturerId=755) OR ( o.oemSearch IN ('14731930', '16028440', '18726', '28300160', '28306630', '449090012', '449090087', '50035531', '50234908', '50468123', '51169750', '51169927') AND o.manufacturerId=2383) OR ( o.oemSearch IN ('75811750000') AND o.manufacturerId=59) OR ( o.oemSearch IN ('001592040', '090011627') AND o.manufacturerId=60) OR ( o.oemSearch IN ('0K53A5103C', '0K91A51055', '1864221008', '1864221008E', '1864221008L', '1864221008N', '1864305009', '1864305009E', '1864305009N', '1864735006', '1864755007L', '1864761566', '1864761566L', '21W', 'H7') AND o.manufacturerId=184) OR ( o.oemSearch IN ('050756', '605057', 'K605057', 'R01020205', 'T050056', 'T050756') AND o.manufacturerId=2635) OR ( o.oemSearch IN ('1732172M1', '322801M1', '76961873') AND o.manufacturerId=975) OR ( o.oemSearch IN ('0025440094', '1000109712', '56511') AND o.manufacturerId=976) OR ( o.oemSearch IN ('03038640', '09246930', '09247090', '09247140', '09440620', '14405007', '200802330', '200818630', '200843000', '270101770', '9305220', '9440620', 'N10320101') AND o.manufacturerId=2218) OR ( o.oemSearch IN ('3J03222311', '3J08013961', 'R249153510', 'TA04930040', 'TA04930041') AND o.manufacturerId=977) OR ( o.oemSearch IN ('52720') AND o.manufacturerId=63) OR ( o.oemSearch IN ('14145020', '14145090', '14148190', '14152090', '71739587', '71779057') AND o.manufacturerId=64) OR ( o.oemSearch IN ('21W', '589783', 'BR0477P', 'H7', 'LR000701', 'LR000703', 'LR000705', 'LR000863', 'LR021904', 'RTC3633', 'XBI000030', 'XBI500020', 'XZQ000010') AND o.manufacturerId=1820) OR ( o.oemSearch IN ('1134850', '1134860', '1135274', 'B170992') AND o.manufacturerId=2219) OR ( o.oemSearch IN ('0000000W5W', '21W') AND o.manufacturerId=842) OR ( o.oemSearch IN ('10044613', '10331504', '6000071', '6000864', '6070013', '607011101', '607011301', '607013401', '6070201', '607020108', '607020114', '6070213', '6070220', '6200697', '6905324', '7026907', 'A400809000007') AND o.manufacturerId=679) OR ( o.oemSearch IN ('0029741702', '7919500971', '7919518929', '7919564920', 'N10320101') AND o.manufacturerId=1029) OR ( o.oemSearch IN ('3000297', '3000318', '3204085') AND o.manufacturerId=3927) OR ( o.oemSearch IN ('5801012') AND o.manufacturerId=2649) OR ( o.oemSearch IN ('07920081805', '07920083007', '07920083011', '7920081805', '81259010073', '83259010504', 'T381', 'ZF259017007', 'ZF259017008', 'ZF259017057', 'ZF920006658') AND o.manufacturerId=69) OR ( o.oemSearch IN ('000676', '563881', '563882', '675', '741480', '745991', '775776') AND o.manufacturerId=2386) OR ( o.oemSearch IN ('000208860') AND o.manufacturerId=771) OR ( o.oemSearch IN ('3713341M1') AND o.manufacturerId=669) OR ( o.oemSearch IN ('1N15510X4', '1N19510X4', '1N21510X4', '21W', '907032550', '907036350', '997032605', '997037550', '997038605', '9970STH755', '9970STHB4', '9970XED2S', '9S9HB12182', 'D530510H3', 'H7') AND o.manufacturerId=72) OR ( o.oemSearch IN ('000000000069', 'A000000000069', '000000000374', 'A000000000374', '000000000853', 'A000000000853', '000000002723', 'A000000002723', '000000004248', 'A000000004248', '000000006373', 'A000000006373', '000000007419', 'A000000007419', '000000008146', 'A000000008146', '000000008156', 'A000000008156', '0002481V002L044', 'A0002481V002L044', '0005449094', 'A0005449094', '0008250394', 'A0008250394', '0025440094', 'A0025440094', '072601012130', 'A072601012130', '072601012190', 'A072601012190', '072601012191', 'A072601012191', '072601012703', 'A072601012703', '072601012803', 'A072601012803', '072601012805', 'A072601012805', '072601024131', 'A072601024131', '072601024701', 'A072601024701', '072601024702', 'A072601024702', '0999067000', 'A0999067000', '1248200256', 'A1248200256', '1400001834', 'A1400001834', '2218200456', 'A2218200456', '3501288012', 'A3501288012', '4008090000', 'A4008090000', '400809000001', 'A400809000001', '400809000007', 'A400809000007', '40080900000764', 'A40080900000764', '400809000009', 'A400809000009', '4638250094', 'A4638250094', '72601012130', 'A72601012130', '72601012190', 'A72601012190', '72601012803', 'A72601012803', '910139000001', 'A910139000001', '910139000002', 'A910139000002', 'A000000000853', 'AA000000000853', 'A000000002723', 'AA000000002723', 'A0002481V002L044', 'AA0002481V002L044', 'A0025440094', 'AA0025440094', 'A072601012130', 'AA072601012130', 'A072601012190', 'AA072601012190', 'A072601012703', 'AA072601012703', 'A072601024131', 'AA072601024131', 'A072601024701', 'AA072601024701', 'A072601024702', 'AA072601024702', 'A400809000007', 'AA400809000007', 'AN000000002723', 'AAN000000002723', 'AN000000004248', 'AAN000000004248', 'AN072601012130', 'AAN072601012130', 'AN072601012190', 'AAN072601012190', 'AN072601012250', 'AAN072601012250', 'AN400809000001', 'AAN400809000001', 'AN400809000007', 'AAN400809000007', 'AN910139000002', 'AAN910139000002', 'N000000000069', 'AN000000000069', 'N000000000853', 'AN000000000853', 'N000000001604', 'AN000000001604', 'N000000002723', 'AN000000002723', 'N000000004248', 'AN000000004248', 'N000000006373', 'AN000000006373', 'N000000007419', 'AN000000007419', 'N072601012130', 'AN072601012130', 'N072601012190', 'AN072601012190', 'N072601012250', 'AN072601012250', 'N400809000001', 'AN400809000001', 'N400809000007', 'AN400809000007', 'N72601012250', 'AN72601012250', 'N910139000002', 'AN910139000002') AND o.manufacturerId=74) OR ( o.oemSearch IN ('0002481V002L044', '0025440094', '400809000007', '7919518929', 'A0002481V002L044', 'A0025440094', 'A400809000007') AND o.manufacturerId=3645) OR ( o.oemSearch IN ('07119905013', '07119905345', '07119978340', '07119978370', '07119978373', '07509063574', '07509063578', '3436336', '63128361289', '63128370309', '63136902877', '63210151621', '63210151622', '63210152962', '63210395453', '63210395459', '63210398942', '63216926910', '63216926920', '63216926926', '63216926927', '63216926929', '63217160780', '63217160781', '63217160790', '63217160796', '63217160797', '63217160805', '63217160806', '6926910', '71199978373', '7160780', '7160805', '7509063574') AND o.manufacturerId=1523))