#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUyNHx8bW9kZWxfaWQ9PTU0NDl8fG1kZl9pZD09MF4zMTYxNnx8c3BhcmVfaWQ9PTEwMDU5OA%3D%3D&st=50
SELECT
CONCAT(av.SupplierID, "^", av.DataSupplierArticleNumber) AS article_id,
d.`Description` AS crit_designation,
dv.`DisplayValue` AS crit_value,
"" crit_unit,
2 criteria_art,
"articletypes" as source
FROM articlepassengercars av
JOIN passengercarlinkageattributes_ru vla
ON av.Idx = vla.Idx
JOIN linkageattributedescriptions d
ON vla.DescriptionIdx = d.Idx
JOIN linkageattributedisplayvalues dv
ON vla.DisplayValueIdx = dv.Idx
WHERE
av.VehicleID = "31616"
AND (
(av.SupplierID = 4814
AND av.DataSupplierArticleNumber = "D20148"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4814
AND av.DataSupplierArticleNumber = "D20388"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4598
AND av.DataSupplierArticleNumber = "13408"
AND av.ProductID IN (308))
OR
(av.SupplierID = 4997
AND av.DataSupplierArticleNumber = "YD106036"
AND av.ProductID IN (308))
OR
(av.SupplierID = 206
AND av.DataSupplierArticleNumber = "37496"
AND av.ProductID IN (402))
OR
(av.SupplierID = 206
AND av.DataSupplierArticleNumber = "37300"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4426
AND av.DataSupplierArticleNumber = "C2X013ABE"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4426
AND av.DataSupplierArticleNumber = "C1X024ABE"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4426
AND av.DataSupplierArticleNumber = "C2F011ABE"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4533
AND av.DataSupplierArticleNumber = "112728"
AND av.ProductID IN (402))
OR
(av.SupplierID = 166
AND av.DataSupplierArticleNumber = "BPFI-1021"
AND av.ProductID IN (402))
OR
(av.SupplierID = 180
AND av.DataSupplierArticleNumber = "SP-1421"
AND av.ProductID IN (9))
OR
(av.SupplierID = 180
AND av.DataSupplierArticleNumber = "MD-577"
AND av.ProductID IN (9))
OR
(av.SupplierID = 257
AND av.DataSupplierArticleNumber = "30-ECO016"
AND av.ProductID IN (9))
OR
(av.SupplierID = 442
AND av.DataSupplierArticleNumber = "0399-1308"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4631
AND av.DataSupplierArticleNumber = "AKD-0325"
AND av.ProductID IN (402))
OR
(av.SupplierID = 3
AND av.DataSupplierArticleNumber = "13.0470-7172.2"
AND av.ProductID IN (402))
OR
(av.SupplierID = 3
AND av.DataSupplierArticleNumber = "13.0460-3825.2"
AND av.ProductID IN (402))
OR
(av.SupplierID = 3
AND av.DataSupplierArticleNumber = "13.0460-7172.2"
AND av.ProductID IN (402))
OR
(av.SupplierID = 3
AND av.DataSupplierArticleNumber = "13.0460-7212.2"
AND av.ProductID IN (402))
OR
(av.SupplierID = 300
AND av.DataSupplierArticleNumber = "702425"
AND av.ProductID IN (307))
OR
(av.SupplierID = 300
AND av.DataSupplierArticleNumber = "654747"
AND av.ProductID IN (308))
OR
(av.SupplierID = 4737
AND av.DataSupplierArticleNumber = "ZK1061"
AND av.ProductID IN (307))
OR
(av.SupplierID = 4651
AND av.DataSupplierArticleNumber = "03.300"
AND av.ProductID IN (308))
OR
(av.SupplierID = 4651
AND av.DataSupplierArticleNumber = "04.5282"
AND av.ProductID IN (307))
OR
(av.SupplierID = 4337
AND av.DataSupplierArticleNumber = "G50"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4337
AND av.DataSupplierArticleNumber = "G78"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4464
AND av.DataSupplierArticleNumber = "KAT1427"
AND av.ProductID IN (307))
OR
(av.SupplierID = 4464
AND av.DataSupplierArticleNumber = "A04764"
AND av.ProductID IN (308))
OR
(av.SupplierID = 4464
AND av.DataSupplierArticleNumber = "KATW1427"
AND av.ProductID IN (307))
OR
(av.SupplierID = 394
AND av.DataSupplierArticleNumber = "BA2236"
AND av.ProductID IN (402))
OR
(av.SupplierID = 478
AND av.DataSupplierArticleNumber = "TB9504K"
AND av.ProductID IN (307))
OR
(av.SupplierID = 350
AND av.DataSupplierArticleNumber = "ADK82327"
AND av.ProductID IN (9))
OR
(av.SupplierID = 350
AND av.DataSupplierArticleNumber = "ADL142301"
AND av.ProductID IN (9))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BBP1992"
AND av.ProductID IN (402))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BFF8051"
AND av.ProductID IN (9))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BFF8002"
AND av.ProductID IN (9))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "0 986 494 044"
AND av.ProductID IN (402))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "1 457 070 001"
AND av.ProductID IN (9))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "1 987 949 644"
AND av.ProductID IN (306))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "1 987 948 939"
AND av.ProductID IN (307))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "0 986 494 073"
AND av.ProductID IN (402))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "F 026 402 076"
AND av.ProductID IN (9))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "0 986 494 125"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4993
AND av.DataSupplierArticleNumber = "AA0251"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4993
AND av.DataSupplierArticleNumber = "AA0045"
AND av.ProductID IN (402))
OR
(av.SupplierID = 281
AND av.DataSupplierArticleNumber = "23402 00 701 00"
AND av.ProductID IN (402))
OR
(av.SupplierID = 195
AND av.DataSupplierArticleNumber = "KCD0319"
AND av.ProductID IN (307))
OR
(av.SupplierID = 65
AND av.DataSupplierArticleNumber = "P 23 100"
AND av.ProductID IN (402))
OR
(av.SupplierID = 65
AND av.DataSupplierArticleNumber = "P 23 101"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4872
AND av.DataSupplierArticleNumber = "BP3014"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4578
AND av.DataSupplierArticleNumber = "PBTK528"
AND av.ProductID IN (307))
OR
(av.SupplierID = 4455
AND av.DataSupplierArticleNumber = "BSG 65-130-002"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4463
AND av.DataSupplierArticleNumber = "0354KFW"
AND av.ProductID IN (307))
OR
(av.SupplierID = 4463
AND av.DataSupplierArticleNumber = "77560"
AND av.ProductID IN (308))
OR
(av.SupplierID = 4463
AND av.DataSupplierArticleNumber = "0354KF"
AND av.ProductID IN (307))
OR
(av.SupplierID = 243
AND av.DataSupplierArticleNumber = "DKS04.5282"
AND av.ProductID IN (307))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "L409/606"
AND av.ProductID IN (9))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "L502/606"
AND av.ProductID IN (9))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "CFF100409"
AND av.ProductID IN (9))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "CFF100502"
AND av.ProductID IN (9))
OR
(av.SupplierID = 311
AND av.DataSupplierArticleNumber = "822-540-0"
AND av.ProductID IN (402))
OR
(av.SupplierID = 311
AND av.DataSupplierArticleNumber = "822-540-4"
AND av.ProductID IN (402))
OR
(av.SupplierID = 311
AND av.DataSupplierArticleNumber = "822-706-0"
AND av.ProductID IN (402))
OR
(av.SupplierID = 163
AND av.DataSupplierArticleNumber = "DNW1999"
AND av.ProductID IN (9))
OR
(av.SupplierID = 163
AND av.DataSupplierArticleNumber = "MG1677"
AND av.ProductID IN (9))
OR
(av.SupplierID = 421
AND av.DataSupplierArticleNumber = "CBP01630"
AND av.ProductID IN (402))
OR
(av.SupplierID = 421
AND av.DataSupplierArticleNumber = "ADB01137"
AND av.ProductID IN (402))
OR
(av.SupplierID = 421
AND av.DataSupplierArticleNumber = "EFF156"
AND av.ProductID IN (9))
OR
(av.SupplierID = 421
AND av.DataSupplierArticleNumber = "ADB01630"
AND av.ProductID IN (402))
OR
(av.SupplierID = 421
AND av.DataSupplierArticleNumber = "EFF201"
AND av.ProductID IN (9))
OR
(av.SupplierID = 421
AND av.DataSupplierArticleNumber = "CBP01137"
AND av.ProductID IN (402))
OR
(av.SupplierID = 31
AND av.DataSupplierArticleNumber = "CT1106"
AND av.ProductID IN (306))
OR
(av.SupplierID = 31
AND av.DataSupplierArticleNumber = "CT1106K1"
AND av.ProductID IN (307))
OR
(av.SupplierID = 437
AND av.DataSupplierArticleNumber = "FA5757A"
AND av.ProductID IN (9))
OR
(av.SupplierID = 437
AND av.DataSupplierArticleNumber = "FP5759HWS"
AND av.ProductID IN (9))
OR
(av.SupplierID = 42
AND av.DataSupplierArticleNumber = "94987"
AND av.ProductID IN (306))
OR
(av.SupplierID = 42
AND av.DataSupplierArticleNumber = "KTB458"
AND av.ProductID IN (307))
OR
(av.SupplierID = 42
AND av.DataSupplierArticleNumber = "ATB2547"
AND av.ProductID IN (308))
OR
(av.SupplierID = 89
AND av.DataSupplierArticleNumber = "LP1964"
AND av.ProductID IN (402))
OR
(av.SupplierID = 89
AND av.DataSupplierArticleNumber = "KDB458"
AND av.ProductID IN (307))
OR
(av.SupplierID = 89
AND av.DataSupplierArticleNumber = "HDF608"
AND av.ProductID IN (9))
OR
(av.SupplierID = 89
AND av.DataSupplierArticleNumber = "TB6178"
AND av.ProductID IN (306))
OR
(av.SupplierID = 89
AND av.DataSupplierArticleNumber = "LP1723"
AND av.ProductID IN (402))
OR
(av.SupplierID = 186
AND av.DataSupplierArticleNumber = "A120184"
AND av.ProductID IN (9))
OR
(av.SupplierID = 186
AND av.DataSupplierArticleNumber = "A120262"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4519
AND av.DataSupplierArticleNumber = "BP2072"
AND av.ProductID IN (402))
OR
(av.SupplierID = 154
AND av.DataSupplierArticleNumber = "06KD042"
AND av.ProductID IN (308))
OR
(av.SupplierID = 154
AND av.DataSupplierArticleNumber = "06KD043"
AND av.ProductID IN (308))
OR
(av.SupplierID = 154
AND av.DataSupplierArticleNumber = "05KD036"
AND av.ProductID IN (306))
OR
(av.SupplierID = 4948
AND av.DataSupplierArticleNumber = "DP1110.13.0072"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4948
AND av.DataSupplierArticleNumber = "DP1010.10.0867"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4948
AND av.DataSupplierArticleNumber = "DP1110.13.0068"
AND av.ProductID IN (9))
OR
(av.SupplierID = 266
AND av.DataSupplierArticleNumber = "DBP234188"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "DBP1797"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "DFFL567"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "DBP4188"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "DT12174"
AND av.ProductID IN (308))
OR
(av.SupplierID = 4770
AND av.DataSupplierArticleNumber = "5502222379"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4770
AND av.DataSupplierArticleNumber = "5502223628"
AND av.ProductID IN (402))
OR
(av.SupplierID = 267
AND av.DataSupplierArticleNumber = "TBK493"
AND av.ProductID IN (307))
OR
(av.SupplierID = 267
AND av.DataSupplierArticleNumber = "24190"
AND av.ProductID IN (306))
OR
(av.SupplierID = 267
AND av.DataSupplierArticleNumber = "T9379"
AND av.ProductID IN (308))
OR
(av.SupplierID = 4834
AND av.DataSupplierArticleNumber = "14859"
AND av.ProductID IN (308))
OR
(av.SupplierID = 4938
AND av.DataSupplierArticleNumber = "FT44026"
AND av.ProductID IN (308))
OR
(av.SupplierID = 4938
AND av.DataSupplierArticleNumber = "FT29159"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4938
AND av.DataSupplierArticleNumber = "FT39047"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4938
AND av.DataSupplierArticleNumber = "FT39051"
AND av.ProductID IN (9))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "30757"
AND av.ProductID IN (9))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "16492"
AND av.ProductID IN (402))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "10298"
AND av.ProductID IN (308))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "28306"
AND av.ProductID IN (306))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "28305"
AND av.ProductID IN (307))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "16852"
AND av.ProductID IN (402))
OR
(av.SupplierID = 271
AND av.DataSupplierArticleNumber = "BP43073"
AND av.ProductID IN (402))
OR
(av.SupplierID = 62
AND av.DataSupplierArticleNumber = "FDB4188"
AND av.ProductID IN (402))
OR
(av.SupplierID = 62
AND av.DataSupplierArticleNumber = "FDB1797"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4986
AND av.DataSupplierArticleNumber = "FCP1520H"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4838
AND av.DataSupplierArticleNumber = "FBP4113"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4838
AND av.DataSupplierArticleNumber = "FK-773"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4838
AND av.DataSupplierArticleNumber = "FK-781"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4659
AND av.DataSupplierArticleNumber = "ZP 8083 FM"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4659
AND av.DataSupplierArticleNumber = "KFE 1460"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4659
AND av.DataSupplierArticleNumber = "KFE 1460 V"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4659
AND av.DataSupplierArticleNumber = "MFE 1558 MB"
AND av.ProductID IN (9))
OR
(av.SupplierID = 256
AND av.DataSupplierArticleNumber = "PE982"
AND av.ProductID IN (9))
OR
(av.SupplierID = 256
AND av.DataSupplierArticleNumber = "PP966/3"
AND av.ProductID IN (9))
OR
(av.SupplierID = 441
AND av.DataSupplierArticleNumber = "4829"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4937
AND av.DataSupplierArticleNumber = "FP0972"
AND av.ProductID IN (402))
OR
(av.SupplierID = 236
AND av.DataSupplierArticleNumber = "F904549V"
AND av.ProductID IN (307))
OR
(av.SupplierID = 236
AND av.DataSupplierArticleNumber = "FS01063"
AND av.ProductID IN (308))
OR
(av.SupplierID = 236
AND av.DataSupplierArticleNumber = "F914549V"
AND av.ProductID IN (307))
OR
(av.SupplierID = 236
AND av.DataSupplierArticleNumber = "4549V"
AND av.ProductID IN (306))
OR
(av.SupplierID = 4887
AND av.DataSupplierArticleNumber = "FO 689581"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4887
AND av.DataSupplierArticleNumber = "FO 847181"
AND av.ProductID IN (402))
OR
(av.SupplierID = 59
AND av.DataSupplierArticleNumber = "PS10042"
AND av.ProductID IN (9))
OR
(av.SupplierID = 59
AND av.DataSupplierArticleNumber = "C10026A"
AND av.ProductID IN (9))
OR
(av.SupplierID = 409
AND av.DataSupplierArticleNumber = "FBP-1265"
AND av.ProductID IN (402))
OR
(av.SupplierID = 409
AND av.DataSupplierArticleNumber = "FBP-1475"
AND av.ProductID IN (402))
OR
(av.SupplierID = 409
AND av.DataSupplierArticleNumber = "FBP-1618"
AND av.ProductID IN (402))
OR
(av.SupplierID = 295
AND av.DataSupplierArticleNumber = "722.0"
AND av.ProductID IN (402))
OR
(av.SupplierID = 295
AND av.DataSupplierArticleNumber = "556.0"
AND av.ProductID IN (402))
OR
(av.SupplierID = 295
AND av.DataSupplierArticleNumber = "556.4"
AND av.ProductID IN (402))
OR
(av.SupplierID = 313
AND av.DataSupplierArticleNumber = "FL04.402"
AND av.ProductID IN (9))
OR
(av.SupplierID = 313
AND av.DataSupplierArticleNumber = "PD07.503"
AND av.ProductID IN (402))
OR
(av.SupplierID = 313
AND av.DataSupplierArticleNumber = "FL04.404"
AND av.ProductID IN (9))
OR
(av.SupplierID = 54
AND av.DataSupplierArticleNumber = "BL2519A1"
AND av.ProductID IN (402))
OR
(av.SupplierID = 54
AND av.DataSupplierArticleNumber = "BL1817A2"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4844
AND av.DataSupplierArticleNumber = "GBP088800"
AND av.ProductID IN (402,402))
OR
(av.SupplierID = 500
AND av.DataSupplierArticleNumber = "B1.G102-0650.2"
AND av.ProductID IN (402))
OR
(av.SupplierID = 500
AND av.DataSupplierArticleNumber = "B1.G102-0672.2"
AND av.ProductID IN (402))
OR
(av.SupplierID = 500
AND av.DataSupplierArticleNumber = "B1.G102-0836.2"
AND av.ProductID IN (402))
OR
(av.SupplierID = 33
AND av.DataSupplierArticleNumber = "T43211"
AND av.ProductID IN (308))
OR
(av.SupplierID = 33
AND av.DataSupplierArticleNumber = "5650XS"
AND av.ProductID IN (306))
OR
(av.SupplierID = 33
AND av.DataSupplierArticleNumber = "K025650XS"
AND av.ProductID IN (307))
OR
(av.SupplierID = 368
AND av.DataSupplierArticleNumber = "PUKD042"
AND av.ProductID IN (308))
OR
(av.SupplierID = 368
AND av.DataSupplierArticleNumber = "COKD036"
AND av.ProductID IN (306))
OR
(av.SupplierID = 368
AND av.DataSupplierArticleNumber = "PUKD043"
AND av.ProductID IN (308))
OR
(av.SupplierID = 279
AND av.DataSupplierArticleNumber = "6116132"
AND av.ProductID IN (402))
OR
(av.SupplierID = 279
AND av.DataSupplierArticleNumber = "6116371"
AND av.ProductID IN (402))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "8DB 355 009-311"
AND av.ProductID IN (402))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "8DB 355 012-411"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4625
AND av.DataSupplierArticleNumber = "8DB 355 012-411"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4625
AND av.DataSupplierArticleNumber = "8DB 355 009-311"
AND av.ProductID IN (402))
OR
(av.SupplierID = 81
AND av.DataSupplierArticleNumber = "E83KP02 D140"
AND av.ProductID IN (9))
OR
(av.SupplierID = 81
AND av.DataSupplierArticleNumber = "H340WK"
AND av.ProductID IN (9))
OR
(av.SupplierID = 81
AND av.DataSupplierArticleNumber = "E83KP D140"
AND av.ProductID IN (9))
OR
(av.SupplierID = 81
AND av.DataSupplierArticleNumber = "E83KP01 D140"
AND av.ProductID IN (9))
OR
(av.SupplierID = 178
AND av.DataSupplierArticleNumber = "20-1420"
AND av.ProductID IN (307))
OR
(av.SupplierID = 55
AND av.DataSupplierArticleNumber = "J1338027"
AND av.ProductID IN (9))
OR
(av.SupplierID = 341
AND av.DataSupplierArticleNumber = "4915"
AND av.ProductID IN (9))
OR
(av.SupplierID = 341
AND av.DataSupplierArticleNumber = "4499"
AND av.ProductID IN (9))
OR
(av.SupplierID = 341
AND av.DataSupplierArticleNumber = "4829"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4998
AND av.DataSupplierArticleNumber = "HP8382"
AND av.ProductID IN (402))
OR
(av.SupplierID = 239
AND av.DataSupplierArticleNumber = "HTG 135"
AND av.ProductID IN (308))
OR
(av.SupplierID = 239
AND av.DataSupplierArticleNumber = "KH 493"
AND av.ProductID IN (307))
OR
(av.SupplierID = 239
AND av.DataSupplierArticleNumber = "190 HTDP/T 24"
AND av.ProductID IN (306))
OR
(av.SupplierID = 158
AND av.DataSupplierArticleNumber = "181536"
AND av.ProductID IN (402))
OR
(av.SupplierID = 158
AND av.DataSupplierArticleNumber = "181763"
AND av.ProductID IN (402))
OR
(av.SupplierID = 204
AND av.DataSupplierArticleNumber = "531 0844 10"
AND av.ProductID IN (308))
OR
(av.SupplierID = 204
AND av.DataSupplierArticleNumber = "530 0435 10"
AND av.ProductID IN (307))
OR
(av.SupplierID = 204
AND av.DataSupplierArticleNumber = "531 0255 30"
AND av.ProductID IN (308))
OR
(av.SupplierID = 204
AND av.DataSupplierArticleNumber = "530 0624 10"
AND av.ProductID IN (307))
OR
(av.SupplierID = 262
AND av.DataSupplierArticleNumber = "15-3742"
AND av.ProductID IN (308))
OR
(av.SupplierID = 262
AND av.DataSupplierArticleNumber = "20-1420"
AND av.ProductID IN (307))
OR
(av.SupplierID = 459
AND av.DataSupplierArticleNumber = "IFG-3886"
AND av.ProductID IN (9))
OR
(av.SupplierID = 156
AND av.DataSupplierArticleNumber = "FC-ECO016"
AND av.ProductID IN (9))
OR
(av.SupplierID = 481
AND av.DataSupplierArticleNumber = "3ECO016"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4689
AND av.DataSupplierArticleNumber = "B3F038PR"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4689
AND av.DataSupplierArticleNumber = "B3F036PR"
AND av.ProductID IN (9))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1218700500"
AND av.ProductID IN (9))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1212201509"
AND av.ProductID IN (308))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1263603119"
AND av.ProductID IN (402))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1212104910"
AND av.ProductID IN (307))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "3363700319"
AND av.ProductID IN (402))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1212104919"
AND av.ProductID IN (307))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1212102209"
AND av.ProductID IN (306))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1212201500"
AND av.ProductID IN (308))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1263603110"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4935
AND av.DataSupplierArticleNumber = "JCP1474"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4935
AND av.DataSupplierArticleNumber = "JCP1797"
AND av.ProductID IN (402))
OR
(av.SupplierID = 48
AND av.DataSupplierArticleNumber = "573089JC"
AND av.ProductID IN (402))
OR
(av.SupplierID = 48
AND av.DataSupplierArticleNumber = "573307J"
AND av.ProductID IN (402))
OR
(av.SupplierID = 48
AND av.DataSupplierArticleNumber = "573089D"
AND av.ProductID IN (402))
OR
(av.SupplierID = 48
AND av.DataSupplierArticleNumber = "573089J"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4461
AND av.DataSupplierArticleNumber = "FC1181"
AND av.ProductID IN (9))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "JQ1013594"
AND av.ProductID IN (402))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "R0241"
AND av.ProductID IN (308))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "F301601"
AND av.ProductID IN (9))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "F305701"
AND av.ProductID IN (9))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "JQ1013040"
AND av.ProductID IN (402))
OR
(av.SupplierID = 286
AND av.DataSupplierArticleNumber = "810071"
AND av.ProductID IN (402))
OR
(av.SupplierID = 286
AND av.DataSupplierArticleNumber = "0879 31"
AND av.ProductID IN (402))
OR
(av.SupplierID = 286
AND av.DataSupplierArticleNumber = "0888 00"
AND av.ProductID IN (402))
OR
(av.SupplierID = 286
AND av.DataSupplierArticleNumber = "1178 00"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4462
AND av.DataSupplierArticleNumber = "KFI354"
AND av.ProductID IN (307))
OR
(av.SupplierID = 4462
AND av.DataSupplierArticleNumber = "WKFI354"
AND av.ProductID IN (307))
OR
(av.SupplierID = 4462
AND av.DataSupplierArticleNumber = "FI11910"
AND av.ProductID IN (308))
OR
(av.SupplierID = 34
AND av.DataSupplierArticleNumber = "KL 567"
AND av.ProductID IN (9))
OR
(av.SupplierID = 432
AND av.DataSupplierArticleNumber = "50014136"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "1726860"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "6001720"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "6008533"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "1223350"
AND av.ProductID IN (308))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "6013015"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "1723002"
AND av.ProductID IN (9))
OR
(av.SupplierID = 197
AND av.DataSupplierArticleNumber = "05P1218"
AND av.ProductID IN (402))
OR
(av.SupplierID = 197
AND av.DataSupplierArticleNumber = "05P1524"
AND av.ProductID IN (402))
OR
(av.SupplierID = 197
AND av.DataSupplierArticleNumber = "05P1216"
AND av.ProductID IN (402))
OR
(av.SupplierID = 424
AND av.DataSupplierArticleNumber = "LA0207"
AND av.ProductID IN (308))
OR
(av.SupplierID = 424
AND av.DataSupplierArticleNumber = "LDK0368"
AND av.ProductID IN (307))
OR
(av.SupplierID = 424
AND av.DataSupplierArticleNumber = "LA0208"
AND av.ProductID IN (308))
OR
(av.SupplierID = 424
AND av.DataSupplierArticleNumber = "LA0206"
AND av.ProductID IN (308))
OR
(av.SupplierID = 4973
AND av.DataSupplierArticleNumber = "LFDE150"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4973
AND av.DataSupplierArticleNumber = "LFDF178"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4600
AND av.DataSupplierArticleNumber = "PB-1255"
AND av.ProductID IN (308))
OR
(av.SupplierID = 4600
AND av.DataSupplierArticleNumber = "PK-1348"
AND av.ProductID IN (307))
OR
(av.SupplierID = 4600
AND av.DataSupplierArticleNumber = "LF-1811"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4600
AND av.DataSupplierArticleNumber = "LF-1814"
AND av.ProductID IN (9))
OR
(av.SupplierID = 95
AND av.DataSupplierArticleNumber = "340018181049"
AND av.ProductID IN (306))
OR
(av.SupplierID = 95
AND av.DataSupplierArticleNumber = "341303980000"
AND av.ProductID IN (307))
OR
(av.SupplierID = 95
AND av.DataSupplierArticleNumber = "363916060225"
AND av.ProductID IN (402))
OR
(av.SupplierID = 95
AND av.DataSupplierArticleNumber = "341310491201"
AND av.ProductID IN (307))
OR
(av.SupplierID = 95
AND av.DataSupplierArticleNumber = "153071760155"
AND av.ProductID IN (9))
OR
(av.SupplierID = 95
AND av.DataSupplierArticleNumber = "363916060162"
AND av.ProductID IN (402))
OR
(av.SupplierID = 95
AND av.DataSupplierArticleNumber = "153071760527"
AND av.ProductID IN (9))
OR
(av.SupplierID = 287
AND av.DataSupplierArticleNumber = "KL 567"
AND av.ProductID IN (9))
OR
(av.SupplierID = 317
AND av.DataSupplierArticleNumber = "1050187"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4
AND av.DataSupplierArticleNumber = "WK 853/21"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4
AND av.DataSupplierArticleNumber = "PU 723 x"
AND av.ProductID IN (9))
OR
(av.SupplierID = 133
AND av.DataSupplierArticleNumber = "23720"
AND av.ProductID IN (307))
OR
(av.SupplierID = 133
AND av.DataSupplierArticleNumber = "63236"
AND av.ProductID IN (9))
OR
(av.SupplierID = 133
AND av.DataSupplierArticleNumber = "43720"
AND av.ProductID IN (306))
OR
(av.SupplierID = 133
AND av.DataSupplierArticleNumber = "63029"
AND av.ProductID IN (9))
OR
(av.SupplierID = 358
AND av.DataSupplierArticleNumber = "13046071722N-SET-MS"
AND av.ProductID IN (402))
OR
(av.SupplierID = 358
AND av.DataSupplierArticleNumber = "723X-KF-PCS-MS"
AND av.ProductID IN (9))
OR
(av.SupplierID = 358
AND av.DataSupplierArticleNumber = "853/21-KF-PCS-MS"
AND av.ProductID IN (9))
OR
(av.SupplierID = 358
AND av.DataSupplierArticleNumber = "13046071722-SET-MS"
AND av.ProductID IN (402))
OR
(av.SupplierID = 358
AND av.DataSupplierArticleNumber = "208DK-KF-PCS-MS"
AND av.ProductID IN (9))
OR
(av.SupplierID = 403
AND av.DataSupplierArticleNumber = "26-0667"
AND av.ProductID IN (9))
OR
(av.SupplierID = 403
AND av.DataSupplierArticleNumber = "26-0033"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4773
AND av.DataSupplierArticleNumber = "MFF-3E16"
AND av.ProductID IN (9))
OR
(av.SupplierID = 244
AND av.DataSupplierArticleNumber = "4499"
AND av.ProductID IN (9))
OR
(av.SupplierID = 244
AND av.DataSupplierArticleNumber = "4829"
AND av.ProductID IN (9))
OR
(av.SupplierID = 244
AND av.DataSupplierArticleNumber = "4915"
AND av.ProductID IN (9))
OR
(av.SupplierID = 218
AND av.DataSupplierArticleNumber = "ELG5327"
AND av.ProductID IN (9))
OR
(av.SupplierID = 218
AND av.DataSupplierArticleNumber = "ELG5322"
AND av.ProductID IN (9))
OR
(av.SupplierID = 121
AND av.DataSupplierArticleNumber = "22-0540-4"
AND av.ProductID IN (402))
OR
(av.SupplierID = 121
AND av.DataSupplierArticleNumber = "22-0706-0"
AND av.ProductID IN (402))
OR
(av.SupplierID = 121
AND av.DataSupplierArticleNumber = "22-0540-0"
AND av.ProductID IN (402))
OR
(av.SupplierID = 94
AND av.DataSupplierArticleNumber = "1170100"
AND av.ProductID IN (402))
OR
(av.SupplierID = 94
AND av.DataSupplierArticleNumber = "WM-Z 621"
AND av.ProductID IN (307))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "214 323 0004"
AND av.ProductID IN (9))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "614 323 0004"
AND av.ProductID IN (9))
OR
(av.SupplierID = 462
AND av.DataSupplierArticleNumber = "DE 3118"
AND av.ProductID IN (9))
OR
(av.SupplierID = 462
AND av.DataSupplierArticleNumber = "DF 3531"
AND av.ProductID IN (9))
OR
(av.SupplierID = 73
AND av.DataSupplierArticleNumber = "MDB2262"
AND av.ProductID IN (402))
OR
(av.SupplierID = 73
AND av.DataSupplierArticleNumber = "MDB2800"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4470
AND av.DataSupplierArticleNumber = "F116"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4564
AND av.DataSupplierArticleNumber = "VFF500"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4564
AND av.DataSupplierArticleNumber = "VFF551"
AND av.ProductID IN (9))
OR
(av.SupplierID = 490
AND av.DataSupplierArticleNumber = "FN388"
AND av.ProductID IN (9))
OR
(av.SupplierID = 490
AND av.DataSupplierArticleNumber = "FN148"
AND av.ProductID IN (9))
OR
(av.SupplierID = 190
AND av.DataSupplierArticleNumber = "NP2016"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4682
AND av.DataSupplierArticleNumber = "PN0325"
AND av.ProductID IN (402))
OR
(av.SupplierID = 248
AND av.DataSupplierArticleNumber = "J1338031"
AND av.ProductID IN (9))
OR
(av.SupplierID = 127
AND av.DataSupplierArticleNumber = "222379"
AND av.ProductID IN (402))
OR
(av.SupplierID = 127
AND av.DataSupplierArticleNumber = "223628"
AND av.ProductID IN (402))
OR
(av.SupplierID = 440
AND av.DataSupplierArticleNumber = "S133I04"
AND av.ProductID IN (9))
OR
(av.SupplierID = 440
AND av.DataSupplierArticleNumber = "S112I16"
AND av.ProductID IN (306))
OR
(av.SupplierID = 4380
AND av.DataSupplierArticleNumber = "2136691"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4380
AND av.DataSupplierArticleNumber = "2135196"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4380
AND av.DataSupplierArticleNumber = "2136743"
AND av.ProductID IN (9))
OR
(av.SupplierID = 64
AND av.DataSupplierArticleNumber = "371ST"
AND av.ProductID IN (308))
OR
(av.SupplierID = 129
AND av.DataSupplierArticleNumber = "88800"
AND av.ProductID IN (402))
OR
(av.SupplierID = 129
AND av.DataSupplierArticleNumber = "FF-01204"
AND av.ProductID IN (9))
OR
(av.SupplierID = 129
AND av.DataSupplierArticleNumber = "SK-1696"
AND av.ProductID IN (307))
OR
(av.SupplierID = 129
AND av.DataSupplierArticleNumber = "0-N115"
AND av.ProductID IN (308))
OR
(av.SupplierID = 4558
AND av.DataSupplierArticleNumber = "PT12174"
AND av.ProductID IN (308))
OR
(av.SupplierID = 4558
AND av.DataSupplierArticleNumber = "PF3152"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4558
AND av.DataSupplierArticleNumber = "PF3269"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4686
AND av.DataSupplierArticleNumber = "1530-2520"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4686
AND av.DataSupplierArticleNumber = "1530-2543"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4520
AND av.DataSupplierArticleNumber = "PRP1408"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4520
AND av.DataSupplierArticleNumber = "PRP1409"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4520
AND av.DataSupplierArticleNumber = "PRP0482"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4520
AND av.DataSupplierArticleNumber = "PRP1410"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4520
AND av.DataSupplierArticleNumber = "PRP1228"
AND av.ProductID IN (402))
OR
(av.SupplierID = 38
AND av.DataSupplierArticleNumber = "C507A"
AND av.ProductID IN (9))
OR
(av.SupplierID = 38
AND av.DataSupplierArticleNumber = "FCS722"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4821
AND av.DataSupplierArticleNumber = "QP0935"
AND av.ProductID IN (402))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "MBP1366"
AND av.ProductID IN (402))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "QBK658"
AND av.ProductID IN (307))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "QFF0278"
AND av.ProductID IN (9))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "MBP1509"
AND av.ProductID IN (402))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "QTB544"
AND av.ProductID IN (306))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "BP1366"
AND av.ProductID IN (402))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "QFF0299"
AND av.ProductID IN (9))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "BP1509"
AND av.ProductID IN (402))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "MBK658"
AND av.ProductID IN (307))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "QTT841"
AND av.ProductID IN (308))
OR
(av.SupplierID = 4955
AND av.DataSupplierArticleNumber = "RB1763"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4955
AND av.DataSupplierArticleNumber = "RB1536"
AND av.ProductID IN (402))
OR
(av.SupplierID = 400
AND av.DataSupplierArticleNumber = "RA.0904.0"
AND av.ProductID IN (402))
OR
(av.SupplierID = 400
AND av.DataSupplierArticleNumber = "RA.0797.1"
AND av.ProductID IN (402))
OR
(av.SupplierID = 153
AND av.DataSupplierArticleNumber = "0879.31"
AND av.ProductID IN (402))
OR
(av.SupplierID = 153
AND av.DataSupplierArticleNumber = "0888.00"
AND av.ProductID IN (402))
OR
(av.SupplierID = 153
AND av.DataSupplierArticleNumber = "1178.00"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4330
AND av.DataSupplierArticleNumber = "RKT1306"
AND av.ProductID IN (308))
OR
(av.SupplierID = 4330
AND av.DataSupplierArticleNumber = "RKTK1093"
AND av.ProductID IN (307))
OR
(av.SupplierID = 152
AND av.DataSupplierArticleNumber = "21178.00"
AND av.ProductID IN (402))
OR
(av.SupplierID = 152
AND av.DataSupplierArticleNumber = "2879.31"
AND av.ProductID IN (402))
OR
(av.SupplierID = 152
AND av.DataSupplierArticleNumber = "2888.00"
AND av.ProductID IN (402))
OR
(av.SupplierID = 100
AND av.DataSupplierArticleNumber = "RR1049"
AND av.ProductID IN (306))
OR
(av.SupplierID = 23
AND av.DataSupplierArticleNumber = "5603677"
AND av.ProductID IN (307))
OR
(av.SupplierID = 23
AND av.DataSupplierArticleNumber = "55844"
AND av.ProductID IN (308))
OR
(av.SupplierID = 23
AND av.DataSupplierArticleNumber = "5584475"
AND av.ProductID IN (307))
OR
(av.SupplierID = 23
AND av.DataSupplierArticleNumber = "56036"
AND av.ProductID IN (308))
OR
(av.SupplierID = 260
AND av.DataSupplierArticleNumber = "1766005"
AND av.ProductID IN (306))
OR
(av.SupplierID = 260
AND av.DataSupplierArticleNumber = "1756008"
AND av.ProductID IN (307))
OR
(av.SupplierID = 260
AND av.DataSupplierArticleNumber = "1706007"
AND av.ProductID IN (308))
OR
(av.SupplierID = 297
AND av.DataSupplierArticleNumber = "1501222379"
AND av.ProductID IN (402))
OR
(av.SupplierID = 297
AND av.DataSupplierArticleNumber = "1501223628"
AND av.ProductID IN (402))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "SP 431 PR"
AND av.ProductID IN (402))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "SC 7046 P"
AND av.ProductID IN (9))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "ST 6120"
AND av.ProductID IN (9))
OR
(av.SupplierID = 27
AND av.DataSupplierArticleNumber = "4829"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4768
AND av.DataSupplierArticleNumber = "S30005"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4768
AND av.DataSupplierArticleNumber = "S30014"
AND av.ProductID IN (9))
OR
(av.SupplierID = 50
AND av.DataSupplierArticleNumber = "VKMA 02194"
AND av.ProductID IN (307))
OR
(av.SupplierID = 50
AND av.DataSupplierArticleNumber = "VKM 12174"
AND av.ProductID IN (308))
OR
(av.SupplierID = 110
AND av.DataSupplierArticleNumber = "KD458.56"
AND av.ProductID IN (307))
OR
(av.SupplierID = 110
AND av.DataSupplierArticleNumber = "GT358.30"
AND av.ProductID IN (308))
OR
(av.SupplierID = 142
AND av.DataSupplierArticleNumber = "S 6H2O NE"
AND av.ProductID IN (9))
OR
(av.SupplierID = 142
AND av.DataSupplierArticleNumber = "S 1ONE NR"
AND av.ProductID IN (9))
OR
(av.SupplierID = 142
AND av.DataSupplierArticleNumber = "S 5139 GC"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4348
AND av.DataSupplierArticleNumber = "SM-FFG014"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "21-00726-SX"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "893 000-SX"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "03-40052-SX"
AND av.ProductID IN (308))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "899 000B-SX"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "21-00477-SX"
AND av.ProductID IN (9))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "70 93 0757"
AND av.ProductID IN (9))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "70 03 0029"
AND av.ProductID IN (308))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "70 92 8305"
AND av.ProductID IN (307))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "40 91 6492"
AND av.ProductID IN (402))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "70 92 8306"
AND av.ProductID IN (306))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "70 91 6852"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4011
AND av.DataSupplierArticleNumber = "GS010026-E"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4011
AND av.DataSupplierArticleNumber = "GS24/01"
AND av.ProductID IN (9))
OR
(av.SupplierID = 91
AND av.DataSupplierArticleNumber = "N311A"
AND av.ProductID IN (9))
OR
(av.SupplierID = 91
AND av.DataSupplierArticleNumber = "RN260"
AND av.ProductID IN (9))
OR
(av.SupplierID = 39
AND av.DataSupplierArticleNumber = "2373807"
AND av.ProductID IN (402))
OR
(av.SupplierID = 39
AND av.DataSupplierArticleNumber = "2434801"
AND av.ProductID IN (402))
OR
(av.SupplierID = 301
AND av.DataSupplierArticleNumber = "206 912"
AND av.ProductID IN (306))
OR
(av.SupplierID = 301
AND av.DataSupplierArticleNumber = "207 045"
AND av.ProductID IN (9))
OR
(av.SupplierID = 301
AND av.DataSupplierArticleNumber = "206 919"
AND av.ProductID IN (308))
OR
(av.SupplierID = 301
AND av.DataSupplierArticleNumber = "207 473"
AND av.ProductID IN (402))
OR
(av.SupplierID = 108
AND av.DataSupplierArticleNumber = "8645 5650xs"
AND av.ProductID IN (306))
OR
(av.SupplierID = 108
AND av.DataSupplierArticleNumber = "8647 10083"
AND av.ProductID IN (307))
OR
(av.SupplierID = 108
AND av.DataSupplierArticleNumber = "8110 15043"
AND av.ProductID IN (402))
OR
(av.SupplierID = 108
AND av.DataSupplierArticleNumber = "8646 15117"
AND av.ProductID IN (308))
OR
(av.SupplierID = 108
AND av.DataSupplierArticleNumber = "8110 24020"
AND av.ProductID IN (402))
OR
(av.SupplierID = 108
AND av.DataSupplierArticleNumber = "8646 10138"
AND av.ProductID IN (308))
OR
(av.SupplierID = 199
AND av.DataSupplierArticleNumber = "556.4"
AND av.ProductID IN (402))
OR
(av.SupplierID = 199
AND av.DataSupplierArticleNumber = "722.0"
AND av.ProductID IN (402))
OR
(av.SupplierID = 199
AND av.DataSupplierArticleNumber = "556.0"
AND av.ProductID IN (402))
OR
(av.SupplierID = 161
AND av.DataSupplierArticleNumber = "GDB1637"
AND av.ProductID IN (402))
OR
(av.SupplierID = 161
AND av.DataSupplierArticleNumber = "GDB1613"
AND av.ProductID IN (402))
OR
(av.SupplierID = 137
AND av.DataSupplierArticleNumber = "60.H2O.00"
AND av.ProductID IN (9))
OR
(av.SupplierID = 137
AND av.DataSupplierArticleNumber = "24.ONE.01"
AND av.ProductID IN (9))
OR
(av.SupplierID = 137
AND av.DataSupplierArticleNumber = "55.139.00"
AND av.ProductID IN (9))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V40-0655"
AND av.ProductID IN (308))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V40-8027-1"
AND av.ProductID IN (402))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V24-0103"
AND av.ProductID IN (402))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V24-0153"
AND av.ProductID IN (402))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V24-0222"
AND av.ProductID IN (9))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V40-8027"
AND av.ProductID IN (402))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V40-0611"
AND av.ProductID IN (9))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "598727"
AND av.ProductID IN (402))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "598793"
AND av.ProductID IN (402))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "587914"
AND av.ProductID IN (9))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "301678"
AND av.ProductID IN (402))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "601118"
AND av.ProductID IN (402))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "598678"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4425
AND av.DataSupplierArticleNumber = "837971"
AND av.ProductID IN (402,402))
OR
(av.SupplierID = 4425
AND av.DataSupplierArticleNumber = "65018063"
AND av.ProductID IN (308,308))
OR
(av.SupplierID = 179
AND av.DataSupplierArticleNumber = "G1616H"
AND av.ProductID IN (306))
OR
(av.SupplierID = 179
AND av.DataSupplierArticleNumber = "K1G1616H"
AND av.ProductID IN (307))
OR
(av.SupplierID = 456
AND av.DataSupplierArticleNumber = "626.1216"
AND av.ProductID IN (402))
OR
(av.SupplierID = 456
AND av.DataSupplierArticleNumber = "626.1218"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4498
AND av.DataSupplierArticleNumber = "WBP23402B"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4498
AND av.DataSupplierArticleNumber = "WBP24348A"
AND av.ProductID IN (402))
OR
(av.SupplierID = 482
AND av.DataSupplierArticleNumber = "151-1988"
AND av.ProductID IN (402))
OR
(av.SupplierID = 482
AND av.DataSupplierArticleNumber = "151-2003"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1151204"
AND av.ProductID IN (306))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1431589"
AND av.ProductID IN (307))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1431617"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1252643"
AND av.ProductID IN (308))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1018982"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1431590"
AND av.ProductID IN (306))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1142105"
AND av.ProductID IN (307))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1431483"
AND av.ProductID IN (308))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1215064"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1252050"
AND av.ProductID IN (307))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1215161"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1097446"
AND av.ProductID IN (308))
OR
(av.SupplierID = 324
AND av.DataSupplierArticleNumber = "WF8408"
AND av.ProductID IN (9))
OR
(av.SupplierID = 324
AND av.DataSupplierArticleNumber = "WF8366"
AND av.ProductID IN (9))
OR
(av.SupplierID = 366
AND av.DataSupplierArticleNumber = "P9883.00"
AND av.ProductID IN (402))
OR
(av.SupplierID = 366
AND av.DataSupplierArticleNumber = "P10783.00"
AND av.ProductID IN (402))
OR
(av.SupplierID = 366
AND av.DataSupplierArticleNumber = "P9793.31"
AND av.ProductID IN (402))
OR
(av.SupplierID = 4894
AND av.DataSupplierArticleNumber = "KF-5010E"
AND av.ProductID IN (9))
OR
(av.SupplierID = 4894
AND av.DataSupplierArticleNumber = "BS-2829"
AND av.ProductID IN (402))
OR
(av.SupplierID = 86
AND av.DataSupplierArticleNumber = "24348.160.1"
AND av.ProductID IN (402))
OR
(av.SupplierID = 86
AND av.DataSupplierArticleNumber = "24348.160.2"
AND av.ProductID IN (402))
OR
(av.SupplierID = 86
AND av.DataSupplierArticleNumber = "23402.200.1"
AND av.ProductID IN (402))
OR
(av.SupplierID = 86
AND av.DataSupplierArticleNumber = "23402.200.3"
AND av.ProductID IN (402))
)
UNION ALL
SELECT
CONCAT(aa.SupplierID, "^", aa.DataSupplierArticleNumber)
as article_id,
if (aa.Description = "", aa.DisplayTitle, aa.Description)
as crit_designation,
aa.DisplayValue as crit_value,
"" crit_unit,
1 criteria_art,
"articleattributes" as source
FROM articleattributes aa
WHERE
(
(aa.SupplierID = 4814
AND aa.DataSupplierArticleNumber = "D20148")
OR
(aa.SupplierID = 4814
AND aa.DataSupplierArticleNumber = "D20388")
OR
(aa.SupplierID = 4598
AND aa.DataSupplierArticleNumber = "13408")
OR
(aa.SupplierID = 4997
AND aa.DataSupplierArticleNumber = "YD106036")
OR
(aa.SupplierID = 206
AND aa.DataSupplierArticleNumber = "37496")
OR
(aa.SupplierID = 206
AND aa.DataSupplierArticleNumber = "37300")
OR
(aa.SupplierID = 4426
AND aa.DataSupplierArticleNumber = "C2X013ABE")
OR
(aa.SupplierID = 4426
AND aa.DataSupplierArticleNumber = "C1X024ABE")
OR
(aa.SupplierID = 4426
AND aa.DataSupplierArticleNumber = "C2F011ABE")
OR
(aa.SupplierID = 4533
AND aa.DataSupplierArticleNumber = "112728")
OR
(aa.SupplierID = 166
AND aa.DataSupplierArticleNumber = "BPFI-1021")
OR
(aa.SupplierID = 180
AND aa.DataSupplierArticleNumber = "SP-1421")
OR
(aa.SupplierID = 180
AND aa.DataSupplierArticleNumber = "MD-577")
OR
(aa.SupplierID = 257
AND aa.DataSupplierArticleNumber = "30-ECO016")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "0399-1308")
OR
(aa.SupplierID = 4631
AND aa.DataSupplierArticleNumber = "AKD-0325")
OR
(aa.SupplierID = 3
AND aa.DataSupplierArticleNumber = "13.0470-7172.2")
OR
(aa.SupplierID = 3
AND aa.DataSupplierArticleNumber = "13.0460-3825.2")
OR
(aa.SupplierID = 3
AND aa.DataSupplierArticleNumber = "13.0460-7172.2")
OR
(aa.SupplierID = 3
AND aa.DataSupplierArticleNumber = "13.0460-7212.2")
OR
(aa.SupplierID = 300
AND aa.DataSupplierArticleNumber = "702425")
OR
(aa.SupplierID = 300
AND aa.DataSupplierArticleNumber = "654747")
OR
(aa.SupplierID = 4737
AND aa.DataSupplierArticleNumber = "ZK1061")
OR
(aa.SupplierID = 4651
AND aa.DataSupplierArticleNumber = "03.300")
OR
(aa.SupplierID = 4651
AND aa.DataSupplierArticleNumber = "04.5282")
OR
(aa.SupplierID = 4337
AND aa.DataSupplierArticleNumber = "G50")
OR
(aa.SupplierID = 4337
AND aa.DataSupplierArticleNumber = "G78")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "KAT1427")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "A04764")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "KATW1427")
OR
(aa.SupplierID = 394
AND aa.DataSupplierArticleNumber = "BA2236")
OR
(aa.SupplierID = 478
AND aa.DataSupplierArticleNumber = "TB9504K")
OR
(aa.SupplierID = 350
AND aa.DataSupplierArticleNumber = "ADK82327")
OR
(aa.SupplierID = 350
AND aa.DataSupplierArticleNumber = "ADL142301")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BBP1992")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BFF8051")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BFF8002")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 986 494 044")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "1 457 070 001")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "1 987 949 644")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "1 987 948 939")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 986 494 073")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "F 026 402 076")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 986 494 125")
OR
(aa.SupplierID = 4993
AND aa.DataSupplierArticleNumber = "AA0251")
OR
(aa.SupplierID = 4993
AND aa.DataSupplierArticleNumber = "AA0045")
OR
(aa.SupplierID = 281
AND aa.DataSupplierArticleNumber = "23402 00 701 00")
OR
(aa.SupplierID = 195
AND aa.DataSupplierArticleNumber = "KCD0319")
OR
(aa.SupplierID = 65
AND aa.DataSupplierArticleNumber = "P 23 100")
OR
(aa.SupplierID = 65
AND aa.DataSupplierArticleNumber = "P 23 101")
OR
(aa.SupplierID = 4872
AND aa.DataSupplierArticleNumber = "BP3014")
OR
(aa.SupplierID = 4578
AND aa.DataSupplierArticleNumber = "PBTK528")
OR
(aa.SupplierID = 4455
AND aa.DataSupplierArticleNumber = "BSG 65-130-002")
OR
(aa.SupplierID = 4463
AND aa.DataSupplierArticleNumber = "0354KFW")
OR
(aa.SupplierID = 4463
AND aa.DataSupplierArticleNumber = "77560")
OR
(aa.SupplierID = 4463
AND aa.DataSupplierArticleNumber = "0354KF")
OR
(aa.SupplierID = 243
AND aa.DataSupplierArticleNumber = "DKS04.5282")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "L409/606")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "L502/606")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "CFF100409")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "CFF100502")
OR
(aa.SupplierID = 311
AND aa.DataSupplierArticleNumber = "822-540-0")
OR
(aa.SupplierID = 311
AND aa.DataSupplierArticleNumber = "822-540-4")
OR
(aa.SupplierID = 311
AND aa.DataSupplierArticleNumber = "822-706-0")
OR
(aa.SupplierID = 163
AND aa.DataSupplierArticleNumber = "DNW1999")
OR
(aa.SupplierID = 163
AND aa.DataSupplierArticleNumber = "MG1677")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "CBP01630")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "ADB01137")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "EFF156")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "ADB01630")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "EFF201")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "CBP01137")
OR
(aa.SupplierID = 31
AND aa.DataSupplierArticleNumber = "CT1106")
OR
(aa.SupplierID = 31
AND aa.DataSupplierArticleNumber = "CT1106K1")
OR
(aa.SupplierID = 437
AND aa.DataSupplierArticleNumber = "FA5757A")
OR
(aa.SupplierID = 437
AND aa.DataSupplierArticleNumber = "FP5759HWS")
OR
(aa.SupplierID = 42
AND aa.DataSupplierArticleNumber = "94987")
OR
(aa.SupplierID = 42
AND aa.DataSupplierArticleNumber = "KTB458")
OR
(aa.SupplierID = 42
AND aa.DataSupplierArticleNumber = "ATB2547")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "LP1964")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "KDB458")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "HDF608")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "TB6178")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "LP1723")
OR
(aa.SupplierID = 186
AND aa.DataSupplierArticleNumber = "A120184")
OR
(aa.SupplierID = 186
AND aa.DataSupplierArticleNumber = "A120262")
OR
(aa.SupplierID = 4519
AND aa.DataSupplierArticleNumber = "BP2072")
OR
(aa.SupplierID = 154
AND aa.DataSupplierArticleNumber = "06KD042")
OR
(aa.SupplierID = 154
AND aa.DataSupplierArticleNumber = "06KD043")
OR
(aa.SupplierID = 154
AND aa.DataSupplierArticleNumber = "05KD036")
OR
(aa.SupplierID = 4948
AND aa.DataSupplierArticleNumber = "DP1110.13.0072")
OR
(aa.SupplierID = 4948
AND aa.DataSupplierArticleNumber = "DP1010.10.0867")
OR
(aa.SupplierID = 4948
AND aa.DataSupplierArticleNumber = "DP1110.13.0068")
OR
(aa.SupplierID = 266
AND aa.DataSupplierArticleNumber = "DBP234188")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DBP1797")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DFFL567")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DBP4188")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DT12174")
OR
(aa.SupplierID = 4770
AND aa.DataSupplierArticleNumber = "5502222379")
OR
(aa.SupplierID = 4770
AND aa.DataSupplierArticleNumber = "5502223628")
OR
(aa.SupplierID = 267
AND aa.DataSupplierArticleNumber = "TBK493")
OR
(aa.SupplierID = 267
AND aa.DataSupplierArticleNumber = "24190")
OR
(aa.SupplierID = 267
AND aa.DataSupplierArticleNumber = "T9379")
OR
(aa.SupplierID = 4834
AND aa.DataSupplierArticleNumber = "14859")
OR
(aa.SupplierID = 4938
AND aa.DataSupplierArticleNumber = "FT44026")
OR
(aa.SupplierID = 4938
AND aa.DataSupplierArticleNumber = "FT29159")
OR
(aa.SupplierID = 4938
AND aa.DataSupplierArticleNumber = "FT39047")
OR
(aa.SupplierID = 4938
AND aa.DataSupplierArticleNumber = "FT39051")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "30757")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "16492")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "10298")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "28306")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "28305")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "16852")
OR
(aa.SupplierID = 271
AND aa.DataSupplierArticleNumber = "BP43073")
OR
(aa.SupplierID = 62
AND aa.DataSupplierArticleNumber = "FDB4188")
OR
(aa.SupplierID = 62
AND aa.DataSupplierArticleNumber = "FDB1797")
OR
(aa.SupplierID = 4986
AND aa.DataSupplierArticleNumber = "FCP1520H")
OR
(aa.SupplierID = 4838
AND aa.DataSupplierArticleNumber = "FBP4113")
OR
(aa.SupplierID = 4838
AND aa.DataSupplierArticleNumber = "FK-773")
OR
(aa.SupplierID = 4838
AND aa.DataSupplierArticleNumber = "FK-781")
OR
(aa.SupplierID = 4659
AND aa.DataSupplierArticleNumber = "ZP 8083 FM")
OR
(aa.SupplierID = 4659
AND aa.DataSupplierArticleNumber = "KFE 1460")
OR
(aa.SupplierID = 4659
AND aa.DataSupplierArticleNumber = "KFE 1460 V")
OR
(aa.SupplierID = 4659
AND aa.DataSupplierArticleNumber = "MFE 1558 MB")
OR
(aa.SupplierID = 256
AND aa.DataSupplierArticleNumber = "PE982")
OR
(aa.SupplierID = 256
AND aa.DataSupplierArticleNumber = "PP966/3")
OR
(aa.SupplierID = 441
AND aa.DataSupplierArticleNumber = "4829")
OR
(aa.SupplierID = 4937
AND aa.DataSupplierArticleNumber = "FP0972")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "F904549V")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "FS01063")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "F914549V")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "4549V")
OR
(aa.SupplierID = 4887
AND aa.DataSupplierArticleNumber = "FO 689581")
OR
(aa.SupplierID = 4887
AND aa.DataSupplierArticleNumber = "FO 847181")
OR
(aa.SupplierID = 59
AND aa.DataSupplierArticleNumber = "PS10042")
OR
(aa.SupplierID = 59
AND aa.DataSupplierArticleNumber = "C10026A")
OR
(aa.SupplierID = 409
AND aa.DataSupplierArticleNumber = "FBP-1265")
OR
(aa.SupplierID = 409
AND aa.DataSupplierArticleNumber = "FBP-1475")
OR
(aa.SupplierID = 409
AND aa.DataSupplierArticleNumber = "FBP-1618")
OR
(aa.SupplierID = 295
AND aa.DataSupplierArticleNumber = "722.0")
OR
(aa.SupplierID = 295
AND aa.DataSupplierArticleNumber = "556.0")
OR
(aa.SupplierID = 295
AND aa.DataSupplierArticleNumber = "556.4")
OR
(aa.SupplierID = 313
AND aa.DataSupplierArticleNumber = "FL04.402")
OR
(aa.SupplierID = 313
AND aa.DataSupplierArticleNumber = "PD07.503")
OR
(aa.SupplierID = 313
AND aa.DataSupplierArticleNumber = "FL04.404")
OR
(aa.SupplierID = 54
AND aa.DataSupplierArticleNumber = "BL2519A1")
OR
(aa.SupplierID = 54
AND aa.DataSupplierArticleNumber = "BL1817A2")
OR
(aa.SupplierID = 4844
AND aa.DataSupplierArticleNumber = "GBP088800")
OR
(aa.SupplierID = 500
AND aa.DataSupplierArticleNumber = "B1.G102-0650.2")
OR
(aa.SupplierID = 500
AND aa.DataSupplierArticleNumber = "B1.G102-0672.2")
OR
(aa.SupplierID = 500
AND aa.DataSupplierArticleNumber = "B1.G102-0836.2")
OR
(aa.SupplierID = 33
AND aa.DataSupplierArticleNumber = "T43211")
OR
(aa.SupplierID = 33
AND aa.DataSupplierArticleNumber = "5650XS")
OR
(aa.SupplierID = 33
AND aa.DataSupplierArticleNumber = "K025650XS")
OR
(aa.SupplierID = 368
AND aa.DataSupplierArticleNumber = "PUKD042")
OR
(aa.SupplierID = 368
AND aa.DataSupplierArticleNumber = "COKD036")
OR
(aa.SupplierID = 368
AND aa.DataSupplierArticleNumber = "PUKD043")
OR
(aa.SupplierID = 279
AND aa.DataSupplierArticleNumber = "6116132")
OR
(aa.SupplierID = 279
AND aa.DataSupplierArticleNumber = "6116371")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8DB 355 009-311")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8DB 355 012-411")
OR
(aa.SupplierID = 4625
AND aa.DataSupplierArticleNumber = "8DB 355 012-411")
OR
(aa.SupplierID = 4625
AND aa.DataSupplierArticleNumber = "8DB 355 009-311")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "E83KP02 D140")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "H340WK")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "E83KP D140")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "E83KP01 D140")
OR
(aa.SupplierID = 178
AND aa.DataSupplierArticleNumber = "20-1420")
OR
(aa.SupplierID = 55
AND aa.DataSupplierArticleNumber = "J1338027")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "4915")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "4499")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "4829")
OR
(aa.SupplierID = 4998
AND aa.DataSupplierArticleNumber = "HP8382")
OR
(aa.SupplierID = 239
AND aa.DataSupplierArticleNumber = "HTG 135")
OR
(aa.SupplierID = 239
AND aa.DataSupplierArticleNumber = "KH 493")
OR
(aa.SupplierID = 239
AND aa.DataSupplierArticleNumber = "190 HTDP/T 24")
OR
(aa.SupplierID = 158
AND aa.DataSupplierArticleNumber = "181536")
OR
(aa.SupplierID = 158
AND aa.DataSupplierArticleNumber = "181763")
OR
(aa.SupplierID = 204
AND aa.DataSupplierArticleNumber = "531 0844 10")
OR
(aa.SupplierID = 204
AND aa.DataSupplierArticleNumber = "530 0435 10")
OR
(aa.SupplierID = 204
AND aa.DataSupplierArticleNumber = "531 0255 30")
OR
(aa.SupplierID = 204
AND aa.DataSupplierArticleNumber = "530 0624 10")
OR
(aa.SupplierID = 262
AND aa.DataSupplierArticleNumber = "15-3742")
OR
(aa.SupplierID = 262
AND aa.DataSupplierArticleNumber = "20-1420")
OR
(aa.SupplierID = 459
AND aa.DataSupplierArticleNumber = "IFG-3886")
OR
(aa.SupplierID = 156
AND aa.DataSupplierArticleNumber = "FC-ECO016")
OR
(aa.SupplierID = 481
AND aa.DataSupplierArticleNumber = "3ECO016")
OR
(aa.SupplierID = 4689
AND aa.DataSupplierArticleNumber = "B3F038PR")
OR
(aa.SupplierID = 4689
AND aa.DataSupplierArticleNumber = "B3F036PR")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1218700500")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1212201509")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1263603119")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1212104910")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "3363700319")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1212104919")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1212102209")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1212201500")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1263603110")
OR
(aa.SupplierID = 4935
AND aa.DataSupplierArticleNumber = "JCP1474")
OR
(aa.SupplierID = 4935
AND aa.DataSupplierArticleNumber = "JCP1797")
OR
(aa.SupplierID = 48
AND aa.DataSupplierArticleNumber = "573089JC")
OR
(aa.SupplierID = 48
AND aa.DataSupplierArticleNumber = "573307J")
OR
(aa.SupplierID = 48
AND aa.DataSupplierArticleNumber = "573089D")
OR
(aa.SupplierID = 48
AND aa.DataSupplierArticleNumber = "573089J")
OR
(aa.SupplierID = 4461
AND aa.DataSupplierArticleNumber = "FC1181")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "JQ1013594")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "R0241")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "F301601")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "F305701")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "JQ1013040")
OR
(aa.SupplierID = 286
AND aa.DataSupplierArticleNumber = "810071")
OR
(aa.SupplierID = 286
AND aa.DataSupplierArticleNumber = "0879 31")
OR
(aa.SupplierID = 286
AND aa.DataSupplierArticleNumber = "0888 00")
OR
(aa.SupplierID = 286
AND aa.DataSupplierArticleNumber = "1178 00")
OR
(aa.SupplierID = 4462
AND aa.DataSupplierArticleNumber = "KFI354")
OR
(aa.SupplierID = 4462
AND aa.DataSupplierArticleNumber = "WKFI354")
OR
(aa.SupplierID = 4462
AND aa.DataSupplierArticleNumber = "FI11910")
OR
(aa.SupplierID = 34
AND aa.DataSupplierArticleNumber = "KL 567")
OR
(aa.SupplierID = 432
AND aa.DataSupplierArticleNumber = "50014136")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "1726860")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "6001720")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "6008533")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "1223350")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "6013015")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "1723002")
OR
(aa.SupplierID = 197
AND aa.DataSupplierArticleNumber = "05P1218")
OR
(aa.SupplierID = 197
AND aa.DataSupplierArticleNumber = "05P1524")
OR
(aa.SupplierID = 197
AND aa.DataSupplierArticleNumber = "05P1216")
OR
(aa.SupplierID = 424
AND aa.DataSupplierArticleNumber = "LA0207")
OR
(aa.SupplierID = 424
AND aa.DataSupplierArticleNumber = "LDK0368")
OR
(aa.SupplierID = 424
AND aa.DataSupplierArticleNumber = "LA0208")
OR
(aa.SupplierID = 424
AND aa.DataSupplierArticleNumber = "LA0206")
OR
(aa.SupplierID = 4973
AND aa.DataSupplierArticleNumber = "LFDE150")
OR
(aa.SupplierID = 4973
AND aa.DataSupplierArticleNumber = "LFDF178")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "PB-1255")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "PK-1348")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "LF-1811")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "LF-1814")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "340018181049")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "341303980000")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "363916060225")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "341310491201")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "153071760155")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "363916060162")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "153071760527")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "KL 567")
OR
(aa.SupplierID = 317
AND aa.DataSupplierArticleNumber = "1050187")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "WK 853/21")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "PU 723 x")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "23720")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "63236")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "43720")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "63029")
OR
(aa.SupplierID = 358
AND aa.DataSupplierArticleNumber = "13046071722N-SET-MS")
OR
(aa.SupplierID = 358
AND aa.DataSupplierArticleNumber = "723X-KF-PCS-MS")
OR
(aa.SupplierID = 358
AND aa.DataSupplierArticleNumber = "853/21-KF-PCS-MS")
OR
(aa.SupplierID = 358
AND aa.DataSupplierArticleNumber = "13046071722-SET-MS")
OR
(aa.SupplierID = 358
AND aa.DataSupplierArticleNumber = "208DK-KF-PCS-MS")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "26-0667")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "26-0033")
OR
(aa.SupplierID = 4773
AND aa.DataSupplierArticleNumber = "MFF-3E16")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "4499")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "4829")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "4915")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "ELG5327")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "ELG5322")
OR
(aa.SupplierID = 121
AND aa.DataSupplierArticleNumber = "22-0540-4")
OR
(aa.SupplierID = 121
AND aa.DataSupplierArticleNumber = "22-0706-0")
OR
(aa.SupplierID = 121
AND aa.DataSupplierArticleNumber = "22-0540-0")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "1170100")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "WM-Z 621")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "214 323 0004")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "614 323 0004")
OR
(aa.SupplierID = 462
AND aa.DataSupplierArticleNumber = "DE 3118")
OR
(aa.SupplierID = 462
AND aa.DataSupplierArticleNumber = "DF 3531")
OR
(aa.SupplierID = 73
AND aa.DataSupplierArticleNumber = "MDB2262")
OR
(aa.SupplierID = 73
AND aa.DataSupplierArticleNumber = "MDB2800")
OR
(aa.SupplierID = 4470
AND aa.DataSupplierArticleNumber = "F116")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "VFF500")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "VFF551")
OR
(aa.SupplierID = 490
AND aa.DataSupplierArticleNumber = "FN388")
OR
(aa.SupplierID = 490
AND aa.DataSupplierArticleNumber = "FN148")
OR
(aa.SupplierID = 190
AND aa.DataSupplierArticleNumber = "NP2016")
OR
(aa.SupplierID = 4682
AND aa.DataSupplierArticleNumber = "PN0325")
OR
(aa.SupplierID = 248
AND aa.DataSupplierArticleNumber = "J1338031")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "222379")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "223628")
OR
(aa.SupplierID = 440
AND aa.DataSupplierArticleNumber = "S133I04")
OR
(aa.SupplierID = 440
AND aa.DataSupplierArticleNumber = "S112I16")
OR
(aa.SupplierID = 4380
AND aa.DataSupplierArticleNumber = "2136691")
OR
(aa.SupplierID = 4380
AND aa.DataSupplierArticleNumber = "2135196")
OR
(aa.SupplierID = 4380
AND aa.DataSupplierArticleNumber = "2136743")
OR
(aa.SupplierID = 64
AND aa.DataSupplierArticleNumber = "371ST")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "88800")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "FF-01204")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "SK-1696")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "0-N115")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PT12174")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PF3152")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PF3269")
OR
(aa.SupplierID = 4686
AND aa.DataSupplierArticleNumber = "1530-2520")
OR
(aa.SupplierID = 4686
AND aa.DataSupplierArticleNumber = "1530-2543")
OR
(aa.SupplierID = 4520
AND aa.DataSupplierArticleNumber = "PRP1408")
OR
(aa.SupplierID = 4520
AND aa.DataSupplierArticleNumber = "PRP1409")
OR
(aa.SupplierID = 4520
AND aa.DataSupplierArticleNumber = "PRP0482")
OR
(aa.SupplierID = 4520
AND aa.DataSupplierArticleNumber = "PRP1410")
OR
(aa.SupplierID = 4520
AND aa.DataSupplierArticleNumber = "PRP1228")
OR
(aa.SupplierID = 38
AND aa.DataSupplierArticleNumber = "C507A")
OR
(aa.SupplierID = 38
AND aa.DataSupplierArticleNumber = "FCS722")
OR
(aa.SupplierID = 4821
AND aa.DataSupplierArticleNumber = "QP0935")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "MBP1366")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QBK658")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QFF0278")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "MBP1509")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QTB544")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "BP1366")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QFF0299")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "BP1509")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "MBK658")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QTT841")
OR
(aa.SupplierID = 4955
AND aa.DataSupplierArticleNumber = "RB1763")
OR
(aa.SupplierID = 4955
AND aa.DataSupplierArticleNumber = "RB1536")
OR
(aa.SupplierID = 400
AND aa.DataSupplierArticleNumber = "RA.0904.0")
OR
(aa.SupplierID = 400
AND aa.DataSupplierArticleNumber = "RA.0797.1")
OR
(aa.SupplierID = 153
AND aa.DataSupplierArticleNumber = "0879.31")
OR
(aa.SupplierID = 153
AND aa.DataSupplierArticleNumber = "0888.00")
OR
(aa.SupplierID = 153
AND aa.DataSupplierArticleNumber = "1178.00")
OR
(aa.SupplierID = 4330
AND aa.DataSupplierArticleNumber = "RKT1306")
OR
(aa.SupplierID = 4330
AND aa.DataSupplierArticleNumber = "RKTK1093")
OR
(aa.SupplierID = 152
AND aa.DataSupplierArticleNumber = "21178.00")
OR
(aa.SupplierID = 152
AND aa.DataSupplierArticleNumber = "2879.31")
OR
(aa.SupplierID = 152
AND aa.DataSupplierArticleNumber = "2888.00")
OR
(aa.SupplierID = 100
AND aa.DataSupplierArticleNumber = "RR1049")
OR
(aa.SupplierID = 23
AND aa.DataSupplierArticleNumber = "5603677")
OR
(aa.SupplierID = 23
AND aa.DataSupplierArticleNumber = "55844")
OR
(aa.SupplierID = 23
AND aa.DataSupplierArticleNumber = "5584475")
OR
(aa.SupplierID = 23
AND aa.DataSupplierArticleNumber = "56036")
OR
(aa.SupplierID = 260
AND aa.DataSupplierArticleNumber = "1766005")
OR
(aa.SupplierID = 260
AND aa.DataSupplierArticleNumber = "1756008")
OR
(aa.SupplierID = 260
AND aa.DataSupplierArticleNumber = "1706007")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "1501222379")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "1501223628")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "SP 431 PR")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "SC 7046 P")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "ST 6120")
OR
(aa.SupplierID = 27
AND aa.DataSupplierArticleNumber = "4829")
OR
(aa.SupplierID = 4768
AND aa.DataSupplierArticleNumber = "S30005")
OR
(aa.SupplierID = 4768
AND aa.DataSupplierArticleNumber = "S30014")
OR
(aa.SupplierID = 50
AND aa.DataSupplierArticleNumber = "VKMA 02194")
OR
(aa.SupplierID = 50
AND aa.DataSupplierArticleNumber = "VKM 12174")
OR
(aa.SupplierID = 110
AND aa.DataSupplierArticleNumber = "KD458.56")
OR
(aa.SupplierID = 110
AND aa.DataSupplierArticleNumber = "GT358.30")
OR
(aa.SupplierID = 142
AND aa.DataSupplierArticleNumber = "S 6H2O NE")
OR
(aa.SupplierID = 142
AND aa.DataSupplierArticleNumber = "S 1ONE NR")
OR
(aa.SupplierID = 142
AND aa.DataSupplierArticleNumber = "S 5139 GC")
OR
(aa.SupplierID = 4348
AND aa.DataSupplierArticleNumber = "SM-FFG014")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "21-00726-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "893 000-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "03-40052-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "899 000B-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "21-00477-SX")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "70 93 0757")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "70 03 0029")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "70 92 8305")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "40 91 6492")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "70 92 8306")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "70 91 6852")
OR
(aa.SupplierID = 4011
AND aa.DataSupplierArticleNumber = "GS010026-E")
OR
(aa.SupplierID = 4011
AND aa.DataSupplierArticleNumber = "GS24/01")
OR
(aa.SupplierID = 91
AND aa.DataSupplierArticleNumber = "N311A")
OR
(aa.SupplierID = 91
AND aa.DataSupplierArticleNumber = "RN260")
OR
(aa.SupplierID = 39
AND aa.DataSupplierArticleNumber = "2373807")
OR
(aa.SupplierID = 39
AND aa.DataSupplierArticleNumber = "2434801")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "206 912")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "207 045")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "206 919")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "207 473")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8645 5650xs")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8647 10083")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8110 15043")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8646 15117")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8110 24020")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8646 10138")
OR
(aa.SupplierID = 199
AND aa.DataSupplierArticleNumber = "556.4")
OR
(aa.SupplierID = 199
AND aa.DataSupplierArticleNumber = "722.0")
OR
(aa.SupplierID = 199
AND aa.DataSupplierArticleNumber = "556.0")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "GDB1637")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "GDB1613")
OR
(aa.SupplierID = 137
AND aa.DataSupplierArticleNumber = "60.H2O.00")
OR
(aa.SupplierID = 137
AND aa.DataSupplierArticleNumber = "24.ONE.01")
OR
(aa.SupplierID = 137
AND aa.DataSupplierArticleNumber = "55.139.00")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V40-0655")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V40-8027-1")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V24-0103")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V24-0153")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V24-0222")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V40-8027")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V40-0611")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "598727")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "598793")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "587914")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "301678")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "601118")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "598678")
OR
(aa.SupplierID = 4425
AND aa.DataSupplierArticleNumber = "837971")
OR
(aa.SupplierID = 4425
AND aa.DataSupplierArticleNumber = "65018063")
OR
(aa.SupplierID = 179
AND aa.DataSupplierArticleNumber = "G1616H")
OR
(aa.SupplierID = 179
AND aa.DataSupplierArticleNumber = "K1G1616H")
OR
(aa.SupplierID = 456
AND aa.DataSupplierArticleNumber = "626.1216")
OR
(aa.SupplierID = 456
AND aa.DataSupplierArticleNumber = "626.1218")
OR
(aa.SupplierID = 4498
AND aa.DataSupplierArticleNumber = "WBP23402B")
OR
(aa.SupplierID = 4498
AND aa.DataSupplierArticleNumber = "WBP24348A")
OR
(aa.SupplierID = 482
AND aa.DataSupplierArticleNumber = "151-1988")
OR
(aa.SupplierID = 482
AND aa.DataSupplierArticleNumber = "151-2003")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1151204")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1431589")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1431617")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1252643")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1018982")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1431590")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1142105")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1431483")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1215064")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1252050")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1215161")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1097446")
OR
(aa.SupplierID = 324
AND aa.DataSupplierArticleNumber = "WF8408")
OR
(aa.SupplierID = 324
AND aa.DataSupplierArticleNumber = "WF8366")
OR
(aa.SupplierID = 366
AND aa.DataSupplierArticleNumber = "P9883.00")
OR
(aa.SupplierID = 366
AND aa.DataSupplierArticleNumber = "P10783.00")
OR
(aa.SupplierID = 366
AND aa.DataSupplierArticleNumber = "P9793.31")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "KF-5010E")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "BS-2829")
OR
(aa.SupplierID = 86
AND aa.DataSupplierArticleNumber = "24348.160.1")
OR
(aa.SupplierID = 86
AND aa.DataSupplierArticleNumber = "24348.160.2")
OR
(aa.SupplierID = 86
AND aa.DataSupplierArticleNumber = "23402.200.1")
OR
(aa.SupplierID = 86
AND aa.DataSupplierArticleNumber = "23402.200.3")
)
AND aa.Language = "ru"
UNION ALL
SELECT
CONCAT(aa.SupplierID, "^", aa.DataSupplierArticleNumber)
as article_id,
if (aa.Description = "", aa.DisplayTitle, aa.Description)
as crit_designation,
aa.DisplayValue as crit_value,
"" crit_unit,
1 criteria_art,
"articleattributes_2018_2" as source
FROM articleattributes_2018_2 aa
WHERE
(
(aa.SupplierID = 4814
AND aa.DataSupplierArticleNumber = "D20148")
OR
(aa.SupplierID = 4814
AND aa.DataSupplierArticleNumber = "D20388")
OR
(aa.SupplierID = 4598
AND aa.DataSupplierArticleNumber = "13408")
OR
(aa.SupplierID = 4997
AND aa.DataSupplierArticleNumber = "YD106036")
OR
(aa.SupplierID = 206
AND aa.DataSupplierArticleNumber = "37496")
OR
(aa.SupplierID = 206
AND aa.DataSupplierArticleNumber = "37300")
OR
(aa.SupplierID = 4426
AND aa.DataSupplierArticleNumber = "C2X013ABE")
OR
(aa.SupplierID = 4426
AND aa.DataSupplierArticleNumber = "C1X024ABE")
OR
(aa.SupplierID = 4426
AND aa.DataSupplierArticleNumber = "C2F011ABE")
OR
(aa.SupplierID = 4533
AND aa.DataSupplierArticleNumber = "112728")
OR
(aa.SupplierID = 166
AND aa.DataSupplierArticleNumber = "BPFI-1021")
OR
(aa.SupplierID = 180
AND aa.DataSupplierArticleNumber = "SP-1421")
OR
(aa.SupplierID = 180
AND aa.DataSupplierArticleNumber = "MD-577")
OR
(aa.SupplierID = 257
AND aa.DataSupplierArticleNumber = "30-ECO016")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "0399-1308")
OR
(aa.SupplierID = 4631
AND aa.DataSupplierArticleNumber = "AKD-0325")
OR
(aa.SupplierID = 3
AND aa.DataSupplierArticleNumber = "13.0470-7172.2")
OR
(aa.SupplierID = 3
AND aa.DataSupplierArticleNumber = "13.0460-3825.2")
OR
(aa.SupplierID = 3
AND aa.DataSupplierArticleNumber = "13.0460-7172.2")
OR
(aa.SupplierID = 3
AND aa.DataSupplierArticleNumber = "13.0460-7212.2")
OR
(aa.SupplierID = 300
AND aa.DataSupplierArticleNumber = "702425")
OR
(aa.SupplierID = 300
AND aa.DataSupplierArticleNumber = "654747")
OR
(aa.SupplierID = 4737
AND aa.DataSupplierArticleNumber = "ZK1061")
OR
(aa.SupplierID = 4651
AND aa.DataSupplierArticleNumber = "03.300")
OR
(aa.SupplierID = 4651
AND aa.DataSupplierArticleNumber = "04.5282")
OR
(aa.SupplierID = 4337
AND aa.DataSupplierArticleNumber = "G50")
OR
(aa.SupplierID = 4337
AND aa.DataSupplierArticleNumber = "G78")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "KAT1427")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "A04764")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "KATW1427")
OR
(aa.SupplierID = 394
AND aa.DataSupplierArticleNumber = "BA2236")
OR
(aa.SupplierID = 478
AND aa.DataSupplierArticleNumber = "TB9504K")
OR
(aa.SupplierID = 350
AND aa.DataSupplierArticleNumber = "ADK82327")
OR
(aa.SupplierID = 350
AND aa.DataSupplierArticleNumber = "ADL142301")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BBP1992")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BFF8051")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BFF8002")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 986 494 044")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "1 457 070 001")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "1 987 949 644")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "1 987 948 939")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 986 494 073")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "F 026 402 076")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 986 494 125")
OR
(aa.SupplierID = 4993
AND aa.DataSupplierArticleNumber = "AA0251")
OR
(aa.SupplierID = 4993
AND aa.DataSupplierArticleNumber = "AA0045")
OR
(aa.SupplierID = 281
AND aa.DataSupplierArticleNumber = "23402 00 701 00")
OR
(aa.SupplierID = 195
AND aa.DataSupplierArticleNumber = "KCD0319")
OR
(aa.SupplierID = 65
AND aa.DataSupplierArticleNumber = "P 23 100")
OR
(aa.SupplierID = 65
AND aa.DataSupplierArticleNumber = "P 23 101")
OR
(aa.SupplierID = 4872
AND aa.DataSupplierArticleNumber = "BP3014")
OR
(aa.SupplierID = 4578
AND aa.DataSupplierArticleNumber = "PBTK528")
OR
(aa.SupplierID = 4455
AND aa.DataSupplierArticleNumber = "BSG 65-130-002")
OR
(aa.SupplierID = 4463
AND aa.DataSupplierArticleNumber = "0354KFW")
OR
(aa.SupplierID = 4463
AND aa.DataSupplierArticleNumber = "77560")
OR
(aa.SupplierID = 4463
AND aa.DataSupplierArticleNumber = "0354KF")
OR
(aa.SupplierID = 243
AND aa.DataSupplierArticleNumber = "DKS04.5282")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "L409/606")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "L502/606")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "CFF100409")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "CFF100502")
OR
(aa.SupplierID = 311
AND aa.DataSupplierArticleNumber = "822-540-0")
OR
(aa.SupplierID = 311
AND aa.DataSupplierArticleNumber = "822-540-4")
OR
(aa.SupplierID = 311
AND aa.DataSupplierArticleNumber = "822-706-0")
OR
(aa.SupplierID = 163
AND aa.DataSupplierArticleNumber = "DNW1999")
OR
(aa.SupplierID = 163
AND aa.DataSupplierArticleNumber = "MG1677")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "CBP01630")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "ADB01137")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "EFF156")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "ADB01630")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "EFF201")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "CBP01137")
OR
(aa.SupplierID = 31
AND aa.DataSupplierArticleNumber = "CT1106")
OR
(aa.SupplierID = 31
AND aa.DataSupplierArticleNumber = "CT1106K1")
OR
(aa.SupplierID = 437
AND aa.DataSupplierArticleNumber = "FA5757A")
OR
(aa.SupplierID = 437
AND aa.DataSupplierArticleNumber = "FP5759HWS")
OR
(aa.SupplierID = 42
AND aa.DataSupplierArticleNumber = "94987")
OR
(aa.SupplierID = 42
AND aa.DataSupplierArticleNumber = "KTB458")
OR
(aa.SupplierID = 42
AND aa.DataSupplierArticleNumber = "ATB2547")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "LP1964")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "KDB458")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "HDF608")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "TB6178")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "LP1723")
OR
(aa.SupplierID = 186
AND aa.DataSupplierArticleNumber = "A120184")
OR
(aa.SupplierID = 186
AND aa.DataSupplierArticleNumber = "A120262")
OR
(aa.SupplierID = 4519
AND aa.DataSupplierArticleNumber = "BP2072")
OR
(aa.SupplierID = 154
AND aa.DataSupplierArticleNumber = "06KD042")
OR
(aa.SupplierID = 154
AND aa.DataSupplierArticleNumber = "06KD043")
OR
(aa.SupplierID = 154
AND aa.DataSupplierArticleNumber = "05KD036")
OR
(aa.SupplierID = 4948
AND aa.DataSupplierArticleNumber = "DP1110.13.0072")
OR
(aa.SupplierID = 4948
AND aa.DataSupplierArticleNumber = "DP1010.10.0867")
OR
(aa.SupplierID = 4948
AND aa.DataSupplierArticleNumber = "DP1110.13.0068")
OR
(aa.SupplierID = 266
AND aa.DataSupplierArticleNumber = "DBP234188")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DBP1797")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DFFL567")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DBP4188")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DT12174")
OR
(aa.SupplierID = 4770
AND aa.DataSupplierArticleNumber = "5502222379")
OR
(aa.SupplierID = 4770
AND aa.DataSupplierArticleNumber = "5502223628")
OR
(aa.SupplierID = 267
AND aa.DataSupplierArticleNumber = "TBK493")
OR
(aa.SupplierID = 267
AND aa.DataSupplierArticleNumber = "24190")
OR
(aa.SupplierID = 267
AND aa.DataSupplierArticleNumber = "T9379")
OR
(aa.SupplierID = 4834
AND aa.DataSupplierArticleNumber = "14859")
OR
(aa.SupplierID = 4938
AND aa.DataSupplierArticleNumber = "FT44026")
OR
(aa.SupplierID = 4938
AND aa.DataSupplierArticleNumber = "FT29159")
OR
(aa.SupplierID = 4938
AND aa.DataSupplierArticleNumber = "FT39047")
OR
(aa.SupplierID = 4938
AND aa.DataSupplierArticleNumber = "FT39051")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "30757")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "16492")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "10298")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "28306")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "28305")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "16852")
OR
(aa.SupplierID = 271
AND aa.DataSupplierArticleNumber = "BP43073")
OR
(aa.SupplierID = 62
AND aa.DataSupplierArticleNumber = "FDB4188")
OR
(aa.SupplierID = 62
AND aa.DataSupplierArticleNumber = "FDB1797")
OR
(aa.SupplierID = 4986
AND aa.DataSupplierArticleNumber = "FCP1520H")
OR
(aa.SupplierID = 4838
AND aa.DataSupplierArticleNumber = "FBP4113")
OR
(aa.SupplierID = 4838
AND aa.DataSupplierArticleNumber = "FK-773")
OR
(aa.SupplierID = 4838
AND aa.DataSupplierArticleNumber = "FK-781")
OR
(aa.SupplierID = 4659
AND aa.DataSupplierArticleNumber = "ZP 8083 FM")
OR
(aa.SupplierID = 4659
AND aa.DataSupplierArticleNumber = "KFE 1460")
OR
(aa.SupplierID = 4659
AND aa.DataSupplierArticleNumber = "KFE 1460 V")
OR
(aa.SupplierID = 4659
AND aa.DataSupplierArticleNumber = "MFE 1558 MB")
OR
(aa.SupplierID = 256
AND aa.DataSupplierArticleNumber = "PE982")
OR
(aa.SupplierID = 256
AND aa.DataSupplierArticleNumber = "PP966/3")
OR
(aa.SupplierID = 441
AND aa.DataSupplierArticleNumber = "4829")
OR
(aa.SupplierID = 4937
AND aa.DataSupplierArticleNumber = "FP0972")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "F904549V")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "FS01063")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "F914549V")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "4549V")
OR
(aa.SupplierID = 4887
AND aa.DataSupplierArticleNumber = "FO 689581")
OR
(aa.SupplierID = 4887
AND aa.DataSupplierArticleNumber = "FO 847181")
OR
(aa.SupplierID = 59
AND aa.DataSupplierArticleNumber = "PS10042")
OR
(aa.SupplierID = 59
AND aa.DataSupplierArticleNumber = "C10026A")
OR
(aa.SupplierID = 409
AND aa.DataSupplierArticleNumber = "FBP-1265")
OR
(aa.SupplierID = 409
AND aa.DataSupplierArticleNumber = "FBP-1475")
OR
(aa.SupplierID = 409
AND aa.DataSupplierArticleNumber = "FBP-1618")
OR
(aa.SupplierID = 295
AND aa.DataSupplierArticleNumber = "722.0")
OR
(aa.SupplierID = 295
AND aa.DataSupplierArticleNumber = "556.0")
OR
(aa.SupplierID = 295
AND aa.DataSupplierArticleNumber = "556.4")
OR
(aa.SupplierID = 313
AND aa.DataSupplierArticleNumber = "FL04.402")
OR
(aa.SupplierID = 313
AND aa.DataSupplierArticleNumber = "PD07.503")
OR
(aa.SupplierID = 313
AND aa.DataSupplierArticleNumber = "FL04.404")
OR
(aa.SupplierID = 54
AND aa.DataSupplierArticleNumber = "BL2519A1")
OR
(aa.SupplierID = 54
AND aa.DataSupplierArticleNumber = "BL1817A2")
OR
(aa.SupplierID = 4844
AND aa.DataSupplierArticleNumber = "GBP088800")
OR
(aa.SupplierID = 500
AND aa.DataSupplierArticleNumber = "B1.G102-0650.2")
OR
(aa.SupplierID = 500
AND aa.DataSupplierArticleNumber = "B1.G102-0672.2")
OR
(aa.SupplierID = 500
AND aa.DataSupplierArticleNumber = "B1.G102-0836.2")
OR
(aa.SupplierID = 33
AND aa.DataSupplierArticleNumber = "T43211")
OR
(aa.SupplierID = 33
AND aa.DataSupplierArticleNumber = "5650XS")
OR
(aa.SupplierID = 33
AND aa.DataSupplierArticleNumber = "K025650XS")
OR
(aa.SupplierID = 368
AND aa.DataSupplierArticleNumber = "PUKD042")
OR
(aa.SupplierID = 368
AND aa.DataSupplierArticleNumber = "COKD036")
OR
(aa.SupplierID = 368
AND aa.DataSupplierArticleNumber = "PUKD043")
OR
(aa.SupplierID = 279
AND aa.DataSupplierArticleNumber = "6116132")
OR
(aa.SupplierID = 279
AND aa.DataSupplierArticleNumber = "6116371")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8DB 355 009-311")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8DB 355 012-411")
OR
(aa.SupplierID = 4625
AND aa.DataSupplierArticleNumber = "8DB 355 012-411")
OR
(aa.SupplierID = 4625
AND aa.DataSupplierArticleNumber = "8DB 355 009-311")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "E83KP02 D140")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "H340WK")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "E83KP D140")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "E83KP01 D140")
OR
(aa.SupplierID = 178
AND aa.DataSupplierArticleNumber = "20-1420")
OR
(aa.SupplierID = 55
AND aa.DataSupplierArticleNumber = "J1338027")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "4915")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "4499")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "4829")
OR
(aa.SupplierID = 4998
AND aa.DataSupplierArticleNumber = "HP8382")
OR
(aa.SupplierID = 239
AND aa.DataSupplierArticleNumber = "HTG 135")
OR
(aa.SupplierID = 239
AND aa.DataSupplierArticleNumber = "KH 493")
OR
(aa.SupplierID = 239
AND aa.DataSupplierArticleNumber = "190 HTDP/T 24")
OR
(aa.SupplierID = 158
AND aa.DataSupplierArticleNumber = "181536")
OR
(aa.SupplierID = 158
AND aa.DataSupplierArticleNumber = "181763")
OR
(aa.SupplierID = 204
AND aa.DataSupplierArticleNumber = "531 0844 10")
OR
(aa.SupplierID = 204
AND aa.DataSupplierArticleNumber = "530 0435 10")
OR
(aa.SupplierID = 204
AND aa.DataSupplierArticleNumber = "531 0255 30")
OR
(aa.SupplierID = 204
AND aa.DataSupplierArticleNumber = "530 0624 10")
OR
(aa.SupplierID = 262
AND aa.DataSupplierArticleNumber = "15-3742")
OR
(aa.SupplierID = 262
AND aa.DataSupplierArticleNumber = "20-1420")
OR
(aa.SupplierID = 459
AND aa.DataSupplierArticleNumber = "IFG-3886")
OR
(aa.SupplierID = 156
AND aa.DataSupplierArticleNumber = "FC-ECO016")
OR
(aa.SupplierID = 481
AND aa.DataSupplierArticleNumber = "3ECO016")
OR
(aa.SupplierID = 4689
AND aa.DataSupplierArticleNumber = "B3F038PR")
OR
(aa.SupplierID = 4689
AND aa.DataSupplierArticleNumber = "B3F036PR")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1218700500")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1212201509")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1263603119")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1212104910")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "3363700319")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1212104919")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1212102209")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1212201500")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1263603110")
OR
(aa.SupplierID = 4935
AND aa.DataSupplierArticleNumber = "JCP1474")
OR
(aa.SupplierID = 4935
AND aa.DataSupplierArticleNumber = "JCP1797")
OR
(aa.SupplierID = 48
AND aa.DataSupplierArticleNumber = "573089JC")
OR
(aa.SupplierID = 48
AND aa.DataSupplierArticleNumber = "573307J")
OR
(aa.SupplierID = 48
AND aa.DataSupplierArticleNumber = "573089D")
OR
(aa.SupplierID = 48
AND aa.DataSupplierArticleNumber = "573089J")
OR
(aa.SupplierID = 4461
AND aa.DataSupplierArticleNumber = "FC1181")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "JQ1013594")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "R0241")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "F301601")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "F305701")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "JQ1013040")
OR
(aa.SupplierID = 286
AND aa.DataSupplierArticleNumber = "810071")
OR
(aa.SupplierID = 286
AND aa.DataSupplierArticleNumber = "0879 31")
OR
(aa.SupplierID = 286
AND aa.DataSupplierArticleNumber = "0888 00")
OR
(aa.SupplierID = 286
AND aa.DataSupplierArticleNumber = "1178 00")
OR
(aa.SupplierID = 4462
AND aa.DataSupplierArticleNumber = "KFI354")
OR
(aa.SupplierID = 4462
AND aa.DataSupplierArticleNumber = "WKFI354")
OR
(aa.SupplierID = 4462
AND aa.DataSupplierArticleNumber = "FI11910")
OR
(aa.SupplierID = 34
AND aa.DataSupplierArticleNumber = "KL 567")
OR
(aa.SupplierID = 432
AND aa.DataSupplierArticleNumber = "50014136")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "1726860")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "6001720")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "6008533")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "1223350")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "6013015")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "1723002")
OR
(aa.SupplierID = 197
AND aa.DataSupplierArticleNumber = "05P1218")
OR
(aa.SupplierID = 197
AND aa.DataSupplierArticleNumber = "05P1524")
OR
(aa.SupplierID = 197
AND aa.DataSupplierArticleNumber = "05P1216")
OR
(aa.SupplierID = 424
AND aa.DataSupplierArticleNumber = "LA0207")
OR
(aa.SupplierID = 424
AND aa.DataSupplierArticleNumber = "LDK0368")
OR
(aa.SupplierID = 424
AND aa.DataSupplierArticleNumber = "LA0208")
OR
(aa.SupplierID = 424
AND aa.DataSupplierArticleNumber = "LA0206")
OR
(aa.SupplierID = 4973
AND aa.DataSupplierArticleNumber = "LFDE150")
OR
(aa.SupplierID = 4973
AND aa.DataSupplierArticleNumber = "LFDF178")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "PB-1255")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "PK-1348")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "LF-1811")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "LF-1814")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "340018181049")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "341303980000")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "363916060225")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "341310491201")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "153071760155")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "363916060162")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "153071760527")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "KL 567")
OR
(aa.SupplierID = 317
AND aa.DataSupplierArticleNumber = "1050187")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "WK 853/21")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "PU 723 x")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "23720")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "63236")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "43720")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "63029")
OR
(aa.SupplierID = 358
AND aa.DataSupplierArticleNumber = "13046071722N-SET-MS")
OR
(aa.SupplierID = 358
AND aa.DataSupplierArticleNumber = "723X-KF-PCS-MS")
OR
(aa.SupplierID = 358
AND aa.DataSupplierArticleNumber = "853/21-KF-PCS-MS")
OR
(aa.SupplierID = 358
AND aa.DataSupplierArticleNumber = "13046071722-SET-MS")
OR
(aa.SupplierID = 358
AND aa.DataSupplierArticleNumber = "208DK-KF-PCS-MS")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "26-0667")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "26-0033")
OR
(aa.SupplierID = 4773
AND aa.DataSupplierArticleNumber = "MFF-3E16")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "4499")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "4829")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "4915")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "ELG5327")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "ELG5322")
OR
(aa.SupplierID = 121
AND aa.DataSupplierArticleNumber = "22-0540-4")
OR
(aa.SupplierID = 121
AND aa.DataSupplierArticleNumber = "22-0706-0")
OR
(aa.SupplierID = 121
AND aa.DataSupplierArticleNumber = "22-0540-0")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "1170100")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "WM-Z 621")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "214 323 0004")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "614 323 0004")
OR
(aa.SupplierID = 462
AND aa.DataSupplierArticleNumber = "DE 3118")
OR
(aa.SupplierID = 462
AND aa.DataSupplierArticleNumber = "DF 3531")
OR
(aa.SupplierID = 73
AND aa.DataSupplierArticleNumber = "MDB2262")
OR
(aa.SupplierID = 73
AND aa.DataSupplierArticleNumber = "MDB2800")
OR
(aa.SupplierID = 4470
AND aa.DataSupplierArticleNumber = "F116")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "VFF500")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "VFF551")
OR
(aa.SupplierID = 490
AND aa.DataSupplierArticleNumber = "FN388")
OR
(aa.SupplierID = 490
AND aa.DataSupplierArticleNumber = "FN148")
OR
(aa.SupplierID = 190
AND aa.DataSupplierArticleNumber = "NP2016")
OR
(aa.SupplierID = 4682
AND aa.DataSupplierArticleNumber = "PN0325")
OR
(aa.SupplierID = 248
AND aa.DataSupplierArticleNumber = "J1338031")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "222379")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "223628")
OR
(aa.SupplierID = 440
AND aa.DataSupplierArticleNumber = "S133I04")
OR
(aa.SupplierID = 440
AND aa.DataSupplierArticleNumber = "S112I16")
OR
(aa.SupplierID = 4380
AND aa.DataSupplierArticleNumber = "2136691")
OR
(aa.SupplierID = 4380
AND aa.DataSupplierArticleNumber = "2135196")
OR
(aa.SupplierID = 4380
AND aa.DataSupplierArticleNumber = "2136743")
OR
(aa.SupplierID = 64
AND aa.DataSupplierArticleNumber = "371ST")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "88800")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "FF-01204")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "SK-1696")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "0-N115")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PT12174")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PF3152")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PF3269")
OR
(aa.SupplierID = 4686
AND aa.DataSupplierArticleNumber = "1530-2520")
OR
(aa.SupplierID = 4686
AND aa.DataSupplierArticleNumber = "1530-2543")
OR
(aa.SupplierID = 4520
AND aa.DataSupplierArticleNumber = "PRP1408")
OR
(aa.SupplierID = 4520
AND aa.DataSupplierArticleNumber = "PRP1409")
OR
(aa.SupplierID = 4520
AND aa.DataSupplierArticleNumber = "PRP0482")
OR
(aa.SupplierID = 4520
AND aa.DataSupplierArticleNumber = "PRP1410")
OR
(aa.SupplierID = 4520
AND aa.DataSupplierArticleNumber = "PRP1228")
OR
(aa.SupplierID = 38
AND aa.DataSupplierArticleNumber = "C507A")
OR
(aa.SupplierID = 38
AND aa.DataSupplierArticleNumber = "FCS722")
OR
(aa.SupplierID = 4821
AND aa.DataSupplierArticleNumber = "QP0935")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "MBP1366")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QBK658")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QFF0278")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "MBP1509")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QTB544")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "BP1366")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QFF0299")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "BP1509")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "MBK658")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QTT841")
OR
(aa.SupplierID = 4955
AND aa.DataSupplierArticleNumber = "RB1763")
OR
(aa.SupplierID = 4955
AND aa.DataSupplierArticleNumber = "RB1536")
OR
(aa.SupplierID = 400
AND aa.DataSupplierArticleNumber = "RA.0904.0")
OR
(aa.SupplierID = 400
AND aa.DataSupplierArticleNumber = "RA.0797.1")
OR
(aa.SupplierID = 153
AND aa.DataSupplierArticleNumber = "0879.31")
OR
(aa.SupplierID = 153
AND aa.DataSupplierArticleNumber = "0888.00")
OR
(aa.SupplierID = 153
AND aa.DataSupplierArticleNumber = "1178.00")
OR
(aa.SupplierID = 4330
AND aa.DataSupplierArticleNumber = "RKT1306")
OR
(aa.SupplierID = 4330
AND aa.DataSupplierArticleNumber = "RKTK1093")
OR
(aa.SupplierID = 152
AND aa.DataSupplierArticleNumber = "21178.00")
OR
(aa.SupplierID = 152
AND aa.DataSupplierArticleNumber = "2879.31")
OR
(aa.SupplierID = 152
AND aa.DataSupplierArticleNumber = "2888.00")
OR
(aa.SupplierID = 100
AND aa.DataSupplierArticleNumber = "RR1049")
OR
(aa.SupplierID = 23
AND aa.DataSupplierArticleNumber = "5603677")
OR
(aa.SupplierID = 23
AND aa.DataSupplierArticleNumber = "55844")
OR
(aa.SupplierID = 23
AND aa.DataSupplierArticleNumber = "5584475")
OR
(aa.SupplierID = 23
AND aa.DataSupplierArticleNumber = "56036")
OR
(aa.SupplierID = 260
AND aa.DataSupplierArticleNumber = "1766005")
OR
(aa.SupplierID = 260
AND aa.DataSupplierArticleNumber = "1756008")
OR
(aa.SupplierID = 260
AND aa.DataSupplierArticleNumber = "1706007")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "1501222379")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "1501223628")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "SP 431 PR")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "SC 7046 P")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "ST 6120")
OR
(aa.SupplierID = 27
AND aa.DataSupplierArticleNumber = "4829")
OR
(aa.SupplierID = 4768
AND aa.DataSupplierArticleNumber = "S30005")
OR
(aa.SupplierID = 4768
AND aa.DataSupplierArticleNumber = "S30014")
OR
(aa.SupplierID = 50
AND aa.DataSupplierArticleNumber = "VKMA 02194")
OR
(aa.SupplierID = 50
AND aa.DataSupplierArticleNumber = "VKM 12174")
OR
(aa.SupplierID = 110
AND aa.DataSupplierArticleNumber = "KD458.56")
OR
(aa.SupplierID = 110
AND aa.DataSupplierArticleNumber = "GT358.30")
OR
(aa.SupplierID = 142
AND aa.DataSupplierArticleNumber = "S 6H2O NE")
OR
(aa.SupplierID = 142
AND aa.DataSupplierArticleNumber = "S 1ONE NR")
OR
(aa.SupplierID = 142
AND aa.DataSupplierArticleNumber = "S 5139 GC")
OR
(aa.SupplierID = 4348
AND aa.DataSupplierArticleNumber = "SM-FFG014")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "21-00726-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "893 000-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "03-40052-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "899 000B-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "21-00477-SX")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "70 93 0757")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "70 03 0029")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "70 92 8305")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "40 91 6492")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "70 92 8306")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "70 91 6852")
OR
(aa.SupplierID = 4011
AND aa.DataSupplierArticleNumber = "GS010026-E")
OR
(aa.SupplierID = 4011
AND aa.DataSupplierArticleNumber = "GS24/01")
OR
(aa.SupplierID = 91
AND aa.DataSupplierArticleNumber = "N311A")
OR
(aa.SupplierID = 91
AND aa.DataSupplierArticleNumber = "RN260")
OR
(aa.SupplierID = 39
AND aa.DataSupplierArticleNumber = "2373807")
OR
(aa.SupplierID = 39
AND aa.DataSupplierArticleNumber = "2434801")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "206 912")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "207 045")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "206 919")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "207 473")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8645 5650xs")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8647 10083")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8110 15043")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8646 15117")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8110 24020")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8646 10138")
OR
(aa.SupplierID = 199
AND aa.DataSupplierArticleNumber = "556.4")
OR
(aa.SupplierID = 199
AND aa.DataSupplierArticleNumber = "722.0")
OR
(aa.SupplierID = 199
AND aa.DataSupplierArticleNumber = "556.0")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "GDB1637")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "GDB1613")
OR
(aa.SupplierID = 137
AND aa.DataSupplierArticleNumber = "60.H2O.00")
OR
(aa.SupplierID = 137
AND aa.DataSupplierArticleNumber = "24.ONE.01")
OR
(aa.SupplierID = 137
AND aa.DataSupplierArticleNumber = "55.139.00")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V40-0655")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V40-8027-1")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V24-0103")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V24-0153")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V24-0222")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V40-8027")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V40-0611")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "598727")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "598793")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "587914")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "301678")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "601118")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "598678")
OR
(aa.SupplierID = 4425
AND aa.DataSupplierArticleNumber = "837971")
OR
(aa.SupplierID = 4425
AND aa.DataSupplierArticleNumber = "65018063")
OR
(aa.SupplierID = 179
AND aa.DataSupplierArticleNumber = "G1616H")
OR
(aa.SupplierID = 179
AND aa.DataSupplierArticleNumber = "K1G1616H")
OR
(aa.SupplierID = 456
AND aa.DataSupplierArticleNumber = "626.1216")
OR
(aa.SupplierID = 456
AND aa.DataSupplierArticleNumber = "626.1218")
OR
(aa.SupplierID = 4498
AND aa.DataSupplierArticleNumber = "WBP23402B")
OR
(aa.SupplierID = 4498
AND aa.DataSupplierArticleNumber = "WBP24348A")
OR
(aa.SupplierID = 482
AND aa.DataSupplierArticleNumber = "151-1988")
OR
(aa.SupplierID = 482
AND aa.DataSupplierArticleNumber = "151-2003")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1151204")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1431589")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1431617")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1252643")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1018982")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1431590")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1142105")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1431483")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1215064")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1252050")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1215161")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1097446")
OR
(aa.SupplierID = 324
AND aa.DataSupplierArticleNumber = "WF8408")
OR
(aa.SupplierID = 324
AND aa.DataSupplierArticleNumber = "WF8366")
OR
(aa.SupplierID = 366
AND aa.DataSupplierArticleNumber = "P9883.00")
OR
(aa.SupplierID = 366
AND aa.DataSupplierArticleNumber = "P10783.00")
OR
(aa.SupplierID = 366
AND aa.DataSupplierArticleNumber = "P9793.31")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "KF-5010E")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "BS-2829")
OR
(aa.SupplierID = 86
AND aa.DataSupplierArticleNumber = "24348.160.1")
OR
(aa.SupplierID = 86
AND aa.DataSupplierArticleNumber = "24348.160.2")
OR
(aa.SupplierID = 86
AND aa.DataSupplierArticleNumber = "23402.200.1")
OR
(aa.SupplierID = 86
AND aa.DataSupplierArticleNumber = "23402.200.3")
)
AND aa.Language = "ru"
Продажа автозапчастей типа Дополнительные работы для автомобилей
