#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2MXx8bW9kZWxfaWQ9PTE4NHx8bWRmX2lkPT0wXjU0N3x8c3BhcmVfaWQ9PTEwMDU4Ng%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 = "547" AND ( (av.SupplierID = 4598 AND av.DataSupplierArticleNumber = "50402" AND av.ProductID IN (1080)) OR (av.SupplierID = 208 AND av.DataSupplierArticleNumber = "2344" AND av.ProductID IN (1080)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 65-700-075" AND av.ProductID IN (1080)) OR (av.SupplierID = 405 AND av.DataSupplierArticleNumber = "480016" AND av.ProductID IN (1080)) OR (av.SupplierID = 140 AND av.DataSupplierArticleNumber = "80000506" AND av.ProductID IN (1080)) OR (av.SupplierID = 267 AND av.DataSupplierArticleNumber = "SS1181" AND av.ProductID IN (1080)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "02273" AND av.ProductID IN (1080)) OR (av.SupplierID = 4467 AND av.DataSupplierArticleNumber = "FZ9771" AND av.ProductID IN (1080)) OR (av.SupplierID = 373 AND av.DataSupplierArticleNumber = "511519" AND av.ProductID IN (1080)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1250100209" AND av.ProductID IN (1080)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1250100200" AND av.ProductID IN (1080)) OR (av.SupplierID = 286 AND av.DataSupplierArticleNumber = "8500 24819" AND av.ProductID IN (1080)) OR (av.SupplierID = 4546 AND av.DataSupplierArticleNumber = "4231660" AND av.ProductID IN (1080)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "614 040 0003" AND av.ProductID IN (1080)) OR (av.SupplierID = 37 AND av.DataSupplierArticleNumber = "L24819" AND av.ProductID IN (1080)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "OP-SB-3811" AND av.ProductID IN (1080)) OR (av.SupplierID = 4558 AND av.DataSupplierArticleNumber = "PSE1314" AND av.ProductID IN (1080)) OR (av.SupplierID = 4686 AND av.DataSupplierArticleNumber = "2307-0228" AND av.ProductID IN (1080)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "985352" AND av.ProductID IN (1080)) OR (av.SupplierID = 260 AND av.DataSupplierArticleNumber = "9001654" AND av.ProductID IN (1080)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "40 79 0015" AND av.ProductID IN (1080)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "200 748" AND av.ProductID IN (1080)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "788675" AND av.ProductID IN (1080)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "788594" AND av.ProductID IN (1080)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8500 24819" AND av.ProductID IN (1080)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1233496" AND av.ProductID IN (1080)) ) 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 = "50402") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "2344") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 65-700-075") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "480016") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "80000506") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "SS1181") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "02273") OR (aa.SupplierID = 4467 AND aa.DataSupplierArticleNumber = "FZ9771") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "511519") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1250100209") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1250100200") OR (aa.SupplierID = 286 AND aa.DataSupplierArticleNumber = "8500 24819") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4231660") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "614 040 0003") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "L24819") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "OP-SB-3811") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PSE1314") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "2307-0228") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "985352") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "9001654") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "40 79 0015") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "200 748") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "788675") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "788594") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 24819") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1233496") ) 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 = "50402") OR (aa.SupplierID = 208 AND aa.DataSupplierArticleNumber = "2344") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 65-700-075") OR (aa.SupplierID = 405 AND aa.DataSupplierArticleNumber = "480016") OR (aa.SupplierID = 140 AND aa.DataSupplierArticleNumber = "80000506") OR (aa.SupplierID = 267 AND aa.DataSupplierArticleNumber = "SS1181") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "02273") OR (aa.SupplierID = 4467 AND aa.DataSupplierArticleNumber = "FZ9771") OR (aa.SupplierID = 373 AND aa.DataSupplierArticleNumber = "511519") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1250100209") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1250100200") OR (aa.SupplierID = 286 AND aa.DataSupplierArticleNumber = "8500 24819") OR (aa.SupplierID = 4546 AND aa.DataSupplierArticleNumber = "4231660") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "614 040 0003") OR (aa.SupplierID = 37 AND aa.DataSupplierArticleNumber = "L24819") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "OP-SB-3811") OR (aa.SupplierID = 4558 AND aa.DataSupplierArticleNumber = "PSE1314") OR (aa.SupplierID = 4686 AND aa.DataSupplierArticleNumber = "2307-0228") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "985352") OR (aa.SupplierID = 260 AND aa.DataSupplierArticleNumber = "9001654") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "40 79 0015") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "200 748") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "788675") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "788594") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8500 24819") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1233496") ) AND aa.Language = "ru" Продажа автозапчастей типа Подвеска для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
3RG 50402 Втулка, балка моста
BIRTH 2344 Втулка, балка моста
BSG BSG 65-700-075 Втулка, балка моста
CAUTEX 480016 Втулка, балка моста
CORTECO 80000506 Втулка, балка моста
FAI AutoParts SS1181 Втулка, балка моста
FEBI BILSTEIN 02273 Втулка, балка моста
FORTUNE LINE FZ9771 Втулка, балка моста
GSP 511519 Втулка, балка моста
JP GROUP 1250100209 Втулка, балка моста
1250100200 Втулка, балка моста
KAWE 8500 24819 Втулка, балка моста
KRAFT AUTOMOTIVE 4231660 Втулка, балка моста
MEYLE 614 040 0003 Втулка, балка моста
MONROE L24819 Втулка, балка моста
MOOG OP-SB-3811 Втулка, балка моста
PATRON PSE1314 Втулка, балка моста
PROFIT 2307-0228 Втулка, балка моста
RUVILLE 985352 Втулка, балка моста
SASIC 9001654 Втулка, балка моста
SWAG 40 79 0015 Втулка, балка моста
TOPRAN 200 748 Втулка, балка моста
TRICLO 788675 Втулка, балка моста
788594 Втулка, балка моста
TRISCAN 8500 24819 Втулка, балка моста
WILMINK GROUP WG1233496 Втулка, балка моста
2026 CATCAR.INFO (v 2.0)