#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU4N3x8bW9kZWxfaWQ9PTczNzV8fG1kZl9pZD09MF4zMjc5N3x8c3BhcmVfaWQ9PTEwMTY2Nw%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 = "32797" AND ( (av.SupplierID = 4943 AND av.DataSupplierArticleNumber = "AW1910006" AND av.ProductID IN (106)) OR (av.SupplierID = 4943 AND av.DataSupplierArticleNumber = "AW1910001" AND av.ProductID IN (106)) OR (av.SupplierID = 363 AND av.DataSupplierArticleNumber = "79780240" AND av.ProductID IN (106)) OR (av.SupplierID = 363 AND av.DataSupplierArticleNumber = "70721057" AND av.ProductID IN (106)) OR (av.SupplierID = 363 AND av.DataSupplierArticleNumber = "79780242" AND av.ProductID IN (106)) OR (av.SupplierID = 363 AND av.DataSupplierArticleNumber = "70721063" AND av.ProductID IN (106)) OR (av.SupplierID = 363 AND av.DataSupplierArticleNumber = "70721014" AND av.ProductID IN (106)) OR (av.SupplierID = 363 AND av.DataSupplierArticleNumber = "70721101" AND av.ProductID IN (106)) OR (av.SupplierID = 363 AND av.DataSupplierArticleNumber = "70721024" AND av.ProductID IN (106)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "LID10020" AND av.ProductID IN (106)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "LID10063" AND av.ProductID IN (106)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "LID10018" AND av.ProductID IN (106)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "LID10066" AND av.ProductID IN (106)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "LID10019" AND av.ProductID IN (106)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "LLB711P" AND av.ProductID IN (106)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "ELBL711" AND av.ProductID IN (106)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "LLD1S" AND av.ProductID IN (106)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "ELBXD1S" AND av.ProductID IN (106)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "LLB711" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "19759" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "98282" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "17123" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "95397" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "93013272" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "93012270" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "79299" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "35017" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "98715" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "17463" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "97131" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "93013293" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "93012303" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "84491" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "35752" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "98717" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "19686" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "98264" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "12904" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "93768" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "93012861" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "90902" AND av.ProductID IN (106)) OR (av.SupplierID = 4612 AND av.DataSupplierArticleNumber = "74154" AND av.ProductID IN (106)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "8GH 007 157-121" AND av.ProductID IN (106)) OR (av.SupplierID = 72 AND av.DataSupplierArticleNumber = "89901320" AND av.ProductID IN (106)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "0805500" AND av.ProductID IN (106)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "0805515" AND av.ProductID IN (106)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "L19535" AND av.ProductID IN (106)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "L10755B" AND av.ProductID IN (106)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "L10755" AND av.ProductID IN (106)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "L19535-02" AND av.ProductID IN (106)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "L10755B-01" AND av.ProductID IN (106)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "L10755-01" AND av.ProductID IN (106)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "L19535W" AND av.ProductID IN (106)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "L10755B-02" AND av.ProductID IN (106)) OR (av.SupplierID = 4600 AND av.DataSupplierArticleNumber = "L10755-02" AND av.ProductID IN (106)) OR (av.SupplierID = 4671 AND av.DataSupplierArticleNumber = "N499" AND av.ProductID IN (106)) OR (av.SupplierID = 4671 AND av.DataSupplierArticleNumber = "N499-01B" AND av.ProductID IN (106)) OR (av.SupplierID = 4671 AND av.DataSupplierArticleNumber = "N499B" AND av.ProductID IN (106)) OR (av.SupplierID = 4671 AND av.DataSupplierArticleNumber = "N499EL-HCB" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210SUP" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210NR1-01B" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210NBU" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210CBI-01B" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210XR-02B" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210ULT" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210SV2" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210NR1-02B" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210NBU-01B" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210CBI-HCB" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210-01B" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210ULT-01B" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210SV2-01B" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210NR5-01B" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210NBU-HCB" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210L" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210CBI" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210ULT-HCB" AND av.ProductID IN (106)) OR (av.SupplierID = 67 AND av.DataSupplierArticleNumber = "64210SV2-HCB" AND av.ProductID IN (106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12972WHVSM" AND av.ProductID IN (106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12972VPB1" AND av.ProductID IN (106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12972LLECOS2" AND av.ProductID IN (106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12972XV+B1" AND av.ProductID IN (106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12972VPS2" AND av.ProductID IN (106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12972PRB1" AND av.ProductID IN (106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12972LLECOB1" AND av.ProductID IN (106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12972XV+S2" AND av.ProductID IN (106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12972WHVB1" AND av.ProductID IN (106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12972PRC1" AND av.ProductID IN (106)) OR (av.SupplierID = 75 AND av.DataSupplierArticleNumber = "12972LLECOC1" AND av.ProductID IN (106)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "BL57162" AND av.ProductID IN (106)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "57183" AND av.ProductID IN (106)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "57162" AND av.ProductID IN (106)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "57185" AND av.ProductID IN (106)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "57162L" AND av.ProductID IN (106)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "57186" AND av.ProductID IN (106)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "57180" AND av.ProductID IN (106)) OR (av.SupplierID = 45 AND av.DataSupplierArticleNumber = "57080" AND av.ProductID IN (106)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "032519" AND av.ProductID IN (106)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "032516" AND av.ProductID IN (106)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "032523" AND av.ProductID IN (106)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "032520" AND av.ProductID IN (106)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "032517" AND av.ProductID IN (106)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "032008" AND av.ProductID IN (106)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "032521" AND av.ProductID IN (106)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "032518" AND av.ProductID IN (106)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "032009" AND av.ProductID IN (106)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "032522" AND av.ProductID IN (106)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V99-84-0002" AND av.ProductID IN (106)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V99-84-0021" AND av.ProductID IN (106)) OR (av.SupplierID = 4894 AND av.DataSupplierArticleNumber = "LP-1019" AND av.ProductID IN (106)) OR (av.SupplierID = 4894 AND av.DataSupplierArticleNumber = "LP-1047" AND av.ProductID IN (106)) ) 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 = 4943 AND aa.DataSupplierArticleNumber = "AW1910006") OR (aa.SupplierID = 4943 AND aa.DataSupplierArticleNumber = "AW1910001") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "79780240") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721057") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "79780242") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721063") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721014") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721101") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721024") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "LID10020") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "LID10063") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "LID10018") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "LID10066") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "LID10019") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLB711P") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ELBL711") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLD1S") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ELBXD1S") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLB711") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "19759") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "98282") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "17123") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "95397") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93013272") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93012270") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "79299") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "35017") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "98715") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "17463") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "97131") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93013293") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93012303") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "84491") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "35752") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "98717") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "19686") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "98264") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "12904") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93768") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93012861") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "90902") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "74154") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8GH 007 157-121") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "89901320") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "0805500") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "0805515") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "L19535") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "L10755B") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "L10755") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "L19535-02") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "L10755B-01") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "L10755-01") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "L19535W") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "L10755B-02") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "L10755-02") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N499") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N499-01B") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N499B") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N499EL-HCB") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210SUP") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210NR1-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210NBU") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210CBI-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210XR-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210ULT") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210SV2") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210NR1-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210NBU-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210CBI-HCB") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210ULT-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210SV2-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210NR5-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210NBU-HCB") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210L") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210CBI") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210ULT-HCB") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210SV2-HCB") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972WHVSM") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972VPB1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972LLECOS2") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972XV+B1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972VPS2") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972PRB1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972LLECOB1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972XV+S2") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972WHVB1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972PRC1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972LLECOC1") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "BL57162") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "57183") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "57162") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "57185") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "57162L") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "57186") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "57180") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "57080") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032519") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032516") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032523") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032520") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032517") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032008") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032521") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032518") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032009") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032522") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-84-0002") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-84-0021") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1019") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1047") ) 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 = 4943 AND aa.DataSupplierArticleNumber = "AW1910006") OR (aa.SupplierID = 4943 AND aa.DataSupplierArticleNumber = "AW1910001") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "79780240") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721057") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "79780242") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721063") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721014") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721101") OR (aa.SupplierID = 363 AND aa.DataSupplierArticleNumber = "70721024") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "LID10020") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "LID10063") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "LID10018") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "LID10066") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "LID10019") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLB711P") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ELBL711") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLD1S") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "ELBXD1S") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LLB711") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "19759") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "98282") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "17123") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "95397") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93013272") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93012270") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "79299") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "35017") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "98715") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "17463") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "97131") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93013293") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93012303") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "84491") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "35752") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "98717") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "19686") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "98264") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "12904") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93768") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "93012861") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "90902") OR (aa.SupplierID = 4612 AND aa.DataSupplierArticleNumber = "74154") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8GH 007 157-121") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "89901320") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "0805500") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "0805515") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "L19535") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "L10755B") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "L10755") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "L19535-02") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "L10755B-01") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "L10755-01") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "L19535W") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "L10755B-02") OR (aa.SupplierID = 4600 AND aa.DataSupplierArticleNumber = "L10755-02") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N499") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N499-01B") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N499B") OR (aa.SupplierID = 4671 AND aa.DataSupplierArticleNumber = "N499EL-HCB") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210SUP") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210NR1-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210NBU") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210CBI-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210XR-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210ULT") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210SV2") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210NR1-02B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210NBU-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210CBI-HCB") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210ULT-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210SV2-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210NR5-01B") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210NBU-HCB") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210L") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210CBI") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210ULT-HCB") OR (aa.SupplierID = 67 AND aa.DataSupplierArticleNumber = "64210SV2-HCB") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972WHVSM") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972VPB1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972LLECOS2") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972XV+B1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972VPS2") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972PRB1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972LLECOB1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972XV+S2") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972WHVB1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972PRC1") OR (aa.SupplierID = 75 AND aa.DataSupplierArticleNumber = "12972LLECOC1") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "BL57162") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "57183") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "57162") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "57185") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "57162L") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "57186") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "57180") OR (aa.SupplierID = 45 AND aa.DataSupplierArticleNumber = "57080") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032519") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032516") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032523") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032520") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032517") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032008") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032521") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032518") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032009") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "032522") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-84-0002") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-84-0021") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1019") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "LP-1047") ) AND aa.Language = "ru" Продажа автозапчастей типа Лампа накаливания фара дальнего света для автомобилей

