#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUxN3x8bW9kZWxfaWQ9PTUzOTJ8fG1kZl9pZD09MF4xODQ4M3x8c3BhcmVfaWQ9PTEwMDc4OQ%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 = "18483" AND ( (av.SupplierID = 139 AND av.DataSupplierArticleNumber = "15012800" AND av.ProductID IN (572)) OR (av.SupplierID = 139 AND av.DataSupplierArticleNumber = "15062900" AND av.ProductID IN (572)) OR (av.SupplierID = 478 AND av.DataSupplierArticleNumber = "OS0318" AND av.ProductID IN (572)) OR (av.SupplierID = 478 AND av.DataSupplierArticleNumber = "OS5311" AND av.ProductID IN (572)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "19026732B" AND av.ProductID IN (572)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "19026733B" AND av.ProductID IN (572)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "010.360" AND av.ProductID IN (572)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "458.620" AND av.ProductID IN (572)) OR (av.SupplierID = 237 AND av.DataSupplierArticleNumber = "8452810" AND av.ProductID IN (757)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "OS1833" AND av.ProductID IN (572)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "OS1832" AND av.ProductID IN (572)) OR (av.SupplierID = 60 AND av.DataSupplierArticleNumber = "50-319582-00" AND av.ProductID IN (572)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "NJ353" AND av.ProductID IN (572)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "NA5324" AND av.ProductID IN (572)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "NJ286" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1183804" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1163052" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1189880" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1163421" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1192934" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1183282" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1090838" AND av.ProductID IN (572)) ) 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 = 139 AND aa.DataSupplierArticleNumber = "15012800") OR (aa.SupplierID = 139 AND aa.DataSupplierArticleNumber = "15062900") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "OS0318") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "OS5311") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "19026732B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "19026733B") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "010.360") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "458.620") OR (aa.SupplierID = 237 AND aa.DataSupplierArticleNumber = "8452810") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "OS1833") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "OS1832") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "50-319582-00") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NJ353") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NA5324") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NJ286") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1183804") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1163052") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1189880") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1163421") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1192934") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1183282") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1090838") ) 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 = 139 AND aa.DataSupplierArticleNumber = "15012800") OR (aa.SupplierID = 139 AND aa.DataSupplierArticleNumber = "15062900") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "OS0318") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "OS5311") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "19026732B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "19026733B") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "010.360") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "458.620") OR (aa.SupplierID = 237 AND aa.DataSupplierArticleNumber = "8452810") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "OS1833") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "OS1832") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "50-319582-00") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NJ353") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NA5324") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NJ286") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1183804") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1163052") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1189880") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1163421") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1192934") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1183282") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1090838") ) AND aa.Language = "ru" Продажа автозапчастей типа Прокладка/комплект прокладок вала для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AJUSA 15012800 Уплотняющее кольцо, коленчатый вал
15062900 Уплотняющее кольцо, коленчатый вал
BGA OS0318 Уплотняющее кольцо, коленчатый вал
OS5311 Уплотняющее кольцо, коленчатый вал
CORTECO 19026732B Уплотняющее кольцо, коленчатый вал
19026733B Уплотняющее кольцо, коленчатый вал
ELRING 010.360 Уплотняющее кольцо, коленчатый вал
458.620 Уплотняющее кольцо, коленчатый вал
ELWIS ROYAL 8452810 Уплотняющее кольцо, распределительный вал
FAI AutoParts OS1833 Уплотняющее кольцо, коленчатый вал
OS1832 Уплотняющее кольцо, коленчатый вал
GOETZE 50-319582-00 Уплотняющее кольцо, коленчатый вал
PAYEN NJ353 Уплотняющее кольцо, коленчатый вал
NA5324 Уплотняющее кольцо, коленчатый вал
NJ286 Уплотняющее кольцо, коленчатый вал
WILMINK GROUP WG1183804 Уплотняющее кольцо, коленчатый вал
WG1163052 Уплотняющее кольцо, коленчатый вал
WG1189880 Уплотняющее кольцо, коленчатый вал
WG1163421 Уплотняющее кольцо, коленчатый вал
WG1192934 Уплотняющее кольцо, коленчатый вал
WG1183282 Уплотняющее кольцо, коленчатый вал
WG1090838 Уплотняющее кольцо, коленчатый вал
2026 CATCAR.INFO (v 2.0)