#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2Nnx8bW9kZWxfaWQ9PTY0NDd8fG1kZl9pZD09MF4yMzQ2Nnx8c3BhcmVfaWQ9PTEwMjc5NQ%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 = "23466" AND ( (av.SupplierID = 4598 AND av.DataSupplierArticleNumber = "81637" AND av.ProductID IN (3891)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "1 987 972 077" AND av.ProductID IN (4051)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "331.680" AND av.ProductID IN (4051)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "30253" AND av.ProductID IN (3891)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "60 93 0253" AND av.ProductID IN (3891)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1087611" AND av.ProductID IN (4051)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1430856" AND av.ProductID IN (3891)) ) 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 = "81637") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "1 987 972 077") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "331.680") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "30253") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "60 93 0253") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1087611") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1430856") ) 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 = "81637") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "1 987 972 077") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "331.680") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "30253") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "60 93 0253") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1087611") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1430856") ) AND aa.Language = "ru" Продажа автозапчастей типа Прокладка для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
3RG 81637 Уплотнительное кольцо, клапанная форсунка
BOSCH 1 987 972 077 Прокладка, корпус форсунки
ELRING 331.680 Прокладка, корпус форсунки
FEBI BILSTEIN 30253 Уплотнительное кольцо, клапанная форсунка
SWAG 60 93 0253 Уплотнительное кольцо, клапанная форсунка
WILMINK GROUP WG1087611 Прокладка, корпус форсунки
WG1430856 Уплотнительное кольцо, клапанная форсунка
2026 CATCAR.INFO (v 2.0)