#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2MXx8bW9kZWxfaWQ9PTM5OTV8fG1kZl9pZD09MF4xMDQ2MHx8c3BhcmVfaWQ9PTEwMTQ2Nw%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 = "10460"
AND (
(av.SupplierID = 11
AND av.DataSupplierArticleNumber = "112554"
AND av.ProductID IN (107))
OR
(av.SupplierID = 363
AND av.DataSupplierArticleNumber = "70721023"
AND av.ProductID IN (107))
OR
(av.SupplierID = 363
AND av.DataSupplierArticleNumber = "70721012"
AND av.ProductID IN (107))
OR
(av.SupplierID = 363
AND av.DataSupplierArticleNumber = "79780235"
AND av.ProductID IN (107))
OR
(av.SupplierID = 363
AND av.DataSupplierArticleNumber = "70721062"
AND av.ProductID IN (107))
OR
(av.SupplierID = 363
AND av.DataSupplierArticleNumber = "70721055"
AND av.ProductID IN (107))
OR
(av.SupplierID = 363
AND av.DataSupplierArticleNumber = "70721013"
AND av.ProductID IN (107))
OR
(av.SupplierID = 363
AND av.DataSupplierArticleNumber = "79780237"
AND av.ProductID IN (107))
OR
(av.SupplierID = 363
AND av.DataSupplierArticleNumber = "79780230"
AND av.ProductID IN (107))
OR
(av.SupplierID = 363
AND av.DataSupplierArticleNumber = "70721056"
AND av.ProductID IN (107))
OR
(av.SupplierID = 363
AND av.DataSupplierArticleNumber = "70721021"
AND av.ProductID IN (107))
OR
(av.SupplierID = 363
AND av.DataSupplierArticleNumber = "79780232"
AND av.ProductID IN (107))
OR
(av.SupplierID = 363
AND av.DataSupplierArticleNumber = "70721061"
AND av.ProductID IN (107))
OR
(av.SupplierID = 253
AND av.DataSupplierArticleNumber = "LID10078"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 253
AND av.DataSupplierArticleNumber = "LID10079"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 253
AND av.DataSupplierArticleNumber = "9600080"
AND av.ProductID IN (107))
OR
(av.SupplierID = 253
AND av.DataSupplierArticleNumber = "9600081"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "DB64150"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "DB64193EXV-01B"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "DB64193-01B"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "DB7528"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "DB64150EXV-01B"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "DB64150-01B"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "DB64193LLF"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "DB64193BW"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "DB64150LLF"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "DB2825"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "DB64150BW"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "DB64193EXV"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "DB64193"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "DB6418"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 4318
AND av.DataSupplierArticleNumber = "DB64150EXV"
AND av.ProductID IN (107))
OR
(av.SupplierID = 101
AND av.DataSupplierArticleNumber = "06583"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "35752"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "93012846"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "98714"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "93011341"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "19759"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "93012270"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "98264"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "70244"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "17463"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "90902"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "97131"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "17138"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "17120"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "84489"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "93768"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "74154"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "93013292"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "35930"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "93012861"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "98715"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "34454"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "93012303"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "98281"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "76108"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "19682"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "91618"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "97132"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "27888"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "17123"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "84491"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "95396"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "12791"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "79298"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "93013293"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "73500"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "93013070"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "98716"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "35017"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "93012336"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "98282"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "77048"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "19686"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "93012268"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "98241"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "41961"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "17462"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "90901"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "95397"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "12904"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "79299"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "93361"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "74153"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "93013272"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4612
AND av.DataSupplierArticleNumber = "98717"
AND av.ProductID IN (107))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "8GH 007 157-121"
AND av.ProductID IN (107))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "8GJ 002 525-131"
AND av.ProductID IN (107))
OR
(av.SupplierID = 72
AND av.DataSupplierArticleNumber = "89901100"
AND av.ProductID IN (107))
OR
(av.SupplierID = 72
AND av.DataSupplierArticleNumber = "89901175"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 72
AND av.DataSupplierArticleNumber = "89901218"
AND av.ProductID IN (107))
OR
(av.SupplierID = 72
AND av.DataSupplierArticleNumber = "89901051"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "0805290"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "0800850"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 4546
AND av.DataSupplierArticleNumber = "0805250"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4600
AND av.DataSupplierArticleNumber = "L10460-01"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4600
AND av.DataSupplierArticleNumber = "L10460B-02"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4600
AND av.DataSupplierArticleNumber = "L10460-02"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4600
AND av.DataSupplierArticleNumber = "L10460B"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4600
AND av.DataSupplierArticleNumber = "L10460"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4600
AND av.DataSupplierArticleNumber = "L10460B-01"
AND av.ProductID IN (107))
OR
(av.SupplierID = 133
AND av.DataSupplierArticleNumber = "103200"
AND av.ProductID IN (107))
OR
(av.SupplierID = 403
AND av.DataSupplierArticleNumber = "78-0088"
AND av.ProductID IN (107))
OR
(av.SupplierID = 403
AND av.DataSupplierArticleNumber = "78-0097"
AND av.ProductID IN (107))
OR
(av.SupplierID = 403
AND av.DataSupplierArticleNumber = "78-0044SET"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 403
AND av.DataSupplierArticleNumber = "78-0008"
AND av.ProductID IN (107))
OR
(av.SupplierID = 485
AND av.DataSupplierArticleNumber = "17177"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 485
AND av.DataSupplierArticleNumber = "48861"
AND av.ProductID IN (107))
OR
(av.SupplierID = 485
AND av.DataSupplierArticleNumber = "17189"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 485
AND av.DataSupplierArticleNumber = "48881"
AND av.ProductID IN (107))
OR
(av.SupplierID = 485
AND av.DataSupplierArticleNumber = "48889"
AND av.ProductID IN (107))
OR
(av.SupplierID = 485
AND av.DataSupplierArticleNumber = "48677"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4671
AND av.DataSupplierArticleNumber = "N472EL-HCB"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4671
AND av.DataSupplierArticleNumber = "N472"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4671
AND av.DataSupplierArticleNumber = "N501"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 4671
AND av.DataSupplierArticleNumber = "N472-01B"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4671
AND av.DataSupplierArticleNumber = "N501-02B"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 4671
AND av.DataSupplierArticleNumber = "N472B"
AND av.ProductID IN (107))
OR
(av.SupplierID = 67
AND av.DataSupplierArticleNumber = "2825"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 67
AND av.DataSupplierArticleNumber = "64193ULT-01B"
AND av.ProductID IN (107))
OR
(av.SupplierID = 67
AND av.DataSupplierArticleNumber = "64193SV2-01B"
AND av.ProductID IN (107))
OR
(av.SupplierID = 67
AND av.DataSupplierArticleNumber = "64193NR1-02B"
AND av.ProductID IN (107))
OR
(av.SupplierID = 67
AND av.DataSupplierArticleNumber = "64193NBU-01B"
AND av.ProductID IN (107))
OR
(av.SupplierID = 67
AND av.DataSupplierArticleNumber = "2825ULT-02B"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 67
AND av.DataSupplierArticleNumber = "64193CBI-01B"
AND av.ProductID IN (107))
OR
(av.SupplierID = 67
AND av.DataSupplierArticleNumber = "2825-02B"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 67
AND av.DataSupplierArticleNumber = "64193"
AND av.ProductID IN (107))
OR
(av.SupplierID = 67
AND av.DataSupplierArticleNumber = "64193ULT-HCB"
AND av.ProductID IN (107))
OR
(av.SupplierID = 67
AND av.DataSupplierArticleNumber = "64193SV2-HCB"
AND av.ProductID IN (107))
OR
(av.SupplierID = 67
AND av.DataSupplierArticleNumber = "64193NR5-01B"
AND av.ProductID IN (107))
OR
(av.SupplierID = 67
AND av.DataSupplierArticleNumber = "64193NBU-HCB"
AND av.ProductID IN (107))
OR
(av.SupplierID = 67
AND av.DataSupplierArticleNumber = "64193CBI-HCB"
AND av.ProductID IN (107))
OR
(av.SupplierID = 67
AND av.DataSupplierArticleNumber = "2825HCBI-02B"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 67
AND av.DataSupplierArticleNumber = "64193-01B"
AND av.ProductID IN (107))
OR
(av.SupplierID = 67
AND av.DataSupplierArticleNumber = "64193XR-02B"
AND av.ProductID IN (107))
OR
(av.SupplierID = 67
AND av.DataSupplierArticleNumber = "64193ULT"
AND av.ProductID IN (107))
OR
(av.SupplierID = 67
AND av.DataSupplierArticleNumber = "64193SV2"
AND av.ProductID IN (107))
OR
(av.SupplierID = 67
AND av.DataSupplierArticleNumber = "64193NR1-01B"
AND av.ProductID IN (107))
OR
(av.SupplierID = 67
AND av.DataSupplierArticleNumber = "64193NBU"
AND av.ProductID IN (107))
OR
(av.SupplierID = 67
AND av.DataSupplierArticleNumber = "2825ULT"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 67
AND av.DataSupplierArticleNumber = "64193CBI"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4558
AND av.DataSupplierArticleNumber = "PLH4-60/55"
AND av.ProductID IN (107))
OR
(av.SupplierID = 4558
AND av.DataSupplierArticleNumber = "PLT10-12/5"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 75
AND av.DataSupplierArticleNumber = "12342XV+S2"
AND av.ProductID IN (107))
OR
(av.SupplierID = 75
AND av.DataSupplierArticleNumber = "12342WHVB1"
AND av.ProductID IN (107))
OR
(av.SupplierID = 75
AND av.DataSupplierArticleNumber = "12342PRC1"
AND av.ProductID IN (107))
OR
(av.SupplierID = 75
AND av.DataSupplierArticleNumber = "12961LLECOCP"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 75
AND av.DataSupplierArticleNumber = "12342LLECOC1"
AND av.ProductID IN (107))
OR
(av.SupplierID = 75
AND av.DataSupplierArticleNumber = "12961CP"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 75
AND av.DataSupplierArticleNumber = "12342WHVSM"
AND av.ProductID IN (107))
OR
(av.SupplierID = 75
AND av.DataSupplierArticleNumber = "12342VPB1"
AND av.ProductID IN (107))
OR
(av.SupplierID = 75
AND av.DataSupplierArticleNumber = "12961NBVB2"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 75
AND av.DataSupplierArticleNumber = "12342LLECOS2"
AND av.ProductID IN (107))
OR
(av.SupplierID = 75
AND av.DataSupplierArticleNumber = "12961EDCP"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 75
AND av.DataSupplierArticleNumber = "12342XV+B1"
AND av.ProductID IN (107))
OR
(av.SupplierID = 75
AND av.DataSupplierArticleNumber = "12342VPS2"
AND av.ProductID IN (107))
OR
(av.SupplierID = 75
AND av.DataSupplierArticleNumber = "12342PRB1"
AND av.ProductID IN (107))
OR
(av.SupplierID = 75
AND av.DataSupplierArticleNumber = "12961LLECOB2"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 75
AND av.DataSupplierArticleNumber = "12342LLECOB1"
AND av.ProductID IN (107))
OR
(av.SupplierID = 75
AND av.DataSupplierArticleNumber = "12961B2"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "202792"
AND av.ProductID IN (107))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "202112"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 225
AND av.DataSupplierArticleNumber = "202013"
AND av.ProductID IN (107))
OR
(av.SupplierID = 45
AND av.DataSupplierArticleNumber = "BL54182"
AND av.ProductID IN (107))
OR
(av.SupplierID = 45
AND av.DataSupplierArticleNumber = "5221L"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 45
AND av.DataSupplierArticleNumber = "54185"
AND av.ProductID IN (107))
OR
(av.SupplierID = 45
AND av.DataSupplierArticleNumber = "54182"
AND av.ProductID IN (107))
OR
(av.SupplierID = 45
AND av.DataSupplierArticleNumber = "54080"
AND av.ProductID IN (107))
OR
(av.SupplierID = 45
AND av.DataSupplierArticleNumber = "5224"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 45
AND av.DataSupplierArticleNumber = "54186"
AND av.ProductID IN (107))
OR
(av.SupplierID = 45
AND av.DataSupplierArticleNumber = "54182LL"
AND av.ProductID IN (107))
OR
(av.SupplierID = 45
AND av.DataSupplierArticleNumber = "54100"
AND av.ProductID IN (107))
OR
(av.SupplierID = 45
AND av.DataSupplierArticleNumber = "BL5221"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 45
AND av.DataSupplierArticleNumber = "54188"
AND av.ProductID IN (107))
OR
(av.SupplierID = 45
AND av.DataSupplierArticleNumber = "5221"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 45
AND av.DataSupplierArticleNumber = "54183"
AND av.ProductID IN (107))
OR
(av.SupplierID = 45
AND av.DataSupplierArticleNumber = "54180"
AND av.ProductID IN (107))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "99 90 6583"
AND av.ProductID IN (107))
OR
(av.SupplierID = 151
AND av.DataSupplierArticleNumber = "99 90 6580"
AND av.ProductID IN (107))
OR
(av.SupplierID = 209
AND av.DataSupplierArticleNumber = "88.58.101"
AND av.ProductID IN (107))
OR
(av.SupplierID = 209
AND av.DataSupplierArticleNumber = "88.58.103"
AND av.ProductID IN (107))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "032509"
AND av.ProductID IN (107))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "032006"
AND av.ProductID IN (107))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "032211"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "032513"
AND av.ProductID IN (107))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "032510"
AND av.ProductID IN (107))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "032007"
AND av.ProductID IN (107))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "032700"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "032116"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "032514"
AND av.ProductID IN (107))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "032511"
AND av.ProductID IN (107))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "032508"
AND av.ProductID IN (107))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "032118"
AND av.ProductID IN (1092))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "032515"
AND av.ProductID IN (107))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "032512"
AND av.ProductID IN (107))
OR
(av.SupplierID = 183
AND av.DataSupplierArticleNumber = "V99-84-0002"
AND av.ProductID IN (107))
OR
(av.SupplierID = 183
AND av.DataSupplierArticleNumber = "V99-84-0007"
AND av.ProductID IN (107))
)
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 = 11
AND aa.DataSupplierArticleNumber = "112554")
OR
(aa.SupplierID = 363
AND aa.DataSupplierArticleNumber = "70721023")
OR
(aa.SupplierID = 363
AND aa.DataSupplierArticleNumber = "70721012")
OR
(aa.SupplierID = 363
AND aa.DataSupplierArticleNumber = "79780235")
OR
(aa.SupplierID = 363
AND aa.DataSupplierArticleNumber = "70721062")
OR
(aa.SupplierID = 363
AND aa.DataSupplierArticleNumber = "70721055")
OR
(aa.SupplierID = 363
AND aa.DataSupplierArticleNumber = "70721013")
OR
(aa.SupplierID = 363
AND aa.DataSupplierArticleNumber = "79780237")
OR
(aa.SupplierID = 363
AND aa.DataSupplierArticleNumber = "79780230")
OR
(aa.SupplierID = 363
AND aa.DataSupplierArticleNumber = "70721056")
OR
(aa.SupplierID = 363
AND aa.DataSupplierArticleNumber = "70721021")
OR
(aa.SupplierID = 363
AND aa.DataSupplierArticleNumber = "79780232")
OR
(aa.SupplierID = 363
AND aa.DataSupplierArticleNumber = "70721061")
OR
(aa.SupplierID = 253
AND aa.DataSupplierArticleNumber = "LID10078")
OR
(aa.SupplierID = 253
AND aa.DataSupplierArticleNumber = "LID10079")
OR
(aa.SupplierID = 253
AND aa.DataSupplierArticleNumber = "9600080")
OR
(aa.SupplierID = 253
AND aa.DataSupplierArticleNumber = "9600081")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DB64150")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DB64193EXV-01B")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DB64193-01B")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DB7528")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DB64150EXV-01B")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DB64150-01B")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DB64193LLF")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DB64193BW")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DB64150LLF")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DB2825")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DB64150BW")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DB64193EXV")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DB64193")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DB6418")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DB64150EXV")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "06583")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "35752")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "93012846")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "98714")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "93011341")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "19759")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "93012270")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "98264")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "70244")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "17463")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "90902")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "97131")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "17138")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "17120")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "84489")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "93768")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "74154")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "93013292")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "35930")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "93012861")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "98715")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "34454")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "93012303")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "98281")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "76108")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "19682")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "91618")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "97132")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "27888")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "17123")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "84491")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "95396")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "12791")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "79298")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "93013293")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "73500")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "93013070")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "98716")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "35017")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "93012336")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "98282")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "77048")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "19686")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "93012268")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "98241")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "41961")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "17462")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "90901")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "95397")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "12904")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "79299")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "93361")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "74153")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "93013272")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "98717")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8GH 007 157-121")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8GJ 002 525-131")
OR
(aa.SupplierID = 72
AND aa.DataSupplierArticleNumber = "89901100")
OR
(aa.SupplierID = 72
AND aa.DataSupplierArticleNumber = "89901175")
OR
(aa.SupplierID = 72
AND aa.DataSupplierArticleNumber = "89901218")
OR
(aa.SupplierID = 72
AND aa.DataSupplierArticleNumber = "89901051")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "0805290")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "0800850")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "0805250")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "L10460-01")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "L10460B-02")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "L10460-02")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "L10460B")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "L10460")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "L10460B-01")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "103200")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "78-0088")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "78-0097")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "78-0044SET")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "78-0008")
OR
(aa.SupplierID = 485
AND aa.DataSupplierArticleNumber = "17177")
OR
(aa.SupplierID = 485
AND aa.DataSupplierArticleNumber = "48861")
OR
(aa.SupplierID = 485
AND aa.DataSupplierArticleNumber = "17189")
OR
(aa.SupplierID = 485
AND aa.DataSupplierArticleNumber = "48881")
OR
(aa.SupplierID = 485
AND aa.DataSupplierArticleNumber = "48889")
OR
(aa.SupplierID = 485
AND aa.DataSupplierArticleNumber = "48677")
OR
(aa.SupplierID = 4671
AND aa.DataSupplierArticleNumber = "N472EL-HCB")
OR
(aa.SupplierID = 4671
AND aa.DataSupplierArticleNumber = "N472")
OR
(aa.SupplierID = 4671
AND aa.DataSupplierArticleNumber = "N501")
OR
(aa.SupplierID = 4671
AND aa.DataSupplierArticleNumber = "N472-01B")
OR
(aa.SupplierID = 4671
AND aa.DataSupplierArticleNumber = "N501-02B")
OR
(aa.SupplierID = 4671
AND aa.DataSupplierArticleNumber = "N472B")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "2825")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "64193ULT-01B")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "64193SV2-01B")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "64193NR1-02B")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "64193NBU-01B")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "2825ULT-02B")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "64193CBI-01B")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "2825-02B")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "64193")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "64193ULT-HCB")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "64193SV2-HCB")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "64193NR5-01B")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "64193NBU-HCB")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "64193CBI-HCB")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "2825HCBI-02B")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "64193-01B")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "64193XR-02B")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "64193ULT")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "64193SV2")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "64193NR1-01B")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "64193NBU")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "2825ULT")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "64193CBI")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PLH4-60/55")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PLT10-12/5")
OR
(aa.SupplierID = 75
AND aa.DataSupplierArticleNumber = "12342XV+S2")
OR
(aa.SupplierID = 75
AND aa.DataSupplierArticleNumber = "12342WHVB1")
OR
(aa.SupplierID = 75
AND aa.DataSupplierArticleNumber = "12342PRC1")
OR
(aa.SupplierID = 75
AND aa.DataSupplierArticleNumber = "12961LLECOCP")
OR
(aa.SupplierID = 75
AND aa.DataSupplierArticleNumber = "12342LLECOC1")
OR
(aa.SupplierID = 75
AND aa.DataSupplierArticleNumber = "12961CP")
OR
(aa.SupplierID = 75
AND aa.DataSupplierArticleNumber = "12342WHVSM")
OR
(aa.SupplierID = 75
AND aa.DataSupplierArticleNumber = "12342VPB1")
OR
(aa.SupplierID = 75
AND aa.DataSupplierArticleNumber = "12961NBVB2")
OR
(aa.SupplierID = 75
AND aa.DataSupplierArticleNumber = "12342LLECOS2")
OR
(aa.SupplierID = 75
AND aa.DataSupplierArticleNumber = "12961EDCP")
OR
(aa.SupplierID = 75
AND aa.DataSupplierArticleNumber = "12342XV+B1")
OR
(aa.SupplierID = 75
AND aa.DataSupplierArticleNumber = "12342VPS2")
OR
(aa.SupplierID = 75
AND aa.DataSupplierArticleNumber = "12342PRB1")
OR
(aa.SupplierID = 75
AND aa.DataSupplierArticleNumber = "12961LLECOB2")
OR
(aa.SupplierID = 75
AND aa.DataSupplierArticleNumber = "12342LLECOB1")
OR
(aa.SupplierID = 75
AND aa.DataSupplierArticleNumber = "12961B2")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "202792")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "202112")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "202013")
OR
(aa.SupplierID = 45
AND aa.DataSupplierArticleNumber = "BL54182")
OR
(aa.SupplierID = 45
AND aa.DataSupplierArticleNumber = "5221L")
OR
(aa.SupplierID = 45
AND aa.DataSupplierArticleNumber = "54185")
OR
(aa.SupplierID = 45
AND aa.DataSupplierArticleNumber = "54182")
OR
(aa.SupplierID = 45
AND aa.DataSupplierArticleNumber = "54080")
OR
(aa.SupplierID = 45
AND aa.DataSupplierArticleNumber = "5224")
OR
(aa.SupplierID = 45
AND aa.DataSupplierArticleNumber = "54186")
OR
(aa.SupplierID = 45
AND aa.DataSupplierArticleNumber = "54182LL")
OR
(aa.SupplierID = 45
AND aa.DataSupplierArticleNumber = "54100")
OR
(aa.SupplierID = 45
AND aa.DataSupplierArticleNumber = "BL5221")
OR
(aa.SupplierID = 45
AND aa.DataSupplierArticleNumber = "54188")
OR
(aa.SupplierID = 45
AND aa.DataSupplierArticleNumber = "5221")
OR
(aa.SupplierID = 45
AND aa.DataSupplierArticleNumber = "54183")
OR
(aa.SupplierID = 45
AND aa.DataSupplierArticleNumber = "54180")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "99 90 6583")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "99 90 6580")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "88.58.101")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "88.58.103")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "032509")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "032006")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "032211")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "032513")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "032510")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "032007")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "032700")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "032116")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "032514")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "032511")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "032508")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "032118")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "032515")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "032512")
OR
(aa.SupplierID = 183
AND aa.DataSupplierArticleNumber = "V99-84-0002")
OR
(aa.SupplierID = 183
AND aa.DataSupplierArticleNumber = "V99-84-0007")
)
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 = 11
AND aa.DataSupplierArticleNumber = "112554")
OR
(aa.SupplierID = 363
AND aa.DataSupplierArticleNumber = "70721023")
OR
(aa.SupplierID = 363
AND aa.DataSupplierArticleNumber = "70721012")
OR
(aa.SupplierID = 363
AND aa.DataSupplierArticleNumber = "79780235")
OR
(aa.SupplierID = 363
AND aa.DataSupplierArticleNumber = "70721062")
OR
(aa.SupplierID = 363
AND aa.DataSupplierArticleNumber = "70721055")
OR
(aa.SupplierID = 363
AND aa.DataSupplierArticleNumber = "70721013")
OR
(aa.SupplierID = 363
AND aa.DataSupplierArticleNumber = "79780237")
OR
(aa.SupplierID = 363
AND aa.DataSupplierArticleNumber = "79780230")
OR
(aa.SupplierID = 363
AND aa.DataSupplierArticleNumber = "70721056")
OR
(aa.SupplierID = 363
AND aa.DataSupplierArticleNumber = "70721021")
OR
(aa.SupplierID = 363
AND aa.DataSupplierArticleNumber = "79780232")
OR
(aa.SupplierID = 363
AND aa.DataSupplierArticleNumber = "70721061")
OR
(aa.SupplierID = 253
AND aa.DataSupplierArticleNumber = "LID10078")
OR
(aa.SupplierID = 253
AND aa.DataSupplierArticleNumber = "LID10079")
OR
(aa.SupplierID = 253
AND aa.DataSupplierArticleNumber = "9600080")
OR
(aa.SupplierID = 253
AND aa.DataSupplierArticleNumber = "9600081")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DB64150")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DB64193EXV-01B")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DB64193-01B")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DB7528")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DB64150EXV-01B")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DB64150-01B")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DB64193LLF")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DB64193BW")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DB64150LLF")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DB2825")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DB64150BW")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DB64193EXV")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DB64193")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DB6418")
OR
(aa.SupplierID = 4318
AND aa.DataSupplierArticleNumber = "DB64150EXV")
OR
(aa.SupplierID = 101
AND aa.DataSupplierArticleNumber = "06583")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "35752")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "93012846")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "98714")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "93011341")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "19759")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "93012270")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "98264")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "70244")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "17463")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "90902")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "97131")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "17138")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "17120")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "84489")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "93768")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "74154")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "93013292")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "35930")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "93012861")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "98715")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "34454")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "93012303")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "98281")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "76108")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "19682")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "91618")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "97132")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "27888")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "17123")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "84491")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "95396")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "12791")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "79298")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "93013293")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "73500")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "93013070")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "98716")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "35017")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "93012336")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "98282")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "77048")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "19686")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "93012268")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "98241")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "41961")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "17462")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "90901")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "95397")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "12904")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "79299")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "93361")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "74153")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "93013272")
OR
(aa.SupplierID = 4612
AND aa.DataSupplierArticleNumber = "98717")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8GH 007 157-121")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8GJ 002 525-131")
OR
(aa.SupplierID = 72
AND aa.DataSupplierArticleNumber = "89901100")
OR
(aa.SupplierID = 72
AND aa.DataSupplierArticleNumber = "89901175")
OR
(aa.SupplierID = 72
AND aa.DataSupplierArticleNumber = "89901218")
OR
(aa.SupplierID = 72
AND aa.DataSupplierArticleNumber = "89901051")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "0805290")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "0800850")
OR
(aa.SupplierID = 4546
AND aa.DataSupplierArticleNumber = "0805250")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "L10460-01")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "L10460B-02")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "L10460-02")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "L10460B")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "L10460")
OR
(aa.SupplierID = 4600
AND aa.DataSupplierArticleNumber = "L10460B-01")
OR
(aa.SupplierID = 133
AND aa.DataSupplierArticleNumber = "103200")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "78-0088")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "78-0097")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "78-0044SET")
OR
(aa.SupplierID = 403
AND aa.DataSupplierArticleNumber = "78-0008")
OR
(aa.SupplierID = 485
AND aa.DataSupplierArticleNumber = "17177")
OR
(aa.SupplierID = 485
AND aa.DataSupplierArticleNumber = "48861")
OR
(aa.SupplierID = 485
AND aa.DataSupplierArticleNumber = "17189")
OR
(aa.SupplierID = 485
AND aa.DataSupplierArticleNumber = "48881")
OR
(aa.SupplierID = 485
AND aa.DataSupplierArticleNumber = "48889")
OR
(aa.SupplierID = 485
AND aa.DataSupplierArticleNumber = "48677")
OR
(aa.SupplierID = 4671
AND aa.DataSupplierArticleNumber = "N472EL-HCB")
OR
(aa.SupplierID = 4671
AND aa.DataSupplierArticleNumber = "N472")
OR
(aa.SupplierID = 4671
AND aa.DataSupplierArticleNumber = "N501")
OR
(aa.SupplierID = 4671
AND aa.DataSupplierArticleNumber = "N472-01B")
OR
(aa.SupplierID = 4671
AND aa.DataSupplierArticleNumber = "N501-02B")
OR
(aa.SupplierID = 4671
AND aa.DataSupplierArticleNumber = "N472B")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "2825")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "64193ULT-01B")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "64193SV2-01B")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "64193NR1-02B")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "64193NBU-01B")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "2825ULT-02B")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "64193CBI-01B")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "2825-02B")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "64193")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "64193ULT-HCB")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "64193SV2-HCB")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "64193NR5-01B")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "64193NBU-HCB")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "64193CBI-HCB")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "2825HCBI-02B")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "64193-01B")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "64193XR-02B")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "64193ULT")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "64193SV2")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "64193NR1-01B")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "64193NBU")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "2825ULT")
OR
(aa.SupplierID = 67
AND aa.DataSupplierArticleNumber = "64193CBI")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PLH4-60/55")
OR
(aa.SupplierID = 4558
AND aa.DataSupplierArticleNumber = "PLT10-12/5")
OR
(aa.SupplierID = 75
AND aa.DataSupplierArticleNumber = "12342XV+S2")
OR
(aa.SupplierID = 75
AND aa.DataSupplierArticleNumber = "12342WHVB1")
OR
(aa.SupplierID = 75
AND aa.DataSupplierArticleNumber = "12342PRC1")
OR
(aa.SupplierID = 75
AND aa.DataSupplierArticleNumber = "12961LLECOCP")
OR
(aa.SupplierID = 75
AND aa.DataSupplierArticleNumber = "12342LLECOC1")
OR
(aa.SupplierID = 75
AND aa.DataSupplierArticleNumber = "12961CP")
OR
(aa.SupplierID = 75
AND aa.DataSupplierArticleNumber = "12342WHVSM")
OR
(aa.SupplierID = 75
AND aa.DataSupplierArticleNumber = "12342VPB1")
OR
(aa.SupplierID = 75
AND aa.DataSupplierArticleNumber = "12961NBVB2")
OR
(aa.SupplierID = 75
AND aa.DataSupplierArticleNumber = "12342LLECOS2")
OR
(aa.SupplierID = 75
AND aa.DataSupplierArticleNumber = "12961EDCP")
OR
(aa.SupplierID = 75
AND aa.DataSupplierArticleNumber = "12342XV+B1")
OR
(aa.SupplierID = 75
AND aa.DataSupplierArticleNumber = "12342VPS2")
OR
(aa.SupplierID = 75
AND aa.DataSupplierArticleNumber = "12342PRB1")
OR
(aa.SupplierID = 75
AND aa.DataSupplierArticleNumber = "12961LLECOB2")
OR
(aa.SupplierID = 75
AND aa.DataSupplierArticleNumber = "12342LLECOB1")
OR
(aa.SupplierID = 75
AND aa.DataSupplierArticleNumber = "12961B2")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "202792")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "202112")
OR
(aa.SupplierID = 225
AND aa.DataSupplierArticleNumber = "202013")
OR
(aa.SupplierID = 45
AND aa.DataSupplierArticleNumber = "BL54182")
OR
(aa.SupplierID = 45
AND aa.DataSupplierArticleNumber = "5221L")
OR
(aa.SupplierID = 45
AND aa.DataSupplierArticleNumber = "54185")
OR
(aa.SupplierID = 45
AND aa.DataSupplierArticleNumber = "54182")
OR
(aa.SupplierID = 45
AND aa.DataSupplierArticleNumber = "54080")
OR
(aa.SupplierID = 45
AND aa.DataSupplierArticleNumber = "5224")
OR
(aa.SupplierID = 45
AND aa.DataSupplierArticleNumber = "54186")
OR
(aa.SupplierID = 45
AND aa.DataSupplierArticleNumber = "54182LL")
OR
(aa.SupplierID = 45
AND aa.DataSupplierArticleNumber = "54100")
OR
(aa.SupplierID = 45
AND aa.DataSupplierArticleNumber = "BL5221")
OR
(aa.SupplierID = 45
AND aa.DataSupplierArticleNumber = "54188")
OR
(aa.SupplierID = 45
AND aa.DataSupplierArticleNumber = "5221")
OR
(aa.SupplierID = 45
AND aa.DataSupplierArticleNumber = "54183")
OR
(aa.SupplierID = 45
AND aa.DataSupplierArticleNumber = "54180")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "99 90 6583")
OR
(aa.SupplierID = 151
AND aa.DataSupplierArticleNumber = "99 90 6580")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "88.58.101")
OR
(aa.SupplierID = 209
AND aa.DataSupplierArticleNumber = "88.58.103")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "032509")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "032006")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "032211")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "032513")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "032510")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "032007")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "032700")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "032116")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "032514")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "032511")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "032508")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "032118")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "032515")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "032512")
OR
(aa.SupplierID = 183
AND aa.DataSupplierArticleNumber = "V99-84-0002")
OR
(aa.SupplierID = 183
AND aa.DataSupplierArticleNumber = "V99-84-0007")
)
AND aa.Language = "ru"
Продажа автозапчастей типа Лампа накаливания основной фары для автомобилей
