#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUxNHx8bW9kZWxfaWQ9PTY3MzF8fG1kZl9pZD09MF4xMTIzOTB8fHNwYXJlX2lkPT0xMDAxMzM%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 = "112390" AND ( (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "ASH4-650" AND av.ProductID IN (298)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "WAR014" AND av.ProductID IN (298)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "ASH4-400" AND av.ProductID IN (298)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BW15F" AND av.ProductID IN (298)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BW16F" AND av.ProductID IN (298)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BW26F" AND av.ProductID IN (298)) OR (av.SupplierID = 475 AND av.DataSupplierArticleNumber = "BW14R" AND av.ProductID IN (298)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "3 397 006 943" AND av.ProductID IN (298)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "3 397 014 144" AND av.ProductID IN (298)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "3 397 008 577" AND av.ProductID IN (298)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "3 397 006 952" AND av.ProductID IN (298)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "3 397 008 587" AND av.ProductID IN (298)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "3 397 007 414" AND av.ProductID IN (298)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "3 397 004 631" AND av.ProductID IN (298)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "3 397 014 122" AND av.ProductID IN (298)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "3 397 007 561" AND av.ProductID IN (298)) OR (av.SupplierID = 43 AND av.DataSupplierArticleNumber = "EF65/B01" AND av.ProductID IN (298)) OR (av.SupplierID = 43 AND av.DataSupplierArticleNumber = "AFL6540A/C02" AND av.ProductID IN (298)) OR (av.SupplierID = 43 AND av.DataSupplierArticleNumber = "AP35/B01" AND av.ProductID IN (298)) OR (av.SupplierID = 43 AND av.DataSupplierArticleNumber = "AFL40/B01" AND av.ProductID IN (298)) OR (av.SupplierID = 43 AND av.DataSupplierArticleNumber = "EF40/B01" AND av.ProductID IN (298)) OR (av.SupplierID = 43 AND av.DataSupplierArticleNumber = "AFL65/B01" AND av.ProductID IN (298)) OR (av.SupplierID = 421 AND av.DataSupplierArticleNumber = "CFWB650" AND av.ProductID IN (298)) OR (av.SupplierID = 421 AND av.DataSupplierArticleNumber = "CRWB350F" AND av.ProductID IN (298)) OR (av.SupplierID = 421 AND av.DataSupplierArticleNumber = "CFWB400" AND av.ProductID IN (298)) OR (av.SupplierID = 66 AND av.DataSupplierArticleNumber = "DF-235" AND av.ProductID IN (298)) OR (av.SupplierID = 66 AND av.DataSupplierArticleNumber = "DF-044" AND av.ProductID IN (298)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "LWDF26A" AND av.ProductID IN (298)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "LWTF1626A" AND av.ProductID IN (298)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "LWDF16A" AND av.ProductID IN (298)) OR (av.SupplierID = 4938 AND av.DataSupplierArticleNumber = "FT93344" AND av.ProductID IN (301)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "9XW 197 765-161" AND av.ProductID IN (298)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "9XW 197 765-261" AND av.ProductID IN (298)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "9XW 190 680-161" AND av.ProductID IN (298)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "9XW 200 526-011" AND av.ProductID IN (298)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "9XW 190 680-261" AND av.ProductID IN (298)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "000723134001" AND av.ProductID IN (298)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "029 650 2600" AND av.ProductID IN (298)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "029 350 1410" AND av.ProductID IN (298)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "029 400 1600" AND av.ProductID IN (298)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "LVWB2651" AND av.ProductID IN (298)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "LVWB9117" AND av.ProductID IN (298)) OR (av.SupplierID = 4564 AND av.DataSupplierArticleNumber = "LVWB1651" AND av.ProductID IN (298)) OR (av.SupplierID = 378 AND av.DataSupplierArticleNumber = "WBS0016.00" AND av.ProductID IN (298)) OR (av.SupplierID = 378 AND av.DataSupplierArticleNumber = "WBS0026.00" AND av.ProductID IN (298)) OR (av.SupplierID = 378 AND av.DataSupplierArticleNumber = "WBR7002.00" AND av.ProductID IN (298)) OR (av.SupplierID = 4543 AND av.DataSupplierArticleNumber = "86010400" AND av.ProductID IN (298)) OR (av.SupplierID = 4543 AND av.DataSupplierArticleNumber = "86010650" AND av.ProductID IN (298)) OR (av.SupplierID = 4543 AND av.DataSupplierArticleNumber = "86010375" AND av.ProductID IN (298)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QAW022" AND av.ProductID IN (298)) OR (av.SupplierID = 19 AND av.DataSupplierArticleNumber = "116540" AND av.ProductID IN (298)) OR (av.SupplierID = 227 AND av.DataSupplierArticleNumber = "TF400L" AND av.ProductID IN (298)) OR (av.SupplierID = 227 AND av.DataSupplierArticleNumber = "FX650" AND av.ProductID IN (298)) OR (av.SupplierID = 227 AND av.DataSupplierArticleNumber = "EFB6518R" AND av.ProductID IN (298)) OR (av.SupplierID = 227 AND av.DataSupplierArticleNumber = "EFB4018L" AND av.ProductID IN (298)) OR (av.SupplierID = 227 AND av.DataSupplierArticleNumber = "TXB400" AND av.ProductID IN (298)) OR (av.SupplierID = 227 AND av.DataSupplierArticleNumber = "TF400R" AND av.ProductID IN (298)) OR (av.SupplierID = 227 AND av.DataSupplierArticleNumber = "NF409" AND av.ProductID IN (298)) OR (av.SupplierID = 227 AND av.DataSupplierArticleNumber = "EX354" AND av.ProductID IN (298)) OR (av.SupplierID = 227 AND av.DataSupplierArticleNumber = "EFB4018R" AND av.ProductID IN (298)) OR (av.SupplierID = 227 AND av.DataSupplierArticleNumber = "35-160" AND av.ProductID IN (298)) OR (av.SupplierID = 227 AND av.DataSupplierArticleNumber = "TXB650" AND av.ProductID IN (298)) OR (av.SupplierID = 227 AND av.DataSupplierArticleNumber = "TF650L" AND av.ProductID IN (298)) OR (av.SupplierID = 227 AND av.DataSupplierArticleNumber = "NF659" AND av.ProductID IN (298)) OR (av.SupplierID = 227 AND av.DataSupplierArticleNumber = "FX400" AND av.ProductID IN (298)) OR (av.SupplierID = 227 AND av.DataSupplierArticleNumber = "EFB6518L" AND av.ProductID IN (298)) OR (av.SupplierID = 227 AND av.DataSupplierArticleNumber = "35-260" AND av.ProductID IN (298)) OR (av.SupplierID = 227 AND av.DataSupplierArticleNumber = "TF650R" AND av.ProductID IN (298)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "578502" AND av.ProductID IN (298)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "578513" AND av.ProductID IN (298)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "574164" AND av.ProductID IN (298)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "576053" AND av.ProductID IN (298)) OR (av.SupplierID = 4894 AND av.DataSupplierArticleNumber = "FW-650" AND av.ProductID IN (298)) OR (av.SupplierID = 4894 AND av.DataSupplierArticleNumber = "HW-400" AND av.ProductID IN (298)) OR (av.SupplierID = 4894 AND av.DataSupplierArticleNumber = "FW-400" AND av.ProductID IN (298)) ) 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 = 442 AND aa.DataSupplierArticleNumber = "ASH4-650") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "WAR014") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "ASH4-400") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BW15F") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BW16F") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BW26F") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BW14R") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "3 397 006 943") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "3 397 014 144") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "3 397 008 577") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "3 397 006 952") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "3 397 008 587") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "3 397 007 414") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "3 397 004 631") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "3 397 014 122") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "3 397 007 561") OR (aa.SupplierID = 43 AND aa.DataSupplierArticleNumber = "EF65/B01") OR (aa.SupplierID = 43 AND aa.DataSupplierArticleNumber = "AFL6540A/C02") OR (aa.SupplierID = 43 AND aa.DataSupplierArticleNumber = "AP35/B01") OR (aa.SupplierID = 43 AND aa.DataSupplierArticleNumber = "AFL40/B01") OR (aa.SupplierID = 43 AND aa.DataSupplierArticleNumber = "EF40/B01") OR (aa.SupplierID = 43 AND aa.DataSupplierArticleNumber = "AFL65/B01") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CFWB650") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CRWB350F") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CFWB400") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DF-235") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DF-044") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LWDF26A") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LWTF1626A") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LWDF16A") OR (aa.SupplierID = 4938 AND aa.DataSupplierArticleNumber = "FT93344") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9XW 197 765-161") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9XW 197 765-261") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9XW 190 680-161") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9XW 200 526-011") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9XW 190 680-261") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "000723134001") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "029 650 2600") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "029 350 1410") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "029 400 1600") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVWB2651") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVWB9117") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVWB1651") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "WBS0016.00") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "WBS0026.00") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "WBR7002.00") OR (aa.SupplierID = 4543 AND aa.DataSupplierArticleNumber = "86010400") OR (aa.SupplierID = 4543 AND aa.DataSupplierArticleNumber = "86010650") OR (aa.SupplierID = 4543 AND aa.DataSupplierArticleNumber = "86010375") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QAW022") OR (aa.SupplierID = 19 AND aa.DataSupplierArticleNumber = "116540") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "TF400L") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "FX650") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "EFB6518R") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "EFB4018L") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "TXB400") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "TF400R") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "NF409") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "EX354") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "EFB4018R") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "35-160") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "TXB650") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "TF650L") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "NF659") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "FX400") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "EFB6518L") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "35-260") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "TF650R") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "578502") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "578513") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "574164") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "576053") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "FW-650") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "HW-400") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "FW-400") ) 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 = 442 AND aa.DataSupplierArticleNumber = "ASH4-650") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "WAR014") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "ASH4-400") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BW15F") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BW16F") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BW26F") OR (aa.SupplierID = 475 AND aa.DataSupplierArticleNumber = "BW14R") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "3 397 006 943") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "3 397 014 144") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "3 397 008 577") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "3 397 006 952") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "3 397 008 587") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "3 397 007 414") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "3 397 004 631") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "3 397 014 122") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "3 397 007 561") OR (aa.SupplierID = 43 AND aa.DataSupplierArticleNumber = "EF65/B01") OR (aa.SupplierID = 43 AND aa.DataSupplierArticleNumber = "AFL6540A/C02") OR (aa.SupplierID = 43 AND aa.DataSupplierArticleNumber = "AP35/B01") OR (aa.SupplierID = 43 AND aa.DataSupplierArticleNumber = "AFL40/B01") OR (aa.SupplierID = 43 AND aa.DataSupplierArticleNumber = "EF40/B01") OR (aa.SupplierID = 43 AND aa.DataSupplierArticleNumber = "AFL65/B01") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CFWB650") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CRWB350F") OR (aa.SupplierID = 421 AND aa.DataSupplierArticleNumber = "CFWB400") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DF-235") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DF-044") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LWDF26A") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LWTF1626A") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "LWDF16A") OR (aa.SupplierID = 4938 AND aa.DataSupplierArticleNumber = "FT93344") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9XW 197 765-161") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9XW 197 765-261") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9XW 190 680-161") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9XW 200 526-011") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "9XW 190 680-261") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "000723134001") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "029 650 2600") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "029 350 1410") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "029 400 1600") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVWB2651") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVWB9117") OR (aa.SupplierID = 4564 AND aa.DataSupplierArticleNumber = "LVWB1651") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "WBS0016.00") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "WBS0026.00") OR (aa.SupplierID = 378 AND aa.DataSupplierArticleNumber = "WBR7002.00") OR (aa.SupplierID = 4543 AND aa.DataSupplierArticleNumber = "86010400") OR (aa.SupplierID = 4543 AND aa.DataSupplierArticleNumber = "86010650") OR (aa.SupplierID = 4543 AND aa.DataSupplierArticleNumber = "86010375") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QAW022") OR (aa.SupplierID = 19 AND aa.DataSupplierArticleNumber = "116540") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "TF400L") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "FX650") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "EFB6518R") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "EFB4018L") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "TXB400") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "TF400R") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "NF409") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "EX354") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "EFB4018R") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "35-160") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "TXB650") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "TF650L") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "NF659") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "FX400") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "EFB6518L") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "35-260") OR (aa.SupplierID = 227 AND aa.DataSupplierArticleNumber = "TF650R") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "578502") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "578513") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "574164") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "576053") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "FW-650") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "HW-400") OR (aa.SupplierID = 4894 AND aa.DataSupplierArticleNumber = "FW-400") ) AND aa.Language = "ru" Продажа автозапчастей типа Стеклоочиститель / резина для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
ASHUKI ASH4-650 Щетка стеклоочистителя
WAR014 Щетка стеклоочистителя
ASH4-400 Щетка стеклоочистителя
BORG & BECK BW15F Щетка стеклоочистителя
BW16F Щетка стеклоочистителя
BW26F Щетка стеклоочистителя
BW14R Щетка стеклоочистителя
BOSCH 3 397 006 943 Щетка стеклоочистителя
3 397 014 144 Щетка стеклоочистителя
3 397 008 577 Щетка стеклоочистителя
3 397 006 952 Щетка стеклоочистителя
3 397 008 587 Щетка стеклоочистителя
3 397 007 414 Щетка стеклоочистителя
3 397 004 631 Щетка стеклоочистителя
3 397 014 122 Щетка стеклоочистителя
3 397 007 561 Щетка стеклоочистителя
CHAMPION EF65/B01 Щетка стеклоочистителя
AFL6540A/C02 Щетка стеклоочистителя
AP35/B01 Щетка стеклоочистителя
AFL40/B01 Щетка стеклоочистителя
EF40/B01 Щетка стеклоочистителя
AFL65/B01 Щетка стеклоочистителя
COMLINE CFWB650 Щетка стеклоочистителя
CRWB350F Щетка стеклоочистителя
CFWB400 Щетка стеклоочистителя
DENSO DF-235 Щетка стеклоочистителя
DF-044 Щетка стеклоочистителя
ELTA AUTOMOTIVE LWDF26A Щетка стеклоочистителя
LWTF1626A Щетка стеклоочистителя
LWDF16A Щетка стеклоочистителя
FAST FT93344 Рычаг стеклоочистителя, система очистки окон
HELLA 9XW 197 765-161 Щетка стеклоочистителя
9XW 197 765-261 Щетка стеклоочистителя
9XW 190 680-161 Щетка стеклоочистителя
9XW 200 526-011 Щетка стеклоочистителя
9XW 190 680-261 Щетка стеклоочистителя
MAGNETI MARELLI 000723134001 Щетка стеклоочистителя
MEYLE 029 650 2600 Щетка стеклоочистителя
029 350 1410 Щетка стеклоочистителя
029 400 1600 Щетка стеклоочистителя
MOTAQUIP LVWB2651 Щетка стеклоочистителя
LVWB9117 Щетка стеклоочистителя
LVWB1651 Щетка стеклоочистителя
OPEN PARTS WBS0016.00 Щетка стеклоочистителя
WBS0026.00 Щетка стеклоочистителя
WBR7002.00 Щетка стеклоочистителя
PowerMax 86010400 Щетка стеклоочистителя
86010650 Щетка стеклоочистителя
86010375 Щетка стеклоочистителя
QUINTON HAZELL QAW022 Щетка стеклоочистителя
SWF 116540 Щетка стеклоочистителя
TRICO TF400L Щетка стеклоочистителя
FX650 Щетка стеклоочистителя
EFB6518R Щетка стеклоочистителя
EFB4018L Щетка стеклоочистителя
TXB400 Щетка стеклоочистителя
TF400R Щетка стеклоочистителя
NF409 Щетка стеклоочистителя
EX354 Щетка стеклоочистителя
EFB4018R Щетка стеклоочистителя
35-160 Щетка стеклоочистителя
TXB650 Щетка стеклоочистителя
TF650L Щетка стеклоочистителя
NF659 Щетка стеклоочистителя
FX400 Щетка стеклоочистителя
EFB6518L Щетка стеклоочистителя
35-260 Щетка стеклоочистителя
TF650R Щетка стеклоочистителя
VALEO 578502 Щетка стеклоочистителя
578513 Щетка стеклоочистителя
574164 Щетка стеклоочистителя
576053 Щетка стеклоочистителя
ZEKKERT FW-650 Щетка стеклоочистителя
HW-400 Щетка стеклоочистителя
FW-400 Щетка стеклоочистителя
2026 CATCAR.INFO (v 2.0)