SELECT  ps.id, (s.groups_ids->>'4')::integer as supplier_group_id, p.article, ps.supplier_id, ps.title, ps.price, ps.quantity, ps.min_quantity,  b.image as brand_image, b.title as brand_title, b.id as main_brand_id, b.offline_tecdoc_id as main_brand_tecdoc_id,
                        sg.autoartis_koeff as autoartis_koeff, a.supplierId, b.title as main_brand_title, i.fileName, b2.offline_tecdoc_id
                FROM products.products as p                
                LEFT JOIN products.brands b ON p.brand_id=b.main_id AND b.id=b.main_id
                LEFT JOIN products.brands b2 ON b2.id=b.main_id
                LEFT JOIN tecdoc2021.article a ON a.articleSearch=p.article AND a.supplierId=b2.offline_tecdoc_id
                LEFT JOIN tecdoc2021.article_image i ON i.supplierId=b2.offline_tecdoc_id AND i.articleNumber=a.articleNumber
                INNER JOIN products.products_suppliers as ps ON p.id=ps.product_id
                LEFT JOIN products.suppliers as s ON s.id=ps.supplier_id
                LEFT JOIN products.suppliers_groups as sg ON sg.id=(s.groups_ids->>'4')::int
                WHERE ps.quantity>0 AND ((p.article='ADD8KHF' AND p.brand_id IN (463)) OR (p.article='109425' AND p.brand_id IN (90,31317,1248,5434)) OR (p.article='109438' AND p.brand_id IN (90,31317,1248,5434)) OR (p.article='36721' AND p.brand_id IN (90,31317,1248,5434)) OR (p.article='F87716' AND p.brand_id IN (37562,3715,107)) OR (p.article='42760' AND p.brand_id IN (468)) OR (p.article='30936721' AND p.brand_id IN (37620,123)) OR (p.article='174361KIT' AND p.brand_id IN (37563,6578,30136,30098,248,3301,27428,27927)) OR (p.article='D5127' AND p.brand_id IN (37008,4922,5047,27548,4950,30673,269)) OR (p.article='D5174' AND p.brand_id IN (37008,4922,5047,27548,4950,30673,269)) OR (p.article='110067110' AND p.brand_id IN (252,32421,4949,29129,7790,7030,33780)) OR (p.article='047303B' AND p.brand_id IN (29876,37510,29550,681,32359,32364,45,46)) OR (p.article='047304B' AND p.brand_id IN (29876,37510,29550,681,32359,32364,45,46)) OR (p.article='BU9788' AND p.brand_id IN (30506,347)) OR (p.article='51980' AND p.brand_id IN (4981,168)) OR (p.article='52513' AND p.brand_id IN (4981,168)) OR (p.article='59209' AND p.brand_id IN (4981,168)) OR (p.article='59214' AND p.brand_id IN (4981,168)) OR (p.article='756978' AND p.brand_id IN (2953,586)) OR (p.article='756979' AND p.brand_id IN (2953,586)) OR (p.article='PK0201' AND p.brand_id IN (3276,29980)) OR (p.article='PK0203' AND p.brand_id IN (3276,29980)) OR (p.article='PK0205' AND p.brand_id IN (3276,29980)) OR (p.article='520126' AND p.brand_id IN (413)) OR (p.article='520176' AND p.brand_id IN (413)) OR (p.article='109426' AND p.brand_id IN (90,31317,1248,5434)) OR (p.article='36725' AND p.brand_id IN (90,31317,1248,5434)) OR (p.article='5406060PK' AND p.brand_id IN (283,6850)) OR (p.article='5406061PK' AND p.brand_id IN (283,6850)) OR (p.article='910118' AND p.brand_id IN (76,77,31433,5436)) OR (p.article='910119' AND p.brand_id IN (76,77,31433,5436)) OR (p.article='PR7032' AND p.brand_id IN (5414,37044,4900,438)) OR (p.article='A9A015MT' AND p.brand_id IN (394,6298)) OR (p.article='725678' AND p.brand_id IN (304)) OR (p.article='42002' AND p.brand_id IN (457,2974,3711)) OR (p.article='42003' AND p.brand_id IN (457,2974,3711)) OR (p.article='1006400014' AND p.brand_id IN (120)) OR (p.article='1006420011' AND p.brand_id IN (120)) OR (p.article='1006420015' AND p.brand_id IN (120)) OR (p.article='PK281' AND p.brand_id IN (668,32604,30844,3791,3887,37,3790)) OR (p.article='694726' AND p.brand_id IN (106)) OR (p.article='DCK508304' AND p.brand_id IN (288,3075)) OR (p.article='DCK508404' AND p.brand_id IN (288,3075)) OR (p.article='F87715' AND p.brand_id IN (37562,3715,107)) OR (p.article='37296' AND p.brand_id IN (31394,2854,258)) OR (p.article='37688' AND p.brand_id IN (31394,2854,258)) OR (p.article='48490' AND p.brand_id IN (31394,2854,258)) OR (p.article='48513' AND p.brand_id IN (31394,2854,258)) OR (p.article='50335' AND p.brand_id IN (31394,2854,258)) OR (p.article='50761' AND p.brand_id IN (31394,2854,258)) OR (p.article='QF22D00015' AND p.brand_id IN (29545,3261,381)) OR (p.article='VKDP33128T' AND p.brand_id IN (38027,47,37050)) OR (p.article='VKDP33140T' AND p.brand_id IN (38027,47,37050)) OR (p.article='T442002' AND p.brand_id IN (458)) OR (p.article='T442003' AND p.brand_id IN (458)) OR (p.article='1198190SX' AND p.brand_id IN (437)) OR (p.article='30109425' AND p.brand_id IN (37620,123)) OR (p.article='30936725' AND p.brand_id IN (37620,123)) OR (p.article='33100275' AND p.brand_id IN (37620,123)) OR (p.article='33100276' AND p.brand_id IN (37620,123)) OR (p.article='TED57341' AND p.brand_id IN (30546,436)) OR (p.article='113443' AND p.brand_id IN (37605,6695,29104,4901,6490,5433,234)) OR (p.article='113444' AND p.brand_id IN (37605,6695,29104,4901,6490,5433,234)) OR (p.article='620453' AND p.brand_id IN (37605,6695,29104,4901,6490,5433,234)) OR (p.article='BC1666' AND p.brand_id IN (502)) OR (p.article='BC1684' AND p.brand_id IN (502)) OR (p.article='392801' AND p.brand_id IN (662)) OR (p.article='392804' AND p.brand_id IN (662)) OR (p.article='V103370' AND p.brand_id IN (39162,39163,39130,33103,6249,6237,21186,5220,5260,133,148)) OR (p.article='V106199' AND p.brand_id IN (39162,39163,39130,33103,6249,6237,21186,5220,5260,133,148)) OR (p.article='44030' AND p.brand_id IN (392)) OR (p.article='VE51980' AND p.brand_id IN (392)) OR (p.article='VE52513' AND p.brand_id IN (392)) OR (p.article='44121783301' AND p.brand_id IN (24369,384)) OR (p.article='WG2031172' AND p.brand_id IN (4099,684)) OR (p.article='WG2032131' AND p.brand_id IN (4099,684)) OR (p.article='ZVTM002A' AND p.brand_id IN (5195)) OR (p.article='4G0412131' AND p.brand_id IN (33394,29566,29328,957,721,1346,2760,828,830,33238,2761,33391,4914,852,37467,37468,37470,33707,4905,5949,1259,1345)) OR (p.article='8E0412377' AND p.brand_id IN (33394,29566,29328,957,721,1346,2760,828,830,33238,2761,33391,4914,852,37467,37468,37470,33707,4905,5949,1259,1345)) OR (p.article='8E0412377C' AND p.brand_id IN (33394,29566,29328,957,721,1346,2760,828,830,33238,2761,33391,4914,852,37467,37468,37470,33707,4905,5949,1259,1345)) OR (p.article='8K0412131E' AND p.brand_id IN (33394,29566,29328,957,721,1346,2760,828,830,33238,2761,33391,4914,852,37467,37468,37470,33707,4905,5949,1259,1345)) OR (p.article='8K0412131F' AND p.brand_id IN (33394,29566,29328,957,721,1346,2760,828,830,33238,2761,33391,4914,852,37467,37468,37470,33707,4905,5949,1259,1345)) OR (p.article='8K0412131G' AND p.brand_id IN (33394,29566,29328,957,721,1346,2760,828,830,33238,2761,33391,4914,852,37467,37468,37470,33707,4905,5949,1259,1345)) OR (p.article='8K0412137A' AND p.brand_id IN (33394,29566,29328,957,721,1346,2760,828,830,33238,2761,33391,4914,852,37467,37468,37470,33707,4905,5949,1259,1345)) OR (p.article='8K0412377B' AND p.brand_id IN (33394,29566,29328,957,721,1346,2760,828,830,33238,2761,33391,4914,852,37467,37468,37470,33707,4905,5949,1259,1345)) OR (p.article='8W0512131G' AND p.brand_id IN (33394,29566,29328,957,721,1346,2760,828,830,33238,2761,33391,4914,852,37467,37468,37470,33707,4905,5949,1259,1345)) OR (p.article='8W0512131GS1' AND p.brand_id IN (33394,29566,29328,957,721,1346,2760,828,830,33238,2761,33391,4914,852,37467,37468,37470,33707,4905,5949,1259,1345)) OR (p.article='5532622001' AND p.brand_id IN (39328,37659,37660,38114,4896,5011,33791,37484,37500,37501,37024,27445,37516,940,941,5572,5451,3005,5745,37998,29639,5034,30155,30133,4928,5025,32132,32131,32133,29564,4897,4895,37469,37472,37066,5121,6641,3004,33231,32130,33243,5023)) OR (p.article='047131B' AND p.brand_id IN (29876,37510,29550,681,32359,32364,45,46)) OR (p.article='047267B' AND p.brand_id IN (29876,37510,29550,681,32359,32364,45,46)) OR (p.article='047305B' AND p.brand_id IN (29876,37510,29550,681,32359,32364,45,46)) OR (p.article='047412B' AND p.brand_id IN (29876,37510,29550,681,32359,32364,45,46)) OR (p.article='062651B' AND p.brand_id IN (29876,37510,29550,681,32359,32364,45,46)) OR (p.article='07009' AND p.brand_id IN (457,2974,3711)) OR (p.article='1004120096' AND p.brand_id IN (120)) OR (p.article='1006400013' AND p.brand_id IN (120)) OR (p.article='1006410010' AND p.brand_id IN (120)) OR (p.article='1006420016' AND p.brand_id IN (120)) OR (p.article='108836' AND p.brand_id IN (90,31317,1248,5434)) OR (p.article='110067210' AND p.brand_id IN (252,32421,4949,29129,7790,7030,33780)) OR (p.article='110070210' AND p.brand_id IN (252,32421,4949,29129,7790,7030,33780)) OR (p.article='110447' AND p.brand_id IN (37605,6695,29104,4901,6490,5433,234)) OR (p.article='11271987' AND p.brand_id IN (32029,16)) OR (p.article='113445' AND p.brand_id IN (37605,6695,29104,4901,6490,5433,234)) OR (p.article='113621' AND p.brand_id IN (37605,6695,29104,4901,6490,5433,234)) OR (p.article='11421013S' AND p.brand_id IN (39143,5579,29506,29792,491)) OR (p.article='11421018S' AND p.brand_id IN (39143,5579,29506,29792,491)) OR (p.article='1142400900' AND p.brand_id IN (39320,29441,28665,4953,2607,6916,211)) OR (p.article='115927' AND p.brand_id IN (37605,6695,29104,4901,6490,5433,234)) OR (p.article='116139' AND p.brand_id IN (37605,6695,29104,4901,6490,5433,234)) OR (p.article='11688' AND p.brand_id IN (468)) OR (p.article='1180S0096' AND p.brand_id IN (6693)) OR (p.article='1198253SX' AND p.brand_id IN (437)) OR (p.article='11984' AND p.brand_id IN (12099,37037,30074,685)) OR (p.article='12224463' AND p.brand_id IN (32029,16)) OR (p.article='12228812' AND p.brand_id IN (32029,16)) OR (p.article='174363' AND p.brand_id IN (37563,6578,30136,30098,248,3301,27428,27927)) OR (p.article='17437' AND p.brand_id IN (37563,6578,30136,30098,248,3301,27428,27927)) OR (p.article='175101' AND p.brand_id IN (37563,6578,30136,30098,248,3301,27428,27927)) OR (p.article='176973' AND p.brand_id IN (37563,6578,30136,30098,248,3301,27428,27927)) OR (p.article='180054460' AND p.brand_id IN (274,26354,2941,27951)) OR (p.article='209109' AND p.brand_id IN (149)) OR (p.article='209207' AND p.brand_id IN (149)) OR (p.article='21210Z' AND p.brand_id IN (3101,292)) OR (p.article='23140660' AND p.brand_id IN (469,6992)) OR (p.article='2585901' AND p.brand_id IN (37645,39555,5020,5415,35,4927,5835,6543,34)) OR (p.article='26360' AND p.brand_id IN (90,31317,1248,5434)) OR (p.article='300118' AND p.brand_id IN (651)) OR (p.article='30932635' AND p.brand_id IN (37620,123)) OR (p.article='30936605' AND p.brand_id IN (37620,123)) OR (p.article='30936726' AND p.brand_id IN (37620,123)) OR (p.article='30937127' AND p.brand_id IN (37620,123)) OR (p.article='30940384' AND p.brand_id IN (37620,123)) OR (p.article='32635' AND p.brand_id IN (90,31317,1248,5434)) OR (p.article='32926360' AND p.brand_id IN (37620,123)) OR (p.article='33100288' AND p.brand_id IN (37620,123)) OR (p.article='3490801' AND p.brand_id IN (37645,39555,5020,5415,35,4927,5835,6543,34)) OR (p.article='35039' AND p.brand_id IN (31394,2854,258)) OR (p.article='350392' AND p.brand_id IN (31394,2854,258)) OR (p.article='35153' AND p.brand_id IN (31394,2854,258)) OR (p.article='35196' AND p.brand_id IN (31394,2854,258)) OR (p.article='351962' AND p.brand_id IN (31394,2854,258)) OR (p.article='36605' AND p.brand_id IN (90,31317,1248,5434)) OR (p.article='36726' AND p.brand_id IN (90,31317,1248,5434)) OR (p.article='37127' AND p.brand_id IN (90,31317,1248,5434)) OR (p.article='37691' AND p.brand_id IN (31394,2854,258)) OR (p.article='37692' AND p.brand_id IN (31394,2854,258)) OR (p.article='37819' AND p.brand_id IN (109)) OR (p.article='37855' AND p.brand_id IN (109)) OR (p.article='381215' AND p.brand_id IN (21286)) OR (p.article='381413' AND p.brand_id IN (21286)) OR (p.article='391876' AND p.brand_id IN (662)) OR (p.article='392802' AND p.brand_id IN (662)) OR (p.article='392805' AND p.brand_id IN (662)) OR (p.article='40384' AND p.brand_id IN (90,31317,1248,5434)) OR (p.article='40574' AND p.brand_id IN (457,2974,3711)) OR (p.article='4090400' AND p.brand_id IN (3535,4977,420)) OR (p.article='413014' AND p.brand_id IN (30654,6544,30653,30800,37520,53,1267,6066,6256,27681,5237,31493,6570,6171,29106,6254,5016,2,52,4982,29942)) OR (p.article='42004' AND p.brand_id IN (457,2974,3711)) OR (p.article='42039' AND p.brand_id IN (457,2974,3711)) OR (p.article='44029' AND p.brand_id IN (392)) OR (p.article='44031' AND p.brand_id IN (392)) OR (p.article='44120882601' AND p.brand_id IN (24369,384)) OR (p.article='44121162801' AND p.brand_id IN (24369,384)) OR (p.article='461173' AND p.brand_id IN (2953,586)) OR (p.article='48455' AND p.brand_id IN (31394,2854,258)) OR (p.article='48532' AND p.brand_id IN (31394,2854,258)) OR (p.article='48551' AND p.brand_id IN (31394,2854,258)) OR (p.article='48553' AND p.brand_id IN (31394,2854,258)) OR (p.article='48651' AND p.brand_id IN (31394,2854,258)) OR (p.article='50189' AND p.brand_id IN (4981,168)) OR (p.article='502429' AND p.brand_id IN (7751)) OR (p.article='50428' AND p.brand_id IN (37563,6578,30136,30098,248,3301,27428,27927)) OR (p.article='50540' AND p.brand_id IN (31394,2854,258)) OR (p.article='50764' AND p.brand_id IN (31394,2854,258)) OR (p.article='50957' AND p.brand_id IN (4981,168)) OR (p.article='51007' AND p.brand_id IN (31394,2854,258)) OR (p.article='510383' AND p.brand_id IN (283,6850)) OR (p.article='510383K' AND p.brand_id IN (283,6850)) OR (p.article='51045' AND p.brand_id IN (31394,2854,258)) OR (p.article='51078' AND p.brand_id IN (31394,2854,258)) OR (p.article='51080' AND p.brand_id IN (31394,2854,258)) OR (p.article='513835' AND p.brand_id IN (283,6850)) OR (p.article='513835K' AND p.brand_id IN (283,6850)) OR (p.article='51981' AND p.brand_id IN (4981,168)) OR (p.article='520222' AND p.brand_id IN (413)) OR (p.article='52472' AND p.brand_id IN (4981,168)) OR (p.article='52505' AND p.brand_id IN (4981,168)) OR (p.article='52528' AND p.brand_id IN (3385,7321,3386,31109,21847)) OR (p.article='5406000PK' AND p.brand_id IN (283,6850)) OR (p.article='5406062PK' AND p.brand_id IN (283,6850)) OR (p.article='57484' AND p.brand_id IN (457,2974,3711)) OR (p.article='590124' AND p.brand_id IN (191)) OR (p.article='59211' AND p.brand_id IN (4981,168)) OR (p.article='59213' AND p.brand_id IN (4981,168)) OR (p.article='59215' AND p.brand_id IN (4981,168)) OR (p.article='6302089' AND p.brand_id IN (497)) OR (p.article='6302092' AND p.brand_id IN (497)) OR (p.article='6309463' AND p.brand_id IN (497)) OR (p.article='684711' AND p.brand_id IN (106)) OR (p.article='693401' AND p.brand_id IN (106)) OR (p.article='70039K' AND p.brand_id IN (29920)) OR (p.article='722399' AND p.brand_id IN (304)) OR (p.article='7324568' AND p.brand_id IN (2868)) OR (p.article='7324986' AND p.brand_id IN (2868)) OR (p.article='7324988' AND p.brand_id IN (2868)) OR (p.article='750961' AND p.brand_id IN (2953,586)) OR (p.article='755855' AND p.brand_id IN (2953,586)) OR (p.article='756980' AND p.brand_id IN (2953,586)) OR (p.article='760116' AND p.brand_id IN (2953,586)) OR (p.article='80000248' AND p.brand_id IN (116)) OR (p.article='802200' AND p.brand_id IN (30)) OR (p.article='802515' AND p.brand_id IN (30)) OR (p.article='814009910' AND p.brand_id IN (4130,30950,154)) OR (p.article='814017510' AND p.brand_id IN (4130,30950,154)) OR (p.article='825704' AND p.brand_id IN (4131,970,22)) OR (p.article='825720' AND p.brand_id IN (4131,970,22)) OR (p.article='837403' AND p.brand_id IN (111)) OR (p.article='850029922' AND p.brand_id IN (223)) OR (p.article='850029922' AND p.brand_id IN (94)) OR (p.article='850029929' AND p.brand_id IN (223)) OR (p.article='850029929' AND p.brand_id IN (94)) OR (p.article='87687A' AND p.brand_id IN (14)) OR (p.article='88840A' AND p.brand_id IN (14)) OR (p.article='9005620' AND p.brand_id IN (206)) OR (p.article='910062' AND p.brand_id IN (76,77,31433,5436)) OR (p.article='910117' AND p.brand_id IN (76,77,31433,5436)) OR (p.article='910258' AND p.brand_id IN (76,77,31433,5436)) OR (p.article='ADVW029' AND p.brand_id IN (5758)) OR (p.article='AK735449' AND p.brand_id IN (37562,3715,107)) OR (p.article='AUSB9515' AND p.brand_id IN (38098,5448,110)) OR (p.article='B19199' AND p.brand_id IN (504)) OR (p.article='BSJ10022' AND p.brand_id IN (81)) OR (p.article='BSJ10023' AND p.brand_id IN (81)) OR (p.article='BSM5130' AND p.brand_id IN (346,5019,35286,2002)) OR (p.article='BSM5336' AND p.brand_id IN (346,5019,35286,2002)) OR (p.article='D5220' AND p.brand_id IN (37008,4922,5047,27548,4950,30673,269)) OR (p.article='D600116' AND p.brand_id IN (33811,7795,150)) OR (p.article='DB31011' AND p.brand_id IN (4910)) OR (p.article='DB47024' AND p.brand_id IN (4910)) OR (p.article='DB47124' AND p.brand_id IN (4910)) OR (p.article='F87451' AND p.brand_id IN (37562,3715,107)) OR (p.article='F87681' AND p.brand_id IN (37562,3715,107)) OR (p.article='F87717' AND p.brand_id IN (37562,3715,107)) OR (p.article='F87842' AND p.brand_id IN (37562,3715,107)) OR (p.article='FSM5130' AND p.brand_id IN (12134,30712,587)) OR (p.article='FSM5336' AND p.brand_id IN (12134,30712,587)) OR (p.article='GK406' AND p.brand_id IN (3649,66,29884)) OR (p.article='HYSHBACR' AND p.brand_id IN (463)) OR (p.article='JSB157' AND p.brand_id IN (5459,25053,3647,591,2120,2323,19,5179,6099,590,3467,132)) OR (p.article='KB65716' AND p.brand_id IN (5171,4934,5805,2046,5458,36626,96)) OR (p.article='KB65722' AND p.brand_id IN (5171,4934,5805,2046,5458,36626,96)) OR (p.article='KS169' AND p.brand_id IN (191)) OR (p.article='MK207' AND p.brand_id IN (668,32604,30844,3791,3887,37,3790)) OR (p.article='PK391' AND p.brand_id IN (668,32604,30844,3791,3887,37,3790)) OR (p.article='PR7019' AND p.brand_id IN (5414,37044,4900,438)) OR (p.article='PSE4490' AND p.brand_id IN (425)) OR (p.article='PSE6327' AND p.brand_id IN (425)) OR (p.article='QF00V00022' AND p.brand_id IN (29545,3261,381)) OR (p.article='R52658' AND p.brand_id IN (2880)) OR (p.article='R54979' AND p.brand_id IN (2880)) OR (p.article='SKSS0670095' AND p.brand_id IN (24077)) OR (p.article='SM0438' AND p.brand_id IN (28636)) OR (p.article='SM0444' AND p.brand_id IN (28636)) OR (p.article='SM3069S' AND p.brand_id IN (522)) OR (p.article='SM5446' AND p.brand_id IN (76,77,31433,5436)) OR (p.article='SM5784' AND p.brand_id IN (76,77,31433,5436)) OR (p.article='SMT203600' AND p.brand_id IN (288,3075)) OR (p.article='SS3186' AND p.brand_id IN (2606,39121,29530,12095,210)) OR (p.article='SS7882' AND p.brand_id IN (2606,39121,29530,12095,210)) OR (p.article='T407009' AND p.brand_id IN (458)) OR (p.article='T440574' AND p.brand_id IN (458)) OR (p.article='T442004' AND p.brand_id IN (458)) OR (p.article='T442039' AND p.brand_id IN (458)) OR (p.article='T457484' AND p.brand_id IN (458)) OR (p.article='V100976' AND p.brand_id IN (39162,39163,39130,33103,6249,6237,21186,5220,5260,133,148)) OR (p.article='V101430' AND p.brand_id IN (39162,39163,39130,33103,6249,6237,21186,5220,5260,133,148)) OR (p.article='V103355' AND p.brand_id IN (39162,39163,39130,33103,6249,6237,21186,5220,5260,133,148)) OR (p.article='V103371' AND p.brand_id IN (39162,39163,39130,33103,6249,6237,21186,5220,5260,133,148)) OR (p.article='V106402' AND p.brand_id IN (39162,39163,39130,33103,6249,6237,21186,5220,5260,133,148)) OR (p.article='VE50189' AND p.brand_id IN (392)) OR (p.article='VE50957' AND p.brand_id IN (392)) OR (p.article='VE51981' AND p.brand_id IN (392)) OR (p.article='VE52472' AND p.brand_id IN (392)) OR (p.article='VE52505' AND p.brand_id IN (392)) OR (p.article='VKDA35123T' AND p.brand_id IN (38027,47,37050)) OR (p.article='VKDP33129T' AND p.brand_id IN (38027,47,37050)) OR (p.article='VKDP33144T' AND p.brand_id IN (38027,47,37050)) OR (p.article='VKDP33146T' AND p.brand_id IN (38027,47,37050)) OR (p.article='PSE6348' AND p.brand_id IN (425)) OR (p.article='55325220005532622001' AND p.brand_id IN (0)) OR (p.article='ADSHBA5FKIT' AND p.brand_id IN (463)) OR (p.article='FC223' AND p.brand_id IN (4445)) OR (p.article='44121784401' AND p.brand_id IN (24369,384)) OR (p.article='K41784801' AND p.brand_id IN (24369,384)) OR (p.article='K41784601' AND p.brand_id IN (24369,384)) OR (p.article='DR0315' AND p.brand_id IN (4942)) OR (p.article='TAH1270' AND p.brand_id IN (29716,21017,28631)) OR (p.article='TAH1303' AND p.brand_id IN (29716,21017,28631)) OR (p.article='ADSHB8K5FKIT' AND p.brand_id IN (463)) OR (p.article='ADSHBA6IVFKIT' AND p.brand_id IN (463)) OR (p.article='DR0349' AND p.brand_id IN (4942)) OR (p.article='PR7097' AND p.brand_id IN (5414,37044,4900,438)) OR (p.article='MAB1189' AND p.brand_id IN (4907)) OR (p.article='8R0412131D' AND p.brand_id IN (33394,29566,29328,957,721,1346,2760,828,830,33238,2761,33391,4914,852,37467,37468,37470,33707,4905,5949,1259,1345)) OR (p.article='PR7185' AND p.brand_id IN (5414,37044,4900,438)) OR (p.article='21134' AND p.brand_id IN (5569)) OR (p.article='STP1005' AND p.brand_id IN (24073)) OR (p.article='MAB1190' AND p.brand_id IN (4907)) OR (p.article='ADSHBQ5FKIT' AND p.brand_id IN (463)) OR (p.article='SPK100' AND p.brand_id IN (214)) OR (p.article='DB44001' AND p.brand_id IN (4910))) AND ps.supplier_id IN (224,226,223,225,227)An internal server error occurred.