#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU4N3x8bW9kZWxfaWQ9PTU0Mjd8fG1kZl9pZD09MF4zMTU5Nnx8c3BhcmVfaWQ9PTEwMTcwMg%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 = "31596" AND ( (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "5703-04-9540571CP" AND av.ProductID IN (1005)) OR (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "5703-04-9540572CP" AND av.ProductID IN (1005)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "2247223" AND av.ProductID IN (1005)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "2247220" AND av.ProductID IN (1005)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "2247221" AND av.ProductID IN (1005)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "2247222" AND av.ProductID IN (1005)) OR (av.SupplierID = 4353 AND av.DataSupplierArticleNumber = "88540421902" AND av.ProductID IN (1005)) OR (av.SupplierID = 4353 AND av.DataSupplierArticleNumber = "88530810202" AND av.ProductID IN (1005)) OR (av.SupplierID = 4353 AND av.DataSupplierArticleNumber = "88540422002" AND av.ProductID IN (1005)) OR (av.SupplierID = 4353 AND av.DataSupplierArticleNumber = "88530810302" AND av.ProductID IN (1005)) OR (av.SupplierID = 4353 AND av.DataSupplierArticleNumber = "88530005502" AND av.ProductID IN (1005)) OR (av.SupplierID = 4353 AND av.DataSupplierArticleNumber = "88530008002" AND av.ProductID IN (1344)) OR (av.SupplierID = 4353 AND av.DataSupplierArticleNumber = "88540422102" AND av.ProductID IN (1005)) OR (av.SupplierID = 4353 AND av.DataSupplierArticleNumber = "88530810402" AND av.ProductID IN (1005)) OR (av.SupplierID = 4353 AND av.DataSupplierArticleNumber = "88530810102" AND av.ProductID IN (1005)) OR (av.SupplierID = 4353 AND av.DataSupplierArticleNumber = "88530008102" AND av.ProductID IN (1344)) OR (av.SupplierID = 4353 AND av.DataSupplierArticleNumber = "88540422202" AND av.ProductID IN (1005)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "5839406" AND av.ProductID IN (1005)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "5839403" AND av.ProductID IN (1005)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "5839404" AND av.ProductID IN (1005)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "5839405" AND av.ProductID IN (1005)) ) 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 = 4555 AND aa.DataSupplierArticleNumber = "5703-04-9540571CP") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "5703-04-9540572CP") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "2247223") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "2247220") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "2247221") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "2247222") OR (aa.SupplierID = 4353 AND aa.DataSupplierArticleNumber = "88540421902") OR (aa.SupplierID = 4353 AND aa.DataSupplierArticleNumber = "88530810202") OR (aa.SupplierID = 4353 AND aa.DataSupplierArticleNumber = "88540422002") OR (aa.SupplierID = 4353 AND aa.DataSupplierArticleNumber = "88530810302") OR (aa.SupplierID = 4353 AND aa.DataSupplierArticleNumber = "88530005502") OR (aa.SupplierID = 4353 AND aa.DataSupplierArticleNumber = "88530008002") OR (aa.SupplierID = 4353 AND aa.DataSupplierArticleNumber = "88540422102") OR (aa.SupplierID = 4353 AND aa.DataSupplierArticleNumber = "88530810402") OR (aa.SupplierID = 4353 AND aa.DataSupplierArticleNumber = "88530810102") OR (aa.SupplierID = 4353 AND aa.DataSupplierArticleNumber = "88530008102") OR (aa.SupplierID = 4353 AND aa.DataSupplierArticleNumber = "88540422202") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5839406") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5839403") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5839404") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5839405") ) 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 = 4555 AND aa.DataSupplierArticleNumber = "5703-04-9540571CP") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "5703-04-9540572CP") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "2247223") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "2247220") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "2247221") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "2247222") OR (aa.SupplierID = 4353 AND aa.DataSupplierArticleNumber = "88540421902") OR (aa.SupplierID = 4353 AND aa.DataSupplierArticleNumber = "88530810202") OR (aa.SupplierID = 4353 AND aa.DataSupplierArticleNumber = "88540422002") OR (aa.SupplierID = 4353 AND aa.DataSupplierArticleNumber = "88530810302") OR (aa.SupplierID = 4353 AND aa.DataSupplierArticleNumber = "88530005502") OR (aa.SupplierID = 4353 AND aa.DataSupplierArticleNumber = "88530008002") OR (aa.SupplierID = 4353 AND aa.DataSupplierArticleNumber = "88540422102") OR (aa.SupplierID = 4353 AND aa.DataSupplierArticleNumber = "88530810402") OR (aa.SupplierID = 4353 AND aa.DataSupplierArticleNumber = "88530810102") OR (aa.SupplierID = 4353 AND aa.DataSupplierArticleNumber = "88530008102") OR (aa.SupplierID = 4353 AND aa.DataSupplierArticleNumber = "88540422202") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5839406") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5839403") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5839404") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5839405") ) AND aa.Language = "ru" Продажа автозапчастей типа Облицовка/защитная накладка для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
BLIC 5703-04-9540571CP Облицовка / защитная накладка, дверь
5703-04-9540572CP Облицовка / защитная накладка, дверь
DIEDERICHS 2247223 Облицовка / защитная накладка, дверь
2247220 Облицовка / защитная накладка, дверь
2247221 Облицовка / защитная накладка, дверь
2247222 Облицовка / защитная накладка, дверь
DPA 88540421902 Облицовка / защитная накладка, дверь
88530810202 Облицовка / защитная накладка, дверь
88540422002 Облицовка / защитная накладка, дверь
88530810302 Облицовка / защитная накладка, дверь
88530005502 Облицовка / защитная накладка, дверь
88530008002 Накладка порога
88540422102 Облицовка / защитная накладка, дверь
88530810402 Облицовка / защитная накладка, дверь
88530810102 Облицовка / защитная накладка, дверь
88530008102 Накладка порога
88540422202 Облицовка / защитная накладка, дверь
VAN WEZEL 5839406 Облицовка / защитная накладка, дверь
5839403 Облицовка / защитная накладка, дверь
5839404 Облицовка / защитная накладка, дверь
5839405 Облицовка / защитная накладка, дверь
2026 CATCAR.INFO (v 2.0)