#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2MXx8bW9kZWxfaWQ9PTM5OTV8fG1kZl9pZD09MF4xNTM1Nnx8c3BhcmVfaWQ9PTEwMTY2Mg%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 = "15356" AND ( (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "2901164" AND av.ProductID IN (289)) OR (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "2902164" AND av.ProductID IN (289)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 30-815-004" AND av.ProductID IN (289)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "4464288" AND av.ProductID IN (289)) OR (av.SupplierID = 72 AND av.DataSupplierArticleNumber = "80660030" AND av.ProductID IN (289)) OR (av.SupplierID = 72 AND av.DataSupplierArticleNumber = "80660031" AND av.ProductID IN (289)) OR (av.SupplierID = 138 AND av.DataSupplierArticleNumber = "60 03 30-2" AND av.ProductID IN (289)) OR (av.SupplierID = 138 AND av.DataSupplierArticleNumber = "60 03 29-2" AND av.ProductID IN (289)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "60050282" AND av.ProductID IN (289)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "60320281A1" AND av.ProductID IN (289)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "60320282A1" AND av.ProductID IN (289)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "60050281" AND av.ProductID IN (289)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "712372811129" AND av.ProductID IN (289)) OR (av.SupplierID = 95 AND av.DataSupplierArticleNumber = "712372911129" AND av.ProductID IN (289)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "RN3044413" AND av.ProductID IN (289)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "RN3044414" AND av.ProductID IN (289)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "621009" AND av.ProductID IN (289)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "621010" AND av.ProductID IN (289)) OR (av.SupplierID = 61 AND av.DataSupplierArticleNumber = "19-5319-05-2" AND av.ProductID IN (289)) OR (av.SupplierID = 61 AND av.DataSupplierArticleNumber = "19-5320-05-2" AND av.ProductID IN (289)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "047401" AND av.ProductID IN (289)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "088358" AND av.ProductID IN (289)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "4343996" AND av.ProductID IN (289)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "4343995" AND av.ProductID IN (289)) ) 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 = 362 AND aa.DataSupplierArticleNumber = "2901164") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "2902164") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 30-815-004") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "4464288") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "80660030") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "80660031") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "60 03 30-2") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "60 03 29-2") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "60050282") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "60320281A1") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "60320282A1") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "60050281") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "712372811129") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "712372911129") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "RN3044413") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "RN3044414") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "621009") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "621010") OR (aa.SupplierID = 61 AND aa.DataSupplierArticleNumber = "19-5319-05-2") OR (aa.SupplierID = 61 AND aa.DataSupplierArticleNumber = "19-5320-05-2") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "047401") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "088358") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "4343996") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "4343995") ) 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 = 362 AND aa.DataSupplierArticleNumber = "2901164") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "2902164") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 30-815-004") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "4464288") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "80660030") OR (aa.SupplierID = 72 AND aa.DataSupplierArticleNumber = "80660031") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "60 03 30-2") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "60 03 29-2") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "60050282") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "60320281A1") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "60320282A1") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "60050281") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "712372811129") OR (aa.SupplierID = 95 AND aa.DataSupplierArticleNumber = "712372911129") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "RN3044413") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "RN3044414") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "621009") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "621010") OR (aa.SupplierID = 61 AND aa.DataSupplierArticleNumber = "19-5319-05-2") OR (aa.SupplierID = 61 AND aa.DataSupplierArticleNumber = "19-5320-05-2") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "047401") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "088358") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "4343996") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "4343995") ) AND aa.Language = "ru" Продажа автозапчастей типа Противотуманная фара / вставка для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
ALKAR 2901164 Противотуманная фара
2902164 Противотуманная фара
BSG BSG 30-815-004 Противотуманная фара
DIEDERICHS 4464288 Противотуманная фара
HERTH+BUSS ELPARTS 80660030 Противотуманная фара
80660031 Противотуманная фара
JOHNS 60 03 30-2 Противотуманная фара
60 03 29-2 Противотуманная фара
KLOKKERHOLM 60050282 Противотуманная фара
60320281A1 Противотуманная фара
60320282A1 Противотуманная фара
60050281 Противотуманная фара
MAGNETI MARELLI 712372811129 Противотуманная фара
712372911129 Противотуманная фара
PRASCO RN3044413 Противотуманная фара
RN3044414 Противотуманная фара
SPILU 621009 Противотуманная фара
621010 Противотуманная фара
TYC 19-5319-05-2 Противотуманная фара
19-5320-05-2 Противотуманная фара
VALEO 047401 Противотуманная фара
088358 Противотуманная фара
VAN WEZEL 4343996 Противотуманная фара
4343995 Противотуманная фара
2026 CATCAR.INFO (v 2.0)