#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUwNHx8bW9kZWxfaWQ9PTMzOTV8fG1kZl9pZD09MF4xNTY2M3x8c3BhcmVfaWQ9PTEwMDMyMQ%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 = "15663" AND ( (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "102.318" AND av.ProductID IN (138)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "635.290" AND av.ProductID IN (138)) OR (av.SupplierID = 237 AND av.DataSupplierArticleNumber = "3023029" AND av.ProductID IN (138)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1121200300" AND av.ProductID IN (138)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "JE689" AND av.ProductID IN (138)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "103 608" AND av.ProductID IN (138)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "107 206" AND av.ProductID IN (138)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V10-1828" AND av.ProductID IN (138)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1007111" AND av.ProductID IN (138)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1448299" AND av.ProductID IN (138)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1193984" AND av.ProductID IN (138)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1158173" AND av.ProductID IN (138)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1230173" AND av.ProductID IN (138)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1182218" AND av.ProductID IN (138)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1246557" AND av.ProductID IN (138)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1190505" AND av.ProductID IN (138)) ) 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 = 10 AND aa.DataSupplierArticleNumber = "102.318") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "635.290") OR (aa.SupplierID = 237 AND aa.DataSupplierArticleNumber = "3023029") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1121200300") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "JE689") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "103 608") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "107 206") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-1828") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1007111") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1448299") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1193984") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1158173") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1230173") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1182218") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1246557") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1190505") ) 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 = 10 AND aa.DataSupplierArticleNumber = "102.318") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "635.290") OR (aa.SupplierID = 237 AND aa.DataSupplierArticleNumber = "3023029") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1121200300") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "JE689") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "103 608") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "107 206") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V10-1828") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1007111") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1448299") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1193984") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1158173") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1230173") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1182218") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1246557") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1190505") ) AND aa.Language = "ru" Продажа автозапчастей типа Прокладка для автомобилей

Выбор автозапчасти

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
ELRING 102.318 Прокладка, труба выхлопного газа
635.290 Прокладка, труба выхлопного газа
ELWIS ROYAL 3023029 Прокладка, труба выхлопного газа
JP GROUP 1121200300 Прокладка, труба выхлопного газа
PAYEN JE689 Прокладка, труба выхлопного газа
TOPRAN 103 608 Прокладка, труба выхлопного газа
107 206 Прокладка, труба выхлопного газа
VAICO V10-1828 Прокладка, труба выхлопного газа
WILMINK GROUP WG1007111 Прокладка, труба выхлопного газа
WG1448299 Прокладка, труба выхлопного газа
WG1193984 Прокладка, труба выхлопного газа
WG1158173 Прокладка, труба выхлопного газа
WG1230173 Прокладка, труба выхлопного газа
WG1182218 Прокладка, труба выхлопного газа
WG1246557 Прокладка, труба выхлопного газа
WG1190505 Прокладка, труба выхлопного газа
2026 CATCAR.INFO (v 2.0)