#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTU1ODZ8fG1kZl9pZD09MF41NzMwN3x8c3BhcmVfaWQ9PTEwMDU5Nw%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 = "57307"
AND (
(av.SupplierID = 4814
AND av.DataSupplierArticleNumber = "K30264"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4814
AND av.DataSupplierArticleNumber = "E50312"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4814
AND av.DataSupplierArticleNumber = "A63216"
AND av.ProductID IN (8))
OR
(av.SupplierID = 228
AND av.DataSupplierArticleNumber = "1654"
AND av.ProductID IN (424))
OR
(av.SupplierID = 228
AND av.DataSupplierArticleNumber = "654"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4533
AND av.DataSupplierArticleNumber = "143218"
AND av.ProductID IN (305,305))
OR
(av.SupplierID = 166
AND av.DataSupplierArticleNumber = "ATF-92001"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 166
AND av.DataSupplierArticleNumber = "ATF-92005"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 180
AND av.DataSupplierArticleNumber = "MD-8282"
AND av.ProductID IN (8))
OR
(av.SupplierID = 180
AND av.DataSupplierArticleNumber = "MD-683"
AND av.ProductID IN (7))
OR
(av.SupplierID = 180
AND av.DataSupplierArticleNumber = "TR-013"
AND av.ProductID IN (416))
OR
(av.SupplierID = 4866
AND av.DataSupplierArticleNumber = "SuperTronic 0W-40"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 4866
AND av.DataSupplierArticleNumber = "HighTronic G 5W-30"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 4866
AND av.DataSupplierArticleNumber = "SuperT LA 5W-30"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 4866
AND av.DataSupplierArticleNumber = "SuperTr LL III 5W-30"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 4866
AND av.DataSupplierArticleNumber = "HighTronic 5W-40"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 4576
AND av.DataSupplierArticleNumber = "71698"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4576
AND av.DataSupplierArticleNumber = "71699"
AND av.ProductID IN (424))
OR
(av.SupplierID = 442
AND av.DataSupplierArticleNumber = "M001-50"
AND av.ProductID IN (135))
OR
(av.SupplierID = 442
AND av.DataSupplierArticleNumber = "ASH2-600"
AND av.ProductID IN (298))
OR
(av.SupplierID = 442
AND av.DataSupplierArticleNumber = "US102243"
AND av.ProductID IN (8))
OR
(av.SupplierID = 442
AND av.DataSupplierArticleNumber = "ASH2-650"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4337
AND av.DataSupplierArticleNumber = "R145"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4337
AND av.DataSupplierArticleNumber = "520"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4337
AND av.DataSupplierArticleNumber = "R163"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4337
AND av.DataSupplierArticleNumber = "I62"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4464
AND av.DataSupplierArticleNumber = "WBF650"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4464
AND av.DataSupplierArticleNumber = "WBF600"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4995
AND av.DataSupplierArticleNumber = "001-10-16884"
AND av.ProductID IN (3843))
OR
(av.SupplierID = 4995
AND av.DataSupplierArticleNumber = "001-10-16685"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4995
AND av.DataSupplierArticleNumber = "001-20-03274"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4995
AND av.DataSupplierArticleNumber = "001-20-03354"
AND av.ProductID IN (424))
OR
(av.SupplierID = 350
AND av.DataSupplierArticleNumber = "ADV182234"
AND av.ProductID IN (8))
OR
(av.SupplierID = 350
AND av.DataSupplierArticleNumber = "ADU172101"
AND av.ProductID IN (7))
OR
(av.SupplierID = 350
AND av.DataSupplierArticleNumber = "ADU172511"
AND av.ProductID IN (424))
OR
(av.SupplierID = 350
AND av.DataSupplierArticleNumber = "ADA102132"
AND av.ProductID IN (416))
OR
(av.SupplierID = 350
AND av.DataSupplierArticleNumber = "AD07R2050"
AND av.ProductID IN (305))
OR
(av.SupplierID = 350
AND av.DataSupplierArticleNumber = "ADA100105"
AND av.ProductID IN (135))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BW24F"
AND av.ProductID IN (298))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BFC1061"
AND av.ProductID IN (424))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BFA2015"
AND av.ProductID IN (8))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BW26F"
AND av.ProductID IN (298))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "F 026 407 112"
AND av.ProductID IN (7))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "1 987 432 513"
AND av.ProductID IN (424))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "F 026 400 055"
AND av.ProductID IN (8))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "3 397 008 587"
AND av.ProductID IN (298))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "1 987 946 275"
AND av.ProductID IN (305))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "3 397 007 216"
AND av.ProductID IN (298))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "3 397 006 951"
AND av.ProductID IN (298))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "3 397 008 051"
AND av.ProductID IN (298))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "3 397 006 952"
AND av.ProductID IN (298))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "1 987 432 213"
AND av.ProductID IN (424))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "0 986 626 852"
AND av.ProductID IN (8))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "3 397 008 585"
AND av.ProductID IN (298))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "3 397 007 215"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4455
AND av.DataSupplierArticleNumber = "SIL SB 2624 B"
AND av.ProductID IN (298))
OR
(av.SupplierID = 157
AND av.DataSupplierArticleNumber = "BSP21723"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4668
AND av.DataSupplierArticleNumber = "005287"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 4668
AND av.DataSupplierArticleNumber = "05163R"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 4668
AND av.DataSupplierArticleNumber = "005355"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 4668
AND av.DataSupplierArticleNumber = "05192R"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 4668
AND av.DataSupplierArticleNumber = "05156R"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 4668
AND av.DataSupplierArticleNumber = "05163C"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "EF65/B01"
AND av.ProductID IN (298))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "CCF0180"
AND av.ProductID IN (424))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "AFL65/B01"
AND av.ProductID IN (298))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "COF100599E"
AND av.ProductID IN (7))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "CCF0180C"
AND av.ProductID IN (424))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "AFL6560B/C02"
AND av.ProductID IN (298))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "AF38Z/B01"
AND av.ProductID IN (298))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "XE599/606"
AND av.ProductID IN (7))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "EF60/B01"
AND av.ProductID IN (298))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "CAF100872P"
AND av.ProductID IN (8))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "AFL60/B01"
AND av.ProductID IN (298))
OR
(av.SupplierID = 189
AND av.DataSupplierArticleNumber = "21116"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 189
AND av.DataSupplierArticleNumber = "3011"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 189
AND av.DataSupplierArticleNumber = "65604"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 189
AND av.DataSupplierArticleNumber = "65607"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 163
AND av.DataSupplierArticleNumber = "ML4534"
AND av.ProductID IN (7))
OR
(av.SupplierID = 163
AND av.DataSupplierArticleNumber = "NC2345CA"
AND av.ProductID IN (424))
OR
(av.SupplierID = 163
AND av.DataSupplierArticleNumber = "MA3089"
AND av.ProductID IN (8))
OR
(av.SupplierID = 421
AND av.DataSupplierArticleNumber = "EAF630"
AND av.ProductID IN (8))
OR
(av.SupplierID = 421
AND av.DataSupplierArticleNumber = "CFWB650"
AND av.ProductID IN (298))
OR
(av.SupplierID = 421
AND av.DataSupplierArticleNumber = "EOF253"
AND av.ProductID IN (7))
OR
(av.SupplierID = 421
AND av.DataSupplierArticleNumber = "EKF175A"
AND av.ProductID IN (424))
OR
(av.SupplierID = 421
AND av.DataSupplierArticleNumber = "CFWB600"
AND av.ProductID IN (298))
OR
(av.SupplierID = 421
AND av.DataSupplierArticleNumber = "EKF175"
AND av.ProductID IN (424))
OR
(av.SupplierID = 31
AND av.DataSupplierArticleNumber = "6DPK2215"
AND av.ProductID IN (305))
OR
(av.SupplierID = 31
AND av.DataSupplierArticleNumber = "6PK2215"
AND av.ProductID IN (305))
OR
(av.SupplierID = 140
AND av.DataSupplierArticleNumber = "80001728"
AND av.ProductID IN (424))
OR
(av.SupplierID = 140
AND av.DataSupplierArticleNumber = "80000614"
AND av.ProductID IN (424))
OR
(av.SupplierID = 140
AND av.DataSupplierArticleNumber = "80000616"
AND av.ProductID IN (424))
OR
(av.SupplierID = 66
AND av.DataSupplierArticleNumber = "DF-025"
AND av.ProductID IN (298))
OR
(av.SupplierID = 253
AND av.DataSupplierArticleNumber = "DCI0251M"
AND av.ProductID IN (424))
OR
(av.SupplierID = 253
AND av.DataSupplierArticleNumber = "DCI1151"
AND av.ProductID IN (424))
OR
(av.SupplierID = 253
AND av.DataSupplierArticleNumber = "DCI0151"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4357
AND av.DataSupplierArticleNumber = "49540"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 4357
AND av.DataSupplierArticleNumber = "49260"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 4357
AND av.DataSupplierArticleNumber = "51800"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 4357
AND av.DataSupplierArticleNumber = "49270"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 4357
AND av.DataSupplierArticleNumber = "28360"
AND av.ProductID IN (3354))
OR
(av.SupplierID = 4357
AND av.DataSupplierArticleNumber = "51810"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 4357
AND av.DataSupplierArticleNumber = "49360"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 4357
AND av.DataSupplierArticleNumber = "49180"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 4357
AND av.DataSupplierArticleNumber = "51770"
AND av.ProductID IN (3354))
OR
(av.SupplierID = 4585
AND av.DataSupplierArticleNumber = "DVF60"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4585
AND av.DataSupplierArticleNumber = "DVF65"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4948
AND av.DataSupplierArticleNumber = "DP3310.10.105"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 4948
AND av.DataSupplierArticleNumber = "DP3310.10.078"
AND av.ProductID IN (3354))
OR
(av.SupplierID = 4948
AND av.DataSupplierArticleNumber = "DP3310.10.084"
AND av.ProductID IN (3354))
OR
(av.SupplierID = 4948
AND av.DataSupplierArticleNumber = "DP3310.10.140"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 4948
AND av.DataSupplierArticleNumber = "DP1110.11.0126"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4948
AND av.DataSupplierArticleNumber = "DP3310.10.015"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 4948
AND av.DataSupplierArticleNumber = "DP1110.10.0146"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "DCFK307"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "DAF1845"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "DCF307"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4881
AND av.DataSupplierArticleNumber = "500522"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 10
AND av.DataSupplierArticleNumber = "115.100"
AND av.ProductID IN (135))
OR
(av.SupplierID = 10
AND av.DataSupplierArticleNumber = "295.540"
AND av.ProductID IN (3106))
OR
(av.SupplierID = 237
AND av.DataSupplierArticleNumber = "5256009"
AND av.ProductID IN (135))
OR
(av.SupplierID = 398
AND av.DataSupplierArticleNumber = "E113650"
AND av.ProductID IN (3354))
OR
(av.SupplierID = 398
AND av.DataSupplierArticleNumber = "E113658"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 398
AND av.DataSupplierArticleNumber = "E100085"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 398
AND av.DataSupplierArticleNumber = "E100054"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 398
AND av.DataSupplierArticleNumber = "E113680"
AND av.ProductID IN (3354))
OR
(av.SupplierID = 398
AND av.DataSupplierArticleNumber = "E113659"
AND av.ProductID IN (3354))
OR
(av.SupplierID = 398
AND av.DataSupplierArticleNumber = "E100062"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 398
AND av.DataSupplierArticleNumber = "E113665"
AND av.ProductID IN (3354))
OR
(av.SupplierID = 398
AND av.DataSupplierArticleNumber = "E100024"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 398
AND av.DataSupplierArticleNumber = "E100076"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 398
AND av.DataSupplierArticleNumber = "E113667"
AND av.ProductID IN (3354))
OR
(av.SupplierID = 4938
AND av.DataSupplierArticleNumber = "FT93250"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4938
AND av.DataSupplierArticleNumber = "FT93251"
AND av.ProductID IN (298))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "07215"
AND av.ProductID IN (135))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "09463"
AND av.ProductID IN (416))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "30018"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "10072"
AND av.ProductID IN (3106))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "22806"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "29013"
AND av.ProductID IN (305))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "47282"
AND av.ProductID IN (416))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "26680"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "30640"
AND av.ProductID IN (424))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "34870"
AND av.ProductID IN (8))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "04054"
AND av.ProductID IN (135))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "47283"
AND av.ProductID IN (416))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "10098"
AND av.ProductID IN (3843))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "26681"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "24661"
AND av.ProductID IN (7))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "30641"
AND av.ProductID IN (424))
OR
(av.SupplierID = 271
AND av.DataSupplierArticleNumber = "FCS190"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4838
AND av.DataSupplierArticleNumber = "F-629"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4838
AND av.DataSupplierArticleNumber = "FA-2058"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4659
AND av.DataSupplierArticleNumber = "HC 7135"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4659
AND av.DataSupplierArticleNumber = "HCK 7135"
AND av.ProductID IN (424))
OR
(av.SupplierID = 256
AND av.DataSupplierArticleNumber = "K1288A"
AND av.ProductID IN (424))
OR
(av.SupplierID = 256
AND av.DataSupplierArticleNumber = "AP157/6"
AND av.ProductID IN (8))
OR
(av.SupplierID = 256
AND av.DataSupplierArticleNumber = "OE677/4"
AND av.ProductID IN (7))
OR
(av.SupplierID = 256
AND av.DataSupplierArticleNumber = "K1288"
AND av.ProductID IN (424))
OR
(av.SupplierID = 441
AND av.DataSupplierArticleNumber = "177"
AND av.ProductID IN (424))
OR
(av.SupplierID = 441
AND av.DataSupplierArticleNumber = "677"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4581
AND av.DataSupplierArticleNumber = "AF55735"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4581
AND av.DataSupplierArticleNumber = "AF55769"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4581
AND av.DataSupplierArticleNumber = "TF15074"
AND av.ProductID IN (416))
OR
(av.SupplierID = 4581
AND av.DataSupplierArticleNumber = "AF26375"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4581
AND av.DataSupplierArticleNumber = "AF26462"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4581
AND av.DataSupplierArticleNumber = "LF4000"
AND av.ProductID IN (7))
OR
(av.SupplierID = 236
AND av.DataSupplierArticleNumber = "6DPK2215"
AND av.ProductID IN (305))
OR
(av.SupplierID = 236
AND av.DataSupplierArticleNumber = "6PK2213"
AND av.ProductID IN (305))
OR
(av.SupplierID = 33
AND av.DataSupplierArticleNumber = "6DPK2215"
AND av.ProductID IN (305))
OR
(av.SupplierID = 33
AND av.DataSupplierArticleNumber = "6PK2213"
AND av.ProductID IN (305))
OR
(av.SupplierID = 4663
AND av.DataSupplierArticleNumber = "AG 221"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4663
AND av.DataSupplierArticleNumber = "AG 1007"
AND av.ProductID IN (8))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "9XW 190 680-261"
AND av.ProductID IN (298))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "9XW 197 765-241"
AND av.ProductID IN (298))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "9XW 197 765-261"
AND av.ProductID IN (298))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "9XW 190 680-241"
AND av.ProductID IN (298))
OR
(av.SupplierID = 81
AND av.DataSupplierArticleNumber = "E2916LI"
AND av.ProductID IN (424))
OR
(av.SupplierID = 81
AND av.DataSupplierArticleNumber = "E821L"
AND av.ProductID IN (8))
OR
(av.SupplierID = 81
AND av.DataSupplierArticleNumber = "E87H D153"
AND av.ProductID IN (7))
OR
(av.SupplierID = 81
AND av.DataSupplierArticleNumber = "E2916LC"
AND av.ProductID IN (424))
OR
(av.SupplierID = 81
AND av.DataSupplierArticleNumber = "E11H D204"
AND av.ProductID IN (7))
OR
(av.SupplierID = 341
AND av.DataSupplierArticleNumber = "17411"
AND av.ProductID IN (424))
OR
(av.SupplierID = 341
AND av.DataSupplierArticleNumber = "14167"
AND av.ProductID IN (7))
OR
(av.SupplierID = 204
AND av.DataSupplierArticleNumber = "FB 6PK2215"
AND av.ProductID IN (305))
OR
(av.SupplierID = 4689
AND av.DataSupplierArticleNumber = "B4M026PR"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4689
AND av.DataSupplierArticleNumber = "B1M030PR"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4689
AND av.DataSupplierArticleNumber = "B2M069PR"
AND av.ProductID IN (8))
OR
(av.SupplierID = 138
AND av.DataSupplierArticleNumber = "IRF 1151"
AND av.ProductID IN (424))
OR
(av.SupplierID = 138
AND av.DataSupplierArticleNumber = "IRF 0151"
AND av.ProductID IN (424))
OR
(av.SupplierID = 138
AND av.DataSupplierArticleNumber = "IRF 0251M"
AND av.ProductID IN (424))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1331900500"
AND av.ProductID IN (416))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1128100400"
AND av.ProductID IN (424))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1331900509"
AND av.ProductID IN (416))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1118609100"
AND av.ProductID IN (8))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1128104200"
AND av.ProductID IN (424))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1318502100"
AND av.ProductID IN (7))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "F414801"
AND av.ProductID IN (424))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "F509001"
AND av.ProductID IN (424))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "27D02"
AND av.ProductID IN (298))
OR
(av.SupplierID = 34
AND av.DataSupplierArticleNumber = "LA 307"
AND av.ProductID IN (424))
OR
(av.SupplierID = 34
AND av.DataSupplierArticleNumber = "LX 1845"
AND av.ProductID IN (8))
OR
(av.SupplierID = 34
AND av.DataSupplierArticleNumber = "HX 81D"
AND av.ProductID IN (416))
OR
(av.SupplierID = 34
AND av.DataSupplierArticleNumber = "LAK 307"
AND av.ProductID IN (424))
OR
(av.SupplierID = 432
AND av.DataSupplierArticleNumber = "50014163"
AND av.ProductID IN (8))
OR
(av.SupplierID = 432
AND av.DataSupplierArticleNumber = "50014483"
AND av.ProductID IN (7))
OR
(av.SupplierID = 432
AND av.DataSupplierArticleNumber = "50014228"
AND av.ProductID IN (424))
OR
(av.SupplierID = 432
AND av.DataSupplierArticleNumber = "50014229"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "K65PBCDE"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "K60PB"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "1701055"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "K60PBCDE"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "K65PB"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "1731125"
AND av.ProductID IN (424))
OR
(av.SupplierID = 222
AND av.DataSupplierArticleNumber = "P000322"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 222
AND av.DataSupplierArticleNumber = "P000273"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 222
AND av.DataSupplierArticleNumber = "P000238"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 222
AND av.DataSupplierArticleNumber = "P000336"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 222
AND av.DataSupplierArticleNumber = "P000323"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 222
AND av.DataSupplierArticleNumber = "P000274"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 222
AND av.DataSupplierArticleNumber = "P000242"
AND av.ProductID IN (3354))
OR
(av.SupplierID = 222
AND av.DataSupplierArticleNumber = "P000240"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 222
AND av.DataSupplierArticleNumber = "P003758"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 222
AND av.DataSupplierArticleNumber = "P000326"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 222
AND av.DataSupplierArticleNumber = "P000312"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 222
AND av.DataSupplierArticleNumber = "P000385"
AND av.ProductID IN (3354))
OR
(av.SupplierID = 222
AND av.DataSupplierArticleNumber = "P003760"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 222
AND av.DataSupplierArticleNumber = "P000327"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 4973
AND av.DataSupplierArticleNumber = "LFAF515"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4973
AND av.DataSupplierArticleNumber = "LFCP179"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4973
AND av.DataSupplierArticleNumber = "LFOE208"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4973
AND av.DataSupplierArticleNumber = "LFCP275"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4600
AND av.DataSupplierArticleNumber = "LA-1248"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4600
AND av.DataSupplierArticleNumber = "LAC-1236"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4600
AND av.DataSupplierArticleNumber = "LAC-1236C"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4600
AND av.DataSupplierArticleNumber = "LO-1907"
AND av.ProductID IN (7))
OR
(av.SupplierID = 95
AND av.DataSupplierArticleNumber = "350203062280"
AND av.ProductID IN (424))
OR
(av.SupplierID = 95
AND av.DataSupplierArticleNumber = "152071762000"
AND av.ProductID IN (8))
OR
(av.SupplierID = 95
AND av.DataSupplierArticleNumber = "153071760763"
AND av.ProductID IN (7))
OR
(av.SupplierID = 287
AND av.DataSupplierArticleNumber = "LX 1845"
AND av.ProductID IN (8))
OR
(av.SupplierID = 287
AND av.DataSupplierArticleNumber = "LA 307"
AND av.ProductID IN (424))
OR
(av.SupplierID = 287
AND av.DataSupplierArticleNumber = "LAK 307"
AND av.ProductID IN (424))
OR
(av.SupplierID = 287
AND av.DataSupplierArticleNumber = "HX 81D"
AND av.ProductID IN (416))
OR
(av.SupplierID = 4
AND av.DataSupplierArticleNumber = "H 27 001"
AND av.ProductID IN (416))
OR
(av.SupplierID = 4
AND av.DataSupplierArticleNumber = "C 4312/1"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4
AND av.DataSupplierArticleNumber = "FP 3569"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4
AND av.DataSupplierArticleNumber = "CU 2603"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4
AND av.DataSupplierArticleNumber = "CU 3569"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4
AND av.DataSupplierArticleNumber = "HU 7010 z"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4
AND av.DataSupplierArticleNumber = "H 182 KIT"
AND av.ProductID IN (416))
OR
(av.SupplierID = 4
AND av.DataSupplierArticleNumber = "CUK 3569"
AND av.ProductID IN (424))
OR
(av.SupplierID = 133
AND av.DataSupplierArticleNumber = "29990"
AND av.ProductID IN (417))
OR
(av.SupplierID = 133
AND av.DataSupplierArticleNumber = "60655"
AND av.ProductID IN (8))
OR
(av.SupplierID = 133
AND av.DataSupplierArticleNumber = "69001"
AND av.ProductID IN (416))
OR
(av.SupplierID = 133
AND av.DataSupplierArticleNumber = "64816"
AND av.ProductID IN (7))
OR
(av.SupplierID = 133
AND av.DataSupplierArticleNumber = "65231"
AND av.ProductID IN (424))
OR
(av.SupplierID = 133
AND av.DataSupplierArticleNumber = "68889"
AND av.ProductID IN (4055))
OR
(av.SupplierID = 133
AND av.DataSupplierArticleNumber = "67231"
AND av.ProductID IN (424))
OR
(av.SupplierID = 358
AND av.DataSupplierArticleNumber = "4312/1-LF-PCS-MS"
AND av.ProductID IN (8))
OR
(av.SupplierID = 358
AND av.DataSupplierArticleNumber = "7010Z-OF-PCS-MS"
AND av.ProductID IN (7))
OR
(av.SupplierID = 358
AND av.DataSupplierArticleNumber = "3569-IF-PCS-MS"
AND av.ProductID IN (424))
OR
(av.SupplierID = 403
AND av.DataSupplierArticleNumber = "26-0514"
AND av.ProductID IN (424))
OR
(av.SupplierID = 403
AND av.DataSupplierArticleNumber = "26-0848"
AND av.ProductID IN (424))
OR
(av.SupplierID = 403
AND av.DataSupplierArticleNumber = "26-0525"
AND av.ProductID IN (8))
OR
(av.SupplierID = 403
AND av.DataSupplierArticleNumber = "26-0019"
AND av.ProductID IN (7))
OR
(av.SupplierID = 244
AND av.DataSupplierArticleNumber = "17411"
AND av.ProductID IN (424))
OR
(av.SupplierID = 244
AND av.DataSupplierArticleNumber = "14167"
AND av.ProductID IN (7))
OR
(av.SupplierID = 218
AND av.DataSupplierArticleNumber = "ELR7310"
AND av.ProductID IN (424))
OR
(av.SupplierID = 218
AND av.DataSupplierArticleNumber = "ELH4429"
AND av.ProductID IN (7))
OR
(av.SupplierID = 218
AND av.DataSupplierArticleNumber = "EKR7228"
AND av.ProductID IN (424))
OR
(av.SupplierID = 218
AND av.DataSupplierArticleNumber = "ELR7228"
AND av.ProductID IN (424))
OR
(av.SupplierID = 218
AND av.DataSupplierArticleNumber = "ELP9165"
AND av.ProductID IN (8))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "012 319 0038"
AND av.ProductID IN (424))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "012 321 0010"
AND av.ProductID IN (8))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "014 322 0014"
AND av.ProductID IN (7))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "014 135 0302"
AND av.ProductID IN (4921))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "012 320 0038"
AND av.ProductID IN (424))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "029 600 2400"
AND av.ProductID IN (298))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "014 019 2800"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "014 135 0402"
AND av.ProductID IN (4921))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "029 650 2600"
AND av.ProductID IN (298))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "014 135 0202"
AND av.ProductID IN (4921))
OR
(av.SupplierID = 462
AND av.DataSupplierArticleNumber = "K 986C"
AND av.ProductID IN (424))
OR
(av.SupplierID = 462
AND av.DataSupplierArticleNumber = "K 747"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4470
AND av.DataSupplierArticleNumber = "P340"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4470
AND av.DataSupplierArticleNumber = "HB197"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4470
AND av.DataSupplierArticleNumber = "HB197C"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4564
AND av.DataSupplierArticleNumber = "VFA1187"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4564
AND av.DataSupplierArticleNumber = "LVCF559"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4564
AND av.DataSupplierArticleNumber = "LVFL775"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4564
AND av.DataSupplierArticleNumber = "VCF410"
AND av.ProductID IN (424))
OR
(av.SupplierID = 490
AND av.DataSupplierArticleNumber = "FOP312"
AND av.ProductID IN (7))
OR
(av.SupplierID = 490
AND av.DataSupplierArticleNumber = "FK264"
AND av.ProductID IN (424))
OR
(av.SupplierID = 490
AND av.DataSupplierArticleNumber = "PA3216"
AND av.ProductID IN (8))
OR
(av.SupplierID = 248
AND av.DataSupplierArticleNumber = "N1311040"
AND av.ProductID IN (7))
OR
(av.SupplierID = 440
AND av.DataSupplierArticleNumber = "N131N33"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4380
AND av.DataSupplierArticleNumber = "2133079"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4380
AND av.DataSupplierArticleNumber = "2135514"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4380
AND av.DataSupplierArticleNumber = "2136186"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4683
AND av.DataSupplierArticleNumber = "06308"
AND av.ProductID IN (3843))
OR
(av.SupplierID = 4558
AND av.DataSupplierArticleNumber = "PF2307"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4558
AND av.DataSupplierArticleNumber = "6PK2213"
AND av.ProductID IN (305))
OR
(av.SupplierID = 4543
AND av.DataSupplierArticleNumber = "86010600"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4543
AND av.DataSupplierArticleNumber = "86010650"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4686
AND av.DataSupplierArticleNumber = "1540-0339"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4686
AND av.DataSupplierArticleNumber = "1512-2629"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4686
AND av.DataSupplierArticleNumber = "1521-2216"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4686
AND av.DataSupplierArticleNumber = "1521-2271"
AND av.ProductID IN (424))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "QAW024"
AND av.ProductID IN (298))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "QAW026"
AND av.ProductID IN (298))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "QFL0282"
AND av.ProductID IN (416))
OR
(av.SupplierID = 461
AND av.DataSupplierArticleNumber = "1213102"
AND av.ProductID IN (3354))
OR
(av.SupplierID = 461
AND av.DataSupplierArticleNumber = "1121101"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 461
AND av.DataSupplierArticleNumber = "1212100"
AND av.ProductID IN (3354))
OR
(av.SupplierID = 461
AND av.DataSupplierArticleNumber = "1213101"
AND av.ProductID IN (3354))
OR
(av.SupplierID = 100
AND av.DataSupplierArticleNumber = "6K2215"
AND av.ProductID IN (305))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "AEROTECH 9470"
AND av.ProductID IN (298))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "SB 2167"
AND av.ProductID IN (8))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "7715 O.E.M. 5W-30"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "AEROTECH 9106"
AND av.ProductID IN (298))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "SA 1227"
AND av.ProductID IN (424))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "Energy Formula PD 5W40"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "AEROTECH 9107"
AND av.ProductID IN (298))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "9107-9106"
AND av.ProductID IN (298))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "SH 425/1 P"
AND av.ProductID IN (7))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "SAK 227"
AND av.ProductID IN (424))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "Dexron VI"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "AEROTECH 9469"
AND av.ProductID IN (298))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "9470-9469"
AND av.ProductID IN (298))
OR
(av.SupplierID = 27
AND av.DataSupplierArticleNumber = "177"
AND av.ProductID IN (424))
OR
(av.SupplierID = 27
AND av.DataSupplierArticleNumber = "677"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4768
AND av.DataSupplierArticleNumber = "G760"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4768
AND av.DataSupplierArticleNumber = "P760"
AND av.ProductID IN (424))
OR
(av.SupplierID = 50
AND av.DataSupplierArticleNumber = "VKMV 6PK2211"
AND av.ProductID IN (305))
OR
(av.SupplierID = 142
AND av.DataSupplierArticleNumber = "S 3137 C"
AND av.ProductID IN (424))
OR
(av.SupplierID = 142
AND av.DataSupplierArticleNumber = "S 4161 CA"
AND av.ProductID IN (424))
OR
(av.SupplierID = 142
AND av.DataSupplierArticleNumber = "S 3340 A"
AND av.ProductID IN (8))
OR
(av.SupplierID = 142
AND av.DataSupplierArticleNumber = "S 5159 PE"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "201 614-SX"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "20-50519-SX"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "20-51001-SX"
AND av.ProductID IN (416))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "20-50558-SX"
AND av.ProductID IN (7))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "99 90 9463"
AND av.ProductID IN (416))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "99 91 0098"
AND av.ProductID IN (3843))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "10 92 6680"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "10 93 4870"
AND av.ProductID IN (8))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "30 92 9013"
AND av.ProductID IN (305))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "99 90 4054"
AND av.ProductID IN (135))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "10 94 7282"
AND av.ProductID IN (416))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "10 92 6681"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "10 92 4661"
AND av.ProductID IN (7))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "10 91 0072"
AND av.ProductID IN (3106))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "10 93 0640"
AND av.ProductID IN (424))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "99 90 7215"
AND av.ProductID IN (135))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "10 94 7283"
AND av.ProductID IN (416))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "10 93 0018"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "10 92 2806"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "10 93 0641"
AND av.ProductID IN (424))
OR
(av.SupplierID = 19
AND av.DataSupplierArticleNumber = "119407"
AND av.ProductID IN (298))
OR
(av.SupplierID = 19
AND av.DataSupplierArticleNumber = "119508"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4011
AND av.DataSupplierArticleNumber = "OL011277-E"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4011
AND av.DataSupplierArticleNumber = "AR4312PM"
AND av.ProductID IN (8))
OR
(av.SupplierID = 301
AND av.DataSupplierArticleNumber = "111 659"
AND av.ProductID IN (424))
OR
(av.SupplierID = 301
AND av.DataSupplierArticleNumber = "400 457"
AND av.ProductID IN (3106))
OR
(av.SupplierID = 301
AND av.DataSupplierArticleNumber = "400 451"
AND av.ProductID IN (416))
OR
(av.SupplierID = 301
AND av.DataSupplierArticleNumber = "407 778"
AND av.ProductID IN (7))
OR
(av.SupplierID = 301
AND av.DataSupplierArticleNumber = "409 220"
AND av.ProductID IN (3843))
OR
(av.SupplierID = 301
AND av.DataSupplierArticleNumber = "111 660"
AND av.ProductID IN (424))
OR
(av.SupplierID = 301
AND av.DataSupplierArticleNumber = "113 184"
AND av.ProductID IN (298))
OR
(av.SupplierID = 301
AND av.DataSupplierArticleNumber = "407 792"
AND av.ProductID IN (3106))
OR
(av.SupplierID = 301
AND av.DataSupplierArticleNumber = "401 337"
AND av.ProductID IN (8))
OR
(av.SupplierID = 301
AND av.DataSupplierArticleNumber = "408 516"
AND av.ProductID IN (416))
OR
(av.SupplierID = 301
AND av.DataSupplierArticleNumber = "409 092"
AND av.ProductID IN (3843))
OR
(av.SupplierID = 301
AND av.DataSupplierArticleNumber = "409 119"
AND av.ProductID IN (3843))
OR
(av.SupplierID = 227
AND av.DataSupplierArticleNumber = "EFB6517R"
AND av.ProductID IN (298))
OR
(av.SupplierID = 227
AND av.DataSupplierArticleNumber = "EFB6017L"
AND av.ProductID IN (298))
OR
(av.SupplierID = 227
AND av.DataSupplierArticleNumber = "TXB650"
AND av.ProductID IN (298))
OR
(av.SupplierID = 227
AND av.DataSupplierArticleNumber = "TF650L"
AND av.ProductID IN (298))
OR
(av.SupplierID = 227
AND av.DataSupplierArticleNumber = "NF657"
AND av.ProductID IN (298))
OR
(av.SupplierID = 227
AND av.DataSupplierArticleNumber = "FX600"
AND av.ProductID IN (298))
OR
(av.SupplierID = 227
AND av.DataSupplierArticleNumber = "EFB6017R"
AND av.ProductID IN (298))
OR
(av.SupplierID = 227
AND av.DataSupplierArticleNumber = "35-240"
AND av.ProductID IN (298))
OR
(av.SupplierID = 227
AND av.DataSupplierArticleNumber = "TF650R"
AND av.ProductID IN (298))
OR
(av.SupplierID = 227
AND av.DataSupplierArticleNumber = "TF600L"
AND av.ProductID IN (298))
OR
(av.SupplierID = 227
AND av.DataSupplierArticleNumber = "FX650"
AND av.ProductID IN (298))
OR
(av.SupplierID = 227
AND av.DataSupplierArticleNumber = "EFB6517L"
AND av.ProductID IN (298))
OR
(av.SupplierID = 227
AND av.DataSupplierArticleNumber = "35-260"
AND av.ProductID IN (298))
OR
(av.SupplierID = 227
AND av.DataSupplierArticleNumber = "TXB600"
AND av.ProductID IN (298))
OR
(av.SupplierID = 227
AND av.DataSupplierArticleNumber = "TF600R"
AND av.ProductID IN (298))
OR
(av.SupplierID = 227
AND av.DataSupplierArticleNumber = "NF607"
AND av.ProductID IN (298))
OR
(av.SupplierID = 108
AND av.DataSupplierArticleNumber = "8640 662215"
AND av.ProductID IN (305))
OR
(av.SupplierID = 108
AND av.DataSupplierArticleNumber = "8640 602213"
AND av.ProductID IN (305))
OR
(av.SupplierID = 209
AND av.DataSupplierArticleNumber = "02.19.258"
AND av.ProductID IN (305))
OR
(av.SupplierID = 209
AND av.DataSupplierArticleNumber = "02.18.100"
AND av.ProductID IN (7))
OR
(av.SupplierID = 209
AND av.DataSupplierArticleNumber = "02.59.084"
AND av.ProductID IN (424))
OR
(av.SupplierID = 209
AND av.DataSupplierArticleNumber = "02.58.409"
AND av.ProductID IN (298))
OR
(av.SupplierID = 209
AND av.DataSupplierArticleNumber = "02.43.192"
AND av.ProductID IN (3843))
OR
(av.SupplierID = 209
AND av.DataSupplierArticleNumber = "88.25.005"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 209
AND av.DataSupplierArticleNumber = "02.14.064"
AND av.ProductID IN (8))
OR
(av.SupplierID = 209
AND av.DataSupplierArticleNumber = "02.18.032"
AND av.ProductID IN (7))
OR
(av.SupplierID = 209
AND av.DataSupplierArticleNumber = "88.25.006"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 209
AND av.DataSupplierArticleNumber = "02.59.082"
AND av.ProductID IN (424))
OR
(av.SupplierID = 209
AND av.DataSupplierArticleNumber = "02.25.031"
AND av.ProductID IN (3106))
OR
(av.SupplierID = 209
AND av.DataSupplierArticleNumber = "02.25.033"
AND av.ProductID IN (416))
OR
(av.SupplierID = 137
AND av.DataSupplierArticleNumber = "54.161.00"
AND av.ProductID IN (424))
OR
(av.SupplierID = 137
AND av.DataSupplierArticleNumber = "30.340.00"
AND av.ProductID IN (8))
OR
(av.SupplierID = 137
AND av.DataSupplierArticleNumber = "25.159.00"
AND av.ProductID IN (7))
OR
(av.SupplierID = 137
AND av.DataSupplierArticleNumber = "53.137.00"
AND av.ProductID IN (424))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V60-0060"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V10-3327"
AND av.ProductID IN (135))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V30-7316"
AND av.ProductID IN (3843))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V60-0078"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V60-0185"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V60-0100"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V60-0079"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V60-0082"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V30-2318"
AND av.ProductID IN (135))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V30-0455"
AND av.ProductID IN (416))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V60-0053"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V30-1928"
AND av.ProductID IN (3843))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V60-0260"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V60-0183"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V60-0080"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V10-0441"
AND av.ProductID IN (8))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V60-0083"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V60-0054"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V30-7313"
AND av.ProductID IN (3843))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V30-0931"
AND av.ProductID IN (7))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V60-0184"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V60-0081"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V60-0099"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "575789"
AND av.ProductID IN (298))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "574361"
AND av.ProductID IN (298))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "574362"
AND av.ProductID IN (298))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "585198"
AND av.ProductID IN (8))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "715601"
AND av.ProductID IN (424))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "575788"
AND av.ProductID IN (298))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "574334"
AND av.ProductID IN (298))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "715602"
AND av.ProductID IN (424))
OR
(av.SupplierID = 183
AND av.DataSupplierArticleNumber = "V30-31-1053"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1019217"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1805387"
AND av.ProductID IN (3106))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1432760"
AND av.ProductID IN (416))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1233557"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1215345"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1794583"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1019009"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1153170"
AND av.ProductID IN (305))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1794533"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1217290"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1234162"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1215635"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1019072"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1216098"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1428752"
AND av.ProductID IN (305))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1084960"
AND av.ProductID IN (135))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1794567"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1427082"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1427210"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1794440"
AND av.ProductID IN (3106))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1214732"
AND av.ProductID IN (416))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1233555"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1019073"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1427307"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1796118"
AND av.ProductID IN (3843))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1794568"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 324
AND av.DataSupplierArticleNumber = "WP9331"
AND av.ProductID IN (424))
OR
(av.SupplierID = 324
AND av.DataSupplierArticleNumber = "WL7470"
AND av.ProductID IN (7))
OR
(av.SupplierID = 324
AND av.DataSupplierArticleNumber = "WP9330"
AND av.ProductID IN (424))
OR
(av.SupplierID = 324
AND av.DataSupplierArticleNumber = "WA9520"
AND av.ProductID IN (8))
OR
(av.SupplierID = 188
AND av.DataSupplierArticleNumber = "21116"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 188
AND av.DataSupplierArticleNumber = "3011"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 4894
AND av.DataSupplierArticleNumber = "HW-600"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4894
AND av.DataSupplierArticleNumber = "IF-3147"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4894
AND av.DataSupplierArticleNumber = "OF-4175E"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4894
AND av.DataSupplierArticleNumber = "HW-650"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4894
AND av.DataSupplierArticleNumber = "IF-3147K"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4894
AND av.DataSupplierArticleNumber = "FW-600"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4894
AND av.DataSupplierArticleNumber = "OF-4416G"
AND av.ProductID IN (416))
OR
(av.SupplierID = 4894
AND av.DataSupplierArticleNumber = "LF-1565"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4894
AND av.DataSupplierArticleNumber = "FW-650"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4894
AND av.DataSupplierArticleNumber = "OF-4431G"
AND av.ProductID IN (416))
)
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 = "K30264")
OR
(aa.SupplierID = 4814
AND aa.DataSupplierArticleNumber = "E50312")
OR
(aa.SupplierID = 4814
AND aa.DataSupplierArticleNumber = "A63216")
OR
(aa.SupplierID = 228
AND aa.DataSupplierArticleNumber = "1654")
OR
(aa.SupplierID = 228
AND aa.DataSupplierArticleNumber = "654")
OR
(aa.SupplierID = 4533
AND aa.DataSupplierArticleNumber = "143218")
OR
(aa.SupplierID = 166
AND aa.DataSupplierArticleNumber = "ATF-92001")
OR
(aa.SupplierID = 166
AND aa.DataSupplierArticleNumber = "ATF-92005")
OR
(aa.SupplierID = 180
AND aa.DataSupplierArticleNumber = "MD-8282")
OR
(aa.SupplierID = 180
AND aa.DataSupplierArticleNumber = "MD-683")
OR
(aa.SupplierID = 180
AND aa.DataSupplierArticleNumber = "TR-013")
OR
(aa.SupplierID = 4866
AND aa.DataSupplierArticleNumber = "SuperTronic 0W-40")
OR
(aa.SupplierID = 4866
AND aa.DataSupplierArticleNumber = "HighTronic G 5W-30")
OR
(aa.SupplierID = 4866
AND aa.DataSupplierArticleNumber = "SuperT LA 5W-30")
OR
(aa.SupplierID = 4866
AND aa.DataSupplierArticleNumber = "SuperTr LL III 5W-30")
OR
(aa.SupplierID = 4866
AND aa.DataSupplierArticleNumber = "HighTronic 5W-40")
OR
(aa.SupplierID = 4576
AND aa.DataSupplierArticleNumber = "71698")
OR
(aa.SupplierID = 4576
AND aa.DataSupplierArticleNumber = "71699")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "M001-50")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "ASH2-600")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "US102243")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "ASH2-650")
OR
(aa.SupplierID = 4337
AND aa.DataSupplierArticleNumber = "R145")
OR
(aa.SupplierID = 4337
AND aa.DataSupplierArticleNumber = "520")
OR
(aa.SupplierID = 4337
AND aa.DataSupplierArticleNumber = "R163")
OR
(aa.SupplierID = 4337
AND aa.DataSupplierArticleNumber = "I62")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "WBF650")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "WBF600")
OR
(aa.SupplierID = 4995
AND aa.DataSupplierArticleNumber = "001-10-16884")
OR
(aa.SupplierID = 4995
AND aa.DataSupplierArticleNumber = "001-10-16685")
OR
(aa.SupplierID = 4995
AND aa.DataSupplierArticleNumber = "001-20-03274")
OR
(aa.SupplierID = 4995
AND aa.DataSupplierArticleNumber = "001-20-03354")
OR
(aa.SupplierID = 350
AND aa.DataSupplierArticleNumber = "ADV182234")
OR
(aa.SupplierID = 350
AND aa.DataSupplierArticleNumber = "ADU172101")
OR
(aa.SupplierID = 350
AND aa.DataSupplierArticleNumber = "ADU172511")
OR
(aa.SupplierID = 350
AND aa.DataSupplierArticleNumber = "ADA102132")
OR
(aa.SupplierID = 350
AND aa.DataSupplierArticleNumber = "AD07R2050")
OR
(aa.SupplierID = 350
AND aa.DataSupplierArticleNumber = "ADA100105")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BW24F")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BFC1061")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BFA2015")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BW26F")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "F 026 407 112")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "1 987 432 513")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "F 026 400 055")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 008 587")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "1 987 946 275")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 007 216")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 006 951")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 008 051")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 006 952")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "1 987 432 213")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 986 626 852")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 008 585")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 007 215")
OR
(aa.SupplierID = 4455
AND aa.DataSupplierArticleNumber = "SIL SB 2624 B")
OR
(aa.SupplierID = 157
AND aa.DataSupplierArticleNumber = "BSP21723")
OR
(aa.SupplierID = 4668
AND aa.DataSupplierArticleNumber = "005287")
OR
(aa.SupplierID = 4668
AND aa.DataSupplierArticleNumber = "05163R")
OR
(aa.SupplierID = 4668
AND aa.DataSupplierArticleNumber = "005355")
OR
(aa.SupplierID = 4668
AND aa.DataSupplierArticleNumber = "05192R")
OR
(aa.SupplierID = 4668
AND aa.DataSupplierArticleNumber = "05156R")
OR
(aa.SupplierID = 4668
AND aa.DataSupplierArticleNumber = "05163C")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "EF65/B01")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "CCF0180")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "AFL65/B01")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "COF100599E")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "CCF0180C")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "AFL6560B/C02")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "AF38Z/B01")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "XE599/606")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "EF60/B01")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "CAF100872P")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "AFL60/B01")
OR
(aa.SupplierID = 189
AND aa.DataSupplierArticleNumber = "21116")
OR
(aa.SupplierID = 189
AND aa.DataSupplierArticleNumber = "3011")
OR
(aa.SupplierID = 189
AND aa.DataSupplierArticleNumber = "65604")
OR
(aa.SupplierID = 189
AND aa.DataSupplierArticleNumber = "65607")
OR
(aa.SupplierID = 163
AND aa.DataSupplierArticleNumber = "ML4534")
OR
(aa.SupplierID = 163
AND aa.DataSupplierArticleNumber = "NC2345CA")
OR
(aa.SupplierID = 163
AND aa.DataSupplierArticleNumber = "MA3089")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "EAF630")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "CFWB650")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "EOF253")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "EKF175A")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "CFWB600")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "EKF175")
OR
(aa.SupplierID = 31
AND aa.DataSupplierArticleNumber = "6DPK2215")
OR
(aa.SupplierID = 31
AND aa.DataSupplierArticleNumber = "6PK2215")
OR
(aa.SupplierID = 140
AND aa.DataSupplierArticleNumber = "80001728")
OR
(aa.SupplierID = 140
AND aa.DataSupplierArticleNumber = "80000614")
OR
(aa.SupplierID = 140
AND aa.DataSupplierArticleNumber = "80000616")
OR
(aa.SupplierID = 66
AND aa.DataSupplierArticleNumber = "DF-025")
OR
(aa.SupplierID = 253
AND aa.DataSupplierArticleNumber = "DCI0251M")
OR
(aa.SupplierID = 253
AND aa.DataSupplierArticleNumber = "DCI1151")
OR
(aa.SupplierID = 253
AND aa.DataSupplierArticleNumber = "DCI0151")
OR
(aa.SupplierID = 4357
AND aa.DataSupplierArticleNumber = "49540")
OR
(aa.SupplierID = 4357
AND aa.DataSupplierArticleNumber = "49260")
OR
(aa.SupplierID = 4357
AND aa.DataSupplierArticleNumber = "51800")
OR
(aa.SupplierID = 4357
AND aa.DataSupplierArticleNumber = "49270")
OR
(aa.SupplierID = 4357
AND aa.DataSupplierArticleNumber = "28360")
OR
(aa.SupplierID = 4357
AND aa.DataSupplierArticleNumber = "51810")
OR
(aa.SupplierID = 4357
AND aa.DataSupplierArticleNumber = "49360")
OR
(aa.SupplierID = 4357
AND aa.DataSupplierArticleNumber = "49180")
OR
(aa.SupplierID = 4357
AND aa.DataSupplierArticleNumber = "51770")
OR
(aa.SupplierID = 4585
AND aa.DataSupplierArticleNumber = "DVF60")
OR
(aa.SupplierID = 4585
AND aa.DataSupplierArticleNumber = "DVF65")
OR
(aa.SupplierID = 4948
AND aa.DataSupplierArticleNumber = "DP3310.10.105")
OR
(aa.SupplierID = 4948
AND aa.DataSupplierArticleNumber = "DP3310.10.078")
OR
(aa.SupplierID = 4948
AND aa.DataSupplierArticleNumber = "DP3310.10.084")
OR
(aa.SupplierID = 4948
AND aa.DataSupplierArticleNumber = "DP3310.10.140")
OR
(aa.SupplierID = 4948
AND aa.DataSupplierArticleNumber = "DP1110.11.0126")
OR
(aa.SupplierID = 4948
AND aa.DataSupplierArticleNumber = "DP3310.10.015")
OR
(aa.SupplierID = 4948
AND aa.DataSupplierArticleNumber = "DP1110.10.0146")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DCFK307")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DAF1845")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DCF307")
OR
(aa.SupplierID = 4881
AND aa.DataSupplierArticleNumber = "500522")
OR
(aa.SupplierID = 10
AND aa.DataSupplierArticleNumber = "115.100")
OR
(aa.SupplierID = 10
AND aa.DataSupplierArticleNumber = "295.540")
OR
(aa.SupplierID = 237
AND aa.DataSupplierArticleNumber = "5256009")
OR
(aa.SupplierID = 398
AND aa.DataSupplierArticleNumber = "E113650")
OR
(aa.SupplierID = 398
AND aa.DataSupplierArticleNumber = "E113658")
OR
(aa.SupplierID = 398
AND aa.DataSupplierArticleNumber = "E100085")
OR
(aa.SupplierID = 398
AND aa.DataSupplierArticleNumber = "E100054")
OR
(aa.SupplierID = 398
AND aa.DataSupplierArticleNumber = "E113680")
OR
(aa.SupplierID = 398
AND aa.DataSupplierArticleNumber = "E113659")
OR
(aa.SupplierID = 398
AND aa.DataSupplierArticleNumber = "E100062")
OR
(aa.SupplierID = 398
AND aa.DataSupplierArticleNumber = "E113665")
OR
(aa.SupplierID = 398
AND aa.DataSupplierArticleNumber = "E100024")
OR
(aa.SupplierID = 398
AND aa.DataSupplierArticleNumber = "E100076")
OR
(aa.SupplierID = 398
AND aa.DataSupplierArticleNumber = "E113667")
OR
(aa.SupplierID = 4938
AND aa.DataSupplierArticleNumber = "FT93250")
OR
(aa.SupplierID = 4938
AND aa.DataSupplierArticleNumber = "FT93251")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "07215")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "09463")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "30018")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "10072")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "22806")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "29013")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "47282")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "26680")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "30640")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "34870")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "04054")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "47283")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "10098")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "26681")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "24661")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "30641")
OR
(aa.SupplierID = 271
AND aa.DataSupplierArticleNumber = "FCS190")
OR
(aa.SupplierID = 4838
AND aa.DataSupplierArticleNumber = "F-629")
OR
(aa.SupplierID = 4838
AND aa.DataSupplierArticleNumber = "FA-2058")
OR
(aa.SupplierID = 4659
AND aa.DataSupplierArticleNumber = "HC 7135")
OR
(aa.SupplierID = 4659
AND aa.DataSupplierArticleNumber = "HCK 7135")
OR
(aa.SupplierID = 256
AND aa.DataSupplierArticleNumber = "K1288A")
OR
(aa.SupplierID = 256
AND aa.DataSupplierArticleNumber = "AP157/6")
OR
(aa.SupplierID = 256
AND aa.DataSupplierArticleNumber = "OE677/4")
OR
(aa.SupplierID = 256
AND aa.DataSupplierArticleNumber = "K1288")
OR
(aa.SupplierID = 441
AND aa.DataSupplierArticleNumber = "177")
OR
(aa.SupplierID = 441
AND aa.DataSupplierArticleNumber = "677")
OR
(aa.SupplierID = 4581
AND aa.DataSupplierArticleNumber = "AF55735")
OR
(aa.SupplierID = 4581
AND aa.DataSupplierArticleNumber = "AF55769")
OR
(aa.SupplierID = 4581
AND aa.DataSupplierArticleNumber = "TF15074")
OR
(aa.SupplierID = 4581
AND aa.DataSupplierArticleNumber = "AF26375")
OR
(aa.SupplierID = 4581
AND aa.DataSupplierArticleNumber = "AF26462")
OR
(aa.SupplierID = 4581
AND aa.DataSupplierArticleNumber = "LF4000")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "6DPK2215")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "6PK2213")
OR
(aa.SupplierID = 33
AND aa.DataSupplierArticleNumber = "6DPK2215")
OR
(aa.SupplierID = 33
AND aa.DataSupplierArticleNumber = "6PK2213")
OR
(aa.SupplierID = 4663
AND aa.DataSupplierArticleNumber = "AG 221")
OR
(aa.SupplierID = 4663
AND aa.DataSupplierArticleNumber = "AG 1007")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 190 680-261")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 197 765-241")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 197 765-261")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 190 680-241")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "E2916LI")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "E821L")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "E87H D153")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "E2916LC")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "E11H D204")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "17411")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "14167")
OR
(aa.SupplierID = 204
AND aa.DataSupplierArticleNumber = "FB 6PK2215")
OR
(aa.SupplierID = 4689
AND aa.DataSupplierArticleNumber = "B4M026PR")
OR
(aa.SupplierID = 4689
AND aa.DataSupplierArticleNumber = "B1M030PR")
OR
(aa.SupplierID = 4689
AND aa.DataSupplierArticleNumber = "B2M069PR")
OR
(aa.SupplierID = 138
AND aa.DataSupplierArticleNumber = "IRF 1151")
OR
(aa.SupplierID = 138
AND aa.DataSupplierArticleNumber = "IRF 0151")
OR
(aa.SupplierID = 138
AND aa.DataSupplierArticleNumber = "IRF 0251M")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1331900500")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1128100400")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1331900509")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1118609100")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1128104200")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1318502100")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "F414801")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "F509001")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "27D02")
OR
(aa.SupplierID = 34
AND aa.DataSupplierArticleNumber = "LA 307")
OR
(aa.SupplierID = 34
AND aa.DataSupplierArticleNumber = "LX 1845")
OR
(aa.SupplierID = 34
AND aa.DataSupplierArticleNumber = "HX 81D")
OR
(aa.SupplierID = 34
AND aa.DataSupplierArticleNumber = "LAK 307")
OR
(aa.SupplierID = 432
AND aa.DataSupplierArticleNumber = "50014163")
OR
(aa.SupplierID = 432
AND aa.DataSupplierArticleNumber = "50014483")
OR
(aa.SupplierID = 432
AND aa.DataSupplierArticleNumber = "50014228")
OR
(aa.SupplierID = 432
AND aa.DataSupplierArticleNumber = "50014229")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "K65PBCDE")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "K60PB")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "1701055")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "K60PBCDE")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "K65PB")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "1731125")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000322")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000273")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000238")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000336")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000323")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000274")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000242")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000240")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P003758")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000326")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000312")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000385")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P003760")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000327")
OR
(aa.SupplierID = 4973
AND aa.DataSupplierArticleNumber = "LFAF515")
OR
(aa.SupplierID = 4973
AND aa.DataSupplierArticleNumber = "LFCP179")
OR
(aa.SupplierID = 4973
AND aa.DataSupplierArticleNumber = "LFOE208")
OR
(aa.SupplierID = 4973
AND aa.DataSupplierArticleNumber = "LFCP275")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "LA-1248")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "LAC-1236")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "LAC-1236C")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "LO-1907")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "350203062280")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "152071762000")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "153071760763")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "LX 1845")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "LA 307")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "LAK 307")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "HX 81D")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "H 27 001")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "C 4312/1")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "FP 3569")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "CU 2603")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "CU 3569")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "HU 7010 z")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "H 182 KIT")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "CUK 3569")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "29990")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "60655")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "69001")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "64816")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "65231")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "68889")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "67231")
OR
(aa.SupplierID = 358
AND aa.DataSupplierArticleNumber = "4312/1-LF-PCS-MS")
OR
(aa.SupplierID = 358
AND aa.DataSupplierArticleNumber = "7010Z-OF-PCS-MS")
OR
(aa.SupplierID = 358
AND aa.DataSupplierArticleNumber = "3569-IF-PCS-MS")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "26-0514")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "26-0848")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "26-0525")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "26-0019")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "17411")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "14167")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "ELR7310")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "ELH4429")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "EKR7228")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "ELR7228")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "ELP9165")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "012 319 0038")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "012 321 0010")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "014 322 0014")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "014 135 0302")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "012 320 0038")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "029 600 2400")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "014 019 2800")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "014 135 0402")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "029 650 2600")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "014 135 0202")
OR
(aa.SupplierID = 462
AND aa.DataSupplierArticleNumber = "K 986C")
OR
(aa.SupplierID = 462
AND aa.DataSupplierArticleNumber = "K 747")
OR
(aa.SupplierID = 4470
AND aa.DataSupplierArticleNumber = "P340")
OR
(aa.SupplierID = 4470
AND aa.DataSupplierArticleNumber = "HB197")
OR
(aa.SupplierID = 4470
AND aa.DataSupplierArticleNumber = "HB197C")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "VFA1187")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "LVCF559")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "LVFL775")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "VCF410")
OR
(aa.SupplierID = 490
AND aa.DataSupplierArticleNumber = "FOP312")
OR
(aa.SupplierID = 490
AND aa.DataSupplierArticleNumber = "FK264")
OR
(aa.SupplierID = 490
AND aa.DataSupplierArticleNumber = "PA3216")
OR
(aa.SupplierID = 248
AND aa.DataSupplierArticleNumber = "N1311040")
OR
(aa.SupplierID = 440
AND aa.DataSupplierArticleNumber = "N131N33")
OR
(aa.SupplierID = 4380
AND aa.DataSupplierArticleNumber = "2133079")
OR
(aa.SupplierID = 4380
AND aa.DataSupplierArticleNumber = "2135514")
OR
(aa.SupplierID = 4380
AND aa.DataSupplierArticleNumber = "2136186")
OR
(aa.SupplierID = 4683
AND aa.DataSupplierArticleNumber = "06308")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PF2307")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "6PK2213")
OR
(aa.SupplierID = 4543
AND aa.DataSupplierArticleNumber = "86010600")
OR
(aa.SupplierID = 4543
AND aa.DataSupplierArticleNumber = "86010650")
OR
(aa.SupplierID = 4686
AND aa.DataSupplierArticleNumber = "1540-0339")
OR
(aa.SupplierID = 4686
AND aa.DataSupplierArticleNumber = "1512-2629")
OR
(aa.SupplierID = 4686
AND aa.DataSupplierArticleNumber = "1521-2216")
OR
(aa.SupplierID = 4686
AND aa.DataSupplierArticleNumber = "1521-2271")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QAW024")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QAW026")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QFL0282")
OR
(aa.SupplierID = 461
AND aa.DataSupplierArticleNumber = "1213102")
OR
(aa.SupplierID = 461
AND aa.DataSupplierArticleNumber = "1121101")
OR
(aa.SupplierID = 461
AND aa.DataSupplierArticleNumber = "1212100")
OR
(aa.SupplierID = 461
AND aa.DataSupplierArticleNumber = "1213101")
OR
(aa.SupplierID = 100
AND aa.DataSupplierArticleNumber = "6K2215")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "AEROTECH 9470")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "SB 2167")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "7715 O.E.M. 5W-30")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "AEROTECH 9106")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "SA 1227")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "Energy Formula PD 5W40")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "AEROTECH 9107")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "9107-9106")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "SH 425/1 P")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "SAK 227")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "Dexron VI")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "AEROTECH 9469")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "9470-9469")
OR
(aa.SupplierID = 27
AND aa.DataSupplierArticleNumber = "177")
OR
(aa.SupplierID = 27
AND aa.DataSupplierArticleNumber = "677")
OR
(aa.SupplierID = 4768
AND aa.DataSupplierArticleNumber = "G760")
OR
(aa.SupplierID = 4768
AND aa.DataSupplierArticleNumber = "P760")
OR
(aa.SupplierID = 50
AND aa.DataSupplierArticleNumber = "VKMV 6PK2211")
OR
(aa.SupplierID = 142
AND aa.DataSupplierArticleNumber = "S 3137 C")
OR
(aa.SupplierID = 142
AND aa.DataSupplierArticleNumber = "S 4161 CA")
OR
(aa.SupplierID = 142
AND aa.DataSupplierArticleNumber = "S 3340 A")
OR
(aa.SupplierID = 142
AND aa.DataSupplierArticleNumber = "S 5159 PE")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "201 614-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "20-50519-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "20-51001-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "20-50558-SX")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "99 90 9463")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "99 91 0098")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "10 92 6680")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "10 93 4870")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "30 92 9013")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "99 90 4054")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "10 94 7282")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "10 92 6681")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "10 92 4661")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "10 91 0072")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "10 93 0640")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "99 90 7215")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "10 94 7283")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "10 93 0018")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "10 92 2806")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "10 93 0641")
OR
(aa.SupplierID = 19
AND aa.DataSupplierArticleNumber = "119407")
OR
(aa.SupplierID = 19
AND aa.DataSupplierArticleNumber = "119508")
OR
(aa.SupplierID = 4011
AND aa.DataSupplierArticleNumber = "OL011277-E")
OR
(aa.SupplierID = 4011
AND aa.DataSupplierArticleNumber = "AR4312PM")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "111 659")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "400 457")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "400 451")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "407 778")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "409 220")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "111 660")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "113 184")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "407 792")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "401 337")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "408 516")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "409 092")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "409 119")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "EFB6517R")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "EFB6017L")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "TXB650")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "TF650L")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "NF657")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "FX600")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "EFB6017R")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "35-240")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "TF650R")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "TF600L")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "FX650")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "EFB6517L")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "35-260")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "TXB600")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "TF600R")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "NF607")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8640 662215")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8640 602213")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "02.19.258")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "02.18.100")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "02.59.084")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "02.58.409")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "02.43.192")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "88.25.005")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "02.14.064")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "02.18.032")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "88.25.006")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "02.59.082")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "02.25.031")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "02.25.033")
OR
(aa.SupplierID = 137
AND aa.DataSupplierArticleNumber = "54.161.00")
OR
(aa.SupplierID = 137
AND aa.DataSupplierArticleNumber = "30.340.00")
OR
(aa.SupplierID = 137
AND aa.DataSupplierArticleNumber = "25.159.00")
OR
(aa.SupplierID = 137
AND aa.DataSupplierArticleNumber = "53.137.00")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0060")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V10-3327")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V30-7316")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0078")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0185")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0100")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0079")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0082")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V30-2318")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V30-0455")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0053")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V30-1928")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0260")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0183")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0080")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V10-0441")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0083")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0054")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V30-7313")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V30-0931")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0184")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0081")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0099")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "575789")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "574361")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "574362")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "585198")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "715601")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "575788")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "574334")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "715602")
OR
(aa.SupplierID = 183
AND aa.DataSupplierArticleNumber = "V30-31-1053")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1019217")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1805387")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1432760")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1233557")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1215345")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1794583")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1019009")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1153170")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1794533")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1217290")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1234162")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1215635")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1019072")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1216098")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1428752")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1084960")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1794567")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1427082")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1427210")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1794440")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1214732")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1233555")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1019073")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1427307")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1796118")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1794568")
OR
(aa.SupplierID = 324
AND aa.DataSupplierArticleNumber = "WP9331")
OR
(aa.SupplierID = 324
AND aa.DataSupplierArticleNumber = "WL7470")
OR
(aa.SupplierID = 324
AND aa.DataSupplierArticleNumber = "WP9330")
OR
(aa.SupplierID = 324
AND aa.DataSupplierArticleNumber = "WA9520")
OR
(aa.SupplierID = 188
AND aa.DataSupplierArticleNumber = "21116")
OR
(aa.SupplierID = 188
AND aa.DataSupplierArticleNumber = "3011")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "HW-600")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "IF-3147")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "OF-4175E")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "HW-650")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "IF-3147K")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "FW-600")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "OF-4416G")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "LF-1565")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "FW-650")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "OF-4431G")
)
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 = "K30264")
OR
(aa.SupplierID = 4814
AND aa.DataSupplierArticleNumber = "E50312")
OR
(aa.SupplierID = 4814
AND aa.DataSupplierArticleNumber = "A63216")
OR
(aa.SupplierID = 228
AND aa.DataSupplierArticleNumber = "1654")
OR
(aa.SupplierID = 228
AND aa.DataSupplierArticleNumber = "654")
OR
(aa.SupplierID = 4533
AND aa.DataSupplierArticleNumber = "143218")
OR
(aa.SupplierID = 166
AND aa.DataSupplierArticleNumber = "ATF-92001")
OR
(aa.SupplierID = 166
AND aa.DataSupplierArticleNumber = "ATF-92005")
OR
(aa.SupplierID = 180
AND aa.DataSupplierArticleNumber = "MD-8282")
OR
(aa.SupplierID = 180
AND aa.DataSupplierArticleNumber = "MD-683")
OR
(aa.SupplierID = 180
AND aa.DataSupplierArticleNumber = "TR-013")
OR
(aa.SupplierID = 4866
AND aa.DataSupplierArticleNumber = "SuperTronic 0W-40")
OR
(aa.SupplierID = 4866
AND aa.DataSupplierArticleNumber = "HighTronic G 5W-30")
OR
(aa.SupplierID = 4866
AND aa.DataSupplierArticleNumber = "SuperT LA 5W-30")
OR
(aa.SupplierID = 4866
AND aa.DataSupplierArticleNumber = "SuperTr LL III 5W-30")
OR
(aa.SupplierID = 4866
AND aa.DataSupplierArticleNumber = "HighTronic 5W-40")
OR
(aa.SupplierID = 4576
AND aa.DataSupplierArticleNumber = "71698")
OR
(aa.SupplierID = 4576
AND aa.DataSupplierArticleNumber = "71699")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "M001-50")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "ASH2-600")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "US102243")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "ASH2-650")
OR
(aa.SupplierID = 4337
AND aa.DataSupplierArticleNumber = "R145")
OR
(aa.SupplierID = 4337
AND aa.DataSupplierArticleNumber = "520")
OR
(aa.SupplierID = 4337
AND aa.DataSupplierArticleNumber = "R163")
OR
(aa.SupplierID = 4337
AND aa.DataSupplierArticleNumber = "I62")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "WBF650")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "WBF600")
OR
(aa.SupplierID = 4995
AND aa.DataSupplierArticleNumber = "001-10-16884")
OR
(aa.SupplierID = 4995
AND aa.DataSupplierArticleNumber = "001-10-16685")
OR
(aa.SupplierID = 4995
AND aa.DataSupplierArticleNumber = "001-20-03274")
OR
(aa.SupplierID = 4995
AND aa.DataSupplierArticleNumber = "001-20-03354")
OR
(aa.SupplierID = 350
AND aa.DataSupplierArticleNumber = "ADV182234")
OR
(aa.SupplierID = 350
AND aa.DataSupplierArticleNumber = "ADU172101")
OR
(aa.SupplierID = 350
AND aa.DataSupplierArticleNumber = "ADU172511")
OR
(aa.SupplierID = 350
AND aa.DataSupplierArticleNumber = "ADA102132")
OR
(aa.SupplierID = 350
AND aa.DataSupplierArticleNumber = "AD07R2050")
OR
(aa.SupplierID = 350
AND aa.DataSupplierArticleNumber = "ADA100105")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BW24F")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BFC1061")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BFA2015")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BW26F")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "F 026 407 112")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "1 987 432 513")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "F 026 400 055")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 008 587")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "1 987 946 275")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 007 216")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 006 951")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 008 051")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 006 952")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "1 987 432 213")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 986 626 852")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 008 585")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 007 215")
OR
(aa.SupplierID = 4455
AND aa.DataSupplierArticleNumber = "SIL SB 2624 B")
OR
(aa.SupplierID = 157
AND aa.DataSupplierArticleNumber = "BSP21723")
OR
(aa.SupplierID = 4668
AND aa.DataSupplierArticleNumber = "005287")
OR
(aa.SupplierID = 4668
AND aa.DataSupplierArticleNumber = "05163R")
OR
(aa.SupplierID = 4668
AND aa.DataSupplierArticleNumber = "005355")
OR
(aa.SupplierID = 4668
AND aa.DataSupplierArticleNumber = "05192R")
OR
(aa.SupplierID = 4668
AND aa.DataSupplierArticleNumber = "05156R")
OR
(aa.SupplierID = 4668
AND aa.DataSupplierArticleNumber = "05163C")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "EF65/B01")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "CCF0180")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "AFL65/B01")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "COF100599E")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "CCF0180C")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "AFL6560B/C02")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "AF38Z/B01")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "XE599/606")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "EF60/B01")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "CAF100872P")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "AFL60/B01")
OR
(aa.SupplierID = 189
AND aa.DataSupplierArticleNumber = "21116")
OR
(aa.SupplierID = 189
AND aa.DataSupplierArticleNumber = "3011")
OR
(aa.SupplierID = 189
AND aa.DataSupplierArticleNumber = "65604")
OR
(aa.SupplierID = 189
AND aa.DataSupplierArticleNumber = "65607")
OR
(aa.SupplierID = 163
AND aa.DataSupplierArticleNumber = "ML4534")
OR
(aa.SupplierID = 163
AND aa.DataSupplierArticleNumber = "NC2345CA")
OR
(aa.SupplierID = 163
AND aa.DataSupplierArticleNumber = "MA3089")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "EAF630")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "CFWB650")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "EOF253")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "EKF175A")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "CFWB600")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "EKF175")
OR
(aa.SupplierID = 31
AND aa.DataSupplierArticleNumber = "6DPK2215")
OR
(aa.SupplierID = 31
AND aa.DataSupplierArticleNumber = "6PK2215")
OR
(aa.SupplierID = 140
AND aa.DataSupplierArticleNumber = "80001728")
OR
(aa.SupplierID = 140
AND aa.DataSupplierArticleNumber = "80000614")
OR
(aa.SupplierID = 140
AND aa.DataSupplierArticleNumber = "80000616")
OR
(aa.SupplierID = 66
AND aa.DataSupplierArticleNumber = "DF-025")
OR
(aa.SupplierID = 253
AND aa.DataSupplierArticleNumber = "DCI0251M")
OR
(aa.SupplierID = 253
AND aa.DataSupplierArticleNumber = "DCI1151")
OR
(aa.SupplierID = 253
AND aa.DataSupplierArticleNumber = "DCI0151")
OR
(aa.SupplierID = 4357
AND aa.DataSupplierArticleNumber = "49540")
OR
(aa.SupplierID = 4357
AND aa.DataSupplierArticleNumber = "49260")
OR
(aa.SupplierID = 4357
AND aa.DataSupplierArticleNumber = "51800")
OR
(aa.SupplierID = 4357
AND aa.DataSupplierArticleNumber = "49270")
OR
(aa.SupplierID = 4357
AND aa.DataSupplierArticleNumber = "28360")
OR
(aa.SupplierID = 4357
AND aa.DataSupplierArticleNumber = "51810")
OR
(aa.SupplierID = 4357
AND aa.DataSupplierArticleNumber = "49360")
OR
(aa.SupplierID = 4357
AND aa.DataSupplierArticleNumber = "49180")
OR
(aa.SupplierID = 4357
AND aa.DataSupplierArticleNumber = "51770")
OR
(aa.SupplierID = 4585
AND aa.DataSupplierArticleNumber = "DVF60")
OR
(aa.SupplierID = 4585
AND aa.DataSupplierArticleNumber = "DVF65")
OR
(aa.SupplierID = 4948
AND aa.DataSupplierArticleNumber = "DP3310.10.105")
OR
(aa.SupplierID = 4948
AND aa.DataSupplierArticleNumber = "DP3310.10.078")
OR
(aa.SupplierID = 4948
AND aa.DataSupplierArticleNumber = "DP3310.10.084")
OR
(aa.SupplierID = 4948
AND aa.DataSupplierArticleNumber = "DP3310.10.140")
OR
(aa.SupplierID = 4948
AND aa.DataSupplierArticleNumber = "DP1110.11.0126")
OR
(aa.SupplierID = 4948
AND aa.DataSupplierArticleNumber = "DP3310.10.015")
OR
(aa.SupplierID = 4948
AND aa.DataSupplierArticleNumber = "DP1110.10.0146")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DCFK307")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DAF1845")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DCF307")
OR
(aa.SupplierID = 4881
AND aa.DataSupplierArticleNumber = "500522")
OR
(aa.SupplierID = 10
AND aa.DataSupplierArticleNumber = "115.100")
OR
(aa.SupplierID = 10
AND aa.DataSupplierArticleNumber = "295.540")
OR
(aa.SupplierID = 237
AND aa.DataSupplierArticleNumber = "5256009")
OR
(aa.SupplierID = 398
AND aa.DataSupplierArticleNumber = "E113650")
OR
(aa.SupplierID = 398
AND aa.DataSupplierArticleNumber = "E113658")
OR
(aa.SupplierID = 398
AND aa.DataSupplierArticleNumber = "E100085")
OR
(aa.SupplierID = 398
AND aa.DataSupplierArticleNumber = "E100054")
OR
(aa.SupplierID = 398
AND aa.DataSupplierArticleNumber = "E113680")
OR
(aa.SupplierID = 398
AND aa.DataSupplierArticleNumber = "E113659")
OR
(aa.SupplierID = 398
AND aa.DataSupplierArticleNumber = "E100062")
OR
(aa.SupplierID = 398
AND aa.DataSupplierArticleNumber = "E113665")
OR
(aa.SupplierID = 398
AND aa.DataSupplierArticleNumber = "E100024")
OR
(aa.SupplierID = 398
AND aa.DataSupplierArticleNumber = "E100076")
OR
(aa.SupplierID = 398
AND aa.DataSupplierArticleNumber = "E113667")
OR
(aa.SupplierID = 4938
AND aa.DataSupplierArticleNumber = "FT93250")
OR
(aa.SupplierID = 4938
AND aa.DataSupplierArticleNumber = "FT93251")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "07215")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "09463")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "30018")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "10072")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "22806")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "29013")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "47282")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "26680")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "30640")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "34870")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "04054")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "47283")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "10098")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "26681")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "24661")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "30641")
OR
(aa.SupplierID = 271
AND aa.DataSupplierArticleNumber = "FCS190")
OR
(aa.SupplierID = 4838
AND aa.DataSupplierArticleNumber = "F-629")
OR
(aa.SupplierID = 4838
AND aa.DataSupplierArticleNumber = "FA-2058")
OR
(aa.SupplierID = 4659
AND aa.DataSupplierArticleNumber = "HC 7135")
OR
(aa.SupplierID = 4659
AND aa.DataSupplierArticleNumber = "HCK 7135")
OR
(aa.SupplierID = 256
AND aa.DataSupplierArticleNumber = "K1288A")
OR
(aa.SupplierID = 256
AND aa.DataSupplierArticleNumber = "AP157/6")
OR
(aa.SupplierID = 256
AND aa.DataSupplierArticleNumber = "OE677/4")
OR
(aa.SupplierID = 256
AND aa.DataSupplierArticleNumber = "K1288")
OR
(aa.SupplierID = 441
AND aa.DataSupplierArticleNumber = "177")
OR
(aa.SupplierID = 441
AND aa.DataSupplierArticleNumber = "677")
OR
(aa.SupplierID = 4581
AND aa.DataSupplierArticleNumber = "AF55735")
OR
(aa.SupplierID = 4581
AND aa.DataSupplierArticleNumber = "AF55769")
OR
(aa.SupplierID = 4581
AND aa.DataSupplierArticleNumber = "TF15074")
OR
(aa.SupplierID = 4581
AND aa.DataSupplierArticleNumber = "AF26375")
OR
(aa.SupplierID = 4581
AND aa.DataSupplierArticleNumber = "AF26462")
OR
(aa.SupplierID = 4581
AND aa.DataSupplierArticleNumber = "LF4000")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "6DPK2215")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "6PK2213")
OR
(aa.SupplierID = 33
AND aa.DataSupplierArticleNumber = "6DPK2215")
OR
(aa.SupplierID = 33
AND aa.DataSupplierArticleNumber = "6PK2213")
OR
(aa.SupplierID = 4663
AND aa.DataSupplierArticleNumber = "AG 221")
OR
(aa.SupplierID = 4663
AND aa.DataSupplierArticleNumber = "AG 1007")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 190 680-261")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 197 765-241")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 197 765-261")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 190 680-241")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "E2916LI")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "E821L")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "E87H D153")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "E2916LC")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "E11H D204")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "17411")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "14167")
OR
(aa.SupplierID = 204
AND aa.DataSupplierArticleNumber = "FB 6PK2215")
OR
(aa.SupplierID = 4689
AND aa.DataSupplierArticleNumber = "B4M026PR")
OR
(aa.SupplierID = 4689
AND aa.DataSupplierArticleNumber = "B1M030PR")
OR
(aa.SupplierID = 4689
AND aa.DataSupplierArticleNumber = "B2M069PR")
OR
(aa.SupplierID = 138
AND aa.DataSupplierArticleNumber = "IRF 1151")
OR
(aa.SupplierID = 138
AND aa.DataSupplierArticleNumber = "IRF 0151")
OR
(aa.SupplierID = 138
AND aa.DataSupplierArticleNumber = "IRF 0251M")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1331900500")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1128100400")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1331900509")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1118609100")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1128104200")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1318502100")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "F414801")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "F509001")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "27D02")
OR
(aa.SupplierID = 34
AND aa.DataSupplierArticleNumber = "LA 307")
OR
(aa.SupplierID = 34
AND aa.DataSupplierArticleNumber = "LX 1845")
OR
(aa.SupplierID = 34
AND aa.DataSupplierArticleNumber = "HX 81D")
OR
(aa.SupplierID = 34
AND aa.DataSupplierArticleNumber = "LAK 307")
OR
(aa.SupplierID = 432
AND aa.DataSupplierArticleNumber = "50014163")
OR
(aa.SupplierID = 432
AND aa.DataSupplierArticleNumber = "50014483")
OR
(aa.SupplierID = 432
AND aa.DataSupplierArticleNumber = "50014228")
OR
(aa.SupplierID = 432
AND aa.DataSupplierArticleNumber = "50014229")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "K65PBCDE")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "K60PB")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "1701055")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "K60PBCDE")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "K65PB")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "1731125")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000322")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000273")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000238")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000336")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000323")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000274")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000242")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000240")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P003758")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000326")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000312")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000385")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P003760")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000327")
OR
(aa.SupplierID = 4973
AND aa.DataSupplierArticleNumber = "LFAF515")
OR
(aa.SupplierID = 4973
AND aa.DataSupplierArticleNumber = "LFCP179")
OR
(aa.SupplierID = 4973
AND aa.DataSupplierArticleNumber = "LFOE208")
OR
(aa.SupplierID = 4973
AND aa.DataSupplierArticleNumber = "LFCP275")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "LA-1248")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "LAC-1236")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "LAC-1236C")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "LO-1907")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "350203062280")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "152071762000")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "153071760763")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "LX 1845")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "LA 307")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "LAK 307")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "HX 81D")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "H 27 001")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "C 4312/1")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "FP 3569")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "CU 2603")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "CU 3569")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "HU 7010 z")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "H 182 KIT")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "CUK 3569")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "29990")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "60655")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "69001")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "64816")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "65231")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "68889")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "67231")
OR
(aa.SupplierID = 358
AND aa.DataSupplierArticleNumber = "4312/1-LF-PCS-MS")
OR
(aa.SupplierID = 358
AND aa.DataSupplierArticleNumber = "7010Z-OF-PCS-MS")
OR
(aa.SupplierID = 358
AND aa.DataSupplierArticleNumber = "3569-IF-PCS-MS")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "26-0514")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "26-0848")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "26-0525")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "26-0019")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "17411")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "14167")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "ELR7310")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "ELH4429")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "EKR7228")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "ELR7228")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "ELP9165")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "012 319 0038")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "012 321 0010")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "014 322 0014")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "014 135 0302")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "012 320 0038")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "029 600 2400")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "014 019 2800")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "014 135 0402")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "029 650 2600")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "014 135 0202")
OR
(aa.SupplierID = 462
AND aa.DataSupplierArticleNumber = "K 986C")
OR
(aa.SupplierID = 462
AND aa.DataSupplierArticleNumber = "K 747")
OR
(aa.SupplierID = 4470
AND aa.DataSupplierArticleNumber = "P340")
OR
(aa.SupplierID = 4470
AND aa.DataSupplierArticleNumber = "HB197")
OR
(aa.SupplierID = 4470
AND aa.DataSupplierArticleNumber = "HB197C")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "VFA1187")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "LVCF559")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "LVFL775")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "VCF410")
OR
(aa.SupplierID = 490
AND aa.DataSupplierArticleNumber = "FOP312")
OR
(aa.SupplierID = 490
AND aa.DataSupplierArticleNumber = "FK264")
OR
(aa.SupplierID = 490
AND aa.DataSupplierArticleNumber = "PA3216")
OR
(aa.SupplierID = 248
AND aa.DataSupplierArticleNumber = "N1311040")
OR
(aa.SupplierID = 440
AND aa.DataSupplierArticleNumber = "N131N33")
OR
(aa.SupplierID = 4380
AND aa.DataSupplierArticleNumber = "2133079")
OR
(aa.SupplierID = 4380
AND aa.DataSupplierArticleNumber = "2135514")
OR
(aa.SupplierID = 4380
AND aa.DataSupplierArticleNumber = "2136186")
OR
(aa.SupplierID = 4683
AND aa.DataSupplierArticleNumber = "06308")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PF2307")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "6PK2213")
OR
(aa.SupplierID = 4543
AND aa.DataSupplierArticleNumber = "86010600")
OR
(aa.SupplierID = 4543
AND aa.DataSupplierArticleNumber = "86010650")
OR
(aa.SupplierID = 4686
AND aa.DataSupplierArticleNumber = "1540-0339")
OR
(aa.SupplierID = 4686
AND aa.DataSupplierArticleNumber = "1512-2629")
OR
(aa.SupplierID = 4686
AND aa.DataSupplierArticleNumber = "1521-2216")
OR
(aa.SupplierID = 4686
AND aa.DataSupplierArticleNumber = "1521-2271")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QAW024")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QAW026")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QFL0282")
OR
(aa.SupplierID = 461
AND aa.DataSupplierArticleNumber = "1213102")
OR
(aa.SupplierID = 461
AND aa.DataSupplierArticleNumber = "1121101")
OR
(aa.SupplierID = 461
AND aa.DataSupplierArticleNumber = "1212100")
OR
(aa.SupplierID = 461
AND aa.DataSupplierArticleNumber = "1213101")
OR
(aa.SupplierID = 100
AND aa.DataSupplierArticleNumber = "6K2215")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "AEROTECH 9470")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "SB 2167")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "7715 O.E.M. 5W-30")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "AEROTECH 9106")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "SA 1227")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "Energy Formula PD 5W40")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "AEROTECH 9107")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "9107-9106")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "SH 425/1 P")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "SAK 227")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "Dexron VI")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "AEROTECH 9469")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "9470-9469")
OR
(aa.SupplierID = 27
AND aa.DataSupplierArticleNumber = "177")
OR
(aa.SupplierID = 27
AND aa.DataSupplierArticleNumber = "677")
OR
(aa.SupplierID = 4768
AND aa.DataSupplierArticleNumber = "G760")
OR
(aa.SupplierID = 4768
AND aa.DataSupplierArticleNumber = "P760")
OR
(aa.SupplierID = 50
AND aa.DataSupplierArticleNumber = "VKMV 6PK2211")
OR
(aa.SupplierID = 142
AND aa.DataSupplierArticleNumber = "S 3137 C")
OR
(aa.SupplierID = 142
AND aa.DataSupplierArticleNumber = "S 4161 CA")
OR
(aa.SupplierID = 142
AND aa.DataSupplierArticleNumber = "S 3340 A")
OR
(aa.SupplierID = 142
AND aa.DataSupplierArticleNumber = "S 5159 PE")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "201 614-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "20-50519-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "20-51001-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "20-50558-SX")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "99 90 9463")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "99 91 0098")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "10 92 6680")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "10 93 4870")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "30 92 9013")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "99 90 4054")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "10 94 7282")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "10 92 6681")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "10 92 4661")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "10 91 0072")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "10 93 0640")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "99 90 7215")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "10 94 7283")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "10 93 0018")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "10 92 2806")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "10 93 0641")
OR
(aa.SupplierID = 19
AND aa.DataSupplierArticleNumber = "119407")
OR
(aa.SupplierID = 19
AND aa.DataSupplierArticleNumber = "119508")
OR
(aa.SupplierID = 4011
AND aa.DataSupplierArticleNumber = "OL011277-E")
OR
(aa.SupplierID = 4011
AND aa.DataSupplierArticleNumber = "AR4312PM")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "111 659")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "400 457")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "400 451")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "407 778")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "409 220")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "111 660")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "113 184")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "407 792")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "401 337")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "408 516")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "409 092")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "409 119")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "EFB6517R")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "EFB6017L")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "TXB650")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "TF650L")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "NF657")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "FX600")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "EFB6017R")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "35-240")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "TF650R")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "TF600L")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "FX650")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "EFB6517L")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "35-260")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "TXB600")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "TF600R")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "NF607")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8640 662215")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8640 602213")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "02.19.258")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "02.18.100")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "02.59.084")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "02.58.409")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "02.43.192")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "88.25.005")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "02.14.064")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "02.18.032")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "88.25.006")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "02.59.082")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "02.25.031")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "02.25.033")
OR
(aa.SupplierID = 137
AND aa.DataSupplierArticleNumber = "54.161.00")
OR
(aa.SupplierID = 137
AND aa.DataSupplierArticleNumber = "30.340.00")
OR
(aa.SupplierID = 137
AND aa.DataSupplierArticleNumber = "25.159.00")
OR
(aa.SupplierID = 137
AND aa.DataSupplierArticleNumber = "53.137.00")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0060")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V10-3327")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V30-7316")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0078")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0185")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0100")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0079")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0082")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V30-2318")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V30-0455")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0053")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V30-1928")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0260")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0183")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0080")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V10-0441")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0083")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0054")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V30-7313")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V30-0931")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0184")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0081")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0099")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "575789")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "574361")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "574362")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "585198")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "715601")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "575788")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "574334")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "715602")
OR
(aa.SupplierID = 183
AND aa.DataSupplierArticleNumber = "V30-31-1053")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1019217")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1805387")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1432760")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1233557")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1215345")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1794583")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1019009")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1153170")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1794533")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1217290")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1234162")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1215635")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1019072")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1216098")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1428752")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1084960")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1794567")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1427082")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1427210")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1794440")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1214732")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1233555")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1019073")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1427307")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1796118")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1794568")
OR
(aa.SupplierID = 324
AND aa.DataSupplierArticleNumber = "WP9331")
OR
(aa.SupplierID = 324
AND aa.DataSupplierArticleNumber = "WL7470")
OR
(aa.SupplierID = 324
AND aa.DataSupplierArticleNumber = "WP9330")
OR
(aa.SupplierID = 324
AND aa.DataSupplierArticleNumber = "WA9520")
OR
(aa.SupplierID = 188
AND aa.DataSupplierArticleNumber = "21116")
OR
(aa.SupplierID = 188
AND aa.DataSupplierArticleNumber = "3011")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "HW-600")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "IF-3147")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "OF-4175E")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "HW-650")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "IF-3147K")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "FW-600")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "OF-4416G")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "LF-1565")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "FW-650")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "OF-4431G")
)
AND aa.Language = "ru"
Продажа автозапчастей типа Интервал регулировки для автомобилей
