#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU4N3x8bW9kZWxfaWQ9PTE5OTR8fG1kZl9pZD09MF4xMzEwMHx8c3BhcmVfaWQ9PTEwMDYxNw%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 = "13100" AND ( (av.SupplierID = 4815 AND av.DataSupplierArticleNumber = "B12418" AND av.ProductID IN (864)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 90-860-035" AND av.ProductID IN (864)) OR (av.SupplierID = 157 AND av.DataSupplierArticleNumber = "BSP24791" AND av.ProductID IN (791)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "37644" AND av.ProductID IN (864)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "6NW 007 546-071" AND av.ProductID IN (791)) OR (av.SupplierID = 403 AND av.DataSupplierArticleNumber = "28-0348" AND av.ProductID IN (791)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "2317001" AND av.ProductID IN (791)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "2317013" AND av.ProductID IN (791)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "0916007" AND av.ProductID IN (864)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "2317000" AND av.ProductID IN (791)) OR (av.SupplierID = 4683 AND av.DataSupplierArticleNumber = "13278" AND av.ProductID IN (791)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "30 93 7644" AND av.ProductID IN (864)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "112 408" AND av.ProductID IN (864)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "115 155" AND av.ProductID IN (791)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "115 117" AND av.ProductID IN (864)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "115 156" AND av.ProductID IN (791)) OR (av.SupplierID = 83 AND av.DataSupplierArticleNumber = "X10-729-002-009" AND av.ProductID IN (791)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V10-77-0007" AND av.ProductID IN (791)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V10-77-1011" AND av.ProductID IN (791)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "99591342501" AND av.ProductID IN (791)) OR (av.SupplierID = 4346 AND av.DataSupplierArticleNumber = "99591343401" AND av.ProductID IN (791)) ) 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 = 4815 AND aa.DataSupplierArticleNumber = "B12418") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 90-860-035") OR (aa.SupplierID = 157 AND aa.DataSupplierArticleNumber = "BSP24791") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "37644") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "6NW 007 546-071") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "28-0348") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2317001") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2317013") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0916007") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2317000") OR (aa.SupplierID = 4683 AND aa.DataSupplierArticleNumber = "13278") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 7644") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "112 408") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "115 155") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "115 117") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "115 156") OR (aa.SupplierID = 83 AND aa.DataSupplierArticleNumber = "X10-729-002-009") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V10-77-0007") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V10-77-1011") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99591342501") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99591343401") ) 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 = 4815 AND aa.DataSupplierArticleNumber = "B12418") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 90-860-035") OR (aa.SupplierID = 157 AND aa.DataSupplierArticleNumber = "BSP24791") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "37644") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "6NW 007 546-071") OR (aa.SupplierID = 403 AND aa.DataSupplierArticleNumber = "28-0348") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2317001") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2317013") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0916007") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "2317000") OR (aa.SupplierID = 4683 AND aa.DataSupplierArticleNumber = "13278") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "30 93 7644") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "112 408") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "115 155") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "115 117") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "115 156") OR (aa.SupplierID = 83 AND aa.DataSupplierArticleNumber = "X10-729-002-009") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V10-77-0007") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V10-77-1011") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99591342501") OR (aa.SupplierID = 4346 AND aa.DataSupplierArticleNumber = "99591343401") ) AND aa.Language = "ru" Продажа автозапчастей типа Центральный замок для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
Borsehung B12418 Выключатель, фиксатор двери
BSG BSG 90-860-035 Выключатель, фиксатор двери
BUGIAD BSP24791 Регулировочный элемент, центральный замок
FEBI BILSTEIN 37644 Выключатель, фиксатор двери
HELLA 6NW 007 546-071 Регулировочный элемент, центральный замок
MAXGEAR 28-0348 Регулировочный элемент, центральный замок
METZGER 2317001 Регулировочный элемент, центральный замок
2317013 Регулировочный элемент, центральный замок
0916007 Выключатель, фиксатор двери
2317000 Регулировочный элемент, центральный замок
OSSCA 13278 Регулировочный элемент, центральный замок
SWAG 30 93 7644 Выключатель, фиксатор двери
TOPRAN 112 408 Выключатель, фиксатор двери
115 155 Регулировочный элемент, центральный замок
115 117 Выключатель, фиксатор двери
115 156 Регулировочный элемент, центральный замок
VDO X10-729-002-009 Регулировочный элемент, центральный замок
VEMO V10-77-0007 Регулировочный элемент, центральный замок
V10-77-1011 Регулировочный элемент, центральный замок
vika 99591342501 Регулировочный элемент, центральный замок
99591343401 Регулировочный элемент, центральный замок
2026 CATCAR.INFO (v 2.0)