#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2MXx8bW9kZWxfaWQ9PTM0NjZ8fG1kZl9pZD09MF4xMzY0N3x8c3BhcmVfaWQ9PTEwMDU3Mg%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 = "50422"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4598
AND av.DataSupplierArticleNumber = "50421"
AND av.ProductID IN (251))
OR
(av.SupplierID = 206
AND av.DataSupplierArticleNumber = "270238"
AND av.ProductID IN (251))
OR
(av.SupplierID = 206
AND av.DataSupplierArticleNumber = "270240"
AND av.ProductID IN (251))
OR
(av.SupplierID = 206
AND av.DataSupplierArticleNumber = "270241"
AND av.ProductID IN (251))
OR
(av.SupplierID = 206
AND av.DataSupplierArticleNumber = "270227"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4943
AND av.DataSupplierArticleNumber = "AW1420401"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4943
AND av.DataSupplierArticleNumber = "AW1420962"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4943
AND av.DataSupplierArticleNumber = "AW1420999"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4995
AND av.DataSupplierArticleNumber = "001-10-20714"
AND av.ProductID IN (251))
OR
(av.SupplierID = 49
AND av.DataSupplierArticleNumber = "045388B"
AND av.ProductID IN (251))
OR
(av.SupplierID = 49
AND av.DataSupplierArticleNumber = "040069B"
AND av.ProductID IN (251))
OR
(av.SupplierID = 49
AND av.DataSupplierArticleNumber = "045345B"
AND av.ProductID IN (251))
OR
(av.SupplierID = 49
AND av.DataSupplierArticleNumber = "045369B"
AND av.ProductID IN (251))
OR
(av.SupplierID = 49
AND av.DataSupplierArticleNumber = "040068B"
AND av.ProductID IN (251))
OR
(av.SupplierID = 208
AND av.DataSupplierArticleNumber = "2281"
AND av.ProductID IN (251))
OR
(av.SupplierID = 208
AND av.DataSupplierArticleNumber = "2282"
AND av.ProductID IN (251))
OR
(av.SupplierID = 208
AND av.DataSupplierArticleNumber = "2347"
AND av.ProductID IN (251))
OR
(av.SupplierID = 14
AND av.DataSupplierArticleNumber = "87-042-A"
AND av.ProductID IN (251))
OR
(av.SupplierID = 14
AND av.DataSupplierArticleNumber = "87-426-A"
AND av.ProductID IN (251))
OR
(av.SupplierID = 14
AND av.DataSupplierArticleNumber = "87-895-A"
AND av.ProductID IN (251))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BSK6226"
AND av.ProductID IN (251))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BSK6227"
AND av.ProductID IN (251))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BSK6003"
AND av.ProductID IN (251))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BSK6004"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4455
AND av.DataSupplierArticleNumber = "BSG 65-700-065"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4455
AND av.DataSupplierArticleNumber = "BSG 65-700-085"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4455
AND av.DataSupplierArticleNumber = "BSG 65-700-086"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4455
AND av.DataSupplierArticleNumber = "BSG 65-700-064"
AND av.ProductID IN (251))
OR
(av.SupplierID = 405
AND av.DataSupplierArticleNumber = "480516"
AND av.ProductID IN (3245))
OR
(av.SupplierID = 405
AND av.DataSupplierArticleNumber = "480517"
AND av.ProductID IN (3245))
OR
(av.SupplierID = 405
AND av.DataSupplierArticleNumber = "480528"
AND av.ProductID IN (3245))
OR
(av.SupplierID = 140
AND av.DataSupplierArticleNumber = "21652930"
AND av.ProductID IN (251))
OR
(av.SupplierID = 140
AND av.DataSupplierArticleNumber = "21652937"
AND av.ProductID IN (251))
OR
(av.SupplierID = 140
AND av.DataSupplierArticleNumber = "21652929"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4880
AND av.DataSupplierArticleNumber = "CBH15007"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4880
AND av.DataSupplierArticleNumber = "CBH15008"
AND av.ProductID IN (251))
OR
(av.SupplierID = 89
AND av.DataSupplierArticleNumber = "TD769W"
AND av.ProductID IN (251))
OR
(av.SupplierID = 89
AND av.DataSupplierArticleNumber = "TD310W"
AND av.ProductID IN (251))
OR
(av.SupplierID = 89
AND av.DataSupplierArticleNumber = "TD311W"
AND av.ProductID IN (251))
OR
(av.SupplierID = 89
AND av.DataSupplierArticleNumber = "TD541W"
AND av.ProductID IN (251))
OR
(av.SupplierID = 186
AND av.DataSupplierArticleNumber = "D300055"
AND av.ProductID IN (251))
OR
(av.SupplierID = 186
AND av.DataSupplierArticleNumber = "D300056"
AND av.ProductID IN (251))
OR
(av.SupplierID = 253
AND av.DataSupplierArticleNumber = "1184402"
AND av.ProductID IN (251))
OR
(av.SupplierID = 267
AND av.DataSupplierArticleNumber = "SS4341"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4834
AND av.DataSupplierArticleNumber = "2854"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4834
AND av.DataSupplierArticleNumber = "2847"
AND av.ProductID IN (251))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "04402"
AND av.ProductID IN (251))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "02183"
AND av.ProductID IN (251))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "02263"
AND av.ProductID IN (251))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "04390"
AND av.ProductID IN (251))
OR
(av.SupplierID = 407
AND av.DataSupplierArticleNumber = "FSK6226"
AND av.ProductID IN (251))
OR
(av.SupplierID = 407
AND av.DataSupplierArticleNumber = "FSK6227"
AND av.ProductID IN (251))
OR
(av.SupplierID = 407
AND av.DataSupplierArticleNumber = "FSK6003"
AND av.ProductID IN (251))
OR
(av.SupplierID = 407
AND av.DataSupplierArticleNumber = "FSK6004"
AND av.ProductID IN (251))
OR
(av.SupplierID = 236
AND av.DataSupplierArticleNumber = "FL3988-J"
AND av.ProductID IN (251))
OR
(av.SupplierID = 236
AND av.DataSupplierArticleNumber = "FL4097-J"
AND av.ProductID IN (251))
OR
(av.SupplierID = 236
AND av.DataSupplierArticleNumber = "FL4098-J"
AND av.ProductID IN (251))
OR
(av.SupplierID = 236
AND av.DataSupplierArticleNumber = "FL4226-J"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4727
AND av.DataSupplierArticleNumber = "2000012"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4727
AND av.DataSupplierArticleNumber = "2000013"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4467
AND av.DataSupplierArticleNumber = "FZ9442"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4467
AND av.DataSupplierArticleNumber = "FZ9444"
AND av.ProductID IN (251))
OR
(av.SupplierID = 373
AND av.DataSupplierArticleNumber = "510904"
AND av.ProductID IN (251))
OR
(av.SupplierID = 373
AND av.DataSupplierArticleNumber = "512462"
AND av.ProductID IN (251))
OR
(av.SupplierID = 373
AND av.DataSupplierArticleNumber = "510842"
AND av.ProductID IN (3245))
OR
(av.SupplierID = 239
AND av.DataSupplierArticleNumber = "590037"
AND av.ProductID IN (251))
OR
(av.SupplierID = 239
AND av.DataSupplierArticleNumber = "590047"
AND av.ProductID IN (251))
OR
(av.SupplierID = 239
AND av.DataSupplierArticleNumber = "590097"
AND av.ProductID IN (251))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1250300900"
AND av.ProductID IN (251))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1240201600"
AND av.ProductID IN (251))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1250300909"
AND av.ProductID IN (251))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1240201609"
AND av.ProductID IN (251))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1240202209"
AND av.ProductID IN (251))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "1240201500"
AND av.ProductID IN (251))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "8800267"
AND av.ProductID IN (251))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "8800086"
AND av.ProductID IN (251))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "8800087"
AND av.ProductID IN (251))
OR
(av.SupplierID = 185
AND av.DataSupplierArticleNumber = "8800266"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "4231680"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "4231685"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "4231586"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "4231588"
AND av.ProductID IN (251))
OR
(av.SupplierID = 35
AND av.DataSupplierArticleNumber = "22116 01"
AND av.ProductID IN (251))
OR
(av.SupplierID = 35
AND av.DataSupplierArticleNumber = "26096 01"
AND av.ProductID IN (251))
OR
(av.SupplierID = 35
AND av.DataSupplierArticleNumber = "21776 02"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4600
AND av.DataSupplierArticleNumber = "C8544"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4600
AND av.DataSupplierArticleNumber = "C8545"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4600
AND av.DataSupplierArticleNumber = "C8541"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4600
AND av.DataSupplierArticleNumber = "C8543"
AND av.ProductID IN (251))
OR
(av.SupplierID = 317
AND av.DataSupplierArticleNumber = "237921"
AND av.ProductID IN (251))
OR
(av.SupplierID = 317
AND av.DataSupplierArticleNumber = "237931"
AND av.ProductID IN (251))
OR
(av.SupplierID = 133
AND av.DataSupplierArticleNumber = "33895"
AND av.ProductID IN (251))
OR
(av.SupplierID = 133
AND av.DataSupplierArticleNumber = "33848"
AND av.ProductID IN (251))
OR
(av.SupplierID = 133
AND av.DataSupplierArticleNumber = "33849"
AND av.ProductID IN (251))
OR
(av.SupplierID = 358
AND av.DataSupplierArticleNumber = "16063-PCS-MS"
AND av.ProductID IN (251))
OR
(av.SupplierID = 358
AND av.DataSupplierArticleNumber = "21776-PCS-MS"
AND av.ProductID IN (251))
OR
(av.SupplierID = 403
AND av.DataSupplierArticleNumber = "72-1250"
AND av.ProductID IN (251))
OR
(av.SupplierID = 403
AND av.DataSupplierArticleNumber = "72-1176"
AND av.ProductID IN (251))
OR
(av.SupplierID = 94
AND av.DataSupplierArticleNumber = "52001708"
AND av.ProductID IN (251))
OR
(av.SupplierID = 94
AND av.DataSupplierArticleNumber = "52001808"
AND av.ProductID IN (251))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "614 042 0003"
AND av.ProductID IN (3245))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "614 042 0004"
AND av.ProductID IN (3245))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "614 035 0010"
AND av.ProductID IN (3245))
OR
(av.SupplierID = 144
AND av.DataSupplierArticleNumber = "614 035 0016"
AND av.ProductID IN (3245))
OR
(av.SupplierID = 37
AND av.DataSupplierArticleNumber = "L24818"
AND av.ProductID IN (251))
OR
(av.SupplierID = 37
AND av.DataSupplierArticleNumber = "L24823"
AND av.ProductID IN (251))
OR
(av.SupplierID = 37
AND av.DataSupplierArticleNumber = "L24817"
AND av.ProductID IN (251))
OR
(av.SupplierID = 134
AND av.DataSupplierArticleNumber = "OP-SB-3779"
AND av.ProductID IN (251))
OR
(av.SupplierID = 134
AND av.DataSupplierArticleNumber = "OP-SB-3813"
AND av.ProductID IN (251))
OR
(av.SupplierID = 134
AND av.DataSupplierArticleNumber = "OP-SB-1380"
AND av.ProductID IN (251))
OR
(av.SupplierID = 134
AND av.DataSupplierArticleNumber = "OP-SB-1382"
AND av.ProductID IN (251))
OR
(av.SupplierID = 127
AND av.DataSupplierArticleNumber = "5103615"
AND av.ProductID IN (251))
OR
(av.SupplierID = 127
AND av.DataSupplierArticleNumber = "5103616"
AND av.ProductID IN (251))
OR
(av.SupplierID = 198
AND av.DataSupplierArticleNumber = "1215522"
AND av.ProductID IN (251))
OR
(av.SupplierID = 198
AND av.DataSupplierArticleNumber = "1215523"
AND av.ProductID IN (251))
OR
(av.SupplierID = 129
AND av.DataSupplierArticleNumber = "F8-5722"
AND av.ProductID IN (251))
OR
(av.SupplierID = 129
AND av.DataSupplierArticleNumber = "F8-5108"
AND av.ProductID IN (251))
OR
(av.SupplierID = 129
AND av.DataSupplierArticleNumber = "F8-5109"
AND av.ProductID IN (251))
OR
(av.SupplierID = 129
AND av.DataSupplierArticleNumber = "F8-5337"
AND av.ProductID IN (251))
OR
(av.SupplierID = 129
AND av.DataSupplierArticleNumber = "F8-4099"
AND av.ProductID IN (251))
OR
(av.SupplierID = 331
AND av.DataSupplierArticleNumber = "1840"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4558
AND av.DataSupplierArticleNumber = "PSE1082"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4686
AND av.DataSupplierArticleNumber = "2307-0072"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4686
AND av.DataSupplierArticleNumber = "2307-0204"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4686
AND av.DataSupplierArticleNumber = "2307-0236"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4686
AND av.DataSupplierArticleNumber = "2307-0067"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4368
AND av.DataSupplierArticleNumber = "SB7501"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4368
AND av.DataSupplierArticleNumber = "SB7452"
AND av.ProductID IN (251))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "EMS1988"
AND av.ProductID IN (251))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "EMS8033"
AND av.ProductID IN (251))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "EMS8127"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4708
AND av.DataSupplierArticleNumber = "OP11011"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4708
AND av.DataSupplierArticleNumber = "OP11010"
AND av.ProductID IN (251))
OR
(av.SupplierID = 23
AND av.DataSupplierArticleNumber = "985329"
AND av.ProductID IN (251))
OR
(av.SupplierID = 23
AND av.DataSupplierArticleNumber = "985357"
AND av.ProductID IN (251))
OR
(av.SupplierID = 23
AND av.DataSupplierArticleNumber = "985335"
AND av.ProductID IN (251))
OR
(av.SupplierID = 23
AND av.DataSupplierArticleNumber = "985360"
AND av.ProductID IN (251))
OR
(av.SupplierID = 23
AND av.DataSupplierArticleNumber = "985353"
AND av.ProductID IN (251))
OR
(av.SupplierID = 23
AND av.DataSupplierArticleNumber = "985356"
AND av.ProductID IN (251))
OR
(av.SupplierID = 297
AND av.DataSupplierArticleNumber = "19125103616"
AND av.ProductID IN (251))
OR
(av.SupplierID = 297
AND av.DataSupplierArticleNumber = "19125103615"
AND av.ProductID IN (251))
OR
(av.SupplierID = 135
AND av.DataSupplierArticleNumber = "809624"
AND av.ProductID IN (251))
OR
(av.SupplierID = 135
AND av.DataSupplierArticleNumber = "809625"
AND av.ProductID IN (251))
OR
(av.SupplierID = 135
AND av.DataSupplierArticleNumber = "809626"
AND av.ProductID IN (251))
OR
(av.SupplierID = 135
AND av.DataSupplierArticleNumber = "809622"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "74-21742-SX"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4595
AND av.DataSupplierArticleNumber = "74-22025-SX"
AND av.ProductID IN (251))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "40 60 0014"
AND av.ProductID IN (251))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "40 79 0011"
AND av.ProductID IN (251))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "40 79 0012"
AND av.ProductID IN (251))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "40 60 0009"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4758
AND av.DataSupplierArticleNumber = "57-05768"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4758
AND av.DataSupplierArticleNumber = "57-00403"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4758
AND av.DataSupplierArticleNumber = "57-06495"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4758
AND av.DataSupplierArticleNumber = "57-02633"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4758
AND av.DataSupplierArticleNumber = "57-02634"
AND av.ProductID IN (251))
OR
(av.SupplierID = 301
AND av.DataSupplierArticleNumber = "200 769"
AND av.ProductID IN (251))
OR
(av.SupplierID = 301
AND av.DataSupplierArticleNumber = "200 502"
AND av.ProductID IN (251))
OR
(av.SupplierID = 301
AND av.DataSupplierArticleNumber = "200 503"
AND av.ProductID IN (251))
OR
(av.SupplierID = 301
AND av.DataSupplierArticleNumber = "200 768"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4970
AND av.DataSupplierArticleNumber = "781101"
AND av.ProductID IN (251))
OR
(av.SupplierID = 108
AND av.DataSupplierArticleNumber = "8500 24823"
AND av.ProductID IN (251))
OR
(av.SupplierID = 108
AND av.DataSupplierArticleNumber = "8500 24817"
AND av.ProductID IN (251))
OR
(av.SupplierID = 108
AND av.DataSupplierArticleNumber = "8500 24818"
AND av.ProductID IN (251))
OR
(av.SupplierID = 161
AND av.DataSupplierArticleNumber = "JBU254"
AND av.ProductID IN (251))
OR
(av.SupplierID = 161
AND av.DataSupplierArticleNumber = "JBU380"
AND av.ProductID IN (251))
OR
(av.SupplierID = 161
AND av.DataSupplierArticleNumber = "JBU546"
AND av.ProductID IN (251))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V40-1303"
AND av.ProductID IN (251))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V40-0321"
AND av.ProductID IN (251))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V40-0322"
AND av.ProductID IN (251))
OR
(av.SupplierID = 162
AND av.DataSupplierArticleNumber = "V40-1279"
AND av.ProductID IN (251))
OR
(av.SupplierID = 4425
AND av.DataSupplierArticleNumber = "20858"
AND av.ProductID IN (251,251))
OR
(av.SupplierID = 4425
AND av.DataSupplierArticleNumber = "20857"
AND av.ProductID IN (251,251))
)
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 = "50422")
OR
(aa.SupplierID = 4598
AND aa.DataSupplierArticleNumber = "50421")
OR
(aa.SupplierID = 206
AND aa.DataSupplierArticleNumber = "270238")
OR
(aa.SupplierID = 206
AND aa.DataSupplierArticleNumber = "270240")
OR
(aa.SupplierID = 206
AND aa.DataSupplierArticleNumber = "270241")
OR
(aa.SupplierID = 206
AND aa.DataSupplierArticleNumber = "270227")
OR
(aa.SupplierID = 4943
AND aa.DataSupplierArticleNumber = "AW1420401")
OR
(aa.SupplierID = 4943
AND aa.DataSupplierArticleNumber = "AW1420962")
OR
(aa.SupplierID = 4943
AND aa.DataSupplierArticleNumber = "AW1420999")
OR
(aa.SupplierID = 4995
AND aa.DataSupplierArticleNumber = "001-10-20714")
OR
(aa.SupplierID = 49
AND aa.DataSupplierArticleNumber = "045388B")
OR
(aa.SupplierID = 49
AND aa.DataSupplierArticleNumber = "040069B")
OR
(aa.SupplierID = 49
AND aa.DataSupplierArticleNumber = "045345B")
OR
(aa.SupplierID = 49
AND aa.DataSupplierArticleNumber = "045369B")
OR
(aa.SupplierID = 49
AND aa.DataSupplierArticleNumber = "040068B")
OR
(aa.SupplierID = 208
AND aa.DataSupplierArticleNumber = "2281")
OR
(aa.SupplierID = 208
AND aa.DataSupplierArticleNumber = "2282")
OR
(aa.SupplierID = 208
AND aa.DataSupplierArticleNumber = "2347")
OR
(aa.SupplierID = 14
AND aa.DataSupplierArticleNumber = "87-042-A")
OR
(aa.SupplierID = 14
AND aa.DataSupplierArticleNumber = "87-426-A")
OR
(aa.SupplierID = 14
AND aa.DataSupplierArticleNumber = "87-895-A")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BSK6226")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BSK6227")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BSK6003")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BSK6004")
OR
(aa.SupplierID = 4455
AND aa.DataSupplierArticleNumber = "BSG 65-700-065")
OR
(aa.SupplierID = 4455
AND aa.DataSupplierArticleNumber = "BSG 65-700-085")
OR
(aa.SupplierID = 4455
AND aa.DataSupplierArticleNumber = "BSG 65-700-086")
OR
(aa.SupplierID = 4455
AND aa.DataSupplierArticleNumber = "BSG 65-700-064")
OR
(aa.SupplierID = 405
AND aa.DataSupplierArticleNumber = "480516")
OR
(aa.SupplierID = 405
AND aa.DataSupplierArticleNumber = "480517")
OR
(aa.SupplierID = 405
AND aa.DataSupplierArticleNumber = "480528")
OR
(aa.SupplierID = 140
AND aa.DataSupplierArticleNumber = "21652930")
OR
(aa.SupplierID = 140
AND aa.DataSupplierArticleNumber = "21652937")
OR
(aa.SupplierID = 140
AND aa.DataSupplierArticleNumber = "21652929")
OR
(aa.SupplierID = 4880
AND aa.DataSupplierArticleNumber = "CBH15007")
OR
(aa.SupplierID = 4880
AND aa.DataSupplierArticleNumber = "CBH15008")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "TD769W")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "TD310W")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "TD311W")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "TD541W")
OR
(aa.SupplierID = 186
AND aa.DataSupplierArticleNumber = "D300055")
OR
(aa.SupplierID = 186
AND aa.DataSupplierArticleNumber = "D300056")
OR
(aa.SupplierID = 253
AND aa.DataSupplierArticleNumber = "1184402")
OR
(aa.SupplierID = 267
AND aa.DataSupplierArticleNumber = "SS4341")
OR
(aa.SupplierID = 4834
AND aa.DataSupplierArticleNumber = "2854")
OR
(aa.SupplierID = 4834
AND aa.DataSupplierArticleNumber = "2847")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "04402")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "02183")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "02263")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "04390")
OR
(aa.SupplierID = 407
AND aa.DataSupplierArticleNumber = "FSK6226")
OR
(aa.SupplierID = 407
AND aa.DataSupplierArticleNumber = "FSK6227")
OR
(aa.SupplierID = 407
AND aa.DataSupplierArticleNumber = "FSK6003")
OR
(aa.SupplierID = 407
AND aa.DataSupplierArticleNumber = "FSK6004")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "FL3988-J")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "FL4097-J")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "FL4098-J")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "FL4226-J")
OR
(aa.SupplierID = 4727
AND aa.DataSupplierArticleNumber = "2000012")
OR
(aa.SupplierID = 4727
AND aa.DataSupplierArticleNumber = "2000013")
OR
(aa.SupplierID = 4467
AND aa.DataSupplierArticleNumber = "FZ9442")
OR
(aa.SupplierID = 4467
AND aa.DataSupplierArticleNumber = "FZ9444")
OR
(aa.SupplierID = 373
AND aa.DataSupplierArticleNumber = "510904")
OR
(aa.SupplierID = 373
AND aa.DataSupplierArticleNumber = "512462")
OR
(aa.SupplierID = 373
AND aa.DataSupplierArticleNumber = "510842")
OR
(aa.SupplierID = 239
AND aa.DataSupplierArticleNumber = "590037")
OR
(aa.SupplierID = 239
AND aa.DataSupplierArticleNumber = "590047")
OR
(aa.SupplierID = 239
AND aa.DataSupplierArticleNumber = "590097")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1250300900")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1240201600")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1250300909")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1240201609")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1240202209")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1240201500")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "8800267")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "8800086")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "8800087")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "8800266")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "4231680")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "4231685")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "4231586")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "4231588")
OR
(aa.SupplierID = 35
AND aa.DataSupplierArticleNumber = "22116 01")
OR
(aa.SupplierID = 35
AND aa.DataSupplierArticleNumber = "26096 01")
OR
(aa.SupplierID = 35
AND aa.DataSupplierArticleNumber = "21776 02")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "C8544")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "C8545")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "C8541")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "C8543")
OR
(aa.SupplierID = 317
AND aa.DataSupplierArticleNumber = "237921")
OR
(aa.SupplierID = 317
AND aa.DataSupplierArticleNumber = "237931")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "33895")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "33848")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "33849")
OR
(aa.SupplierID = 358
AND aa.DataSupplierArticleNumber = "16063-PCS-MS")
OR
(aa.SupplierID = 358
AND aa.DataSupplierArticleNumber = "21776-PCS-MS")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "72-1250")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "72-1176")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "52001708")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "52001808")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "614 042 0003")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "614 042 0004")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "614 035 0010")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "614 035 0016")
OR
(aa.SupplierID = 37
AND aa.DataSupplierArticleNumber = "L24818")
OR
(aa.SupplierID = 37
AND aa.DataSupplierArticleNumber = "L24823")
OR
(aa.SupplierID = 37
AND aa.DataSupplierArticleNumber = "L24817")
OR
(aa.SupplierID = 134
AND aa.DataSupplierArticleNumber = "OP-SB-3779")
OR
(aa.SupplierID = 134
AND aa.DataSupplierArticleNumber = "OP-SB-3813")
OR
(aa.SupplierID = 134
AND aa.DataSupplierArticleNumber = "OP-SB-1380")
OR
(aa.SupplierID = 134
AND aa.DataSupplierArticleNumber = "OP-SB-1382")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "5103615")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "5103616")
OR
(aa.SupplierID = 198
AND aa.DataSupplierArticleNumber = "1215522")
OR
(aa.SupplierID = 198
AND aa.DataSupplierArticleNumber = "1215523")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "F8-5722")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "F8-5108")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "F8-5109")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "F8-5337")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "F8-4099")
OR
(aa.SupplierID = 331
AND aa.DataSupplierArticleNumber = "1840")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PSE1082")
OR
(aa.SupplierID = 4686
AND aa.DataSupplierArticleNumber = "2307-0072")
OR
(aa.SupplierID = 4686
AND aa.DataSupplierArticleNumber = "2307-0204")
OR
(aa.SupplierID = 4686
AND aa.DataSupplierArticleNumber = "2307-0236")
OR
(aa.SupplierID = 4686
AND aa.DataSupplierArticleNumber = "2307-0067")
OR
(aa.SupplierID = 4368
AND aa.DataSupplierArticleNumber = "SB7501")
OR
(aa.SupplierID = 4368
AND aa.DataSupplierArticleNumber = "SB7452")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "EMS1988")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "EMS8033")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "EMS8127")
OR
(aa.SupplierID = 4708
AND aa.DataSupplierArticleNumber = "OP11011")
OR
(aa.SupplierID = 4708
AND aa.DataSupplierArticleNumber = "OP11010")
OR
(aa.SupplierID = 23
AND aa.DataSupplierArticleNumber = "985329")
OR
(aa.SupplierID = 23
AND aa.DataSupplierArticleNumber = "985357")
OR
(aa.SupplierID = 23
AND aa.DataSupplierArticleNumber = "985335")
OR
(aa.SupplierID = 23
AND aa.DataSupplierArticleNumber = "985360")
OR
(aa.SupplierID = 23
AND aa.DataSupplierArticleNumber = "985353")
OR
(aa.SupplierID = 23
AND aa.DataSupplierArticleNumber = "985356")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "19125103616")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "19125103615")
OR
(aa.SupplierID = 135
AND aa.DataSupplierArticleNumber = "809624")
OR
(aa.SupplierID = 135
AND aa.DataSupplierArticleNumber = "809625")
OR
(aa.SupplierID = 135
AND aa.DataSupplierArticleNumber = "809626")
OR
(aa.SupplierID = 135
AND aa.DataSupplierArticleNumber = "809622")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "74-21742-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "74-22025-SX")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "40 60 0014")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "40 79 0011")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "40 79 0012")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "40 60 0009")
OR
(aa.SupplierID = 4758
AND aa.DataSupplierArticleNumber = "57-05768")
OR
(aa.SupplierID = 4758
AND aa.DataSupplierArticleNumber = "57-00403")
OR
(aa.SupplierID = 4758
AND aa.DataSupplierArticleNumber = "57-06495")
OR
(aa.SupplierID = 4758
AND aa.DataSupplierArticleNumber = "57-02633")
OR
(aa.SupplierID = 4758
AND aa.DataSupplierArticleNumber = "57-02634")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "200 769")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "200 502")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "200 503")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "200 768")
OR
(aa.SupplierID = 4970
AND aa.DataSupplierArticleNumber = "781101")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8500 24823")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8500 24817")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8500 24818")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "JBU254")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "JBU380")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "JBU546")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V40-1303")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V40-0321")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V40-0322")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V40-1279")
OR
(aa.SupplierID = 4425
AND aa.DataSupplierArticleNumber = "20858")
OR
(aa.SupplierID = 4425
AND aa.DataSupplierArticleNumber = "20857")
)
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 = "50422")
OR
(aa.SupplierID = 4598
AND aa.DataSupplierArticleNumber = "50421")
OR
(aa.SupplierID = 206
AND aa.DataSupplierArticleNumber = "270238")
OR
(aa.SupplierID = 206
AND aa.DataSupplierArticleNumber = "270240")
OR
(aa.SupplierID = 206
AND aa.DataSupplierArticleNumber = "270241")
OR
(aa.SupplierID = 206
AND aa.DataSupplierArticleNumber = "270227")
OR
(aa.SupplierID = 4943
AND aa.DataSupplierArticleNumber = "AW1420401")
OR
(aa.SupplierID = 4943
AND aa.DataSupplierArticleNumber = "AW1420962")
OR
(aa.SupplierID = 4943
AND aa.DataSupplierArticleNumber = "AW1420999")
OR
(aa.SupplierID = 4995
AND aa.DataSupplierArticleNumber = "001-10-20714")
OR
(aa.SupplierID = 49
AND aa.DataSupplierArticleNumber = "045388B")
OR
(aa.SupplierID = 49
AND aa.DataSupplierArticleNumber = "040069B")
OR
(aa.SupplierID = 49
AND aa.DataSupplierArticleNumber = "045345B")
OR
(aa.SupplierID = 49
AND aa.DataSupplierArticleNumber = "045369B")
OR
(aa.SupplierID = 49
AND aa.DataSupplierArticleNumber = "040068B")
OR
(aa.SupplierID = 208
AND aa.DataSupplierArticleNumber = "2281")
OR
(aa.SupplierID = 208
AND aa.DataSupplierArticleNumber = "2282")
OR
(aa.SupplierID = 208
AND aa.DataSupplierArticleNumber = "2347")
OR
(aa.SupplierID = 14
AND aa.DataSupplierArticleNumber = "87-042-A")
OR
(aa.SupplierID = 14
AND aa.DataSupplierArticleNumber = "87-426-A")
OR
(aa.SupplierID = 14
AND aa.DataSupplierArticleNumber = "87-895-A")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BSK6226")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BSK6227")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BSK6003")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BSK6004")
OR
(aa.SupplierID = 4455
AND aa.DataSupplierArticleNumber = "BSG 65-700-065")
OR
(aa.SupplierID = 4455
AND aa.DataSupplierArticleNumber = "BSG 65-700-085")
OR
(aa.SupplierID = 4455
AND aa.DataSupplierArticleNumber = "BSG 65-700-086")
OR
(aa.SupplierID = 4455
AND aa.DataSupplierArticleNumber = "BSG 65-700-064")
OR
(aa.SupplierID = 405
AND aa.DataSupplierArticleNumber = "480516")
OR
(aa.SupplierID = 405
AND aa.DataSupplierArticleNumber = "480517")
OR
(aa.SupplierID = 405
AND aa.DataSupplierArticleNumber = "480528")
OR
(aa.SupplierID = 140
AND aa.DataSupplierArticleNumber = "21652930")
OR
(aa.SupplierID = 140
AND aa.DataSupplierArticleNumber = "21652937")
OR
(aa.SupplierID = 140
AND aa.DataSupplierArticleNumber = "21652929")
OR
(aa.SupplierID = 4880
AND aa.DataSupplierArticleNumber = "CBH15007")
OR
(aa.SupplierID = 4880
AND aa.DataSupplierArticleNumber = "CBH15008")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "TD769W")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "TD310W")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "TD311W")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "TD541W")
OR
(aa.SupplierID = 186
AND aa.DataSupplierArticleNumber = "D300055")
OR
(aa.SupplierID = 186
AND aa.DataSupplierArticleNumber = "D300056")
OR
(aa.SupplierID = 253
AND aa.DataSupplierArticleNumber = "1184402")
OR
(aa.SupplierID = 267
AND aa.DataSupplierArticleNumber = "SS4341")
OR
(aa.SupplierID = 4834
AND aa.DataSupplierArticleNumber = "2854")
OR
(aa.SupplierID = 4834
AND aa.DataSupplierArticleNumber = "2847")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "04402")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "02183")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "02263")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "04390")
OR
(aa.SupplierID = 407
AND aa.DataSupplierArticleNumber = "FSK6226")
OR
(aa.SupplierID = 407
AND aa.DataSupplierArticleNumber = "FSK6227")
OR
(aa.SupplierID = 407
AND aa.DataSupplierArticleNumber = "FSK6003")
OR
(aa.SupplierID = 407
AND aa.DataSupplierArticleNumber = "FSK6004")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "FL3988-J")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "FL4097-J")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "FL4098-J")
OR
(aa.SupplierID = 236
AND aa.DataSupplierArticleNumber = "FL4226-J")
OR
(aa.SupplierID = 4727
AND aa.DataSupplierArticleNumber = "2000012")
OR
(aa.SupplierID = 4727
AND aa.DataSupplierArticleNumber = "2000013")
OR
(aa.SupplierID = 4467
AND aa.DataSupplierArticleNumber = "FZ9442")
OR
(aa.SupplierID = 4467
AND aa.DataSupplierArticleNumber = "FZ9444")
OR
(aa.SupplierID = 373
AND aa.DataSupplierArticleNumber = "510904")
OR
(aa.SupplierID = 373
AND aa.DataSupplierArticleNumber = "512462")
OR
(aa.SupplierID = 373
AND aa.DataSupplierArticleNumber = "510842")
OR
(aa.SupplierID = 239
AND aa.DataSupplierArticleNumber = "590037")
OR
(aa.SupplierID = 239
AND aa.DataSupplierArticleNumber = "590047")
OR
(aa.SupplierID = 239
AND aa.DataSupplierArticleNumber = "590097")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1250300900")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1240201600")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1250300909")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1240201609")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1240202209")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "1240201500")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "8800267")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "8800086")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "8800087")
OR
(aa.SupplierID = 185
AND aa.DataSupplierArticleNumber = "8800266")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "4231680")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "4231685")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "4231586")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "4231588")
OR
(aa.SupplierID = 35
AND aa.DataSupplierArticleNumber = "22116 01")
OR
(aa.SupplierID = 35
AND aa.DataSupplierArticleNumber = "26096 01")
OR
(aa.SupplierID = 35
AND aa.DataSupplierArticleNumber = "21776 02")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "C8544")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "C8545")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "C8541")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "C8543")
OR
(aa.SupplierID = 317
AND aa.DataSupplierArticleNumber = "237921")
OR
(aa.SupplierID = 317
AND aa.DataSupplierArticleNumber = "237931")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "33895")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "33848")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "33849")
OR
(aa.SupplierID = 358
AND aa.DataSupplierArticleNumber = "16063-PCS-MS")
OR
(aa.SupplierID = 358
AND aa.DataSupplierArticleNumber = "21776-PCS-MS")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "72-1250")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "72-1176")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "52001708")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "52001808")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "614 042 0003")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "614 042 0004")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "614 035 0010")
OR
(aa.SupplierID = 144
AND aa.DataSupplierArticleNumber = "614 035 0016")
OR
(aa.SupplierID = 37
AND aa.DataSupplierArticleNumber = "L24818")
OR
(aa.SupplierID = 37
AND aa.DataSupplierArticleNumber = "L24823")
OR
(aa.SupplierID = 37
AND aa.DataSupplierArticleNumber = "L24817")
OR
(aa.SupplierID = 134
AND aa.DataSupplierArticleNumber = "OP-SB-3779")
OR
(aa.SupplierID = 134
AND aa.DataSupplierArticleNumber = "OP-SB-3813")
OR
(aa.SupplierID = 134
AND aa.DataSupplierArticleNumber = "OP-SB-1380")
OR
(aa.SupplierID = 134
AND aa.DataSupplierArticleNumber = "OP-SB-1382")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "5103615")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "5103616")
OR
(aa.SupplierID = 198
AND aa.DataSupplierArticleNumber = "1215522")
OR
(aa.SupplierID = 198
AND aa.DataSupplierArticleNumber = "1215523")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "F8-5722")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "F8-5108")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "F8-5109")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "F8-5337")
OR
(aa.SupplierID = 129
AND aa.DataSupplierArticleNumber = "F8-4099")
OR
(aa.SupplierID = 331
AND aa.DataSupplierArticleNumber = "1840")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PSE1082")
OR
(aa.SupplierID = 4686
AND aa.DataSupplierArticleNumber = "2307-0072")
OR
(aa.SupplierID = 4686
AND aa.DataSupplierArticleNumber = "2307-0204")
OR
(aa.SupplierID = 4686
AND aa.DataSupplierArticleNumber = "2307-0236")
OR
(aa.SupplierID = 4686
AND aa.DataSupplierArticleNumber = "2307-0067")
OR
(aa.SupplierID = 4368
AND aa.DataSupplierArticleNumber = "SB7501")
OR
(aa.SupplierID = 4368
AND aa.DataSupplierArticleNumber = "SB7452")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "EMS1988")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "EMS8033")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "EMS8127")
OR
(aa.SupplierID = 4708
AND aa.DataSupplierArticleNumber = "OP11011")
OR
(aa.SupplierID = 4708
AND aa.DataSupplierArticleNumber = "OP11010")
OR
(aa.SupplierID = 23
AND aa.DataSupplierArticleNumber = "985329")
OR
(aa.SupplierID = 23
AND aa.DataSupplierArticleNumber = "985357")
OR
(aa.SupplierID = 23
AND aa.DataSupplierArticleNumber = "985335")
OR
(aa.SupplierID = 23
AND aa.DataSupplierArticleNumber = "985360")
OR
(aa.SupplierID = 23
AND aa.DataSupplierArticleNumber = "985353")
OR
(aa.SupplierID = 23
AND aa.DataSupplierArticleNumber = "985356")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "19125103616")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "19125103615")
OR
(aa.SupplierID = 135
AND aa.DataSupplierArticleNumber = "809624")
OR
(aa.SupplierID = 135
AND aa.DataSupplierArticleNumber = "809625")
OR
(aa.SupplierID = 135
AND aa.DataSupplierArticleNumber = "809626")
OR
(aa.SupplierID = 135
AND aa.DataSupplierArticleNumber = "809622")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "74-21742-SX")
OR
(aa.SupplierID = 4595
AND aa.DataSupplierArticleNumber = "74-22025-SX")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "40 60 0014")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "40 79 0011")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "40 79 0012")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "40 60 0009")
OR
(aa.SupplierID = 4758
AND aa.DataSupplierArticleNumber = "57-05768")
OR
(aa.SupplierID = 4758
AND aa.DataSupplierArticleNumber = "57-00403")
OR
(aa.SupplierID = 4758
AND aa.DataSupplierArticleNumber = "57-06495")
OR
(aa.SupplierID = 4758
AND aa.DataSupplierArticleNumber = "57-02633")
OR
(aa.SupplierID = 4758
AND aa.DataSupplierArticleNumber = "57-02634")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "200 769")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "200 502")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "200 503")
OR
(aa.SupplierID = 301
AND aa.DataSupplierArticleNumber = "200 768")
OR
(aa.SupplierID = 4970
AND aa.DataSupplierArticleNumber = "781101")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8500 24823")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8500 24817")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8500 24818")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "JBU254")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "JBU380")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "JBU546")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V40-1303")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V40-0321")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V40-0322")
OR
(aa.SupplierID = 162
AND aa.DataSupplierArticleNumber = "V40-1279")
OR
(aa.SupplierID = 4425
AND aa.DataSupplierArticleNumber = "20858")
OR
(aa.SupplierID = 4425
AND aa.DataSupplierArticleNumber = "20857")
)
AND aa.Language = "ru"
Продажа автозапчастей типа Подвеска / крепление ходовой части для автомобилей
