#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2MXx8bW9kZWxfaWQ9PTQ4MjB8fG1kZl9pZD09MF4xOTI3OXx8c3BhcmVfaWQ9PTEwMDQzOA%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 = "19279" AND ( (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "601991" AND av.ProductID IN (540)) OR (av.SupplierID = 4651 AND av.DataSupplierArticleNumber = "03.81897" AND av.ProductID IN (540)) OR (av.SupplierID = 4651 AND av.DataSupplierArticleNumber = "03.80229" AND av.ProductID IN (540)) OR (av.SupplierID = 4651 AND av.DataSupplierArticleNumber = "03.80360" AND av.ProductID IN (540)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 65-615-023" AND av.ProductID IN (540)) OR (av.SupplierID = 4693 AND av.DataSupplierArticleNumber = "E2X5345BTA" AND av.ProductID IN (540)) OR (av.SupplierID = 204 AND av.DataSupplierArticleNumber = "533 0085 30" AND av.ProductID IN (540)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "10-0986" AND av.ProductID IN (540)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "R0098" AND av.ProductID IN (540)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "0-N2170" AND av.ProductID IN (540)) OR (av.SupplierID = 57 AND av.DataSupplierArticleNumber = "QTA1190" AND av.ProductID IN (540)) OR (av.SupplierID = 4330 AND av.DataSupplierArticleNumber = "RKT3613" AND av.ProductID IN (540)) OR (av.SupplierID = 4330 AND av.DataSupplierArticleNumber = "RKT1945" AND av.ProductID IN (540)) OR (av.SupplierID = 4330 AND av.DataSupplierArticleNumber = "RKT2076" AND av.ProductID IN (540)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "55345" AND av.ProductID IN (540)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8641 241003" AND av.ProductID IN (540)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V40-0203" AND av.ProductID IN (540)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1253228" AND av.ProductID IN (540)) ) 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 = 300 AND aa.DataSupplierArticleNumber = "601991") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.81897") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.80229") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.80360") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 65-615-023") OR (aa.SupplierID = 4693 AND aa.DataSupplierArticleNumber = "E2X5345BTA") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "533 0085 30") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "10-0986") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "R0098") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "0-N2170") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QTA1190") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT3613") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT1945") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT2076") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "55345") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8641 241003") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V40-0203") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1253228") ) 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 = 300 AND aa.DataSupplierArticleNumber = "601991") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.81897") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.80229") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.80360") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 65-615-023") OR (aa.SupplierID = 4693 AND aa.DataSupplierArticleNumber = "E2X5345BTA") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "533 0085 30") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "10-0986") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "R0098") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "0-N2170") OR (aa.SupplierID = 57 AND aa.DataSupplierArticleNumber = "QTA1190") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT3613") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT1945") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT2076") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "55345") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8641 241003") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V40-0203") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1253228") ) AND aa.Language = "ru" Продажа автозапчастей типа Натяжная планка для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
AUTEX 601991 Натяжная планка, поликлиновой ремень
AUTOKIT 03.81897 Натяжная планка, поликлиновой ремень
03.80229 Натяжная планка, поликлиновой ремень
03.80360 Натяжная планка, поликлиновой ремень
BSG BSG 65-615-023 Натяжная планка, поликлиновой ремень
BTA E2X5345BTA Натяжная планка, поликлиновой ремень
INA 533 0085 30 Натяжная планка, поликлиновой ремень
IPD 10-0986 Натяжная планка, поликлиновой ремень
KAMOKA R0098 Натяжная планка, поликлиновой ремень
OPTIMAL 0-N2170 Натяжная планка, поликлиновой ремень
QUINTON HAZELL QTA1190 Натяжная планка, поликлиновой ремень
REPKIT RKT3613 Натяжная планка, поликлиновой ремень
RKT1945 Натяжная планка, поликлиновой ремень
RKT2076 Натяжная планка, поликлиновой ремень
RUVILLE 55345 Натяжная планка, поликлиновой ремень
TRISCAN 8641 241003 Натяжная планка, поликлиновой ремень
VAICO V40-0203 Натяжная планка, поликлиновой ремень
WILMINK GROUP WG1253228 Натяжная планка, поликлиновой ремень
2026 CATCAR.INFO (v 2.0)