#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU3NXx8bW9kZWxfaWQ9PTc1ODh8fG1kZl9pZD09MF4yODI4Mnx8c3BhcmVfaWQ9PTEwMDM0Mg%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 = "28282" AND ( (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "5902-06-0236" AND av.ProductID IN (795)) OR (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "5902-06-0058P" AND av.ProductID IN (1280)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "954631" AND av.ProductID IN (795)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "26274" AND av.ProductID IN (795)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "8TW 004 764-021" AND av.ProductID IN (795)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1198500700" AND av.ProductID IN (795)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "90813" AND av.ProductID IN (795)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "45-0028" AND av.ProductID IN (795)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "2220023" AND av.ProductID IN (795)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "2220500" AND av.ProductID IN (1280)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "32 92 6274" AND av.ProductID IN (795)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "110 472" AND av.ProductID IN (795)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "190382" AND av.ProductID IN (795)) OR (av.SupplierID = 83 AND av.DataSupplierArticleNumber = "246-086-001-007Z" AND av.ProductID IN (795)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V10-08-0208" AND av.ProductID IN (795)) ) 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 = 4555 AND aa.DataSupplierArticleNumber = "5902-06-0236") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "5902-06-0058P") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "954631") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "26274") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8TW 004 764-021") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1198500700") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "90813") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "45-0028") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2220023") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2220500") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "32 92 6274") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "110 472") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "190382") OR (aa.SupplierID = 83 AND aa.DataSupplierArticleNumber = "246-086-001-007Z") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V10-08-0208") ) 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 = 4555 AND aa.DataSupplierArticleNumber = "5902-06-0236") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "5902-06-0058P") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "954631") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "26274") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8TW 004 764-021") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1198500700") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "90813") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "45-0028") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2220023") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2220500") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "32 92 6274") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "110 472") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "190382") OR (aa.SupplierID = 83 AND aa.DataSupplierArticleNumber = "246-086-001-007Z") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V10-08-0208") ) AND aa.Language = "ru" Продажа автозапчастей типа Система очистки фар для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
BLIC 5902-06-0236 Водяной насос, система очистки фар
5902-06-0058P Распылитель воды для чистки, система очистки фар
CAUTEX 954631 Водяной насос, система очистки фар
FEBI BILSTEIN 26274 Водяной насос, система очистки фар
HELLA 8TW 004 764-021 Водяной насос, система очистки фар
JP GROUP 1198500700 Водяной насос, система очистки фар
MAPCO 90813 Водяной насос, система очистки фар
MAXGEAR 45-0028 Водяной насос, система очистки фар
METZGER 2220023 Водяной насос, система очистки фар
2220500 Распылитель воды для чистки, система очистки фар
SWAG 32 92 6274 Водяной насос, система очистки фар
TOPRAN 110 472 Водяной насос, система очистки фар
TRICLO 190382 Водяной насос, система очистки фар
VDO 246-086-001-007Z Водяной насос, система очистки фар
VEMO V10-08-0208 Водяной насос, система очистки фар
2026 CATCAR.INFO (v 2.0)