#216.73.216.140 catcar.info/totalcatalog/?l=YnJhbmRfaWQ9PTU2MXx8bW9kZWxfaWQ9PTUwfHxtZGZfaWQ9PTBeNTc4fHxzcGFyZV9pZD09MTAwMzc5&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 = "578" AND ( (av.SupplierID = 208 AND av.DataSupplierArticleNumber = "8703" AND av.ProductID IN (597)) OR (av.SupplierID = 208 AND av.DataSupplierArticleNumber = "8085" AND av.ProductID IN (597)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 65-700-198" AND av.ProductID IN (597)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "481076" AND av.ProductID IN (597)) OR (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "4683" AND av.ProductID IN (597)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "01213" AND av.ProductID IN (597)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "01218" AND av.ProductID IN (598)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1213600400" AND av.ProductID IN (597)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "1130970" AND av.ProductID IN (598)) OR (av.SupplierID = 317 AND av.DataSupplierArticleNumber = "134022" AND av.ProductID IN (597)) OR (av.SupplierID = 4664 AND av.DataSupplierArticleNumber = "03682" AND av.ProductID IN (597)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "2141012" AND av.ProductID IN (597)) OR (av.SupplierID = 331 AND av.DataSupplierArticleNumber = "29623" AND av.ProductID IN (597)) OR (av.SupplierID = 4683 AND av.DataSupplierArticleNumber = "02541" AND av.ProductID IN (597)) OR (av.SupplierID = 4667 AND av.DataSupplierArticleNumber = "T403682" AND av.ProductID IN (597)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "40 22 0002" AND av.ProductID IN (597)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "40 22 0001" AND av.ProductID IN (598)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "318088" AND av.ProductID IN (597)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V40-0481" AND av.ProductID IN (597)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1795609" AND av.ProductID IN (597)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1795608" AND av.ProductID IN (598)) ) 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 = 208 AND aa.DataSupplierArticleNumber = "8703") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "8085") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 65-700-198") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "481076") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "4683") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "01213") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "01218") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1213600400") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "1130970") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "134022") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "03682") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2141012") OR (aa.SupplierID = 331 AND aa.DataSupplierArticleNumber = "29623") OR (aa.SupplierID = 4683 AND aa.DataSupplierArticleNumber = "02541") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T403682") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "40 22 0002") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "40 22 0001") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "318088") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V40-0481") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1795609") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1795608") ) 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 = 208 AND aa.DataSupplierArticleNumber = "8703") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "8085") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 65-700-198") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "481076") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "4683") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "01213") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "01218") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1213600400") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "1130970") OR (aa.SupplierID = 317 AND aa.DataSupplierArticleNumber = "134022") OR (aa.SupplierID = 4664 AND aa.DataSupplierArticleNumber = "03682") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2141012") OR (aa.SupplierID = 331 AND aa.DataSupplierArticleNumber = "29623") OR (aa.SupplierID = 4683 AND aa.DataSupplierArticleNumber = "02541") OR (aa.SupplierID = 4667 AND aa.DataSupplierArticleNumber = "T403682") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "40 22 0002") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "40 22 0001") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "318088") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V40-0481") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1795609") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1795608") ) AND aa.Language = "ru" Продажа автозапчастей типа Крышка маслозаливной горловины / прокладка для автомобилей - Catcar.info
Каталог автозапчастей
Catcar Aftermarket
Каталог автозапчастей
Catcar Aftermarket
Уже продаёте автозапчасти? Подключите каталоги на свой сайт, чтобы повысить продажи
Подключить каталоги

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


Производители Артикул Наименование Сведения Полная информация
BIRTH 8703 Крышка, заливная горловина
8085 Крышка, заливная горловина
BSG BSG 65-700-198 Крышка, заливная горловина
CAUTEX 481076 Крышка, заливная горловина
FARE SA 4683 Крышка, заливная горловина
FEBI BILSTEIN 01213 Крышка, заливная горловина
01218 Прокладка, маслоналивная горловина
JP GROUP 1213600400 Крышка, заливная горловина
KRAFT AUTOMOTIVE 1130970 Прокладка, маслоналивная горловина
MALÒ 134022 Крышка, заливная горловина
Metalcaucho 03682 Крышка, заливная горловина
METZGER 2141012 Крышка, заливная горловина
ORIGINAL IMPERIUM 29623 Крышка, заливная горловина
OSSCA 02541 Крышка, заливная горловина
STC T403682 Крышка, заливная горловина
SWAG 40 22 0002 Крышка, заливная горловина
40 22 0001 Прокладка, маслоналивная горловина
TRICLO 318088 Крышка, заливная горловина
VAICO V40-0481 Крышка, заливная горловина
WILMINK GROUP WG1795609 Крышка, заливная горловина
WG1795608 Прокладка, маслоналивная горловина
2026 CATCAR.INFO (v 2.0)