#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1MXx8bW9kZWxfaWQ9PTQ3MjJ8fG1kZl9pZD09MV4xMTAyMHx8c3BhcmVfaWQ9PTIwMDU0MQ%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 articlecommercialvehicles av JOIN commercialvehiclelinkageattributes_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 = "11020" AND ( (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "15170" AND av.ProductID IN (657)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "43538" AND av.ProductID IN (657)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "44322" AND av.ProductID IN (657)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "037.078-00A" AND av.ProductID IN (657)) OR (av.SupplierID = 63 AND av.DataSupplierArticleNumber = "037.092-00A" AND av.ProductID IN (657)) OR (av.SupplierID = 4698 AND av.DataSupplierArticleNumber = "STR-40229" AND av.ProductID IN (2070)) OR (av.SupplierID = 4698 AND av.DataSupplierArticleNumber = "STR-40208" AND av.ProductID IN (657)) OR (av.SupplierID = 4698 AND av.DataSupplierArticleNumber = "STR-60206" AND av.ProductID IN (2070)) OR (av.SupplierID = 4698 AND av.DataSupplierArticleNumber = "STR-40003" AND av.ProductID IN (2070)) OR (av.SupplierID = 4698 AND av.DataSupplierArticleNumber = "STR-40212" AND av.ProductID IN (2070)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "020.659" AND av.ProductID IN (657)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "020.441" AND av.ProductID IN (657)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "021.074" AND av.ProductID IN (657)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "020.443" AND av.ProductID IN (657)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "022.404" AND av.ProductID IN (657)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "020.605" AND av.ProductID IN (657)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "11.010.1905.180" AND av.ProductID IN (657,657)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "11.010.0905.170" AND av.ProductID IN (657,657)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "11.010.0904.181" AND av.ProductID IN (657,657)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "11.100.4500.100" AND av.ProductID IN (657,657)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "11.010.0905.180" AND av.ProductID IN (657,657)) OR (av.SupplierID = 336 AND av.DataSupplierArticleNumber = "11.010.1905.330" AND av.ProductID IN (657,657)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "85-18499-SX" AND av.ProductID IN (657)) ) 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 = 101 AND aa.DataSupplierArticleNumber = "15170") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "43538") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "44322") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "037.078-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "037.092-00A") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-40229") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-40208") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-60206") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-40003") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-40212") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "020.659") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "020.441") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "021.074") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "020.443") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "022.404") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "020.605") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "11.010.1905.180") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "11.010.0905.170") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "11.010.0904.181") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "11.100.4500.100") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "11.010.0905.180") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "11.010.1905.330") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "85-18499-SX") ) 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 = 101 AND aa.DataSupplierArticleNumber = "15170") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "43538") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "44322") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "037.078-00A") OR (aa.SupplierID = 63 AND aa.DataSupplierArticleNumber = "037.092-00A") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-40229") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-40208") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-60206") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-40003") OR (aa.SupplierID = 4698 AND aa.DataSupplierArticleNumber = "STR-40212") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "020.659") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "020.441") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "021.074") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "020.443") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "022.404") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "020.605") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "11.010.1905.180") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "11.010.0905.170") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "11.010.0904.181") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "11.100.4500.100") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "11.010.0905.180") OR (aa.SupplierID = 336 AND aa.DataSupplierArticleNumber = "11.010.1905.330") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "85-18499-SX") ) AND aa.Language = "ru" Продажа автозапчастей типа Болт крепления колеса для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
FEBI BILSTEIN 15170 Болт крепления колеса
43538 Болт крепления колеса
44322 Болт крепления колеса
PE Automotive 037.078-00A Болт крепления колеса
037.092-00A Болт крепления колеса
S-TR STR-40229 Болт для крепления колеса
STR-40208 Болт крепления колеса
STR-60206 Болт для крепления колеса
STR-40003 Болт для крепления колеса
STR-40212 Болт для крепления колеса
SAMPA 020.659 Болт крепления колеса
020.441 Болт крепления колеса
021.074 Болт крепления колеса
020.443 Болт крепления колеса
022.404 Болт крепления колеса
020.605 Болт крепления колеса
ST-TEMPLIN 11.010.1905.180 Болт крепления колеса
11.010.0905.170 Болт крепления колеса
11.010.0904.181 Болт крепления колеса
11.100.4500.100 Болт крепления колеса
11.010.0905.180 Болт крепления колеса
11.010.1905.330 Болт крепления колеса
STELLOX 85-18499-SX Болт крепления колеса
2026 CATCAR.INFO (v 2.0)