#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTY0N3x8bW9kZWxfaWQ9PTQ3MTJ8fG1kZl9pZD09MF4xNjI4Mnx8c3BhcmVfaWQ9PTEwNDMxMw%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 = "16282" AND ( (av.SupplierID = 4997 AND av.DataSupplierArticleNumber = "YP313923" AND av.ProductID IN (540)) OR (av.SupplierID = 257 AND av.DataSupplierArticleNumber = "128-0H-H04" AND av.ProductID IN (540)) OR (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "654572" AND av.ProductID IN (540)) OR (av.SupplierID = 4651 AND av.DataSupplierArticleNumber = "03.81422" AND av.ProductID IN (540)) OR (av.SupplierID = 4651 AND av.DataSupplierArticleNumber = "03.80235" AND av.ProductID IN (540)) OR (av.SupplierID = 4651 AND av.DataSupplierArticleNumber = "03.80558" AND av.ProductID IN (540)) OR (av.SupplierID = 4693 AND av.DataSupplierArticleNumber = "E20500BTA" AND av.ProductID IN (540)) OR (av.SupplierID = 204 AND av.DataSupplierArticleNumber = "534 0306 10" AND av.ProductID IN (540)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "15-3567" AND av.ProductID IN (540)) OR (av.SupplierID = 156 AND av.DataSupplierArticleNumber = "TS-H04" AND av.ProductID IN (540)) OR (av.SupplierID = 481 AND av.DataSupplierArticleNumber = "128H04" AND av.ProductID IN (540)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "3518200309" AND av.ProductID IN (540)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "R0358" AND av.ProductID IN (540)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "R0357" AND av.ProductID IN (540)) OR (av.SupplierID = 4773 AND av.DataSupplierArticleNumber = "MTP-4H04" AND av.ProductID IN (540)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "0-N1815" AND av.ProductID IN (540)) OR (av.SupplierID = 4330 AND av.DataSupplierArticleNumber = "RKT3138" AND av.ProductID IN (540)) OR (av.SupplierID = 4330 AND av.DataSupplierArticleNumber = "RKT1951" AND av.ProductID IN (540)) OR (av.SupplierID = 4330 AND av.DataSupplierArticleNumber = "RKT2274" AND av.ProductID IN (540)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "58414" AND av.ProductID IN (540)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8641 433001" AND av.ProductID IN (540)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1253480" 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 = 4997 AND aa.DataSupplierArticleNumber = "YP313923") OR (aa.SupplierID = 257 AND aa.DataSupplierArticleNumber = "128-0H-H04") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "654572") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.81422") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.80235") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.80558") OR (aa.SupplierID = 4693 AND aa.DataSupplierArticleNumber = "E20500BTA") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "534 0306 10") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "15-3567") OR (aa.SupplierID = 156 AND aa.DataSupplierArticleNumber = "TS-H04") OR (aa.SupplierID = 481 AND aa.DataSupplierArticleNumber = "128H04") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "3518200309") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "R0358") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "R0357") OR (aa.SupplierID = 4773 AND aa.DataSupplierArticleNumber = "MTP-4H04") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "0-N1815") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT3138") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT1951") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT2274") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "58414") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8641 433001") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1253480") ) 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 = 4997 AND aa.DataSupplierArticleNumber = "YP313923") OR (aa.SupplierID = 257 AND aa.DataSupplierArticleNumber = "128-0H-H04") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "654572") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.81422") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.80235") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.80558") OR (aa.SupplierID = 4693 AND aa.DataSupplierArticleNumber = "E20500BTA") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "534 0306 10") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "15-3567") OR (aa.SupplierID = 156 AND aa.DataSupplierArticleNumber = "TS-H04") OR (aa.SupplierID = 481 AND aa.DataSupplierArticleNumber = "128H04") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "3518200309") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "R0358") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "R0357") OR (aa.SupplierID = 4773 AND aa.DataSupplierArticleNumber = "MTP-4H04") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "0-N1815") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT3138") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT1951") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT2274") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "58414") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8641 433001") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1253480") ) AND aa.Language = "ru" Продажа автозапчастей типа Натяжная планка для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
A.B.A YP313923 Натяжная планка, поликлиновой ремень
ASHIKA 128-0H-H04 Натяжная планка, поликлиновой ремень
AUTEX 654572 Натяжная планка, поликлиновой ремень
AUTOKIT 03.81422 Натяжная планка, поликлиновой ремень
03.80235 Натяжная планка, поликлиновой ремень
03.80558 Натяжная планка, поликлиновой ремень
BTA E20500BTA Натяжная планка, поликлиновой ремень
INA 534 0306 10 Натяжная планка, поликлиновой ремень
IPD 15-3567 Натяжная планка, поликлиновой ремень
JAPANPARTS TS-H04 Натяжная планка, поликлиновой ремень
JAPKO 128H04 Натяжная планка, поликлиновой ремень
JP GROUP 3518200309 Натяжная планка, поликлиновой ремень
KAMOKA R0358 Натяжная планка, поликлиновой ремень
R0357 Натяжная планка, поликлиновой ремень
MDR MTP-4H04 Натяжная планка, поликлиновой ремень
OPTIMAL 0-N1815 Натяжная планка, поликлиновой ремень
REPKIT RKT3138 Натяжная планка, поликлиновой ремень
RKT1951 Натяжная планка, поликлиновой ремень
RKT2274 Натяжная планка, поликлиновой ремень
RUVILLE 58414 Натяжная планка, поликлиновой ремень
TRISCAN 8641 433001 Натяжная планка, поликлиновой ремень
WILMINK GROUP WG1253480 Натяжная планка, поликлиновой ремень
2026 CATCAR.INFO (v 2.0)