#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2MXx8bW9kZWxfaWQ9PTM0NjZ8fG1kZl9pZD09MF4xMzY0N3x8c3BhcmVfaWQ9PTEwMDE5OA%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 = "13647"
AND (
(av.SupplierID = 4598
AND av.DataSupplierArticleNumber = "32422"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4598
AND av.DataSupplierArticleNumber = "32421"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4987
AND av.DataSupplierArticleNumber = "OP-C-22180"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4987
AND av.DataSupplierArticleNumber = "OP-A-55734"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4987
AND av.DataSupplierArticleNumber = "OP-C-20242"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4987
AND av.DataSupplierArticleNumber = "OP-A-20364"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4987
AND av.DataSupplierArticleNumber = "OP-C-22179"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4987
AND av.DataSupplierArticleNumber = "OP-A-20365"
AND av.ProductID IN (914))
OR
(av.SupplierID = 206
AND av.DataSupplierArticleNumber = "230586"
AND av.ProductID IN (914))
OR
(av.SupplierID = 206
AND av.DataSupplierArticleNumber = "230587"
AND av.ProductID IN (914))
OR
(av.SupplierID = 206
AND av.DataSupplierArticleNumber = "230336"
AND av.ProductID IN (914))
OR
(av.SupplierID = 206
AND av.DataSupplierArticleNumber = "230337"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4829
AND av.DataSupplierArticleNumber = "17OP3180"
AND av.ProductID IN (914,914))
OR
(av.SupplierID = 4829
AND av.DataSupplierArticleNumber = "17OP3179"
AND av.ProductID IN (914,914))
OR
(av.SupplierID = 4829
AND av.DataSupplierArticleNumber = "17OP3177"
AND av.ProductID IN (914,914))
OR
(av.SupplierID = 4829
AND av.DataSupplierArticleNumber = "17OP3178"
AND av.ProductID IN (914,914))
OR
(av.SupplierID = 4737
AND av.DataSupplierArticleNumber = "FT1401"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4737
AND av.DataSupplierArticleNumber = "FT1093"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4737
AND av.DataSupplierArticleNumber = "FT1094"
AND av.ProductID IN (914))
OR
(av.SupplierID = 49
AND av.DataSupplierArticleNumber = "041121B"
AND av.ProductID IN (51))
OR
(av.SupplierID = 49
AND av.DataSupplierArticleNumber = "040662B"
AND av.ProductID IN (914))
OR
(av.SupplierID = 49
AND av.DataSupplierArticleNumber = "040290B"
AND av.ProductID IN (914))
OR
(av.SupplierID = 49
AND av.DataSupplierArticleNumber = "040292B"
AND av.ProductID IN (914))
OR
(av.SupplierID = 49
AND av.DataSupplierArticleNumber = "040661B"
AND av.ProductID IN (914))
OR
(av.SupplierID = 208
AND av.DataSupplierArticleNumber = "TD1419"
AND av.ProductID IN (914))
OR
(av.SupplierID = 208
AND av.DataSupplierArticleNumber = "TS1418"
AND av.ProductID IN (914))
OR
(av.SupplierID = 208
AND av.DataSupplierArticleNumber = "TS1419"
AND av.ProductID IN (914))
OR
(av.SupplierID = 208
AND av.DataSupplierArticleNumber = "TD1418"
AND av.ProductID IN (914))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BTR4534"
AND av.ProductID IN (914))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BTR4536"
AND av.ProductID IN (914))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BTR4528"
AND av.ProductID IN (914))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BTR4532"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4455
AND av.DataSupplierArticleNumber = "BSG 65-310-049"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4455
AND av.DataSupplierArticleNumber = "BSG 65-310-051"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4455
AND av.DataSupplierArticleNumber = "BSG 65-310-046"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4455
AND av.DataSupplierArticleNumber = "BSG 65-310-047"
AND av.ProductID IN (914))
OR
(av.SupplierID = 405
AND av.DataSupplierArticleNumber = "480522"
AND av.ProductID IN (676))
OR
(av.SupplierID = 421
AND av.DataSupplierArticleNumber = "CTR1065"
AND av.ProductID IN (914))
OR
(av.SupplierID = 421
AND av.DataSupplierArticleNumber = "CTR2065"
AND av.ProductID IN (914))
OR
(av.SupplierID = 89
AND av.DataSupplierArticleNumber = "TA1208"
AND av.ProductID IN (914))
OR
(av.SupplierID = 89
AND av.DataSupplierArticleNumber = "TA1593"
AND av.ProductID IN (914))
OR
(av.SupplierID = 89
AND av.DataSupplierArticleNumber = "TA1594"
AND av.ProductID IN (914))
OR
(av.SupplierID = 89
AND av.DataSupplierArticleNumber = "TA1206"
AND av.ProductID IN (914))
OR
(av.SupplierID = 186
AND av.DataSupplierArticleNumber = "D130046"
AND av.ProductID IN (914))
OR
(av.SupplierID = 186
AND av.DataSupplierArticleNumber = "D130088"
AND av.ProductID IN (914))
OR
(av.SupplierID = 186
AND av.DataSupplierArticleNumber = "D130111"
AND av.ProductID IN (914))
OR
(av.SupplierID = 186
AND av.DataSupplierArticleNumber = "D130040"
AND av.ProductID IN (914))
OR
(av.SupplierID = 253
AND av.DataSupplierArticleNumber = "1184404"
AND av.ProductID IN (914))
OR
(av.SupplierID = 471
AND av.DataSupplierArticleNumber = "A2-5340"
AND av.ProductID IN (914))
OR
(av.SupplierID = 267
AND av.DataSupplierArticleNumber = "SS6017"
AND av.ProductID IN (914))
OR
(av.SupplierID = 267
AND av.DataSupplierArticleNumber = "SS1185"
AND av.ProductID IN (914))
OR
(av.SupplierID = 267
AND av.DataSupplierArticleNumber = "SS6018"
AND av.ProductID IN (914))
OR
(av.SupplierID = 267
AND av.DataSupplierArticleNumber = "SS507"
AND av.ProductID IN (914))
OR
(av.SupplierID = 267
AND av.DataSupplierArticleNumber = "SS508"
AND av.ProductID IN (914))
OR
(av.SupplierID = 267
AND av.DataSupplierArticleNumber = "SS1184"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4834
AND av.DataSupplierArticleNumber = "RD049"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4834
AND av.DataSupplierArticleNumber = "RD051"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4834
AND av.DataSupplierArticleNumber = "RD046"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4834
AND av.DataSupplierArticleNumber = "RD047"
AND av.ProductID IN (914))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "01855"
AND av.ProductID IN (914))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "06192"
AND av.ProductID IN (914))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "06193"
AND av.ProductID IN (914))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "01854"
AND av.ProductID IN (914))
OR
(av.SupplierID = 407
AND av.DataSupplierArticleNumber = "FTR4536"
AND av.ProductID IN (914))
OR
(av.SupplierID = 407
AND av.DataSupplierArticleNumber = "FTR4528"
AND av.ProductID IN (914))
OR
(av.SupplierID = 407
AND av.DataSupplierArticleNumber = "FTR4532"
AND av.ProductID IN (914))
OR
(av.SupplierID = 407
AND av.DataSupplierArticleNumber = "FTR4534"
AND av.ProductID IN (914))
OR
(av.SupplierID = 236
AND av.DataSupplierArticleNumber = "FL939-B"
AND av.ProductID IN (914))
OR
(av.SupplierID = 236
AND av.DataSupplierArticleNumber = "FL257-B"
AND av.ProductID IN (914))
OR
(av.SupplierID = 236
AND av.DataSupplierArticleNumber = "FL588-C"
AND av.ProductID IN (51))
OR
(av.SupplierID = 236
AND av.DataSupplierArticleNumber = "FL258-B"
AND av.ProductID IN (914))
OR
(av.SupplierID = 236
AND av.DataSupplierArticleNumber = "FL927-B"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4727
AND av.DataSupplierArticleNumber = "2001017"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4727
AND av.DataSupplierArticleNumber = "2001014"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4727
AND av.DataSupplierArticleNumber = "2001015"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4727
AND av.DataSupplierArticleNumber = "2001016"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4727
AND av.DataSupplierArticleNumber = "2001011"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4467
AND av.DataSupplierArticleNumber = "FZ1368"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4467
AND av.DataSupplierArticleNumber = "FZ1369"
AND av.ProductID IN (914))
OR
(av.SupplierID = 486
AND av.DataSupplierArticleNumber = "2065"
AND av.ProductID IN (914))
OR
(av.SupplierID = 486
AND av.DataSupplierArticleNumber = "2066"
AND av.ProductID IN (914))
OR
(av.SupplierID = 486
AND av.DataSupplierArticleNumber = "2067"
AND av.ProductID IN (914))
OR
(av.SupplierID = 486
AND av.DataSupplierArticleNumber = "2064"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4844
AND av.DataSupplierArticleNumber = "GSP121005"
AND av.ProductID IN (914,914))
OR
(av.SupplierID = 4844
AND av.DataSupplierArticleNumber = "GSP701004"
AND av.ProductID IN (914,914))
OR
(av.SupplierID = 4844
AND av.DataSupplierArticleNumber = "GSP201122"
AND av.ProductID IN (914,914))
OR
(av.SupplierID = 4844
AND av.DataSupplierArticleNumber = "GSP201055"
AND av.ProductID IN (914,914))
OR
(av.SupplierID = 4844
AND av.DataSupplierArticleNumber = "GSP121006"
AND av.ProductID IN (914,914))
OR
(av.SupplierID = 4844
AND av.DataSupplierArticleNumber = "GSP201056"
AND av.ProductID IN (914,914))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1244601880"
AND av.ProductID IN (914))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1244601679"
AND av.ProductID IN (914))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1244601889"
AND av.ProductID IN (914))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1244601680"
AND av.ProductID IN (914))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1244601879"
AND av.ProductID IN (914))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1244601670"
AND av.ProductID IN (914))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "999527"
AND av.ProductID IN (51))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "999631"
AND av.ProductID IN (914))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "999636"
AND av.ProductID IN (914))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "999536"
AND av.ProductID IN (914))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "999526"
AND av.ProductID IN (51))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "999537"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "4311650"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "4311590"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "4311660"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "4311595"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "4311640"
AND av.ProductID IN (914))
OR
(av.SupplierID = 35
AND av.DataSupplierArticleNumber = "26799 01"
AND av.ProductID IN (914))
OR
(av.SupplierID = 35
AND av.DataSupplierArticleNumber = "14703 01"
AND av.ProductID IN (914))
OR
(av.SupplierID = 35
AND av.DataSupplierArticleNumber = "14704 01"
AND av.ProductID IN (914))
OR
(av.SupplierID = 35
AND av.DataSupplierArticleNumber = "14131 01"
AND av.ProductID IN (914))
OR
(av.SupplierID = 35
AND av.DataSupplierArticleNumber = "26798 01"
AND av.ProductID IN (914))
OR
(av.SupplierID = 35
AND av.DataSupplierArticleNumber = "14599 01"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4600
AND av.DataSupplierArticleNumber = "C4262L"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4600
AND av.DataSupplierArticleNumber = "C4262R"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4600
AND av.DataSupplierArticleNumber = "C4213L"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4600
AND av.DataSupplierArticleNumber = "C4213R"
AND av.ProductID IN (914))
OR
(av.SupplierID = 133
AND av.DataSupplierArticleNumber = "49758"
AND av.ProductID IN (914))
OR
(av.SupplierID = 133
AND av.DataSupplierArticleNumber = "49759"
AND av.ProductID IN (914))
OR
(av.SupplierID = 133
AND av.DataSupplierArticleNumber = "49600"
AND av.ProductID IN (914))
OR
(av.SupplierID = 133
AND av.DataSupplierArticleNumber = "49601"
AND av.ProductID IN (914))
OR
(av.SupplierID = 358
AND av.DataSupplierArticleNumber = "14599-PCS-MS"
AND av.ProductID IN (914))
OR
(av.SupplierID = 403
AND av.DataSupplierArticleNumber = "69-0218"
AND av.ProductID IN (914))
OR
(av.SupplierID = 403
AND av.DataSupplierArticleNumber = "69-0324"
AND av.ProductID IN (914))
OR
(av.SupplierID = 403
AND av.DataSupplierArticleNumber = "69-0325"
AND av.ProductID IN (914))
OR
(av.SupplierID = 403
AND av.DataSupplierArticleNumber = "69-0217"
AND av.ProductID IN (914))
OR
(av.SupplierID = 94
AND av.DataSupplierArticleNumber = "54001502"
AND av.ProductID IN (914))
OR
(av.SupplierID = 94
AND av.DataSupplierArticleNumber = "84001502"
AND av.ProductID IN (914))
OR
(av.SupplierID = 94
AND av.DataSupplierArticleNumber = "54001601"
AND av.ProductID IN (914))
OR
(av.SupplierID = 94
AND av.DataSupplierArticleNumber = "84001601"
AND av.ProductID IN (914))
OR
(av.SupplierID = 94
AND av.DataSupplierArticleNumber = "54004001"
AND av.ProductID IN (914))
OR
(av.SupplierID = 94
AND av.DataSupplierArticleNumber = "54004102"
AND av.ProductID IN (914))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "616 020 5589"
AND av.ProductID IN (914))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "616 020 5555"
AND av.ProductID IN (914))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "616 020 5557"
AND av.ProductID IN (914))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "616 020 5588"
AND av.ProductID IN (914))
OR
(av.SupplierID = 37
AND av.DataSupplierArticleNumber = "L24107"
AND av.ProductID IN (914))
OR
(av.SupplierID = 37
AND av.DataSupplierArticleNumber = "L24108"
AND av.ProductID IN (914))
OR
(av.SupplierID = 37
AND av.DataSupplierArticleNumber = "L24105"
AND av.ProductID IN (914))
OR
(av.SupplierID = 37
AND av.DataSupplierArticleNumber = "L24125"
AND av.ProductID IN (914))
OR
(av.SupplierID = 37
AND av.DataSupplierArticleNumber = "L24106"
AND av.ProductID IN (914))
OR
(av.SupplierID = 37
AND av.DataSupplierArticleNumber = "L24126"
AND av.ProductID IN (914))
OR
(av.SupplierID = 134
AND av.DataSupplierArticleNumber = "OP-ES-5557"
AND av.ProductID IN (914))
OR
(av.SupplierID = 134
AND av.DataSupplierArticleNumber = "OP-ES-5588"
AND av.ProductID IN (914))
OR
(av.SupplierID = 134
AND av.DataSupplierArticleNumber = "OP-ES-5589"
AND av.ProductID IN (914))
OR
(av.SupplierID = 134
AND av.DataSupplierArticleNumber = "OP-ES-5555"
AND av.ProductID IN (914))
OR
(av.SupplierID = 127
AND av.DataSupplierArticleNumber = "5033650"
AND av.ProductID IN (914))
OR
(av.SupplierID = 127
AND av.DataSupplierArticleNumber = "5033651"
AND av.ProductID IN (914))
OR
(av.SupplierID = 127
AND av.DataSupplierArticleNumber = "5033652"
AND av.ProductID IN (914))
OR
(av.SupplierID = 127
AND av.DataSupplierArticleNumber = "5033653"
AND av.ProductID IN (914))
OR
(av.SupplierID = 198
AND av.DataSupplierArticleNumber = "0181418"
AND av.ProductID IN (914))
OR
(av.SupplierID = 198
AND av.DataSupplierArticleNumber = "0191418"
AND av.ProductID IN (914))
OR
(av.SupplierID = 129
AND av.DataSupplierArticleNumber = "G1-369"
AND av.ProductID IN (914))
OR
(av.SupplierID = 129
AND av.DataSupplierArticleNumber = "G1-038"
AND av.ProductID IN (914))
OR
(av.SupplierID = 129
AND av.DataSupplierArticleNumber = "G2-699"
AND av.ProductID IN (51))
OR
(av.SupplierID = 129
AND av.DataSupplierArticleNumber = "G1-040"
AND av.ProductID IN (914))
OR
(av.SupplierID = 129
AND av.DataSupplierArticleNumber = "G1-368"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4558
AND av.DataSupplierArticleNumber = "PS1109R"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4558
AND av.DataSupplierArticleNumber = "PS1116L"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4558
AND av.DataSupplierArticleNumber = "PS1109L"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4686
AND av.DataSupplierArticleNumber = "2302-0284"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4686
AND av.DataSupplierArticleNumber = "2302-0291"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4686
AND av.DataSupplierArticleNumber = "2302-0292"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4686
AND av.DataSupplierArticleNumber = "2302-0282"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4368
AND av.DataSupplierArticleNumber = "TR7496"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4368
AND av.DataSupplierArticleNumber = "TR7502"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4368
AND av.DataSupplierArticleNumber = "TR7526"
AND av.ProductID IN (914))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "QR3027S"
AND av.ProductID IN (914))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "QR3028S"
AND av.ProductID IN (914))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "QR3025S"
AND av.ProductID IN (914))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "QR3026S"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4708
AND av.DataSupplierArticleNumber = "OP2020"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4708
AND av.DataSupplierArticleNumber = "OP2025"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4708
AND av.DataSupplierArticleNumber = "OP2026"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4708
AND av.DataSupplierArticleNumber = "OP2021"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4708
AND av.DataSupplierArticleNumber = "OP2027"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4708
AND av.DataSupplierArticleNumber = "OP2024"
AND av.ProductID IN (914))
OR
(av.SupplierID = 430
AND av.DataSupplierArticleNumber = "91-00340"
AND av.ProductID IN (914))
OR
(av.SupplierID = 430
AND av.DataSupplierArticleNumber = "91-00342"
AND av.ProductID IN (914))
OR
(av.SupplierID = 430
AND av.DataSupplierArticleNumber = "91-00351"
AND av.ProductID IN (914))
OR
(av.SupplierID = 430
AND av.DataSupplierArticleNumber = "91-00353"
AND av.ProductID IN (914))
OR
(av.SupplierID = 23
AND av.DataSupplierArticleNumber = "915365"
AND av.ProductID IN (914))
OR
(av.SupplierID = 23
AND av.DataSupplierArticleNumber = "915362"
AND av.ProductID IN (914))
OR
(av.SupplierID = 23
AND av.DataSupplierArticleNumber = "915363"
AND av.ProductID IN (914))
OR
(av.SupplierID = 23
AND av.DataSupplierArticleNumber = "915364"
AND av.ProductID IN (914))
OR
(av.SupplierID = 260
AND av.DataSupplierArticleNumber = "9006379"
AND av.ProductID IN (914))
OR
(av.SupplierID = 260
AND av.DataSupplierArticleNumber = "9006559"
AND av.ProductID IN (914))
OR
(av.SupplierID = 260
AND av.DataSupplierArticleNumber = "9006560"
AND av.ProductID IN (914))
OR
(av.SupplierID = 260
AND av.DataSupplierArticleNumber = "9006378"
AND av.ProductID IN (914))
OR
(av.SupplierID = 297
AND av.DataSupplierArticleNumber = "19065033651"
AND av.ProductID IN (914))
OR
(av.SupplierID = 297
AND av.DataSupplierArticleNumber = "19065033652"
AND av.ProductID IN (914))
OR
(av.SupplierID = 297
AND av.DataSupplierArticleNumber = "19065033653"
AND av.ProductID IN (914))
OR
(av.SupplierID = 297
AND av.DataSupplierArticleNumber = "19065033650"
AND av.ProductID IN (914))
OR
(av.SupplierID = 135
AND av.DataSupplierArticleNumber = "9536"
AND av.ProductID IN (914))
OR
(av.SupplierID = 135
AND av.DataSupplierArticleNumber = "9537"
AND av.ProductID IN (914))
OR
(av.SupplierID = 135
AND av.DataSupplierArticleNumber = "9631"
AND av.ProductID IN (914))
OR
(av.SupplierID = 135
AND av.DataSupplierArticleNumber = "9636"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "51-00280-SX"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "53-01232-SX"
AND av.ProductID IN (51))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "51-00215A-SX"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "51-05189-SX"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "51-00280A-SX"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "53-01233-SX"
AND av.ProductID IN (51))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "51-00216-SX"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "51-98001-SX"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "51-00391-SX"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "55-00269-SX"
AND av.ProductID IN (51))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "51-00216A-SX"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "53-00798-SX"
AND av.ProductID IN (51))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "51-00215-SX"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "51-00917-SX"
AND av.ProductID IN (914))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "40 71 0010"
AND av.ProductID IN (914))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "40 71 0011"
AND av.ProductID IN (914))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "40 71 0002"
AND av.ProductID IN (914))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "40 71 0003"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4758
AND av.DataSupplierArticleNumber = "42-02660"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4758
AND av.DataSupplierArticleNumber = "42-02654"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4758
AND av.DataSupplierArticleNumber = "42-06388"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4758
AND av.DataSupplierArticleNumber = "42-02655"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4758
AND av.DataSupplierArticleNumber = "42-02652"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4758
AND av.DataSupplierArticleNumber = "42-06389"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4758
AND av.DataSupplierArticleNumber = "42-02658"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4758
AND av.DataSupplierArticleNumber = "42-02653"
AND av.ProductID IN (914))
OR
(av.SupplierID = 301
AND av.DataSupplierArticleNumber = "205 219"
AND av.ProductID IN (914))
OR
(av.SupplierID = 301
AND av.DataSupplierArticleNumber = "205 218"
AND av.ProductID IN (914))
OR
(av.SupplierID = 108
AND av.DataSupplierArticleNumber = "8500 24108"
AND av.ProductID IN (914))
OR
(av.SupplierID = 108
AND av.DataSupplierArticleNumber = "8500 24105"
AND av.ProductID IN (914))
OR
(av.SupplierID = 108
AND av.DataSupplierArticleNumber = "8500 24125"
AND av.ProductID IN (914))
OR
(av.SupplierID = 108
AND av.DataSupplierArticleNumber = "8500 24106"
AND av.ProductID IN (914))
OR
(av.SupplierID = 108
AND av.DataSupplierArticleNumber = "8500 24126"
AND av.ProductID IN (914))
OR
(av.SupplierID = 108
AND av.DataSupplierArticleNumber = "8500 24107"
AND av.ProductID IN (914))
OR
(av.SupplierID = 161
AND av.DataSupplierArticleNumber = "JTE337"
AND av.ProductID IN (914))
OR
(av.SupplierID = 161
AND av.DataSupplierArticleNumber = "JTE703"
AND av.ProductID IN (914))
OR
(av.SupplierID = 161
AND av.DataSupplierArticleNumber = "JTE728"
AND av.ProductID IN (914))
OR
(av.SupplierID = 161
AND av.DataSupplierArticleNumber = "JTE336"
AND av.ProductID IN (914))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V40-0253"
AND av.ProductID IN (914))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V40-9503"
AND av.ProductID IN (914))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V40-0437"
AND av.ProductID IN (914))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V40-0254"
AND av.ProductID IN (914))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V40-0438"
AND av.ProductID IN (914))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V40-0435"
AND av.ProductID IN (914))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V40-9502"
AND av.ProductID IN (914))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V40-0436"
AND av.ProductID IN (914))
OR
(av.SupplierID = 4425
AND av.DataSupplierArticleNumber = "16932"
AND av.ProductID IN (914,914))
OR
(av.SupplierID = 4425
AND av.DataSupplierArticleNumber = "22535"
AND av.ProductID IN (914,914))
OR
(av.SupplierID = 4425
AND av.DataSupplierArticleNumber = "22533"
AND av.ProductID IN (914,914))
OR
(av.SupplierID = 4425
AND av.DataSupplierArticleNumber = "22531"
AND av.ProductID IN (914,914))
OR
(av.SupplierID = 4425
AND av.DataSupplierArticleNumber = "22530"
AND av.ProductID IN (914,914))
OR
(av.SupplierID = 4425
AND av.DataSupplierArticleNumber = "22532"
AND av.ProductID IN (914,914))
OR
(av.SupplierID = 4425
AND av.DataSupplierArticleNumber = "16935"
AND av.ProductID IN (914,914))
)
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 = 4598
AND aa.DataSupplierArticleNumber = "32422")
OR
(aa.SupplierID = 4598
AND aa.DataSupplierArticleNumber = "32421")
OR
(aa.SupplierID = 4987
AND aa.DataSupplierArticleNumber = "OP-C-22180")
OR
(aa.SupplierID = 4987
AND aa.DataSupplierArticleNumber = "OP-A-55734")
OR
(aa.SupplierID = 4987
AND aa.DataSupplierArticleNumber = "OP-C-20242")
OR
(aa.SupplierID = 4987
AND aa.DataSupplierArticleNumber = "OP-A-20364")
OR
(aa.SupplierID = 4987
AND aa.DataSupplierArticleNumber = "OP-C-22179")
OR
(aa.SupplierID = 4987
AND aa.DataSupplierArticleNumber = "OP-A-20365")
OR
(aa.SupplierID = 206
AND aa.DataSupplierArticleNumber = "230586")
OR
(aa.SupplierID = 206
AND aa.DataSupplierArticleNumber = "230587")
OR
(aa.SupplierID = 206
AND aa.DataSupplierArticleNumber = "230336")
OR
(aa.SupplierID = 206
AND aa.DataSupplierArticleNumber = "230337")
OR
(aa.SupplierID = 4829
AND aa.DataSupplierArticleNumber = "17OP3180")
OR
(aa.SupplierID = 4829
AND aa.DataSupplierArticleNumber = "17OP3179")
OR
(aa.SupplierID = 4829
AND aa.DataSupplierArticleNumber = "17OP3177")
OR
(aa.SupplierID = 4829
AND aa.DataSupplierArticleNumber = "17OP3178")
OR
(aa.SupplierID = 4737
AND aa.DataSupplierArticleNumber = "FT1401")
OR
(aa.SupplierID = 4737
AND aa.DataSupplierArticleNumber = "FT1093")
OR
(aa.SupplierID = 4737
AND aa.DataSupplierArticleNumber = "FT1094")
OR
(aa.SupplierID = 49
AND aa.DataSupplierArticleNumber = "041121B")
OR
(aa.SupplierID = 49
AND aa.DataSupplierArticleNumber = "040662B")
OR
(aa.SupplierID = 49
AND aa.DataSupplierArticleNumber = "040290B")
OR
(aa.SupplierID = 49
AND aa.DataSupplierArticleNumber = "040292B")
OR
(aa.SupplierID = 49
AND aa.DataSupplierArticleNumber = "040661B")
OR
(aa.SupplierID = 208
AND aa.DataSupplierArticleNumber = "TD1419")
OR
(aa.SupplierID = 208
AND aa.DataSupplierArticleNumber = "TS1418")
OR
(aa.SupplierID = 208
AND aa.DataSupplierArticleNumber = "TS1419")
OR
(aa.SupplierID = 208
AND aa.DataSupplierArticleNumber = "TD1418")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BTR4534")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BTR4536")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BTR4528")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BTR4532")
OR
(aa.SupplierID = 4455
AND aa.DataSupplierArticleNumber = "BSG 65-310-049")
OR
(aa.SupplierID = 4455
AND aa.DataSupplierArticleNumber = "BSG 65-310-051")
OR
(aa.SupplierID = 4455
AND aa.DataSupplierArticleNumber = "BSG 65-310-046")
OR
(aa.SupplierID = 4455
AND aa.DataSupplierArticleNumber = "BSG 65-310-047")
OR
(aa.SupplierID = 405
AND aa.DataSupplierArticleNumber = "480522")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "CTR1065")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "CTR2065")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "TA1208")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "TA1593")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "TA1594")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "TA1206")
OR
(aa.SupplierID = 186
AND aa.DataSupplierArticleNumber = "D130046")
OR
(aa.SupplierID = 186
AND aa.DataSupplierArticleNumber = "D130088")
OR
(aa.SupplierID = 186
AND aa.DataSupplierArticleNumber = "D130111")
OR
(aa.SupplierID = 186
AND aa.DataSupplierArticleNumber = "D130040")
OR
(aa.SupplierID = 253
AND aa.DataSupplierArticleNumber = "1184404")
OR
(aa.SupplierID = 471
AND aa.DataSupplierArticleNumber = "A2-5340")
OR
(aa.SupplierID = 267
AND aa.DataSupplierArticleNumber = "SS6017")
OR
(aa.SupplierID = 267
AND aa.DataSupplierArticleNumber = "SS1185")
OR
(aa.SupplierID = 267
AND aa.DataSupplierArticleNumber = "SS6018")
OR
(aa.SupplierID = 267
AND aa.DataSupplierArticleNumber = "SS507")
OR
(aa.SupplierID = 267
AND aa.DataSupplierArticleNumber = "SS508")
OR
(aa.SupplierID = 267
AND aa.DataSupplierArticleNumber = "SS1184")
OR
(aa.SupplierID = 4834
AND aa.DataSupplierArticleNumber = "RD049")
OR
(aa.SupplierID = 4834
AND aa.DataSupplierArticleNumber = "RD051")
OR
(aa.SupplierID = 4834
AND aa.DataSupplierArticleNumber = "RD046")
OR
(aa.SupplierID = 4834
AND aa.DataSupplierArticleNumber = "RD047")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "01855")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "06192")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "06193")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "01854")
OR
(aa.SupplierID = 407
AND aa.DataSupplierArticleNumber = "FTR4536")
OR
(aa.SupplierID = 407
AND aa.DataSupplierArticleNumber = "FTR4528")
OR
(aa.SupplierID = 407
AND aa.DataSupplierArticleNumber = "FTR4532")
OR
(aa.SupplierID = 407
AND aa.DataSupplierArticleNumber = "FTR4534")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "FL939-B")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "FL257-B")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "FL588-C")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "FL258-B")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "FL927-B")
OR
(aa.SupplierID = 4727
AND aa.DataSupplierArticleNumber = "2001017")
OR
(aa.SupplierID = 4727
AND aa.DataSupplierArticleNumber = "2001014")
OR
(aa.SupplierID = 4727
AND aa.DataSupplierArticleNumber = "2001015")
OR
(aa.SupplierID = 4727
AND aa.DataSupplierArticleNumber = "2001016")
OR
(aa.SupplierID = 4727
AND aa.DataSupplierArticleNumber = "2001011")
OR
(aa.SupplierID = 4467
AND aa.DataSupplierArticleNumber = "FZ1368")
OR
(aa.SupplierID = 4467
AND aa.DataSupplierArticleNumber = "FZ1369")
OR
(aa.SupplierID = 486
AND aa.DataSupplierArticleNumber = "2065")
OR
(aa.SupplierID = 486
AND aa.DataSupplierArticleNumber = "2066")
OR
(aa.SupplierID = 486
AND aa.DataSupplierArticleNumber = "2067")
OR
(aa.SupplierID = 486
AND aa.DataSupplierArticleNumber = "2064")
OR
(aa.SupplierID = 4844
AND aa.DataSupplierArticleNumber = "GSP121005")
OR
(aa.SupplierID = 4844
AND aa.DataSupplierArticleNumber = "GSP701004")
OR
(aa.SupplierID = 4844
AND aa.DataSupplierArticleNumber = "GSP201122")
OR
(aa.SupplierID = 4844
AND aa.DataSupplierArticleNumber = "GSP201055")
OR
(aa.SupplierID = 4844
AND aa.DataSupplierArticleNumber = "GSP121006")
OR
(aa.SupplierID = 4844
AND aa.DataSupplierArticleNumber = "GSP201056")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1244601880")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1244601679")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1244601889")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1244601680")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1244601879")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1244601670")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "999527")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "999631")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "999636")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "999536")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "999526")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "999537")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "4311650")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "4311590")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "4311660")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "4311595")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "4311640")
OR
(aa.SupplierID = 35
AND aa.DataSupplierArticleNumber = "26799 01")
OR
(aa.SupplierID = 35
AND aa.DataSupplierArticleNumber = "14703 01")
OR
(aa.SupplierID = 35
AND aa.DataSupplierArticleNumber = "14704 01")
OR
(aa.SupplierID = 35
AND aa.DataSupplierArticleNumber = "14131 01")
OR
(aa.SupplierID = 35
AND aa.DataSupplierArticleNumber = "26798 01")
OR
(aa.SupplierID = 35
AND aa.DataSupplierArticleNumber = "14599 01")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "C4262L")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "C4262R")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "C4213L")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "C4213R")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "49758")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "49759")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "49600")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "49601")
OR
(aa.SupplierID = 358
AND aa.DataSupplierArticleNumber = "14599-PCS-MS")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "69-0218")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "69-0324")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "69-0325")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "69-0217")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "54001502")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "84001502")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "54001601")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "84001601")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "54004001")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "54004102")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "616 020 5589")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "616 020 5555")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "616 020 5557")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "616 020 5588")
OR
(aa.SupplierID = 37
AND aa.DataSupplierArticleNumber = "L24107")
OR
(aa.SupplierID = 37
AND aa.DataSupplierArticleNumber = "L24108")
OR
(aa.SupplierID = 37
AND aa.DataSupplierArticleNumber = "L24105")
OR
(aa.SupplierID = 37
AND aa.DataSupplierArticleNumber = "L24125")
OR
(aa.SupplierID = 37
AND aa.DataSupplierArticleNumber = "L24106")
OR
(aa.SupplierID = 37
AND aa.DataSupplierArticleNumber = "L24126")
OR
(aa.SupplierID = 134
AND aa.DataSupplierArticleNumber = "OP-ES-5557")
OR
(aa.SupplierID = 134
AND aa.DataSupplierArticleNumber = "OP-ES-5588")
OR
(aa.SupplierID = 134
AND aa.DataSupplierArticleNumber = "OP-ES-5589")
OR
(aa.SupplierID = 134
AND aa.DataSupplierArticleNumber = "OP-ES-5555")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "5033650")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "5033651")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "5033652")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "5033653")
OR
(aa.SupplierID = 198
AND aa.DataSupplierArticleNumber = "0181418")
OR
(aa.SupplierID = 198
AND aa.DataSupplierArticleNumber = "0191418")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "G1-369")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "G1-038")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "G2-699")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "G1-040")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "G1-368")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PS1109R")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PS1116L")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PS1109L")
OR
(aa.SupplierID = 4686
AND aa.DataSupplierArticleNumber = "2302-0284")
OR
(aa.SupplierID = 4686
AND aa.DataSupplierArticleNumber = "2302-0291")
OR
(aa.SupplierID = 4686
AND aa.DataSupplierArticleNumber = "2302-0292")
OR
(aa.SupplierID = 4686
AND aa.DataSupplierArticleNumber = "2302-0282")
OR
(aa.SupplierID = 4368
AND aa.DataSupplierArticleNumber = "TR7496")
OR
(aa.SupplierID = 4368
AND aa.DataSupplierArticleNumber = "TR7502")
OR
(aa.SupplierID = 4368
AND aa.DataSupplierArticleNumber = "TR7526")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QR3027S")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QR3028S")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QR3025S")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QR3026S")
OR
(aa.SupplierID = 4708
AND aa.DataSupplierArticleNumber = "OP2020")
OR
(aa.SupplierID = 4708
AND aa.DataSupplierArticleNumber = "OP2025")
OR
(aa.SupplierID = 4708
AND aa.DataSupplierArticleNumber = "OP2026")
OR
(aa.SupplierID = 4708
AND aa.DataSupplierArticleNumber = "OP2021")
OR
(aa.SupplierID = 4708
AND aa.DataSupplierArticleNumber = "OP2027")
OR
(aa.SupplierID = 4708
AND aa.DataSupplierArticleNumber = "OP2024")
OR
(aa.SupplierID = 430
AND aa.DataSupplierArticleNumber = "91-00340")
OR
(aa.SupplierID = 430
AND aa.DataSupplierArticleNumber = "91-00342")
OR
(aa.SupplierID = 430
AND aa.DataSupplierArticleNumber = "91-00351")
OR
(aa.SupplierID = 430
AND aa.DataSupplierArticleNumber = "91-00353")
OR
(aa.SupplierID = 23
AND aa.DataSupplierArticleNumber = "915365")
OR
(aa.SupplierID = 23
AND aa.DataSupplierArticleNumber = "915362")
OR
(aa.SupplierID = 23
AND aa.DataSupplierArticleNumber = "915363")
OR
(aa.SupplierID = 23
AND aa.DataSupplierArticleNumber = "915364")
OR
(aa.SupplierID = 260
AND aa.DataSupplierArticleNumber = "9006379")
OR
(aa.SupplierID = 260
AND aa.DataSupplierArticleNumber = "9006559")
OR
(aa.SupplierID = 260
AND aa.DataSupplierArticleNumber = "9006560")
OR
(aa.SupplierID = 260
AND aa.DataSupplierArticleNumber = "9006378")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "19065033651")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "19065033652")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "19065033653")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "19065033650")
OR
(aa.SupplierID = 135
AND aa.DataSupplierArticleNumber = "9536")
OR
(aa.SupplierID = 135
AND aa.DataSupplierArticleNumber = "9537")
OR
(aa.SupplierID = 135
AND aa.DataSupplierArticleNumber = "9631")
OR
(aa.SupplierID = 135
AND aa.DataSupplierArticleNumber = "9636")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "51-00280-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "53-01232-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "51-00215A-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "51-05189-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "51-00280A-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "53-01233-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "51-00216-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "51-98001-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "51-00391-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "55-00269-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "51-00216A-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "53-00798-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "51-00215-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "51-00917-SX")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "40 71 0010")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "40 71 0011")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "40 71 0002")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "40 71 0003")
OR
(aa.SupplierID = 4758
AND aa.DataSupplierArticleNumber = "42-02660")
OR
(aa.SupplierID = 4758
AND aa.DataSupplierArticleNumber = "42-02654")
OR
(aa.SupplierID = 4758
AND aa.DataSupplierArticleNumber = "42-06388")
OR
(aa.SupplierID = 4758
AND aa.DataSupplierArticleNumber = "42-02655")
OR
(aa.SupplierID = 4758
AND aa.DataSupplierArticleNumber = "42-02652")
OR
(aa.SupplierID = 4758
AND aa.DataSupplierArticleNumber = "42-06389")
OR
(aa.SupplierID = 4758
AND aa.DataSupplierArticleNumber = "42-02658")
OR
(aa.SupplierID = 4758
AND aa.DataSupplierArticleNumber = "42-02653")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "205 219")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "205 218")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8500 24108")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8500 24105")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8500 24125")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8500 24106")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8500 24126")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8500 24107")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "JTE337")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "JTE703")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "JTE728")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "JTE336")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V40-0253")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V40-9503")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V40-0437")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V40-0254")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V40-0438")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V40-0435")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V40-9502")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V40-0436")
OR
(aa.SupplierID = 4425
AND aa.DataSupplierArticleNumber = "16932")
OR
(aa.SupplierID = 4425
AND aa.DataSupplierArticleNumber = "22535")
OR
(aa.SupplierID = 4425
AND aa.DataSupplierArticleNumber = "22533")
OR
(aa.SupplierID = 4425
AND aa.DataSupplierArticleNumber = "22531")
OR
(aa.SupplierID = 4425
AND aa.DataSupplierArticleNumber = "22530")
OR
(aa.SupplierID = 4425
AND aa.DataSupplierArticleNumber = "22532")
OR
(aa.SupplierID = 4425
AND aa.DataSupplierArticleNumber = "16935")
)
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 = 4598
AND aa.DataSupplierArticleNumber = "32422")
OR
(aa.SupplierID = 4598
AND aa.DataSupplierArticleNumber = "32421")
OR
(aa.SupplierID = 4987
AND aa.DataSupplierArticleNumber = "OP-C-22180")
OR
(aa.SupplierID = 4987
AND aa.DataSupplierArticleNumber = "OP-A-55734")
OR
(aa.SupplierID = 4987
AND aa.DataSupplierArticleNumber = "OP-C-20242")
OR
(aa.SupplierID = 4987
AND aa.DataSupplierArticleNumber = "OP-A-20364")
OR
(aa.SupplierID = 4987
AND aa.DataSupplierArticleNumber = "OP-C-22179")
OR
(aa.SupplierID = 4987
AND aa.DataSupplierArticleNumber = "OP-A-20365")
OR
(aa.SupplierID = 206
AND aa.DataSupplierArticleNumber = "230586")
OR
(aa.SupplierID = 206
AND aa.DataSupplierArticleNumber = "230587")
OR
(aa.SupplierID = 206
AND aa.DataSupplierArticleNumber = "230336")
OR
(aa.SupplierID = 206
AND aa.DataSupplierArticleNumber = "230337")
OR
(aa.SupplierID = 4829
AND aa.DataSupplierArticleNumber = "17OP3180")
OR
(aa.SupplierID = 4829
AND aa.DataSupplierArticleNumber = "17OP3179")
OR
(aa.SupplierID = 4829
AND aa.DataSupplierArticleNumber = "17OP3177")
OR
(aa.SupplierID = 4829
AND aa.DataSupplierArticleNumber = "17OP3178")
OR
(aa.SupplierID = 4737
AND aa.DataSupplierArticleNumber = "FT1401")
OR
(aa.SupplierID = 4737
AND aa.DataSupplierArticleNumber = "FT1093")
OR
(aa.SupplierID = 4737
AND aa.DataSupplierArticleNumber = "FT1094")
OR
(aa.SupplierID = 49
AND aa.DataSupplierArticleNumber = "041121B")
OR
(aa.SupplierID = 49
AND aa.DataSupplierArticleNumber = "040662B")
OR
(aa.SupplierID = 49
AND aa.DataSupplierArticleNumber = "040290B")
OR
(aa.SupplierID = 49
AND aa.DataSupplierArticleNumber = "040292B")
OR
(aa.SupplierID = 49
AND aa.DataSupplierArticleNumber = "040661B")
OR
(aa.SupplierID = 208
AND aa.DataSupplierArticleNumber = "TD1419")
OR
(aa.SupplierID = 208
AND aa.DataSupplierArticleNumber = "TS1418")
OR
(aa.SupplierID = 208
AND aa.DataSupplierArticleNumber = "TS1419")
OR
(aa.SupplierID = 208
AND aa.DataSupplierArticleNumber = "TD1418")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BTR4534")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BTR4536")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BTR4528")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BTR4532")
OR
(aa.SupplierID = 4455
AND aa.DataSupplierArticleNumber = "BSG 65-310-049")
OR
(aa.SupplierID = 4455
AND aa.DataSupplierArticleNumber = "BSG 65-310-051")
OR
(aa.SupplierID = 4455
AND aa.DataSupplierArticleNumber = "BSG 65-310-046")
OR
(aa.SupplierID = 4455
AND aa.DataSupplierArticleNumber = "BSG 65-310-047")
OR
(aa.SupplierID = 405
AND aa.DataSupplierArticleNumber = "480522")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "CTR1065")
OR
(aa.SupplierID = 421
AND aa.DataSupplierArticleNumber = "CTR2065")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "TA1208")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "TA1593")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "TA1594")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "TA1206")
OR
(aa.SupplierID = 186
AND aa.DataSupplierArticleNumber = "D130046")
OR
(aa.SupplierID = 186
AND aa.DataSupplierArticleNumber = "D130088")
OR
(aa.SupplierID = 186
AND aa.DataSupplierArticleNumber = "D130111")
OR
(aa.SupplierID = 186
AND aa.DataSupplierArticleNumber = "D130040")
OR
(aa.SupplierID = 253
AND aa.DataSupplierArticleNumber = "1184404")
OR
(aa.SupplierID = 471
AND aa.DataSupplierArticleNumber = "A2-5340")
OR
(aa.SupplierID = 267
AND aa.DataSupplierArticleNumber = "SS6017")
OR
(aa.SupplierID = 267
AND aa.DataSupplierArticleNumber = "SS1185")
OR
(aa.SupplierID = 267
AND aa.DataSupplierArticleNumber = "SS6018")
OR
(aa.SupplierID = 267
AND aa.DataSupplierArticleNumber = "SS507")
OR
(aa.SupplierID = 267
AND aa.DataSupplierArticleNumber = "SS508")
OR
(aa.SupplierID = 267
AND aa.DataSupplierArticleNumber = "SS1184")
OR
(aa.SupplierID = 4834
AND aa.DataSupplierArticleNumber = "RD049")
OR
(aa.SupplierID = 4834
AND aa.DataSupplierArticleNumber = "RD051")
OR
(aa.SupplierID = 4834
AND aa.DataSupplierArticleNumber = "RD046")
OR
(aa.SupplierID = 4834
AND aa.DataSupplierArticleNumber = "RD047")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "01855")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "06192")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "06193")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "01854")
OR
(aa.SupplierID = 407
AND aa.DataSupplierArticleNumber = "FTR4536")
OR
(aa.SupplierID = 407
AND aa.DataSupplierArticleNumber = "FTR4528")
OR
(aa.SupplierID = 407
AND aa.DataSupplierArticleNumber = "FTR4532")
OR
(aa.SupplierID = 407
AND aa.DataSupplierArticleNumber = "FTR4534")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "FL939-B")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "FL257-B")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "FL588-C")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "FL258-B")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "FL927-B")
OR
(aa.SupplierID = 4727
AND aa.DataSupplierArticleNumber = "2001017")
OR
(aa.SupplierID = 4727
AND aa.DataSupplierArticleNumber = "2001014")
OR
(aa.SupplierID = 4727
AND aa.DataSupplierArticleNumber = "2001015")
OR
(aa.SupplierID = 4727
AND aa.DataSupplierArticleNumber = "2001016")
OR
(aa.SupplierID = 4727
AND aa.DataSupplierArticleNumber = "2001011")
OR
(aa.SupplierID = 4467
AND aa.DataSupplierArticleNumber = "FZ1368")
OR
(aa.SupplierID = 4467
AND aa.DataSupplierArticleNumber = "FZ1369")
OR
(aa.SupplierID = 486
AND aa.DataSupplierArticleNumber = "2065")
OR
(aa.SupplierID = 486
AND aa.DataSupplierArticleNumber = "2066")
OR
(aa.SupplierID = 486
AND aa.DataSupplierArticleNumber = "2067")
OR
(aa.SupplierID = 486
AND aa.DataSupplierArticleNumber = "2064")
OR
(aa.SupplierID = 4844
AND aa.DataSupplierArticleNumber = "GSP121005")
OR
(aa.SupplierID = 4844
AND aa.DataSupplierArticleNumber = "GSP701004")
OR
(aa.SupplierID = 4844
AND aa.DataSupplierArticleNumber = "GSP201122")
OR
(aa.SupplierID = 4844
AND aa.DataSupplierArticleNumber = "GSP201055")
OR
(aa.SupplierID = 4844
AND aa.DataSupplierArticleNumber = "GSP121006")
OR
(aa.SupplierID = 4844
AND aa.DataSupplierArticleNumber = "GSP201056")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1244601880")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1244601679")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1244601889")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1244601680")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1244601879")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1244601670")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "999527")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "999631")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "999636")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "999536")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "999526")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "999537")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "4311650")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "4311590")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "4311660")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "4311595")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "4311640")
OR
(aa.SupplierID = 35
AND aa.DataSupplierArticleNumber = "26799 01")
OR
(aa.SupplierID = 35
AND aa.DataSupplierArticleNumber = "14703 01")
OR
(aa.SupplierID = 35
AND aa.DataSupplierArticleNumber = "14704 01")
OR
(aa.SupplierID = 35
AND aa.DataSupplierArticleNumber = "14131 01")
OR
(aa.SupplierID = 35
AND aa.DataSupplierArticleNumber = "26798 01")
OR
(aa.SupplierID = 35
AND aa.DataSupplierArticleNumber = "14599 01")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "C4262L")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "C4262R")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "C4213L")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "C4213R")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "49758")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "49759")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "49600")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "49601")
OR
(aa.SupplierID = 358
AND aa.DataSupplierArticleNumber = "14599-PCS-MS")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "69-0218")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "69-0324")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "69-0325")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "69-0217")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "54001502")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "84001502")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "54001601")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "84001601")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "54004001")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "54004102")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "616 020 5589")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "616 020 5555")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "616 020 5557")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "616 020 5588")
OR
(aa.SupplierID = 37
AND aa.DataSupplierArticleNumber = "L24107")
OR
(aa.SupplierID = 37
AND aa.DataSupplierArticleNumber = "L24108")
OR
(aa.SupplierID = 37
AND aa.DataSupplierArticleNumber = "L24105")
OR
(aa.SupplierID = 37
AND aa.DataSupplierArticleNumber = "L24125")
OR
(aa.SupplierID = 37
AND aa.DataSupplierArticleNumber = "L24106")
OR
(aa.SupplierID = 37
AND aa.DataSupplierArticleNumber = "L24126")
OR
(aa.SupplierID = 134
AND aa.DataSupplierArticleNumber = "OP-ES-5557")
OR
(aa.SupplierID = 134
AND aa.DataSupplierArticleNumber = "OP-ES-5588")
OR
(aa.SupplierID = 134
AND aa.DataSupplierArticleNumber = "OP-ES-5589")
OR
(aa.SupplierID = 134
AND aa.DataSupplierArticleNumber = "OP-ES-5555")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "5033650")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "5033651")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "5033652")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "5033653")
OR
(aa.SupplierID = 198
AND aa.DataSupplierArticleNumber = "0181418")
OR
(aa.SupplierID = 198
AND aa.DataSupplierArticleNumber = "0191418")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "G1-369")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "G1-038")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "G2-699")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "G1-040")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "G1-368")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PS1109R")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PS1116L")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PS1109L")
OR
(aa.SupplierID = 4686
AND aa.DataSupplierArticleNumber = "2302-0284")
OR
(aa.SupplierID = 4686
AND aa.DataSupplierArticleNumber = "2302-0291")
OR
(aa.SupplierID = 4686
AND aa.DataSupplierArticleNumber = "2302-0292")
OR
(aa.SupplierID = 4686
AND aa.DataSupplierArticleNumber = "2302-0282")
OR
(aa.SupplierID = 4368
AND aa.DataSupplierArticleNumber = "TR7496")
OR
(aa.SupplierID = 4368
AND aa.DataSupplierArticleNumber = "TR7502")
OR
(aa.SupplierID = 4368
AND aa.DataSupplierArticleNumber = "TR7526")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QR3027S")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QR3028S")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QR3025S")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QR3026S")
OR
(aa.SupplierID = 4708
AND aa.DataSupplierArticleNumber = "OP2020")
OR
(aa.SupplierID = 4708
AND aa.DataSupplierArticleNumber = "OP2025")
OR
(aa.SupplierID = 4708
AND aa.DataSupplierArticleNumber = "OP2026")
OR
(aa.SupplierID = 4708
AND aa.DataSupplierArticleNumber = "OP2021")
OR
(aa.SupplierID = 4708
AND aa.DataSupplierArticleNumber = "OP2027")
OR
(aa.SupplierID = 4708
AND aa.DataSupplierArticleNumber = "OP2024")
OR
(aa.SupplierID = 430
AND aa.DataSupplierArticleNumber = "91-00340")
OR
(aa.SupplierID = 430
AND aa.DataSupplierArticleNumber = "91-00342")
OR
(aa.SupplierID = 430
AND aa.DataSupplierArticleNumber = "91-00351")
OR
(aa.SupplierID = 430
AND aa.DataSupplierArticleNumber = "91-00353")
OR
(aa.SupplierID = 23
AND aa.DataSupplierArticleNumber = "915365")
OR
(aa.SupplierID = 23
AND aa.DataSupplierArticleNumber = "915362")
OR
(aa.SupplierID = 23
AND aa.DataSupplierArticleNumber = "915363")
OR
(aa.SupplierID = 23
AND aa.DataSupplierArticleNumber = "915364")
OR
(aa.SupplierID = 260
AND aa.DataSupplierArticleNumber = "9006379")
OR
(aa.SupplierID = 260
AND aa.DataSupplierArticleNumber = "9006559")
OR
(aa.SupplierID = 260
AND aa.DataSupplierArticleNumber = "9006560")
OR
(aa.SupplierID = 260
AND aa.DataSupplierArticleNumber = "9006378")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "19065033651")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "19065033652")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "19065033653")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "19065033650")
OR
(aa.SupplierID = 135
AND aa.DataSupplierArticleNumber = "9536")
OR
(aa.SupplierID = 135
AND aa.DataSupplierArticleNumber = "9537")
OR
(aa.SupplierID = 135
AND aa.DataSupplierArticleNumber = "9631")
OR
(aa.SupplierID = 135
AND aa.DataSupplierArticleNumber = "9636")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "51-00280-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "53-01232-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "51-00215A-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "51-05189-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "51-00280A-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "53-01233-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "51-00216-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "51-98001-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "51-00391-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "55-00269-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "51-00216A-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "53-00798-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "51-00215-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "51-00917-SX")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "40 71 0010")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "40 71 0011")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "40 71 0002")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "40 71 0003")
OR
(aa.SupplierID = 4758
AND aa.DataSupplierArticleNumber = "42-02660")
OR
(aa.SupplierID = 4758
AND aa.DataSupplierArticleNumber = "42-02654")
OR
(aa.SupplierID = 4758
AND aa.DataSupplierArticleNumber = "42-06388")
OR
(aa.SupplierID = 4758
AND aa.DataSupplierArticleNumber = "42-02655")
OR
(aa.SupplierID = 4758
AND aa.DataSupplierArticleNumber = "42-02652")
OR
(aa.SupplierID = 4758
AND aa.DataSupplierArticleNumber = "42-06389")
OR
(aa.SupplierID = 4758
AND aa.DataSupplierArticleNumber = "42-02658")
OR
(aa.SupplierID = 4758
AND aa.DataSupplierArticleNumber = "42-02653")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "205 219")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "205 218")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8500 24108")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8500 24105")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8500 24125")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8500 24106")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8500 24126")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8500 24107")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "JTE337")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "JTE703")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "JTE728")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "JTE336")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V40-0253")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V40-9503")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V40-0437")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V40-0254")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V40-0438")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V40-0435")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V40-9502")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V40-0436")
OR
(aa.SupplierID = 4425
AND aa.DataSupplierArticleNumber = "16932")
OR
(aa.SupplierID = 4425
AND aa.DataSupplierArticleNumber = "22535")
OR
(aa.SupplierID = 4425
AND aa.DataSupplierArticleNumber = "22533")
OR
(aa.SupplierID = 4425
AND aa.DataSupplierArticleNumber = "22531")
OR
(aa.SupplierID = 4425
AND aa.DataSupplierArticleNumber = "22530")
OR
(aa.SupplierID = 4425
AND aa.DataSupplierArticleNumber = "22532")
OR
(aa.SupplierID = 4425
AND aa.DataSupplierArticleNumber = "16935")
)
AND aa.Language = "ru"
Продажа автозапчастей типа Шарниры для автомобилей
