#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUwNHx8bW9kZWxfaWQ9PTE4OTF8fG1kZl9pZD09MF4xNjcxMHx8c3BhcmVfaWQ9PTEwMjc3OA%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 = "16710" AND ( (av.SupplierID = 139 AND av.DataSupplierArticleNumber = "15010800" AND av.ProductID IN (757)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "12012709B" AND av.ProductID IN (757)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "20026412B" AND av.ProductID IN (757)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "325.156" AND av.ProductID IN (757,757,757)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "129.780" AND av.ProductID IN (757,757,757)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "326.470" AND av.ProductID IN (757,757,757)) OR (av.SupplierID = 10 AND av.DataSupplierArticleNumber = "325.155" AND av.ProductID IN (757)) OR (av.SupplierID = 237 AND av.DataSupplierArticleNumber = "8456040" AND av.ProductID IN (757)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "OS534" AND av.ProductID IN (757)) OR (av.SupplierID = 88 AND av.DataSupplierArticleNumber = "P76087-01" AND av.ProductID IN (757)) OR (av.SupplierID = 60 AND av.DataSupplierArticleNumber = "50-303185-50" AND av.ProductID IN (757)) OR (av.SupplierID = 204 AND av.DataSupplierArticleNumber = "413 0093 10" AND av.ProductID IN (757)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "1150010" AND av.ProductID IN (757)) OR (av.SupplierID = 113 AND av.DataSupplierArticleNumber = "NA5001" AND av.ProductID IN (757)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "295405" AND av.ProductID IN (757)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "34-00001-SX" AND av.ProductID IN (757)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8550 10050" AND av.ProductID IN (757)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8550 10026" AND av.ProductID IN (757)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "07.10.010" AND av.ProductID IN (757)) OR (av.SupplierID = 9 AND av.DataSupplierArticleNumber = "81-19299-10" AND av.ProductID IN (757)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1223074" AND av.ProductID IN (757,757,757)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1091096" AND av.ProductID IN (757)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1086953" AND av.ProductID IN (757,757,757)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1086403" AND av.ProductID IN (757,757,757)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1226509" AND av.ProductID IN (757,757,757)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1103912" AND av.ProductID IN (757)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1004468" AND av.ProductID IN (757)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1163037" AND av.ProductID IN (757)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1085139" AND av.ProductID IN (757)) ) 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 = "15010800") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "12012709B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "20026412B") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "325.156") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "129.780") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "326.470") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "325.155") OR (aa.SupplierID = 237 AND aa.DataSupplierArticleNumber = "8456040") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "OS534") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P76087-01") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "50-303185-50") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "413 0093 10") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "1150010") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NA5001") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "295405") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "34-00001-SX") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8550 10050") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8550 10026") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "07.10.010") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-19299-10") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1223074") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1091096") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1086953") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1086403") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1226509") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1103912") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1004468") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1163037") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1085139") ) 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 = "15010800") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "12012709B") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "20026412B") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "325.156") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "129.780") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "326.470") OR (aa.SupplierID = 10 AND aa.DataSupplierArticleNumber = "325.155") OR (aa.SupplierID = 237 AND aa.DataSupplierArticleNumber = "8456040") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "OS534") OR (aa.SupplierID = 88 AND aa.DataSupplierArticleNumber = "P76087-01") OR (aa.SupplierID = 60 AND aa.DataSupplierArticleNumber = "50-303185-50") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "413 0093 10") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "1150010") OR (aa.SupplierID = 113 AND aa.DataSupplierArticleNumber = "NA5001") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "295405") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "34-00001-SX") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8550 10050") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8550 10026") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "07.10.010") OR (aa.SupplierID = 9 AND aa.DataSupplierArticleNumber = "81-19299-10") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1223074") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1091096") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1086953") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1086403") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1226509") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1103912") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1004468") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1163037") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1085139") ) AND aa.Language = "ru" Продажа автозапчастей типа Сальник вала для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AJUSA 15010800 Уплотняющее кольцо, распределительный вал
CORTECO 12012709B Уплотняющее кольцо, распределительный вал
20026412B Уплотняющее кольцо, распределительный вал
ELRING 325.156 Уплотняющее кольцо, распределительный вал
129.780 Уплотняющее кольцо, распределительный вал
326.470 Уплотняющее кольцо, распределительный вал
325.155 Уплотняющее кольцо, распределительный вал
ELWIS ROYAL 8456040 Уплотняющее кольцо, распределительный вал
FAI AutoParts OS534 Уплотняющее кольцо, распределительный вал
GLASER P76087-01 Уплотняющее кольцо, распределительный вал
GOETZE 50-303185-50 Уплотняющее кольцо, распределительный вал
INA 413 0093 10 Уплотняющее кольцо, распределительный вал
KRAFT AUTOMOTIVE 1150010 Уплотняющее кольцо, распределительный вал
PAYEN NA5001 Уплотняющее кольцо, распределительный вал
RUVILLE 295405 Уплотняющее кольцо, распределительный вал
STELLOX 34-00001-SX Уплотняющее кольцо, распределительный вал
TRISCAN 8550 10050 Уплотняющее кольцо, распределительный вал
8550 10026 Уплотняющее кольцо, распределительный вал
TRUCKTEC AUTOMOTIVE 07.10.010 Уплотняющее кольцо, распределительный вал
VICTOR REINZ 81-19299-10 Уплотняющее кольцо, распределительный вал
WILMINK GROUP WG1223074 Уплотняющее кольцо, распределительный вал
WG1091096 Уплотняющее кольцо, распределительный вал
WG1086953 Уплотняющее кольцо, распределительный вал
WG1086403 Уплотняющее кольцо, распределительный вал
WG1226509 Уплотняющее кольцо, распределительный вал
WG1103912 Уплотняющее кольцо, распределительный вал
WG1004468 Уплотняющее кольцо, распределительный вал
WG1163037 Уплотняющее кольцо, распределительный вал
WG1085139 Уплотняющее кольцо, распределительный вал
2026 CATCAR.INFO (v 2.0)