#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU3OXx8bW9kZWxfaWQ9PTM1NjZ8fG1kZl9pZD09MF45NTYwfHxzcGFyZV9pZD09MTAyNjk3&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 = "9560" AND ( (av.SupplierID = 4481 AND av.DataSupplierArticleNumber = "208079000" AND av.ProductID IN (4731)) OR (av.SupplierID = 4481 AND av.DataSupplierArticleNumber = "108080000" AND av.ProductID IN (2444)) OR (av.SupplierID = 4481 AND av.DataSupplierArticleNumber = "108079000" AND av.ProductID IN (2444)) OR (av.SupplierID = 176 AND av.DataSupplierArticleNumber = "464079" AND av.ProductID IN (219)) OR (av.SupplierID = 176 AND av.DataSupplierArticleNumber = "464080" AND av.ProductID IN (219)) OR (av.SupplierID = 175 AND av.DataSupplierArticleNumber = "8192579" AND av.ProductID IN (219)) OR (av.SupplierID = 175 AND av.DataSupplierArticleNumber = "8192580" AND av.ProductID IN (219)) OR (av.SupplierID = 4657 AND av.DataSupplierArticleNumber = "051-48-072" AND av.ProductID IN (2444)) OR (av.SupplierID = 4657 AND av.DataSupplierArticleNumber = "051-48-072M" AND av.ProductID IN (2444)) OR (av.SupplierID = 4752 AND av.DataSupplierArticleNumber = "ML4615" AND av.ProductID IN (219)) OR (av.SupplierID = 4752 AND av.DataSupplierArticleNumber = "ML4614" AND av.ProductID IN (219)) OR (av.SupplierID = 4021 AND av.DataSupplierArticleNumber = "RTO034" AND av.ProductID IN (219)) OR (av.SupplierID = 4021 AND av.DataSupplierArticleNumber = "RTO035" AND av.ProductID IN (219)) OR (av.SupplierID = 173 AND av.DataSupplierArticleNumber = "121553" AND av.ProductID IN (2444)) OR (av.SupplierID = 401 AND av.DataSupplierArticleNumber = "GS1706" AND av.ProductID IN (219)) OR (av.SupplierID = 401 AND av.DataSupplierArticleNumber = "GS1705" AND av.ProductID IN (219)) ) 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 = 4481 AND aa.DataSupplierArticleNumber = "208079000") OR (aa.SupplierID = 4481 AND aa.DataSupplierArticleNumber = "108080000") OR (aa.SupplierID = 4481 AND aa.DataSupplierArticleNumber = "108079000") OR (aa.SupplierID = 176 AND aa.DataSupplierArticleNumber = "464079") OR (aa.SupplierID = 176 AND aa.DataSupplierArticleNumber = "464080") OR (aa.SupplierID = 175 AND aa.DataSupplierArticleNumber = "8192579") OR (aa.SupplierID = 175 AND aa.DataSupplierArticleNumber = "8192580") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "051-48-072") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "051-48-072M") OR (aa.SupplierID = 4752 AND aa.DataSupplierArticleNumber = "ML4615") OR (aa.SupplierID = 4752 AND aa.DataSupplierArticleNumber = "ML4614") OR (aa.SupplierID = 4021 AND aa.DataSupplierArticleNumber = "RTO034") OR (aa.SupplierID = 4021 AND aa.DataSupplierArticleNumber = "RTO035") OR (aa.SupplierID = 173 AND aa.DataSupplierArticleNumber = "121553") OR (aa.SupplierID = 401 AND aa.DataSupplierArticleNumber = "GS1706") OR (aa.SupplierID = 401 AND aa.DataSupplierArticleNumber = "GS1705") ) 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 = 4481 AND aa.DataSupplierArticleNumber = "208079000") OR (aa.SupplierID = 4481 AND aa.DataSupplierArticleNumber = "108080000") OR (aa.SupplierID = 4481 AND aa.DataSupplierArticleNumber = "108079000") OR (aa.SupplierID = 176 AND aa.DataSupplierArticleNumber = "464079") OR (aa.SupplierID = 176 AND aa.DataSupplierArticleNumber = "464080") OR (aa.SupplierID = 175 AND aa.DataSupplierArticleNumber = "8192579") OR (aa.SupplierID = 175 AND aa.DataSupplierArticleNumber = "8192580") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "051-48-072") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "051-48-072M") OR (aa.SupplierID = 4752 AND aa.DataSupplierArticleNumber = "ML4615") OR (aa.SupplierID = 4752 AND aa.DataSupplierArticleNumber = "ML4614") OR (aa.SupplierID = 4021 AND aa.DataSupplierArticleNumber = "RTO034") OR (aa.SupplierID = 4021 AND aa.DataSupplierArticleNumber = "RTO035") OR (aa.SupplierID = 173 AND aa.DataSupplierArticleNumber = "121553") OR (aa.SupplierID = 401 AND aa.DataSupplierArticleNumber = "GS1706") OR (aa.SupplierID = 401 AND aa.DataSupplierArticleNumber = "GS1705") ) AND aa.Language = "ru" Продажа автозапчастей типа Багажник / помещение для груза для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
CARBOX 208079000 Лоток багажного/грузового отсека
108080000 Ванночка для багажника
108079000 Ванночка для багажника
KILEN 464079 Газовая пружина, крышка багажник
464080 Газовая пружина, крышка багажник
LESJÖFORS 8192579 Газовая пружина, крышка багажник
8192580 Газовая пружина, крышка багажник
LORO 051-48-072 Ванночка для багажника
051-48-072M Ванночка для багажника
MONROE-AU ML4615 Газовая пружина, крышка багажник
ML4614 Газовая пружина, крышка багажник
montcada RTO034 Газовая пружина, крышка багажник
RTO035 Газовая пружина, крышка багажник
RAMEDER 121553 Ванночка для багажника
ROC GS1706 Газовая пружина, крышка багажник
GS1705 Газовая пружина, крышка багажник
2026 CATCAR.INFO (v 2.0)