#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTY0N3x8bW9kZWxfaWQ9PTczNjh8fG1kZl9pZD09MF4zMDg0Mnx8c3BhcmVfaWQ9PTEwMDAzMg%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 = "30842"
AND (
(av.SupplierID = 206
AND av.DataSupplierArticleNumber = "17693"
AND av.ProductID IN (82))
OR
(av.SupplierID = 206
AND av.DataSupplierArticleNumber = "17724"
AND av.ProductID IN (82))
OR
(av.SupplierID = 206
AND av.DataSupplierArticleNumber = "18024"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4426
AND av.DataSupplierArticleNumber = "C40312ABE"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4533
AND av.DataSupplierArticleNumber = "242680"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4533
AND av.DataSupplierArticleNumber = "242719"
AND av.ProductID IN (82))
OR
(av.SupplierID = 283
AND av.DataSupplierArticleNumber = "25258"
AND av.ProductID IN (82))
OR
(av.SupplierID = 283
AND av.DataSupplierArticleNumber = "14985"
AND av.ProductID IN (82))
OR
(av.SupplierID = 283
AND av.DataSupplierArticleNumber = "24907"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4537
AND av.DataSupplierArticleNumber = "DK6134"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4537
AND av.DataSupplierArticleNumber = "DSK2543"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4537
AND av.DataSupplierArticleNumber = "DK6177"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4537
AND av.DataSupplierArticleNumber = "DSK2408"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4537
AND av.DataSupplierArticleNumber = "DSK2496"
AND av.ProductID IN (82))
OR
(av.SupplierID = 257
AND av.DataSupplierArticleNumber = "60-0K-010"
AND av.ProductID IN (82))
OR
(av.SupplierID = 257
AND av.DataSupplierArticleNumber = "61-0K-002"
AND av.ProductID IN (82))
OR
(av.SupplierID = 442
AND av.DataSupplierArticleNumber = "0993-1130"
AND av.ProductID IN (82))
OR
(av.SupplierID = 3
AND av.DataSupplierArticleNumber = "24.0118-0145.1"
AND av.ProductID IN (82))
OR
(av.SupplierID = 3
AND av.DataSupplierArticleNumber = "24.0110-0324.1"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4337
AND av.DataSupplierArticleNumber = "ADC0333"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4337
AND av.DataSupplierArticleNumber = "PDC0333"
AND av.ProductID IN (82))
OR
(av.SupplierID = 350
AND av.DataSupplierArticleNumber = "ADG043143"
AND av.ProductID IN (82))
OR
(av.SupplierID = 350
AND av.DataSupplierArticleNumber = "ADG04396"
AND av.ProductID IN (82))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BBD4528"
AND av.ProductID IN (82))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BBD4529"
AND av.ProductID IN (82))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BBD4701"
AND av.ProductID IN (82))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "0 986 479 286"
AND av.ProductID IN (82))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "0 986 479 S04"
AND av.ProductID IN (82))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "0 986 479 256"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4993
AND av.DataSupplierArticleNumber = "AE0337"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4993
AND av.DataSupplierArticleNumber = "AE0126"
AND av.ProductID IN (82))
OR
(av.SupplierID = 289
AND av.DataSupplierArticleNumber = "BS 8868"
AND av.ProductID IN (82))
OR
(av.SupplierID = 289
AND av.DataSupplierArticleNumber = "BS 7776"
AND av.ProductID IN (82))
OR
(av.SupplierID = 289
AND av.DataSupplierArticleNumber = "BS 8512"
AND av.ProductID IN (82))
OR
(av.SupplierID = 65
AND av.DataSupplierArticleNumber = "08.A916.10"
AND av.ProductID IN (82))
OR
(av.SupplierID = 65
AND av.DataSupplierArticleNumber = "09.9503.10"
AND av.ProductID IN (82))
OR
(av.SupplierID = 65
AND av.DataSupplierArticleNumber = "09.A867.10"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4872
AND av.DataSupplierArticleNumber = "DBB268V"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4872
AND av.DataSupplierArticleNumber = "DBB793S"
AND av.ProductID IN (82))
OR
(av.SupplierID = 243
AND av.DataSupplierArticleNumber = "HPD 1146"
AND av.ProductID IN (82))
OR
(av.SupplierID = 243
AND av.DataSupplierArticleNumber = "142.1146"
AND av.ProductID IN (82))
OR
(av.SupplierID = 243
AND av.DataSupplierArticleNumber = "142.1147"
AND av.ProductID IN (82))
OR
(av.SupplierID = 243
AND av.DataSupplierArticleNumber = "142.1296"
AND av.ProductID IN (82))
OR
(av.SupplierID = 311
AND av.DataSupplierArticleNumber = "800-926"
AND av.ProductID IN (82))
OR
(av.SupplierID = 311
AND av.DataSupplierArticleNumber = "800-929"
AND av.ProductID IN (82))
OR
(av.SupplierID = 421
AND av.DataSupplierArticleNumber = "ADC1056"
AND av.ProductID IN (82))
OR
(av.SupplierID = 421
AND av.DataSupplierArticleNumber = "ADC2401V"
AND av.ProductID IN (82))
OR
(av.SupplierID = 89
AND av.DataSupplierArticleNumber = "BG3981"
AND av.ProductID IN (82))
OR
(av.SupplierID = 89
AND av.DataSupplierArticleNumber = "BG4535"
AND av.ProductID IN (82))
OR
(av.SupplierID = 89
AND av.DataSupplierArticleNumber = "BG3935"
AND av.ProductID IN (82))
OR
(av.SupplierID = 89
AND av.DataSupplierArticleNumber = "BG4535C"
AND av.ProductID IN (82))
OR
(av.SupplierID = 89
AND av.DataSupplierArticleNumber = "BG3935C"
AND av.ProductID IN (82))
OR
(av.SupplierID = 186
AND av.DataSupplierArticleNumber = "B130523"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4519
AND av.DataSupplierArticleNumber = "BD1108"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4948
AND av.DataSupplierArticleNumber = "DP1010.11.0920"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4948
AND av.DataSupplierArticleNumber = "DP1010.11.0256"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "DBD1268"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "DBD1792C"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "DBD1793"
AND av.ProductID IN (82))
OR
(av.SupplierID = 309
AND av.DataSupplierArticleNumber = "19-0061"
AND av.ProductID IN (82))
OR
(av.SupplierID = 309
AND av.DataSupplierArticleNumber = "19-3285"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4770
AND av.DataSupplierArticleNumber = "5815203518"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4770
AND av.DataSupplierArticleNumber = "5815203529"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4770
AND av.DataSupplierArticleNumber = "5815203517"
AND av.ProductID IN (82))
OR
(av.SupplierID = 271
AND av.DataSupplierArticleNumber = "TB218161"
AND av.ProductID IN (82))
OR
(av.SupplierID = 271
AND av.DataSupplierArticleNumber = "TB219313"
AND av.ProductID IN (82))
OR
(av.SupplierID = 62
AND av.DataSupplierArticleNumber = "DDF1268"
AND av.ProductID IN (82))
OR
(av.SupplierID = 62
AND av.DataSupplierArticleNumber = "DDF1792C"
AND av.ProductID IN (82))
OR
(av.SupplierID = 62
AND av.DataSupplierArticleNumber = "DDF1793"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4838
AND av.DataSupplierArticleNumber = "FBD180"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4887
AND av.DataSupplierArticleNumber = "FO 2811"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4887
AND av.DataSupplierArticleNumber = "FO 4071"
AND av.ProductID IN (82))
OR
(av.SupplierID = 409
AND av.DataSupplierArticleNumber = "BD-5101"
AND av.ProductID IN (82))
OR
(av.SupplierID = 409
AND av.DataSupplierArticleNumber = "BD-5102"
AND av.ProductID IN (82))
OR
(av.SupplierID = 295
AND av.DataSupplierArticleNumber = "BD1119"
AND av.ProductID IN (82))
OR
(av.SupplierID = 295
AND av.DataSupplierArticleNumber = "BD1027"
AND av.ProductID IN (82))
OR
(av.SupplierID = 54
AND av.DataSupplierArticleNumber = "BS7121B"
AND av.ProductID IN (82))
OR
(av.SupplierID = 54
AND av.DataSupplierArticleNumber = "BS5445"
AND av.ProductID IN (82))
OR
(av.SupplierID = 54
AND av.DataSupplierArticleNumber = "BS7544"
AND av.ProductID IN (82))
OR
(av.SupplierID = 54
AND av.DataSupplierArticleNumber = "BS5445B"
AND av.ProductID IN (82))
OR
(av.SupplierID = 54
AND av.DataSupplierArticleNumber = "BS7121"
AND av.ProductID IN (82))
OR
(av.SupplierID = 500
AND av.DataSupplierArticleNumber = "B1.G218-0145.1"
AND av.ProductID IN (82))
OR
(av.SupplierID = 500
AND av.DataSupplierArticleNumber = "B1.G210-0324.1"
AND av.ProductID IN (82))
OR
(av.SupplierID = 279
AND av.DataSupplierArticleNumber = "6061161"
AND av.ProductID IN (82))
OR
(av.SupplierID = 279
AND av.DataSupplierArticleNumber = "6044581"
AND av.ProductID IN (82))
OR
(av.SupplierID = 279
AND av.DataSupplierArticleNumber = "6048014"
AND av.ProductID IN (82))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "8DD 355 112-791"
AND av.ProductID IN (82))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "8DD 355 112-801"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4625
AND av.DataSupplierArticleNumber = "8DD 355 112-791"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4625
AND av.DataSupplierArticleNumber = "8DD 355 112-801"
AND av.ProductID IN (82))
OR
(av.SupplierID = 55
AND av.DataSupplierArticleNumber = "J3310316"
AND av.ProductID IN (82))
OR
(av.SupplierID = 55
AND av.DataSupplierArticleNumber = "J3300321"
AND av.ProductID IN (82))
OR
(av.SupplierID = 158
AND av.DataSupplierArticleNumber = "78BD5102-2"
AND av.ProductID IN (82))
OR
(av.SupplierID = 158
AND av.DataSupplierArticleNumber = "78BD7500-2"
AND av.ProductID IN (82))
OR
(av.SupplierID = 459
AND av.DataSupplierArticleNumber = "IBP-1K07"
AND av.ProductID IN (82))
OR
(av.SupplierID = 459
AND av.DataSupplierArticleNumber = "IBT-1K12"
AND av.ProductID IN (82))
OR
(av.SupplierID = 156
AND av.DataSupplierArticleNumber = "DI-K10"
AND av.ProductID IN (82))
OR
(av.SupplierID = 156
AND av.DataSupplierArticleNumber = "DP-K02"
AND av.ProductID IN (82))
OR
(av.SupplierID = 481
AND av.DataSupplierArticleNumber = "60K10"
AND av.ProductID IN (82))
OR
(av.SupplierID = 481
AND av.DataSupplierArticleNumber = "61K02"
AND av.ProductID IN (82))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "3663200709"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4935
AND av.DataSupplierArticleNumber = "KIA110"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4935
AND av.DataSupplierArticleNumber = "KIA111"
AND av.ProductID IN (82))
OR
(av.SupplierID = 48
AND av.DataSupplierArticleNumber = "562429J"
AND av.ProductID IN (82))
OR
(av.SupplierID = 48
AND av.DataSupplierArticleNumber = "562429JC"
AND av.ProductID IN (82))
OR
(av.SupplierID = 48
AND av.DataSupplierArticleNumber = "562428J"
AND av.ProductID IN (82))
OR
(av.SupplierID = 48
AND av.DataSupplierArticleNumber = "562555JC"
AND av.ProductID IN (82))
OR
(av.SupplierID = 48
AND av.DataSupplierArticleNumber = "562428JC"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4461
AND av.DataSupplierArticleNumber = "CBR048"
AND av.ProductID IN (82))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "1031027"
AND av.ProductID IN (82))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "1032536"
AND av.ProductID IN (82))
OR
(av.SupplierID = 201
AND av.DataSupplierArticleNumber = "BR-4225-C"
AND av.ProductID IN (82))
OR
(av.SupplierID = 201
AND av.DataSupplierArticleNumber = "BR-3257-C"
AND av.ProductID IN (82))
OR
(av.SupplierID = 286
AND av.DataSupplierArticleNumber = "6991 00"
AND av.ProductID IN (82))
OR
(av.SupplierID = 286
AND av.DataSupplierArticleNumber = "61365 10"
AND av.ProductID IN (82))
OR
(av.SupplierID = 286
AND av.DataSupplierArticleNumber = "6990 10"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4879
AND av.DataSupplierArticleNumber = "KBD4528"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4879
AND av.DataSupplierArticleNumber = "KBD4529"
AND av.ProductID IN (82))
OR
(av.SupplierID = 197
AND av.DataSupplierArticleNumber = "K2009V"
AND av.ProductID IN (82))
OR
(av.SupplierID = 197
AND av.DataSupplierArticleNumber = "K2013P"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4600
AND av.DataSupplierArticleNumber = "BN-1553"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4600
AND av.DataSupplierArticleNumber = "BN-1554"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4600
AND av.DataSupplierArticleNumber = "BN-1552"
AND av.ProductID IN (82))
OR
(av.SupplierID = 95
AND av.DataSupplierArticleNumber = "360406005500"
AND av.ProductID IN (82))
OR
(av.SupplierID = 95
AND av.DataSupplierArticleNumber = "360406112000"
AND av.ProductID IN (82))
OR
(av.SupplierID = 317
AND av.DataSupplierArticleNumber = "1110380"
AND av.ProductID IN (82))
OR
(av.SupplierID = 317
AND av.DataSupplierArticleNumber = "1110104"
AND av.ProductID IN (82))
OR
(av.SupplierID = 133
AND av.DataSupplierArticleNumber = "45572"
AND av.ProductID IN (82))
OR
(av.SupplierID = 358
AND av.DataSupplierArticleNumber = "24011003241-PCS-MS"
AND av.ProductID IN (82))
OR
(av.SupplierID = 358
AND av.DataSupplierArticleNumber = "24011003241-SET-MS"
AND av.ProductID IN (82))
OR
(av.SupplierID = 358
AND av.DataSupplierArticleNumber = "24011801451-PCS-MS"
AND av.ProductID IN (82))
OR
(av.SupplierID = 358
AND av.DataSupplierArticleNumber = "24011801451-SET-MS"
AND av.ProductID IN (82))
OR
(av.SupplierID = 403
AND av.DataSupplierArticleNumber = "19-1938"
AND av.ProductID IN (82))
OR
(av.SupplierID = 403
AND av.DataSupplierArticleNumber = "19-1937"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4899
AND av.DataSupplierArticleNumber = "865517.6060"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4899
AND av.DataSupplierArticleNumber = "865516.6880"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4899
AND av.DataSupplierArticleNumber = "865517.6880"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4899
AND av.DataSupplierArticleNumber = "865516.6980"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4899
AND av.DataSupplierArticleNumber = "865516.0000"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4899
AND av.DataSupplierArticleNumber = "865517.6980"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4899
AND av.DataSupplierArticleNumber = "865517.0000"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4899
AND av.DataSupplierArticleNumber = "865516.6060"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4773
AND av.DataSupplierArticleNumber = "MRD-2K02"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4773
AND av.DataSupplierArticleNumber = "MFD-2K10"
AND av.ProductID IN (82))
OR
(av.SupplierID = 121
AND av.DataSupplierArticleNumber = "23-0926"
AND av.ProductID IN (82))
OR
(av.SupplierID = 121
AND av.DataSupplierArticleNumber = "23-0929"
AND av.ProductID IN (82))
OR
(av.SupplierID = 94
AND av.DataSupplierArticleNumber = "6110160"
AND av.ProductID IN (82))
OR
(av.SupplierID = 94
AND av.DataSupplierArticleNumber = "6110238"
AND av.ProductID IN (82))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "37-15 523 0014"
AND av.ProductID IN (82))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "28-15 521 0009"
AND av.ProductID IN (82))
OR
(av.SupplierID = 73
AND av.DataSupplierArticleNumber = "MDC1725"
AND av.ProductID IN (82))
OR
(av.SupplierID = 73
AND av.DataSupplierArticleNumber = "MDC1726"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4564
AND av.DataSupplierArticleNumber = "LVBD1188Z"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4564
AND av.DataSupplierArticleNumber = "LVBD1608"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4564
AND av.DataSupplierArticleNumber = "LVBD1187Z"
AND av.ProductID IN (82))
OR
(av.SupplierID = 190
AND av.DataSupplierArticleNumber = "NBD1686"
AND av.ProductID IN (82))
OR
(av.SupplierID = 190
AND av.DataSupplierArticleNumber = "NBD1342"
AND av.ProductID IN (82))
OR
(av.SupplierID = 190
AND av.DataSupplierArticleNumber = "NBD1343"
AND av.ProductID IN (82))
OR
(av.SupplierID = 248
AND av.DataSupplierArticleNumber = "J3310311"
AND av.ProductID IN (82))
OR
(av.SupplierID = 248
AND av.DataSupplierArticleNumber = "J3300321"
AND av.ProductID IN (82))
OR
(av.SupplierID = 248
AND av.DataSupplierArticleNumber = "J3300321HC"
AND av.ProductID IN (82))
OR
(av.SupplierID = 127
AND av.DataSupplierArticleNumber = "313517"
AND av.ProductID IN (82))
OR
(av.SupplierID = 127
AND av.DataSupplierArticleNumber = "203517"
AND av.ProductID IN (82))
OR
(av.SupplierID = 127
AND av.DataSupplierArticleNumber = "313518"
AND av.ProductID IN (82))
OR
(av.SupplierID = 127
AND av.DataSupplierArticleNumber = "203518"
AND av.ProductID IN (82))
OR
(av.SupplierID = 127
AND av.DataSupplierArticleNumber = "313529"
AND av.ProductID IN (82))
OR
(av.SupplierID = 127
AND av.DataSupplierArticleNumber = "203529"
AND av.ProductID IN (82))
OR
(av.SupplierID = 440
AND av.DataSupplierArticleNumber = "K330A20"
AND av.ProductID IN (82))
OR
(av.SupplierID = 440
AND av.DataSupplierArticleNumber = "K331A04"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4380
AND av.DataSupplierArticleNumber = "2143269"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4380
AND av.DataSupplierArticleNumber = "2134475"
AND av.ProductID IN (82))
OR
(av.SupplierID = 378
AND av.DataSupplierArticleNumber = "BDA2184.10"
AND av.ProductID IN (82))
OR
(av.SupplierID = 378
AND av.DataSupplierArticleNumber = "BDA2223.20"
AND av.ProductID IN (82))
OR
(av.SupplierID = 129
AND av.DataSupplierArticleNumber = "BS-8156"
AND av.ProductID IN (82))
OR
(av.SupplierID = 129
AND av.DataSupplierArticleNumber = "BS-8652"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4558
AND av.DataSupplierArticleNumber = "PBD4458"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4558
AND av.DataSupplierArticleNumber = "PBD4801"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4558
AND av.DataSupplierArticleNumber = "PBD1560"
AND av.ProductID IN (82))
OR
(av.SupplierID = 291
AND av.DataSupplierArticleNumber = "V1821"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4686
AND av.DataSupplierArticleNumber = "5010-1268"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4520
AND av.DataSupplierArticleNumber = "PRD5323"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4520
AND av.DataSupplierArticleNumber = "PRD2313"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4520
AND av.DataSupplierArticleNumber = "PRD2544"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4821
AND av.DataSupplierArticleNumber = "QD7023"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4821
AND av.DataSupplierArticleNumber = "QD8854"
AND av.ProductID IN (82))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "BDC5755"
AND av.ProductID IN (82))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "BDC5445"
AND av.ProductID IN (82))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "BDC5568"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4955
AND av.DataSupplierArticleNumber = "78RBD25102"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4955
AND av.DataSupplierArticleNumber = "78RBD27500"
AND av.ProductID IN (82))
OR
(av.SupplierID = 400
AND av.DataSupplierArticleNumber = "RD00556"
AND av.ProductID IN (82))
OR
(av.SupplierID = 400
AND av.DataSupplierArticleNumber = "RD00566"
AND av.ProductID IN (82))
OR
(av.SupplierID = 400
AND av.DataSupplierArticleNumber = "RD00555"
AND av.ProductID IN (82))
OR
(av.SupplierID = 153
AND av.DataSupplierArticleNumber = "6991.00"
AND av.ProductID IN (82))
OR
(av.SupplierID = 153
AND av.DataSupplierArticleNumber = "61365.10"
AND av.ProductID IN (82))
OR
(av.SupplierID = 153
AND av.DataSupplierArticleNumber = "6990.10"
AND av.ProductID IN (82))
OR
(av.SupplierID = 152
AND av.DataSupplierArticleNumber = "6991.00"
AND av.ProductID IN (82))
OR
(av.SupplierID = 152
AND av.DataSupplierArticleNumber = "61365.10"
AND av.ProductID IN (82))
OR
(av.SupplierID = 152
AND av.DataSupplierArticleNumber = "6990.10"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4676
AND av.DataSupplierArticleNumber = "RT 20376 T5"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4676
AND av.DataSupplierArticleNumber = "RT 1656"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4676
AND av.DataSupplierArticleNumber = "RT 1656 T5"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4676
AND av.DataSupplierArticleNumber = "RT 20376"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4547
AND av.DataSupplierArticleNumber = "604-03-8817"
AND av.ProductID IN (82))
OR
(av.SupplierID = 260
AND av.DataSupplierArticleNumber = "6106229"
AND av.ProductID IN (82))
OR
(av.SupplierID = 260
AND av.DataSupplierArticleNumber = "6106335"
AND av.ProductID IN (82))
OR
(av.SupplierID = 297
AND av.DataSupplierArticleNumber = "1815313517"
AND av.ProductID IN (82))
OR
(av.SupplierID = 297
AND av.DataSupplierArticleNumber = "1815203517"
AND av.ProductID IN (82))
OR
(av.SupplierID = 297
AND av.DataSupplierArticleNumber = "1815313518"
AND av.ProductID IN (82))
OR
(av.SupplierID = 297
AND av.DataSupplierArticleNumber = "1815203518"
AND av.ProductID IN (82))
OR
(av.SupplierID = 297
AND av.DataSupplierArticleNumber = "1815313529"
AND av.ProductID IN (82))
OR
(av.SupplierID = 297
AND av.DataSupplierArticleNumber = "1815203529"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "6020 1425-SX"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "6020 1426-SX"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "6020 1424-SX"
AND av.ProductID IN (82))
OR
(av.SupplierID = 39
AND av.DataSupplierArticleNumber = "92147103"
AND av.ProductID IN (82))
OR
(av.SupplierID = 39
AND av.DataSupplierArticleNumber = "92147200"
AND av.ProductID IN (82))
OR
(av.SupplierID = 39
AND av.DataSupplierArticleNumber = "92147100"
AND av.ProductID IN (82))
OR
(av.SupplierID = 301
AND av.DataSupplierArticleNumber = "820 765"
AND av.ProductID IN (82))
OR
(av.SupplierID = 108
AND av.DataSupplierArticleNumber = "8120 18126"
AND av.ProductID IN (82))
OR
(av.SupplierID = 108
AND av.DataSupplierArticleNumber = "8120 18113"
AND av.ProductID IN (82))
OR
(av.SupplierID = 108
AND av.DataSupplierArticleNumber = "8120 18113C"
AND av.ProductID IN (82))
OR
(av.SupplierID = 108
AND av.DataSupplierArticleNumber = "8120 18119C"
AND av.ProductID IN (82))
OR
(av.SupplierID = 199
AND av.DataSupplierArticleNumber = "DF1027"
AND av.ProductID IN (82))
OR
(av.SupplierID = 199
AND av.DataSupplierArticleNumber = "DF1119"
AND av.ProductID IN (82))
OR
(av.SupplierID = 161
AND av.DataSupplierArticleNumber = "DF4801"
AND av.ProductID IN (82))
OR
(av.SupplierID = 161
AND av.DataSupplierArticleNumber = "DF6116"
AND av.ProductID IN (82))
OR
(av.SupplierID = 161
AND av.DataSupplierArticleNumber = "DF4458"
AND av.ProductID IN (82))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V53-80006"
AND av.ProductID IN (82))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V52-40008"
AND av.ProductID IN (82))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V52-80015"
AND av.ProductID IN (82))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "197466"
AND av.ProductID IN (82))
OR
(av.SupplierID = 456
AND av.DataSupplierArticleNumber = "628.2650"
AND av.ProductID IN (82))
OR
(av.SupplierID = 456
AND av.DataSupplierArticleNumber = "628.1512"
AND av.ProductID IN (82))
OR
(av.SupplierID = 456
AND av.DataSupplierArticleNumber = "628.2313"
AND av.ProductID IN (82))
OR
(av.SupplierID = 366
AND av.DataSupplierArticleNumber = "D61365.10"
AND av.ProductID IN (82))
OR
(av.SupplierID = 366
AND av.DataSupplierArticleNumber = "D6990.10"
AND av.ProductID IN (82))
OR
(av.SupplierID = 366
AND av.DataSupplierArticleNumber = "D6991.00"
AND av.ProductID IN (82))
OR
(av.SupplierID = 4894
AND av.DataSupplierArticleNumber = "BS-5485"
AND av.ProductID IN (82))
OR
(av.SupplierID = 86
AND av.DataSupplierArticleNumber = "320.3800.20"
AND av.ProductID IN (82))
OR
(av.SupplierID = 86
AND av.DataSupplierArticleNumber = "285.3511.20"
AND av.ProductID IN (82))
)
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 = 206
AND aa.DataSupplierArticleNumber = "17693")
OR
(aa.SupplierID = 206
AND aa.DataSupplierArticleNumber = "17724")
OR
(aa.SupplierID = 206
AND aa.DataSupplierArticleNumber = "18024")
OR
(aa.SupplierID = 4426
AND aa.DataSupplierArticleNumber = "C40312ABE")
OR
(aa.SupplierID = 4533
AND aa.DataSupplierArticleNumber = "242680")
OR
(aa.SupplierID = 4533
AND aa.DataSupplierArticleNumber = "242719")
OR
(aa.SupplierID = 283
AND aa.DataSupplierArticleNumber = "25258")
OR
(aa.SupplierID = 283
AND aa.DataSupplierArticleNumber = "14985")
OR
(aa.SupplierID = 283
AND aa.DataSupplierArticleNumber = "24907")
OR
(aa.SupplierID = 4537
AND aa.DataSupplierArticleNumber = "DK6134")
OR
(aa.SupplierID = 4537
AND aa.DataSupplierArticleNumber = "DSK2543")
OR
(aa.SupplierID = 4537
AND aa.DataSupplierArticleNumber = "DK6177")
OR
(aa.SupplierID = 4537
AND aa.DataSupplierArticleNumber = "DSK2408")
OR
(aa.SupplierID = 4537
AND aa.DataSupplierArticleNumber = "DSK2496")
OR
(aa.SupplierID = 257
AND aa.DataSupplierArticleNumber = "60-0K-010")
OR
(aa.SupplierID = 257
AND aa.DataSupplierArticleNumber = "61-0K-002")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "0993-1130")
OR
(aa.SupplierID = 3
AND aa.DataSupplierArticleNumber = "24.0118-0145.1")
OR
(aa.SupplierID = 3
AND aa.DataSupplierArticleNumber = "24.0110-0324.1")
OR
(aa.SupplierID = 4337
AND aa.DataSupplierArticleNumber = "ADC0333")
OR
(aa.SupplierID = 4337
AND aa.DataSupplierArticleNumber = "PDC0333")
OR
(aa.SupplierID = 350
AND aa.DataSupplierArticleNumber = "ADG043143")
OR
(aa.SupplierID = 350
AND aa.DataSupplierArticleNumber = "ADG04396")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BBD4528")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BBD4529")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BBD4701")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 986 479 286")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 986 479 S04")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 986 479 256")
OR
(aa.SupplierID = 4993
AND aa.DataSupplierArticleNumber = "AE0337")
OR
(aa.SupplierID = 4993
AND aa.DataSupplierArticleNumber = "AE0126")
OR
(aa.SupplierID = 289
AND aa.DataSupplierArticleNumber = "BS 8868")
OR
(aa.SupplierID = 289
AND aa.DataSupplierArticleNumber = "BS 7776")
OR
(aa.SupplierID = 289
AND aa.DataSupplierArticleNumber = "BS 8512")
OR
(aa.SupplierID = 65
AND aa.DataSupplierArticleNumber = "08.A916.10")
OR
(aa.SupplierID = 65
AND aa.DataSupplierArticleNumber = "09.9503.10")
OR
(aa.SupplierID = 65
AND aa.DataSupplierArticleNumber = "09.A867.10")
OR
(aa.SupplierID = 4872
AND aa.DataSupplierArticleNumber = "DBB268V")
OR
(aa.SupplierID = 4872
AND aa.DataSupplierArticleNumber = "DBB793S")
OR
(aa.SupplierID = 243
AND aa.DataSupplierArticleNumber = "HPD 1146")
OR
(aa.SupplierID = 243
AND aa.DataSupplierArticleNumber = "142.1146")
OR
(aa.SupplierID = 243
AND aa.DataSupplierArticleNumber = "142.1147")
OR
(aa.SupplierID = 243
AND aa.DataSupplierArticleNumber = "142.1296")
OR
(aa.SupplierID = 311
AND aa.DataSupplierArticleNumber = "800-926")
OR
(aa.SupplierID = 311
AND aa.DataSupplierArticleNumber = "800-929")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "ADC1056")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "ADC2401V")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "BG3981")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "BG4535")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "BG3935")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "BG4535C")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "BG3935C")
OR
(aa.SupplierID = 186
AND aa.DataSupplierArticleNumber = "B130523")
OR
(aa.SupplierID = 4519
AND aa.DataSupplierArticleNumber = "BD1108")
OR
(aa.SupplierID = 4948
AND aa.DataSupplierArticleNumber = "DP1010.11.0920")
OR
(aa.SupplierID = 4948
AND aa.DataSupplierArticleNumber = "DP1010.11.0256")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DBD1268")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DBD1792C")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DBD1793")
OR
(aa.SupplierID = 309
AND aa.DataSupplierArticleNumber = "19-0061")
OR
(aa.SupplierID = 309
AND aa.DataSupplierArticleNumber = "19-3285")
OR
(aa.SupplierID = 4770
AND aa.DataSupplierArticleNumber = "5815203518")
OR
(aa.SupplierID = 4770
AND aa.DataSupplierArticleNumber = "5815203529")
OR
(aa.SupplierID = 4770
AND aa.DataSupplierArticleNumber = "5815203517")
OR
(aa.SupplierID = 271
AND aa.DataSupplierArticleNumber = "TB218161")
OR
(aa.SupplierID = 271
AND aa.DataSupplierArticleNumber = "TB219313")
OR
(aa.SupplierID = 62
AND aa.DataSupplierArticleNumber = "DDF1268")
OR
(aa.SupplierID = 62
AND aa.DataSupplierArticleNumber = "DDF1792C")
OR
(aa.SupplierID = 62
AND aa.DataSupplierArticleNumber = "DDF1793")
OR
(aa.SupplierID = 4838
AND aa.DataSupplierArticleNumber = "FBD180")
OR
(aa.SupplierID = 4887
AND aa.DataSupplierArticleNumber = "FO 2811")
OR
(aa.SupplierID = 4887
AND aa.DataSupplierArticleNumber = "FO 4071")
OR
(aa.SupplierID = 409
AND aa.DataSupplierArticleNumber = "BD-5101")
OR
(aa.SupplierID = 409
AND aa.DataSupplierArticleNumber = "BD-5102")
OR
(aa.SupplierID = 295
AND aa.DataSupplierArticleNumber = "BD1119")
OR
(aa.SupplierID = 295
AND aa.DataSupplierArticleNumber = "BD1027")
OR
(aa.SupplierID = 54
AND aa.DataSupplierArticleNumber = "BS7121B")
OR
(aa.SupplierID = 54
AND aa.DataSupplierArticleNumber = "BS5445")
OR
(aa.SupplierID = 54
AND aa.DataSupplierArticleNumber = "BS7544")
OR
(aa.SupplierID = 54
AND aa.DataSupplierArticleNumber = "BS5445B")
OR
(aa.SupplierID = 54
AND aa.DataSupplierArticleNumber = "BS7121")
OR
(aa.SupplierID = 500
AND aa.DataSupplierArticleNumber = "B1.G218-0145.1")
OR
(aa.SupplierID = 500
AND aa.DataSupplierArticleNumber = "B1.G210-0324.1")
OR
(aa.SupplierID = 279
AND aa.DataSupplierArticleNumber = "6061161")
OR
(aa.SupplierID = 279
AND aa.DataSupplierArticleNumber = "6044581")
OR
(aa.SupplierID = 279
AND aa.DataSupplierArticleNumber = "6048014")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8DD 355 112-791")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8DD 355 112-801")
OR
(aa.SupplierID = 4625
AND aa.DataSupplierArticleNumber = "8DD 355 112-791")
OR
(aa.SupplierID = 4625
AND aa.DataSupplierArticleNumber = "8DD 355 112-801")
OR
(aa.SupplierID = 55
AND aa.DataSupplierArticleNumber = "J3310316")
OR
(aa.SupplierID = 55
AND aa.DataSupplierArticleNumber = "J3300321")
OR
(aa.SupplierID = 158
AND aa.DataSupplierArticleNumber = "78BD5102-2")
OR
(aa.SupplierID = 158
AND aa.DataSupplierArticleNumber = "78BD7500-2")
OR
(aa.SupplierID = 459
AND aa.DataSupplierArticleNumber = "IBP-1K07")
OR
(aa.SupplierID = 459
AND aa.DataSupplierArticleNumber = "IBT-1K12")
OR
(aa.SupplierID = 156
AND aa.DataSupplierArticleNumber = "DI-K10")
OR
(aa.SupplierID = 156
AND aa.DataSupplierArticleNumber = "DP-K02")
OR
(aa.SupplierID = 481
AND aa.DataSupplierArticleNumber = "60K10")
OR
(aa.SupplierID = 481
AND aa.DataSupplierArticleNumber = "61K02")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "3663200709")
OR
(aa.SupplierID = 4935
AND aa.DataSupplierArticleNumber = "KIA110")
OR
(aa.SupplierID = 4935
AND aa.DataSupplierArticleNumber = "KIA111")
OR
(aa.SupplierID = 48
AND aa.DataSupplierArticleNumber = "562429J")
OR
(aa.SupplierID = 48
AND aa.DataSupplierArticleNumber = "562429JC")
OR
(aa.SupplierID = 48
AND aa.DataSupplierArticleNumber = "562428J")
OR
(aa.SupplierID = 48
AND aa.DataSupplierArticleNumber = "562555JC")
OR
(aa.SupplierID = 48
AND aa.DataSupplierArticleNumber = "562428JC")
OR
(aa.SupplierID = 4461
AND aa.DataSupplierArticleNumber = "CBR048")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "1031027")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "1032536")
OR
(aa.SupplierID = 201
AND aa.DataSupplierArticleNumber = "BR-4225-C")
OR
(aa.SupplierID = 201
AND aa.DataSupplierArticleNumber = "BR-3257-C")
OR
(aa.SupplierID = 286
AND aa.DataSupplierArticleNumber = "6991 00")
OR
(aa.SupplierID = 286
AND aa.DataSupplierArticleNumber = "61365 10")
OR
(aa.SupplierID = 286
AND aa.DataSupplierArticleNumber = "6990 10")
OR
(aa.SupplierID = 4879
AND aa.DataSupplierArticleNumber = "KBD4528")
OR
(aa.SupplierID = 4879
AND aa.DataSupplierArticleNumber = "KBD4529")
OR
(aa.SupplierID = 197
AND aa.DataSupplierArticleNumber = "K2009V")
OR
(aa.SupplierID = 197
AND aa.DataSupplierArticleNumber = "K2013P")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "BN-1553")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "BN-1554")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "BN-1552")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "360406005500")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "360406112000")
OR
(aa.SupplierID = 317
AND aa.DataSupplierArticleNumber = "1110380")
OR
(aa.SupplierID = 317
AND aa.DataSupplierArticleNumber = "1110104")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "45572")
OR
(aa.SupplierID = 358
AND aa.DataSupplierArticleNumber = "24011003241-PCS-MS")
OR
(aa.SupplierID = 358
AND aa.DataSupplierArticleNumber = "24011003241-SET-MS")
OR
(aa.SupplierID = 358
AND aa.DataSupplierArticleNumber = "24011801451-PCS-MS")
OR
(aa.SupplierID = 358
AND aa.DataSupplierArticleNumber = "24011801451-SET-MS")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "19-1938")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "19-1937")
OR
(aa.SupplierID = 4899
AND aa.DataSupplierArticleNumber = "865517.6060")
OR
(aa.SupplierID = 4899
AND aa.DataSupplierArticleNumber = "865516.6880")
OR
(aa.SupplierID = 4899
AND aa.DataSupplierArticleNumber = "865517.6880")
OR
(aa.SupplierID = 4899
AND aa.DataSupplierArticleNumber = "865516.6980")
OR
(aa.SupplierID = 4899
AND aa.DataSupplierArticleNumber = "865516.0000")
OR
(aa.SupplierID = 4899
AND aa.DataSupplierArticleNumber = "865517.6980")
OR
(aa.SupplierID = 4899
AND aa.DataSupplierArticleNumber = "865517.0000")
OR
(aa.SupplierID = 4899
AND aa.DataSupplierArticleNumber = "865516.6060")
OR
(aa.SupplierID = 4773
AND aa.DataSupplierArticleNumber = "MRD-2K02")
OR
(aa.SupplierID = 4773
AND aa.DataSupplierArticleNumber = "MFD-2K10")
OR
(aa.SupplierID = 121
AND aa.DataSupplierArticleNumber = "23-0926")
OR
(aa.SupplierID = 121
AND aa.DataSupplierArticleNumber = "23-0929")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "6110160")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "6110238")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "37-15 523 0014")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "28-15 521 0009")
OR
(aa.SupplierID = 73
AND aa.DataSupplierArticleNumber = "MDC1725")
OR
(aa.SupplierID = 73
AND aa.DataSupplierArticleNumber = "MDC1726")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "LVBD1188Z")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "LVBD1608")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "LVBD1187Z")
OR
(aa.SupplierID = 190
AND aa.DataSupplierArticleNumber = "NBD1686")
OR
(aa.SupplierID = 190
AND aa.DataSupplierArticleNumber = "NBD1342")
OR
(aa.SupplierID = 190
AND aa.DataSupplierArticleNumber = "NBD1343")
OR
(aa.SupplierID = 248
AND aa.DataSupplierArticleNumber = "J3310311")
OR
(aa.SupplierID = 248
AND aa.DataSupplierArticleNumber = "J3300321")
OR
(aa.SupplierID = 248
AND aa.DataSupplierArticleNumber = "J3300321HC")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "313517")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "203517")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "313518")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "203518")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "313529")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "203529")
OR
(aa.SupplierID = 440
AND aa.DataSupplierArticleNumber = "K330A20")
OR
(aa.SupplierID = 440
AND aa.DataSupplierArticleNumber = "K331A04")
OR
(aa.SupplierID = 4380
AND aa.DataSupplierArticleNumber = "2143269")
OR
(aa.SupplierID = 4380
AND aa.DataSupplierArticleNumber = "2134475")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "BDA2184.10")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "BDA2223.20")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "BS-8156")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "BS-8652")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PBD4458")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PBD4801")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PBD1560")
OR
(aa.SupplierID = 291
AND aa.DataSupplierArticleNumber = "V1821")
OR
(aa.SupplierID = 4686
AND aa.DataSupplierArticleNumber = "5010-1268")
OR
(aa.SupplierID = 4520
AND aa.DataSupplierArticleNumber = "PRD5323")
OR
(aa.SupplierID = 4520
AND aa.DataSupplierArticleNumber = "PRD2313")
OR
(aa.SupplierID = 4520
AND aa.DataSupplierArticleNumber = "PRD2544")
OR
(aa.SupplierID = 4821
AND aa.DataSupplierArticleNumber = "QD7023")
OR
(aa.SupplierID = 4821
AND aa.DataSupplierArticleNumber = "QD8854")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "BDC5755")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "BDC5445")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "BDC5568")
OR
(aa.SupplierID = 4955
AND aa.DataSupplierArticleNumber = "78RBD25102")
OR
(aa.SupplierID = 4955
AND aa.DataSupplierArticleNumber = "78RBD27500")
OR
(aa.SupplierID = 400
AND aa.DataSupplierArticleNumber = "RD00556")
OR
(aa.SupplierID = 400
AND aa.DataSupplierArticleNumber = "RD00566")
OR
(aa.SupplierID = 400
AND aa.DataSupplierArticleNumber = "RD00555")
OR
(aa.SupplierID = 153
AND aa.DataSupplierArticleNumber = "6991.00")
OR
(aa.SupplierID = 153
AND aa.DataSupplierArticleNumber = "61365.10")
OR
(aa.SupplierID = 153
AND aa.DataSupplierArticleNumber = "6990.10")
OR
(aa.SupplierID = 152
AND aa.DataSupplierArticleNumber = "6991.00")
OR
(aa.SupplierID = 152
AND aa.DataSupplierArticleNumber = "61365.10")
OR
(aa.SupplierID = 152
AND aa.DataSupplierArticleNumber = "6990.10")
OR
(aa.SupplierID = 4676
AND aa.DataSupplierArticleNumber = "RT 20376 T5")
OR
(aa.SupplierID = 4676
AND aa.DataSupplierArticleNumber = "RT 1656")
OR
(aa.SupplierID = 4676
AND aa.DataSupplierArticleNumber = "RT 1656 T5")
OR
(aa.SupplierID = 4676
AND aa.DataSupplierArticleNumber = "RT 20376")
OR
(aa.SupplierID = 4547
AND aa.DataSupplierArticleNumber = "604-03-8817")
OR
(aa.SupplierID = 260
AND aa.DataSupplierArticleNumber = "6106229")
OR
(aa.SupplierID = 260
AND aa.DataSupplierArticleNumber = "6106335")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "1815313517")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "1815203517")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "1815313518")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "1815203518")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "1815313529")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "1815203529")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "6020 1425-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "6020 1426-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "6020 1424-SX")
OR
(aa.SupplierID = 39
AND aa.DataSupplierArticleNumber = "92147103")
OR
(aa.SupplierID = 39
AND aa.DataSupplierArticleNumber = "92147200")
OR
(aa.SupplierID = 39
AND aa.DataSupplierArticleNumber = "92147100")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "820 765")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8120 18126")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8120 18113")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8120 18113C")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8120 18119C")
OR
(aa.SupplierID = 199
AND aa.DataSupplierArticleNumber = "DF1027")
OR
(aa.SupplierID = 199
AND aa.DataSupplierArticleNumber = "DF1119")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "DF4801")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "DF6116")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "DF4458")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V53-80006")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V52-40008")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V52-80015")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "197466")
OR
(aa.SupplierID = 456
AND aa.DataSupplierArticleNumber = "628.2650")
OR
(aa.SupplierID = 456
AND aa.DataSupplierArticleNumber = "628.1512")
OR
(aa.SupplierID = 456
AND aa.DataSupplierArticleNumber = "628.2313")
OR
(aa.SupplierID = 366
AND aa.DataSupplierArticleNumber = "D61365.10")
OR
(aa.SupplierID = 366
AND aa.DataSupplierArticleNumber = "D6990.10")
OR
(aa.SupplierID = 366
AND aa.DataSupplierArticleNumber = "D6991.00")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "BS-5485")
OR
(aa.SupplierID = 86
AND aa.DataSupplierArticleNumber = "320.3800.20")
OR
(aa.SupplierID = 86
AND aa.DataSupplierArticleNumber = "285.3511.20")
)
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 = 206
AND aa.DataSupplierArticleNumber = "17693")
OR
(aa.SupplierID = 206
AND aa.DataSupplierArticleNumber = "17724")
OR
(aa.SupplierID = 206
AND aa.DataSupplierArticleNumber = "18024")
OR
(aa.SupplierID = 4426
AND aa.DataSupplierArticleNumber = "C40312ABE")
OR
(aa.SupplierID = 4533
AND aa.DataSupplierArticleNumber = "242680")
OR
(aa.SupplierID = 4533
AND aa.DataSupplierArticleNumber = "242719")
OR
(aa.SupplierID = 283
AND aa.DataSupplierArticleNumber = "25258")
OR
(aa.SupplierID = 283
AND aa.DataSupplierArticleNumber = "14985")
OR
(aa.SupplierID = 283
AND aa.DataSupplierArticleNumber = "24907")
OR
(aa.SupplierID = 4537
AND aa.DataSupplierArticleNumber = "DK6134")
OR
(aa.SupplierID = 4537
AND aa.DataSupplierArticleNumber = "DSK2543")
OR
(aa.SupplierID = 4537
AND aa.DataSupplierArticleNumber = "DK6177")
OR
(aa.SupplierID = 4537
AND aa.DataSupplierArticleNumber = "DSK2408")
OR
(aa.SupplierID = 4537
AND aa.DataSupplierArticleNumber = "DSK2496")
OR
(aa.SupplierID = 257
AND aa.DataSupplierArticleNumber = "60-0K-010")
OR
(aa.SupplierID = 257
AND aa.DataSupplierArticleNumber = "61-0K-002")
OR
(aa.SupplierID = 442
AND aa.DataSupplierArticleNumber = "0993-1130")
OR
(aa.SupplierID = 3
AND aa.DataSupplierArticleNumber = "24.0118-0145.1")
OR
(aa.SupplierID = 3
AND aa.DataSupplierArticleNumber = "24.0110-0324.1")
OR
(aa.SupplierID = 4337
AND aa.DataSupplierArticleNumber = "ADC0333")
OR
(aa.SupplierID = 4337
AND aa.DataSupplierArticleNumber = "PDC0333")
OR
(aa.SupplierID = 350
AND aa.DataSupplierArticleNumber = "ADG043143")
OR
(aa.SupplierID = 350
AND aa.DataSupplierArticleNumber = "ADG04396")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BBD4528")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BBD4529")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BBD4701")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 986 479 286")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 986 479 S04")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 986 479 256")
OR
(aa.SupplierID = 4993
AND aa.DataSupplierArticleNumber = "AE0337")
OR
(aa.SupplierID = 4993
AND aa.DataSupplierArticleNumber = "AE0126")
OR
(aa.SupplierID = 289
AND aa.DataSupplierArticleNumber = "BS 8868")
OR
(aa.SupplierID = 289
AND aa.DataSupplierArticleNumber = "BS 7776")
OR
(aa.SupplierID = 289
AND aa.DataSupplierArticleNumber = "BS 8512")
OR
(aa.SupplierID = 65
AND aa.DataSupplierArticleNumber = "08.A916.10")
OR
(aa.SupplierID = 65
AND aa.DataSupplierArticleNumber = "09.9503.10")
OR
(aa.SupplierID = 65
AND aa.DataSupplierArticleNumber = "09.A867.10")
OR
(aa.SupplierID = 4872
AND aa.DataSupplierArticleNumber = "DBB268V")
OR
(aa.SupplierID = 4872
AND aa.DataSupplierArticleNumber = "DBB793S")
OR
(aa.SupplierID = 243
AND aa.DataSupplierArticleNumber = "HPD 1146")
OR
(aa.SupplierID = 243
AND aa.DataSupplierArticleNumber = "142.1146")
OR
(aa.SupplierID = 243
AND aa.DataSupplierArticleNumber = "142.1147")
OR
(aa.SupplierID = 243
AND aa.DataSupplierArticleNumber = "142.1296")
OR
(aa.SupplierID = 311
AND aa.DataSupplierArticleNumber = "800-926")
OR
(aa.SupplierID = 311
AND aa.DataSupplierArticleNumber = "800-929")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "ADC1056")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "ADC2401V")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "BG3981")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "BG4535")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "BG3935")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "BG4535C")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "BG3935C")
OR
(aa.SupplierID = 186
AND aa.DataSupplierArticleNumber = "B130523")
OR
(aa.SupplierID = 4519
AND aa.DataSupplierArticleNumber = "BD1108")
OR
(aa.SupplierID = 4948
AND aa.DataSupplierArticleNumber = "DP1010.11.0920")
OR
(aa.SupplierID = 4948
AND aa.DataSupplierArticleNumber = "DP1010.11.0256")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DBD1268")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DBD1792C")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DBD1793")
OR
(aa.SupplierID = 309
AND aa.DataSupplierArticleNumber = "19-0061")
OR
(aa.SupplierID = 309
AND aa.DataSupplierArticleNumber = "19-3285")
OR
(aa.SupplierID = 4770
AND aa.DataSupplierArticleNumber = "5815203518")
OR
(aa.SupplierID = 4770
AND aa.DataSupplierArticleNumber = "5815203529")
OR
(aa.SupplierID = 4770
AND aa.DataSupplierArticleNumber = "5815203517")
OR
(aa.SupplierID = 271
AND aa.DataSupplierArticleNumber = "TB218161")
OR
(aa.SupplierID = 271
AND aa.DataSupplierArticleNumber = "TB219313")
OR
(aa.SupplierID = 62
AND aa.DataSupplierArticleNumber = "DDF1268")
OR
(aa.SupplierID = 62
AND aa.DataSupplierArticleNumber = "DDF1792C")
OR
(aa.SupplierID = 62
AND aa.DataSupplierArticleNumber = "DDF1793")
OR
(aa.SupplierID = 4838
AND aa.DataSupplierArticleNumber = "FBD180")
OR
(aa.SupplierID = 4887
AND aa.DataSupplierArticleNumber = "FO 2811")
OR
(aa.SupplierID = 4887
AND aa.DataSupplierArticleNumber = "FO 4071")
OR
(aa.SupplierID = 409
AND aa.DataSupplierArticleNumber = "BD-5101")
OR
(aa.SupplierID = 409
AND aa.DataSupplierArticleNumber = "BD-5102")
OR
(aa.SupplierID = 295
AND aa.DataSupplierArticleNumber = "BD1119")
OR
(aa.SupplierID = 295
AND aa.DataSupplierArticleNumber = "BD1027")
OR
(aa.SupplierID = 54
AND aa.DataSupplierArticleNumber = "BS7121B")
OR
(aa.SupplierID = 54
AND aa.DataSupplierArticleNumber = "BS5445")
OR
(aa.SupplierID = 54
AND aa.DataSupplierArticleNumber = "BS7544")
OR
(aa.SupplierID = 54
AND aa.DataSupplierArticleNumber = "BS5445B")
OR
(aa.SupplierID = 54
AND aa.DataSupplierArticleNumber = "BS7121")
OR
(aa.SupplierID = 500
AND aa.DataSupplierArticleNumber = "B1.G218-0145.1")
OR
(aa.SupplierID = 500
AND aa.DataSupplierArticleNumber = "B1.G210-0324.1")
OR
(aa.SupplierID = 279
AND aa.DataSupplierArticleNumber = "6061161")
OR
(aa.SupplierID = 279
AND aa.DataSupplierArticleNumber = "6044581")
OR
(aa.SupplierID = 279
AND aa.DataSupplierArticleNumber = "6048014")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8DD 355 112-791")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8DD 355 112-801")
OR
(aa.SupplierID = 4625
AND aa.DataSupplierArticleNumber = "8DD 355 112-791")
OR
(aa.SupplierID = 4625
AND aa.DataSupplierArticleNumber = "8DD 355 112-801")
OR
(aa.SupplierID = 55
AND aa.DataSupplierArticleNumber = "J3310316")
OR
(aa.SupplierID = 55
AND aa.DataSupplierArticleNumber = "J3300321")
OR
(aa.SupplierID = 158
AND aa.DataSupplierArticleNumber = "78BD5102-2")
OR
(aa.SupplierID = 158
AND aa.DataSupplierArticleNumber = "78BD7500-2")
OR
(aa.SupplierID = 459
AND aa.DataSupplierArticleNumber = "IBP-1K07")
OR
(aa.SupplierID = 459
AND aa.DataSupplierArticleNumber = "IBT-1K12")
OR
(aa.SupplierID = 156
AND aa.DataSupplierArticleNumber = "DI-K10")
OR
(aa.SupplierID = 156
AND aa.DataSupplierArticleNumber = "DP-K02")
OR
(aa.SupplierID = 481
AND aa.DataSupplierArticleNumber = "60K10")
OR
(aa.SupplierID = 481
AND aa.DataSupplierArticleNumber = "61K02")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "3663200709")
OR
(aa.SupplierID = 4935
AND aa.DataSupplierArticleNumber = "KIA110")
OR
(aa.SupplierID = 4935
AND aa.DataSupplierArticleNumber = "KIA111")
OR
(aa.SupplierID = 48
AND aa.DataSupplierArticleNumber = "562429J")
OR
(aa.SupplierID = 48
AND aa.DataSupplierArticleNumber = "562429JC")
OR
(aa.SupplierID = 48
AND aa.DataSupplierArticleNumber = "562428J")
OR
(aa.SupplierID = 48
AND aa.DataSupplierArticleNumber = "562555JC")
OR
(aa.SupplierID = 48
AND aa.DataSupplierArticleNumber = "562428JC")
OR
(aa.SupplierID = 4461
AND aa.DataSupplierArticleNumber = "CBR048")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "1031027")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "1032536")
OR
(aa.SupplierID = 201
AND aa.DataSupplierArticleNumber = "BR-4225-C")
OR
(aa.SupplierID = 201
AND aa.DataSupplierArticleNumber = "BR-3257-C")
OR
(aa.SupplierID = 286
AND aa.DataSupplierArticleNumber = "6991 00")
OR
(aa.SupplierID = 286
AND aa.DataSupplierArticleNumber = "61365 10")
OR
(aa.SupplierID = 286
AND aa.DataSupplierArticleNumber = "6990 10")
OR
(aa.SupplierID = 4879
AND aa.DataSupplierArticleNumber = "KBD4528")
OR
(aa.SupplierID = 4879
AND aa.DataSupplierArticleNumber = "KBD4529")
OR
(aa.SupplierID = 197
AND aa.DataSupplierArticleNumber = "K2009V")
OR
(aa.SupplierID = 197
AND aa.DataSupplierArticleNumber = "K2013P")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "BN-1553")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "BN-1554")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "BN-1552")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "360406005500")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "360406112000")
OR
(aa.SupplierID = 317
AND aa.DataSupplierArticleNumber = "1110380")
OR
(aa.SupplierID = 317
AND aa.DataSupplierArticleNumber = "1110104")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "45572")
OR
(aa.SupplierID = 358
AND aa.DataSupplierArticleNumber = "24011003241-PCS-MS")
OR
(aa.SupplierID = 358
AND aa.DataSupplierArticleNumber = "24011003241-SET-MS")
OR
(aa.SupplierID = 358
AND aa.DataSupplierArticleNumber = "24011801451-PCS-MS")
OR
(aa.SupplierID = 358
AND aa.DataSupplierArticleNumber = "24011801451-SET-MS")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "19-1938")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "19-1937")
OR
(aa.SupplierID = 4899
AND aa.DataSupplierArticleNumber = "865517.6060")
OR
(aa.SupplierID = 4899
AND aa.DataSupplierArticleNumber = "865516.6880")
OR
(aa.SupplierID = 4899
AND aa.DataSupplierArticleNumber = "865517.6880")
OR
(aa.SupplierID = 4899
AND aa.DataSupplierArticleNumber = "865516.6980")
OR
(aa.SupplierID = 4899
AND aa.DataSupplierArticleNumber = "865516.0000")
OR
(aa.SupplierID = 4899
AND aa.DataSupplierArticleNumber = "865517.6980")
OR
(aa.SupplierID = 4899
AND aa.DataSupplierArticleNumber = "865517.0000")
OR
(aa.SupplierID = 4899
AND aa.DataSupplierArticleNumber = "865516.6060")
OR
(aa.SupplierID = 4773
AND aa.DataSupplierArticleNumber = "MRD-2K02")
OR
(aa.SupplierID = 4773
AND aa.DataSupplierArticleNumber = "MFD-2K10")
OR
(aa.SupplierID = 121
AND aa.DataSupplierArticleNumber = "23-0926")
OR
(aa.SupplierID = 121
AND aa.DataSupplierArticleNumber = "23-0929")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "6110160")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "6110238")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "37-15 523 0014")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "28-15 521 0009")
OR
(aa.SupplierID = 73
AND aa.DataSupplierArticleNumber = "MDC1725")
OR
(aa.SupplierID = 73
AND aa.DataSupplierArticleNumber = "MDC1726")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "LVBD1188Z")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "LVBD1608")
OR
(aa.SupplierID = 4564
AND aa.DataSupplierArticleNumber = "LVBD1187Z")
OR
(aa.SupplierID = 190
AND aa.DataSupplierArticleNumber = "NBD1686")
OR
(aa.SupplierID = 190
AND aa.DataSupplierArticleNumber = "NBD1342")
OR
(aa.SupplierID = 190
AND aa.DataSupplierArticleNumber = "NBD1343")
OR
(aa.SupplierID = 248
AND aa.DataSupplierArticleNumber = "J3310311")
OR
(aa.SupplierID = 248
AND aa.DataSupplierArticleNumber = "J3300321")
OR
(aa.SupplierID = 248
AND aa.DataSupplierArticleNumber = "J3300321HC")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "313517")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "203517")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "313518")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "203518")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "313529")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "203529")
OR
(aa.SupplierID = 440
AND aa.DataSupplierArticleNumber = "K330A20")
OR
(aa.SupplierID = 440
AND aa.DataSupplierArticleNumber = "K331A04")
OR
(aa.SupplierID = 4380
AND aa.DataSupplierArticleNumber = "2143269")
OR
(aa.SupplierID = 4380
AND aa.DataSupplierArticleNumber = "2134475")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "BDA2184.10")
OR
(aa.SupplierID = 378
AND aa.DataSupplierArticleNumber = "BDA2223.20")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "BS-8156")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "BS-8652")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PBD4458")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PBD4801")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PBD1560")
OR
(aa.SupplierID = 291
AND aa.DataSupplierArticleNumber = "V1821")
OR
(aa.SupplierID = 4686
AND aa.DataSupplierArticleNumber = "5010-1268")
OR
(aa.SupplierID = 4520
AND aa.DataSupplierArticleNumber = "PRD5323")
OR
(aa.SupplierID = 4520
AND aa.DataSupplierArticleNumber = "PRD2313")
OR
(aa.SupplierID = 4520
AND aa.DataSupplierArticleNumber = "PRD2544")
OR
(aa.SupplierID = 4821
AND aa.DataSupplierArticleNumber = "QD7023")
OR
(aa.SupplierID = 4821
AND aa.DataSupplierArticleNumber = "QD8854")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "BDC5755")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "BDC5445")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "BDC5568")
OR
(aa.SupplierID = 4955
AND aa.DataSupplierArticleNumber = "78RBD25102")
OR
(aa.SupplierID = 4955
AND aa.DataSupplierArticleNumber = "78RBD27500")
OR
(aa.SupplierID = 400
AND aa.DataSupplierArticleNumber = "RD00556")
OR
(aa.SupplierID = 400
AND aa.DataSupplierArticleNumber = "RD00566")
OR
(aa.SupplierID = 400
AND aa.DataSupplierArticleNumber = "RD00555")
OR
(aa.SupplierID = 153
AND aa.DataSupplierArticleNumber = "6991.00")
OR
(aa.SupplierID = 153
AND aa.DataSupplierArticleNumber = "61365.10")
OR
(aa.SupplierID = 153
AND aa.DataSupplierArticleNumber = "6990.10")
OR
(aa.SupplierID = 152
AND aa.DataSupplierArticleNumber = "6991.00")
OR
(aa.SupplierID = 152
AND aa.DataSupplierArticleNumber = "61365.10")
OR
(aa.SupplierID = 152
AND aa.DataSupplierArticleNumber = "6990.10")
OR
(aa.SupplierID = 4676
AND aa.DataSupplierArticleNumber = "RT 20376 T5")
OR
(aa.SupplierID = 4676
AND aa.DataSupplierArticleNumber = "RT 1656")
OR
(aa.SupplierID = 4676
AND aa.DataSupplierArticleNumber = "RT 1656 T5")
OR
(aa.SupplierID = 4676
AND aa.DataSupplierArticleNumber = "RT 20376")
OR
(aa.SupplierID = 4547
AND aa.DataSupplierArticleNumber = "604-03-8817")
OR
(aa.SupplierID = 260
AND aa.DataSupplierArticleNumber = "6106229")
OR
(aa.SupplierID = 260
AND aa.DataSupplierArticleNumber = "6106335")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "1815313517")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "1815203517")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "1815313518")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "1815203518")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "1815313529")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "1815203529")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "6020 1425-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "6020 1426-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "6020 1424-SX")
OR
(aa.SupplierID = 39
AND aa.DataSupplierArticleNumber = "92147103")
OR
(aa.SupplierID = 39
AND aa.DataSupplierArticleNumber = "92147200")
OR
(aa.SupplierID = 39
AND aa.DataSupplierArticleNumber = "92147100")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "820 765")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8120 18126")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8120 18113")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8120 18113C")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8120 18119C")
OR
(aa.SupplierID = 199
AND aa.DataSupplierArticleNumber = "DF1027")
OR
(aa.SupplierID = 199
AND aa.DataSupplierArticleNumber = "DF1119")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "DF4801")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "DF6116")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "DF4458")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V53-80006")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V52-40008")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V52-80015")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "197466")
OR
(aa.SupplierID = 456
AND aa.DataSupplierArticleNumber = "628.2650")
OR
(aa.SupplierID = 456
AND aa.DataSupplierArticleNumber = "628.1512")
OR
(aa.SupplierID = 456
AND aa.DataSupplierArticleNumber = "628.2313")
OR
(aa.SupplierID = 366
AND aa.DataSupplierArticleNumber = "D61365.10")
OR
(aa.SupplierID = 366
AND aa.DataSupplierArticleNumber = "D6990.10")
OR
(aa.SupplierID = 366
AND aa.DataSupplierArticleNumber = "D6991.00")
OR
(aa.SupplierID = 4894
AND aa.DataSupplierArticleNumber = "BS-5485")
OR
(aa.SupplierID = 86
AND aa.DataSupplierArticleNumber = "320.3800.20")
OR
(aa.SupplierID = 86
AND aa.DataSupplierArticleNumber = "285.3511.20")
)
AND aa.Language = "ru"
Продажа автозапчастей типа Тормозной диск для автомобилей
