#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2MXx8bW9kZWxfaWQ9PTE4MDZ8fG1kZl9pZD09MF4xODg3MXx8c3BhcmVfaWQ9PTEwMDc4OQ%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 = "18871" AND ( (av.SupplierID = 478 AND av.DataSupplierArticleNumber = "OS3304" AND av.ProductID IN (572)) OR (av.SupplierID = 478 AND av.DataSupplierArticleNumber = "OS5317" AND av.ProductID IN (572)) OR (av.SupplierID = 478 AND av.DataSupplierArticleNumber = "OS6306" AND av.ProductID IN (572)) OR (av.SupplierID = 4693 AND av.DataSupplierArticleNumber = "N10002BTA" AND av.ProductID IN (757)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "12013882B" AND av.ProductID IN (572)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "20011244B" AND av.ProductID IN (757)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "12013858B" AND av.ProductID IN (572)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "OS697" AND av.ProductID IN (572)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "OS698" AND av.ProductID IN (572)) OR (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "P76200-01" AND av.ProductID IN (572)) OR (av.SupplierID = 60 AND av.DataSupplierArticleNumber = "50-305272-00" AND av.ProductID IN (572)) OR (av.SupplierID = 60 AND av.DataSupplierArticleNumber = "33-131120-00" AND av.ProductID IN (572)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "1151580" AND av.ProductID IN (572)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "NB628" AND av.ProductID IN (572)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "NB691" AND av.ProductID IN (572)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "34-00028-SX" AND av.ProductID IN (572)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "34-00065-SX" AND av.ProductID IN (572)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "34-00002-SX" AND av.ProductID IN (757)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8550 10029" AND av.ProductID IN (572)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8550 10021" AND av.ProductID IN (757)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8550 10028" AND av.ProductID IN (572)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V40-1803" AND av.ProductID IN (757)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V40-1803-1" AND av.ProductID IN (757)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V40-1802" AND av.ProductID IN (757)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "81-21343-00" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1249930" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1004517" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1177371" AND av.ProductID IN (572)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1226435" AND av.ProductID IN (757)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1177373" 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 = 478 AND aa.DataSupplierArticleNumber = "OS3304") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "OS5317") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "OS6306") OR (aa.SupplierID = 4693 AND aa.DataSupplierArticleNumber = "N10002BTA") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "12013882B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "20011244B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "12013858B") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "OS697") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "OS698") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P76200-01") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "50-305272-00") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "33-131120-00") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "1151580") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NB628") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NB691") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "34-00028-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "34-00065-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "34-00002-SX") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8550 10029") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8550 10021") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8550 10028") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V40-1803") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V40-1803-1") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V40-1802") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-21343-00") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1249930") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1004517") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1177371") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1226435") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1177373") ) 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 = 478 AND aa.DataSupplierArticleNumber = "OS3304") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "OS5317") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "OS6306") OR (aa.SupplierID = 4693 AND aa.DataSupplierArticleNumber = "N10002BTA") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "12013882B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "20011244B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "12013858B") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "OS697") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "OS698") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P76200-01") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "50-305272-00") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "33-131120-00") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "1151580") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NB628") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NB691") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "34-00028-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "34-00065-SX") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "34-00002-SX") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8550 10029") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8550 10021") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8550 10028") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V40-1803") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V40-1803-1") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V40-1802") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-21343-00") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1249930") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1004517") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1177371") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1226435") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1177373") ) AND aa.Language = "ru" Продажа автозапчастей типа Прокладка/комплект прокладок вала для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
BGA OS3304 Уплотняющее кольцо, коленчатый вал
OS5317 Уплотняющее кольцо, коленчатый вал
OS6306 Уплотняющее кольцо, коленчатый вал
BTA N10002BTA Уплотняющее кольцо, распределительный вал
CORTECO 12013882B Уплотняющее кольцо, коленчатый вал
20011244B Уплотняющее кольцо, распределительный вал
12013858B Уплотняющее кольцо, коленчатый вал
FAI AutoParts OS697 Уплотняющее кольцо, коленчатый вал
OS698 Уплотняющее кольцо, коленчатый вал
GLASER P76200-01 Уплотняющее кольцо, коленчатый вал
GOETZE 50-305272-00 Уплотняющее кольцо, коленчатый вал
33-131120-00 Уплотняющее кольцо, коленчатый вал
KRAFT AUTOMOTIVE 1151580 Уплотняющее кольцо, коленчатый вал
PAYEN NB628 Уплотняющее кольцо, коленчатый вал
NB691 Уплотняющее кольцо, коленчатый вал
STELLOX 34-00028-SX Уплотняющее кольцо, коленчатый вал
34-00065-SX Уплотняющее кольцо, коленчатый вал
34-00002-SX Уплотняющее кольцо, распределительный вал
TRISCAN 8550 10029 Уплотняющее кольцо, коленчатый вал
8550 10021 Уплотняющее кольцо, распределительный вал
8550 10028 Уплотняющее кольцо, коленчатый вал
VAICO V40-1803 Уплотняющее кольцо, распределительный вал
V40-1803-1 Уплотняющее кольцо, распределительный вал
V40-1802 Уплотняющее кольцо, распределительный вал
VICTOR REINZ 81-21343-00 Уплотняющее кольцо, коленчатый вал
WILMINK GROUP WG1249930 Уплотняющее кольцо, коленчатый вал
WG1004517 Уплотняющее кольцо, коленчатый вал
WG1177371 Уплотняющее кольцо, коленчатый вал
WG1226435 Уплотняющее кольцо, распределительный вал
WG1177373 Уплотняющее кольцо, коленчатый вал
2026 CATCAR.INFO (v 2.0)