#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2MXx8bW9kZWxfaWQ9PTk3MTd8fG1kZl9pZD09MF4xMTMyNXx8c3BhcmVfaWQ9PTEwMDM5OQ%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 = "11325" AND ( (av.SupplierID = 141 AND av.DataSupplierArticleNumber = "FOL167" AND av.ProductID IN (1216)) OR (av.SupplierID = 139 AND av.DataSupplierArticleNumber = "85007200" AND av.ProductID IN (1216)) OR (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "955019" AND av.ProductID IN (1216)) OR (av.SupplierID = 478 AND av.DataSupplierArticleNumber = "HL6329" AND av.ProductID IN (1216)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "BFS127S" AND av.ProductID IN (1216)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "BFS127" AND av.ProductID IN (1216)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "14737" AND av.ProductID IN (1216)) OR (av.SupplierID = 235 AND av.DataSupplierArticleNumber = "PI 06-0008" AND av.ProductID IN (1216)) OR (av.SupplierID = 204 AND av.DataSupplierArticleNumber = "420 0072 10" AND av.ProductID IN (1216)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "45-4014" AND av.ProductID IN (1216)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1211400200" AND av.ProductID IN (1216)) OR (av.SupplierID = 432 AND av.DataSupplierArticleNumber = "50006436" AND av.ProductID IN (1216)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "17-0125" AND av.ProductID IN (1216)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "265301" AND av.ProductID IN (1216)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "20-00519-SX" AND av.ProductID IN (1216)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "40 18 0004" AND av.ProductID IN (1216)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "108 855" AND av.ProductID IN (1216)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "80-24003" AND av.ProductID IN (1216)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1250783" AND av.ProductID IN (1216)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1156395" AND av.ProductID IN (1216)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1429757" AND av.ProductID IN (1216)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1170680" AND av.ProductID IN (1216)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1172093" AND av.ProductID IN (1216)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1017731" 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 = "FOL167") OR (aa.SupplierID = 139 AND aa.DataSupplierArticleNumber = "85007200") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "955019") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "HL6329") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "BFS127S") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "BFS127") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "14737") OR (aa.SupplierID = 235 AND aa.DataSupplierArticleNumber = "PI 06-0008") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "420 0072 10") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "45-4014") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1211400200") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "50006436") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "17-0125") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "265301") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "20-00519-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "40 18 0004") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "108 855") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "80-24003") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250783") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1156395") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1429757") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1170680") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1172093") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1017731") ) 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 = "FOL167") OR (aa.SupplierID = 139 AND aa.DataSupplierArticleNumber = "85007200") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "955019") OR (aa.SupplierID = 478 AND aa.DataSupplierArticleNumber = "HL6329") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "BFS127S") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "BFS127") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "14737") OR (aa.SupplierID = 235 AND aa.DataSupplierArticleNumber = "PI 06-0008") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "420 0072 10") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "45-4014") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1211400200") OR (aa.SupplierID = 432 AND aa.DataSupplierArticleNumber = "50006436") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "17-0125") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "265301") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "20-00519-SX") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "40 18 0004") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "108 855") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "80-24003") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1250783") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1156395") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1429757") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1170680") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1172093") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1017731") ) AND aa.Language = "ru" Продажа автозапчастей типа Штанга толкателя / предохранительная трубка для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AE FOL167 Толкатель
AJUSA 85007200 Толкатель
AUTEX 955019 Толкатель
BGA HL6329 Толкатель
FAI AutoParts BFS127S Толкатель
BFS127 Толкатель
FEBI BILSTEIN 14737 Толкатель
FRECCIA PI 06-0008 Толкатель
INA 420 0072 10 Толкатель
IPD 45-4014 Толкатель
JP GROUP 1211400200 Толкатель
KOLBENSCHMIDT 50006436 Толкатель
MAXGEAR 17-0125 Толкатель
RUVILLE 265301 Толкатель
STELLOX 20-00519-SX Толкатель
SWAG 40 18 0004 Толкатель
TOPRAN 108 855 Толкатель
TRISCAN 80-24003 Толкатель
WILMINK GROUP WG1250783 Толкатель
WG1156395 Толкатель
WG1429757 Толкатель
WG1170680 Толкатель
WG1172093 Толкатель
WG1017731 Толкатель
2026 CATCAR.INFO (v 2.0)