#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTM1NTh8fG1kZl9pZD09MF45NTAyfHxzcGFyZV9pZD09MTAwODA3&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 = "9502"
AND (
(av.SupplierID = 206
AND av.DataSupplierArticleNumber = "43659"
AND av.ProductID IN (405))
OR
(av.SupplierID = 206
AND av.DataSupplierArticleNumber = "422441"
AND av.ProductID IN (78))
OR
(av.SupplierID = 206
AND av.DataSupplierArticleNumber = "422442"
AND av.ProductID IN (78))
OR
(av.SupplierID = 206
AND av.DataSupplierArticleNumber = "422401"
AND av.ProductID IN (78))
OR
(av.SupplierID = 206
AND av.DataSupplierArticleNumber = "43061"
AND av.ProductID IN (405))
OR
(av.SupplierID = 206
AND av.DataSupplierArticleNumber = "422402"
AND av.ProductID IN (78))
OR
(av.SupplierID = 4534
AND av.DataSupplierArticleNumber = "TCA3824"
AND av.ProductID IN (78))
OR
(av.SupplierID = 4534
AND av.DataSupplierArticleNumber = "TCA2833"
AND av.ProductID IN (78))
OR
(av.SupplierID = 4534
AND av.DataSupplierArticleNumber = "TCA2584"
AND av.ProductID IN (78))
OR
(av.SupplierID = 4534
AND av.DataSupplierArticleNumber = "TCA2834"
AND av.ProductID IN (78))
OR
(av.SupplierID = 4534
AND av.DataSupplierArticleNumber = "TCA2595"
AND av.ProductID IN (78))
OR
(av.SupplierID = 4534
AND av.DataSupplierArticleNumber = "TCA3823"
AND av.ProductID IN (78))
OR
(av.SupplierID = 4534
AND av.DataSupplierArticleNumber = "TCA2596"
AND av.ProductID IN (78))
OR
(av.SupplierID = 4534
AND av.DataSupplierArticleNumber = "TCA2583"
AND av.ProductID IN (78))
OR
(av.SupplierID = 4537
AND av.DataSupplierArticleNumber = "LCA476"
AND av.ProductID IN (78))
OR
(av.SupplierID = 4537
AND av.DataSupplierArticleNumber = "RCA476"
AND av.ProductID IN (78))
OR
(av.SupplierID = 3
AND av.DataSupplierArticleNumber = "24.9236-8002.5"
AND av.ProductID IN (78))
OR
(av.SupplierID = 3
AND av.DataSupplierArticleNumber = "13.9361-0035.2"
AND av.ProductID IN (78))
OR
(av.SupplierID = 3
AND av.DataSupplierArticleNumber = "11.3571-8510.2"
AND av.ProductID IN (78))
OR
(av.SupplierID = 3
AND av.DataSupplierArticleNumber = "13.9361-0036.2"
AND av.ProductID IN (78))
OR
(av.SupplierID = 3
AND av.DataSupplierArticleNumber = "13.2361-8001.2"
AND av.ProductID IN (78))
OR
(av.SupplierID = 3
AND av.DataSupplierArticleNumber = "24.9236-8001.5"
AND av.ProductID IN (78))
OR
(av.SupplierID = 3
AND av.DataSupplierArticleNumber = "13.2361-8002.2"
AND av.ProductID IN (78))
OR
(av.SupplierID = 3
AND av.DataSupplierArticleNumber = "11.3571-8509.2"
AND av.ProductID IN (78))
OR
(av.SupplierID = 351
AND av.DataSupplierArticleNumber = "D4594"
AND av.ProductID IN (405))
OR
(av.SupplierID = 351
AND av.DataSupplierArticleNumber = "D41608C"
AND av.ProductID IN (405))
OR
(av.SupplierID = 351
AND av.DataSupplierArticleNumber = "D41842C"
AND av.ProductID IN (405))
OR
(av.SupplierID = 351
AND av.DataSupplierArticleNumber = "D4134"
AND av.ProductID IN (405))
OR
(av.SupplierID = 351
AND av.DataSupplierArticleNumber = "D4357"
AND av.ProductID IN (405))
OR
(av.SupplierID = 351
AND av.DataSupplierArticleNumber = "D41583C"
AND av.ProductID IN (405))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "1 987 470 084"
AND av.ProductID IN (405))
OR
(av.SupplierID = 4993
AND av.DataSupplierArticleNumber = "AG0782"
AND av.ProductID IN (78))
OR
(av.SupplierID = 4993
AND av.DataSupplierArticleNumber = "AG0783"
AND av.ProductID IN (78))
OR
(av.SupplierID = 4993
AND av.DataSupplierArticleNumber = "AG0396"
AND av.ProductID IN (78))
OR
(av.SupplierID = 4993
AND av.DataSupplierArticleNumber = "AG0397"
AND av.ProductID IN (78))
OR
(av.SupplierID = 65
AND av.DataSupplierArticleNumber = "F 50 210"
AND av.ProductID IN (78))
OR
(av.SupplierID = 65
AND av.DataSupplierArticleNumber = "F 50 125"
AND av.ProductID IN (78))
OR
(av.SupplierID = 65
AND av.DataSupplierArticleNumber = "F 50 211"
AND av.ProductID IN (78))
OR
(av.SupplierID = 65
AND av.DataSupplierArticleNumber = "F 50 128"
AND av.ProductID IN (78))
OR
(av.SupplierID = 65
AND av.DataSupplierArticleNumber = "F 50 129"
AND av.ProductID IN (78))
OR
(av.SupplierID = 65
AND av.DataSupplierArticleNumber = "F 50 124"
AND av.ProductID IN (78))
OR
(av.SupplierID = 114
AND av.DataSupplierArticleNumber = "342743"
AND av.ProductID IN (78))
OR
(av.SupplierID = 114
AND av.DataSupplierArticleNumber = "203520"
AND av.ProductID IN (405))
OR
(av.SupplierID = 114
AND av.DataSupplierArticleNumber = "342536"
AND av.ProductID IN (78))
OR
(av.SupplierID = 114
AND av.DataSupplierArticleNumber = "343692"
AND av.ProductID IN (78))
OR
(av.SupplierID = 114
AND av.DataSupplierArticleNumber = "205704"
AND av.ProductID IN (405))
OR
(av.SupplierID = 114
AND av.DataSupplierArticleNumber = "342537"
AND av.ProductID IN (78))
OR
(av.SupplierID = 114
AND av.DataSupplierArticleNumber = "343693"
AND av.ProductID IN (78))
OR
(av.SupplierID = 114
AND av.DataSupplierArticleNumber = "342742"
AND av.ProductID IN (78))
OR
(av.SupplierID = 114
AND av.DataSupplierArticleNumber = "203501"
AND av.ProductID IN (405))
OR
(av.SupplierID = 89
AND av.DataSupplierArticleNumber = "LC7482"
AND av.ProductID IN (78))
OR
(av.SupplierID = 89
AND av.DataSupplierArticleNumber = "LC7481"
AND av.ProductID IN (78))
OR
(av.SupplierID = 460
AND av.DataSupplierArticleNumber = "4150200"
AND av.ProductID IN (78))
OR
(av.SupplierID = 460
AND av.DataSupplierArticleNumber = "4158100"
AND av.ProductID IN (78))
OR
(av.SupplierID = 460
AND av.DataSupplierArticleNumber = "3157100"
AND av.ProductID IN (78))
OR
(av.SupplierID = 460
AND av.DataSupplierArticleNumber = "4250200"
AND av.ProductID IN (78))
OR
(av.SupplierID = 460
AND av.DataSupplierArticleNumber = "3257100"
AND av.ProductID IN (78))
OR
(av.SupplierID = 460
AND av.DataSupplierArticleNumber = "4258100"
AND av.ProductID IN (78))
OR
(av.SupplierID = 391
AND av.DataSupplierArticleNumber = "2224440"
AND av.ProductID IN (78))
OR
(av.SupplierID = 391
AND av.DataSupplierArticleNumber = "2224439"
AND av.ProductID IN (78))
OR
(av.SupplierID = 226
AND av.DataSupplierArticleNumber = "87-0518"
AND av.ProductID IN (78))
OR
(av.SupplierID = 226
AND av.DataSupplierArticleNumber = "83-0517"
AND av.ProductID IN (78))
OR
(av.SupplierID = 226
AND av.DataSupplierArticleNumber = "87-0520"
AND av.ProductID IN (78))
OR
(av.SupplierID = 226
AND av.DataSupplierArticleNumber = "86-0518"
AND av.ProductID IN (78))
OR
(av.SupplierID = 226
AND av.DataSupplierArticleNumber = "86-0520"
AND av.ProductID IN (78))
OR
(av.SupplierID = 226
AND av.DataSupplierArticleNumber = "82-0517"
AND av.ProductID IN (78))
OR
(av.SupplierID = 224
AND av.DataSupplierArticleNumber = "BC62536"
AND av.ProductID IN (78))
OR
(av.SupplierID = 224
AND av.DataSupplierArticleNumber = "BC62537"
AND av.ProductID IN (78))
OR
(av.SupplierID = 224
AND av.DataSupplierArticleNumber = "BC52998"
AND av.ProductID IN (78))
OR
(av.SupplierID = 224
AND av.DataSupplierArticleNumber = "BC52999"
AND av.ProductID IN (78))
OR
(av.SupplierID = 4512
AND av.DataSupplierArticleNumber = "400207"
AND av.ProductID IN (405))
OR
(av.SupplierID = 4512
AND av.DataSupplierArticleNumber = "401938"
AND av.ProductID IN (405))
OR
(av.SupplierID = 4512
AND av.DataSupplierArticleNumber = "400695"
AND av.ProductID IN (405))
OR
(av.SupplierID = 4512
AND av.DataSupplierArticleNumber = "401668"
AND av.ProductID IN (405))
OR
(av.SupplierID = 4512
AND av.DataSupplierArticleNumber = "400127"
AND av.ProductID IN (405))
OR
(av.SupplierID = 4512
AND av.DataSupplierArticleNumber = "401711"
AND av.ProductID IN (405))
OR
(av.SupplierID = 62
AND av.DataSupplierArticleNumber = "FCL694553"
AND av.ProductID IN (78))
OR
(av.SupplierID = 62
AND av.DataSupplierArticleNumber = "FCL694554"
AND av.ProductID IN (78))
OR
(av.SupplierID = 62
AND av.DataSupplierArticleNumber = "FCL692760"
AND av.ProductID IN (78))
OR
(av.SupplierID = 62
AND av.DataSupplierArticleNumber = "FCL692761"
AND av.ProductID IN (78))
OR
(av.SupplierID = 380
AND av.DataSupplierArticleNumber = "236913"
AND av.ProductID IN (405))
OR
(av.SupplierID = 380
AND av.DataSupplierArticleNumber = "236916"
AND av.ProductID IN (405))
OR
(av.SupplierID = 380
AND av.DataSupplierArticleNumber = "235001"
AND av.ProductID IN (405))
OR
(av.SupplierID = 380
AND av.DataSupplierArticleNumber = "236028"
AND av.ProductID IN (405))
OR
(av.SupplierID = 54
AND av.DataSupplierArticleNumber = "RX571310A0"
AND av.ProductID IN (78))
OR
(av.SupplierID = 54
AND av.DataSupplierArticleNumber = "RX361306A0"
AND av.ProductID IN (78))
OR
(av.SupplierID = 54
AND av.DataSupplierArticleNumber = "RKS8833027"
AND av.ProductID IN (405))
OR
(av.SupplierID = 54
AND av.DataSupplierArticleNumber = "RS361306A0"
AND av.ProductID IN (78))
OR
(av.SupplierID = 54
AND av.DataSupplierArticleNumber = "RX571410A0"
AND av.ProductID IN (78))
OR
(av.SupplierID = 54
AND av.DataSupplierArticleNumber = "RX361403A0"
AND av.ProductID IN (78))
OR
(av.SupplierID = 54
AND av.DataSupplierArticleNumber = "RKS8833030"
AND av.ProductID IN (405))
OR
(av.SupplierID = 54
AND av.DataSupplierArticleNumber = "RS361406A0"
AND av.ProductID IN (78))
OR
(av.SupplierID = 54
AND av.DataSupplierArticleNumber = "RX361406A0"
AND av.ProductID IN (78))
OR
(av.SupplierID = 54
AND av.DataSupplierArticleNumber = "RX361303A0"
AND av.ProductID IN (78))
OR
(av.SupplierID = 54
AND av.DataSupplierArticleNumber = "RKS8833020"
AND av.ProductID IN (405))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "8AN 355 440-351"
AND av.ProductID IN (78))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "8AC 355 382-081"
AND av.ProductID IN (78))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "8AC 355 382-031"
AND av.ProductID IN (78))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "8AN 355 440-361"
AND av.ProductID IN (78))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "8AC 355 391-371"
AND av.ProductID IN (78))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "8AC 355 382-041"
AND av.ProductID IN (78))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "8AN 355 441-821"
AND av.ProductID IN (78))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "8AC 355 391-381"
AND av.ProductID IN (78))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "8AC 355 382-071"
AND av.ProductID IN (78))
OR
(av.SupplierID = 4625
AND av.DataSupplierArticleNumber = "8AN 355 440-351"
AND av.ProductID IN (78))
OR
(av.SupplierID = 4625
AND av.DataSupplierArticleNumber = "8AC 355 382-081"
AND av.ProductID IN (78))
OR
(av.SupplierID = 4625
AND av.DataSupplierArticleNumber = "8AC 355 382-031"
AND av.ProductID IN (78))
OR
(av.SupplierID = 4625
AND av.DataSupplierArticleNumber = "8AN 355 440-361"
AND av.ProductID IN (78))
OR
(av.SupplierID = 4625
AND av.DataSupplierArticleNumber = "8AC 355 391-371"
AND av.ProductID IN (78))
OR
(av.SupplierID = 4625
AND av.DataSupplierArticleNumber = "8AC 355 382-041"
AND av.ProductID IN (78))
OR
(av.SupplierID = 4625
AND av.DataSupplierArticleNumber = "8AN 355 441-821"
AND av.ProductID IN (78))
OR
(av.SupplierID = 4625
AND av.DataSupplierArticleNumber = "8AC 355 391-381"
AND av.ProductID IN (78))
OR
(av.SupplierID = 4625
AND av.DataSupplierArticleNumber = "8AC 355 382-071"
AND av.ProductID IN (78))
OR
(av.SupplierID = 286
AND av.DataSupplierArticleNumber = "205704"
AND av.ProductID IN (405))
OR
(av.SupplierID = 286
AND av.DataSupplierArticleNumber = "342742"
AND av.ProductID IN (78))
OR
(av.SupplierID = 286
AND av.DataSupplierArticleNumber = "342743"
AND av.ProductID IN (78))
OR
(av.SupplierID = 286
AND av.DataSupplierArticleNumber = "342536"
AND av.ProductID IN (78))
OR
(av.SupplierID = 286
AND av.DataSupplierArticleNumber = "203501"
AND av.ProductID IN (405))
OR
(av.SupplierID = 286
AND av.DataSupplierArticleNumber = "342537"
AND av.ProductID IN (78))
OR
(av.SupplierID = 4496
AND av.DataSupplierArticleNumber = "77.0926"
AND av.ProductID IN (78))
OR
(av.SupplierID = 4496
AND av.DataSupplierArticleNumber = "77.0927"
AND av.ProductID IN (78))
OR
(av.SupplierID = 197
AND av.DataSupplierArticleNumber = "PF11404"
AND av.ProductID IN (78))
OR
(av.SupplierID = 197
AND av.DataSupplierArticleNumber = "PF11403"
AND av.ProductID IN (78))
OR
(av.SupplierID = 94
AND av.DataSupplierArticleNumber = "6250261"
AND av.ProductID IN (78))
OR
(av.SupplierID = 94
AND av.DataSupplierArticleNumber = "6250262"
AND av.ProductID IN (78))
OR
(av.SupplierID = 94
AND av.DataSupplierArticleNumber = "6250069"
AND av.ProductID IN (78))
OR
(av.SupplierID = 94
AND av.DataSupplierArticleNumber = "6250379"
AND av.ProductID IN (78))
OR
(av.SupplierID = 94
AND av.DataSupplierArticleNumber = "6250070"
AND av.ProductID IN (78))
OR
(av.SupplierID = 94
AND av.DataSupplierArticleNumber = "6250380"
AND av.ProductID IN (78))
OR
(av.SupplierID = 127
AND av.DataSupplierArticleNumber = "2133153"
AND av.ProductID IN (78))
OR
(av.SupplierID = 127
AND av.DataSupplierArticleNumber = "8833027"
AND av.ProductID IN (405))
OR
(av.SupplierID = 127
AND av.DataSupplierArticleNumber = "213335"
AND av.ProductID IN (78))
OR
(av.SupplierID = 127
AND av.DataSupplierArticleNumber = "2133154"
AND av.ProductID IN (78))
OR
(av.SupplierID = 127
AND av.DataSupplierArticleNumber = "8833030"
AND av.ProductID IN (405))
OR
(av.SupplierID = 127
AND av.DataSupplierArticleNumber = "213336"
AND av.ProductID IN (78))
OR
(av.SupplierID = 127
AND av.DataSupplierArticleNumber = "2133213"
AND av.ProductID IN (78))
OR
(av.SupplierID = 127
AND av.DataSupplierArticleNumber = "8833020"
AND av.ProductID IN (405))
OR
(av.SupplierID = 127
AND av.DataSupplierArticleNumber = "2133214"
AND av.ProductID IN (78))
OR
(av.SupplierID = 4558
AND av.DataSupplierArticleNumber = "PRK173"
AND av.ProductID IN (405))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "QBS2777"
AND av.ProductID IN (78))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "QBS2762"
AND av.ProductID IN (78))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "QBS2778"
AND av.ProductID IN (78))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "QBS2773"
AND av.ProductID IN (78))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "QBS2774"
AND av.ProductID IN (78))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "QBS2761"
AND av.ProductID IN (78))
OR
(av.SupplierID = 214
AND av.DataSupplierArticleNumber = "DC82537"
AND av.ProductID IN (78))
OR
(av.SupplierID = 214
AND av.DataSupplierArticleNumber = "DC75108"
AND av.ProductID IN (78))
OR
(av.SupplierID = 214
AND av.DataSupplierArticleNumber = "DC75109"
AND av.ProductID IN (78))
OR
(av.SupplierID = 214
AND av.DataSupplierArticleNumber = "DC73692"
AND av.ProductID IN (78))
OR
(av.SupplierID = 214
AND av.DataSupplierArticleNumber = "DC82536"
AND av.ProductID IN (78))
OR
(av.SupplierID = 214
AND av.DataSupplierArticleNumber = "DC73693"
AND av.ProductID IN (78))
OR
(av.SupplierID = 297
AND av.DataSupplierArticleNumber = "1301213335"
AND av.ProductID IN (78))
OR
(av.SupplierID = 297
AND av.DataSupplierArticleNumber = "13012133154"
AND av.ProductID IN (78))
OR
(av.SupplierID = 297
AND av.DataSupplierArticleNumber = "1301213336"
AND av.ProductID IN (78))
OR
(av.SupplierID = 297
AND av.DataSupplierArticleNumber = "13012133213"
AND av.ProductID IN (78))
OR
(av.SupplierID = 297
AND av.DataSupplierArticleNumber = "13012133214"
AND av.ProductID IN (78))
OR
(av.SupplierID = 297
AND av.DataSupplierArticleNumber = "13012133153"
AND av.ProductID IN (78))
OR
(av.SupplierID = 4607
AND av.DataSupplierArticleNumber = "BC2551"
AND av.ProductID IN (78))
OR
(av.SupplierID = 4607
AND av.DataSupplierArticleNumber = "BC2551R"
AND av.ProductID IN (78))
OR
(av.SupplierID = 4607
AND av.DataSupplierArticleNumber = "BC9462"
AND av.ProductID IN (78))
OR
(av.SupplierID = 4607
AND av.DataSupplierArticleNumber = "BC9462R"
AND av.ProductID IN (78))
OR
(av.SupplierID = 39
AND av.DataSupplierArticleNumber = "38077600"
AND av.ProductID IN (78))
OR
(av.SupplierID = 39
AND av.DataSupplierArticleNumber = "38027400"
AND av.ProductID IN (78))
OR
(av.SupplierID = 39
AND av.DataSupplierArticleNumber = "38079300"
AND av.ProductID IN (78))
OR
(av.SupplierID = 39
AND av.DataSupplierArticleNumber = "38037500"
AND av.ProductID IN (78))
OR
(av.SupplierID = 39
AND av.DataSupplierArticleNumber = "38003400"
AND av.ProductID IN (78))
OR
(av.SupplierID = 39
AND av.DataSupplierArticleNumber = "38142800"
AND av.ProductID IN (78))
OR
(av.SupplierID = 39
AND av.DataSupplierArticleNumber = "38037900"
AND av.ProductID IN (78))
OR
(av.SupplierID = 39
AND av.DataSupplierArticleNumber = "38003900"
AND av.ProductID IN (78))
OR
(av.SupplierID = 39
AND av.DataSupplierArticleNumber = "38142900"
AND av.ProductID IN (78))
OR
(av.SupplierID = 108
AND av.DataSupplierArticleNumber = "8170 203520"
AND av.ProductID IN (405))
OR
(av.SupplierID = 108
AND av.DataSupplierArticleNumber = "8170 342743"
AND av.ProductID IN (78))
OR
(av.SupplierID = 108
AND av.DataSupplierArticleNumber = "8170 342536"
AND av.ProductID IN (78))
OR
(av.SupplierID = 108
AND av.DataSupplierArticleNumber = "8170 205704"
AND av.ProductID IN (405))
OR
(av.SupplierID = 108
AND av.DataSupplierArticleNumber = "8170 343692"
AND av.ProductID IN (78))
OR
(av.SupplierID = 108
AND av.DataSupplierArticleNumber = "8170 342537"
AND av.ProductID IN (78))
OR
(av.SupplierID = 108
AND av.DataSupplierArticleNumber = "8170 343693"
AND av.ProductID IN (78))
OR
(av.SupplierID = 108
AND av.DataSupplierArticleNumber = "8170 203501"
AND av.ProductID IN (405))
OR
(av.SupplierID = 108
AND av.DataSupplierArticleNumber = "8170 342742"
AND av.ProductID IN (78))
OR
(av.SupplierID = 209
AND av.DataSupplierArticleNumber = "02.35.230"
AND av.ProductID IN (405))
OR
(av.SupplierID = 209
AND av.DataSupplierArticleNumber = "02.35.231"
AND av.ProductID IN (405))
OR
(av.SupplierID = 161
AND av.DataSupplierArticleNumber = "BHX471E"
AND av.ProductID IN (78))
OR
(av.SupplierID = 161
AND av.DataSupplierArticleNumber = "BCN190E"
AND av.ProductID IN (78))
OR
(av.SupplierID = 161
AND av.DataSupplierArticleNumber = "BHX472E"
AND av.ProductID IN (78))
OR
(av.SupplierID = 161
AND av.DataSupplierArticleNumber = "BHR265E"
AND av.ProductID IN (78))
OR
(av.SupplierID = 161
AND av.DataSupplierArticleNumber = "BHR266E"
AND av.ProductID IN (78))
OR
(av.SupplierID = 161
AND av.DataSupplierArticleNumber = "BCN189E"
AND av.ProductID IN (78))
OR
(av.SupplierID = 4739
AND av.DataSupplierArticleNumber = "25084304"
AND av.ProductID IN (78))
)
UNION ALL
SELECT
CONCAT(aa.SupplierID, "^", aa.DataSupplierArticleNumber)
as article_id,
if (aa.Description = "", aa.DisplayTitle, aa.Description)
as crit_designation,
aa.DisplayValue as crit_value,
"" crit_unit,
1 criteria_art,
"articleattributes" as source
FROM articleattributes aa
WHERE
(
(aa.SupplierID = 206
AND aa.DataSupplierArticleNumber = "43659")
OR
(aa.SupplierID = 206
AND aa.DataSupplierArticleNumber = "422441")
OR
(aa.SupplierID = 206
AND aa.DataSupplierArticleNumber = "422442")
OR
(aa.SupplierID = 206
AND aa.DataSupplierArticleNumber = "422401")
OR
(aa.SupplierID = 206
AND aa.DataSupplierArticleNumber = "43061")
OR
(aa.SupplierID = 206
AND aa.DataSupplierArticleNumber = "422402")
OR
(aa.SupplierID = 4534
AND aa.DataSupplierArticleNumber = "TCA3824")
OR
(aa.SupplierID = 4534
AND aa.DataSupplierArticleNumber = "TCA2833")
OR
(aa.SupplierID = 4534
AND aa.DataSupplierArticleNumber = "TCA2584")
OR
(aa.SupplierID = 4534
AND aa.DataSupplierArticleNumber = "TCA2834")
OR
(aa.SupplierID = 4534
AND aa.DataSupplierArticleNumber = "TCA2595")
OR
(aa.SupplierID = 4534
AND aa.DataSupplierArticleNumber = "TCA3823")
OR
(aa.SupplierID = 4534
AND aa.DataSupplierArticleNumber = "TCA2596")
OR
(aa.SupplierID = 4534
AND aa.DataSupplierArticleNumber = "TCA2583")
OR
(aa.SupplierID = 4537
AND aa.DataSupplierArticleNumber = "LCA476")
OR
(aa.SupplierID = 4537
AND aa.DataSupplierArticleNumber = "RCA476")
OR
(aa.SupplierID = 3
AND aa.DataSupplierArticleNumber = "24.9236-8002.5")
OR
(aa.SupplierID = 3
AND aa.DataSupplierArticleNumber = "13.9361-0035.2")
OR
(aa.SupplierID = 3
AND aa.DataSupplierArticleNumber = "11.3571-8510.2")
OR
(aa.SupplierID = 3
AND aa.DataSupplierArticleNumber = "13.9361-0036.2")
OR
(aa.SupplierID = 3
AND aa.DataSupplierArticleNumber = "13.2361-8001.2")
OR
(aa.SupplierID = 3
AND aa.DataSupplierArticleNumber = "24.9236-8001.5")
OR
(aa.SupplierID = 3
AND aa.DataSupplierArticleNumber = "13.2361-8002.2")
OR
(aa.SupplierID = 3
AND aa.DataSupplierArticleNumber = "11.3571-8509.2")
OR
(aa.SupplierID = 351
AND aa.DataSupplierArticleNumber = "D4594")
OR
(aa.SupplierID = 351
AND aa.DataSupplierArticleNumber = "D41608C")
OR
(aa.SupplierID = 351
AND aa.DataSupplierArticleNumber = "D41842C")
OR
(aa.SupplierID = 351
AND aa.DataSupplierArticleNumber = "D4134")
OR
(aa.SupplierID = 351
AND aa.DataSupplierArticleNumber = "D4357")
OR
(aa.SupplierID = 351
AND aa.DataSupplierArticleNumber = "D41583C")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "1 987 470 084")
OR
(aa.SupplierID = 4993
AND aa.DataSupplierArticleNumber = "AG0782")
OR
(aa.SupplierID = 4993
AND aa.DataSupplierArticleNumber = "AG0783")
OR
(aa.SupplierID = 4993
AND aa.DataSupplierArticleNumber = "AG0396")
OR
(aa.SupplierID = 4993
AND aa.DataSupplierArticleNumber = "AG0397")
OR
(aa.SupplierID = 65
AND aa.DataSupplierArticleNumber = "F 50 210")
OR
(aa.SupplierID = 65
AND aa.DataSupplierArticleNumber = "F 50 125")
OR
(aa.SupplierID = 65
AND aa.DataSupplierArticleNumber = "F 50 211")
OR
(aa.SupplierID = 65
AND aa.DataSupplierArticleNumber = "F 50 128")
OR
(aa.SupplierID = 65
AND aa.DataSupplierArticleNumber = "F 50 129")
OR
(aa.SupplierID = 65
AND aa.DataSupplierArticleNumber = "F 50 124")
OR
(aa.SupplierID = 114
AND aa.DataSupplierArticleNumber = "342743")
OR
(aa.SupplierID = 114
AND aa.DataSupplierArticleNumber = "203520")
OR
(aa.SupplierID = 114
AND aa.DataSupplierArticleNumber = "342536")
OR
(aa.SupplierID = 114
AND aa.DataSupplierArticleNumber = "343692")
OR
(aa.SupplierID = 114
AND aa.DataSupplierArticleNumber = "205704")
OR
(aa.SupplierID = 114
AND aa.DataSupplierArticleNumber = "342537")
OR
(aa.SupplierID = 114
AND aa.DataSupplierArticleNumber = "343693")
OR
(aa.SupplierID = 114
AND aa.DataSupplierArticleNumber = "342742")
OR
(aa.SupplierID = 114
AND aa.DataSupplierArticleNumber = "203501")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "LC7482")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "LC7481")
OR
(aa.SupplierID = 460
AND aa.DataSupplierArticleNumber = "4150200")
OR
(aa.SupplierID = 460
AND aa.DataSupplierArticleNumber = "4158100")
OR
(aa.SupplierID = 460
AND aa.DataSupplierArticleNumber = "3157100")
OR
(aa.SupplierID = 460
AND aa.DataSupplierArticleNumber = "4250200")
OR
(aa.SupplierID = 460
AND aa.DataSupplierArticleNumber = "3257100")
OR
(aa.SupplierID = 460
AND aa.DataSupplierArticleNumber = "4258100")
OR
(aa.SupplierID = 391
AND aa.DataSupplierArticleNumber = "2224440")
OR
(aa.SupplierID = 391
AND aa.DataSupplierArticleNumber = "2224439")
OR
(aa.SupplierID = 226
AND aa.DataSupplierArticleNumber = "87-0518")
OR
(aa.SupplierID = 226
AND aa.DataSupplierArticleNumber = "83-0517")
OR
(aa.SupplierID = 226
AND aa.DataSupplierArticleNumber = "87-0520")
OR
(aa.SupplierID = 226
AND aa.DataSupplierArticleNumber = "86-0518")
OR
(aa.SupplierID = 226
AND aa.DataSupplierArticleNumber = "86-0520")
OR
(aa.SupplierID = 226
AND aa.DataSupplierArticleNumber = "82-0517")
OR
(aa.SupplierID = 224
AND aa.DataSupplierArticleNumber = "BC62536")
OR
(aa.SupplierID = 224
AND aa.DataSupplierArticleNumber = "BC62537")
OR
(aa.SupplierID = 224
AND aa.DataSupplierArticleNumber = "BC52998")
OR
(aa.SupplierID = 224
AND aa.DataSupplierArticleNumber = "BC52999")
OR
(aa.SupplierID = 4512
AND aa.DataSupplierArticleNumber = "400207")
OR
(aa.SupplierID = 4512
AND aa.DataSupplierArticleNumber = "401938")
OR
(aa.SupplierID = 4512
AND aa.DataSupplierArticleNumber = "400695")
OR
(aa.SupplierID = 4512
AND aa.DataSupplierArticleNumber = "401668")
OR
(aa.SupplierID = 4512
AND aa.DataSupplierArticleNumber = "400127")
OR
(aa.SupplierID = 4512
AND aa.DataSupplierArticleNumber = "401711")
OR
(aa.SupplierID = 62
AND aa.DataSupplierArticleNumber = "FCL694553")
OR
(aa.SupplierID = 62
AND aa.DataSupplierArticleNumber = "FCL694554")
OR
(aa.SupplierID = 62
AND aa.DataSupplierArticleNumber = "FCL692760")
OR
(aa.SupplierID = 62
AND aa.DataSupplierArticleNumber = "FCL692761")
OR
(aa.SupplierID = 380
AND aa.DataSupplierArticleNumber = "236913")
OR
(aa.SupplierID = 380
AND aa.DataSupplierArticleNumber = "236916")
OR
(aa.SupplierID = 380
AND aa.DataSupplierArticleNumber = "235001")
OR
(aa.SupplierID = 380
AND aa.DataSupplierArticleNumber = "236028")
OR
(aa.SupplierID = 54
AND aa.DataSupplierArticleNumber = "RX571310A0")
OR
(aa.SupplierID = 54
AND aa.DataSupplierArticleNumber = "RX361306A0")
OR
(aa.SupplierID = 54
AND aa.DataSupplierArticleNumber = "RKS8833027")
OR
(aa.SupplierID = 54
AND aa.DataSupplierArticleNumber = "RS361306A0")
OR
(aa.SupplierID = 54
AND aa.DataSupplierArticleNumber = "RX571410A0")
OR
(aa.SupplierID = 54
AND aa.DataSupplierArticleNumber = "RX361403A0")
OR
(aa.SupplierID = 54
AND aa.DataSupplierArticleNumber = "RKS8833030")
OR
(aa.SupplierID = 54
AND aa.DataSupplierArticleNumber = "RS361406A0")
OR
(aa.SupplierID = 54
AND aa.DataSupplierArticleNumber = "RX361406A0")
OR
(aa.SupplierID = 54
AND aa.DataSupplierArticleNumber = "RX361303A0")
OR
(aa.SupplierID = 54
AND aa.DataSupplierArticleNumber = "RKS8833020")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8AN 355 440-351")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8AC 355 382-081")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8AC 355 382-031")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8AN 355 440-361")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8AC 355 391-371")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8AC 355 382-041")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8AN 355 441-821")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8AC 355 391-381")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8AC 355 382-071")
OR
(aa.SupplierID = 4625
AND aa.DataSupplierArticleNumber = "8AN 355 440-351")
OR
(aa.SupplierID = 4625
AND aa.DataSupplierArticleNumber = "8AC 355 382-081")
OR
(aa.SupplierID = 4625
AND aa.DataSupplierArticleNumber = "8AC 355 382-031")
OR
(aa.SupplierID = 4625
AND aa.DataSupplierArticleNumber = "8AN 355 440-361")
OR
(aa.SupplierID = 4625
AND aa.DataSupplierArticleNumber = "8AC 355 391-371")
OR
(aa.SupplierID = 4625
AND aa.DataSupplierArticleNumber = "8AC 355 382-041")
OR
(aa.SupplierID = 4625
AND aa.DataSupplierArticleNumber = "8AN 355 441-821")
OR
(aa.SupplierID = 4625
AND aa.DataSupplierArticleNumber = "8AC 355 391-381")
OR
(aa.SupplierID = 4625
AND aa.DataSupplierArticleNumber = "8AC 355 382-071")
OR
(aa.SupplierID = 286
AND aa.DataSupplierArticleNumber = "205704")
OR
(aa.SupplierID = 286
AND aa.DataSupplierArticleNumber = "342742")
OR
(aa.SupplierID = 286
AND aa.DataSupplierArticleNumber = "342743")
OR
(aa.SupplierID = 286
AND aa.DataSupplierArticleNumber = "342536")
OR
(aa.SupplierID = 286
AND aa.DataSupplierArticleNumber = "203501")
OR
(aa.SupplierID = 286
AND aa.DataSupplierArticleNumber = "342537")
OR
(aa.SupplierID = 4496
AND aa.DataSupplierArticleNumber = "77.0926")
OR
(aa.SupplierID = 4496
AND aa.DataSupplierArticleNumber = "77.0927")
OR
(aa.SupplierID = 197
AND aa.DataSupplierArticleNumber = "PF11404")
OR
(aa.SupplierID = 197
AND aa.DataSupplierArticleNumber = "PF11403")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "6250261")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "6250262")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "6250069")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "6250379")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "6250070")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "6250380")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "2133153")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "8833027")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "213335")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "2133154")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "8833030")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "213336")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "2133213")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "8833020")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "2133214")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PRK173")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QBS2777")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QBS2762")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QBS2778")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QBS2773")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QBS2774")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QBS2761")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "DC82537")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "DC75108")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "DC75109")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "DC73692")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "DC82536")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "DC73693")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "1301213335")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "13012133154")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "1301213336")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "13012133213")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "13012133214")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "13012133153")
OR
(aa.SupplierID = 4607
AND aa.DataSupplierArticleNumber = "BC2551")
OR
(aa.SupplierID = 4607
AND aa.DataSupplierArticleNumber = "BC2551R")
OR
(aa.SupplierID = 4607
AND aa.DataSupplierArticleNumber = "BC9462")
OR
(aa.SupplierID = 4607
AND aa.DataSupplierArticleNumber = "BC9462R")
OR
(aa.SupplierID = 39
AND aa.DataSupplierArticleNumber = "38077600")
OR
(aa.SupplierID = 39
AND aa.DataSupplierArticleNumber = "38027400")
OR
(aa.SupplierID = 39
AND aa.DataSupplierArticleNumber = "38079300")
OR
(aa.SupplierID = 39
AND aa.DataSupplierArticleNumber = "38037500")
OR
(aa.SupplierID = 39
AND aa.DataSupplierArticleNumber = "38003400")
OR
(aa.SupplierID = 39
AND aa.DataSupplierArticleNumber = "38142800")
OR
(aa.SupplierID = 39
AND aa.DataSupplierArticleNumber = "38037900")
OR
(aa.SupplierID = 39
AND aa.DataSupplierArticleNumber = "38003900")
OR
(aa.SupplierID = 39
AND aa.DataSupplierArticleNumber = "38142900")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8170 203520")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8170 342743")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8170 342536")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8170 205704")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8170 343692")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8170 342537")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8170 343693")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8170 203501")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8170 342742")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "02.35.230")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "02.35.231")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "BHX471E")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "BCN190E")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "BHX472E")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "BHR265E")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "BHR266E")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "BCN189E")
OR
(aa.SupplierID = 4739
AND aa.DataSupplierArticleNumber = "25084304")
)
AND aa.Language = "ru"
UNION ALL
SELECT
CONCAT(aa.SupplierID, "^", aa.DataSupplierArticleNumber)
as article_id,
if (aa.Description = "", aa.DisplayTitle, aa.Description)
as crit_designation,
aa.DisplayValue as crit_value,
"" crit_unit,
1 criteria_art,
"articleattributes_2018_2" as source
FROM articleattributes_2018_2 aa
WHERE
(
(aa.SupplierID = 206
AND aa.DataSupplierArticleNumber = "43659")
OR
(aa.SupplierID = 206
AND aa.DataSupplierArticleNumber = "422441")
OR
(aa.SupplierID = 206
AND aa.DataSupplierArticleNumber = "422442")
OR
(aa.SupplierID = 206
AND aa.DataSupplierArticleNumber = "422401")
OR
(aa.SupplierID = 206
AND aa.DataSupplierArticleNumber = "43061")
OR
(aa.SupplierID = 206
AND aa.DataSupplierArticleNumber = "422402")
OR
(aa.SupplierID = 4534
AND aa.DataSupplierArticleNumber = "TCA3824")
OR
(aa.SupplierID = 4534
AND aa.DataSupplierArticleNumber = "TCA2833")
OR
(aa.SupplierID = 4534
AND aa.DataSupplierArticleNumber = "TCA2584")
OR
(aa.SupplierID = 4534
AND aa.DataSupplierArticleNumber = "TCA2834")
OR
(aa.SupplierID = 4534
AND aa.DataSupplierArticleNumber = "TCA2595")
OR
(aa.SupplierID = 4534
AND aa.DataSupplierArticleNumber = "TCA3823")
OR
(aa.SupplierID = 4534
AND aa.DataSupplierArticleNumber = "TCA2596")
OR
(aa.SupplierID = 4534
AND aa.DataSupplierArticleNumber = "TCA2583")
OR
(aa.SupplierID = 4537
AND aa.DataSupplierArticleNumber = "LCA476")
OR
(aa.SupplierID = 4537
AND aa.DataSupplierArticleNumber = "RCA476")
OR
(aa.SupplierID = 3
AND aa.DataSupplierArticleNumber = "24.9236-8002.5")
OR
(aa.SupplierID = 3
AND aa.DataSupplierArticleNumber = "13.9361-0035.2")
OR
(aa.SupplierID = 3
AND aa.DataSupplierArticleNumber = "11.3571-8510.2")
OR
(aa.SupplierID = 3
AND aa.DataSupplierArticleNumber = "13.9361-0036.2")
OR
(aa.SupplierID = 3
AND aa.DataSupplierArticleNumber = "13.2361-8001.2")
OR
(aa.SupplierID = 3
AND aa.DataSupplierArticleNumber = "24.9236-8001.5")
OR
(aa.SupplierID = 3
AND aa.DataSupplierArticleNumber = "13.2361-8002.2")
OR
(aa.SupplierID = 3
AND aa.DataSupplierArticleNumber = "11.3571-8509.2")
OR
(aa.SupplierID = 351
AND aa.DataSupplierArticleNumber = "D4594")
OR
(aa.SupplierID = 351
AND aa.DataSupplierArticleNumber = "D41608C")
OR
(aa.SupplierID = 351
AND aa.DataSupplierArticleNumber = "D41842C")
OR
(aa.SupplierID = 351
AND aa.DataSupplierArticleNumber = "D4134")
OR
(aa.SupplierID = 351
AND aa.DataSupplierArticleNumber = "D4357")
OR
(aa.SupplierID = 351
AND aa.DataSupplierArticleNumber = "D41583C")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "1 987 470 084")
OR
(aa.SupplierID = 4993
AND aa.DataSupplierArticleNumber = "AG0782")
OR
(aa.SupplierID = 4993
AND aa.DataSupplierArticleNumber = "AG0783")
OR
(aa.SupplierID = 4993
AND aa.DataSupplierArticleNumber = "AG0396")
OR
(aa.SupplierID = 4993
AND aa.DataSupplierArticleNumber = "AG0397")
OR
(aa.SupplierID = 65
AND aa.DataSupplierArticleNumber = "F 50 210")
OR
(aa.SupplierID = 65
AND aa.DataSupplierArticleNumber = "F 50 125")
OR
(aa.SupplierID = 65
AND aa.DataSupplierArticleNumber = "F 50 211")
OR
(aa.SupplierID = 65
AND aa.DataSupplierArticleNumber = "F 50 128")
OR
(aa.SupplierID = 65
AND aa.DataSupplierArticleNumber = "F 50 129")
OR
(aa.SupplierID = 65
AND aa.DataSupplierArticleNumber = "F 50 124")
OR
(aa.SupplierID = 114
AND aa.DataSupplierArticleNumber = "342743")
OR
(aa.SupplierID = 114
AND aa.DataSupplierArticleNumber = "203520")
OR
(aa.SupplierID = 114
AND aa.DataSupplierArticleNumber = "342536")
OR
(aa.SupplierID = 114
AND aa.DataSupplierArticleNumber = "343692")
OR
(aa.SupplierID = 114
AND aa.DataSupplierArticleNumber = "205704")
OR
(aa.SupplierID = 114
AND aa.DataSupplierArticleNumber = "342537")
OR
(aa.SupplierID = 114
AND aa.DataSupplierArticleNumber = "343693")
OR
(aa.SupplierID = 114
AND aa.DataSupplierArticleNumber = "342742")
OR
(aa.SupplierID = 114
AND aa.DataSupplierArticleNumber = "203501")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "LC7482")
OR
(aa.SupplierID = 89
AND aa.DataSupplierArticleNumber = "LC7481")
OR
(aa.SupplierID = 460
AND aa.DataSupplierArticleNumber = "4150200")
OR
(aa.SupplierID = 460
AND aa.DataSupplierArticleNumber = "4158100")
OR
(aa.SupplierID = 460
AND aa.DataSupplierArticleNumber = "3157100")
OR
(aa.SupplierID = 460
AND aa.DataSupplierArticleNumber = "4250200")
OR
(aa.SupplierID = 460
AND aa.DataSupplierArticleNumber = "3257100")
OR
(aa.SupplierID = 460
AND aa.DataSupplierArticleNumber = "4258100")
OR
(aa.SupplierID = 391
AND aa.DataSupplierArticleNumber = "2224440")
OR
(aa.SupplierID = 391
AND aa.DataSupplierArticleNumber = "2224439")
OR
(aa.SupplierID = 226
AND aa.DataSupplierArticleNumber = "87-0518")
OR
(aa.SupplierID = 226
AND aa.DataSupplierArticleNumber = "83-0517")
OR
(aa.SupplierID = 226
AND aa.DataSupplierArticleNumber = "87-0520")
OR
(aa.SupplierID = 226
AND aa.DataSupplierArticleNumber = "86-0518")
OR
(aa.SupplierID = 226
AND aa.DataSupplierArticleNumber = "86-0520")
OR
(aa.SupplierID = 226
AND aa.DataSupplierArticleNumber = "82-0517")
OR
(aa.SupplierID = 224
AND aa.DataSupplierArticleNumber = "BC62536")
OR
(aa.SupplierID = 224
AND aa.DataSupplierArticleNumber = "BC62537")
OR
(aa.SupplierID = 224
AND aa.DataSupplierArticleNumber = "BC52998")
OR
(aa.SupplierID = 224
AND aa.DataSupplierArticleNumber = "BC52999")
OR
(aa.SupplierID = 4512
AND aa.DataSupplierArticleNumber = "400207")
OR
(aa.SupplierID = 4512
AND aa.DataSupplierArticleNumber = "401938")
OR
(aa.SupplierID = 4512
AND aa.DataSupplierArticleNumber = "400695")
OR
(aa.SupplierID = 4512
AND aa.DataSupplierArticleNumber = "401668")
OR
(aa.SupplierID = 4512
AND aa.DataSupplierArticleNumber = "400127")
OR
(aa.SupplierID = 4512
AND aa.DataSupplierArticleNumber = "401711")
OR
(aa.SupplierID = 62
AND aa.DataSupplierArticleNumber = "FCL694553")
OR
(aa.SupplierID = 62
AND aa.DataSupplierArticleNumber = "FCL694554")
OR
(aa.SupplierID = 62
AND aa.DataSupplierArticleNumber = "FCL692760")
OR
(aa.SupplierID = 62
AND aa.DataSupplierArticleNumber = "FCL692761")
OR
(aa.SupplierID = 380
AND aa.DataSupplierArticleNumber = "236913")
OR
(aa.SupplierID = 380
AND aa.DataSupplierArticleNumber = "236916")
OR
(aa.SupplierID = 380
AND aa.DataSupplierArticleNumber = "235001")
OR
(aa.SupplierID = 380
AND aa.DataSupplierArticleNumber = "236028")
OR
(aa.SupplierID = 54
AND aa.DataSupplierArticleNumber = "RX571310A0")
OR
(aa.SupplierID = 54
AND aa.DataSupplierArticleNumber = "RX361306A0")
OR
(aa.SupplierID = 54
AND aa.DataSupplierArticleNumber = "RKS8833027")
OR
(aa.SupplierID = 54
AND aa.DataSupplierArticleNumber = "RS361306A0")
OR
(aa.SupplierID = 54
AND aa.DataSupplierArticleNumber = "RX571410A0")
OR
(aa.SupplierID = 54
AND aa.DataSupplierArticleNumber = "RX361403A0")
OR
(aa.SupplierID = 54
AND aa.DataSupplierArticleNumber = "RKS8833030")
OR
(aa.SupplierID = 54
AND aa.DataSupplierArticleNumber = "RS361406A0")
OR
(aa.SupplierID = 54
AND aa.DataSupplierArticleNumber = "RX361406A0")
OR
(aa.SupplierID = 54
AND aa.DataSupplierArticleNumber = "RX361303A0")
OR
(aa.SupplierID = 54
AND aa.DataSupplierArticleNumber = "RKS8833020")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8AN 355 440-351")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8AC 355 382-081")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8AC 355 382-031")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8AN 355 440-361")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8AC 355 391-371")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8AC 355 382-041")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8AN 355 441-821")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8AC 355 391-381")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8AC 355 382-071")
OR
(aa.SupplierID = 4625
AND aa.DataSupplierArticleNumber = "8AN 355 440-351")
OR
(aa.SupplierID = 4625
AND aa.DataSupplierArticleNumber = "8AC 355 382-081")
OR
(aa.SupplierID = 4625
AND aa.DataSupplierArticleNumber = "8AC 355 382-031")
OR
(aa.SupplierID = 4625
AND aa.DataSupplierArticleNumber = "8AN 355 440-361")
OR
(aa.SupplierID = 4625
AND aa.DataSupplierArticleNumber = "8AC 355 391-371")
OR
(aa.SupplierID = 4625
AND aa.DataSupplierArticleNumber = "8AC 355 382-041")
OR
(aa.SupplierID = 4625
AND aa.DataSupplierArticleNumber = "8AN 355 441-821")
OR
(aa.SupplierID = 4625
AND aa.DataSupplierArticleNumber = "8AC 355 391-381")
OR
(aa.SupplierID = 4625
AND aa.DataSupplierArticleNumber = "8AC 355 382-071")
OR
(aa.SupplierID = 286
AND aa.DataSupplierArticleNumber = "205704")
OR
(aa.SupplierID = 286
AND aa.DataSupplierArticleNumber = "342742")
OR
(aa.SupplierID = 286
AND aa.DataSupplierArticleNumber = "342743")
OR
(aa.SupplierID = 286
AND aa.DataSupplierArticleNumber = "342536")
OR
(aa.SupplierID = 286
AND aa.DataSupplierArticleNumber = "203501")
OR
(aa.SupplierID = 286
AND aa.DataSupplierArticleNumber = "342537")
OR
(aa.SupplierID = 4496
AND aa.DataSupplierArticleNumber = "77.0926")
OR
(aa.SupplierID = 4496
AND aa.DataSupplierArticleNumber = "77.0927")
OR
(aa.SupplierID = 197
AND aa.DataSupplierArticleNumber = "PF11404")
OR
(aa.SupplierID = 197
AND aa.DataSupplierArticleNumber = "PF11403")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "6250261")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "6250262")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "6250069")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "6250379")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "6250070")
OR
(aa.SupplierID = 94
AND aa.DataSupplierArticleNumber = "6250380")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "2133153")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "8833027")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "213335")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "2133154")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "8833030")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "213336")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "2133213")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "8833020")
OR
(aa.SupplierID = 127
AND aa.DataSupplierArticleNumber = "2133214")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PRK173")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QBS2777")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QBS2762")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QBS2778")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QBS2773")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QBS2774")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QBS2761")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "DC82537")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "DC75108")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "DC75109")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "DC73692")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "DC82536")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "DC73693")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "1301213335")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "13012133154")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "1301213336")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "13012133213")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "13012133214")
OR
(aa.SupplierID = 297
AND aa.DataSupplierArticleNumber = "13012133153")
OR
(aa.SupplierID = 4607
AND aa.DataSupplierArticleNumber = "BC2551")
OR
(aa.SupplierID = 4607
AND aa.DataSupplierArticleNumber = "BC2551R")
OR
(aa.SupplierID = 4607
AND aa.DataSupplierArticleNumber = "BC9462")
OR
(aa.SupplierID = 4607
AND aa.DataSupplierArticleNumber = "BC9462R")
OR
(aa.SupplierID = 39
AND aa.DataSupplierArticleNumber = "38077600")
OR
(aa.SupplierID = 39
AND aa.DataSupplierArticleNumber = "38027400")
OR
(aa.SupplierID = 39
AND aa.DataSupplierArticleNumber = "38079300")
OR
(aa.SupplierID = 39
AND aa.DataSupplierArticleNumber = "38037500")
OR
(aa.SupplierID = 39
AND aa.DataSupplierArticleNumber = "38003400")
OR
(aa.SupplierID = 39
AND aa.DataSupplierArticleNumber = "38142800")
OR
(aa.SupplierID = 39
AND aa.DataSupplierArticleNumber = "38037900")
OR
(aa.SupplierID = 39
AND aa.DataSupplierArticleNumber = "38003900")
OR
(aa.SupplierID = 39
AND aa.DataSupplierArticleNumber = "38142900")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8170 203520")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8170 342743")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8170 342536")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8170 205704")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8170 343692")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8170 342537")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8170 343693")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8170 203501")
OR
(aa.SupplierID = 108
AND aa.DataSupplierArticleNumber = "8170 342742")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "02.35.230")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "02.35.231")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "BHX471E")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "BCN190E")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "BHX472E")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "BHR265E")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "BHR266E")
OR
(aa.SupplierID = 161
AND aa.DataSupplierArticleNumber = "BCN189E")
OR
(aa.SupplierID = 4739
AND aa.DataSupplierArticleNumber = "25084304")
)
AND aa.Language = "ru"
Продажа автозапчастей типа Суппорт диского колесного тормозного механизма / -держатель для автомобилей
