#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2MXx8bW9kZWxfaWQ9PTQwNDR8fG1kZl9pZD09MF4xMDkxNXx8c3BhcmVfaWQ9PTEwMDIyOA%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 = "10915" AND ( (av.SupplierID = 4598 AND av.DataSupplierArticleNumber = "80141" AND av.ProductID IN (322)) OR (av.SupplierID = 139 AND av.DataSupplierArticleNumber = "57023600" AND av.ProductID IN (323)) OR (av.SupplierID = 139 AND av.DataSupplierArticleNumber = "12010200" AND av.ProductID IN (322)) OR (av.SupplierID = 478 AND av.DataSupplierArticleNumber = "VK4377" AND av.ProductID IN (323)) OR (av.SupplierID = 4693 AND av.DataSupplierArticleNumber = "N30003BTA" AND av.ProductID IN (322)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "19036019" AND av.ProductID IN (323)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "12014670" AND av.ProductID IN (322)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "424.800" AND av.ProductID IN (323)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "403.730" AND av.ProductID IN (322)) OR (av.SupplierID = 237 AND av.DataSupplierArticleNumber = "1642657" AND av.ProductID IN (322)) OR (av.SupplierID = 237 AND av.DataSupplierArticleNumber = "9042601" AND av.ProductID IN (323)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "VSK1006" AND av.ProductID IN (323)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "02741" AND av.ProductID IN (322)) OR (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "P76662-00" AND av.ProductID IN (322)) OR (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "N92990-00" AND av.ProductID IN (323)) OR (av.SupplierID = 60 AND av.DataSupplierArticleNumber = "50-306147-50" AND av.ProductID IN (322)) OR (av.SupplierID = 60 AND av.DataSupplierArticleNumber = "24-30614-76/0" AND av.ProductID IN (323)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1111352900" AND av.ProductID IN (322)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "1130275" AND av.ProductID IN (322)) OR (av.SupplierID = 331 AND av.DataSupplierArticleNumber = "35006" AND av.ProductID IN (322)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "HR791" AND av.ProductID IN (323)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "PA5041" AND av.ProductID IN (322)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "40 90 2741" AND av.ProductID IN (322)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "107 502" AND av.ProductID IN (322)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "207 459" AND av.ProductID IN (322)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "70-31306-10" AND av.ProductID IN (322)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "12-31306-01" AND av.ProductID IN (323)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1245954" AND av.ProductID IN (322)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1177014" AND av.ProductID IN (323)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1087867" AND av.ProductID IN (322)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1085202" AND av.ProductID IN (323)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1429784" AND av.ProductID IN (322)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1188933" AND av.ProductID IN (323)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1096949" AND av.ProductID IN (322)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1103062" AND av.ProductID IN (323)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1184640" AND av.ProductID IN (322)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1169857" AND av.ProductID IN (323)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1004649" AND av.ProductID IN (322)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1004306" AND av.ProductID IN (323)) ) 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 = "80141") OR (aa.SupplierID = 139 AND aa.DataSupplierArticleNumber = "57023600") OR (aa.SupplierID = 139 AND aa.DataSupplierArticleNumber = "12010200") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "VK4377") OR (aa.SupplierID = 4693 AND aa.DataSupplierArticleNumber = "N30003BTA") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "19036019") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "12014670") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "424.800") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "403.730") OR (aa.SupplierID = 237 AND aa.DataSupplierArticleNumber = "1642657") OR (aa.SupplierID = 237 AND aa.DataSupplierArticleNumber = "9042601") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "VSK1006") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "02741") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P76662-00") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "N92990-00") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "50-306147-50") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "24-30614-76/0") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1111352900") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "1130275") OR (aa.SupplierID = 331 AND aa.DataSupplierArticleNumber = "35006") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "HR791") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "PA5041") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "40 90 2741") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "107 502") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "207 459") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "70-31306-10") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "12-31306-01") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1245954") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1177014") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1087867") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1085202") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1429784") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1188933") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1096949") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1103062") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1184640") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1169857") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1004649") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1004306") ) 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 = "80141") OR (aa.SupplierID = 139 AND aa.DataSupplierArticleNumber = "57023600") OR (aa.SupplierID = 139 AND aa.DataSupplierArticleNumber = "12010200") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "VK4377") OR (aa.SupplierID = 4693 AND aa.DataSupplierArticleNumber = "N30003BTA") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "19036019") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "12014670") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "424.800") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "403.730") OR (aa.SupplierID = 237 AND aa.DataSupplierArticleNumber = "1642657") OR (aa.SupplierID = 237 AND aa.DataSupplierArticleNumber = "9042601") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "VSK1006") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "02741") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P76662-00") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "N92990-00") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "50-306147-50") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "24-30614-76/0") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1111352900") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "1130275") OR (aa.SupplierID = 331 AND aa.DataSupplierArticleNumber = "35006") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "HR791") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "PA5041") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "40 90 2741") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "107 502") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "207 459") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "70-31306-10") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "12-31306-01") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1245954") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1177014") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1087867") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1085202") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1429784") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1188933") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1096949") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1103062") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1184640") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1169857") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1004649") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1004306") ) AND aa.Language = "ru" Продажа автозапчастей типа Прокладка стерженя для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
3RG 80141 Уплотнительное кольцо, стержень кла
AJUSA 57023600 Комплект прокладок, стержень клапана
12010200 Уплотнительное кольцо, стержень кла
BGA VK4377 Комплект прокладок, стержень клапана
BTA N30003BTA Уплотнительное кольцо, стержень кла
CORTECO 19036019 Комплект прокладок, стержень клапана
12014670 Уплотнительное кольцо, стержень кла
ELRING 424.800 Комплект прокладок, стержень клапана
403.730 Уплотнительное кольцо, стержень кла
ELWIS ROYAL 1642657 Уплотнительное кольцо, стержень кла
9042601 Комплект прокладок, стержень клапана
FAI AutoParts VSK1006 Комплект прокладок, стержень клапана
FEBI BILSTEIN 02741 Уплотнительное кольцо, стержень кла
GLASER P76662-00 Уплотнительное кольцо, стержень кла
N92990-00 Комплект прокладок, стержень клапана
GOETZE 50-306147-50 Уплотнительное кольцо, стержень кла
24-30614-76/0 Комплект прокладок, стержень клапана
JP GROUP 1111352900 Уплотнительное кольцо, стержень кла
KRAFT AUTOMOTIVE 1130275 Уплотнительное кольцо, стержень кла
ORIGINAL IMPERIUM 35006 Уплотнительное кольцо, стержень кла
PAYEN HR791 Комплект прокладок, стержень клапана
PA5041 Уплотнительное кольцо, стержень кла
SWAG 40 90 2741 Уплотнительное кольцо, стержень кла
TOPRAN 107 502 Уплотнительное кольцо, стержень кла
207 459 Уплотнительное кольцо, стержень кла
VICTOR REINZ 70-31306-10 Уплотнительное кольцо, стержень кла
12-31306-01 Комплект прокладок, стержень клапана
WILMINK GROUP WG1245954 Уплотнительное кольцо, стержень кла
WG1177014 Комплект прокладок, стержень клапана
WG1087867 Уплотнительное кольцо, стержень кла
WG1085202 Комплект прокладок, стержень клапана
WG1429784 Уплотнительное кольцо, стержень кла
WG1188933 Комплект прокладок, стержень клапана
WG1096949 Уплотнительное кольцо, стержень кла
WG1103062 Комплект прокладок, стержень клапана
WG1184640 Уплотнительное кольцо, стержень кла
WG1169857 Комплект прокладок, стержень клапана
WG1004649 Уплотнительное кольцо, стержень кла
WG1004306 Комплект прокладок, стержень клапана
2026 CATCAR.INFO (v 2.0)