#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2M3x8bW9kZWxfaWQ9PTE5NjF8fG1kZl9pZD09MF44MjE4fHxzcGFyZV9pZD09MTAwMzUw&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 = "8218"
AND (
(av.SupplierID = 4528
AND av.DataSupplierArticleNumber = "301155RI"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4528
AND av.DataSupplierArticleNumber = "30639RI"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4528
AND av.DataSupplierArticleNumber = "301043RI"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4528
AND av.DataSupplierArticleNumber = "30637RI"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4528
AND av.DataSupplierArticleNumber = "301065RI"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4528
AND av.DataSupplierArticleNumber = "301098RI"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4528
AND av.DataSupplierArticleNumber = "30638RI"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4534
AND av.DataSupplierArticleNumber = "AL3696"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4534
AND av.DataSupplierArticleNumber = "AL3379"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4534
AND av.DataSupplierArticleNumber = "AL3699"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4534
AND av.DataSupplierArticleNumber = "AL3483"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4534
AND av.DataSupplierArticleNumber = "AL3253"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4534
AND av.DataSupplierArticleNumber = "AL3580"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4534
AND av.DataSupplierArticleNumber = "AL3297"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4843
AND av.DataSupplierArticleNumber = "A3022"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4843
AND av.DataSupplierArticleNumber = "A0163"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4843
AND av.DataSupplierArticleNumber = "A3039"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4843
AND av.DataSupplierArticleNumber = "A0381"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4843
AND av.DataSupplierArticleNumber = "A3096"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4843
AND av.DataSupplierArticleNumber = "A3015"
AND av.ProductID IN (4))
OR
(av.SupplierID = 412
AND av.DataSupplierArticleNumber = "L 39 300"
AND av.ProductID IN (4))
OR
(av.SupplierID = 412
AND av.DataSupplierArticleNumber = "L 39 760"
AND av.ProductID IN (4))
OR
(av.SupplierID = 412
AND av.DataSupplierArticleNumber = "L 38 740"
AND av.ProductID IN (4))
OR
(av.SupplierID = 412
AND av.DataSupplierArticleNumber = "L 39 940"
AND av.ProductID IN (4))
OR
(av.SupplierID = 412
AND av.DataSupplierArticleNumber = "L 38 780"
AND av.ProductID IN (4))
OR
(av.SupplierID = 412
AND av.DataSupplierArticleNumber = "L 40 210"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4464
AND av.DataSupplierArticleNumber = "AVA206A"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4464
AND av.DataSupplierArticleNumber = "AVA158"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4464
AND av.DataSupplierArticleNumber = "AVA152A"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4464
AND av.DataSupplierArticleNumber = "AVA158A"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4464
AND av.DataSupplierArticleNumber = "AVA152C"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4464
AND av.DataSupplierArticleNumber = "AVA144"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4464
AND av.DataSupplierArticleNumber = "AVA206"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4464
AND av.DataSupplierArticleNumber = "AVA154A"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4464
AND av.DataSupplierArticleNumber = "AVA144A"
AND av.ProductID IN (4))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BBA2216"
AND av.ProductID IN (4))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BBA2237"
AND av.ProductID IN (4))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BBA2023"
AND av.ProductID IN (4))
OR
(av.SupplierID = 475
AND av.DataSupplierArticleNumber = "BBA2024"
AND av.ProductID IN (4))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "0 986 040 210"
AND av.ProductID IN (4))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "0 986 039 300"
AND av.ProductID IN (4))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "0 123 310 012"
AND av.ProductID IN (4))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "0 986 039 760"
AND av.ProductID IN (4))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "0 986 038 740"
AND av.ProductID IN (4))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "0 120 335 012"
AND av.ProductID IN (4))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "0 986 039 941"
AND av.ProductID IN (4))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "0 986 038 781"
AND av.ProductID IN (4))
OR
(av.SupplierID = 30
AND av.DataSupplierArticleNumber = "0 123 310 010"
AND av.ProductID IN (4))
OR
(av.SupplierID = 177
AND av.DataSupplierArticleNumber = "L610222"
AND av.ProductID IN (4))
OR
(av.SupplierID = 177
AND av.DataSupplierArticleNumber = "L611454"
AND av.ProductID IN (4))
OR
(av.SupplierID = 177
AND av.DataSupplierArticleNumber = "L610100"
AND av.ProductID IN (4))
OR
(av.SupplierID = 484
AND av.DataSupplierArticleNumber = "CAL15206GS"
AND av.ProductID IN (4))
OR
(av.SupplierID = 484
AND av.DataSupplierArticleNumber = "CAL15158AS"
AND av.ProductID IN (4))
OR
(av.SupplierID = 484
AND av.DataSupplierArticleNumber = "CAL15152RS"
AND av.ProductID IN (4))
OR
(av.SupplierID = 484
AND av.DataSupplierArticleNumber = "CAL15144AS"
AND av.ProductID IN (4))
OR
(av.SupplierID = 484
AND av.DataSupplierArticleNumber = "CAL15158GS"
AND av.ProductID IN (4))
OR
(av.SupplierID = 484
AND av.DataSupplierArticleNumber = "CAL15153AS"
AND av.ProductID IN (4))
OR
(av.SupplierID = 484
AND av.DataSupplierArticleNumber = "CAL15144GS"
AND av.ProductID IN (4))
OR
(av.SupplierID = 484
AND av.DataSupplierArticleNumber = "CAL15206AS"
AND av.ProductID IN (4))
OR
(av.SupplierID = 484
AND av.DataSupplierArticleNumber = "CAL15154AS"
AND av.ProductID IN (4))
OR
(av.SupplierID = 484
AND av.DataSupplierArticleNumber = "CAL15152AS"
AND av.ProductID IN (4))
OR
(av.SupplierID = 484
AND av.DataSupplierArticleNumber = "CAL15120AS"
AND av.ProductID IN (4))
OR
(av.SupplierID = 393
AND av.DataSupplierArticleNumber = "4916"
AND av.ProductID IN (4))
OR
(av.SupplierID = 393
AND av.DataSupplierArticleNumber = "4410"
AND av.ProductID IN (4))
OR
(av.SupplierID = 393
AND av.DataSupplierArticleNumber = "4426"
AND av.ProductID IN (4))
OR
(av.SupplierID = 393
AND av.DataSupplierArticleNumber = "4328"
AND av.ProductID IN (4))
OR
(av.SupplierID = 393
AND av.DataSupplierArticleNumber = "4430"
AND av.ProductID IN (4))
OR
(av.SupplierID = 393
AND av.DataSupplierArticleNumber = "4330"
AND av.ProductID IN (4))
OR
(av.SupplierID = 460
AND av.DataSupplierArticleNumber = "216109802"
AND av.ProductID IN (4))
OR
(av.SupplierID = 460
AND av.DataSupplierArticleNumber = "200132802"
AND av.ProductID IN (4))
OR
(av.SupplierID = 460
AND av.DataSupplierArticleNumber = "216112802"
AND av.ProductID IN (4))
OR
(av.SupplierID = 460
AND av.DataSupplierArticleNumber = "200132902"
AND av.ProductID IN (4))
OR
(av.SupplierID = 460
AND av.DataSupplierArticleNumber = "2001321202"
AND av.ProductID IN (4))
OR
(av.SupplierID = 460
AND av.DataSupplierArticleNumber = "216109702"
AND av.ProductID IN (4))
OR
(av.SupplierID = 460
AND av.DataSupplierArticleNumber = "200132702"
AND av.ProductID IN (4))
OR
(av.SupplierID = 391
AND av.DataSupplierArticleNumber = "56545"
AND av.ProductID IN (4))
OR
(av.SupplierID = 391
AND av.DataSupplierArticleNumber = "56299"
AND av.ProductID IN (4))
OR
(av.SupplierID = 391
AND av.DataSupplierArticleNumber = "56224"
AND av.ProductID IN (4))
OR
(av.SupplierID = 391
AND av.DataSupplierArticleNumber = "56596"
AND av.ProductID IN (4))
OR
(av.SupplierID = 391
AND av.DataSupplierArticleNumber = "56549"
AND av.ProductID IN (4))
OR
(av.SupplierID = 391
AND av.DataSupplierArticleNumber = "56410"
AND av.ProductID IN (4))
OR
(av.SupplierID = 391
AND av.DataSupplierArticleNumber = "56225"
AND av.ProductID IN (4))
OR
(av.SupplierID = 391
AND av.DataSupplierArticleNumber = "56558"
AND av.ProductID IN (4))
OR
(av.SupplierID = 391
AND av.DataSupplierArticleNumber = "56503"
AND av.ProductID IN (4))
OR
(av.SupplierID = 391
AND av.DataSupplierArticleNumber = "56229"
AND av.ProductID IN (4))
OR
(av.SupplierID = 391
AND av.DataSupplierArticleNumber = "55712"
AND av.ProductID IN (4))
OR
(av.SupplierID = 391
AND av.DataSupplierArticleNumber = "56587"
AND av.ProductID IN (4))
OR
(av.SupplierID = 226
AND av.DataSupplierArticleNumber = "28-2882"
AND av.ProductID IN (4))
OR
(av.SupplierID = 226
AND av.DataSupplierArticleNumber = "28-2592"
AND av.ProductID IN (4))
OR
(av.SupplierID = 226
AND av.DataSupplierArticleNumber = "28-2925"
AND av.ProductID IN (4))
OR
(av.SupplierID = 226
AND av.DataSupplierArticleNumber = "28-2690"
AND av.ProductID IN (4))
OR
(av.SupplierID = 226
AND av.DataSupplierArticleNumber = "28-1970"
AND av.ProductID IN (4))
OR
(av.SupplierID = 226
AND av.DataSupplierArticleNumber = "28-2795"
AND av.ProductID IN (4))
OR
(av.SupplierID = 226
AND av.DataSupplierArticleNumber = "28-1973"
AND av.ProductID IN (4))
OR
(av.SupplierID = 234
AND av.DataSupplierArticleNumber = "210229"
AND av.ProductID IN (4))
OR
(av.SupplierID = 234
AND av.DataSupplierArticleNumber = "210096"
AND av.ProductID IN (4))
OR
(av.SupplierID = 234
AND av.DataSupplierArticleNumber = "210338"
AND av.ProductID IN (4))
OR
(av.SupplierID = 234
AND av.DataSupplierArticleNumber = "210169"
AND av.ProductID IN (4))
OR
(av.SupplierID = 234
AND av.DataSupplierArticleNumber = "210216"
AND av.ProductID IN (4))
OR
(av.SupplierID = 234
AND av.DataSupplierArticleNumber = "210021"
AND av.ProductID IN (4))
OR
(av.SupplierID = 224
AND av.DataSupplierArticleNumber = "RE7434N"
AND av.ProductID IN (4))
OR
(av.SupplierID = 224
AND av.DataSupplierArticleNumber = "RE72039N"
AND av.ProductID IN (4))
OR
(av.SupplierID = 224
AND av.DataSupplierArticleNumber = "RE73606N"
AND av.ProductID IN (4))
OR
(av.SupplierID = 337
AND av.DataSupplierArticleNumber = "12039940"
AND av.ProductID IN (4))
OR
(av.SupplierID = 337
AND av.DataSupplierArticleNumber = "12038780"
AND av.ProductID IN (4))
OR
(av.SupplierID = 337
AND av.DataSupplierArticleNumber = "12040210"
AND av.ProductID IN (4))
OR
(av.SupplierID = 337
AND av.DataSupplierArticleNumber = "12039300"
AND av.ProductID IN (4))
OR
(av.SupplierID = 337
AND av.DataSupplierArticleNumber = "12038720"
AND av.ProductID IN (4))
OR
(av.SupplierID = 337
AND av.DataSupplierArticleNumber = "12060007"
AND av.ProductID IN (4))
OR
(av.SupplierID = 337
AND av.DataSupplierArticleNumber = "12039760"
AND av.ProductID IN (4))
OR
(av.SupplierID = 337
AND av.DataSupplierArticleNumber = "12038740"
AND av.ProductID IN (4))
OR
(av.SupplierID = 90
AND av.DataSupplierArticleNumber = "118452"
AND av.ProductID IN (4))
OR
(av.SupplierID = 90
AND av.DataSupplierArticleNumber = "118837"
AND av.ProductID IN (4))
OR
(av.SupplierID = 90
AND av.DataSupplierArticleNumber = "118673"
AND av.ProductID IN (4))
OR
(av.SupplierID = 90
AND av.DataSupplierArticleNumber = "118447"
AND av.ProductID IN (4))
OR
(av.SupplierID = 90
AND av.DataSupplierArticleNumber = "118838"
AND av.ProductID IN (4))
OR
(av.SupplierID = 90
AND av.DataSupplierArticleNumber = "118793"
AND av.ProductID IN (4))
OR
(av.SupplierID = 90
AND av.DataSupplierArticleNumber = "118449"
AND av.ProductID IN (4))
OR
(av.SupplierID = 90
AND av.DataSupplierArticleNumber = "118835"
AND av.ProductID IN (4))
OR
(av.SupplierID = 87
AND av.DataSupplierArticleNumber = "9040211"
AND av.ProductID IN (4))
OR
(av.SupplierID = 87
AND av.DataSupplierArticleNumber = "9039300"
AND av.ProductID IN (4))
OR
(av.SupplierID = 87
AND av.DataSupplierArticleNumber = "9039760"
AND av.ProductID IN (4))
OR
(av.SupplierID = 87
AND av.DataSupplierArticleNumber = "9038740"
AND av.ProductID IN (4))
OR
(av.SupplierID = 87
AND av.DataSupplierArticleNumber = "9039941"
AND av.ProductID IN (4))
OR
(av.SupplierID = 87
AND av.DataSupplierArticleNumber = "9038781"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4379
AND av.DataSupplierArticleNumber = "6 3098 9"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4819
AND av.DataSupplierArticleNumber = "112688"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4819
AND av.DataSupplierArticleNumber = "111893"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4819
AND av.DataSupplierArticleNumber = "112703"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4819
AND av.DataSupplierArticleNumber = "112230"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4819
AND av.DataSupplierArticleNumber = "113485"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4819
AND av.DataSupplierArticleNumber = "112292"
AND av.ProductID IN (4))
OR
(av.SupplierID = 425
AND av.DataSupplierArticleNumber = "CA1155IR"
AND av.ProductID IN (4))
OR
(av.SupplierID = 425
AND av.DataSupplierArticleNumber = "CA1043IR"
AND av.ProductID IN (4))
OR
(av.SupplierID = 425
AND av.DataSupplierArticleNumber = "CA637IR"
AND av.ProductID IN (4))
OR
(av.SupplierID = 425
AND av.DataSupplierArticleNumber = "CA1065IR"
AND av.ProductID IN (4))
OR
(av.SupplierID = 425
AND av.DataSupplierArticleNumber = "CA638IR"
AND av.ProductID IN (4))
OR
(av.SupplierID = 425
AND av.DataSupplierArticleNumber = "CA1098IR"
AND av.ProductID IN (4))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "8EL 737 202-001"
AND av.ProductID IN (4))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "8EL 732 715-001"
AND av.ProductID IN (4))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "8EL 012 427-271"
AND av.ProductID IN (4))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "8EL 011 710-141"
AND av.ProductID IN (4))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "8EL 737 014-001"
AND av.ProductID IN (4))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "8EL 725 921-001"
AND av.ProductID IN (4))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "8EL 011 710-991"
AND av.ProductID IN (4))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "8EL 011 710-051"
AND av.ProductID IN (4))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "8EL 737 047-001"
AND av.ProductID IN (4))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "8EL 725 922-001"
AND av.ProductID IN (4))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "8EL 011 711-001"
AND av.ProductID IN (4))
OR
(av.SupplierID = 2
AND av.DataSupplierArticleNumber = "8EL 011 710-091"
AND av.ProductID IN (4))
OR
(av.SupplierID = 72
AND av.DataSupplierArticleNumber = "32040211"
AND av.ProductID IN (4))
OR
(av.SupplierID = 72
AND av.DataSupplierArticleNumber = "32038740"
AND av.ProductID IN (4))
OR
(av.SupplierID = 72
AND av.DataSupplierArticleNumber = "32038781"
AND av.ProductID IN (4))
OR
(av.SupplierID = 72
AND av.DataSupplierArticleNumber = "32039300"
AND av.ProductID IN (4))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "3190100509"
AND av.ProductID IN (4))
OR
(av.SupplierID = 268
AND av.DataSupplierArticleNumber = "4190101200"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4496
AND av.DataSupplierArticleNumber = "11.1065"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4496
AND av.DataSupplierArticleNumber = "11.0637"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4496
AND av.DataSupplierArticleNumber = "11.1098"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4496
AND av.DataSupplierArticleNumber = "11.0638"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4496
AND av.DataSupplierArticleNumber = "11.1155"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4496
AND av.DataSupplierArticleNumber = "11.1043"
AND av.ProductID IN (4))
OR
(av.SupplierID = 20
AND av.DataSupplierArticleNumber = "LRB00312"
AND av.ProductID IN (4))
OR
(av.SupplierID = 20
AND av.DataSupplierArticleNumber = "LRB00280"
AND av.ProductID IN (4))
OR
(av.SupplierID = 20
AND av.DataSupplierArticleNumber = "LRA01448"
AND av.ProductID IN (4))
OR
(av.SupplierID = 20
AND av.DataSupplierArticleNumber = "LRB00281"
AND av.ProductID IN (4))
OR
(av.SupplierID = 20
AND av.DataSupplierArticleNumber = "LRB00183"
AND av.ProductID IN (4))
OR
(av.SupplierID = 20
AND av.DataSupplierArticleNumber = "LRB00311"
AND av.ProductID IN (4))
OR
(av.SupplierID = 20
AND av.DataSupplierArticleNumber = "LRB00184"
AND av.ProductID IN (4))
OR
(av.SupplierID = 95
AND av.DataSupplierArticleNumber = "944390397600"
AND av.ProductID IN (4))
OR
(av.SupplierID = 95
AND av.DataSupplierArticleNumber = "943356967010"
AND av.ProductID IN (4))
OR
(av.SupplierID = 95
AND av.DataSupplierArticleNumber = "943356574010"
AND av.ProductID IN (4))
OR
(av.SupplierID = 95
AND av.DataSupplierArticleNumber = "944390399410"
AND av.ProductID IN (4))
OR
(av.SupplierID = 95
AND av.DataSupplierArticleNumber = "943356974010"
AND av.ProductID IN (4))
OR
(av.SupplierID = 95
AND av.DataSupplierArticleNumber = "943356576010"
AND av.ProductID IN (4))
OR
(av.SupplierID = 95
AND av.DataSupplierArticleNumber = "944390387400"
AND av.ProductID IN (4))
OR
(av.SupplierID = 95
AND av.DataSupplierArticleNumber = "943356577010"
AND av.ProductID IN (4))
OR
(av.SupplierID = 95
AND av.DataSupplierArticleNumber = "943346223010"
AND av.ProductID IN (4))
OR
(av.SupplierID = 287
AND av.DataSupplierArticleNumber = "MG 96"
AND av.ProductID IN (4))
OR
(av.SupplierID = 287
AND av.DataSupplierArticleNumber = "MG 387"
AND av.ProductID IN (4))
OR
(av.SupplierID = 287
AND av.DataSupplierArticleNumber = "MG 418"
AND av.ProductID IN (4))
OR
(av.SupplierID = 287
AND av.DataSupplierArticleNumber = "MG 422"
AND av.ProductID IN (4))
OR
(av.SupplierID = 342
AND av.DataSupplierArticleNumber = "210021"
AND av.ProductID IN (4))
OR
(av.SupplierID = 342
AND av.DataSupplierArticleNumber = "210229"
AND av.ProductID IN (4))
OR
(av.SupplierID = 342
AND av.DataSupplierArticleNumber = "210096"
AND av.ProductID IN (4))
OR
(av.SupplierID = 342
AND av.DataSupplierArticleNumber = "210338"
AND av.ProductID IN (4))
OR
(av.SupplierID = 342
AND av.DataSupplierArticleNumber = "210169"
AND av.ProductID IN (4))
OR
(av.SupplierID = 342
AND av.DataSupplierArticleNumber = "210216"
AND av.ProductID IN (4))
OR
(av.SupplierID = 440
AND av.DataSupplierArticleNumber = "DAN641"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4380
AND av.DataSupplierArticleNumber = "2137036"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4380
AND av.DataSupplierArticleNumber = "2137020"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4380
AND av.DataSupplierArticleNumber = "2137030"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4380
AND av.DataSupplierArticleNumber = "2137014"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4380
AND av.DataSupplierArticleNumber = "2137034"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4380
AND av.DataSupplierArticleNumber = "2137018"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4543
AND av.DataSupplierArticleNumber = "9213045"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4543
AND av.DataSupplierArticleNumber = "89213904"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4543
AND av.DataSupplierArticleNumber = "89212938"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4543
AND av.DataSupplierArticleNumber = "9213904"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4543
AND av.DataSupplierArticleNumber = "9212916"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4543
AND av.DataSupplierArticleNumber = "89212971"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4543
AND av.DataSupplierArticleNumber = "89212735"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4543
AND av.DataSupplierArticleNumber = "9212938"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4543
AND av.DataSupplierArticleNumber = "89213045"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4543
AND av.DataSupplierArticleNumber = "89212916"
AND av.ProductID IN (4))
OR
(av.SupplierID = 396
AND av.DataSupplierArticleNumber = "35214950"
AND av.ProductID IN (4))
OR
(av.SupplierID = 396
AND av.DataSupplierArticleNumber = "20110280"
AND av.ProductID IN (4))
OR
(av.SupplierID = 396
AND av.DataSupplierArticleNumber = "20110281"
AND av.ProductID IN (4))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "QRA1806"
AND av.ProductID IN (4))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "QRA1902"
AND av.ProductID IN (4))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "QRA1034"
AND av.ProductID IN (4))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "QRA1909"
AND av.ProductID IN (4))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "QRA1784"
AND av.ProductID IN (4))
OR
(av.SupplierID = 57
AND av.DataSupplierArticleNumber = "QRA2965"
AND av.ProductID IN (4))
OR
(av.SupplierID = 214
AND av.DataSupplierArticleNumber = "RAA14347"
AND av.ProductID IN (4))
OR
(av.SupplierID = 214
AND av.DataSupplierArticleNumber = "RAA10411"
AND av.ProductID IN (4))
OR
(av.SupplierID = 214
AND av.DataSupplierArticleNumber = "DRB0211"
AND av.ProductID IN (4))
OR
(av.SupplierID = 214
AND av.DataSupplierArticleNumber = "DRA9300"
AND av.ProductID IN (4))
OR
(av.SupplierID = 214
AND av.DataSupplierArticleNumber = "DRA3234"
AND av.ProductID IN (4))
OR
(av.SupplierID = 214
AND av.DataSupplierArticleNumber = "RAA21322"
AND av.ProductID IN (4))
OR
(av.SupplierID = 214
AND av.DataSupplierArticleNumber = "RAA10871"
AND av.ProductID IN (4))
OR
(av.SupplierID = 214
AND av.DataSupplierArticleNumber = "DRB0211N"
AND av.ProductID IN (4))
OR
(av.SupplierID = 214
AND av.DataSupplierArticleNumber = "DRA9760"
AND av.ProductID IN (4))
OR
(av.SupplierID = 214
AND av.DataSupplierArticleNumber = "DRA3236"
AND av.ProductID IN (4))
OR
(av.SupplierID = 214
AND av.DataSupplierArticleNumber = "RAA14345"
AND av.ProductID IN (4))
OR
(av.SupplierID = 214
AND av.DataSupplierArticleNumber = "RAA10052"
AND av.ProductID IN (4))
OR
(av.SupplierID = 214
AND av.DataSupplierArticleNumber = "DRA9941"
AND av.ProductID IN (4))
OR
(av.SupplierID = 214
AND av.DataSupplierArticleNumber = "DRA3236N"
AND av.ProductID IN (4))
OR
(av.SupplierID = 360
AND av.DataSupplierArticleNumber = "212507"
AND av.ProductID IN (4))
OR
(av.SupplierID = 360
AND av.DataSupplierArticleNumber = "212508"
AND av.ProductID IN (4))
OR
(av.SupplierID = 360
AND av.DataSupplierArticleNumber = "212503"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4620
AND av.DataSupplierArticleNumber = "F042A0B023"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4620
AND av.DataSupplierArticleNumber = "F032UA0028"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4620
AND av.DataSupplierArticleNumber = "F032UA0034"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4620
AND av.DataSupplierArticleNumber = "F042A0B008"
AND av.ProductID IN (4))
OR
(av.SupplierID = 4620
AND av.DataSupplierArticleNumber = "F032UA0027"
AND av.ProductID IN (4))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "436613"
AND av.ProductID IN (4))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "436339"
AND av.ProductID IN (4))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "433189"
AND av.ProductID IN (4))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "746006"
AND av.ProductID IN (4))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "436668"
AND av.ProductID IN (4))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "436346"
AND av.ProductID IN (4))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "436336"
AND av.ProductID IN (4))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "433160"
AND av.ProductID IN (4))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "439025"
AND av.ProductID IN (4))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "436478"
AND av.ProductID IN (4))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "436338"
AND av.ProductID IN (4))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "433162"
AND av.ProductID IN (4))
OR
(av.SupplierID = 21
AND av.DataSupplierArticleNumber = "439056"
AND av.ProductID IN (4))
OR
(av.SupplierID = 183
AND av.DataSupplierArticleNumber = "V22-13-39300"
AND av.ProductID IN (4))
OR
(av.SupplierID = 183
AND av.DataSupplierArticleNumber = "V22-13-39760"
AND av.ProductID IN (4))
)
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 = 4528
AND aa.DataSupplierArticleNumber = "301155RI")
OR
(aa.SupplierID = 4528
AND aa.DataSupplierArticleNumber = "30639RI")
OR
(aa.SupplierID = 4528
AND aa.DataSupplierArticleNumber = "301043RI")
OR
(aa.SupplierID = 4528
AND aa.DataSupplierArticleNumber = "30637RI")
OR
(aa.SupplierID = 4528
AND aa.DataSupplierArticleNumber = "301065RI")
OR
(aa.SupplierID = 4528
AND aa.DataSupplierArticleNumber = "301098RI")
OR
(aa.SupplierID = 4528
AND aa.DataSupplierArticleNumber = "30638RI")
OR
(aa.SupplierID = 4534
AND aa.DataSupplierArticleNumber = "AL3696")
OR
(aa.SupplierID = 4534
AND aa.DataSupplierArticleNumber = "AL3379")
OR
(aa.SupplierID = 4534
AND aa.DataSupplierArticleNumber = "AL3699")
OR
(aa.SupplierID = 4534
AND aa.DataSupplierArticleNumber = "AL3483")
OR
(aa.SupplierID = 4534
AND aa.DataSupplierArticleNumber = "AL3253")
OR
(aa.SupplierID = 4534
AND aa.DataSupplierArticleNumber = "AL3580")
OR
(aa.SupplierID = 4534
AND aa.DataSupplierArticleNumber = "AL3297")
OR
(aa.SupplierID = 4843
AND aa.DataSupplierArticleNumber = "A3022")
OR
(aa.SupplierID = 4843
AND aa.DataSupplierArticleNumber = "A0163")
OR
(aa.SupplierID = 4843
AND aa.DataSupplierArticleNumber = "A3039")
OR
(aa.SupplierID = 4843
AND aa.DataSupplierArticleNumber = "A0381")
OR
(aa.SupplierID = 4843
AND aa.DataSupplierArticleNumber = "A3096")
OR
(aa.SupplierID = 4843
AND aa.DataSupplierArticleNumber = "A3015")
OR
(aa.SupplierID = 412
AND aa.DataSupplierArticleNumber = "L 39 300")
OR
(aa.SupplierID = 412
AND aa.DataSupplierArticleNumber = "L 39 760")
OR
(aa.SupplierID = 412
AND aa.DataSupplierArticleNumber = "L 38 740")
OR
(aa.SupplierID = 412
AND aa.DataSupplierArticleNumber = "L 39 940")
OR
(aa.SupplierID = 412
AND aa.DataSupplierArticleNumber = "L 38 780")
OR
(aa.SupplierID = 412
AND aa.DataSupplierArticleNumber = "L 40 210")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "AVA206A")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "AVA158")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "AVA152A")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "AVA158A")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "AVA152C")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "AVA144")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "AVA206")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "AVA154A")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "AVA144A")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BBA2216")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BBA2237")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BBA2023")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BBA2024")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 986 040 210")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 986 039 300")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 123 310 012")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 986 039 760")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 986 038 740")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 120 335 012")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 986 039 941")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 986 038 781")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 123 310 010")
OR
(aa.SupplierID = 177
AND aa.DataSupplierArticleNumber = "L610222")
OR
(aa.SupplierID = 177
AND aa.DataSupplierArticleNumber = "L611454")
OR
(aa.SupplierID = 177
AND aa.DataSupplierArticleNumber = "L610100")
OR
(aa.SupplierID = 484
AND aa.DataSupplierArticleNumber = "CAL15206GS")
OR
(aa.SupplierID = 484
AND aa.DataSupplierArticleNumber = "CAL15158AS")
OR
(aa.SupplierID = 484
AND aa.DataSupplierArticleNumber = "CAL15152RS")
OR
(aa.SupplierID = 484
AND aa.DataSupplierArticleNumber = "CAL15144AS")
OR
(aa.SupplierID = 484
AND aa.DataSupplierArticleNumber = "CAL15158GS")
OR
(aa.SupplierID = 484
AND aa.DataSupplierArticleNumber = "CAL15153AS")
OR
(aa.SupplierID = 484
AND aa.DataSupplierArticleNumber = "CAL15144GS")
OR
(aa.SupplierID = 484
AND aa.DataSupplierArticleNumber = "CAL15206AS")
OR
(aa.SupplierID = 484
AND aa.DataSupplierArticleNumber = "CAL15154AS")
OR
(aa.SupplierID = 484
AND aa.DataSupplierArticleNumber = "CAL15152AS")
OR
(aa.SupplierID = 484
AND aa.DataSupplierArticleNumber = "CAL15120AS")
OR
(aa.SupplierID = 393
AND aa.DataSupplierArticleNumber = "4916")
OR
(aa.SupplierID = 393
AND aa.DataSupplierArticleNumber = "4410")
OR
(aa.SupplierID = 393
AND aa.DataSupplierArticleNumber = "4426")
OR
(aa.SupplierID = 393
AND aa.DataSupplierArticleNumber = "4328")
OR
(aa.SupplierID = 393
AND aa.DataSupplierArticleNumber = "4430")
OR
(aa.SupplierID = 393
AND aa.DataSupplierArticleNumber = "4330")
OR
(aa.SupplierID = 460
AND aa.DataSupplierArticleNumber = "216109802")
OR
(aa.SupplierID = 460
AND aa.DataSupplierArticleNumber = "200132802")
OR
(aa.SupplierID = 460
AND aa.DataSupplierArticleNumber = "216112802")
OR
(aa.SupplierID = 460
AND aa.DataSupplierArticleNumber = "200132902")
OR
(aa.SupplierID = 460
AND aa.DataSupplierArticleNumber = "2001321202")
OR
(aa.SupplierID = 460
AND aa.DataSupplierArticleNumber = "216109702")
OR
(aa.SupplierID = 460
AND aa.DataSupplierArticleNumber = "200132702")
OR
(aa.SupplierID = 391
AND aa.DataSupplierArticleNumber = "56545")
OR
(aa.SupplierID = 391
AND aa.DataSupplierArticleNumber = "56299")
OR
(aa.SupplierID = 391
AND aa.DataSupplierArticleNumber = "56224")
OR
(aa.SupplierID = 391
AND aa.DataSupplierArticleNumber = "56596")
OR
(aa.SupplierID = 391
AND aa.DataSupplierArticleNumber = "56549")
OR
(aa.SupplierID = 391
AND aa.DataSupplierArticleNumber = "56410")
OR
(aa.SupplierID = 391
AND aa.DataSupplierArticleNumber = "56225")
OR
(aa.SupplierID = 391
AND aa.DataSupplierArticleNumber = "56558")
OR
(aa.SupplierID = 391
AND aa.DataSupplierArticleNumber = "56503")
OR
(aa.SupplierID = 391
AND aa.DataSupplierArticleNumber = "56229")
OR
(aa.SupplierID = 391
AND aa.DataSupplierArticleNumber = "55712")
OR
(aa.SupplierID = 391
AND aa.DataSupplierArticleNumber = "56587")
OR
(aa.SupplierID = 226
AND aa.DataSupplierArticleNumber = "28-2882")
OR
(aa.SupplierID = 226
AND aa.DataSupplierArticleNumber = "28-2592")
OR
(aa.SupplierID = 226
AND aa.DataSupplierArticleNumber = "28-2925")
OR
(aa.SupplierID = 226
AND aa.DataSupplierArticleNumber = "28-2690")
OR
(aa.SupplierID = 226
AND aa.DataSupplierArticleNumber = "28-1970")
OR
(aa.SupplierID = 226
AND aa.DataSupplierArticleNumber = "28-2795")
OR
(aa.SupplierID = 226
AND aa.DataSupplierArticleNumber = "28-1973")
OR
(aa.SupplierID = 234
AND aa.DataSupplierArticleNumber = "210229")
OR
(aa.SupplierID = 234
AND aa.DataSupplierArticleNumber = "210096")
OR
(aa.SupplierID = 234
AND aa.DataSupplierArticleNumber = "210338")
OR
(aa.SupplierID = 234
AND aa.DataSupplierArticleNumber = "210169")
OR
(aa.SupplierID = 234
AND aa.DataSupplierArticleNumber = "210216")
OR
(aa.SupplierID = 234
AND aa.DataSupplierArticleNumber = "210021")
OR
(aa.SupplierID = 224
AND aa.DataSupplierArticleNumber = "RE7434N")
OR
(aa.SupplierID = 224
AND aa.DataSupplierArticleNumber = "RE72039N")
OR
(aa.SupplierID = 224
AND aa.DataSupplierArticleNumber = "RE73606N")
OR
(aa.SupplierID = 337
AND aa.DataSupplierArticleNumber = "12039940")
OR
(aa.SupplierID = 337
AND aa.DataSupplierArticleNumber = "12038780")
OR
(aa.SupplierID = 337
AND aa.DataSupplierArticleNumber = "12040210")
OR
(aa.SupplierID = 337
AND aa.DataSupplierArticleNumber = "12039300")
OR
(aa.SupplierID = 337
AND aa.DataSupplierArticleNumber = "12038720")
OR
(aa.SupplierID = 337
AND aa.DataSupplierArticleNumber = "12060007")
OR
(aa.SupplierID = 337
AND aa.DataSupplierArticleNumber = "12039760")
OR
(aa.SupplierID = 337
AND aa.DataSupplierArticleNumber = "12038740")
OR
(aa.SupplierID = 90
AND aa.DataSupplierArticleNumber = "118452")
OR
(aa.SupplierID = 90
AND aa.DataSupplierArticleNumber = "118837")
OR
(aa.SupplierID = 90
AND aa.DataSupplierArticleNumber = "118673")
OR
(aa.SupplierID = 90
AND aa.DataSupplierArticleNumber = "118447")
OR
(aa.SupplierID = 90
AND aa.DataSupplierArticleNumber = "118838")
OR
(aa.SupplierID = 90
AND aa.DataSupplierArticleNumber = "118793")
OR
(aa.SupplierID = 90
AND aa.DataSupplierArticleNumber = "118449")
OR
(aa.SupplierID = 90
AND aa.DataSupplierArticleNumber = "118835")
OR
(aa.SupplierID = 87
AND aa.DataSupplierArticleNumber = "9040211")
OR
(aa.SupplierID = 87
AND aa.DataSupplierArticleNumber = "9039300")
OR
(aa.SupplierID = 87
AND aa.DataSupplierArticleNumber = "9039760")
OR
(aa.SupplierID = 87
AND aa.DataSupplierArticleNumber = "9038740")
OR
(aa.SupplierID = 87
AND aa.DataSupplierArticleNumber = "9039941")
OR
(aa.SupplierID = 87
AND aa.DataSupplierArticleNumber = "9038781")
OR
(aa.SupplierID = 4379
AND aa.DataSupplierArticleNumber = "6 3098 9")
OR
(aa.SupplierID = 4819
AND aa.DataSupplierArticleNumber = "112688")
OR
(aa.SupplierID = 4819
AND aa.DataSupplierArticleNumber = "111893")
OR
(aa.SupplierID = 4819
AND aa.DataSupplierArticleNumber = "112703")
OR
(aa.SupplierID = 4819
AND aa.DataSupplierArticleNumber = "112230")
OR
(aa.SupplierID = 4819
AND aa.DataSupplierArticleNumber = "113485")
OR
(aa.SupplierID = 4819
AND aa.DataSupplierArticleNumber = "112292")
OR
(aa.SupplierID = 425
AND aa.DataSupplierArticleNumber = "CA1155IR")
OR
(aa.SupplierID = 425
AND aa.DataSupplierArticleNumber = "CA1043IR")
OR
(aa.SupplierID = 425
AND aa.DataSupplierArticleNumber = "CA637IR")
OR
(aa.SupplierID = 425
AND aa.DataSupplierArticleNumber = "CA1065IR")
OR
(aa.SupplierID = 425
AND aa.DataSupplierArticleNumber = "CA638IR")
OR
(aa.SupplierID = 425
AND aa.DataSupplierArticleNumber = "CA1098IR")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8EL 737 202-001")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8EL 732 715-001")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8EL 012 427-271")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8EL 011 710-141")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8EL 737 014-001")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8EL 725 921-001")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8EL 011 710-991")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8EL 011 710-051")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8EL 737 047-001")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8EL 725 922-001")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8EL 011 711-001")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8EL 011 710-091")
OR
(aa.SupplierID = 72
AND aa.DataSupplierArticleNumber = "32040211")
OR
(aa.SupplierID = 72
AND aa.DataSupplierArticleNumber = "32038740")
OR
(aa.SupplierID = 72
AND aa.DataSupplierArticleNumber = "32038781")
OR
(aa.SupplierID = 72
AND aa.DataSupplierArticleNumber = "32039300")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "3190100509")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "4190101200")
OR
(aa.SupplierID = 4496
AND aa.DataSupplierArticleNumber = "11.1065")
OR
(aa.SupplierID = 4496
AND aa.DataSupplierArticleNumber = "11.0637")
OR
(aa.SupplierID = 4496
AND aa.DataSupplierArticleNumber = "11.1098")
OR
(aa.SupplierID = 4496
AND aa.DataSupplierArticleNumber = "11.0638")
OR
(aa.SupplierID = 4496
AND aa.DataSupplierArticleNumber = "11.1155")
OR
(aa.SupplierID = 4496
AND aa.DataSupplierArticleNumber = "11.1043")
OR
(aa.SupplierID = 20
AND aa.DataSupplierArticleNumber = "LRB00312")
OR
(aa.SupplierID = 20
AND aa.DataSupplierArticleNumber = "LRB00280")
OR
(aa.SupplierID = 20
AND aa.DataSupplierArticleNumber = "LRA01448")
OR
(aa.SupplierID = 20
AND aa.DataSupplierArticleNumber = "LRB00281")
OR
(aa.SupplierID = 20
AND aa.DataSupplierArticleNumber = "LRB00183")
OR
(aa.SupplierID = 20
AND aa.DataSupplierArticleNumber = "LRB00311")
OR
(aa.SupplierID = 20
AND aa.DataSupplierArticleNumber = "LRB00184")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "944390397600")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "943356967010")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "943356574010")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "944390399410")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "943356974010")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "943356576010")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "944390387400")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "943356577010")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "943346223010")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "MG 96")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "MG 387")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "MG 418")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "MG 422")
OR
(aa.SupplierID = 342
AND aa.DataSupplierArticleNumber = "210021")
OR
(aa.SupplierID = 342
AND aa.DataSupplierArticleNumber = "210229")
OR
(aa.SupplierID = 342
AND aa.DataSupplierArticleNumber = "210096")
OR
(aa.SupplierID = 342
AND aa.DataSupplierArticleNumber = "210338")
OR
(aa.SupplierID = 342
AND aa.DataSupplierArticleNumber = "210169")
OR
(aa.SupplierID = 342
AND aa.DataSupplierArticleNumber = "210216")
OR
(aa.SupplierID = 440
AND aa.DataSupplierArticleNumber = "DAN641")
OR
(aa.SupplierID = 4380
AND aa.DataSupplierArticleNumber = "2137036")
OR
(aa.SupplierID = 4380
AND aa.DataSupplierArticleNumber = "2137020")
OR
(aa.SupplierID = 4380
AND aa.DataSupplierArticleNumber = "2137030")
OR
(aa.SupplierID = 4380
AND aa.DataSupplierArticleNumber = "2137014")
OR
(aa.SupplierID = 4380
AND aa.DataSupplierArticleNumber = "2137034")
OR
(aa.SupplierID = 4380
AND aa.DataSupplierArticleNumber = "2137018")
OR
(aa.SupplierID = 4543
AND aa.DataSupplierArticleNumber = "9213045")
OR
(aa.SupplierID = 4543
AND aa.DataSupplierArticleNumber = "89213904")
OR
(aa.SupplierID = 4543
AND aa.DataSupplierArticleNumber = "89212938")
OR
(aa.SupplierID = 4543
AND aa.DataSupplierArticleNumber = "9213904")
OR
(aa.SupplierID = 4543
AND aa.DataSupplierArticleNumber = "9212916")
OR
(aa.SupplierID = 4543
AND aa.DataSupplierArticleNumber = "89212971")
OR
(aa.SupplierID = 4543
AND aa.DataSupplierArticleNumber = "89212735")
OR
(aa.SupplierID = 4543
AND aa.DataSupplierArticleNumber = "9212938")
OR
(aa.SupplierID = 4543
AND aa.DataSupplierArticleNumber = "89213045")
OR
(aa.SupplierID = 4543
AND aa.DataSupplierArticleNumber = "89212916")
OR
(aa.SupplierID = 396
AND aa.DataSupplierArticleNumber = "35214950")
OR
(aa.SupplierID = 396
AND aa.DataSupplierArticleNumber = "20110280")
OR
(aa.SupplierID = 396
AND aa.DataSupplierArticleNumber = "20110281")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QRA1806")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QRA1902")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QRA1034")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QRA1909")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QRA1784")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QRA2965")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "RAA14347")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "RAA10411")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "DRB0211")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "DRA9300")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "DRA3234")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "RAA21322")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "RAA10871")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "DRB0211N")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "DRA9760")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "DRA3236")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "RAA14345")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "RAA10052")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "DRA9941")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "DRA3236N")
OR
(aa.SupplierID = 360
AND aa.DataSupplierArticleNumber = "212507")
OR
(aa.SupplierID = 360
AND aa.DataSupplierArticleNumber = "212508")
OR
(aa.SupplierID = 360
AND aa.DataSupplierArticleNumber = "212503")
OR
(aa.SupplierID = 4620
AND aa.DataSupplierArticleNumber = "F042A0B023")
OR
(aa.SupplierID = 4620
AND aa.DataSupplierArticleNumber = "F032UA0028")
OR
(aa.SupplierID = 4620
AND aa.DataSupplierArticleNumber = "F032UA0034")
OR
(aa.SupplierID = 4620
AND aa.DataSupplierArticleNumber = "F042A0B008")
OR
(aa.SupplierID = 4620
AND aa.DataSupplierArticleNumber = "F032UA0027")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "436613")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "436339")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "433189")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "746006")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "436668")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "436346")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "436336")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "433160")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "439025")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "436478")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "436338")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "433162")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "439056")
OR
(aa.SupplierID = 183
AND aa.DataSupplierArticleNumber = "V22-13-39300")
OR
(aa.SupplierID = 183
AND aa.DataSupplierArticleNumber = "V22-13-39760")
)
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 = 4528
AND aa.DataSupplierArticleNumber = "301155RI")
OR
(aa.SupplierID = 4528
AND aa.DataSupplierArticleNumber = "30639RI")
OR
(aa.SupplierID = 4528
AND aa.DataSupplierArticleNumber = "301043RI")
OR
(aa.SupplierID = 4528
AND aa.DataSupplierArticleNumber = "30637RI")
OR
(aa.SupplierID = 4528
AND aa.DataSupplierArticleNumber = "301065RI")
OR
(aa.SupplierID = 4528
AND aa.DataSupplierArticleNumber = "301098RI")
OR
(aa.SupplierID = 4528
AND aa.DataSupplierArticleNumber = "30638RI")
OR
(aa.SupplierID = 4534
AND aa.DataSupplierArticleNumber = "AL3696")
OR
(aa.SupplierID = 4534
AND aa.DataSupplierArticleNumber = "AL3379")
OR
(aa.SupplierID = 4534
AND aa.DataSupplierArticleNumber = "AL3699")
OR
(aa.SupplierID = 4534
AND aa.DataSupplierArticleNumber = "AL3483")
OR
(aa.SupplierID = 4534
AND aa.DataSupplierArticleNumber = "AL3253")
OR
(aa.SupplierID = 4534
AND aa.DataSupplierArticleNumber = "AL3580")
OR
(aa.SupplierID = 4534
AND aa.DataSupplierArticleNumber = "AL3297")
OR
(aa.SupplierID = 4843
AND aa.DataSupplierArticleNumber = "A3022")
OR
(aa.SupplierID = 4843
AND aa.DataSupplierArticleNumber = "A0163")
OR
(aa.SupplierID = 4843
AND aa.DataSupplierArticleNumber = "A3039")
OR
(aa.SupplierID = 4843
AND aa.DataSupplierArticleNumber = "A0381")
OR
(aa.SupplierID = 4843
AND aa.DataSupplierArticleNumber = "A3096")
OR
(aa.SupplierID = 4843
AND aa.DataSupplierArticleNumber = "A3015")
OR
(aa.SupplierID = 412
AND aa.DataSupplierArticleNumber = "L 39 300")
OR
(aa.SupplierID = 412
AND aa.DataSupplierArticleNumber = "L 39 760")
OR
(aa.SupplierID = 412
AND aa.DataSupplierArticleNumber = "L 38 740")
OR
(aa.SupplierID = 412
AND aa.DataSupplierArticleNumber = "L 39 940")
OR
(aa.SupplierID = 412
AND aa.DataSupplierArticleNumber = "L 38 780")
OR
(aa.SupplierID = 412
AND aa.DataSupplierArticleNumber = "L 40 210")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "AVA206A")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "AVA158")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "AVA152A")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "AVA158A")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "AVA152C")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "AVA144")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "AVA206")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "AVA154A")
OR
(aa.SupplierID = 4464
AND aa.DataSupplierArticleNumber = "AVA144A")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BBA2216")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BBA2237")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BBA2023")
OR
(aa.SupplierID = 475
AND aa.DataSupplierArticleNumber = "BBA2024")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 986 040 210")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 986 039 300")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 123 310 012")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 986 039 760")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 986 038 740")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 120 335 012")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 986 039 941")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 986 038 781")
OR
(aa.SupplierID = 30
AND aa.DataSupplierArticleNumber = "0 123 310 010")
OR
(aa.SupplierID = 177
AND aa.DataSupplierArticleNumber = "L610222")
OR
(aa.SupplierID = 177
AND aa.DataSupplierArticleNumber = "L611454")
OR
(aa.SupplierID = 177
AND aa.DataSupplierArticleNumber = "L610100")
OR
(aa.SupplierID = 484
AND aa.DataSupplierArticleNumber = "CAL15206GS")
OR
(aa.SupplierID = 484
AND aa.DataSupplierArticleNumber = "CAL15158AS")
OR
(aa.SupplierID = 484
AND aa.DataSupplierArticleNumber = "CAL15152RS")
OR
(aa.SupplierID = 484
AND aa.DataSupplierArticleNumber = "CAL15144AS")
OR
(aa.SupplierID = 484
AND aa.DataSupplierArticleNumber = "CAL15158GS")
OR
(aa.SupplierID = 484
AND aa.DataSupplierArticleNumber = "CAL15153AS")
OR
(aa.SupplierID = 484
AND aa.DataSupplierArticleNumber = "CAL15144GS")
OR
(aa.SupplierID = 484
AND aa.DataSupplierArticleNumber = "CAL15206AS")
OR
(aa.SupplierID = 484
AND aa.DataSupplierArticleNumber = "CAL15154AS")
OR
(aa.SupplierID = 484
AND aa.DataSupplierArticleNumber = "CAL15152AS")
OR
(aa.SupplierID = 484
AND aa.DataSupplierArticleNumber = "CAL15120AS")
OR
(aa.SupplierID = 393
AND aa.DataSupplierArticleNumber = "4916")
OR
(aa.SupplierID = 393
AND aa.DataSupplierArticleNumber = "4410")
OR
(aa.SupplierID = 393
AND aa.DataSupplierArticleNumber = "4426")
OR
(aa.SupplierID = 393
AND aa.DataSupplierArticleNumber = "4328")
OR
(aa.SupplierID = 393
AND aa.DataSupplierArticleNumber = "4430")
OR
(aa.SupplierID = 393
AND aa.DataSupplierArticleNumber = "4330")
OR
(aa.SupplierID = 460
AND aa.DataSupplierArticleNumber = "216109802")
OR
(aa.SupplierID = 460
AND aa.DataSupplierArticleNumber = "200132802")
OR
(aa.SupplierID = 460
AND aa.DataSupplierArticleNumber = "216112802")
OR
(aa.SupplierID = 460
AND aa.DataSupplierArticleNumber = "200132902")
OR
(aa.SupplierID = 460
AND aa.DataSupplierArticleNumber = "2001321202")
OR
(aa.SupplierID = 460
AND aa.DataSupplierArticleNumber = "216109702")
OR
(aa.SupplierID = 460
AND aa.DataSupplierArticleNumber = "200132702")
OR
(aa.SupplierID = 391
AND aa.DataSupplierArticleNumber = "56545")
OR
(aa.SupplierID = 391
AND aa.DataSupplierArticleNumber = "56299")
OR
(aa.SupplierID = 391
AND aa.DataSupplierArticleNumber = "56224")
OR
(aa.SupplierID = 391
AND aa.DataSupplierArticleNumber = "56596")
OR
(aa.SupplierID = 391
AND aa.DataSupplierArticleNumber = "56549")
OR
(aa.SupplierID = 391
AND aa.DataSupplierArticleNumber = "56410")
OR
(aa.SupplierID = 391
AND aa.DataSupplierArticleNumber = "56225")
OR
(aa.SupplierID = 391
AND aa.DataSupplierArticleNumber = "56558")
OR
(aa.SupplierID = 391
AND aa.DataSupplierArticleNumber = "56503")
OR
(aa.SupplierID = 391
AND aa.DataSupplierArticleNumber = "56229")
OR
(aa.SupplierID = 391
AND aa.DataSupplierArticleNumber = "55712")
OR
(aa.SupplierID = 391
AND aa.DataSupplierArticleNumber = "56587")
OR
(aa.SupplierID = 226
AND aa.DataSupplierArticleNumber = "28-2882")
OR
(aa.SupplierID = 226
AND aa.DataSupplierArticleNumber = "28-2592")
OR
(aa.SupplierID = 226
AND aa.DataSupplierArticleNumber = "28-2925")
OR
(aa.SupplierID = 226
AND aa.DataSupplierArticleNumber = "28-2690")
OR
(aa.SupplierID = 226
AND aa.DataSupplierArticleNumber = "28-1970")
OR
(aa.SupplierID = 226
AND aa.DataSupplierArticleNumber = "28-2795")
OR
(aa.SupplierID = 226
AND aa.DataSupplierArticleNumber = "28-1973")
OR
(aa.SupplierID = 234
AND aa.DataSupplierArticleNumber = "210229")
OR
(aa.SupplierID = 234
AND aa.DataSupplierArticleNumber = "210096")
OR
(aa.SupplierID = 234
AND aa.DataSupplierArticleNumber = "210338")
OR
(aa.SupplierID = 234
AND aa.DataSupplierArticleNumber = "210169")
OR
(aa.SupplierID = 234
AND aa.DataSupplierArticleNumber = "210216")
OR
(aa.SupplierID = 234
AND aa.DataSupplierArticleNumber = "210021")
OR
(aa.SupplierID = 224
AND aa.DataSupplierArticleNumber = "RE7434N")
OR
(aa.SupplierID = 224
AND aa.DataSupplierArticleNumber = "RE72039N")
OR
(aa.SupplierID = 224
AND aa.DataSupplierArticleNumber = "RE73606N")
OR
(aa.SupplierID = 337
AND aa.DataSupplierArticleNumber = "12039940")
OR
(aa.SupplierID = 337
AND aa.DataSupplierArticleNumber = "12038780")
OR
(aa.SupplierID = 337
AND aa.DataSupplierArticleNumber = "12040210")
OR
(aa.SupplierID = 337
AND aa.DataSupplierArticleNumber = "12039300")
OR
(aa.SupplierID = 337
AND aa.DataSupplierArticleNumber = "12038720")
OR
(aa.SupplierID = 337
AND aa.DataSupplierArticleNumber = "12060007")
OR
(aa.SupplierID = 337
AND aa.DataSupplierArticleNumber = "12039760")
OR
(aa.SupplierID = 337
AND aa.DataSupplierArticleNumber = "12038740")
OR
(aa.SupplierID = 90
AND aa.DataSupplierArticleNumber = "118452")
OR
(aa.SupplierID = 90
AND aa.DataSupplierArticleNumber = "118837")
OR
(aa.SupplierID = 90
AND aa.DataSupplierArticleNumber = "118673")
OR
(aa.SupplierID = 90
AND aa.DataSupplierArticleNumber = "118447")
OR
(aa.SupplierID = 90
AND aa.DataSupplierArticleNumber = "118838")
OR
(aa.SupplierID = 90
AND aa.DataSupplierArticleNumber = "118793")
OR
(aa.SupplierID = 90
AND aa.DataSupplierArticleNumber = "118449")
OR
(aa.SupplierID = 90
AND aa.DataSupplierArticleNumber = "118835")
OR
(aa.SupplierID = 87
AND aa.DataSupplierArticleNumber = "9040211")
OR
(aa.SupplierID = 87
AND aa.DataSupplierArticleNumber = "9039300")
OR
(aa.SupplierID = 87
AND aa.DataSupplierArticleNumber = "9039760")
OR
(aa.SupplierID = 87
AND aa.DataSupplierArticleNumber = "9038740")
OR
(aa.SupplierID = 87
AND aa.DataSupplierArticleNumber = "9039941")
OR
(aa.SupplierID = 87
AND aa.DataSupplierArticleNumber = "9038781")
OR
(aa.SupplierID = 4379
AND aa.DataSupplierArticleNumber = "6 3098 9")
OR
(aa.SupplierID = 4819
AND aa.DataSupplierArticleNumber = "112688")
OR
(aa.SupplierID = 4819
AND aa.DataSupplierArticleNumber = "111893")
OR
(aa.SupplierID = 4819
AND aa.DataSupplierArticleNumber = "112703")
OR
(aa.SupplierID = 4819
AND aa.DataSupplierArticleNumber = "112230")
OR
(aa.SupplierID = 4819
AND aa.DataSupplierArticleNumber = "113485")
OR
(aa.SupplierID = 4819
AND aa.DataSupplierArticleNumber = "112292")
OR
(aa.SupplierID = 425
AND aa.DataSupplierArticleNumber = "CA1155IR")
OR
(aa.SupplierID = 425
AND aa.DataSupplierArticleNumber = "CA1043IR")
OR
(aa.SupplierID = 425
AND aa.DataSupplierArticleNumber = "CA637IR")
OR
(aa.SupplierID = 425
AND aa.DataSupplierArticleNumber = "CA1065IR")
OR
(aa.SupplierID = 425
AND aa.DataSupplierArticleNumber = "CA638IR")
OR
(aa.SupplierID = 425
AND aa.DataSupplierArticleNumber = "CA1098IR")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8EL 737 202-001")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8EL 732 715-001")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8EL 012 427-271")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8EL 011 710-141")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8EL 737 014-001")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8EL 725 921-001")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8EL 011 710-991")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8EL 011 710-051")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8EL 737 047-001")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8EL 725 922-001")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8EL 011 711-001")
OR
(aa.SupplierID = 2
AND aa.DataSupplierArticleNumber = "8EL 011 710-091")
OR
(aa.SupplierID = 72
AND aa.DataSupplierArticleNumber = "32040211")
OR
(aa.SupplierID = 72
AND aa.DataSupplierArticleNumber = "32038740")
OR
(aa.SupplierID = 72
AND aa.DataSupplierArticleNumber = "32038781")
OR
(aa.SupplierID = 72
AND aa.DataSupplierArticleNumber = "32039300")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "3190100509")
OR
(aa.SupplierID = 268
AND aa.DataSupplierArticleNumber = "4190101200")
OR
(aa.SupplierID = 4496
AND aa.DataSupplierArticleNumber = "11.1065")
OR
(aa.SupplierID = 4496
AND aa.DataSupplierArticleNumber = "11.0637")
OR
(aa.SupplierID = 4496
AND aa.DataSupplierArticleNumber = "11.1098")
OR
(aa.SupplierID = 4496
AND aa.DataSupplierArticleNumber = "11.0638")
OR
(aa.SupplierID = 4496
AND aa.DataSupplierArticleNumber = "11.1155")
OR
(aa.SupplierID = 4496
AND aa.DataSupplierArticleNumber = "11.1043")
OR
(aa.SupplierID = 20
AND aa.DataSupplierArticleNumber = "LRB00312")
OR
(aa.SupplierID = 20
AND aa.DataSupplierArticleNumber = "LRB00280")
OR
(aa.SupplierID = 20
AND aa.DataSupplierArticleNumber = "LRA01448")
OR
(aa.SupplierID = 20
AND aa.DataSupplierArticleNumber = "LRB00281")
OR
(aa.SupplierID = 20
AND aa.DataSupplierArticleNumber = "LRB00183")
OR
(aa.SupplierID = 20
AND aa.DataSupplierArticleNumber = "LRB00311")
OR
(aa.SupplierID = 20
AND aa.DataSupplierArticleNumber = "LRB00184")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "944390397600")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "943356967010")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "943356574010")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "944390399410")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "943356974010")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "943356576010")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "944390387400")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "943356577010")
OR
(aa.SupplierID = 95
AND aa.DataSupplierArticleNumber = "943346223010")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "MG 96")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "MG 387")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "MG 418")
OR
(aa.SupplierID = 287
AND aa.DataSupplierArticleNumber = "MG 422")
OR
(aa.SupplierID = 342
AND aa.DataSupplierArticleNumber = "210021")
OR
(aa.SupplierID = 342
AND aa.DataSupplierArticleNumber = "210229")
OR
(aa.SupplierID = 342
AND aa.DataSupplierArticleNumber = "210096")
OR
(aa.SupplierID = 342
AND aa.DataSupplierArticleNumber = "210338")
OR
(aa.SupplierID = 342
AND aa.DataSupplierArticleNumber = "210169")
OR
(aa.SupplierID = 342
AND aa.DataSupplierArticleNumber = "210216")
OR
(aa.SupplierID = 440
AND aa.DataSupplierArticleNumber = "DAN641")
OR
(aa.SupplierID = 4380
AND aa.DataSupplierArticleNumber = "2137036")
OR
(aa.SupplierID = 4380
AND aa.DataSupplierArticleNumber = "2137020")
OR
(aa.SupplierID = 4380
AND aa.DataSupplierArticleNumber = "2137030")
OR
(aa.SupplierID = 4380
AND aa.DataSupplierArticleNumber = "2137014")
OR
(aa.SupplierID = 4380
AND aa.DataSupplierArticleNumber = "2137034")
OR
(aa.SupplierID = 4380
AND aa.DataSupplierArticleNumber = "2137018")
OR
(aa.SupplierID = 4543
AND aa.DataSupplierArticleNumber = "9213045")
OR
(aa.SupplierID = 4543
AND aa.DataSupplierArticleNumber = "89213904")
OR
(aa.SupplierID = 4543
AND aa.DataSupplierArticleNumber = "89212938")
OR
(aa.SupplierID = 4543
AND aa.DataSupplierArticleNumber = "9213904")
OR
(aa.SupplierID = 4543
AND aa.DataSupplierArticleNumber = "9212916")
OR
(aa.SupplierID = 4543
AND aa.DataSupplierArticleNumber = "89212971")
OR
(aa.SupplierID = 4543
AND aa.DataSupplierArticleNumber = "89212735")
OR
(aa.SupplierID = 4543
AND aa.DataSupplierArticleNumber = "9212938")
OR
(aa.SupplierID = 4543
AND aa.DataSupplierArticleNumber = "89213045")
OR
(aa.SupplierID = 4543
AND aa.DataSupplierArticleNumber = "89212916")
OR
(aa.SupplierID = 396
AND aa.DataSupplierArticleNumber = "35214950")
OR
(aa.SupplierID = 396
AND aa.DataSupplierArticleNumber = "20110280")
OR
(aa.SupplierID = 396
AND aa.DataSupplierArticleNumber = "20110281")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QRA1806")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QRA1902")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QRA1034")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QRA1909")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QRA1784")
OR
(aa.SupplierID = 57
AND aa.DataSupplierArticleNumber = "QRA2965")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "RAA14347")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "RAA10411")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "DRB0211")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "DRA9300")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "DRA3234")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "RAA21322")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "RAA10871")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "DRB0211N")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "DRA9760")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "DRA3236")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "RAA14345")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "RAA10052")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "DRA9941")
OR
(aa.SupplierID = 214
AND aa.DataSupplierArticleNumber = "DRA3236N")
OR
(aa.SupplierID = 360
AND aa.DataSupplierArticleNumber = "212507")
OR
(aa.SupplierID = 360
AND aa.DataSupplierArticleNumber = "212508")
OR
(aa.SupplierID = 360
AND aa.DataSupplierArticleNumber = "212503")
OR
(aa.SupplierID = 4620
AND aa.DataSupplierArticleNumber = "F042A0B023")
OR
(aa.SupplierID = 4620
AND aa.DataSupplierArticleNumber = "F032UA0028")
OR
(aa.SupplierID = 4620
AND aa.DataSupplierArticleNumber = "F032UA0034")
OR
(aa.SupplierID = 4620
AND aa.DataSupplierArticleNumber = "F042A0B008")
OR
(aa.SupplierID = 4620
AND aa.DataSupplierArticleNumber = "F032UA0027")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "436613")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "436339")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "433189")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "746006")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "436668")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "436346")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "436336")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "433160")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "439025")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "436478")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "436338")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "433162")
OR
(aa.SupplierID = 21
AND aa.DataSupplierArticleNumber = "439056")
OR
(aa.SupplierID = 183
AND aa.DataSupplierArticleNumber = "V22-13-39300")
OR
(aa.SupplierID = 183
AND aa.DataSupplierArticleNumber = "V22-13-39760")
)
AND aa.Language = "ru"
Продажа автозапчастей типа Генератор для автомобилей
