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='K11285' AND p.brand_id IN (31098,166,3538)) OR (p.article='92115855' AND p.brand_id IN (517)) OR (p.article='903676' AND p.brand_id IN (106)) OR (p.article='19113' AND p.brand_id IN (468)) OR (p.article='PC3082' AND p.brand_id IN (425)) OR (p.article='10253004' AND p.brand_id IN (2078,33819,5176,6085,2077,5155)) OR (p.article='2998593SX' AND p.brand_id IN (437)) OR (p.article='K18963' AND p.brand_id IN (31098,166,3538)) OR (p.article='220296' AND p.brand_id IN (5119)) OR (p.article='330232' AND p.brand_id IN (5119)) OR (p.article='330245' AND p.brand_id IN (5119)) OR (p.article='22760' AND p.brand_id IN (37563,6578,30136,30098,248,3301,27428,27927)) OR (p.article='22853' AND p.brand_id IN (37563,6578,30136,30098,248,3301,27428,27927)) OR (p.article='29385' AND p.brand_id IN (37563,6578,30136,30098,248,3301,27428,27927)) OR (p.article='CAB1368' AND p.brand_id IN (2526,636)) OR (p.article='13103331' AND p.brand_id IN (205)) OR (p.article='ASH31603' AND p.brand_id IN (28553,597)) OR (p.article='PAL31045' AND p.brand_id IN (28553,597)) OR (p.article='24372707322' AND p.brand_id IN (4)) OR (p.article='24372707412' AND p.brand_id IN (4)) OR (p.article='24372718252' AND p.brand_id IN (4)) OR (p.article='11045' AND p.brand_id IN (5721,408)) OR (p.article='120076610' AND p.brand_id IN (252,32421,4949,29129,7790,7030,33780)) OR (p.article='290HC00570' AND p.brand_id IN (29911)) OR (p.article='BKB1205' AND p.brand_id IN (346,5019,35286,2002)) OR (p.article='BKB1208' AND p.brand_id IN (346,5019,35286,2002)) OR (p.article='BKB1393' AND p.brand_id IN (346,5019,35286,2002)) OR (p.article='BKB2681' AND p.brand_id IN (346,5019,35286,2002)) OR (p.article='BKB3325' AND p.brand_id IN (346,5019,35286,2002)) OR (p.article='1987477253' AND p.brand_id IN (5442,7131,3201,5010,3617,3114,28)) OR (p.article='1987477258' AND p.brand_id IN (5442,7131,3201,5010,3617,3114,28)) OR (p.article='1987482420' AND p.brand_id IN (5442,7131,3201,5010,3617,3114,28)) OR (p.article='601196' AND p.brand_id IN (673,4055)) OR (p.article='601320' AND p.brand_id IN (673,4055)) OR (p.article='601550' AND p.brand_id IN (673,4055)) OR (p.article='601570' AND p.brand_id IN (673,4055)) OR (p.article='R8794' AND p.brand_id IN (646)) OR (p.article='480023' AND p.brand_id IN (2953,586)) OR (p.article='761959' AND p.brand_id IN (2953,586)) OR (p.article='763907' AND p.brand_id IN (2953,586)) OR (p.article='765747' AND p.brand_id IN (2953,586)) OR (p.article='OP02141' AND p.brand_id IN (254)) OR (p.article='OP02142' AND p.brand_id IN (254)) OR (p.article='OP02161' AND p.brand_id IN (254)) OR (p.article='115852' AND p.brand_id IN (517)) OR (p.article='115855' AND p.brand_id IN (517)) OR (p.article='170690' AND p.brand_id IN (517)) OR (p.article='92115852' AND p.brand_id IN (517)) OR (p.article='92170690' AND p.brand_id IN (517)) OR (p.article='26SKV046' AND p.brand_id IN (39241,39242,39240,39243,33864,32194,22596,6400,538)) OR (p.article='1637154980' AND p.brand_id IN (39295,4518,5115)) OR (p.article='FHB432117' AND p.brand_id IN (3657,37587,59)) OR (p.article='FKB1205' AND p.brand_id IN (12134,30712,587)) OR (p.article='FKB1208' AND p.brand_id IN (12134,30712,587)) OR (p.article='FKB1393' AND p.brand_id IN (12134,30712,587)) OR (p.article='FKB2681' AND p.brand_id IN (12134,30712,587)) OR (p.article='FKB3325' AND p.brand_id IN (12134,30712,587)) OR (p.article='FBS15013' AND p.brand_id IN (12186,50)) OR (p.article='FBS17016' AND p.brand_id IN (12186,50)) OR (p.article='FBS17033' AND p.brand_id IN (12186,50)) OR (p.article='8AS355667601' AND p.brand_id IN (12,21534,33779,5799,2003,3635,31097,33228,31994,37464,37465,37466,49,2548,91,1129,4082,3652,3636,3786,3862,5463,5515,5001,5137,3,665,447)) OR (p.article='8AS355667641' AND p.brand_id IN (12,21534,33779,5799,2003,3635,31097,33228,31994,37464,37465,37466,49,2548,91,1129,4082,3652,3636,3786,3862,5463,5515,5001,5137,3,665,447)) OR (p.article='J3923076' AND p.brand_id IN (39111,39503,51,1024,12324,995,22911,5246,6192,36565,6869,2519,32501,29678,29647,6277,22910,5057,6068,5263,67)) OR (p.article='BC331' AND p.brand_id IN (2205,128,4966)) OR (p.article='131331' AND p.brand_id IN (349)) OR (p.article='1270301900' AND p.brand_id IN (39320,29441,28665,4953,2607,6916,211)) OR (p.article='432117J' AND p.brand_id IN (29876,37510,29550,681,32359,32364,45,46)) OR (p.article='BHC1033' AND p.brand_id IN (162,6386)) OR (p.article='5461' AND p.brand_id IN (23334,639)) OR (p.article='7405' AND p.brand_id IN (23334,639)) OR (p.article='7421' AND p.brand_id IN (23334,639)) OR (p.article='2159301' AND p.brand_id IN (37645,39555,5020,5415,35,4927,5835,6543,34)) OR (p.article='320117' AND p.brand_id IN (3496)) OR (p.article='C0572B' AND p.brand_id IN (37569,37570,37571,33821,33822,5056,38025,1088,222,605,27409,159,30960)) OR (p.article='5614' AND p.brand_id IN (109)) OR (p.article='5706' AND p.brand_id IN (109)) OR (p.article='320059' AND p.brand_id IN (304)) OR (p.article='MCL9331' AND p.brand_id IN (672)) OR (p.article='82460' AND p.brand_id IN (457,2974,3711)) OR (p.article='82484' AND p.brand_id IN (457,2974,3711)) OR (p.article='82499' AND p.brand_id IN (457,2974,3711)) OR (p.article='84683' AND p.brand_id IN (457,2974,3711)) OR (p.article='115855' AND p.brand_id IN (86)) OR (p.article='LVVB1786' AND p.brand_id IN (37433,638)) OR (p.article='VVB544' AND p.brand_id IN (37433,638)) OR (p.article='J18963' AND p.brand_id IN (198)) OR (p.article='903290' AND p.brand_id IN (106)) OR (p.article='903680' AND p.brand_id IN (106)) OR (p.article='M293A54' AND p.brand_id IN (20493,38212,33789,324)) OR (p.article='0507371' AND p.brand_id IN (160)) OR (p.article='50318' AND p.brand_id IN (468)) OR (p.article='JAPBC331' AND p.brand_id IN (650)) OR (p.article='BC2023' AND p.brand_id IN (33803,37442,2313,5640,54)) OR (p.article='BC2230' AND p.brand_id IN (33803,37442,2313,5640,54)) OR (p.article='BC2420' AND p.brand_id IN (33803,37442,2313,5640,54)) OR (p.article='BC4456' AND p.brand_id IN (33803,37442,2313,5640,54)) OR (p.article='49MZ012' AND p.brand_id IN (29894,32706,4157,4156,37357)) OR (p.article='01300044' AND p.brand_id IN (3121,29968)) OR (p.article='01360651' AND p.brand_id IN (3121,29968)) OR (p.article='01360652' AND p.brand_id IN (3121,29968)) OR (p.article='2018794' AND p.brand_id IN (441)) OR (p.article='C0572B' AND p.brand_id IN (2989,23863,2789)) OR (p.article='097923' AND p.brand_id IN (446)) OR (p.article='653100' AND p.brand_id IN (564)) OR (p.article='912591' AND p.brand_id IN (434)) OR (p.article='999175' AND p.brand_id IN (434)) OR (p.article='T482460' AND p.brand_id IN (458)) OR (p.article='T482484' AND p.brand_id IN (458)) OR (p.article='T482499' AND p.brand_id IN (458)) OR (p.article='T484683' AND p.brand_id IN (458)) OR (p.article='200872' AND p.brand_id IN (37605,6695,29104,4901,6490,5433,234)) OR (p.article='814024124' AND p.brand_id IN (94)) OR (p.article='814024141' AND p.brand_id IN (94)) OR (p.article='JTR4286' AND p.brand_id IN (5459,25053,3647,591,2120,2323,19,5179,6099,590,3467,132)) OR (p.article='V4030036' AND p.brand_id IN (39162,39163,39130,33103,6249,6237,21186,5220,5260,133,148)) OR (p.article='V4030047' AND p.brand_id IN (39162,39163,39130,33103,6249,6237,21186,5220,5260,133,148)) OR (p.article='560119' AND p.brand_id IN (21286)) OR (p.article='560527' AND p.brand_id IN (21286)) OR (p.article='580234' AND p.brand_id IN (21286)) OR (p.article='21593' AND p.brand_id IN (37645,39555,5020,5415,35,4927,5835,6543,34)) OR (p.article='BC2233' AND p.brand_id IN (33803,37442,2313,5640,54)) OR (p.article='K11355' AND p.brand_id IN (31098,166,3538)) OR (p.article='522600' AND p.brand_id IN (729)) OR (p.article='90193357' AND p.brand_id IN (729)) OR (p.article='90199357' AND p.brand_id IN (729)) OR (p.article='90335899' AND p.brand_id IN (729)) OR (p.article='90369711' AND p.brand_id IN (729)) OR (p.article='91106936' AND p.brand_id IN (729)) OR (p.article='522568' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='522603' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='90235948' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='90235948B' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='90369708' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='90373856' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='90373923' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='90538629' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='90538698' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='522641' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='94581103' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='P90235948' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='P94581103' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='1064280' AND p.brand_id IN (39540,545,3525,29569,1486,2771,1223,30253,30600,1864,2770,33241,1196,1262,4929)) OR (p.article='1094178' AND p.brand_id IN (39540,545,3525,29569,1486,2771,1223,30253,30600,1864,2770,33241,1196,1262,4929)) OR (p.article='1140391' AND p.brand_id IN (39540,545,3525,29569,1486,2771,1223,30253,30600,1864,2770,33241,1196,1262,4929)) OR (p.article='1201199' AND p.brand_id IN (39540,545,3525,29569,1486,2771,1223,30253,30600,1864,2770,33241,1196,1262,4929)) OR (p.article='1206909' AND p.brand_id IN (39540,545,3525,29569,1486,2771,1223,30253,30600,1864,2770,33241,1196,1262,4929)) OR (p.article='1209852' AND p.brand_id IN (39540,545,3525,29569,1486,2771,1223,30253,30600,1864,2770,33241,1196,1262,4929)) OR (p.article='1211024' AND p.brand_id IN (39540,545,3525,29569,1486,2771,1223,30253,30600,1864,2770,33241,1196,1262,4929)) OR (p.article='1220462' AND p.brand_id IN (39540,545,3525,29569,1486,2771,1223,30253,30600,1864,2770,33241,1196,1262,4929)) OR (p.article='1226733' AND p.brand_id IN (39540,545,3525,29569,1486,2771,1223,30253,30600,1864,2770,33241,1196,1262,4929)) OR (p.article='1232018' AND p.brand_id IN (39540,545,3525,29569,1486,2771,1223,30253,30600,1864,2770,33241,1196,1262,4929)) OR (p.article='1253162' AND p.brand_id IN (39540,545,3525,29569,1486,2771,1223,30253,30600,1864,2770,33241,1196,1262,4929)) OR (p.article='1335046' AND p.brand_id IN (39540,545,3525,29569,1486,2771,1223,30253,30600,1864,2770,33241,1196,1262,4929)) OR (p.article='1343668' AND p.brand_id IN (39540,545,3525,29569,1486,2771,1223,30253,30600,1864,2770,33241,1196,1262,4929)) OR (p.article='1445646' AND p.brand_id IN (39540,545,3525,29569,1486,2771,1223,30253,30600,1864,2770,33241,1196,1262,4929)) OR (p.article='1446193' AND p.brand_id IN (39540,545,3525,29569,1486,2771,1223,30253,30600,1864,2770,33241,1196,1262,4929)) OR (p.article='1502612' AND p.brand_id IN (39540,545,3525,29569,1486,2771,1223,30253,30600,1864,2770,33241,1196,1262,4929)) OR (p.article='2M512A635AA' AND p.brand_id IN (39540,545,3525,29569,1486,2771,1223,30253,30600,1864,2770,33241,1196,1262,4929)) OR (p.article='2S612A603AE' AND p.brand_id IN (39540,545,3525,29569,1486,2771,1223,30253,30600,1864,2770,33241,1196,1262,4929)) OR (p.article='2S612A603AF' AND p.brand_id IN (39540,545,3525,29569,1486,2771,1223,30253,30600,1864,2770,33241,1196,1262,4929)) OR (p.article='2S612A603AG' AND p.brand_id IN (39540,545,3525,29569,1486,2771,1223,30253,30600,1864,2770,33241,1196,1262,4929)) OR (p.article='2S612A603AH' AND p.brand_id IN (39540,545,3525,29569,1486,2771,1223,30253,30600,1864,2770,33241,1196,1262,4929)) OR (p.article='3S412A635AA' AND p.brand_id IN (39540,545,3525,29569,1486,2771,1223,30253,30600,1864,2770,33241,1196,1262,4929)) OR (p.article='3S412A635AB' AND p.brand_id IN (39540,545,3525,29569,1486,2771,1223,30253,30600,1864,2770,33241,1196,1262,4929)) OR (p.article='3S412A635AC' AND p.brand_id IN (39540,545,3525,29569,1486,2771,1223,30253,30600,1864,2770,33241,1196,1262,4929)) OR (p.article='6N112A603AA' AND p.brand_id IN (39540,545,3525,29569,1486,2771,1223,30253,30600,1864,2770,33241,1196,1262,4929)) OR (p.article='6N112A603AB' AND p.brand_id IN (39540,545,3525,29569,1486,2771,1223,30253,30600,1864,2770,33241,1196,1262,4929)) OR (p.article='98AG2A635AC' AND p.brand_id IN (39540,545,3525,29569,1486,2771,1223,30253,30600,1864,2770,33241,1196,1262,4929)) OR (p.article='98AG2A635AD' AND p.brand_id IN (39540,545,3525,29569,1486,2771,1223,30253,30600,1864,2770,33241,1196,1262,4929)) OR (p.article='98AG2A635AE' AND p.brand_id IN (39540,545,3525,29569,1486,2771,1223,30253,30600,1864,2770,33241,1196,1262,4929)) OR (p.article='98AG2A635AF' AND p.brand_id IN (39540,545,3525,29569,1486,2771,1223,30253,30600,1864,2770,33241,1196,1262,4929)) OR (p.article='98AG2A635AG' AND p.brand_id IN (39540,545,3525,29569,1486,2771,1223,30253,30600,1864,2770,33241,1196,1262,4929)) OR (p.article='90369711' AND p.brand_id IN (777,30840,33472)) OR (p.article='41007785' AND p.brand_id IN (778,29599,29775)) OR (p.article='8166702' AND p.brand_id IN (778,29599,29775)) OR (p.article='8766702' AND p.brand_id IN (778,29599,29775)) OR (p.article='90235948' 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='90235948B' 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='8166702' AND p.brand_id IN (793)) OR (p.article='814050121' AND p.brand_id IN (796,29589,33236)) OR (p.article='BP4K44150A' AND p.brand_id IN (796,29589,33236)) OR (p.article='BP4K44150B' AND p.brand_id IN (796,29589,33236)) OR (p.article='BP4K44150C' AND p.brand_id IN (796,29589,33236)) OR (p.article='BP4K44150D' AND p.brand_id IN (796,29589,33236)) OR (p.article='BP4K44410A' AND p.brand_id IN (796,29589,33236)) OR (p.article='BP4K44410C' AND p.brand_id IN (796,29589,33236)) OR (p.article='BP4K44410E' AND p.brand_id IN (796,29589,33236)) OR (p.article='BP4K44410F' AND p.brand_id IN (796,29589,33236)) OR (p.article='BP4K44410G' AND p.brand_id IN (796,29589,33236)) OR (p.article='BP4K44410H' AND p.brand_id IN (796,29589,33236)) OR (p.article='BP4K44410J' AND p.brand_id IN (796,29589,33236)) OR (p.article='BP4K44410K' AND p.brand_id IN (796,29589,33236)) OR (p.article='BP4K44410L' AND p.brand_id IN (796,29589,33236)) OR (p.article='BP4K44420A' AND p.brand_id IN (796,29589,33236)) OR (p.article='BP4K44420C' AND p.brand_id IN (796,29589,33236)) OR (p.article='BP4K44420E' AND p.brand_id IN (796,29589,33236)) OR (p.article='BP4K44420F' AND p.brand_id IN (796,29589,33236)) OR (p.article='BP4K44420G' AND p.brand_id IN (796,29589,33236)) OR (p.article='BP4K44420H' AND p.brand_id IN (796,29589,33236)) OR (p.article='BP4K44420L' AND p.brand_id IN (796,29589,33236)) OR (p.article='BR5S44200' AND p.brand_id IN (796,29589,33236)) OR (p.article='BS3E44200B' AND p.brand_id IN (796,29589,33236)) OR (p.article='BS3E44200C' AND p.brand_id IN (796,29589,33236)) OR (p.article='BS3E44200D' AND p.brand_id IN (796,29589,33236)) OR (p.article='BS3E44200E' AND p.brand_id IN (796,29589,33236)) OR (p.article='BS3E44200F' AND p.brand_id IN (796,29589,33236)) OR (p.article='BS3E44200G' AND p.brand_id IN (796,29589,33236)) OR (p.article='BS3E44200H' AND p.brand_id IN (796,29589,33236)) OR (p.article='BS3E44200J' AND p.brand_id IN (796,29589,33236)) OR (p.article='BS3E44200K' AND p.brand_id IN (796,29589,33236)) OR (p.article='BS3E44420J' AND p.brand_id IN (796,29589,33236)) OR (p.article='D65144400D' AND p.brand_id IN (796,29589,33236)) OR (p.article='D65144400E' AND p.brand_id IN (796,29589,33236)) OR (p.article='D65144400G' AND p.brand_id IN (796,29589,33236)) OR (p.article='D65144400H' AND p.brand_id IN (796,29589,33236)) OR (p.article='D65144400J' AND p.brand_id IN (796,29589,33236)) OR (p.article='0522560' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='0522561' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='0522568' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='0522579' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='0522580' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='0522600' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='0522603' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='0522640' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='0522641' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='13172730' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='522543' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='522547' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='522556' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='522560' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='522561' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='522579' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='522580' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='522600' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='522640' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='90141095' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='90184271' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='90193357' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='90193358' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='90289824' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='90335899' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='90335900' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='90369711' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='90373899' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='91025077' AND p.brand_id IN (33393,38074,29174,5687,6651,4993,24296,38000,38001,38075,33872,1189,809,32015,29173,29176,30166,874,6614,33387,33396,3520,29159,37444,37445,942,5675,1190,5166,29175,25009,29605,27066,39632)) OR (p.article='522580' AND p.brand_id IN (33856,33855,30487,837,30489,33415,5650,29586,33240,21094,30488,30601,1315)) OR (p.article='90335899' AND p.brand_id IN (33856,33855,30487,837,30489,33415,5650,29586,33240,21094,30488,30601,1315)) OR (p.article='90369711' AND p.brand_id IN (33856,33855,30487,837,30489,33415,5650,29586,33240,21094,30488,30601,1315)) OR (p.article='814024127' AND p.brand_id IN (3990,839,30132)) OR (p.article='814024142' AND p.brand_id IN (3990,839,30132)) OR (p.article='522547' AND p.brand_id IN (845)) OR (p.article='522560' AND p.brand_id IN (845)) OR (p.article='522561' AND p.brand_id IN (845)) OR (p.article='522568' AND p.brand_id IN (845)) OR (p.article='522579' AND p.brand_id IN (845)) OR (p.article='522580' AND p.brand_id IN (845)) OR (p.article='522600' AND p.brand_id IN (845)) OR (p.article='522603' AND p.brand_id IN (845)) OR (p.article='522640' AND p.brand_id IN (845)) OR (p.article='522641' AND p.brand_id IN (845)) OR (p.article='90125077' AND p.brand_id IN (845)) OR (p.article='90141095' AND p.brand_id IN (845)) OR (p.article='90184271' AND p.brand_id IN (845)) OR (p.article='90193357' AND p.brand_id IN (845)) OR (p.article='90193358' AND p.brand_id IN (845)) OR (p.article='90199357' AND p.brand_id IN (845)) OR (p.article='90235948' AND p.brand_id IN (845)) OR (p.article='90289824' AND p.brand_id IN (845)) OR (p.article='90335899' AND p.brand_id IN (845)) OR (p.article='90335900' AND p.brand_id IN (845)) OR (p.article='90369708' AND p.brand_id IN (845)) OR (p.article='90369711' AND p.brand_id IN (845)) OR (p.article='90373856' AND p.brand_id IN (845)) OR (p.article='90373899' AND p.brand_id IN (845)) OR (p.article='90373923' AND p.brand_id IN (845)) OR (p.article='90533338698' AND p.brand_id IN (845)) OR (p.article='90538629' AND p.brand_id IN (845)) OR (p.article='90538698' AND p.brand_id IN (845)) OR (p.article='91025077' AND p.brand_id IN (845)) OR (p.article='93538698' AND p.brand_id IN (845)) OR (p.article='522568' AND p.brand_id IN (851,29571,29607,33235)) OR (p.article='01140575' AND p.brand_id IN (3121,29968)) OR (p.article='01140576' AND p.brand_id IN (3121,29968)) OR (p.article='01140576C' AND p.brand_id IN (3121,29968)) OR (p.article='01300022' AND p.brand_id IN (3121,29968)) OR (p.article='01300033' AND p.brand_id IN (3121,29968)) OR (p.article='01300046' AND p.brand_id IN (3121,29968)) OR (p.article='01300047' AND p.brand_id IN (3121,29968)) OR (p.article='01360621' AND p.brand_id IN (3121,29968)) OR (p.article='01360650' AND p.brand_id IN (3121,29968)) OR (p.article='01360663' AND p.brand_id IN (3121,29968)) OR (p.article='01360666' AND p.brand_id IN (3121,29968)) OR (p.article='01360730' AND p.brand_id IN (3121,29968)) OR (p.article='04450' AND p.brand_id IN (90,31317,1248,5434)) OR (p.article='04666' AND p.brand_id IN (90,31317,1248,5434)) OR (p.article='088059' AND p.brand_id IN (2953,586)) OR (p.article='088060' AND p.brand_id IN (2953,586)) OR (p.article='10591' AND p.brand_id IN (517)) OR (p.article='10628' AND p.brand_id IN (468)) OR (p.article='115453' AND p.brand_id IN (517)) OR (p.article='115453' AND p.brand_id IN (86)) OR (p.article='115454' AND p.brand_id IN (517)) OR (p.article='115454' AND p.brand_id IN (86)) OR (p.article='115764' AND p.brand_id IN (517)) OR (p.article='115764' AND p.brand_id IN (86)) OR (p.article='11585' AND p.brand_id IN (517)) OR (p.article='11585' AND p.brand_id IN (86)) OR (p.article='115854' AND p.brand_id IN (517)) OR (p.article='115854' AND p.brand_id IN (86)) OR (p.article='120004010' AND p.brand_id IN (252,32421,4949,29129,7790,7030,33780)) OR (p.article='120074210' AND p.brand_id IN (252,32421,4949,29129,7790,7030,33780)) OR (p.article='120076010' AND p.brand_id IN (252,32421,4949,29129,7790,7030,33780)) OR (p.article='120076710' AND p.brand_id IN (252,32421,4949,29129,7790,7030,33780)) OR (p.article='124C0056' AND p.brand_id IN (6693)) OR (p.article='124C0091' AND p.brand_id IN (6693)) OR (p.article='124C0304' AND p.brand_id IN (6693)) OR (p.article='1270301500' AND p.brand_id IN (39320,29441,28665,4953,2607,6916,211)) OR (p.article='1270302600' AND p.brand_id IN (39320,29441,28665,4953,2607,6916,211)) OR (p.article='1302201' AND p.brand_id IN (5119)) OR (p.article='1302211' AND p.brand_id IN (5119)) OR (p.article='131000324' AND p.brand_id IN (205)) OR (p.article='131000325' AND p.brand_id IN (205)) OR (p.article='131000409' AND p.brand_id IN (205)) OR (p.article='1310324' AND p.brand_id IN (349)) OR (p.article='1310325' AND p.brand_id IN (349)) OR (p.article='13103307' AND p.brand_id IN (205)) OR (p.article='13103308' AND p.brand_id IN (205)) OR (p.article='13103330' AND p.brand_id IN (205)) OR (p.article='13103332' AND p.brand_id IN (205)) OR (p.article='1310409' AND p.brand_id IN (349)) OR (p.article='1310WW10' AND p.brand_id IN (205)) OR (p.article='131307' AND p.brand_id IN (349)) OR (p.article='131308' AND p.brand_id IN (349)) OR (p.article='131330' AND p.brand_id IN (349)) OR (p.article='131332' AND p.brand_id IN (349)) OR (p.article='131W10' AND p.brand_id IN (349)) OR (p.article='150166' AND p.brand_id IN (3496)) OR (p.article='1570303100' AND p.brand_id IN (39320,29441,28665,4953,2607,6916,211)) OR (p.article='1570304200' AND p.brand_id IN (39320,29441,28665,4953,2607,6916,211)) OR (p.article='1637154880' AND p.brand_id IN (39295,4518,5115)) OR (p.article='170510' AND p.brand_id IN (517)) OR (p.article='170684' AND p.brand_id IN (517)) OR (p.article='170684' AND p.brand_id IN (86)) OR (p.article='170685' AND p.brand_id IN (517)) OR (p.article='170686' AND p.brand_id IN (517)) OR (p.article='170686' AND p.brand_id IN (86)) OR (p.article='17146' AND p.brand_id IN (468)) OR (p.article='1987477129' AND p.brand_id IN (5442,7131,3201,5010,3617,3114,28)) OR (p.article='1987477136' AND p.brand_id IN (5442,7131,3201,5010,3617,3114,28)) OR (p.article='1987477732' AND p.brand_id IN (5442,7131,3201,5010,3617,3114,28)) OR (p.article='1987477906' AND p.brand_id IN (5442,7131,3201,5010,3617,3114,28)) OR (p.article='1987482057' AND p.brand_id IN (5442,7131,3201,5010,3617,3114,28)) OR (p.article='1987482058' AND p.brand_id IN (5442,7131,3201,5010,3617,3114,28)) OR (p.article='1987482059' AND p.brand_id IN (5442,7131,3201,5010,3617,3114,28)) OR (p.article='1987482138' AND p.brand_id IN (5442,7131,3201,5010,3617,3114,28)) OR (p.article='1987482421' AND p.brand_id IN (5442,7131,3201,5010,3617,3114,28)) OR (p.article='1987482422' AND p.brand_id IN (5442,7131,3201,5010,3617,3114,28)) OR (p.article='1987482851' AND p.brand_id IN (5442,7131,3201,5010,3617,3114,28)) OR (p.article='1MA001' AND p.brand_id IN (517)) OR (p.article='200864' AND p.brand_id IN (37605,6695,29104,4901,6490,5433,234)) OR (p.article='200875' AND p.brand_id IN (37605,6695,29104,4901,6490,5433,234)) OR (p.article='20609004S' AND p.brand_id IN (39143,5579,29506,29792,491)) OR (p.article='20609006S' AND p.brand_id IN (39143,5579,29506,29792,491)) OR (p.article='21592' AND p.brand_id IN (37563,6578,30136,30098,248,3301,27428,27927)) OR (p.article='21593' AND p.brand_id IN (37563,6578,30136,30098,248,3301,27428,27927)) OR (p.article='220273' AND p.brand_id IN (5119)) OR (p.article='220274' AND p.brand_id IN (5119)) OR (p.article='220281' AND p.brand_id IN (5119)) OR (p.article='220294' AND p.brand_id IN (5119)) OR (p.article='220297' AND p.brand_id IN (5119)) OR (p.article='22852' AND p.brand_id IN (37563,6578,30136,30098,248,3301,27428,27927)) OR (p.article='24372706532' AND p.brand_id IN (4)) OR (p.article='24372706632' AND p.brand_id IN (4)) OR (p.article='24372707302' AND p.brand_id IN (4)) OR (p.article='24372707352' AND p.brand_id IN (4)) OR (p.article='24372718132' AND p.brand_id IN (4)) OR (p.article='24372718142' AND p.brand_id IN (4)) OR (p.article='24372718152' AND p.brand_id IN (4)) OR (p.article='24372718292' AND p.brand_id IN (4)) OR (p.article='25SKV926' AND p.brand_id IN (39241,39242,39240,39243,33864,32194,22596,6400,538)) OR (p.article='25SKV936' AND p.brand_id IN (39241,39242,39240,39243,33864,32194,22596,6400,538)) OR (p.article='260137' AND p.brand_id IN (3496)) OR (p.article='260138' AND p.brand_id IN (3496)) OR (p.article='26234' AND p.brand_id IN (37563,6578,30136,30098,248,3301,27428,27927)) OR (p.article='26374' AND p.brand_id IN (37563,6578,30136,30098,248,3301,27428,27927)) OR (p.article='26919' AND p.brand_id IN (37563,6578,30136,30098,248,3301,27428,27927)) OR (p.article='26920' AND p.brand_id IN (37563,6578,30136,30098,248,3301,27428,27927)) OR (p.article='26SKV056' AND p.brand_id IN (39241,39242,39240,39243,33864,32194,22596,6400,538)) OR (p.article='26SKV166' AND p.brand_id IN (39241,39242,39240,39243,33864,32194,22596,6400,538)) OR (p.article='27970' AND p.brand_id IN (468)) OR (p.article='29007' AND p.brand_id IN (468)) OR (p.article='290HC00063' AND p.brand_id IN (29911)) OR (p.article='290HC00297' AND p.brand_id IN (29911)) OR (p.article='290HC00568' AND p.brand_id IN (29911)) OR (p.article='290HC00873' AND p.brand_id IN (29911)) OR (p.article='290HC00924' AND p.brand_id IN (29911)) OR (p.article='290HC01957' AND p.brand_id IN (29911)) OR (p.article='290HC01959' AND p.brand_id IN (29911)) OR (p.article='290HC02115' AND p.brand_id IN (29911)) OR (p.article='290HC02116' AND p.brand_id IN (29911)) OR (p.article='29275' AND p.brand_id IN (468)) OR (p.article='29295' AND p.brand_id IN (37563,6578,30136,30098,248,3301,27428,27927)) OR (p.article='2998509SX' AND p.brand_id IN (437)) OR (p.article='2998550SX' AND p.brand_id IN (437)) OR (p.article='2998562SX' AND p.brand_id IN (437)) OR (p.article='2998565SX' AND p.brand_id IN (437)) OR (p.article='2998599SX' AND p.brand_id IN (437)) OR (p.article='2998711SX' AND p.brand_id IN (437)) OR (p.article='2998736SX' AND p.brand_id IN (437)) OR (p.article='302063' AND p.brand_id IN (37605,6695,29104,4901,6490,5433,234)) OR (p.article='302064' AND p.brand_id IN (37605,6695,29104,4901,6490,5433,234)) OR (p.article='30645' AND p.brand_id IN (432,6767,6766,6036,15100)) OR (p.article='320047' AND p.brand_id IN (304)) OR (p.article='320061' AND p.brand_id IN (304)) OR (p.article='320089' AND p.brand_id IN (304)) OR (p.article='320112' AND p.brand_id IN (3496)) OR (p.article='320113' AND p.brand_id IN (3496)) OR (p.article='320115' AND p.brand_id IN (3496)) OR (p.article='320116' AND p.brand_id IN (3496)) OR (p.article='320118' AND p.brand_id IN (3496)) OR (p.article='320447' AND p.brand_id IN (304)) OR (p.article='320691' AND p.brand_id IN (304)) OR (p.article='330220' AND p.brand_id IN (5119)) OR (p.article='330224' AND p.brand_id IN (5119)) OR (p.article='3302261' AND p.brand_id IN (5119)) OR (p.article='330231' AND p.brand_id IN (5119)) OR (p.article='330257' AND p.brand_id IN (5119)) OR (p.article='40904666' AND p.brand_id IN (37620,123)) OR (p.article='431230J' AND p.brand_id IN (29876,37510,29550,681,32359,32364,45,46)) OR (p.article='432103J' AND p.brand_id IN (29876,37510,29550,681,32359,32364,45,46)) OR (p.article='432678J' AND p.brand_id IN (29876,37510,29550,681,32359,32364,45,46)) OR (p.article='433067J' AND p.brand_id IN (29876,37510,29550,681,32359,32364,45,46)) OR (p.article='450650' AND p.brand_id IN (20974)) OR (p.article='480022' AND p.brand_id IN (2953,586)) OR (p.article='487023' AND p.brand_id IN (2953,586)) OR (p.article='489108' AND p.brand_id IN (2953,586)) OR (p.article='49787' AND p.brand_id IN (468)) OR (p.article='49838' AND p.brand_id IN (468)) OR (p.article='49MZ000' AND p.brand_id IN (29894,32706,4157,4156,37357)) OR (p.article='49MZ001' AND p.brand_id IN (29894,32706,4157,4156,37357)) OR (p.article='50095' AND p.brand_id IN (468)) OR (p.article='50271' AND p.brand_id IN (468)) OR (p.article='50286' AND p.brand_id IN (468)) OR (p.article='5296' AND p.brand_id IN (23334,639)) OR (p.article='5297' AND p.brand_id IN (23334,639)) OR (p.article='5298' AND p.brand_id IN (23334,639)) OR (p.article='554218' AND p.brand_id IN (564)) OR (p.article='554220' AND p.brand_id IN (564)) OR (p.article='554370' AND p.brand_id IN (564)) OR (p.article='5550' AND p.brand_id IN (109)) OR (p.article='555005' AND p.brand_id IN (564)) OR (p.article='5551' AND p.brand_id IN (109)) OR (p.article='5617' AND p.brand_id IN (109)) OR (p.article='561795' AND p.brand_id IN (673,4055)) OR (p.article='561895' AND p.brand_id IN (673,4055)) OR (p.article='5687' AND p.brand_id IN (109)) OR (p.article='601820' AND p.brand_id IN (673,4055)) OR (p.article='601864' AND p.brand_id IN (673,4055)) OR (p.article='603230' AND p.brand_id IN (564)) OR (p.article='603293' AND p.brand_id IN (564)) OR (p.article='653040' AND p.brand_id IN (564)) OR (p.article='7142' AND p.brand_id IN (23334,639)) OR (p.article='7354' AND p.brand_id IN (23334,639)) OR (p.article='7356' AND p.brand_id IN (23334,639)) OR (p.article='73880' AND p.brand_id IN (432,6767,6766,6036,15100)) OR (p.article='7404' AND p.brand_id IN (23334,639)) OR (p.article='7436' AND p.brand_id IN (23334,639)) OR (p.article='7445' AND p.brand_id IN (23334,639)) OR (p.article='7524' AND p.brand_id IN (23334,639)) OR (p.article='761414' AND p.brand_id IN (2953,586)) OR (p.article='761770' AND p.brand_id IN (2953,586)) OR (p.article='761771' AND p.brand_id IN (2953,586)) OR (p.article='761957' AND p.brand_id IN (2953,586)) OR (p.article='761960' AND p.brand_id IN (2953,586)) OR (p.article='761974' AND p.brand_id IN (2953,586)) OR (p.article='761996' AND p.brand_id IN (2953,586)) OR (p.article='763900' AND p.brand_id IN (2953,586)) OR (p.article='763905' AND p.brand_id IN (2953,586)) OR (p.article='800130' AND p.brand_id IN (673,4055)) OR (p.article='801012' AND p.brand_id IN (673,4055)) OR (p.article='801026' AND p.brand_id IN (673,4055)) OR (p.article='801028' AND p.brand_id IN (673,4055)) OR (p.article='801032' AND p.brand_id IN (673,4055)) OR (p.article='80416' AND p.brand_id IN (457,2974,3711)) OR (p.article='814016186' AND p.brand_id IN (94)) OR (p.article='814016187' AND p.brand_id IN (94)) OR (p.article='814024109' AND p.brand_id IN (94)) OR (p.article='814024127' AND p.brand_id IN (94)) OR (p.article='814024140' AND p.brand_id IN (94)) OR (p.article='814024144' AND p.brand_id IN (94)) OR (p.article='814024196' AND p.brand_id IN (94)) OR (p.article='81816' AND p.brand_id IN (457,2974,3711)) OR (p.article='81817' AND p.brand_id IN (457,2974,3711)) OR (p.article='82224' AND p.brand_id IN (457,2974,3711)) OR (p.article='82225' AND p.brand_id IN (457,2974,3711)) OR (p.article='82458' AND p.brand_id IN (457,2974,3711)) OR (p.article='82461' AND p.brand_id IN (457,2974,3711)) OR (p.article='82477' AND p.brand_id IN (457,2974,3711)) OR (p.article='82483' AND p.brand_id IN (457,2974,3711)) OR (p.article='82498' AND p.brand_id IN (457,2974,3711)) OR (p.article='82507' AND p.brand_id IN (457,2974,3711)) OR (p.article='84675' AND p.brand_id IN (457,2974,3711)) OR (p.article='84681' AND p.brand_id IN (457,2974,3711)) OR (p.article='8AS355664461' AND p.brand_id IN (12,21534,33779,5799,2003,3635,31097,33228,31994,37464,37465,37466,49,2548,91,1129,4082,3652,3636,3786,3862,5463,5515,5001,5137,3,665,447)) OR (p.article='8AS355664471' AND p.brand_id IN (12,21534,33779,5799,2003,3635,31097,33228,31994,37464,37465,37466,49,2548,91,1129,4082,3652,3636,3786,3862,5463,5515,5001,5137,3,665,447)) OR (p.article='8AS355667171' AND p.brand_id IN (12,21534,33779,5799,2003,3635,31097,33228,31994,37464,37465,37466,49,2548,91,1129,4082,3652,3636,3786,3862,5463,5515,5001,5137,3,665,447)) OR (p.article='8AS355667181' AND p.brand_id IN (12,21534,33779,5799,2003,3635,31097,33228,31994,37464,37465,37466,49,2548,91,1129,4082,3652,3636,3786,3862,5463,5515,5001,5137,3,665,447)) OR (p.article='8AS355667611' AND p.brand_id IN (12,21534,33779,5799,2003,3635,31097,33228,31994,37464,37465,37466,49,2548,91,1129,4082,3652,3636,3786,3862,5463,5515,5001,5137,3,665,447)) OR (p.article='8AS355667631' AND p.brand_id IN (12,21534,33779,5799,2003,3635,31097,33228,31994,37464,37465,37466,49,2548,91,1129,4082,3652,3636,3786,3862,5463,5515,5001,5137,3,665,447)) OR (p.article='8AS355667981' AND p.brand_id IN (12,21534,33779,5799,2003,3635,31097,33228,31994,37464,37465,37466,49,2548,91,1129,4082,3652,3636,3786,3862,5463,5515,5001,5137,3,665,447)) OR (p.article='8AS355669321' AND p.brand_id IN (12,21534,33779,5799,2003,3635,31097,33228,31994,37464,37465,37466,49,2548,91,1129,4082,3652,3636,3786,3862,5463,5515,5001,5137,3,665,447)) OR (p.article='9025116' AND p.brand_id IN (106)) OR (p.article='9025117' AND p.brand_id IN (106)) OR (p.article='903277' AND p.brand_id IN (106)) OR (p.article='903279' AND p.brand_id IN (106)) OR (p.article='903289' AND p.brand_id IN (106)) OR (p.article='9036143' AND p.brand_id IN (106)) OR (p.article='903652' AND p.brand_id IN (106)) OR (p.article='903658' AND p.brand_id IN (106)) OR (p.article='903664' AND p.brand_id IN (106)) OR (p.article='903665' AND p.brand_id IN (106)) OR (p.article='903675' AND p.brand_id IN (106)) OR (p.article='911820' AND p.brand_id IN (434)) OR (p.article='911849' AND p.brand_id IN (434)) OR (p.article='912209' AND p.brand_id IN (434)) OR (p.article='912210' AND p.brand_id IN (434)) OR (p.article='912211' AND p.brand_id IN (434)) OR (p.article='912820' AND p.brand_id IN (434)) OR (p.article='9210591' AND p.brand_id IN (517)) OR (p.article='92115453' AND p.brand_id IN (517)) OR (p.article='92115454' AND p.brand_id IN (517)) OR (p.article='92115764' AND p.brand_id IN (517)) OR (p.article='9211585' AND p.brand_id IN (517)) OR (p.article='92115854' AND p.brand_id IN (517)) OR (p.article='92170510' AND p.brand_id IN (517)) OR (p.article='92170684' AND p.brand_id IN (517)) OR (p.article='92170685' AND p.brand_id IN (517)) OR (p.article='92170686' AND p.brand_id IN (517)) OR (p.article='921MA001' AND p.brand_id IN (517)) OR (p.article='99904450' AND p.brand_id IN (37620,123)) OR (p.article='999143' AND p.brand_id IN (434)) OR (p.article='999161' AND p.brand_id IN (434)) OR (p.article='999172' AND p.brand_id IN (434)) OR (p.article='ADF124602C' AND p.brand_id IN (268,2924,7586)) OR (p.article='ADG04647' AND p.brand_id IN (268,2924,7586)) OR (p.article='ADM546123' AND p.brand_id IN (268,2924,7586)) OR (p.article='ADM546124' AND p.brand_id IN (268,2924,7586)) OR (p.article='ADM546125' AND p.brand_id IN (268,2924,7586)) OR (p.article='ADM546128' AND p.brand_id IN (268,2924,7586)) OR (p.article='ADM546129' AND p.brand_id IN (268,2924,7586)) OR (p.article='ADM546130' AND p.brand_id IN (268,2924,7586)) OR (p.article='ADM546133' AND p.brand_id IN (268,2924,7586)) OR (p.article='ASH31124' AND p.brand_id IN (28553,597)) OR (p.article='ASH31601' AND p.brand_id IN (28553,597)) OR (p.article='ASH31718' AND p.brand_id IN (28553,597)) OR (p.article='ASH31719' AND p.brand_id IN (28553,597)) OR (p.article='BC0324' AND p.brand_id IN (2205,128,4966)) OR (p.article='BC0325' AND p.brand_id IN (2205,128,4966)) OR (p.article='BC0409' AND p.brand_id IN (2205,128,4966)) OR (p.article='BC2157' AND p.brand_id IN (33803,37442,2313,5640,54)) OR (p.article='BC2418' AND p.brand_id IN (33803,37442,2313,5640,54)) OR (p.article='BC307' AND p.brand_id IN (2205,128,4966)) OR (p.article='BC308' AND p.brand_id IN (2205,128,4966)) OR (p.article='BC330' AND p.brand_id IN (2205,128,4966)) OR (p.article='BC332' AND p.brand_id IN (2205,128,4966)) OR (p.article='BC3410' AND p.brand_id IN (33803,37442,2313,5640,54)) OR (p.article='BC3619' AND p.brand_id IN (33803,37442,2313,5640,54)) OR (p.article='BC3625' AND p.brand_id IN (33803,37442,2313,5640,54)) OR (p.article='BC3637' AND p.brand_id IN (33803,37442,2313,5640,54)) OR (p.article='BC4064' AND p.brand_id IN (33803,37442,2313,5640,54)) OR (p.article='BC4066' AND p.brand_id IN (33803,37442,2313,5640,54)) OR (p.article='BC4072' AND p.brand_id IN (33803,37442,2313,5640,54)) OR (p.article='BCW10' AND p.brand_id IN (2205,128,4966)) OR (p.article='BHC4505' AND p.brand_id IN (162,6386)) OR (p.article='BHC4509' AND p.brand_id IN (162,6386)) OR (p.article='BHC4569' AND p.brand_id IN (162,6386)) OR (p.article='BHC4570' AND p.brand_id IN (162,6386)) OR (p.article='BHC4682' AND p.brand_id IN (162,6386)) OR (p.article='BKB1035' AND p.brand_id IN (346,5019,35286,2002)) OR (p.article='BKB1036' AND p.brand_id IN (346,5019,35286,2002)) OR (p.article='BKB2319' AND p.brand_id IN (346,5019,35286,2002)) OR (p.article='BKB2503' AND p.brand_id IN (346,5019,35286,2002)) OR (p.article='BKB2873' AND p.brand_id IN (346,5019,35286,2002)) OR (p.article='BKB2874' AND p.brand_id IN (346,5019,35286,2002)) OR (p.article='BKB2875' AND p.brand_id IN (346,5019,35286,2002)) OR (p.article='BKB3215' AND p.brand_id IN (346,5019,35286,2002)) OR (p.article='BZ1030' AND p.brand_id IN (522)) OR (p.article='BZ1039' AND p.brand_id IN (522)) OR (p.article='C0249B' AND p.brand_id IN (37569,37570,37571,33821,33822,5056,38025,1088,222,605,27409,159,30960)) OR (p.article='C0249B' AND p.brand_id IN (2989,23863,2789)) OR (p.article='C0250B' AND p.brand_id IN (37569,37570,37571,33821,33822,5056,38025,1088,222,605,27409,159,30960)) OR (p.article='C0250B' AND p.brand_id IN (2989,23863,2789)) OR (p.article='C0332B' AND p.brand_id IN (37569,37570,37571,33821,33822,5056,38025,1088,222,605,27409,159,30960)) OR (p.article='C0332B' AND p.brand_id IN (2989,23863,2789)) OR (p.article='C0372B' AND p.brand_id IN (37569,37570,37571,33821,33822,5056,38025,1088,222,605,27409,159,30960)) OR (p.article='C0372B' AND p.brand_id IN (2989,23863,2789)) OR (p.article='C0373B' AND p.brand_id IN (37569,37570,37571,33821,33822,5056,38025,1088,222,605,27409,159,30960)) OR (p.article='C0373B' AND p.brand_id IN (2989,23863,2789)) OR (p.article='C0534B' AND p.brand_id IN (37569,37570,37571,33821,33822,5056,38025,1088,222,605,27409,159,30960)) OR (p.article='C0534B' AND p.brand_id IN (2989,23863,2789)) OR (p.article='C0549B' AND p.brand_id IN (37569,37570,37571,33821,33822,5056,38025,1088,222,605,27409,159,30960)) OR (p.article='C0549B' AND p.brand_id IN (2989,23863,2789)) OR (p.article='C0569B' AND p.brand_id IN (37569,37570,37571,33821,33822,5056,38025,1088,222,605,27409,159,30960)) OR (p.article='C0569B' AND p.brand_id IN (2989,23863,2789)) OR (p.article='C1343B' AND p.brand_id IN (37569,37570,37571,33821,33822,5056,38025,1088,222,605,27409,159,30960)) OR (p.article='C1343B' AND p.brand_id IN (2989,23863,2789)) OR (p.article='C1710B' AND p.brand_id IN (37569,37570,37571,33821,33822,5056,38025,1088,222,605,27409,159,30960)) OR (p.article='C1710B' AND p.brand_id IN (2989,23863,2789)) OR (p.article='C1794B' AND p.brand_id IN (37569,37570,37571,33821,33822,5056,38025,1088,222,605,27409,159,30960)) OR (p.article='C1794B' AND p.brand_id IN (2989,23863,2789)) OR (p.article='C70007' AND p.brand_id IN (474)) OR (p.article='C73077' AND p.brand_id IN (474)) OR (p.article='C73103' AND p.brand_id IN (474)) OR (p.article='C73104' AND p.brand_id IN (474)) OR (p.article='CAB1136' AND p.brand_id IN (2526,636)) OR (p.article='CAB1137' AND p.brand_id IN (2526,636)) OR (p.article='CAB1353' AND p.brand_id IN (2526,636)) OR (p.article='CAB1462' AND p.brand_id IN (2526,636)) OR (p.article='EI000014' AND p.brand_id IN (4910)) OR (p.article='FBK1017' AND p.brand_id IN (214)) OR (p.article='FBK1080' AND p.brand_id IN (214)) OR (p.article='FBS10047' AND p.brand_id IN (12186,50)) OR (p.article='FBS10051' AND p.brand_id IN (12186,50)) OR (p.article='FBS15014' AND p.brand_id IN (12186,50)) OR (p.article='FBS17018' AND p.brand_id IN (12186,50)) OR (p.article='FHB431230' AND p.brand_id IN (3657,37587,59)) OR (p.article='FHB432103' AND p.brand_id IN (3657,37587,59)) OR (p.article='FHB432678' AND p.brand_id IN (3657,37587,59)) OR (p.article='FHB433067' AND p.brand_id IN (3657,37587,59)) OR (p.article='FKB1035' AND p.brand_id IN (12134,30712,587)) OR (p.article='FKB1036' AND p.brand_id IN (12134,30712,587)) OR (p.article='FKB2319' AND p.brand_id IN (12134,30712,587)) OR (p.article='FKB2503' AND p.brand_id IN (12134,30712,587)) OR (p.article='FKB2873' AND p.brand_id IN (12134,30712,587)) OR (p.article='FKB2874' AND p.brand_id IN (12134,30712,587)) OR (p.article='FKB2875' AND p.brand_id IN (12134,30712,587)) OR (p.article='FKB3215' AND p.brand_id IN (12134,30712,587)) OR (p.article='FO02229' AND p.brand_id IN (254)) OR (p.article='FO02233' AND p.brand_id IN (254)) OR (p.article='J13341' AND p.brand_id IN (198)) OR (p.article='J18961' AND p.brand_id IN (198)) OR (p.article='J19558' AND p.brand_id IN (198)) OR (p.article='J19567' AND p.brand_id IN (198)) OR (p.article='J3913036' AND p.brand_id IN (39111,39503,51,1024,12324,995,22911,5246,6192,36565,6869,2519,32501,29678,29647,6277,22910,5057,6068,5263,67)) OR (p.article='J3920903' AND p.brand_id IN (39111,39503,51,1024,12324,995,22911,5246,6192,36565,6869,2519,32501,29678,29647,6277,22910,5057,6068,5263,67)) OR (p.article='J3923075' AND p.brand_id IN (39111,39503,51,1024,12324,995,22911,5246,6192,36565,6869,2519,32501,29678,29647,6277,22910,5057,6068,5263,67)) OR (p.article='J3923090' AND p.brand_id IN (39111,39503,51,1024,12324,995,22911,5246,6192,36565,6869,2519,32501,29678,29647,6277,22910,5057,6068,5263,67)) OR (p.article='J3933068' AND p.brand_id IN (39111,39503,51,1024,12324,995,22911,5246,6192,36565,6869,2519,32501,29678,29647,6277,22910,5057,6068,5263,67)) OR (p.article='J3933079' AND p.brand_id IN (39111,39503,51,1024,12324,995,22911,5246,6192,36565,6869,2519,32501,29678,29647,6277,22910,5057,6068,5263,67)) OR (p.article='JAPBC330' AND p.brand_id IN (650)) OR (p.article='JAPBC332' AND p.brand_id IN (650)) OR (p.article='K11275' AND p.brand_id IN (31098,166,3538)) OR (p.article='K12016' AND p.brand_id IN (31098,166,3538)) OR (p.article='K13066' AND p.brand_id IN (31098,166,3538)) OR (p.article='K13341' AND p.brand_id IN (31098,166,3538)) OR (p.article='K17402' AND p.brand_id IN (31098,166,3538)) OR (p.article='K17416' AND p.brand_id IN (31098,166,3538)) OR (p.article='K18961' AND p.brand_id IN (31098,166,3538)) OR (p.article='K19558' AND p.brand_id IN (31098,166,3538)) OR (p.article='K19567' AND p.brand_id IN (31098,166,3538)) OR (p.article='LVVB1538' AND p.brand_id IN (37433,638)) OR (p.article='LVVB1539' AND p.brand_id IN (37433,638)) OR (p.article='LVVB1540' AND p.brand_id IN (37433,638)) OR (p.article='MCL9307' AND p.brand_id IN (672)) OR (p.article='MCL9308' AND p.brand_id IN (672)) OR (p.article='MCL9330' AND p.brand_id IN (672)) OR (p.article='MCL9332' AND p.brand_id IN (672)) OR (p.article='MCL9W10' AND p.brand_id IN (672)) OR (p.article='MRP2B03' AND p.brand_id IN (672)) OR (p.article='OP02110' AND p.brand_id IN (254)) OR (p.article='OP02112' AND p.brand_id IN (254)) OR (p.article='OP02113' AND p.brand_id IN (254)) OR (p.article='OP02140' AND p.brand_id IN (254)) OR (p.article='OP02151' AND p.brand_id IN (254)) OR (p.article='OP02160' AND p.brand_id IN (254)) OR (p.article='PAL31060' AND p.brand_id IN (28553,597)) OR (p.article='PAL31118' AND p.brand_id IN (28553,597)) OR (p.article='PAL31480' AND p.brand_id IN (28553,597)) OR (p.article='PAL31481' AND p.brand_id IN (28553,597)) OR (p.article='PC3023' AND p.brand_id IN (425)) OR (p.article='PC3028' AND p.brand_id IN (425)) OR (p.article='PC3102' AND p.brand_id IN (425)) OR (p.article='PC3131' AND p.brand_id IN (425)) OR (p.article='PHC1891' AND p.brand_id IN (33820,3259,380)) OR (p.article='SKCPB1050055' AND p.brand_id IN (24077)) OR (p.article='SKCPB1050090' AND p.brand_id IN (24077)) OR (p.article='T480416' AND p.brand_id IN (458)) OR (p.article='T481816' AND p.brand_id IN (458)) OR (p.article='T481817' AND p.brand_id IN (458)) OR (p.article='T482224' AND p.brand_id IN (458)) OR (p.article='T482225' AND p.brand_id IN (458)) OR (p.article='T482458' AND p.brand_id IN (458)) OR (p.article='T482461' AND p.brand_id IN (458)) OR (p.article='T482477' AND p.brand_id IN (458)) OR (p.article='T482483' AND p.brand_id IN (458)) OR (p.article='T482498' AND p.brand_id IN (458)) OR (p.article='T482507' AND p.brand_id IN (458)) OR (p.article='T484675' AND p.brand_id IN (458)) OR (p.article='T484681' AND p.brand_id IN (458)) OR (p.article='V2530020' AND p.brand_id IN (39162,39163,39130,33103,6249,6237,21186,5220,5260,133,148)) OR (p.article='V2530022' AND p.brand_id IN (39162,39163,39130,33103,6249,6237,21186,5220,5260,133,148)) OR (p.article='V4030048' AND p.brand_id IN (39162,39163,39130,33103,6249,6237,21186,5220,5260,133,148)) OR (p.article='VVB1082' AND p.brand_id IN (37433,638)) OR (p.article='VVB1144' AND p.brand_id IN (37433,638)) OR (p.article='VVB1166' AND p.brand_id IN (37433,638)) OR (p.article='VVB532' AND p.brand_id IN (37433,638)) OR (p.article='ZV4K44150A' AND p.brand_id IN (5195)) OR (p.article='90235948' AND p.brand_id IN (0)) OR (p.article='9458110390235948' AND p.brand_id IN (0)) OR (p.article='NSP0190235948' AND p.brand_id IN (4959))) AND ps.supplier_id IN (224,226,223,225,227)An internal server error occurred.