#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2Nnx8bW9kZWxfaWQ9PTk2OTh8fG1kZl9pZD09MF4xMTAzN3x8c3BhcmVfaWQ9PTEwMDQzOA%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 = "11037" AND ( (av.SupplierID = 4997 AND av.DataSupplierArticleNumber = "YP950008" AND av.ProductID IN (540)) OR (av.SupplierID = 300 AND av.DataSupplierArticleNumber = "654775" AND av.ProductID IN (540)) OR (av.SupplierID = 4651 AND av.DataSupplierArticleNumber = "03.81113" AND av.ProductID IN (540)) OR (av.SupplierID = 195 AND av.DataSupplierArticleNumber = "TOA4006" AND av.ProductID IN (540)) OR (av.SupplierID = 4834 AND av.DataSupplierArticleNumber = "14291" AND av.ProductID IN (2729)) OR (av.SupplierID = 204 AND av.DataSupplierArticleNumber = "534 0281 10" AND av.ProductID IN (540)) OR (av.SupplierID = 262 AND av.DataSupplierArticleNumber = "15-3770" AND av.ProductID IN (540)) OR (av.SupplierID = 185 AND av.DataSupplierArticleNumber = "R0193" AND av.ProductID IN (540)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "54-0831" AND av.ProductID IN (540)) OR (av.SupplierID = 129 AND av.DataSupplierArticleNumber = "0-N2039" AND av.ProductID IN (540)) OR (av.SupplierID = 4330 AND av.DataSupplierArticleNumber = "RKT2829" AND av.ProductID IN (540)) OR (av.SupplierID = 23 AND av.DataSupplierArticleNumber = "55620" AND av.ProductID IN (540)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1253465" 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 = "YP950008") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "654775") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.81113") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "TOA4006") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "14291") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "534 0281 10") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "15-3770") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "R0193") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "54-0831") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "0-N2039") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT2829") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "55620") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1253465") ) 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 = "YP950008") OR (aa.SupplierID = 300 AND aa.DataSupplierArticleNumber = "654775") OR (aa.SupplierID = 4651 AND aa.DataSupplierArticleNumber = "03.81113") OR (aa.SupplierID = 195 AND aa.DataSupplierArticleNumber = "TOA4006") OR (aa.SupplierID = 4834 AND aa.DataSupplierArticleNumber = "14291") OR (aa.SupplierID = 204 AND aa.DataSupplierArticleNumber = "534 0281 10") OR (aa.SupplierID = 262 AND aa.DataSupplierArticleNumber = "15-3770") OR (aa.SupplierID = 185 AND aa.DataSupplierArticleNumber = "R0193") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "54-0831") OR (aa.SupplierID = 129 AND aa.DataSupplierArticleNumber = "0-N2039") OR (aa.SupplierID = 4330 AND aa.DataSupplierArticleNumber = "RKT2829") OR (aa.SupplierID = 23 AND aa.DataSupplierArticleNumber = "55620") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1253465") ) AND aa.Language = "ru" Продажа автозапчастей типа Натяжная планка для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
A.B.A YP950008 Натяжная планка, поликлиновой ремень
AUTEX 654775 Натяжная планка, поликлиновой ремень
AUTOKIT 03.81113 Натяжная планка, поликлиновой ремень
BREDA LORETT TOA4006 Натяжная планка, поликлиновой ремень
FARE SA 14291 ремонтный комплект, рычаг натяжки поликлинового ремня
INA 534 0281 10 Натяжная планка, поликлиновой ремень
IPD 15-3770 Натяжная планка, поликлиновой ремень
KAMOKA R0193 Натяжная планка, поликлиновой ремень
MAXGEAR 54-0831 Натяжная планка, поликлиновой ремень
OPTIMAL 0-N2039 Натяжная планка, поликлиновой ремень
REPKIT RKT2829 Натяжная планка, поликлиновой ремень
RUVILLE 55620 Натяжная планка, поликлиновой ремень
WILMINK GROUP WG1253465 Натяжная планка, поликлиновой ремень
2026 CATCAR.INFO (v 2.0)