#216.73.216.140 www.catcar.info/totalcatalog/?l=YnJhbmRfaWQ9PTUyNHx8bW9kZWxfaWQ9PTE4OTB8fG1kZl9pZD09MF4xMjQ4MTd8fHNwYXJlX2lkPT0xMDA0NDI%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 = "124817" AND ( (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "1 987 302 021" 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 = 30 AND aa.DataSupplierArticleNumber = "1 987 302 021") ) 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 = 30 AND aa.DataSupplierArticleNumber = "1 987 302 021") ) AND aa.Language = "ru" Продажа автозапчастей типа Лампа накаливания фара дальнего света для автомобилей - Catcar.info
Каталог автозапчастей
Catcar Aftermarket
Русский English
Каталог автозапчастей
Catcar Aftermarket
Уже продаёте автозапчасти? Подключите каталоги на свой сайт, чтобы повысить продажи
Подключить каталоги

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


Производители Артикул Наименование Сведения Полная информация
BOSCH 1 987 302 021 Лампа накаливания, фара дальнего света
2026 CATCAR.INFO
2026 CATCAR.INFO (v 2.0)