Выбор автозапчасти

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AYWIPARTS AW1910006 Лампа накаливания, фара дальнего света
AW1910001 Лампа накаливания, фара дальнего света
CARPRISS 79780240 Лампа накаливания, фара дальнего света
70721057 Лампа накаливания, фара дальнего света
79780242 Лампа накаливания, фара дальнего света
70721063 Лампа накаливания, фара дальнего света
70721014 Лампа накаливания, фара дальнего света
70721101 Лампа накаливания, фара дальнего света
70721024 Лампа накаливания, фара дальнего света
DIEDERICHS LID10020 Лампа накаливания, фара дальнего света
LID10063 Лампа накаливания, фара дальнего света
LID10018 Лампа накаливания, фара дальнего света
LID10066 Лампа накаливания, фара дальнего света
LID10019 Лампа накаливания, фара дальнего света
ELTA AUTOMOTIVE LLB711P Лампа накаливания, фара дальнего света
ELBL711 Лампа накаливания, фара дальнего света
LLD1S Лампа накаливания, фара дальнего света
ELBXD1S Лампа накаливания, фара дальнего света
LLB711 Лампа накаливания, фара дальнего света
GE 19759 Лампа накаливания, фара дальнего света
98282 Лампа накаливания, фара дальнего света
17123 Лампа накаливания, фара дальнего света
95397 Лампа накаливания, фара дальнего света
93013272 Лампа накаливания, фара дальнего света
93012270 Лампа накаливания, фара дальнего света
79299 Лампа накаливания, фара дальнего света
35017 Лампа накаливания, фара дальнего света
98715 Лампа накаливания, фара дальнего света
17463 Лампа накаливания, фара дальнего света
97131 Лампа накаливания, фара дальнего света
93013293 Лампа накаливания, фара дальнего света
93012303 Лампа накаливания, фара дальнего света
84491 Лампа накаливания, фара дальнего света
35752 Лампа накаливания, фара дальнего света
98717 Лампа накаливания, фара дальнего света
19686 Лампа накаливания, фара дальнего света
98264 Лампа накаливания, фара дальнего света
12904 Лампа накаливания, фара дальнего света
93768 Лампа накаливания, фара дальнего света
93012861 Лампа накаливания, фара дальнего света
90902 Лампа накаливания, фара дальнего света
74154 Лампа накаливания, фара дальнего света
HELLA 8GH 007 157-121 Лампа накаливания, фара дальнего света
HERTH+BUSS ELPARTS 89901320 Лампа накаливания, фара дальнего света
KRAFT AUTOMOTIVE 0805500 Лампа накаливания, фара дальнего света
0805515 Лампа накаливания, фара дальнего света
LYNXauto L19535 Лампа накаливания, фара дальнего света
L10755B Лампа накаливания, фара дальнего света
L10755 Лампа накаливания, фара дальнего света
L19535-02 Лампа накаливания, фара дальнего света
L10755B-01 Лампа накаливания, фара дальнего света
L10755-01 Лампа накаливания, фара дальнего света
L19535W Лампа накаливания, фара дальнего света
L10755B-02 Лампа накаливания, фара дальнего света
L10755-02 Лампа накаливания, фара дальнего света
NEOLUX® N499 Лампа накаливания, фара дальнего света
N499-01B Лампа накаливания, фара дальнего света
N499B Лампа накаливания, фара дальнего света
N499EL-HCB Лампа накаливания, фара дальнего света
OSRAM 64210SUP Лампа накаливания, фара дальнего света
64210NR1-01B Лампа накаливания, фара дальнего света
64210NBU Лампа накаливания, фара дальнего света
64210CBI-01B Лампа накаливания, фара дальнего света
64210XR-02B Лампа накаливания, фара дальнего света
64210 Лампа накаливания, фара дальнего света
64210ULT Лампа накаливания, фара дальнего света
64210SV2 Лампа накаливания, фара дальнего света
64210NR1-02B Лампа накаливания, фара дальнего света
64210NBU-01B Лампа накаливания, фара дальнего света
64210CBI-HCB Лампа накаливания, фара дальнего света
64210-01B Лампа накаливания, фара дальнего света
64210ULT-01B Лампа накаливания, фара дальнего света
64210SV2-01B Лампа накаливания, фара дальнего света
64210NR5-01B Лампа накаливания, фара дальнего света
64210NBU-HCB Лампа накаливания, фара дальнего света
64210L Лампа накаливания, фара дальнего света
64210CBI Лампа накаливания, фара дальнего света
64210ULT-HCB Лампа накаливания, фара дальнего света
64210SV2-HCB Лампа накаливания, фара дальнего света
PHILIPS 12972WHVSM Лампа накаливания, фара дальнего света
12972VPB1 Лампа накаливания, фара дальнего света
12972LLECOS2 Лампа накаливания, фара дальнего света
12972XV+B1 Лампа накаливания, фара дальнего света
12972VPS2 Лампа накаливания, фара дальнего света
12972PRB1 Лампа накаливания, фара дальнего света
12972LLECOB1 Лампа накаливания, фара дальнего света
12972XV+S2 Лампа накаливания, фара дальнего света
12972WHVB1 Лампа накаливания, фара дальнего света
12972PRC1 Лампа накаливания, фара дальнего света
12972LLECOC1 Лампа накаливания, фара дальнего света
SPAHN GLÜHLAMPEN BL57162 Лампа накаливания, фара дальнего света
57183 Лампа накаливания, фара дальнего света
57162 Лампа накаливания, фара дальнего света
57185 Лампа накаливания, фара дальнего света
57162L Лампа накаливания, фара дальнего света
57186 Лампа накаливания, фара дальнего света
57180 Лампа накаливания, фара дальнего света
57080 Лампа накаливания, фара дальнего света
VALEO 032519 Лампа накаливания, фара дальнего света
032516 Лампа накаливания, фара дальнего света
032523 Лампа накаливания, фара дальнего света
032520 Лампа накаливания, фара дальнего света
032517 Лампа накаливания, фара дальнего света
032008 Лампа накаливания, фара дальнего света
032521 Лампа накаливания, фара дальнего света
032518 Лампа накаливания, фара дальнего света
032009 Лампа накаливания, фара дальнего света
032522 Лампа накаливания, фара дальнего света
VEMO V99-84-0002 Лампа накаливания, фара дальнего света
V99-84-0021 Лампа накаливания, фара дальнего света
ZEKKERT LP-1019 Лампа накаливания, фара дальнего света
LP-1047 Лампа накаливания, фара дальнего света
2026 CATCAR.INFO (v 2.0)