#216.73.216.140 catcar.info/totalcatalog/?l=YnJhbmRfaWQ9PTU3Mnx8bW9kZWxfaWQ9PTU1MzV8fG1kZl9pZD09MV41MTE2fHxzcGFyZV9pZD09MjAxMDcx&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 articlecommercialvehicles av JOIN commercialvehiclelinkageattributes_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 = "5116" AND ( (av.SupplierID = 4696 AND av.DataSupplierArticleNumber = "BPA-SC001B" AND av.ProductID IN (472)) OR (av.SupplierID = 4696 AND av.DataSupplierArticleNumber = "BPC-SC008R" AND av.ProductID IN (473)) OR (av.SupplierID = 4696 AND av.DataSupplierArticleNumber = "SCA-MG-001" AND av.ProductID IN (472)) OR (av.SupplierID = 4696 AND av.DataSupplierArticleNumber = "BPA-SC001C" AND av.ProductID IN (472)) OR (av.SupplierID = 4696 AND av.DataSupplierArticleNumber = "BPA-SC001D" AND av.ProductID IN (472)) OR (av.SupplierID = 4696 AND av.DataSupplierArticleNumber = "BPA-SC001A" AND av.ProductID IN (472)) OR (av.SupplierID = 4696 AND av.DataSupplierArticleNumber = "BPC-SC008L" AND av.ProductID IN (473)) OR (av.SupplierID = 4696 AND av.DataSupplierArticleNumber = "SCA-FP-001" AND av.ProductID IN (472)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "1840 0050" AND av.ProductID IN (472)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "1840 0004" AND av.ProductID IN (472)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "1840 0327" AND av.ProductID IN (473)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "1840 0051" AND av.ProductID IN (472)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "1840 0005" AND av.ProductID IN (472)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "1840 0328" AND av.ProductID IN (473)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "042.304" AND av.ProductID IN (473)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "1840 0006" AND av.ProductID IN (472)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "1840 0003" AND av.ProductID IN (472)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "042.305" AND av.ProductID IN (473)) ) 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 = 4696 AND aa.DataSupplierArticleNumber = "BPA-SC001B") OR (aa.SupplierID = 4696 AND aa.DataSupplierArticleNumber = "BPC-SC008R") OR (aa.SupplierID = 4696 AND aa.DataSupplierArticleNumber = "SCA-MG-001") OR (aa.SupplierID = 4696 AND aa.DataSupplierArticleNumber = "BPA-SC001C") OR (aa.SupplierID = 4696 AND aa.DataSupplierArticleNumber = "BPA-SC001D") OR (aa.SupplierID = 4696 AND aa.DataSupplierArticleNumber = "BPA-SC001A") OR (aa.SupplierID = 4696 AND aa.DataSupplierArticleNumber = "BPC-SC008L") OR (aa.SupplierID = 4696 AND aa.DataSupplierArticleNumber = "SCA-FP-001") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "1840 0050") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "1840 0004") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "1840 0327") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "1840 0051") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "1840 0005") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "1840 0328") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "042.304") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "1840 0006") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "1840 0003") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "042.305") ) 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 = 4696 AND aa.DataSupplierArticleNumber = "BPA-SC001B") OR (aa.SupplierID = 4696 AND aa.DataSupplierArticleNumber = "BPC-SC008R") OR (aa.SupplierID = 4696 AND aa.DataSupplierArticleNumber = "SCA-MG-001") OR (aa.SupplierID = 4696 AND aa.DataSupplierArticleNumber = "BPA-SC001C") OR (aa.SupplierID = 4696 AND aa.DataSupplierArticleNumber = "BPA-SC001D") OR (aa.SupplierID = 4696 AND aa.DataSupplierArticleNumber = "BPA-SC001A") OR (aa.SupplierID = 4696 AND aa.DataSupplierArticleNumber = "BPC-SC008L") OR (aa.SupplierID = 4696 AND aa.DataSupplierArticleNumber = "SCA-FP-001") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "1840 0050") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "1840 0004") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "1840 0327") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "1840 0051") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "1840 0005") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "1840 0328") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "042.304") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "1840 0006") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "1840 0003") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "042.305") ) AND aa.Language = "ru" Продажа автозапчастей типа Облицовка передка/ передняя решетка для автомобилей - Catcar.info
Каталог автозапчастей
Catcar Aftermarket
Каталог автозапчастей
Catcar Aftermarket
Уже продаёте автозапчасти? Подключите каталоги на свой сайт, чтобы повысить продажи
Подключить каталоги

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


Производители Артикул Наименование Сведения Полная информация
PACOL BPA-SC001B Решетка радиатора
BPC-SC008R Кронштейн, облицовка радиатора
SCA-MG-001 Решетка радиатора
BPA-SC001C Решетка радиатора
BPA-SC001D Решетка радиатора
BPA-SC001A Решетка радиатора
BPC-SC008L Кронштейн, облицовка радиатора
SCA-FP-001 Решетка радиатора
SAMPA 1840 0050 Решетка радиатора
1840 0004 Решетка радиатора
1840 0327 Кронштейн, облицовка радиатора
1840 0051 Решетка радиатора
1840 0005 Решетка радиатора
1840 0328 Кронштейн, облицовка радиатора
042.304 Кронштейн, облицовка радиатора
1840 0006 Решетка радиатора
1840 0003 Решетка радиатора
042.305 Кронштейн, облицовка радиатора
2026 CATCAR.INFO (v 2.0)