SELECT DISTINCT 
    m.manufacturerName AS cross_brand, 
    ao.oemSearch, 
    ao.oemnumber, 
    ps_sub.id AS id
FROM (
    
    VALUES 
        ('71722,4576), ('13046028822,3), ('13046072362,3), ('13046072862,3), ('0986494107,30), ('0986494108,30), ('0986494553,30), ('P85082,65), ('P85083,65), ('P85141,65), ('BSG90200018,4455), ('BSG90200019,4455), ('BSG90200034,4455), ('CBP11313,421), ('LP1911,89), ('LP1913,89), ('LP2199,89), ('LP3651,89), ('LP3652,89), ('DP21534,6368), ('DP21556,6368), ('DP22096,6368), ('DP41534R,6368), ('5502224761,4770), ('5502224764,4770), ('1623061680,4391), ('1639375480,4391), ('1639375680,4391), ('2301T5F,4674), ('2301T5R,4674), ('2301T6F,4674), ('16462,101), ('16588,101), ('16824,101), ('BP43115,271), ('BP43116,271), ('FVR1642,62), ('FVR1644,62), ('FVR4302,62), ('FO251181,4887), ('FO871081,4887), ('FO936681,4887), ('8DB355011441,4734), ('8DB355011531,4734), ('8DB355030831,4734), ('SP4203,6265), ('HP8542,4998), ('141953,158), ('181674203,158), ('181779,158), ('PA0953AF,156), ('PP0922AF,156), ('MBF015041,4570), ('MBF015207,4570), ('MBF015228,4570), ('2205523,121), ('2205542,121), ('2208310,121), ('0252369317,144), ('0252374619PD,144), ('0252374619W,144), ('0252462318PD,144), ('0252462318W,144), ('PN0330W,4682), ('PN0353W,4682), ('PN33001W,4682), ('2247102,127), ('224761,127), ('224764,127), ('PBP037,4558), ('PBP100,4558), ('PBP1644,4558), ('089711,153), ('104511,153), ('144001,153), ('6216088,260), ('2332602,39), ('2374601,39), ('2462301,39), ('2626801,39), ('2627001,39), ('0735239,209), ('0735248,209), ('0735267,209), ('GDB1555,4501), ('GDB1557,4501), ('GDB1887,4501), ('302041,21), ('66981046101,4346), ('66981103201,4346), ('66981694401,4346), ('P1145311,366), ('P997311,366), ('BS1179,4894), ('BS2797,4894), ('233261751,86), ('233261752,86), ('237461851,86), ('238821751,86), ('246231802,86), ('C1W044ABE,4426), ('C1W045ABE,4426), ('C1W064ABE,4426), ('C2A004ABE,4426), ('C2W021ABE,4426), ('C2W023ABE,4426), ('C4W013ABE,4426), ('CRB006ABE,4426), ('17525,206), ('37366,206), ('37368,206), ('37413,206), ('37415,206), ('37416,206), ('37478,206), ('37482,206), ('37767,206), ('9109,206), ('9177,206), ('VBSU089,4400), ('BPVW1004,4951), ('BPVW1032,4951), ('BPVW1051,4951), ('BPVW1056,4951), ('BPVW2002,4951), ('BPVW2003,4951), ('BPVW2010,4951), ('AN4367K,4024), ('AN4367KE,4024), ('AN4438K,4024), ('AN4438KE,4024), ('AN4555K,4024), ('AN4556K,4024), ('AN4614WK,4024), ('AN4614WKE,4024), ('AN4702WK,4024), ('AN4702WKE,4024), ('AN4711WK,4024), ('AN4711WKE,4024), ('AN7048K,4024), ('AN8054K,4024), ('AN8150WK,4024), ('1050110,317), ('1050204,317), ('1050249,317), ('1050788,317), ('1051083,317), ('1110553,317), ('1390016,317), ('24934,283), ('24934V,283), ('BKT2078,4537), ('BSH1037,4537), ('DSK2282,4537), ('KIT999,4537), ('PAD1298,4537), ('PAD1324,4537), ('PAD1336,4537), ('PAD1337,4537), ('PAD1352,4537), ('PAD1367,4537), ('PAD1466,4537), ('PAD1529,4537), ('PAD1782,4537), ('PD3077,4537), ('PD3120,4537), ('PD3135,4537), ('PD3166,4537), ('PD3312,4537), ('PD3707,4537), ('SDK6022,4537), ('SHU666,4537), ('X40900,4975), ('X40901,4975), ('X40903,4975), ('X40904,4975), ('X40907,4975), ('X40941,4975), ('X50394,4975), ('X50491,4975), ('32928,4576), ('71314,4576), ('71727,4576), ('71730,4576), ('71777,4576), ('74251,4576), ('74256,4576), ('74979,4576), ('50000953,257), ('50000954,257), ('5008800,257), ('510000007,257), ('51000907,257), ('51000922,257), ('61000925,257), ('61000925C,257), ('K01240,442), ('P11006,442), ('P11045,442), ('P11048,442), ('P11055,442), ('P11237,442), ('P11577,442), ('P331004,442), ('KD1505,4854), ('KD3766,4854), ('KD7011,4854), ('KD7011F,4854), ('KD7396,4854), ('KD7581,4854), ('AKD0330,4631), ('AKD0349,4631), ('AKD0353,4631), ('AKD23202,4631), ('03013704192,3), ('03013792882,3), ('13046028882,3), ('13046028892,3), ('13046057002,3), ('13046071912,3), ('13046072402,3), ('13047028882,3), ('13047071912,3), ('D3956A,351), ('D42478A,351), ('D42548A,351), ('D42872A,351), ('120017810,323), ('120043510,323), ('120043610,323), ('120045710,323), ('PBP0112,4337), ('PBP0158,4337), ('PBP1247,4337), ('PBP8504,4337), ('290BK08420,6271), ('290BK08536,6271), ('290BK08758,6271), ('290BK09402,6271), ('290BK09418,6271), ('BA2242,394), ('BA2243,394), ('BA2301,394), ('510478,49), ('510479,49), ('510503,49), ('510611,49), ('510619,49), ('510669,49), ('511133,49), ('521981,49), ('610305,49), ('DB1947HD,49), ('ADBP410042,350), ('ADK84236,350), ('ADN148601,350), ('ADV1842100,350), ('ADV184228,350), ('ADV184236,350), ('ADV184239,350), ('ADV184257,350), ('ADV184381,350), ('BBK1301,475), ('BBK6177,475), ('BBP1877,475), ('BBP1930,475), ('BBP1939,475), ('BBP2005,475), ('BBP2107,475), ('BBP2108,475), ('BBP2139,475), ('BBP2143,475), ('BBP2144,475), ('BBP2166,475), ('BBP2169,475), ('BBP2275,475), ('BBS6332,475), ('BBS6373,475), ('0986424056,30), ('0986479097,30), ('0986479S06,30), ('0986494053,30), ('0986494119,30), ('0986494160,30), ('0986494203,30), ('0986494303,30), ('0986494573,30), ('0986495094,30), ('0986495453,30), ('0986495485,30), ('1987475306,30), ('AA0145,4993), ('AB0034,4993), ('AB0099,4993), ('AB0148,4993), ('AB0159,4993), ('AB0195,4993), ('233260070200,281), ('233260070210,281), ('237460070310,281), ('237461070310,281), ('239140070400,281), ('246230070300,281), ('BR361VA100,281), ('BS8553,289), ('BV8553,289), ('07B31500,65), ('07B31585,65), ('09958210,65), ('09958211,65), ('A02359,65), ('A02379,65), ('P59050,65), ('P59050N,65), ('P85064,65), ('P85064N,65), ('P85073,65), ('P85073N,65), ('P85073X,65), ('P85076,65), ('P85076N,65), ('P85081,65), ('P85081N,65), ('P85082N,65), ('P85083N,65), ('P85106,65), ('P85107,65), ('P85141N,65), ('P85143,65), ('P85143N,65), ('RD165000,65), ('S06511,65), ('S85536,65), ('BP3086,4872), ('BP3087,4872), ('BP3098,4872), ('BP3099,4872), ('BP3130,4872), ('BP3134,4872), ('BP3140,4872), ('BP3248,4872), ('BP3478,4872), ('BP3508,4872), ('CD7286V,4872), ('GF0081,4872), ('GF0314,4872), ('BSG90200025,4455), ('BSG90202007,4455), ('BSG90202008,4455), ('BSG90202014,4455), ('BSG90210006,4455), ('1421028,243), ('HPD1028,243), ('BKM326,4604), ('BKM623,4604), ('BKM746,4604), ('BKM914,4604), ('562262CH,43), ('573158CH,43), ('573159CH,43), ('573160CH,43), ('573219CH,43), ('573220CH,43), ('573255CH,43), ('573330CH,43), ('573391CH,43), ('153019,311), ('153244,311), ('800728,311), ('8225520,311), ('8225521,311), ('8225523,311), ('8225530,311), ('8225540,311), ('8225542,311), ('8228310,311), ('ADB01284,421), ('ADB01313,421), ('ADB11311,421), ('ADB11312,421), ('ADB11313,421), ('ADB11754,421), ('ADB16002,421), ('ADB32008,421), ('AND6069,421), ('CBP01284,421), ('CBP01313,421), ('CBP11311,421), ('CBP11312,421), ('CBP11754,421), ('CBP16002,421), ('CBP32008,421), ('508480,6263), ('320210,6479), ('324205,6479), ('324761,6479), ('324762,6479), ('324764,6479), ('324775,6479), ('325217,6479), ('604797,6479), ('DBP1911,4587), ('DBP1913,4587), ('DBP1914,4587), ('DBP1920,4587), ('DBP2199,4587), ('DBS10291,4587), ('DBS10336,4587), ('BG3893,89), ('LP1824,89), ('LP1860,89), ('LP1865,89), ('LP1914,89), ('LP1920,89), ('LP2224,89), ('LS1920,89), ('B110853,186), ('B110854,186), ('B110920,186), ('B111060,186), ('B111113,186), ('B111317,186), ('B120098,186), ('B120165,186), ('B160098,186), ('N01348,4396), ('N01351,4396), ('N09059,4396), ('N09095,4396), ('N09127,4396), ('N09236,4396), ('N09436,4396), ('N09480,4396), ('N09485,4396), ('N09489,4396), ('DFB3612,471), ('DFB3613,471), ('1070110049,4345), ('PCP1004,278), ('PCP1238,278), ('PCP1239,278), ('PCP1631,278), ('PCP1638,278), ('PCP1684,278), ('PCP1685,278), ('PCP1687,278), ('PCP1705,278), ('DP1010100054,4948), ('DP1010100062,4948), ('DP1010100777,4948), ('DP1010100890,4948), ('DP1010100891,4948), ('DP1010100918,4948), ('DP1010101098,4948), ('DP1010101129,4948), ('DP1010101154,4948), ('DP1010110374,4948), ('DBP364069,266), ('DBP391636,266), ('DBP391642,266), ('DBP391644,266), ('DBP1642,4881), ('DBP1643,4881), ('DBP1644,4881), ('DBP1655,4881), ('DBP1826,4881), ('DBP4069,4881), ('DBP4302,4881), ('DBS668,4881), ('DP1470,6368), ('DP1534,6368), ('DP1556,6368), ('DP21470,6368), ('DP31470C,6368), ('DP41470R,6368), ('DP41556R,6368), ('DP42096R,6368), ('DP51470NDX,6368), ('DP91470,6368), ('DPX2096,6368), ('RAD1066C,457), ('RAP1016,457), ('RAP1033,457), ('RAP1049,457), ('RAP1154,457), ('RAP1251,457), ('RAP1361,457), ('RAP2019,457), ('310073,4512), ('420055,4512), ('420077,4512), ('420209,4512), ('090606,309), ('121086,309), ('121087,309), ('121134,309), ('121140,309), ('121248,309), ('121478,309), ('121508,309), ('55022247102,4770), ('5502224762,4770), ('5502224786,4770), ('5502225217,4770), ('5815204797,4770), ('5815314797,4770), ('58492715695,4770), ('1617259180,4391), ('1617272780,4391), ('1639373880,4391), ('1639374080,4391), ('1639377180,4391), ('1642776980,4391), ('FD15002,6543), ('FD15007,6543), ('FD15007M,6543), ('FD15007MA,6543), ('FD26028M,6543), ('FD26038M,6543), ('FD26038MA,6543), ('FD26301M,6543), ('FD9819M,6543), ('FD9819MA,6543), ('FK14001,6543), ('0201E11F,4674), ('1701GVIR,4674), ('2401CLIF,4674), ('116199,101), ('16465,101), ('16649,101), ('16860,101), ('23851,101), ('28682,101), ('28730,101), ('29225,101), ('BP43457,271), ('BP53038,271), ('DDF1286,62), ('DDF1286C,62), ('FDB1636,62), ('FDB1655,62), ('FDB1826,62), ('FDB4069,62), ('FSB4000,62), ('FSB668,62), ('FVR1643,62), ('FBD509,4838), ('FBP1391,4838), ('FBP2099,4838), ('FBP4018,4838), ('FBP4102,4838), ('FBP4281,4838), ('FBS8045,4838), ('FP1018E,4937), ('FP1174E,4937), ('FP1491,4937), ('FP33278E,4937), ('FT2070,4937), ('FO815281,4887), ('FO839181,4887), ('FO9090,4887), ('FO918981,4887), ('PD1386,404), ('BD3021,409), ('FBP1366,409), ('FBP136601,409), ('FBP1368,409), ('FBP136801,409), ('FBP1371,409), ('FBP1416,409), ('FBP1633,409), ('FBP1672,409), ('901709,380), ('950841,380), ('845600201,6484), ('845600701,6484), ('1019029,295), ('1052131,295), ('5680,295), ('5681,295), ('5683,295), ('5690,295), ('5700,295), ('5702,295), ('8480,295), ('BD0977,295), ('BB1334A6,54), ('BL1870A1,54), ('BL1871A2,54), ('BL1872A3,54), ('BL1872A4,54), ('BL1872B4,54), ('BL1896A4,54), ('BL1896B4,54), ('BL2073A2,54), ('BS5473,54), ('BS5473B,54), ('B1G10206912,500), ('B1G10207042,500), ('B1G10207062,500), ('B1G10207072,500), ('B1G10207582,500), ('B1G10207592,500), ('B1G12010592,500), ('B1G12012962,500), ('5184782,279), ('5187189,279), ('6043122,279), ('6115161,279), ('6115552,279), ('6115562,279), ('6115571,279), ('6116221,279), ('6116611,279), ('6117691,279), ('6118872,279), ('6133961,279), ('GBP089711,6529), ('GBP103100,6529), ('GBP104511,6529), ('GBS474000,6529), ('8DA355050471,4734), ('8DB355010601,4734), ('8DB355010971,4734), ('8DB355011171,4734), ('8DB355011641,4734), ('8DB355012301,4734), ('8DB355013811,4734), ('8DB355013821,4734), ('8DB355014981,4734), ('8DB355015951,4734), ('8DB355029071,4734), ('8DB355030841,4734), ('8DB355030861,4734), ('8DB355030871,4734), ('8DD355109701,4734), ('8DZ355201871,4734), ('8DZ355202691,4734), ('8DZ355203081,4734), ('J3608025,72), ('J3610805,72), ('SD5702,6265), ('SP1818,6265), ('SP1979,6265), ('SP2099,6265), ('SP2112R,6265), ('HP8543,4998), ('70416066P,6359), ('70416066X,6359), ('181600703,158), ('181674,158), ('181674204,158), ('181674208,158), ('181748,158), ('181778,158), ('DP0925,156), ('DP0925C,156), ('PA0954AF,156), ('PA800AF,156), ('PP0007AF,156), ('PP0907AF,156), ('500953,481), ('500954,481), ('50800,481), ('510007,481), ('510907,481), ('510922,481), ('610925,481), ('610925C,481), ('1163206600,268), ('1163604010,268), ('1163607910,268), ('1163609010,268), ('1163613010,268), ('1163705410,268), ('1163706210,268), ('1163706510,268), ('1163706610,268), ('1163707710,268), ('1163750110,268), ('1163950110,268), ('4763601010,268), ('JBS1038,4935), ('JCP058,4935), ('JCP1617,4935), ('JCP1642,4935), ('JCP1643,4935), ('JCP1644,4935), ('JCP8043,4935), ('362433J,49), ('362440J,49), ('562262J,49), ('562262JC,49), ('573158D,49), ('573158J,49), ('573158JC,49), ('573159J,49), ('573159JC,49), ('573160J,49), ('573160JC,49), ('573219J,49), ('573220J,49), ('573255J,49), ('573330J,49), ('573391J,49), ('FK1261,4461), ('FK20023,4461), ('FK20115,4461), ('FK20124,4461), ('FK20132,4461), ('FK20156,4461), ('FK20168,4461), ('2332617724,6207), ('2332617725,6207), ('2374618005,6207), ('2374620105,6207), ('2391417214,6207), ('2391417224,6207), ('2462318105,6207), ('JQ101160,185), ('JQ101205,185), ('JQ101213,185), ('JQ101308,185), ('JQ1013286,185), ('JQ1013288,185), ('JQ101434,185), ('JQ212027,185), ('JQ212029,185), ('BP8526,201), ('KBP8522,201), ('KSK6501,201), ('089700,286), ('089702,286), ('089711,286), ('09110,286), ('09150,286), ('098711,286), ('099400,286), ('103100,286), ('104501,286), ('104511,286), ('144001,286), ('810072,286), ('810082,286), ('810084,286), ('810086,286), ('KBP1877,4879), ('KBP1930,4879), ('KBP2139,4879), ('KBP2143,4879), ('KBP2166,4879), ('24048Z,387), ('24068Z,387), ('24147Z,387), ('24269Z,387), ('24409Z,387), ('24509Z,387), ('24547Z,387), ('24782Z,387), ('25729Z,387), ('6000194,4546), ('6000197,4546), ('6000592,4546), ('6010070,4546), ('6010090,4546), ('6010907,4546), ('6011155,4546), ('6022600,4546), ('05P1205,283), ('05P1206,283), ('05P1219,283), ('05P1219K,283), ('05P1229,283), ('05P1398,283), ('05P1526,283), ('05P1536,283), ('05P1551,283), ('09110,283), ('09150,283), ('BD1224,4600), ('BD7316,4600), ('BD8001,4600), ('BD8006,4600), ('BD8032,4600), ('BD8033,4600), ('BD8047,4600), ('BS8007,4600), ('BS8008,4600), ('360219198325,4723), ('360406009500,4723), ('361302040470,4723), ('363710201410,4723), ('363916060133,4723), ('363916060353,4723), ('363916060412,4723), ('363916060413,4723), ('363916060414,4723), ('363916060602,4723), ('363916060603,4723), ('363916060894,4723), ('MBC035335,4570), ('MBF015194,4570), ('MBF015195,4570), ('MBF015375,4570), ('MBF015839,4570), ('RMPU03NS,4570), ('RMPZ08,4570), ('25755,133), ('25755C,133), ('6023,133), ('6703,133), ('6772,133), ('67721,133), ('67721HPS,133), ('6772HPS,133), ('6793,133), ('6793HPS,133), ('6992,133), ('6992HPS,133), ('8867,133), ('8874,133), ('88741,133), ('9183,133), ('03013704192SETMS,358), ('13046028822NSETMS,358), ('13046028882NSETMS,358), ('13046028882SETMS,358), ('13046028892NSETMS,358), ('13046028892SETMS,358), ('13046057002NSETMS,358), ('13046071912NSETMS,358), ('13046071922NSETMS,358), ('13046072362NSETMS,358), ('13046072402NSETMS,358), ('13046072402SETMS,358), ('13046118872NSETMS,358), ('AB236028822,358), ('B236028822,358), ('HD236028822,358), ('K6028822,358), ('K6071912,358), ('W236028822,358), ('MS9902,6270), ('MSE0221,6270), ('MSE0226,6270), ('190475,403), ('190497,403), ('190838,403), ('190838MAX,403), ('190838SPORT,403), ('191790,403), ('191822,403), ('191897,403), ('191995,403), ('192962,403), ('192995,403), ('193323,403), ('193324,403), ('193605,403), ('193852,403), ('270545,403), ('270734,403), ('271465,403), ('8710740000,4899), ('8710740060,4899), ('8710740080,4899), ('8710746060,4899), ('8710746880,4899), ('8710746980,4899), ('MFP2800,4773), ('MRP2B03,4773), ('MRP2E15,4773), ('2205520,121), ('2205521,121), ('2205530,121), ('2205540,121), ('230728,121), ('530019,121), ('530244,121), ('0152004,94), ('1050841,94), ('1091610,94), ('1170051,94), ('1170068,94), ('1170190,94), ('1170422,94), ('1170484,94), ('1170763,94), ('1170900,94), ('KR960,94), ('MG960,94), ('0252332617,144), ('02523326171PD,144), ('0252332617PD,144), ('0252332617W,144), ('0252369217,144), ('0252374618PD,144), ('0252374618W,144), ('0252440317PD,144), ('0252440317W,144), ('1155230020,144), ('1155230020PD,144), ('3140420008,144), ('E100116,6495), ('E100298,6495), ('E100498,6495), ('E110119,6495), ('E110264,6495), ('E210587,6495), ('E400116,6495), ('E400298,6495), ('E400498,6495), ('E410119,6495), ('E410264,6495), ('E500116,6495), ('E500298,6495), ('E500498,6495), ('E510119,6495), ('E510264,6495), ('MBA1227,73), ('MBA1610,73), ('MBA841,73), ('MDB2544,73), ('MDB2580,73), ('MDB2638,73), ('MDB2642,73), ('MDB2664,73), ('MDB2673,73), ('MDB2796,73), ('MDB2942,73), ('MDB2943,73), ('MDB3060,73), ('MDB4283,73), ('MDB4284,73), ('MDC1708,73), ('MDC1708C,73), ('MFR544,73), ('D9050MH,6103), ('LVMK1102,4564), ('LVMK1186,4564), ('LVXL1141,4564), ('LVXL1170,4564), ('LVXL1171,4564), ('LVXL1172,4564), ('LVXL1290,4564), ('LVXL1327,4564), ('LVXL1696,4564), ('VBS697,4564), ('NP2167,190), ('NP2283,190), ('NP2913,190), ('NP2936,190), ('NP2948,190), ('NP2999,190), ('NS4031,190), ('NB23326V11,6280), ('NB23692N00,6280), ('NB23748S02,6280), ('NB23914N00,6280), ('NB23973V01,6280), ('FN0589,4682), ('PN0330S,4682), ('PN9805,4682), ('PN9805S,4682), ('NP9004,4990), ('204797,127), ('224762,127), ('224786,127), ('225217,127), ('2715695,127), ('314797,127), ('N360N87,440), ('V361G02,440), ('2134676,4380), ('2134916,4380), ('2134940,4380), ('2135575,4380), ('2135608,4380), ('BDA206220,378), ('BPA089702,378), ('BPA089711,378), ('BPA098711,378), ('BPA104501,378), ('BPA144001,378), ('BSA221100,378), ('BSA221300,378), ('10066,129), ('12179,129), ('12241,129), ('12242,129), ('12263,129), ('12290,129), ('12390,129), ('12545,129), ('9540,129), ('BP09540,129), ('BP10066,129), ('BP12179,129), ('BP12241,129), ('BP12242,129), ('BP12263,129), ('BP12290,129), ('BP12390,129), ('BP12487,129), ('BP12545,129), ('06146,4683), ('09434,4683), ('09435,4683), ('18202,4683), ('29126,4683), ('29152,4683), ('PBP1643,4558), ('PBP1655,4558), ('PBP4069,4558), ('PSP023,4558), ('PSP148,4558), ('JAPPP0007AF,4652), ('PF1393,4655), ('PF13931,4655), ('PF1395,4655), ('PF1396,4655), ('PF13961,4655), ('50001636,4686), ('50001636C,4686), ('50001642,4686), ('50001642C,4686), ('50001643,4686), ('50001643C,4686), ('50001644,4686), ('50001644C,4686), ('50004069,4686), ('50010668,4686), ('50051636,4686), ('50051642,4686), ('50051644,4686), ('50051655,4686), ('50051826,4686), ('PRP0293,4520), ('PRP0337,4520), ('PRP0520,4520), ('PRP0949,4520), ('PRP09493M,4520), ('PRP1412,4520), ('PRP14123M,4520), ('PRP1472,4520), ('PRP14723M,4520), ('PRS0026,4520), ('PRS0027,4520), ('QD4370,4821), ('QP0895,4821), ('QP1641,4821), ('QP1641C,4821), ('QP1985,4821), ('QP2261,4821), ('QP2261C,4821), ('QP2724,4821), ('QP2724C,4821), ('QP3486,4821), ('QP3486C,4821), ('QP5769,4821), ('QP5769C,4821), ('QP5999,4821), ('QP5999C,4821), ('QP7582,4821), ('QP7582C,4821), ('QP8823,4821), ('QP8823C,4821), ('QF500720,4339), ('QF80600,4339), ('QF84000,4339), ('QF84002P,4339), ('BDC5473,57), ('BP1420,57), ('BP1422,57), ('BP1455,57), ('BP1456,57), ('BP1457,57), ('BP1807,57), ('BS1118,57), ('RA08051,400), ('RA08190,400), ('RA08191,400), ('RA08570,400), ('RA08573,400), ('RA08575,400), ('RA10640,400), ('RA12860,400), ('RA28620,400), ('RA28621,400), ('RA28810,400), ('RA28811,400), ('RD00683,400), ('RD00922,400), ('RD01541,400), ('RB1600703,4955), ('RB1674,4955), ('RB1674203,4955), ('RB1674204,4955), ('RB1674208,4955), ('RB1748,4955), ('RB1778,4955), ('RB1779,4955), ('RB1953,4955), ('27SZ000,4869), ('089700,153), ('089702,153), ('098711,153), ('099400,153), ('103100,153), ('104501,153), ('474000,153), ('RAD1066C,214), ('RAP1016,214), ('RAP1033,214), ('RAP1049,214), ('RAP1154,214), ('RAP1251,214), ('RAP1361,214), ('RAP2019,214), ('RAP2210,214), ('RAP2248,214), ('1165G0052,6358), ('1337P0015,6358), ('1419B0002,6358), ('402B0155,6358), ('402B0157,6358), ('402B0234,6358), ('402B0625,6358), ('402B0643,6358), ('402B0668,6358), ('2103100,152), ('2104501,152), ('2104511,152), ('2144001,152), ('289700,152), ('289702,152), ('289711,152), ('298711,152), ('474000,152), ('RT20167,4676), ('RT20167GL,4676), ('RT20167GLT3,4676), ('RT20167GLT5,4676), ('RT20167GLT6,4676), ('5SP1205,343), ('5SP1206,343), ('5SP1219,343), ('5SP1219K,343), ('5SP1229,343), ('5SP1398,343), ('5SP1526,343), ('5SP1536,343), ('5SP1551,343), ('89110,343), ('89150,343), ('6214011,260), ('6216003,260), ('1815204797,297), ('1815314797,297), ('18492715695,297), ('SP288PR,225), ('SP311PR,225), ('SP383PR,225), ('SP733PR,225), ('1495,6331), ('1522,6331), ('DBB286V,6331), ('SPB086,6331), ('SPB087,6331), ('SPB098,6331), ('SPB099,6331), ('SPB130,6331), ('SPB134,6331), ('SPB140,6331), ('SPB248,6331), ('SPB478,6331), ('SPB508,6331), ('SKBK1090036,6357), ('SKBK1090048,6357), ('SKBK1090136,6357), ('SKBK1090346,6357), ('SKBK1090360,6357), ('SKBP0010155,6357), ('SKBP0010157,6357), ('SKBP0010234,6357), ('SKBP0011016,6357), ('SKBP0011189,6357), ('SKBP0011221,6357), ('SKBSP0440001,6357), ('SKPBS1650014,6357), ('000002BSX,4595), ('000080BSX,4595), ('000080SX,4595), ('000083BSX,4595), ('000083SX,4595), ('0001515SX,4595), ('0001540SX,4595), ('000372BSX,4595), ('000443SX,4595), ('000747SX,4595), ('001085BSX,4595), ('001085SX,4595), ('001113SX,4595), ('1005000BSX,4595), ('1042000BLSX,4595), ('1042000BSX,4595), ('1056001BSX,4595), ('1056001SX,4595), ('1056011LSX,4595), ('1056011SX,4595), ('1056022SX,4595), ('908002LSX,4595), ('908002SX,4595), ('908011BLSX,4595), ('908011BSX,4595), ('908011SX,4595), ('031102600280,336), ('031208700940,336), ('031208700950,336), ('10928730,151), ('10929225,151), ('20923851,151), ('30916462,151), ('30916465,151), ('30916588,151), ('30916824,151), ('30916860,151), ('30928682,151), ('60116199,151), ('84916649,151), ('01640,6312), ('01683A,6312), ('01684,6312), ('02169,6312), ('02174,6312), ('756041,6312), ('2332601,39), ('2332603,39), ('2332607,39), ('2332681,39), ('2374602,39), ('2374701,39), ('2374702,39), ('2391401,39), ('2391481,39), ('2397302,39), ('82054900,39), ('82059400,39), ('91058700,39), ('92121403,39), ('97032200,39), ('TX1393,4377), ('TX13931,4377), ('TX1395,4377), ('TX1396,4377), ('TX13961,4377), ('TX14161,4377), ('TX1523,4377), ('TX1646,4377), ('TX2190,4377), ('TX2267,4377), ('110416,301), ('110458,301), ('110540,301), ('112169,301), ('113177,301), ('114855,301), ('TBP309,6022), ('TBP316,6022), ('BD1193,4732), ('PF1203,4732), ('PF1213,4732), ('PF1273,4732), ('PF1383,4732), ('PF1637,4732), ('PF1638,4732), ('PF1639,4732), ('PF1664,4732), ('DF185104,4772), ('GF1862,4772), ('810010022,108), ('810011012,108), ('811029041,108), ('811029052,108), ('811029055,108), ('811029056,108), ('811029084,108), ('811029090,108), ('811029092,108), ('811029167,108), ('811069017,108), ('812029196C,108), ('0735078,209), ('0834084,209), ('019029,199), ('052131,199), ('5680,199), ('5681,199), ('5683,199), ('5690,199), ('5700,199), ('5702,199), ('8480,199), ('DF977,199), ('DF4312,4501), ('GDB1516,4501), ('GDB1556,4501), ('GDB1556DTE,4501), ('GDB1622,4501), ('GDB1622DTE,4501), ('GDB1661,4501), ('GDB1769,4501), ('GDB3396,4501), ('V100772,183), ('V100773,183), ('V102456,183), ('V1080082,183), ('V1081731,183), ('V108175,183), ('V108176,183), ('V108185,183), ('V108186,183), ('V1081861,183), ('V108188,183), ('V108265,183), ('V108351,183), ('V204118,183), ('186886,21), ('297886,21), ('301004,21), ('301847,21), ('302042,21), ('562805,21), ('598651,21), ('598652,21), ('598671,21), ('598847,21), ('601004,21), ('601124,21), ('601287,21), ('872326,21), ('872623,21), ('872746,21), ('873746,21), ('66150920601,4346), ('66980008601,4346), ('66981103101,4346), ('66981106101,4346), ('66981694301,4346), ('66981700501,4346), ('WBP23326A,4498), ('WBP23326B,4498), ('WBP23746A,4498), ('WBP23746B,4498), ('WBP23749A,4498), ('WBP23914A,4498), ('WBP23973B,4498), ('WGR12861,4498), ('1511828,482), ('1511914,482), ('1511944,482), ('1511945,482), ('1511946,482), ('1522134,482), ('P1131300,366), ('P1145301,366), ('P1540301,366), ('P887311,366), ('P997300,366), ('P997302,366), ('Z474000,366), ('140245,6347), ('140411,6347), ('140635,6347), ('141139,6347), ('240207,6347), ('240353,6347), ('340133,6347), ('340143,6347), ('340157,6347), ('340187,6347), ('340189,6347), ('340225,6347), ('340591,6347), ('340939,6347), ('340993,6347), ('341099,6347), ('341233,6347), ('BK4164,4894), ('BK4443,4894), ('BS1248,4894), ('BS1256,4894), ('BS2934,4894), ('BS2948,4894), ('109901062,86), ('109901063,86), ('237461751,86), ('237469751,86), ('237471851,86), ('237479851,86), ('239731651,86), ('ADK84232,350), ('500947,481), ('LVXL1391,4564), ('PN0330,4682), ('JCP8041,4935), ('JCP1826,4935), ('JCP1408,4935), ('FP1018,4937), ('FP3269E,4937), ('13046072452,3), ('13046071922,3), ('098650A214,30), ('0986494202,30), ('BL1871A1,54), ('BG3893C,89), ('811029093,108), ('812029196,108), ('PA0947AF,156), ('9108,206), ('9229,206), ('RAP1847,214), ('50000947,257), ('6115511,279), ('134200,286)
        
) AS search_list(search_art, search_sup)

INNER JOIN article a 
    ON a.articleSearch = search_list.search_art 
   AND a.supplierId = search_list.search_sup

LEFT JOIN article_oem 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 LATERAL (
    SELECT ps_sub.id 
    FROM products.products_suppliers ps_sub 
    WHERE ps_sub.product_id = p.id 
      AND ps_sub.supplier_id IN (223)
) ps_sub ON true;
An internal server error occurred.