#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1M3x8bW9kZWxfaWQ9PTYyMjR8fG1kZl9pZD09MF4yMzEzOHx8c3BhcmVfaWQ9PTEwMDc0MA%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 = "23138" AND ( (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "5703-05-3518970P" AND av.ProductID IN (1002)) OR (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "6502-07-3518922P" AND av.ProductID IN (1002)) OR (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "5703-05-3518971P" AND av.ProductID IN (1002)) OR (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "6502-07-3518923P" AND av.ProductID IN (1002)) OR (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "5703-05-3518972P" AND av.ProductID IN (1002)) OR (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "6502-07-3518924P" AND av.ProductID IN (1002)) OR (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "6502-07-3518921P" AND av.ProductID IN (1002)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "1672162" AND av.ProductID IN (1002)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "1672069" AND av.ProductID IN (1002)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "8301672" AND av.ProductID IN (1249)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "1672163" AND av.ProductID IN (1002)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "1672146" AND av.ProductID IN (1002)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "1672066" AND av.ProductID IN (1002)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "1672147" AND av.ProductID IN (1002)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "1672068" AND av.ProductID IN (1002)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "44739" AND av.ProductID IN (3881)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "3518922" AND av.ProductID IN (1002)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "3518921" AND av.ProductID IN (1002)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "ME0291244" AND av.ProductID IN (1002)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "ME4401253" AND av.ProductID IN (1002)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "ME4401254" AND av.ProductID IN (1002)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "ME0291243" AND av.ProductID IN (1002)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "10 94 4739" AND av.ProductID IN (3881)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "3097481" AND av.ProductID IN (1002)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "3097482" AND av.ProductID IN (1002)) ) 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-05-3518970P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6502-07-3518922P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "5703-05-3518971P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6502-07-3518923P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "5703-05-3518972P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6502-07-3518924P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6502-07-3518921P") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1672162") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1672069") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "8301672") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1672163") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1672146") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1672066") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1672147") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1672068") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "44739") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "3518922") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "3518921") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "ME0291244") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "ME4401253") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "ME4401254") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "ME0291243") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 94 4739") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "3097481") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "3097482") ) 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-05-3518970P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6502-07-3518922P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "5703-05-3518971P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6502-07-3518923P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "5703-05-3518972P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6502-07-3518924P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6502-07-3518921P") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1672162") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1672069") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "8301672") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1672163") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1672146") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1672066") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1672147") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "1672068") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "44739") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "3518922") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "3518921") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "ME0291244") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "ME4401253") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "ME4401254") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "ME0291243") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "10 94 4739") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "3097481") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "3097482") ) AND aa.Language = "ru" Продажа автозапчастей типа Облицовка/защитная накладка для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
BLIC 5703-05-3518970P Облицовка / защитная накладка, буфер
6502-07-3518922P Облицовка / защитная накладка, буфер
5703-05-3518971P Облицовка / защитная накладка, буфер
6502-07-3518923P Облицовка / защитная накладка, буфер
5703-05-3518972P Облицовка / защитная накладка, буфер
6502-07-3518924P Облицовка / защитная накладка, буфер
6502-07-3518921P Облицовка / защитная накладка, буфер
DIEDERICHS 1672162 Облицовка / защитная накладка, буфер
1672069 Облицовка / защитная накладка, буфер
8301672 Облицовка / защитная накладка, ветровое стекло
1672163 Облицовка / защитная накладка, буфер
1672146 Облицовка / защитная накладка, буфер
1672066 Облицовка / защитная накладка, буфер
1672147 Облицовка / защитная накладка, буфер
1672068 Облицовка / защитная накладка, буфер
FEBI BILSTEIN 44739 Зажим, молдинг / защитная накладка
KLOKKERHOLM 3518922 Облицовка / защитная накладка, буфер
3518921 Облицовка / защитная накладка, буфер
PRASCO ME0291244 Облицовка / защитная накладка, буфер
ME4401253 Облицовка / защитная накладка, буфер
ME4401254 Облицовка / защитная накладка, буфер
ME0291243 Облицовка / защитная накладка, буфер
SWAG 10 94 4739 Зажим, молдинг / защитная накладка
VAN WEZEL 3097481 Облицовка / защитная накладка, буфер
3097482 Облицовка / защитная накладка, буфер
2026 CATCAR.INFO (v 2.0)