#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTQwNTh8fG1kZl9pZD09MF4xMTA5OXx8c3BhcmVfaWQ9PTEwMDM5OQ%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 = "11099" AND ( (av.SupplierID = 141 AND av.DataSupplierArticleNumber = "FOL147" AND av.ProductID IN (1216)) OR (av.SupplierID = 139 AND av.DataSupplierArticleNumber = "85017000" AND av.ProductID IN (1216)) OR (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "955051" AND av.ProductID IN (1216)) OR (av.SupplierID = 478 AND av.DataSupplierArticleNumber = "HL6353" AND av.ProductID IN (1216)) OR (av.SupplierID = 4514 AND av.DataSupplierArticleNumber = "ZH0078" AND av.ProductID IN (1216)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "BFS89" AND av.ProductID IN (1216)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "BFS89S" AND av.ProductID IN (1216)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "08676" AND av.ProductID IN (1216)) OR (av.SupplierID = 235 AND av.DataSupplierArticleNumber = "PI 06-0035" AND av.ProductID IN (1216)) OR (av.SupplierID = 204 AND av.DataSupplierArticleNumber = "420 0042 10" AND av.ProductID IN (1216)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "45-4046" AND av.ProductID IN (1216)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1111400400" AND av.ProductID IN (1216)) OR (av.SupplierID = 432 AND av.DataSupplierArticleNumber = "50006421" AND av.ProductID IN (1216)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "265150" AND av.ProductID IN (1216)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "20-00524-SX" AND av.ProductID IN (1216)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "10 18 0010" AND av.ProductID IN (1216)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "400 894" AND av.ProductID IN (1216)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "85-4101" AND av.ProductID IN (1216)) OR (av.SupplierID = 209 AND av.DataSupplierArticleNumber = "02.12.103" AND av.ProductID IN (1216)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V30-0386" AND av.ProductID IN (1216)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1250771" AND av.ProductID IN (1216)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1017718" AND av.ProductID IN (1216)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1426830" AND av.ProductID IN (1216)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1156414" AND av.ProductID IN (1216)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1172077" AND av.ProductID IN (1216)) ) 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 = 141 AND aa.DataSupplierArticleNumber = "FOL147") OR (aa.SupplierID = 139 AND aa.DataSupplierArticleNumber = "85017000") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "955051") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "HL6353") OR (aa.SupplierID = 4514 AND aa.DataSupplierArticleNumber = "ZH0078") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "BFS89") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "BFS89S") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "08676") OR (aa.SupplierID = 235 AND aa.DataSupplierArticleNumber = "PI 06-0035") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "420 0042 10") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "45-4046") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1111400400") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "50006421") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "265150") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "20-00524-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 18 0010") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "400 894") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "85-4101") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.12.103") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V30-0386") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250771") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1017718") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1426830") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1156414") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1172077") ) 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 = 141 AND aa.DataSupplierArticleNumber = "FOL147") OR (aa.SupplierID = 139 AND aa.DataSupplierArticleNumber = "85017000") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "955051") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "HL6353") OR (aa.SupplierID = 4514 AND aa.DataSupplierArticleNumber = "ZH0078") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "BFS89") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "BFS89S") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "08676") OR (aa.SupplierID = 235 AND aa.DataSupplierArticleNumber = "PI 06-0035") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "420 0042 10") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "45-4046") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1111400400") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "50006421") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "265150") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "20-00524-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 18 0010") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "400 894") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "85-4101") OR (aa.SupplierID = 209 AND aa.DataSupplierArticleNumber = "02.12.103") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V30-0386") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250771") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1017718") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1426830") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1156414") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1172077") ) AND aa.Language = "ru" Продажа автозапчастей типа Штанга толкателя / предохранительная трубка для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AE FOL147 Толкатель
AJUSA 85017000 Толкатель
AUTEX 955051 Толкатель
BGA HL6353 Толкатель
ET ENGINETEAM ZH0078 Толкатель
FAI AutoParts BFS89 Толкатель
BFS89S Толкатель
FEBI BILSTEIN 08676 Толкатель
FRECCIA PI 06-0035 Толкатель
INA 420 0042 10 Толкатель
IPD 45-4046 Толкатель
JP GROUP 1111400400 Толкатель
KOLBENSCHMIDT 50006421 Толкатель
RUVILLE 265150 Толкатель
STELLOX 20-00524-SX Толкатель
SWAG 10 18 0010 Толкатель
TOPRAN 400 894 Толкатель
TRISCAN 85-4101 Толкатель
TRUCKTEC AUTOMOTIVE 02.12.103 Толкатель
VAICO V30-0386 Толкатель
WILMINK GROUP WG1250771 Толкатель
WG1017718 Толкатель
WG1426830 Толкатель
WG1156414 Толкатель
WG1172077 Толкатель
2026 CATCAR.INFO (v 2.0)