#216.73.216.140 catcar.info/totalcatalog/?l=YnJhbmRfaWQ9PTU3Mnx8bW9kZWxfaWQ9PTU1MzZ8fG1kZl9pZD09MV41MTg3fHxzcGFyZV9pZD09MjAxMDI5&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 = "5187" AND ( (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "10493" AND av.ProductID IN (1182)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "09857" AND av.ProductID IN (1182)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "10437" AND av.ProductID IN (37)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "10388" AND av.ProductID IN (1182)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "040.475" AND av.ProductID IN (1182)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "040.084" AND av.ProductID IN (1182)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "040.508" AND av.ProductID IN (37)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "040.095" AND av.ProductID IN (1182)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "040.043" AND av.ProductID IN (1182)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "040.305" AND av.ProductID IN (1182)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "040.047" AND av.ProductID IN (1182)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "040.505" AND av.ProductID IN (37)) ) 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 = "10493") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "09857") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "10437") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "10388") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.475") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.084") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.508") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.095") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.043") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.305") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.047") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.505") ) 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 = "10493") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "09857") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "10437") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "10388") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.475") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.084") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.508") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.095") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.043") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.305") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.047") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "040.505") ) AND aa.Language = "ru" Продажа автозапчастей типа Навесные части для автомобилей - Catcar.info
Каталог автозапчастей
Catcar Aftermarket
Каталог автозапчастей
Catcar Aftermarket
Уже продаёте автозапчасти? Подключите каталоги на свой сайт, чтобы повысить продажи
Подключить каталоги

Автозапчасти


Производители Артикул Наименование Сведения Полная информация
FEBI BILSTEIN 10493 Буфер, амортизация
09857 Буфер, амортизация
10437 Монтажный комплект, амортизатор
10388 Буфер, амортизация
SAMPA 040.475 Буфер, амортизация
040.084 Буфер, амортизация
040.508 Монтажный комплект, амортизатор
040.095 Буфер, амортизация
040.043 Буфер, амортизация
040.305 Буфер, амортизация
040.047 Буфер, амортизация
040.505 Монтажный комплект, амортизатор
2026 CATCAR.INFO (v 2.0)