#216.73.216.140 catcar.info/totalcatalog/?l=YnJhbmRfaWQ9PTUyNXx8bW9kZWxfaWQ9PTU1NzN8fG1kZl9pZD09MF4xMTk3MHx8c3BhcmVfaWQ9PTEwMTM0Mg%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 = "11970" AND ( (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "2903228" 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 = "4464188" AND av.ProductID IN (3331)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "4464288" AND av.ProductID IN (289)) OR (av.SupplierID = 138 AND av.DataSupplierArticleNumber = "60 22 29" AND av.ProductID IN (289)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "25760280" AND av.ProductID IN (289)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "60410280A1" AND av.ProductID IN (289)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "609005" AND av.ProductID IN (289)) OR (av.SupplierID = 61 AND av.DataSupplierArticleNumber = "19-5785-10-21" AND av.ProductID IN (289)) OR (av.SupplierID = 61 AND av.DataSupplierArticleNumber = "19-5785-11-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 = "4327999V" AND av.ProductID IN (289)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "4327999" 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 = "2903228") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 30-815-004") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "4464188") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "4464288") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "60 22 29") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "25760280") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "60410280A1") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "609005") OR (aa.SupplierID = 61 AND aa.DataSupplierArticleNumber = "19-5785-10-21") OR (aa.SupplierID = 61 AND aa.DataSupplierArticleNumber = "19-5785-11-2") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "047401") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "088358") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "4327999V") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "4327999") ) 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 = "2903228") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 30-815-004") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "4464188") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "4464288") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "60 22 29") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "25760280") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "60410280A1") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "609005") OR (aa.SupplierID = 61 AND aa.DataSupplierArticleNumber = "19-5785-10-21") OR (aa.SupplierID = 61 AND aa.DataSupplierArticleNumber = "19-5785-11-2") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "047401") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "088358") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "4327999V") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "4327999") ) AND aa.Language = "ru" Продажа автозапчастей типа Противотуманная фара / вставка для автомобилей - Catcar.info
Каталог автозапчастей
Catcar Aftermarket
Каталог автозапчастей
Catcar Aftermarket
Уже продаёте автозапчасти? Подключите каталоги на свой сайт, чтобы повысить продажи
Подключить каталоги

Автозапчасти


Производители Артикул Наименование Сведения Полная информация
ALKAR 2903228 Противотуманная фара
BSG BSG 30-815-004 Противотуманная фара
DIEDERICHS 4464188 Комплект противотуманных фар
4464288 Противотуманная фара
JOHNS 60 22 29 Противотуманная фара
KLOKKERHOLM 25760280 Противотуманная фара
60410280A1 Противотуманная фара
SPILU 609005 Противотуманная фара
TYC 19-5785-10-21 Противотуманная фара
19-5785-11-2 Противотуманная фара
VALEO 047401 Противотуманная фара
088358 Противотуманная фара
VAN WEZEL 4327999V Противотуманная фара
4327999 Противотуманная фара
2026 CATCAR.INFO (v 2.0)