#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTg1Mnx8bW9kZWxfaWQ9PTY3MjF8fG1kZl9pZD09MF4yNDQ4Mnx8c3BhcmVfaWQ9PTEwMDU5Nw%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 = "24482"
AND (
(av.SupplierID = 4814
AND av.DataSupplierArticleNumber = "A63154"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4814
AND av.DataSupplierArticleNumber = "E50115"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4814
AND av.DataSupplierArticleNumber = "C30176"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4814
AND av.DataSupplierArticleNumber = "K30176"
AND av.ProductID IN (424))
OR
(av.SupplierID = 228
AND av.DataSupplierArticleNumber = "1472/1"
AND av.ProductID IN (424))
OR
(av.SupplierID = 228
AND av.DataSupplierArticleNumber = "472/1"
AND av.ProductID IN (424))
OR
(av.SupplierID = 180
AND av.DataSupplierArticleNumber = "MD-8208"
AND av.ProductID IN (8))
OR
(av.SupplierID = 180
AND av.DataSupplierArticleNumber = "MD-463"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4866
AND av.DataSupplierArticleNumber = "SuperTronic G 0W-40"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 4866
AND av.DataSupplierArticleNumber = "ATF J"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 4866
AND av.DataSupplierArticleNumber = "HighTronic G 5W-30"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 257
AND av.DataSupplierArticleNumber = "SA-X30R"
AND av.ProductID IN (298))
OR
(av.SupplierID = 442
AND av.DataSupplierArticleNumber = "WA023"
AND av.ProductID IN (298))
OR
(av.SupplierID = 442
AND av.DataSupplierArticleNumber = "WAR011"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4337
AND av.DataSupplierArticleNumber = "R23"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4337
AND av.DataSupplierArticleNumber = "I31"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4464
AND av.DataSupplierArticleNumber = "WBF580"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4995
AND av.DataSupplierArticleNumber = "031-20-01915"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4995
AND av.DataSupplierArticleNumber = "006-20-01414"
AND av.ProductID IN (424))
OR
(av.SupplierID = 11
AND av.DataSupplierArticleNumber = "UPT2"
AND av.ProductID IN (686))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BFC1000"
AND av.ProductID IN (424))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BW23C"
AND av.ProductID IN (298))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BFC1045"
AND av.ProductID IN (424))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BW23F"
AND av.ProductID IN (298))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BW24F"
AND av.ProductID IN (298))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BW12R"
AND av.ProductID IN (298))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BFA2073"
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 006 951"
AND av.ProductID IN (298))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "3 397 118 451"
AND av.ProductID IN (298))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "3 397 007 416"
AND av.ProductID IN (298))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "3 397 004 990"
AND av.ProductID IN (298))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "3 397 008 584"
AND av.ProductID IN (298))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "3 397 006 950"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4455
AND av.DataSupplierArticleNumber = "BSG 65-145-009"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4455
AND av.DataSupplierArticleNumber = "BSG 65-145-005"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4668
AND av.DataSupplierArticleNumber = "05163C"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 4668
AND av.DataSupplierArticleNumber = "124080"
AND av.ProductID IN (3354))
OR
(av.SupplierID = 4668
AND av.DataSupplierArticleNumber = "004915"
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 = "005332"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 4668
AND av.DataSupplierArticleNumber = "05156R"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "XE568/606"
AND av.ProductID IN (7))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "CCF0015"
AND av.ProductID IN (424))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "OE188/R04"
AND av.ProductID IN (686))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "EON1/287"
AND av.ProductID IN (686))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "AP29/B01"
AND av.ProductID IN (298))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "CAF100949P"
AND av.ProductID IN (8))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "CET2"
AND av.ProductID IN (686))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "CCF0015C"
AND av.ProductID IN (424))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "OE188/T10"
AND av.ProductID IN (686))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "OE089/R04"
AND av.ProductID IN (686))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "EF58/B01"
AND av.ProductID IN (298))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "U949/606"
AND av.ProductID IN (8))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "CET2SB"
AND av.ProductID IN (686))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "A58/B01"
AND av.ProductID IN (298))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "COF100568E"
AND av.ProductID IN (7))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "OE089/T10"
AND av.ProductID IN (686))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "ER55/B01"
AND av.ProductID IN (298))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "EON1/286"
AND av.ProductID IN (686))
OR
(av.SupplierID = 43
AND av.DataSupplierArticleNumber = "AFL58/B01"
AND av.ProductID IN (298))
OR
(av.SupplierID = 189
AND av.DataSupplierArticleNumber = "5078"
AND av.ProductID IN (3354))
OR
(av.SupplierID = 189
AND av.DataSupplierArticleNumber = "21116"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 189
AND av.DataSupplierArticleNumber = "65607"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 189
AND av.DataSupplierArticleNumber = "3010"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 163
AND av.DataSupplierArticleNumber = "NC2062"
AND av.ProductID IN (424))
OR
(av.SupplierID = 163
AND av.DataSupplierArticleNumber = "MA3032"
AND av.ProductID IN (8))
OR
(av.SupplierID = 163
AND av.DataSupplierArticleNumber = "ML1717"
AND av.ProductID IN (7))
OR
(av.SupplierID = 163
AND av.DataSupplierArticleNumber = "NC2109CA"
AND av.ProductID IN (424))
OR
(av.SupplierID = 421
AND av.DataSupplierArticleNumber = "EKF116"
AND av.ProductID IN (424))
OR
(av.SupplierID = 421
AND av.DataSupplierArticleNumber = "EKF116A"
AND av.ProductID IN (424))
OR
(av.SupplierID = 421
AND av.DataSupplierArticleNumber = "EOF086"
AND av.ProductID IN (7))
OR
(av.SupplierID = 421
AND av.DataSupplierArticleNumber = "EAF695"
AND av.ProductID IN (8))
OR
(av.SupplierID = 437
AND av.DataSupplierArticleNumber = "PCK8097"
AND av.ProductID IN (424))
OR
(av.SupplierID = 437
AND av.DataSupplierArticleNumber = "FA5617ECO"
AND av.ProductID IN (7))
OR
(av.SupplierID = 437
AND av.DataSupplierArticleNumber = "PA7427"
AND av.ProductID IN (8))
OR
(av.SupplierID = 437
AND av.DataSupplierArticleNumber = "PC8097"
AND av.ProductID IN (424))
OR
(av.SupplierID = 140
AND av.DataSupplierArticleNumber = "041118S"
AND av.ProductID IN (135))
OR
(av.SupplierID = 140
AND av.DataSupplierArticleNumber = "21652714"
AND av.ProductID IN (424))
OR
(av.SupplierID = 140
AND av.DataSupplierArticleNumber = "21652715"
AND av.ProductID IN (424))
OR
(av.SupplierID = 42
AND av.DataSupplierArticleNumber = "5PK1025"
AND av.ProductID IN (305))
OR
(av.SupplierID = 89
AND av.DataSupplierArticleNumber = "MR51025"
AND av.ProductID IN (305))
OR
(av.SupplierID = 89
AND av.DataSupplierArticleNumber = "TSP0325296"
AND av.ProductID IN (424))
OR
(av.SupplierID = 89
AND av.DataSupplierArticleNumber = "TSP0325296C"
AND av.ProductID IN (424))
OR
(av.SupplierID = 186
AND av.DataSupplierArticleNumber = "A141397"
AND av.ProductID IN (8))
OR
(av.SupplierID = 186
AND av.DataSupplierArticleNumber = "M110030"
AND av.ProductID IN (424))
OR
(av.SupplierID = 186
AND av.DataSupplierArticleNumber = "A210191"
AND av.ProductID IN (7))
OR
(av.SupplierID = 186
AND av.DataSupplierArticleNumber = "M110210"
AND av.ProductID IN (424))
OR
(av.SupplierID = 66
AND av.DataSupplierArticleNumber = "K16TT"
AND av.ProductID IN (686))
OR
(av.SupplierID = 66
AND av.DataSupplierArticleNumber = "DF-043"
AND av.ProductID IN (298))
OR
(av.SupplierID = 66
AND av.DataSupplierArticleNumber = "KJ16CR-L11"
AND av.ProductID IN (686))
OR
(av.SupplierID = 66
AND av.DataSupplierArticleNumber = "IK16TT"
AND av.ProductID IN (686))
OR
(av.SupplierID = 253
AND av.DataSupplierArticleNumber = "DCI0068"
AND av.ProductID IN (424))
OR
(av.SupplierID = 253
AND av.DataSupplierArticleNumber = "DCI1068"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4357
AND av.DataSupplierArticleNumber = "51810"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 4357
AND av.DataSupplierArticleNumber = "49530"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 4357
AND av.DataSupplierArticleNumber = "49240"
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 = "49520"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 4357
AND av.DataSupplierArticleNumber = "28360"
AND av.ProductID IN (3354))
OR
(av.SupplierID = 4585
AND av.DataSupplierArticleNumber = "DVF58"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4948
AND av.DataSupplierArticleNumber = "DP3310.10.015"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 4948
AND av.DataSupplierArticleNumber = "DP3310.10.105"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 4948
AND av.DataSupplierArticleNumber = "DP3310.10.071"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 4948
AND av.DataSupplierArticleNumber = "DP1110.11.0085"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "300DR"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "575DF"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "DOFX258D"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "DCF117"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "600DF"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "DCFK117"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4881
AND av.DataSupplierArticleNumber = "502011"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 10
AND av.DataSupplierArticleNumber = "476.750"
AND av.ProductID IN (135))
OR
(av.SupplierID = 4344
AND av.DataSupplierArticleNumber = "LWCR12F"
AND av.ProductID IN (298))
OR
(av.SupplierID = 398
AND av.DataSupplierArticleNumber = "E100085"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 398
AND av.DataSupplierArticleNumber = "E113661"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 398
AND av.DataSupplierArticleNumber = "E113675"
AND av.ProductID IN (3354))
OR
(av.SupplierID = 398
AND av.DataSupplierArticleNumber = "E100054"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 398
AND av.DataSupplierArticleNumber = "E100076"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 4938
AND av.DataSupplierArticleNumber = "FT38080"
AND av.ProductID IN (7))
OR
(av.SupplierID = 271
AND av.DataSupplierArticleNumber = "FCS164"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4838
AND av.DataSupplierArticleNumber = "F-809"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4659
AND av.DataSupplierArticleNumber = "HCK 7050"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4659
AND av.DataSupplierArticleNumber = "MLE 1520"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4659
AND av.DataSupplierArticleNumber = "HC 7050"
AND av.ProductID IN (424))
OR
(av.SupplierID = 256
AND av.DataSupplierArticleNumber = "OE648/3"
AND av.ProductID IN (7))
OR
(av.SupplierID = 256
AND av.DataSupplierArticleNumber = "K1081"
AND av.ProductID IN (424))
OR
(av.SupplierID = 256
AND av.DataSupplierArticleNumber = "AP188/5"
AND av.ProductID IN (8))
OR
(av.SupplierID = 256
AND av.DataSupplierArticleNumber = "K1081A"
AND av.ProductID IN (424))
OR
(av.SupplierID = 441
AND av.DataSupplierArticleNumber = "MBX107"
AND av.ProductID IN (424))
OR
(av.SupplierID = 441
AND av.DataSupplierArticleNumber = "107"
AND av.ProductID IN (424))
OR
(av.SupplierID = 441
AND av.DataSupplierArticleNumber = "607"
AND av.ProductID IN (424))
OR
(av.SupplierID = 236
AND av.DataSupplierArticleNumber = "FW580E"
AND av.ProductID IN (298))
OR
(av.SupplierID = 59
AND av.DataSupplierArticleNumber = "CA9646"
AND av.ProductID IN (8))
OR
(av.SupplierID = 59
AND av.DataSupplierArticleNumber = "CF9495"
AND av.ProductID IN (424))
OR
(av.SupplierID = 59
AND av.DataSupplierArticleNumber = "CFA9495"
AND av.ProductID IN (424))
OR
(av.SupplierID = 59
AND av.DataSupplierArticleNumber = "CH9018ECO"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4663
AND av.DataSupplierArticleNumber = "AG 264 CF"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4663
AND av.DataSupplierArticleNumber = "OG 113 ECO"
AND av.ProductID IN (7))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "8EH 188 705-031"
AND av.ProductID IN (686))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "9XW 197 765-231"
AND av.ProductID IN (298))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "8EH 188 706-011"
AND av.ProductID IN (686))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "9XW 197 765-241"
AND av.ProductID IN (298))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "8EH 188 706-031"
AND av.ProductID IN (686))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "8EH 188 705-011"
AND av.ProductID IN (686))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "9XW 200 526-081"
AND av.ProductID IN (298))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "9XW 190 680-231"
AND av.ProductID IN (298))
OR
(av.SupplierID = 81
AND av.DataSupplierArticleNumber = "E972LI"
AND av.ProductID IN (424))
OR
(av.SupplierID = 81
AND av.DataSupplierArticleNumber = "E1192L"
AND av.ProductID IN (8))
OR
(av.SupplierID = 81
AND av.DataSupplierArticleNumber = "E972LC"
AND av.ProductID IN (424))
OR
(av.SupplierID = 81
AND av.DataSupplierArticleNumber = "E630H02 D103"
AND av.ProductID IN (7))
OR
(av.SupplierID = 55
AND av.DataSupplierArticleNumber = "J1310910"
AND av.ProductID IN (7))
OR
(av.SupplierID = 341
AND av.DataSupplierArticleNumber = "17113"
AND av.ProductID IN (424))
OR
(av.SupplierID = 341
AND av.DataSupplierArticleNumber = "17113K"
AND av.ProductID IN (424))
OR
(av.SupplierID = 341
AND av.DataSupplierArticleNumber = "14025"
AND av.ProductID IN (7))
OR
(av.SupplierID = 341
AND av.DataSupplierArticleNumber = "17177"
AND av.ProductID IN (424))
OR
(av.SupplierID = 341
AND av.DataSupplierArticleNumber = "14076"
AND av.ProductID IN (7))
OR
(av.SupplierID = 239
AND av.DataSupplierArticleNumber = "1030 K 5"
AND av.ProductID IN (305))
OR
(av.SupplierID = 156
AND av.DataSupplierArticleNumber = "SS-X30R"
AND av.ProductID IN (298))
OR
(av.SupplierID = 481
AND av.DataSupplierArticleNumber = "SJX30R"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4689
AND av.DataSupplierArticleNumber = "B4X014CPR"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4689
AND av.DataSupplierArticleNumber = "B2U013PR"
AND av.ProductID IN (8))
OR
(av.SupplierID = 138
AND av.DataSupplierArticleNumber = "IRF 1068"
AND av.ProductID IN (424))
OR
(av.SupplierID = 138
AND av.DataSupplierArticleNumber = "IRF 0068"
AND av.ProductID IN (424))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1228101800"
AND av.ProductID IN (424))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1218505909"
AND av.ProductID IN (7))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1218606009"
AND av.ProductID IN (8))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1228101100"
AND av.ProductID IN (424))
OR
(av.SupplierID = 305
AND av.DataSupplierArticleNumber = "SS-7000"
AND av.ProductID IN (7))
OR
(av.SupplierID = 305
AND av.DataSupplierArticleNumber = "PS-7000"
AND av.ProductID IN (7))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "27600"
AND av.ProductID IN (298))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "F500901"
AND av.ProductID IN (424))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "29012"
AND av.ProductID IN (298))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "27575"
AND av.ProductID IN (298))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "F402501"
AND av.ProductID IN (424))
OR
(av.SupplierID = 387
AND av.DataSupplierArticleNumber = "43047z"
AND av.ProductID IN (686))
OR
(av.SupplierID = 34
AND av.DataSupplierArticleNumber = "LAK 117"
AND av.ProductID IN (424))
OR
(av.SupplierID = 34
AND av.DataSupplierArticleNumber = "LA 117"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "1731515"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "K60PB"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "1731516"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "K60PBCDE"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "K58PB"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "1701701"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "K58PBCDE"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4907
AND av.DataSupplierArticleNumber = "Asyntho5W30"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 4907
AND av.DataSupplierArticleNumber = "Helar0W40"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 222
AND av.DataSupplierArticleNumber = "P000336"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 222
AND av.DataSupplierArticleNumber = "P000314"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 222
AND av.DataSupplierArticleNumber = "P000242"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 222
AND av.DataSupplierArticleNumber = "P000327"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 222
AND av.DataSupplierArticleNumber = "P000330"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 424
AND av.DataSupplierArticleNumber = "5PK1025L"
AND av.ProductID IN (305))
OR
(av.SupplierID = 4973
AND av.DataSupplierArticleNumber = "LFOE231"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4973
AND av.DataSupplierArticleNumber = "LFCP123"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4600
AND av.DataSupplierArticleNumber = "LR30A"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4600
AND av.DataSupplierArticleNumber = "LAC-1502"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4600
AND av.DataSupplierArticleNumber = "LA-1531"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4600
AND av.DataSupplierArticleNumber = "LAC-1502C"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4600
AND av.DataSupplierArticleNumber = "LO-1522"
AND av.ProductID IN (7))
OR
(av.SupplierID = 95
AND av.DataSupplierArticleNumber = "062130001312"
AND av.ProductID IN (686))
OR
(av.SupplierID = 95
AND av.DataSupplierArticleNumber = "062110150312"
AND av.ProductID IN (686))
OR
(av.SupplierID = 95
AND av.DataSupplierArticleNumber = "350203062120"
AND av.ProductID IN (424))
OR
(av.SupplierID = 287
AND av.DataSupplierArticleNumber = "LAK 117"
AND av.ProductID IN (424))
OR
(av.SupplierID = 287
AND av.DataSupplierArticleNumber = "LA 117"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4
AND av.DataSupplierArticleNumber = "CU 3337"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4
AND av.DataSupplierArticleNumber = "CUK 3337"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4
AND av.DataSupplierArticleNumber = "C 30 170"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4
AND av.DataSupplierArticleNumber = "FP 3337"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4
AND av.DataSupplierArticleNumber = "HU 6007 x"
AND av.ProductID IN (7))
OR
(av.SupplierID = 133
AND av.DataSupplierArticleNumber = "104575HPS"
AND av.ProductID IN (298))
OR
(av.SupplierID = 133
AND av.DataSupplierArticleNumber = "29990"
AND av.ProductID IN (417))
OR
(av.SupplierID = 133
AND av.DataSupplierArticleNumber = "65713"
AND av.ProductID IN (424))
OR
(av.SupplierID = 403
AND av.DataSupplierArticleNumber = "39-0010"
AND av.ProductID IN (298))
OR
(av.SupplierID = 403
AND av.DataSupplierArticleNumber = "26-0301"
AND av.ProductID IN (7))
OR
(av.SupplierID = 403
AND av.DataSupplierArticleNumber = "39-0078"
AND av.ProductID IN (298))
OR
(av.SupplierID = 403
AND av.DataSupplierArticleNumber = "26-0909"
AND av.ProductID IN (8))
OR
(av.SupplierID = 403
AND av.DataSupplierArticleNumber = "26-0063"
AND av.ProductID IN (424))
OR
(av.SupplierID = 403
AND av.DataSupplierArticleNumber = "39-0084"
AND av.ProductID IN (298))
OR
(av.SupplierID = 403
AND av.DataSupplierArticleNumber = "26-0477"
AND av.ProductID IN (424))
OR
(av.SupplierID = 244
AND av.DataSupplierArticleNumber = "17113K"
AND av.ProductID IN (424))
OR
(av.SupplierID = 244
AND av.DataSupplierArticleNumber = "17177"
AND av.ProductID IN (424))
OR
(av.SupplierID = 244
AND av.DataSupplierArticleNumber = "14025"
AND av.ProductID IN (7))
OR
(av.SupplierID = 244
AND av.DataSupplierArticleNumber = "17113"
AND av.ProductID IN (424))
OR
(av.SupplierID = 244
AND av.DataSupplierArticleNumber = "14076"
AND av.ProductID IN (7))
OR
(av.SupplierID = 218
AND av.DataSupplierArticleNumber = "EKR7106"
AND av.ProductID IN (424))
OR
(av.SupplierID = 218
AND av.DataSupplierArticleNumber = "ELR7106"
AND av.ProductID IN (424))
OR
(av.SupplierID = 218
AND av.DataSupplierArticleNumber = "ELP3867"
AND av.ProductID IN (8))
OR
(av.SupplierID = 218
AND av.DataSupplierArticleNumber = "ELH4347"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4664
AND av.DataSupplierArticleNumber = "20023"
AND av.ProductID IN (424))
OR
(av.SupplierID = 94
AND av.DataSupplierArticleNumber = "5PK1025"
AND av.ProductID IN (305))
OR
(av.SupplierID = 94
AND av.DataSupplierArticleNumber = "1020 K5"
AND av.ProductID IN (305))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "029 600 2400"
AND av.ProductID IN (298))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "029 580 2300"
AND av.ProductID IN (298))
OR
(av.SupplierID = 462
AND av.DataSupplierArticleNumber = "K 948"
AND av.ProductID IN (424))
OR
(av.SupplierID = 462
AND av.DataSupplierArticleNumber = "TE 615"
AND av.ProductID IN (7))
OR
(av.SupplierID = 462
AND av.DataSupplierArticleNumber = "K 770"
AND av.ProductID IN (8))
OR
(av.SupplierID = 462
AND av.DataSupplierArticleNumber = "K 948C"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4470
AND av.DataSupplierArticleNumber = "L024"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4470
AND av.DataSupplierArticleNumber = "HB142"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4470
AND av.DataSupplierArticleNumber = "HB142C"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4564
AND av.DataSupplierArticleNumber = "VCF191"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4564
AND av.DataSupplierArticleNumber = "LVWB2451"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4564
AND av.DataSupplierArticleNumber = "VFB398"
AND av.ProductID IN (305))
OR
(av.SupplierID = 4564
AND av.DataSupplierArticleNumber = "VFA1042"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4564
AND av.DataSupplierArticleNumber = "VFL480"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4564
AND av.DataSupplierArticleNumber = "VCF241"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4564
AND av.DataSupplierArticleNumber = "LVWB9112"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4564
AND av.DataSupplierArticleNumber = "LVWB2351"
AND av.ProductID IN (298))
OR
(av.SupplierID = 490
AND av.DataSupplierArticleNumber = "FK176"
AND av.ProductID IN (424))
OR
(av.SupplierID = 490
AND av.DataSupplierArticleNumber = "PA3154"
AND av.ProductID IN (8))
OR
(av.SupplierID = 490
AND av.DataSupplierArticleNumber = "FC176"
AND av.ProductID IN (424))
OR
(av.SupplierID = 490
AND av.DataSupplierArticleNumber = "FOP115"
AND av.ProductID IN (7))
OR
(av.SupplierID = 440
AND av.DataSupplierArticleNumber = "IK16TT"
AND av.ProductID IN (686))
OR
(av.SupplierID = 4380
AND av.DataSupplierArticleNumber = "2136273"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4380
AND av.DataSupplierArticleNumber = "2144608"
AND av.ProductID IN (424))
OR
(av.SupplierID = 378
AND av.DataSupplierArticleNumber = "CAF2065.01"
AND av.ProductID IN (424))
OR
(av.SupplierID = 378
AND av.DataSupplierArticleNumber = "EOS1040.04"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 378
AND av.DataSupplierArticleNumber = "EOS0540.01"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 378
AND av.DataSupplierArticleNumber = "EOS0530.04"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 378
AND av.DataSupplierArticleNumber = "EOF4113.10"
AND av.ProductID IN (7))
OR
(av.SupplierID = 378
AND av.DataSupplierArticleNumber = "EAF3376.10"
AND av.ProductID IN (8))
OR
(av.SupplierID = 378
AND av.DataSupplierArticleNumber = "CAF2065.11"
AND av.ProductID IN (424))
OR
(av.SupplierID = 378
AND av.DataSupplierArticleNumber = "EOS0540.04"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 378
AND av.DataSupplierArticleNumber = "EOS0531.01"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 378
AND av.DataSupplierArticleNumber = "WBR7006.00"
AND av.ProductID IN (298))
OR
(av.SupplierID = 378
AND av.DataSupplierArticleNumber = "EOS1040.01"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 378
AND av.DataSupplierArticleNumber = "EOS0531.04"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 378
AND av.DataSupplierArticleNumber = "WBS0023.00"
AND av.ProductID IN (298))
OR
(av.SupplierID = 378
AND av.DataSupplierArticleNumber = "EOS0530.01"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 129
AND av.DataSupplierArticleNumber = "FC-01615"
AND av.ProductID IN (424))
OR
(av.SupplierID = 129
AND av.DataSupplierArticleNumber = "FC-01616"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4558
AND av.DataSupplierArticleNumber = "PF4162"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4558
AND av.DataSupplierArticleNumber = "PF2050"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4558
AND av.DataSupplierArticleNumber = "PF1308"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4543
AND av.DataSupplierArticleNumber = "86010600"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4686
AND av.DataSupplierArticleNumber = "1520-0729"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4686
AND av.DataSupplierArticleNumber = "1520-0730"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4686
AND av.DataSupplierArticleNumber = "1541-0175"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4520
AND av.DataSupplierArticleNumber = "PR-55F"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4520
AND av.DataSupplierArticleNumber = "PR-55H"
AND av.ProductID IN (298))
OR
(av.SupplierID = 38
AND av.DataSupplierArticleNumber = "A1368"
AND av.ProductID IN (8))
OR
(av.SupplierID = 38
AND av.DataSupplierArticleNumber = "L264A"
AND av.ProductID IN (7))
OR
(av.SupplierID = 38
AND av.DataSupplierArticleNumber = "AH198"
AND av.ProductID IN (424))
OR
(av.SupplierID = 38
AND av.DataSupplierArticleNumber = "AHC198"
AND av.ProductID IN (424))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "QFC0220"
AND av.ProductID IN (424))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "QFC0195"
AND av.ProductID IN (424))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "QFA0796"
AND av.ProductID IN (8))
OR
(av.SupplierID = 461
AND av.DataSupplierArticleNumber = "1111119"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 461
AND av.DataSupplierArticleNumber = "1111100"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 461
AND av.DataSupplierArticleNumber = "1212102"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 461
AND av.DataSupplierArticleNumber = "1181100"
AND av.ProductID IN (3354))
OR
(av.SupplierID = 461
AND av.DataSupplierArticleNumber = "1111116"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "9414-9414"
AND av.ProductID IN (298))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "SB 632"
AND av.ProductID IN (8))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "SH 452 P"
AND av.ProductID IN (7))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "ESTOCADA 9414"
AND av.ProductID IN (298))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "AEROTECH 9106"
AND av.ProductID IN (298))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "9469-9468"
AND av.ProductID IN (298))
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 = "ATF Multivehicle"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "AEROTECH 9468"
AND av.ProductID IN (298))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "9484 REAR WIPER"
AND av.ProductID IN (298))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "Energy Formula PD 5W40"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "9106-9105"
AND av.ProductID IN (298))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "SAK 127"
AND av.ProductID IN (424))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "AEROTECH 9469"
AND av.ProductID IN (298))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "AEROTECH 9105"
AND av.ProductID IN (298))
OR
(av.SupplierID = 27
AND av.DataSupplierArticleNumber = "607"
AND av.ProductID IN (424))
OR
(av.SupplierID = 27
AND av.DataSupplierArticleNumber = "MBX107"
AND av.ProductID IN (424))
OR
(av.SupplierID = 27
AND av.DataSupplierArticleNumber = "107"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4768
AND av.DataSupplierArticleNumber = "P608"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4768
AND av.DataSupplierArticleNumber = "P664"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4768
AND av.DataSupplierArticleNumber = "G608"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4768
AND av.DataSupplierArticleNumber = "G664"
AND av.ProductID IN (424))
OR
(av.SupplierID = 50
AND av.DataSupplierArticleNumber = "VKMV 5PK1028"
AND av.ProductID IN (305))
OR
(av.SupplierID = 50
AND av.DataSupplierArticleNumber = "VKMA 34027"
AND av.ProductID IN (542))
OR
(av.SupplierID = 110
AND av.DataSupplierArticleNumber = "CA5PK1030"
AND av.ProductID IN (305))
OR
(av.SupplierID = 142
AND av.DataSupplierArticleNumber = "S 3045 C"
AND av.ProductID IN (424))
OR
(av.SupplierID = 142
AND av.DataSupplierArticleNumber = "S 3189 A"
AND av.ProductID IN (8))
OR
(av.SupplierID = 142
AND av.DataSupplierArticleNumber = "S 4100 CA"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4667
AND av.DataSupplierArticleNumber = "T420023"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "05-01025-SX"
AND av.ProductID IN (305))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "20-50258-SX"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "71-10256-SX"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "71-10457-SX"
AND av.ProductID IN (424))
OR
(av.SupplierID = 19
AND av.DataSupplierArticleNumber = "119308"
AND av.ProductID IN (298))
OR
(av.SupplierID = 19
AND av.DataSupplierArticleNumber = "119309"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4011
AND av.DataSupplierArticleNumber = "OL0115-E"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4011
AND av.DataSupplierArticleNumber = "CK9495-C"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4011
AND av.DataSupplierArticleNumber = "AR9646PM"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4011
AND av.DataSupplierArticleNumber = "CK9495"
AND av.ProductID IN (424))
OR
(av.SupplierID = 91
AND av.DataSupplierArticleNumber = "E400"
AND av.ProductID IN (424))
OR
(av.SupplierID = 91
AND av.DataSupplierArticleNumber = "OP115"
AND av.ProductID IN (7))
OR
(av.SupplierID = 91
AND av.DataSupplierArticleNumber = "EC400"
AND av.ProductID IN (424))
OR
(av.SupplierID = 227
AND av.DataSupplierArticleNumber = "NF557"
AND av.ProductID IN (298))
OR
(av.SupplierID = 227
AND av.DataSupplierArticleNumber = "EFB5517R"
AND av.ProductID IN (298))
OR
(av.SupplierID = 227
AND av.DataSupplierArticleNumber = "TF550L"
AND av.ProductID IN (298))
OR
(av.SupplierID = 227
AND av.DataSupplierArticleNumber = "EX300"
AND av.ProductID IN (298))
OR
(av.SupplierID = 227
AND av.DataSupplierArticleNumber = "35-220"
AND av.ProductID IN (298))
OR
(av.SupplierID = 227
AND av.DataSupplierArticleNumber = "TF550R"
AND av.ProductID IN (298))
OR
(av.SupplierID = 227
AND av.DataSupplierArticleNumber = "FX550"
AND av.ProductID IN (298))
OR
(av.SupplierID = 227
AND av.DataSupplierArticleNumber = "EFB5517L"
AND av.ProductID IN (298))
OR
(av.SupplierID = 137
AND av.DataSupplierArticleNumber = "53.045.00"
AND av.ProductID IN (424))
OR
(av.SupplierID = 137
AND av.DataSupplierArticleNumber = "54.100.00"
AND av.ProductID IN (424))
OR
(av.SupplierID = 137
AND av.DataSupplierArticleNumber = "30.189.00"
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-0281"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V60-0277"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V60-0099"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V40-0859"
AND av.ProductID IN (8))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V60-0282"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V40-0087"
AND av.ProductID IN (7))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V60-0279"
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-0082"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V60-0283"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V60-0280"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V60-0185"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "586563"
AND av.ProductID IN (7))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "574638"
AND av.ProductID IN (298))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "698711"
AND av.ProductID IN (424))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "701010"
AND av.ProductID IN (424))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "585291"
AND av.ProductID IN (8))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "574637"
AND av.ProductID IN (298))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "698710"
AND av.ProductID IN (424))
OR
(av.SupplierID = 361
AND av.DataSupplierArticleNumber = "SynMatATF2082"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 183
AND av.DataSupplierArticleNumber = "V40-30-1002"
AND av.ProductID IN (424))
OR
(av.SupplierID = 183
AND av.DataSupplierArticleNumber = "V40-31-1112"
AND av.ProductID IN (424))
OR
(av.SupplierID = 179
AND av.DataSupplierArticleNumber = "5PK1030G"
AND av.ProductID IN (305))
OR
(av.SupplierID = 179
AND av.DataSupplierArticleNumber = "5PK1030"
AND av.ProductID IN (305))
OR
(av.SupplierID = 482
AND av.DataSupplierArticleNumber = "100-4022"
AND av.ProductID IN (298))
OR
(av.SupplierID = 482
AND av.DataSupplierArticleNumber = "100-4024"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1461606"
AND av.ProductID IN (686))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1215246"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1461658"
AND av.ProductID IN (686))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1792367"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1217345"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1215563"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4832
AND av.DataSupplierArticleNumber = "WG1193060"
AND av.ProductID IN (135))
OR
(av.SupplierID = 324
AND av.DataSupplierArticleNumber = "WA9498"
AND av.ProductID IN (8))
OR
(av.SupplierID = 324
AND av.DataSupplierArticleNumber = "WL7295"
AND av.ProductID IN (7))
OR
(av.SupplierID = 324
AND av.DataSupplierArticleNumber = "WP9034"
AND av.ProductID IN (424))
OR
(av.SupplierID = 324
AND av.DataSupplierArticleNumber = "WP9035"
AND av.ProductID IN (424))
OR
(av.SupplierID = 188
AND av.DataSupplierArticleNumber = "21116"
AND av.ProductID IN (3224))
OR
(av.SupplierID = 188
AND av.DataSupplierArticleNumber = "3010"
AND av.ProductID IN (3069))
OR
(av.SupplierID = 188
AND av.DataSupplierArticleNumber = "5078"
AND av.ProductID IN (3354))
OR
(av.SupplierID = 499
AND av.DataSupplierArticleNumber = "Z421"
AND av.ProductID IN (424))
OR
(av.SupplierID = 499
AND av.DataSupplierArticleNumber = "ZF421"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4894
AND av.DataSupplierArticleNumber = "OF-4266E"
AND av.ProductID IN (7))
OR
(av.SupplierID = 4894
AND av.DataSupplierArticleNumber = "IF-3177K"
AND av.ProductID IN (424))
OR
(av.SupplierID = 4894
AND av.DataSupplierArticleNumber = "FW-550"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4894
AND av.DataSupplierArticleNumber = "HW-550"
AND av.ProductID IN (298))
OR
(av.SupplierID = 4894
AND av.DataSupplierArticleNumber = "LF-1625"
AND av.ProductID IN (8))
OR
(av.SupplierID = 4894
AND av.DataSupplierArticleNumber = "IF-3177"
AND av.ProductID IN (424))
)
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 = "A63154")
OR
(aa.SupplierID = 4814
AND aa.DataSupplierArticleNumber = "E50115")
OR
(aa.SupplierID = 4814
AND aa.DataSupplierArticleNumber = "C30176")
OR
(aa.SupplierID = 4814
AND aa.DataSupplierArticleNumber = "K30176")
OR
(aa.SupplierID = 228
AND aa.DataSupplierArticleNumber = "1472/1")
OR
(aa.SupplierID = 228
AND aa.DataSupplierArticleNumber = "472/1")
OR
(aa.SupplierID = 180
AND aa.DataSupplierArticleNumber = "MD-8208")
OR
(aa.SupplierID = 180
AND aa.DataSupplierArticleNumber = "MD-463")
OR
(aa.SupplierID = 4866
AND aa.DataSupplierArticleNumber = "SuperTronic G 0W-40")
OR
(aa.SupplierID = 4866
AND aa.DataSupplierArticleNumber = "ATF J")
OR
(aa.SupplierID = 4866
AND aa.DataSupplierArticleNumber = "HighTronic G 5W-30")
OR
(aa.SupplierID = 257
AND aa.DataSupplierArticleNumber = "SA-X30R")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "WA023")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "WAR011")
OR
(aa.SupplierID = 4337
AND aa.DataSupplierArticleNumber = "R23")
OR
(aa.SupplierID = 4337
AND aa.DataSupplierArticleNumber = "I31")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "WBF580")
OR
(aa.SupplierID = 4995
AND aa.DataSupplierArticleNumber = "031-20-01915")
OR
(aa.SupplierID = 4995
AND aa.DataSupplierArticleNumber = "006-20-01414")
OR
(aa.SupplierID = 11
AND aa.DataSupplierArticleNumber = "UPT2")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BFC1000")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BW23C")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BFC1045")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BW23F")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BW24F")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BW12R")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BFA2073")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 008 585")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 006 951")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 118 451")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 007 416")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 004 990")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 008 584")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 006 950")
OR
(aa.SupplierID = 4455
AND aa.DataSupplierArticleNumber = "BSG 65-145-009")
OR
(aa.SupplierID = 4455
AND aa.DataSupplierArticleNumber = "BSG 65-145-005")
OR
(aa.SupplierID = 4668
AND aa.DataSupplierArticleNumber = "05163C")
OR
(aa.SupplierID = 4668
AND aa.DataSupplierArticleNumber = "124080")
OR
(aa.SupplierID = 4668
AND aa.DataSupplierArticleNumber = "004915")
OR
(aa.SupplierID = 4668
AND aa.DataSupplierArticleNumber = "05163R")
OR
(aa.SupplierID = 4668
AND aa.DataSupplierArticleNumber = "005332")
OR
(aa.SupplierID = 4668
AND aa.DataSupplierArticleNumber = "05156R")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "XE568/606")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "CCF0015")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "OE188/R04")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "EON1/287")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "AP29/B01")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "CAF100949P")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "CET2")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "CCF0015C")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "OE188/T10")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "OE089/R04")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "EF58/B01")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "U949/606")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "CET2SB")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "A58/B01")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "COF100568E")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "OE089/T10")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "ER55/B01")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "EON1/286")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "AFL58/B01")
OR
(aa.SupplierID = 189
AND aa.DataSupplierArticleNumber = "5078")
OR
(aa.SupplierID = 189
AND aa.DataSupplierArticleNumber = "21116")
OR
(aa.SupplierID = 189
AND aa.DataSupplierArticleNumber = "65607")
OR
(aa.SupplierID = 189
AND aa.DataSupplierArticleNumber = "3010")
OR
(aa.SupplierID = 163
AND aa.DataSupplierArticleNumber = "NC2062")
OR
(aa.SupplierID = 163
AND aa.DataSupplierArticleNumber = "MA3032")
OR
(aa.SupplierID = 163
AND aa.DataSupplierArticleNumber = "ML1717")
OR
(aa.SupplierID = 163
AND aa.DataSupplierArticleNumber = "NC2109CA")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "EKF116")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "EKF116A")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "EOF086")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "EAF695")
OR
(aa.SupplierID = 437
AND aa.DataSupplierArticleNumber = "PCK8097")
OR
(aa.SupplierID = 437
AND aa.DataSupplierArticleNumber = "FA5617ECO")
OR
(aa.SupplierID = 437
AND aa.DataSupplierArticleNumber = "PA7427")
OR
(aa.SupplierID = 437
AND aa.DataSupplierArticleNumber = "PC8097")
OR
(aa.SupplierID = 140
AND aa.DataSupplierArticleNumber = "041118S")
OR
(aa.SupplierID = 140
AND aa.DataSupplierArticleNumber = "21652714")
OR
(aa.SupplierID = 140
AND aa.DataSupplierArticleNumber = "21652715")
OR
(aa.SupplierID = 42
AND aa.DataSupplierArticleNumber = "5PK1025")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "MR51025")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "TSP0325296")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "TSP0325296C")
OR
(aa.SupplierID = 186
AND aa.DataSupplierArticleNumber = "A141397")
OR
(aa.SupplierID = 186
AND aa.DataSupplierArticleNumber = "M110030")
OR
(aa.SupplierID = 186
AND aa.DataSupplierArticleNumber = "A210191")
OR
(aa.SupplierID = 186
AND aa.DataSupplierArticleNumber = "M110210")
OR
(aa.SupplierID = 66
AND aa.DataSupplierArticleNumber = "K16TT")
OR
(aa.SupplierID = 66
AND aa.DataSupplierArticleNumber = "DF-043")
OR
(aa.SupplierID = 66
AND aa.DataSupplierArticleNumber = "KJ16CR-L11")
OR
(aa.SupplierID = 66
AND aa.DataSupplierArticleNumber = "IK16TT")
OR
(aa.SupplierID = 253
AND aa.DataSupplierArticleNumber = "DCI0068")
OR
(aa.SupplierID = 253
AND aa.DataSupplierArticleNumber = "DCI1068")
OR
(aa.SupplierID = 4357
AND aa.DataSupplierArticleNumber = "51810")
OR
(aa.SupplierID = 4357
AND aa.DataSupplierArticleNumber = "49530")
OR
(aa.SupplierID = 4357
AND aa.DataSupplierArticleNumber = "49240")
OR
(aa.SupplierID = 4357
AND aa.DataSupplierArticleNumber = "49260")
OR
(aa.SupplierID = 4357
AND aa.DataSupplierArticleNumber = "51800")
OR
(aa.SupplierID = 4357
AND aa.DataSupplierArticleNumber = "49520")
OR
(aa.SupplierID = 4357
AND aa.DataSupplierArticleNumber = "28360")
OR
(aa.SupplierID = 4585
AND aa.DataSupplierArticleNumber = "DVF58")
OR
(aa.SupplierID = 4948
AND aa.DataSupplierArticleNumber = "DP3310.10.015")
OR
(aa.SupplierID = 4948
AND aa.DataSupplierArticleNumber = "DP3310.10.105")
OR
(aa.SupplierID = 4948
AND aa.DataSupplierArticleNumber = "DP3310.10.071")
OR
(aa.SupplierID = 4948
AND aa.DataSupplierArticleNumber = "DP1110.11.0085")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "300DR")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "575DF")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DOFX258D")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DCF117")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "600DF")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DCFK117")
OR
(aa.SupplierID = 4881
AND aa.DataSupplierArticleNumber = "502011")
OR
(aa.SupplierID = 10
AND aa.DataSupplierArticleNumber = "476.750")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "LWCR12F")
OR
(aa.SupplierID = 398
AND aa.DataSupplierArticleNumber = "E100085")
OR
(aa.SupplierID = 398
AND aa.DataSupplierArticleNumber = "E113661")
OR
(aa.SupplierID = 398
AND aa.DataSupplierArticleNumber = "E113675")
OR
(aa.SupplierID = 398
AND aa.DataSupplierArticleNumber = "E100054")
OR
(aa.SupplierID = 398
AND aa.DataSupplierArticleNumber = "E100076")
OR
(aa.SupplierID = 4938
AND aa.DataSupplierArticleNumber = "FT38080")
OR
(aa.SupplierID = 271
AND aa.DataSupplierArticleNumber = "FCS164")
OR
(aa.SupplierID = 4838
AND aa.DataSupplierArticleNumber = "F-809")
OR
(aa.SupplierID = 4659
AND aa.DataSupplierArticleNumber = "HCK 7050")
OR
(aa.SupplierID = 4659
AND aa.DataSupplierArticleNumber = "MLE 1520")
OR
(aa.SupplierID = 4659
AND aa.DataSupplierArticleNumber = "HC 7050")
OR
(aa.SupplierID = 256
AND aa.DataSupplierArticleNumber = "OE648/3")
OR
(aa.SupplierID = 256
AND aa.DataSupplierArticleNumber = "K1081")
OR
(aa.SupplierID = 256
AND aa.DataSupplierArticleNumber = "AP188/5")
OR
(aa.SupplierID = 256
AND aa.DataSupplierArticleNumber = "K1081A")
OR
(aa.SupplierID = 441
AND aa.DataSupplierArticleNumber = "MBX107")
OR
(aa.SupplierID = 441
AND aa.DataSupplierArticleNumber = "107")
OR
(aa.SupplierID = 441
AND aa.DataSupplierArticleNumber = "607")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "FW580E")
OR
(aa.SupplierID = 59
AND aa.DataSupplierArticleNumber = "CA9646")
OR
(aa.SupplierID = 59
AND aa.DataSupplierArticleNumber = "CF9495")
OR
(aa.SupplierID = 59
AND aa.DataSupplierArticleNumber = "CFA9495")
OR
(aa.SupplierID = 59
AND aa.DataSupplierArticleNumber = "CH9018ECO")
OR
(aa.SupplierID = 4663
AND aa.DataSupplierArticleNumber = "AG 264 CF")
OR
(aa.SupplierID = 4663
AND aa.DataSupplierArticleNumber = "OG 113 ECO")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8EH 188 705-031")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 197 765-231")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8EH 188 706-011")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 197 765-241")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8EH 188 706-031")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8EH 188 705-011")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 200 526-081")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 190 680-231")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "E972LI")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "E1192L")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "E972LC")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "E630H02 D103")
OR
(aa.SupplierID = 55
AND aa.DataSupplierArticleNumber = "J1310910")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "17113")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "17113K")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "14025")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "17177")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "14076")
OR
(aa.SupplierID = 239
AND aa.DataSupplierArticleNumber = "1030 K 5")
OR
(aa.SupplierID = 156
AND aa.DataSupplierArticleNumber = "SS-X30R")
OR
(aa.SupplierID = 481
AND aa.DataSupplierArticleNumber = "SJX30R")
OR
(aa.SupplierID = 4689
AND aa.DataSupplierArticleNumber = "B4X014CPR")
OR
(aa.SupplierID = 4689
AND aa.DataSupplierArticleNumber = "B2U013PR")
OR
(aa.SupplierID = 138
AND aa.DataSupplierArticleNumber = "IRF 1068")
OR
(aa.SupplierID = 138
AND aa.DataSupplierArticleNumber = "IRF 0068")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1228101800")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1218505909")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1218606009")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1228101100")
OR
(aa.SupplierID = 305
AND aa.DataSupplierArticleNumber = "SS-7000")
OR
(aa.SupplierID = 305
AND aa.DataSupplierArticleNumber = "PS-7000")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "27600")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "F500901")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "29012")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "27575")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "F402501")
OR
(aa.SupplierID = 387
AND aa.DataSupplierArticleNumber = "43047z")
OR
(aa.SupplierID = 34
AND aa.DataSupplierArticleNumber = "LAK 117")
OR
(aa.SupplierID = 34
AND aa.DataSupplierArticleNumber = "LA 117")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "1731515")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "K60PB")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "1731516")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "K60PBCDE")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "K58PB")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "1701701")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "K58PBCDE")
OR
(aa.SupplierID = 4907
AND aa.DataSupplierArticleNumber = "Asyntho5W30")
OR
(aa.SupplierID = 4907
AND aa.DataSupplierArticleNumber = "Helar0W40")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000336")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000314")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000242")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000327")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000330")
OR
(aa.SupplierID = 424
AND aa.DataSupplierArticleNumber = "5PK1025L")
OR
(aa.SupplierID = 4973
AND aa.DataSupplierArticleNumber = "LFOE231")
OR
(aa.SupplierID = 4973
AND aa.DataSupplierArticleNumber = "LFCP123")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "LR30A")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "LAC-1502")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "LA-1531")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "LAC-1502C")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "LO-1522")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "062130001312")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "062110150312")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "350203062120")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "LAK 117")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "LA 117")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "CU 3337")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "CUK 3337")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "C 30 170")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "FP 3337")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "HU 6007 x")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "104575HPS")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "29990")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "65713")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "39-0010")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "26-0301")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "39-0078")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "26-0909")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "26-0063")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "39-0084")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "26-0477")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "17113K")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "17177")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "14025")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "17113")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "14076")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "EKR7106")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "ELR7106")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "ELP3867")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "ELH4347")
OR
(aa.SupplierID = 4664
AND aa.DataSupplierArticleNumber = "20023")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "5PK1025")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "1020 K5")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "029 600 2400")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "029 580 2300")
OR
(aa.SupplierID = 462
AND aa.DataSupplierArticleNumber = "K 948")
OR
(aa.SupplierID = 462
AND aa.DataSupplierArticleNumber = "TE 615")
OR
(aa.SupplierID = 462
AND aa.DataSupplierArticleNumber = "K 770")
OR
(aa.SupplierID = 462
AND aa.DataSupplierArticleNumber = "K 948C")
OR
(aa.SupplierID = 4470
AND aa.DataSupplierArticleNumber = "L024")
OR
(aa.SupplierID = 4470
AND aa.DataSupplierArticleNumber = "HB142")
OR
(aa.SupplierID = 4470
AND aa.DataSupplierArticleNumber = "HB142C")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "VCF191")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "LVWB2451")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "VFB398")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "VFA1042")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "VFL480")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "VCF241")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "LVWB9112")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "LVWB2351")
OR
(aa.SupplierID = 490
AND aa.DataSupplierArticleNumber = "FK176")
OR
(aa.SupplierID = 490
AND aa.DataSupplierArticleNumber = "PA3154")
OR
(aa.SupplierID = 490
AND aa.DataSupplierArticleNumber = "FC176")
OR
(aa.SupplierID = 490
AND aa.DataSupplierArticleNumber = "FOP115")
OR
(aa.SupplierID = 440
AND aa.DataSupplierArticleNumber = "IK16TT")
OR
(aa.SupplierID = 4380
AND aa.DataSupplierArticleNumber = "2136273")
OR
(aa.SupplierID = 4380
AND aa.DataSupplierArticleNumber = "2144608")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "CAF2065.01")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "EOS1040.04")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "EOS0540.01")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "EOS0530.04")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "EOF4113.10")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "EAF3376.10")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "CAF2065.11")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "EOS0540.04")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "EOS0531.01")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "WBR7006.00")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "EOS1040.01")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "EOS0531.04")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "WBS0023.00")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "EOS0530.01")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "FC-01615")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "FC-01616")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PF4162")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PF2050")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PF1308")
OR
(aa.SupplierID = 4543
AND aa.DataSupplierArticleNumber = "86010600")
OR
(aa.SupplierID = 4686
AND aa.DataSupplierArticleNumber = "1520-0729")
OR
(aa.SupplierID = 4686
AND aa.DataSupplierArticleNumber = "1520-0730")
OR
(aa.SupplierID = 4686
AND aa.DataSupplierArticleNumber = "1541-0175")
OR
(aa.SupplierID = 4520
AND aa.DataSupplierArticleNumber = "PR-55F")
OR
(aa.SupplierID = 4520
AND aa.DataSupplierArticleNumber = "PR-55H")
OR
(aa.SupplierID = 38
AND aa.DataSupplierArticleNumber = "A1368")
OR
(aa.SupplierID = 38
AND aa.DataSupplierArticleNumber = "L264A")
OR
(aa.SupplierID = 38
AND aa.DataSupplierArticleNumber = "AH198")
OR
(aa.SupplierID = 38
AND aa.DataSupplierArticleNumber = "AHC198")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QFC0220")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QFC0195")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QFA0796")
OR
(aa.SupplierID = 461
AND aa.DataSupplierArticleNumber = "1111119")
OR
(aa.SupplierID = 461
AND aa.DataSupplierArticleNumber = "1111100")
OR
(aa.SupplierID = 461
AND aa.DataSupplierArticleNumber = "1212102")
OR
(aa.SupplierID = 461
AND aa.DataSupplierArticleNumber = "1181100")
OR
(aa.SupplierID = 461
AND aa.DataSupplierArticleNumber = "1111116")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "9414-9414")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "SB 632")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "SH 452 P")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "ESTOCADA 9414")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "AEROTECH 9106")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "9469-9468")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "7715 O.E.M. 5W-30")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "ATF Multivehicle")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "AEROTECH 9468")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "9484 REAR WIPER")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "Energy Formula PD 5W40")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "9106-9105")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "SAK 127")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "AEROTECH 9469")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "AEROTECH 9105")
OR
(aa.SupplierID = 27
AND aa.DataSupplierArticleNumber = "607")
OR
(aa.SupplierID = 27
AND aa.DataSupplierArticleNumber = "MBX107")
OR
(aa.SupplierID = 27
AND aa.DataSupplierArticleNumber = "107")
OR
(aa.SupplierID = 4768
AND aa.DataSupplierArticleNumber = "P608")
OR
(aa.SupplierID = 4768
AND aa.DataSupplierArticleNumber = "P664")
OR
(aa.SupplierID = 4768
AND aa.DataSupplierArticleNumber = "G608")
OR
(aa.SupplierID = 4768
AND aa.DataSupplierArticleNumber = "G664")
OR
(aa.SupplierID = 50
AND aa.DataSupplierArticleNumber = "VKMV 5PK1028")
OR
(aa.SupplierID = 50
AND aa.DataSupplierArticleNumber = "VKMA 34027")
OR
(aa.SupplierID = 110
AND aa.DataSupplierArticleNumber = "CA5PK1030")
OR
(aa.SupplierID = 142
AND aa.DataSupplierArticleNumber = "S 3045 C")
OR
(aa.SupplierID = 142
AND aa.DataSupplierArticleNumber = "S 3189 A")
OR
(aa.SupplierID = 142
AND aa.DataSupplierArticleNumber = "S 4100 CA")
OR
(aa.SupplierID = 4667
AND aa.DataSupplierArticleNumber = "T420023")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "05-01025-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "20-50258-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "71-10256-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "71-10457-SX")
OR
(aa.SupplierID = 19
AND aa.DataSupplierArticleNumber = "119308")
OR
(aa.SupplierID = 19
AND aa.DataSupplierArticleNumber = "119309")
OR
(aa.SupplierID = 4011
AND aa.DataSupplierArticleNumber = "OL0115-E")
OR
(aa.SupplierID = 4011
AND aa.DataSupplierArticleNumber = "CK9495-C")
OR
(aa.SupplierID = 4011
AND aa.DataSupplierArticleNumber = "AR9646PM")
OR
(aa.SupplierID = 4011
AND aa.DataSupplierArticleNumber = "CK9495")
OR
(aa.SupplierID = 91
AND aa.DataSupplierArticleNumber = "E400")
OR
(aa.SupplierID = 91
AND aa.DataSupplierArticleNumber = "OP115")
OR
(aa.SupplierID = 91
AND aa.DataSupplierArticleNumber = "EC400")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "NF557")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "EFB5517R")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "TF550L")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "EX300")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "35-220")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "TF550R")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "FX550")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "EFB5517L")
OR
(aa.SupplierID = 137
AND aa.DataSupplierArticleNumber = "53.045.00")
OR
(aa.SupplierID = 137
AND aa.DataSupplierArticleNumber = "54.100.00")
OR
(aa.SupplierID = 137
AND aa.DataSupplierArticleNumber = "30.189.00")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0083")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0281")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0277")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0099")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V40-0859")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0282")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V40-0087")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0279")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0100")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0082")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0283")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0280")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0185")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "586563")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "574638")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "698711")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "701010")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "585291")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "574637")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "698710")
OR
(aa.SupplierID = 361
AND aa.DataSupplierArticleNumber = "SynMatATF2082")
OR
(aa.SupplierID = 183
AND aa.DataSupplierArticleNumber = "V40-30-1002")
OR
(aa.SupplierID = 183
AND aa.DataSupplierArticleNumber = "V40-31-1112")
OR
(aa.SupplierID = 179
AND aa.DataSupplierArticleNumber = "5PK1030G")
OR
(aa.SupplierID = 179
AND aa.DataSupplierArticleNumber = "5PK1030")
OR
(aa.SupplierID = 482
AND aa.DataSupplierArticleNumber = "100-4022")
OR
(aa.SupplierID = 482
AND aa.DataSupplierArticleNumber = "100-4024")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1461606")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1215246")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1461658")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1792367")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1217345")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1215563")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1193060")
OR
(aa.SupplierID = 324
AND aa.DataSupplierArticleNumber = "WA9498")
OR
(aa.SupplierID = 324
AND aa.DataSupplierArticleNumber = "WL7295")
OR
(aa.SupplierID = 324
AND aa.DataSupplierArticleNumber = "WP9034")
OR
(aa.SupplierID = 324
AND aa.DataSupplierArticleNumber = "WP9035")
OR
(aa.SupplierID = 188
AND aa.DataSupplierArticleNumber = "21116")
OR
(aa.SupplierID = 188
AND aa.DataSupplierArticleNumber = "3010")
OR
(aa.SupplierID = 188
AND aa.DataSupplierArticleNumber = "5078")
OR
(aa.SupplierID = 499
AND aa.DataSupplierArticleNumber = "Z421")
OR
(aa.SupplierID = 499
AND aa.DataSupplierArticleNumber = "ZF421")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "OF-4266E")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "IF-3177K")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "FW-550")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "HW-550")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "LF-1625")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "IF-3177")
)
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 = "A63154")
OR
(aa.SupplierID = 4814
AND aa.DataSupplierArticleNumber = "E50115")
OR
(aa.SupplierID = 4814
AND aa.DataSupplierArticleNumber = "C30176")
OR
(aa.SupplierID = 4814
AND aa.DataSupplierArticleNumber = "K30176")
OR
(aa.SupplierID = 228
AND aa.DataSupplierArticleNumber = "1472/1")
OR
(aa.SupplierID = 228
AND aa.DataSupplierArticleNumber = "472/1")
OR
(aa.SupplierID = 180
AND aa.DataSupplierArticleNumber = "MD-8208")
OR
(aa.SupplierID = 180
AND aa.DataSupplierArticleNumber = "MD-463")
OR
(aa.SupplierID = 4866
AND aa.DataSupplierArticleNumber = "SuperTronic G 0W-40")
OR
(aa.SupplierID = 4866
AND aa.DataSupplierArticleNumber = "ATF J")
OR
(aa.SupplierID = 4866
AND aa.DataSupplierArticleNumber = "HighTronic G 5W-30")
OR
(aa.SupplierID = 257
AND aa.DataSupplierArticleNumber = "SA-X30R")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "WA023")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "WAR011")
OR
(aa.SupplierID = 4337
AND aa.DataSupplierArticleNumber = "R23")
OR
(aa.SupplierID = 4337
AND aa.DataSupplierArticleNumber = "I31")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "WBF580")
OR
(aa.SupplierID = 4995
AND aa.DataSupplierArticleNumber = "031-20-01915")
OR
(aa.SupplierID = 4995
AND aa.DataSupplierArticleNumber = "006-20-01414")
OR
(aa.SupplierID = 11
AND aa.DataSupplierArticleNumber = "UPT2")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BFC1000")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BW23C")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BFC1045")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BW23F")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BW24F")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BW12R")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BFA2073")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 008 585")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 006 951")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 118 451")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 007 416")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 004 990")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 008 584")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "3 397 006 950")
OR
(aa.SupplierID = 4455
AND aa.DataSupplierArticleNumber = "BSG 65-145-009")
OR
(aa.SupplierID = 4455
AND aa.DataSupplierArticleNumber = "BSG 65-145-005")
OR
(aa.SupplierID = 4668
AND aa.DataSupplierArticleNumber = "05163C")
OR
(aa.SupplierID = 4668
AND aa.DataSupplierArticleNumber = "124080")
OR
(aa.SupplierID = 4668
AND aa.DataSupplierArticleNumber = "004915")
OR
(aa.SupplierID = 4668
AND aa.DataSupplierArticleNumber = "05163R")
OR
(aa.SupplierID = 4668
AND aa.DataSupplierArticleNumber = "005332")
OR
(aa.SupplierID = 4668
AND aa.DataSupplierArticleNumber = "05156R")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "XE568/606")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "CCF0015")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "OE188/R04")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "EON1/287")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "AP29/B01")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "CAF100949P")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "CET2")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "CCF0015C")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "OE188/T10")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "OE089/R04")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "EF58/B01")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "U949/606")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "CET2SB")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "A58/B01")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "COF100568E")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "OE089/T10")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "ER55/B01")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "EON1/286")
OR
(aa.SupplierID = 43
AND aa.DataSupplierArticleNumber = "AFL58/B01")
OR
(aa.SupplierID = 189
AND aa.DataSupplierArticleNumber = "5078")
OR
(aa.SupplierID = 189
AND aa.DataSupplierArticleNumber = "21116")
OR
(aa.SupplierID = 189
AND aa.DataSupplierArticleNumber = "65607")
OR
(aa.SupplierID = 189
AND aa.DataSupplierArticleNumber = "3010")
OR
(aa.SupplierID = 163
AND aa.DataSupplierArticleNumber = "NC2062")
OR
(aa.SupplierID = 163
AND aa.DataSupplierArticleNumber = "MA3032")
OR
(aa.SupplierID = 163
AND aa.DataSupplierArticleNumber = "ML1717")
OR
(aa.SupplierID = 163
AND aa.DataSupplierArticleNumber = "NC2109CA")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "EKF116")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "EKF116A")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "EOF086")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "EAF695")
OR
(aa.SupplierID = 437
AND aa.DataSupplierArticleNumber = "PCK8097")
OR
(aa.SupplierID = 437
AND aa.DataSupplierArticleNumber = "FA5617ECO")
OR
(aa.SupplierID = 437
AND aa.DataSupplierArticleNumber = "PA7427")
OR
(aa.SupplierID = 437
AND aa.DataSupplierArticleNumber = "PC8097")
OR
(aa.SupplierID = 140
AND aa.DataSupplierArticleNumber = "041118S")
OR
(aa.SupplierID = 140
AND aa.DataSupplierArticleNumber = "21652714")
OR
(aa.SupplierID = 140
AND aa.DataSupplierArticleNumber = "21652715")
OR
(aa.SupplierID = 42
AND aa.DataSupplierArticleNumber = "5PK1025")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "MR51025")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "TSP0325296")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "TSP0325296C")
OR
(aa.SupplierID = 186
AND aa.DataSupplierArticleNumber = "A141397")
OR
(aa.SupplierID = 186
AND aa.DataSupplierArticleNumber = "M110030")
OR
(aa.SupplierID = 186
AND aa.DataSupplierArticleNumber = "A210191")
OR
(aa.SupplierID = 186
AND aa.DataSupplierArticleNumber = "M110210")
OR
(aa.SupplierID = 66
AND aa.DataSupplierArticleNumber = "K16TT")
OR
(aa.SupplierID = 66
AND aa.DataSupplierArticleNumber = "DF-043")
OR
(aa.SupplierID = 66
AND aa.DataSupplierArticleNumber = "KJ16CR-L11")
OR
(aa.SupplierID = 66
AND aa.DataSupplierArticleNumber = "IK16TT")
OR
(aa.SupplierID = 253
AND aa.DataSupplierArticleNumber = "DCI0068")
OR
(aa.SupplierID = 253
AND aa.DataSupplierArticleNumber = "DCI1068")
OR
(aa.SupplierID = 4357
AND aa.DataSupplierArticleNumber = "51810")
OR
(aa.SupplierID = 4357
AND aa.DataSupplierArticleNumber = "49530")
OR
(aa.SupplierID = 4357
AND aa.DataSupplierArticleNumber = "49240")
OR
(aa.SupplierID = 4357
AND aa.DataSupplierArticleNumber = "49260")
OR
(aa.SupplierID = 4357
AND aa.DataSupplierArticleNumber = "51800")
OR
(aa.SupplierID = 4357
AND aa.DataSupplierArticleNumber = "49520")
OR
(aa.SupplierID = 4357
AND aa.DataSupplierArticleNumber = "28360")
OR
(aa.SupplierID = 4585
AND aa.DataSupplierArticleNumber = "DVF58")
OR
(aa.SupplierID = 4948
AND aa.DataSupplierArticleNumber = "DP3310.10.015")
OR
(aa.SupplierID = 4948
AND aa.DataSupplierArticleNumber = "DP3310.10.105")
OR
(aa.SupplierID = 4948
AND aa.DataSupplierArticleNumber = "DP3310.10.071")
OR
(aa.SupplierID = 4948
AND aa.DataSupplierArticleNumber = "DP1110.11.0085")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "300DR")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "575DF")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DOFX258D")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DCF117")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "600DF")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DCFK117")
OR
(aa.SupplierID = 4881
AND aa.DataSupplierArticleNumber = "502011")
OR
(aa.SupplierID = 10
AND aa.DataSupplierArticleNumber = "476.750")
OR
(aa.SupplierID = 4344
AND aa.DataSupplierArticleNumber = "LWCR12F")
OR
(aa.SupplierID = 398
AND aa.DataSupplierArticleNumber = "E100085")
OR
(aa.SupplierID = 398
AND aa.DataSupplierArticleNumber = "E113661")
OR
(aa.SupplierID = 398
AND aa.DataSupplierArticleNumber = "E113675")
OR
(aa.SupplierID = 398
AND aa.DataSupplierArticleNumber = "E100054")
OR
(aa.SupplierID = 398
AND aa.DataSupplierArticleNumber = "E100076")
OR
(aa.SupplierID = 4938
AND aa.DataSupplierArticleNumber = "FT38080")
OR
(aa.SupplierID = 271
AND aa.DataSupplierArticleNumber = "FCS164")
OR
(aa.SupplierID = 4838
AND aa.DataSupplierArticleNumber = "F-809")
OR
(aa.SupplierID = 4659
AND aa.DataSupplierArticleNumber = "HCK 7050")
OR
(aa.SupplierID = 4659
AND aa.DataSupplierArticleNumber = "MLE 1520")
OR
(aa.SupplierID = 4659
AND aa.DataSupplierArticleNumber = "HC 7050")
OR
(aa.SupplierID = 256
AND aa.DataSupplierArticleNumber = "OE648/3")
OR
(aa.SupplierID = 256
AND aa.DataSupplierArticleNumber = "K1081")
OR
(aa.SupplierID = 256
AND aa.DataSupplierArticleNumber = "AP188/5")
OR
(aa.SupplierID = 256
AND aa.DataSupplierArticleNumber = "K1081A")
OR
(aa.SupplierID = 441
AND aa.DataSupplierArticleNumber = "MBX107")
OR
(aa.SupplierID = 441
AND aa.DataSupplierArticleNumber = "107")
OR
(aa.SupplierID = 441
AND aa.DataSupplierArticleNumber = "607")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "FW580E")
OR
(aa.SupplierID = 59
AND aa.DataSupplierArticleNumber = "CA9646")
OR
(aa.SupplierID = 59
AND aa.DataSupplierArticleNumber = "CF9495")
OR
(aa.SupplierID = 59
AND aa.DataSupplierArticleNumber = "CFA9495")
OR
(aa.SupplierID = 59
AND aa.DataSupplierArticleNumber = "CH9018ECO")
OR
(aa.SupplierID = 4663
AND aa.DataSupplierArticleNumber = "AG 264 CF")
OR
(aa.SupplierID = 4663
AND aa.DataSupplierArticleNumber = "OG 113 ECO")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8EH 188 705-031")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 197 765-231")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8EH 188 706-011")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 197 765-241")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8EH 188 706-031")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8EH 188 705-011")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 200 526-081")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "9XW 190 680-231")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "E972LI")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "E1192L")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "E972LC")
OR
(aa.SupplierID = 81
AND aa.DataSupplierArticleNumber = "E630H02 D103")
OR
(aa.SupplierID = 55
AND aa.DataSupplierArticleNumber = "J1310910")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "17113")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "17113K")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "14025")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "17177")
OR
(aa.SupplierID = 341
AND aa.DataSupplierArticleNumber = "14076")
OR
(aa.SupplierID = 239
AND aa.DataSupplierArticleNumber = "1030 K 5")
OR
(aa.SupplierID = 156
AND aa.DataSupplierArticleNumber = "SS-X30R")
OR
(aa.SupplierID = 481
AND aa.DataSupplierArticleNumber = "SJX30R")
OR
(aa.SupplierID = 4689
AND aa.DataSupplierArticleNumber = "B4X014CPR")
OR
(aa.SupplierID = 4689
AND aa.DataSupplierArticleNumber = "B2U013PR")
OR
(aa.SupplierID = 138
AND aa.DataSupplierArticleNumber = "IRF 1068")
OR
(aa.SupplierID = 138
AND aa.DataSupplierArticleNumber = "IRF 0068")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1228101800")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1218505909")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1218606009")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1228101100")
OR
(aa.SupplierID = 305
AND aa.DataSupplierArticleNumber = "SS-7000")
OR
(aa.SupplierID = 305
AND aa.DataSupplierArticleNumber = "PS-7000")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "27600")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "F500901")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "29012")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "27575")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "F402501")
OR
(aa.SupplierID = 387
AND aa.DataSupplierArticleNumber = "43047z")
OR
(aa.SupplierID = 34
AND aa.DataSupplierArticleNumber = "LAK 117")
OR
(aa.SupplierID = 34
AND aa.DataSupplierArticleNumber = "LA 117")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "1731515")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "K60PB")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "1731516")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "K60PBCDE")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "K58PB")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "1701701")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "K58PBCDE")
OR
(aa.SupplierID = 4907
AND aa.DataSupplierArticleNumber = "Asyntho5W30")
OR
(aa.SupplierID = 4907
AND aa.DataSupplierArticleNumber = "Helar0W40")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000336")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000314")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000242")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000327")
OR
(aa.SupplierID = 222
AND aa.DataSupplierArticleNumber = "P000330")
OR
(aa.SupplierID = 424
AND aa.DataSupplierArticleNumber = "5PK1025L")
OR
(aa.SupplierID = 4973
AND aa.DataSupplierArticleNumber = "LFOE231")
OR
(aa.SupplierID = 4973
AND aa.DataSupplierArticleNumber = "LFCP123")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "LR30A")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "LAC-1502")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "LA-1531")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "LAC-1502C")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "LO-1522")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "062130001312")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "062110150312")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "350203062120")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "LAK 117")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "LA 117")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "CU 3337")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "CUK 3337")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "C 30 170")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "FP 3337")
OR
(aa.SupplierID = 4
AND aa.DataSupplierArticleNumber = "HU 6007 x")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "104575HPS")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "29990")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "65713")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "39-0010")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "26-0301")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "39-0078")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "26-0909")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "26-0063")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "39-0084")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "26-0477")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "17113K")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "17177")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "14025")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "17113")
OR
(aa.SupplierID = 244
AND aa.DataSupplierArticleNumber = "14076")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "EKR7106")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "ELR7106")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "ELP3867")
OR
(aa.SupplierID = 218
AND aa.DataSupplierArticleNumber = "ELH4347")
OR
(aa.SupplierID = 4664
AND aa.DataSupplierArticleNumber = "20023")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "5PK1025")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "1020 K5")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "029 600 2400")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "029 580 2300")
OR
(aa.SupplierID = 462
AND aa.DataSupplierArticleNumber = "K 948")
OR
(aa.SupplierID = 462
AND aa.DataSupplierArticleNumber = "TE 615")
OR
(aa.SupplierID = 462
AND aa.DataSupplierArticleNumber = "K 770")
OR
(aa.SupplierID = 462
AND aa.DataSupplierArticleNumber = "K 948C")
OR
(aa.SupplierID = 4470
AND aa.DataSupplierArticleNumber = "L024")
OR
(aa.SupplierID = 4470
AND aa.DataSupplierArticleNumber = "HB142")
OR
(aa.SupplierID = 4470
AND aa.DataSupplierArticleNumber = "HB142C")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "VCF191")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "LVWB2451")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "VFB398")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "VFA1042")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "VFL480")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "VCF241")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "LVWB9112")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "LVWB2351")
OR
(aa.SupplierID = 490
AND aa.DataSupplierArticleNumber = "FK176")
OR
(aa.SupplierID = 490
AND aa.DataSupplierArticleNumber = "PA3154")
OR
(aa.SupplierID = 490
AND aa.DataSupplierArticleNumber = "FC176")
OR
(aa.SupplierID = 490
AND aa.DataSupplierArticleNumber = "FOP115")
OR
(aa.SupplierID = 440
AND aa.DataSupplierArticleNumber = "IK16TT")
OR
(aa.SupplierID = 4380
AND aa.DataSupplierArticleNumber = "2136273")
OR
(aa.SupplierID = 4380
AND aa.DataSupplierArticleNumber = "2144608")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "CAF2065.01")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "EOS1040.04")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "EOS0540.01")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "EOS0530.04")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "EOF4113.10")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "EAF3376.10")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "CAF2065.11")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "EOS0540.04")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "EOS0531.01")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "WBR7006.00")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "EOS1040.01")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "EOS0531.04")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "WBS0023.00")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "EOS0530.01")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "FC-01615")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "FC-01616")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PF4162")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PF2050")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PF1308")
OR
(aa.SupplierID = 4543
AND aa.DataSupplierArticleNumber = "86010600")
OR
(aa.SupplierID = 4686
AND aa.DataSupplierArticleNumber = "1520-0729")
OR
(aa.SupplierID = 4686
AND aa.DataSupplierArticleNumber = "1520-0730")
OR
(aa.SupplierID = 4686
AND aa.DataSupplierArticleNumber = "1541-0175")
OR
(aa.SupplierID = 4520
AND aa.DataSupplierArticleNumber = "PR-55F")
OR
(aa.SupplierID = 4520
AND aa.DataSupplierArticleNumber = "PR-55H")
OR
(aa.SupplierID = 38
AND aa.DataSupplierArticleNumber = "A1368")
OR
(aa.SupplierID = 38
AND aa.DataSupplierArticleNumber = "L264A")
OR
(aa.SupplierID = 38
AND aa.DataSupplierArticleNumber = "AH198")
OR
(aa.SupplierID = 38
AND aa.DataSupplierArticleNumber = "AHC198")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QFC0220")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QFC0195")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QFA0796")
OR
(aa.SupplierID = 461
AND aa.DataSupplierArticleNumber = "1111119")
OR
(aa.SupplierID = 461
AND aa.DataSupplierArticleNumber = "1111100")
OR
(aa.SupplierID = 461
AND aa.DataSupplierArticleNumber = "1212102")
OR
(aa.SupplierID = 461
AND aa.DataSupplierArticleNumber = "1181100")
OR
(aa.SupplierID = 461
AND aa.DataSupplierArticleNumber = "1111116")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "9414-9414")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "SB 632")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "SH 452 P")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "ESTOCADA 9414")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "AEROTECH 9106")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "9469-9468")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "7715 O.E.M. 5W-30")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "ATF Multivehicle")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "AEROTECH 9468")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "9484 REAR WIPER")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "Energy Formula PD 5W40")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "9106-9105")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "SAK 127")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "AEROTECH 9469")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "AEROTECH 9105")
OR
(aa.SupplierID = 27
AND aa.DataSupplierArticleNumber = "607")
OR
(aa.SupplierID = 27
AND aa.DataSupplierArticleNumber = "MBX107")
OR
(aa.SupplierID = 27
AND aa.DataSupplierArticleNumber = "107")
OR
(aa.SupplierID = 4768
AND aa.DataSupplierArticleNumber = "P608")
OR
(aa.SupplierID = 4768
AND aa.DataSupplierArticleNumber = "P664")
OR
(aa.SupplierID = 4768
AND aa.DataSupplierArticleNumber = "G608")
OR
(aa.SupplierID = 4768
AND aa.DataSupplierArticleNumber = "G664")
OR
(aa.SupplierID = 50
AND aa.DataSupplierArticleNumber = "VKMV 5PK1028")
OR
(aa.SupplierID = 50
AND aa.DataSupplierArticleNumber = "VKMA 34027")
OR
(aa.SupplierID = 110
AND aa.DataSupplierArticleNumber = "CA5PK1030")
OR
(aa.SupplierID = 142
AND aa.DataSupplierArticleNumber = "S 3045 C")
OR
(aa.SupplierID = 142
AND aa.DataSupplierArticleNumber = "S 3189 A")
OR
(aa.SupplierID = 142
AND aa.DataSupplierArticleNumber = "S 4100 CA")
OR
(aa.SupplierID = 4667
AND aa.DataSupplierArticleNumber = "T420023")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "05-01025-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "20-50258-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "71-10256-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "71-10457-SX")
OR
(aa.SupplierID = 19
AND aa.DataSupplierArticleNumber = "119308")
OR
(aa.SupplierID = 19
AND aa.DataSupplierArticleNumber = "119309")
OR
(aa.SupplierID = 4011
AND aa.DataSupplierArticleNumber = "OL0115-E")
OR
(aa.SupplierID = 4011
AND aa.DataSupplierArticleNumber = "CK9495-C")
OR
(aa.SupplierID = 4011
AND aa.DataSupplierArticleNumber = "AR9646PM")
OR
(aa.SupplierID = 4011
AND aa.DataSupplierArticleNumber = "CK9495")
OR
(aa.SupplierID = 91
AND aa.DataSupplierArticleNumber = "E400")
OR
(aa.SupplierID = 91
AND aa.DataSupplierArticleNumber = "OP115")
OR
(aa.SupplierID = 91
AND aa.DataSupplierArticleNumber = "EC400")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "NF557")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "EFB5517R")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "TF550L")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "EX300")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "35-220")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "TF550R")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "FX550")
OR
(aa.SupplierID = 227
AND aa.DataSupplierArticleNumber = "EFB5517L")
OR
(aa.SupplierID = 137
AND aa.DataSupplierArticleNumber = "53.045.00")
OR
(aa.SupplierID = 137
AND aa.DataSupplierArticleNumber = "54.100.00")
OR
(aa.SupplierID = 137
AND aa.DataSupplierArticleNumber = "30.189.00")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0083")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0281")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0277")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0099")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V40-0859")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0282")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V40-0087")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0279")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0100")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0082")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0283")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0280")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V60-0185")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "586563")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "574638")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "698711")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "701010")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "585291")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "574637")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "698710")
OR
(aa.SupplierID = 361
AND aa.DataSupplierArticleNumber = "SynMatATF2082")
OR
(aa.SupplierID = 183
AND aa.DataSupplierArticleNumber = "V40-30-1002")
OR
(aa.SupplierID = 183
AND aa.DataSupplierArticleNumber = "V40-31-1112")
OR
(aa.SupplierID = 179
AND aa.DataSupplierArticleNumber = "5PK1030G")
OR
(aa.SupplierID = 179
AND aa.DataSupplierArticleNumber = "5PK1030")
OR
(aa.SupplierID = 482
AND aa.DataSupplierArticleNumber = "100-4022")
OR
(aa.SupplierID = 482
AND aa.DataSupplierArticleNumber = "100-4024")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1461606")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1215246")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1461658")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1792367")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1217345")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1215563")
OR
(aa.SupplierID = 4832
AND aa.DataSupplierArticleNumber = "WG1193060")
OR
(aa.SupplierID = 324
AND aa.DataSupplierArticleNumber = "WA9498")
OR
(aa.SupplierID = 324
AND aa.DataSupplierArticleNumber = "WL7295")
OR
(aa.SupplierID = 324
AND aa.DataSupplierArticleNumber = "WP9034")
OR
(aa.SupplierID = 324
AND aa.DataSupplierArticleNumber = "WP9035")
OR
(aa.SupplierID = 188
AND aa.DataSupplierArticleNumber = "21116")
OR
(aa.SupplierID = 188
AND aa.DataSupplierArticleNumber = "3010")
OR
(aa.SupplierID = 188
AND aa.DataSupplierArticleNumber = "5078")
OR
(aa.SupplierID = 499
AND aa.DataSupplierArticleNumber = "Z421")
OR
(aa.SupplierID = 499
AND aa.DataSupplierArticleNumber = "ZF421")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "OF-4266E")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "IF-3177K")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "FW-550")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "HW-550")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "LF-1625")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "IF-3177")
)
AND aa.Language = "ru"
Продажа автозапчастей типа Интервал регулировки для автомобилей
