#216.73.216.140 catcar.info/totalcatalog/?l=YnJhbmRfaWQ9PTUyNXx8bW9kZWxfaWQ9PTUyMTB8fG1kZl9pZD09MF4xODM3OXx8c3BhcmVfaWQ9PTEwMDQ3Mg%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 = "18379" AND ( (av.SupplierID = 4598 AND av.DataSupplierArticleNumber = "81219" AND av.ProductID IN (3323)) OR (av.SupplierID = 208 AND av.DataSupplierArticleNumber = "80032" AND av.ProductID IN (3323)) OR (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "9924" AND av.ProductID IN (3323)) OR (av.SupplierID = 317 AND av.DataSupplierArticleNumber = "136002" AND av.ProductID IN (590)) OR (av.SupplierID = 4664 AND av.DataSupplierArticleNumber = "03837" AND av.ProductID IN (3323)) OR (av.SupplierID = 4667 AND av.DataSupplierArticleNumber = "T403837" AND av.ProductID IN (3323)) ) 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 = 4598 AND aa.DataSupplierArticleNumber = "81219") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "80032") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "9924") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "136002") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "03837") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T403837") ) 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 = 4598 AND aa.DataSupplierArticleNumber = "81219") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "80032") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "9924") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "136002") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "03837") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T403837") ) AND aa.Language = "ru" Продажа автозапчастей типа Корпус топливного фильтра / прокладка для автомобилей - Catcar.info
Каталог автозапчастей
Catcar Aftermarket
Каталог автозапчастей
Catcar Aftermarket
Уже продаёте автозапчасти? Подключите каталоги на свой сайт, чтобы повысить продажи
Подключить каталоги

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


Производители Артикул Наименование Сведения Полная информация
3RG 81219 Крышка, корпус масляного фильтра
BIRTH 80032 Крышка, корпус масляного фильтра
FARE SA 9924 Крышка, корпус масляного фильтра
MALÒ 136002 Корпус, масляный фильтр
Metalcaucho 03837 Крышка, корпус масляного фильтра
STC T403837 Крышка, корпус масляного фильтра
2026 CATCAR.INFO (v 2.0)