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 ('55702161', '55703721', '55703917', '60602694', '6854093', '6854104') AND o.manufacturerId=255) OR ( o.oemSearch IN ('0000071724084', '50541345', '51803075', '51893889', '55702161', '55703721', '55703917', '5D33751', '5D337510', '5D3375100', '5D3375400', '5D3775100', '5E52754', '5E527540', '60602694', '60815796', '60816191', '6854094', '6854104', '71721731', '71721732', '71721745', '71721746', '71721763', '71781765') AND o.manufacturerId=2) OR ( o.oemSearch IN ('1K0820803E', '1K0820803F', '1K0820803G', '1K0820803H', '1K0820803J', '1K0820803L', '1K0820803N', '1K0820803NX', '1K0820803P', '1K0820803Q', '1K0820803QX', '1K0820803S', '1K0820803SX', '1K0820808B', '1K0820808BX', '1K0820808D', '1K0820808DX', '1K0820808F', '1K0820808FX', '1K0820859', '1K0820859C', '1K0820859D', '1K0820859E', '1K0820859F', '1K0820859M', '1K0820859Q', '1K0820859QX', '1K0820859S', '1K0820859SX', '2E0820803A', '2E0820803B', '2E0820803C', '2E0820803D', '2E0820803G', '3BD260805A', '4471706290', '4471706340', '4471706350', '4471706351', '4471904310', '4471905670', '4472208180', '4472208181', '4472208182', '4472208183', '4472208184', '4B0260805', '4B02608055', '4B0260805B', '4B0260805BX', '4B0260805C', '4B0260805N', '4B0260805P', '4B0260805PX', '4B0260805Q', '4B0260805R', '4B0260808', '4B02608088', '4B0260811A', '4B3230805', '4B3260205', '4B3260805', '4B32608055', '4B3260808', '4B32608088', '4D0260805B', '4D0260805C', '4D0260805D', '4D0260808', '4D02608088', '4D0260808A', '4D0260811A', '4F0260805AL', '4F0260805AN', '4F0260805AP', '4Z0260805', '4Z7260805', '5060310751', '5060310781', '5K0820803B', '8D0260805', '8D0260805B', '8D0260805C', '8D0260805D', '8D0260805DX', '8D0260805F', '8D0260805J', '8D0260805K', '8D0260805KX', '8D0260805M', '8D0260805MX', '8D0260805P', '8D0260805Q', '8D0260805R', '8D0260805RX', '8D0260808', '8D0260811A', '8DO260805B', '8DO260805J', '8DO260808', '8E0260805F', '8E0260805S', '8K0260805E', '8K0260805L', '8KD260805', '9612601152', '99612601151', '99612601152', 'UNDEFINED', 'W01K0820859F') AND o.manufacturerId=5) OR ( o.oemSearch IN ('4B0260805B', '4B0260805BX', '4B0260805Q', '4B3260805', '4B3260808', '4D0260805B', '4D0260805D', '4D0260808', '8D0260805B', '8D0260805J', '8D0260805P', '8D0260805Q', '8D0260805R', '8D0260805RX', '8D0260808') AND o.manufacturerId=2858) OR ( o.oemSearch IN ('64509180547', '64526904014', '64526904015', '64526904017', '64526904018', '64526909628', '64526910458', '64526910459', '64526910460', '64526911340', '64526911341', '64526911342', '64526914369', '64526914370', '64526914371', '64526915388', '64526916232', '64526917866', '64526918000', '64526918749', '64526921651', '64526936883', '64526946871', '64526956493', '64528362414', '64528363275', '64528363485', '64528377241', '64528377242', '64528377244', '64528377744', '64528379924', '64528381233', '64528385050', '64528385919', '64528385920', '64528385921', '64528385922', '64528386451', '6904014', '6904015', '6904017', '6904018', '6910458', '6910459', '6910460', '6911340', '6911341', '6911342', '6914369', '6914370', '6914371', '6915388', '6916232', '6917866', '6918000', '6918749', '6936883', '6946871', '6956493', '8362414', '8363275', '8363485', '8377241', '8377242', '8377744', '8379924', '8385050', '8385919', '8385920', '8385921', '8385922', '8386451', '8390741', '8391695', '9180547') AND o.manufacturerId=16) OR ( o.oemSearch IN ('0022300811', '4677038', '4677143P', '5080378AA', '55036151G', '55116515AB', 'A0022300811') AND o.manufacturerId=20) OR ( o.oemSearch IN ('55702161', '55703721', '55703917', '6854093', '6854104', '93190815') AND o.manufacturerId=21) OR ( o.oemSearch IN ('1607883080', '648760') AND o.manufacturerId=804) OR ( o.oemSearch IN ('07969992', '7969990', '7969991', '7969992', '9062300311', '9062302011', 'A9032302011', 'A9062300311', 'A9062302011') AND o.manufacturerId=750) OR ( o.oemSearch IN ('4B0260805B', '4B0260805BX', '4B0260805C', '4B0260805N', '4B0260805P', '4B0260805PX', '4B0260805Q', '4B0260805R', '4B3260805', '4B3260808', '4D0260805B', '4D0260805C', '4D0260805D', '4D0260808', '4D0260808A', '8D0260805', '8D0260805B', '8D0260805D', '8D0260805DX', '8D0260805F', '8D0260805J', '8D0260805M', '8D0260805MX', '8D0260805P', '8D0260805Q', '8D0260805R', '8D0260805RX', '8D0260808') AND o.manufacturerId=4896) OR ( o.oemSearch IN ('55036151G') AND o.manufacturerId=29) OR ( o.oemSearch IN ('G311550', 'G311550020100') AND o.manufacturerId=752) OR ( o.oemSearch IN ('0000071721746', '4471902141', '4471905550', '46336396', '46438366', '46536396', '46775094', '50292004', '50503374', '5060310751', '5060310781', '51794515', '51803075', '54407090', '55194880', '55701200', '55702161', '55702661', '55703721', '55703917', '5D33751', '5D337510', '60602694', '60812516', '60814101', '60815796', '60816181', '60816191', '6854093', '6854104', '71721731', '71721732', '71721745', '71721746', '71781763', '71781764', '71781765', '71781766', '71789105', '71789106', '71789107', '71789111', '71789112', '71789113', '71789348', '71789349', '71789350', '8D0260805M', '93190815') AND o.manufacturerId=35) OR ( o.oemSearch IN ('21000003') AND o.manufacturerId=2850) OR ( o.oemSearch IN ('1201714', '55702161', '55703721', '55703917', '6854093', '6854104', '93190815') AND o.manufacturerId=36) OR ( o.oemSearch IN ('09241681', '13263478', '1854048', '1854084', '1854104', '1854137', '1854149', '1854412', '2443138', '24443138', '39079899', '55352021', '55565236', '55701200', '55702661', '55703721', '5E527520', '5E527540', '6854002', '6854040', '6854091', '6854092', '6854102', '6854103', '90457635', '90564976', '9196940', '9196949', '9241681', '93190812', '93190814', '93190815', '9319O812', '95516234') AND o.manufacturerId=753) OR ( o.oemSearch IN ('55702161', '55703721', '55703917', '5E527540', '6854093', '6854104', '93190815') AND o.manufacturerId=39) OR ( o.oemSearch IN ('38810PW0N01') AND o.manufacturerId=45) OR ( o.oemSearch IN ('8973557690') AND o.manufacturerId=54) OR ( o.oemSearch IN ('55036151G', '56006551') AND o.manufacturerId=882) OR ( o.oemSearch IN ('46536396', '5060310751', '5060310781', '60602694', '71721745', '8D0260805M') AND o.manufacturerId=64) OR ( o.oemSearch IN ('3H5Z19D629BA', 'AH2219D629AA', 'ERR4375', 'JPB101154L', 'LR013841') AND o.manufacturerId=1820) OR ( o.oemSearch IN ('0000234211', 'A0000234211', '00012302811', 'A00012302811', '0002300811', 'A0002300811', '0002300911', 'A0002300911', '0002301611', 'A0002301611', '0002302011', 'A0002302011', '0002302111', 'A0002302111', '0002303911', 'A0002303911', '0002304011', 'A0002304011', '0002305911', 'A0002305911', '0002306811', 'A0002306811', '0002307011', 'A0002307011', '0002307911', 'A0002307911', '000230791180', 'A000230791180', '0002309411', 'A0002309411', '0002340911', 'A0002340911', '0002342011', 'A0002342011', '0002342311', 'A0002342311', '0002342411', 'A0002342411', '0002342911', 'A0002342911', '0002343111', 'A0002343111', '0002346303', 'A0002346303', '0002347011', 'A0002347011', '00112308211', 'A00112308211', '0012307111', 'A0012307111', '05097010AA', 'A05097010AA', '0541230011', 'A0541230011', '07969992', 'A07969992', '1191300015', 'A1191300015', '1192300011', 'A1192300011', '2300911', 'A2300911', '2301100070A', 'A2301100070A', '2302011', 'A2302011', '2303911', 'A2303911', '2306811', 'A2306811', '2307011', 'A2307011', '2340911', 'A2340911', '2342011', 'A2342011', '2342411', 'A2342411', '2342911', 'A2342911', '2343111', 'A2343111', '5412300211', 'A5412300211', '5412300411', 'A5412300411', '5412300611', 'A5412300611', '5412300711', 'A5412300711', '5412301211', 'A5412301211', '5412301311', 'A5412301311', '5412301411', 'A5412301411', '5412301511', 'A5412301511', '7969990', 'A7969990', '7969991', 'A7969991', '7969992', 'A7969992', 'A0002300811', 'AA0002300811', 'A0002300911', 'AA0002300911', 'A0002301611', 'AA0002301611', 'A0002302011', 'AA0002302011', 'A000230201180', 'AA000230201180', 'A0002303911', 'AA0002303911', 'A0002306811', 'AA0002306811', 'A0002307011', 'AA0002307011', 'A000230701180', 'AA000230701180', 'A000230701187', 'AA000230701187', 'A0002307811', 'AA0002307811', 'A0002308011', 'AA0002308011', 'A0002340911', 'AA0002340911', 'A0002342011', 'AA0002342011', 'A0002342311', 'AA0002342311', 'A0002342411', 'AA0002342411', 'A0002342911', 'AA0002342911', 'A0002343111', 'AA0002343111', 'A0002346303', 'AA0002346303', 'A0002346306', 'AA0002346306', 'A0002347011', 'AA0002347011', 'A1191300015', 'AA1191300015', 'A1192300011', 'AA1192300011', 'A2301100070', 'AA2301100070', 'A5412300211', 'AA5412300211', 'A5412300411', 'AA5412300411', 'A5412300611', 'AA5412300611', 'A5412300711', 'AA5412300711', 'A5412301211', 'AA5412301211', 'A5412301311', 'AA5412301311', 'A5412301411', 'AA5412301411', 'A5412301511', 'AA5412301511') AND o.manufacturerId=74) OR ( o.oemSearch IN ('JPB101144', 'JPB101161', 'JPB101430A', 'JPB101450A', 'JPB101460', 'JPB101460A', 'JPB500120') AND o.manufacturerId=75) OR ( o.oemSearch IN ('4B0260805B', '4B0260808', '4B3260805', '4B3260808', '4D0260805B', '4D0260805D', '4D0260808', '5060310751', '89027', '89029', '89045', '89054') AND o.manufacturerId=80) OR ( o.oemSearch IN ('1111', '4471007920', '4471009270', '4471009440', '4471706290', '4471706297', '4471706340', '4471706350', '4471707420', '4472208140', '4472208350', '4472208390', '4472209590', '4B0260805', '4B0260805B', '4B0260805C', '4B0260805N', '4B0260805P', '4B0260805Q', '4B3230805', '4B3260805', '4D0260805B', '4D0260805C', '4D0260805D', '4D0260808', '4D0260808A', '5060310751', '5060310781', '5062310500', '5275200', '55701200', '55702161', '55703721', '55703917', '60602694', '6854091', '6854093', '6854102', '6854104', '8D0260805', '8D0260805B', '8D0260805D', '8D0260805F', '8D0260805J', '8D0260805K', '8D0260805M', '8D0260805P', '8D0260805Q', '8D0260805R', '8D0260808', '8E0260805F', '8E0260805S', '93012602104', '93190812', '93190815', '996126011051', '99612601152') AND o.manufacturerId=83) OR ( o.oemSearch IN ('055701200', '055702661', '06854091', '06854092', '06854102', '06854103', '09122119', '09192581', '09196949', '09241681', '093190812', '093198014', '1201131', '1201134', '13263478', '1340267', '13447213', '1854048', '1854066', '1854084', '1854096', '1854097', '1854104', '1854120', '1854121', '1854128', '1854137', '1854148', '1854149', '1854412', '1854413', '24416177', '24416178', '24428118', '24430230', '24430319', '24443138', '2483001840', '39006349', '39006352', '39006353', '39079895', '39079898', '39079899', '4471905040', '447260036', '4709128', '5275200', '55352021', '55565236', '55701200', '55702161', '55702661', '55703721', '55703917', '5570661', '557O12OO', '5E527520', '5E52754', '6340553', '6854000', '6854001', '6854002', '6854028', '6854029', '6854040', '6854091', '6854092', '685409255702661', '6854093', '6854094', '6854102', '6854103', '6854104', '68541O2', '6854O91', '90457635', '90507617', '90564976', '9122119', '9122120', '9192581', '9196949', '9241681', '93176859', '93176860', '93176871', '93190812', '93190814', '93190815', '93193972', '93198014', '9319O812', '9518237', '95516234', '95516235', 'R1580013') AND o.manufacturerId=84) OR ( o.oemSearch IN ('55702161', '55703721', '55703917', '6854093', '6854104', '93190815') AND o.manufacturerId=88) OR ( o.oemSearch IN ('055702661', '06854092', '06854103', '09241681', '093198014', '1854084', '1854137', '1854149', '24443138', '4471706340', '4471904310', '4B02608055', '4B0260805B', '4B0260805BX', '4B0260805Q', '4B0260808', '4B02608088', '4B3260205', '4B3260805', '4B32608055', '4B3260808', '4B32608088', '4D0260805B', '4D0260805D', '4D0260808', '4D02608088', '55702661', '6854002', '6854040', '6854092', '90564976', '9196949', '9241681', '93012602104', '93176871', '93190814', '93198014', '996126011051', '99612601151', '99612601152', '996126011BX', '99657392600') AND o.manufacturerId=92) OR ( o.oemSearch IN ('7701474008') AND o.manufacturerId=93) OR ( o.oemSearch IN ('926003370R') AND o.manufacturerId=694) OR ( o.oemSearch IN ('JPB000040', 'JPB000040A', 'JPB101154', 'JPB101430', 'JPB101450', 'JPB101540', 'JPB500110', 'JPB500130') AND o.manufacturerId=95) OR ( o.oemSearch IN ('12758380', '4541207', '4869483', '5046891', '5048095', '5048368') AND o.manufacturerId=99) OR ( o.oemSearch IN ('1K0820803E', '1K0820803F', '1K0820803G', '1K0820803H', '1K0820803J', '1K0820803L', '1K0820803N', '1K0820803NX', '1K0820803P', '1K0820803Q', '1K0820803QX', '1K0820803S', '1K0820803SX', '1K0820808B', '1K0820808BX', '1K0820808D', '1K0820808DX', '1K0820808F', '1K0820808FX', '1K0820859', '1K0820859C', '1K0820859D', '1K0820859E', '1K0820859F', '1K0820859M', '1K0820859Q', '1K0820859QX', '1K0820859S', '1K0820859SX', '2E0820803A', '2E0820803B', '2E0820803C', '2E0820803D', '2E0820803G', '4B0260805', '4B0260805B', '4B0260805BX', '4B0260805C', '4B0260805N', '4B0260805P', '4B0260805PX', '4B0260805Q', '4B0260808', '4B3260805', '4B3260808', '4D0260805B', '4D0260805C', '4D0260805D', '4D0260808', '4Z7260805', '5K0820803B', '8D0260805', '8D0260805B', '8D0260805C', '8D0260805D', '8D0260805F', '8D0260805J', '8D0260805K', '8D0260805M', '8D0260805MX', '8D0260805P', '8D0260805Q', '8D0260805R', '8D0260805RX', '8D0260808', 'W01K0820859F') AND o.manufacturerId=104) OR ( o.oemSearch IN ('SB035D', 'SB063D') AND o.manufacturerId=0) OR ( o.oemSearch IN ('1K0820803E', '1K0820803F', '1K0820803G', '1K0820803H', '1K0820803J', '1K0820803L', '1K0820803N', '1K0820803NX', '1K0820803P', '1K0820803Q', '1K0820803QX', '1K0820803S', '1K0820803SX', '1K0820808B', '1K0820808BX', '1K0820808D', '1K0820808DX', '1K0820808F', '1K0820808FX', '1K0820859', '1K0820859C', '1K0820859D', '1K0820859E', '1K0820859F', '1K0820859M', '1K0820859Q', '1K0820859QX', '1K0820859S', '1K0820859SX', '2E0820803A', '2E0820803B', '2E0820803C', '2E0820803D', '2E0820803G', '3BD260805A', '4B0260805', '4B02608055', '4B0260805B', '4B0260805BX', '4B0260805C', '4B0260805N', '4B0260805P', '4B0260805PX', '4B0260805Q', '4B0260805R', '4B0260808', '4B02608088', '4B0260811A', '4B3260805', '4B32608055', '4B3260808', '4B32608088', '4D0260805B', '4D0260805C', '4D0260805D', '4D0260808', '4D02608088', '4D0260808A', '4D0260811A', '4Z7260805', '5K0820803B', '8D0260805', '8D0260805B', '8D0260805C', '8D0260805D', '8D0260805F', '8D0260805J', '8D0260805K', '8D0260805M', '8D0260805MX', '8D0260805P', '8D0260805Q', '8D0260805R', '8D0260805RX', '8D0260808', '8DO260805B', '8DO260805J', '8DO260808', '99612601151', '99612601152', 'W01K0820859F') AND o.manufacturerId=106) OR ( o.oemSearch IN ('55702161', '55703917') AND o.manufacturerId=109) OR ( o.oemSearch IN ('8831002460', '883100F010') AND o.manufacturerId=111) OR ( o.oemSearch IN ('1K0820803E', '1K0820803F', '1K0820803G', '1K0820803H', '1K0820803J', '1K0820803L', '1K0820803N', '1K0820803NX', '1K0820803P', '1K0820803Q', '1K0820803QX', '1K0820803S', '1K0820803SX', '1K0820808B', '1K0820808BX', '1K0820808D', '1K0820808DX', '1K0820808F', '1K0820808FX', '1K0820859', '1K0820859C', '1K0820859D', '1K0820859E', '1K0820859F', '1K0820859M', '1K0820859Q', '1K0820859QX', '1K0820859S', '1K0820859SX', '2E0820803A', '2E0820803B', '2E0820803C', '2E0820803D', '2E0820803G', '3BD260805A', '4471904310', '4472208180', '4472208181', '4472208182', '4472208183', '4472208184', '4B00260805C', '4B0206805C', '4B0206805K', '4B0206805N', '4B0260805', '4B02608055', '4B0260805A', '4B0260805B', '4B0260805BV', '4B0260805BX', '4B0260805C', '4B0260805D', '4B0260805N', '4B0260805P', '4B0260805PX', '4B0260805Q', '4B0260805R', '4B0260808', '4B02608088', '4B0260811A', '4B0269805B', '4B3260805', '4B32608055', '4B3260808', '4B32608088', '4D0260805', '4D0260805A', '4D0260805B', '4D0260805C', '4D0260805D', '4D0260805F', '4D0260805G', '4D0260808', '4D02608088', '4D0260808A', '4D0260811A', '4Z0260805', '4Z7260805', '5060310751', '5060310781', '5K0820803B', '5X00820803B', '5X0820803B', '7L6820805C', '8B0820803C', '8D00260805B', '8D00260805D', '8D00260805J', '8D00260808', '8D0260805', '8D0260805B', '8D0260805BX', '8D0260805C', '8D0260805D', '8D0260805DX', '8D0260805F', '8D0260805J', '8D0260805JX', '8D0260805K', '8D0260805KX', '8D0260805M', '8D0260805MX', '8D0260805P', '8D0260805PX', '8D0260805Q', '8D0260805QX', '8D0260805R', '8D0260805RV', '8D0260805RX', '8D0260808', '8D0260808X', '8D0260811A', '8DO260805B', '8DO260805J', '8DO260808', '8EO260805BT', '8Q0260805A', '99612601151', '99612601152', '996126011BX', 'W01K0820859F') AND o.manufacturerId=253) OR ( o.oemSearch IN ('09241681', '1135322', '1854084', '1854137') AND o.manufacturerId=117))