#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU4N3x8bW9kZWxfaWQ9PTk3MTB8fG1kZl9pZD09MF4yNDE3OXx8c3BhcmVfaWQ9PTEwMTY1Nw%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 = "24179" AND ( (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "2766128" AND av.ProductID IN (259)) OR (av.SupplierID = 362 AND av.DataSupplierArticleNumber = "2765128" AND av.ProductID IN (259)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "2266980" AND av.ProductID IN (259)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "2266981" AND av.ProductID IN (259)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "2266080" AND av.ProductID IN (259)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "2266485" AND av.ProductID IN (3175)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "2266081" AND av.ProductID IN (259)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "1EL 010 793-411" AND av.ProductID IN (259)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "1EL 010 793-421" AND av.ProductID IN (259)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "1E9 010 793-011" AND av.ProductID IN (259)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "1E9 010 793-021" AND av.ProductID IN (259)) OR (av.SupplierID = 138 AND av.DataSupplierArticleNumber = "95 17 10" AND av.ProductID IN (259)) OR (av.SupplierID = 138 AND av.DataSupplierArticleNumber = "95 17 09" AND av.ProductID IN (259)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "95150131" AND av.ProductID IN (259)) OR (av.SupplierID = 78 AND av.DataSupplierArticleNumber = "95150132" AND av.ProductID IN (259)) OR (av.SupplierID = 4657 AND av.DataSupplierArticleNumber = "441-11H3LMLDEM2" AND av.ProductID IN (259)) OR (av.SupplierID = 4657 AND av.DataSupplierArticleNumber = "441-11H3RMLDEM2" AND av.ProductID IN (259)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "390079" AND av.ProductID IN (259)) OR (av.SupplierID = 4680 AND av.DataSupplierArticleNumber = "390080" AND av.ProductID IN (259)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "5806962" AND av.ProductID IN (259)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "5806961" AND av.ProductID IN (259)) ) 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 = 362 AND aa.DataSupplierArticleNumber = "2766128") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "2765128") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "2266980") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "2266981") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "2266080") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "2266485") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "2266081") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "1EL 010 793-411") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "1EL 010 793-421") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "1E9 010 793-011") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "1E9 010 793-021") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "95 17 10") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "95 17 09") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "95150131") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "95150132") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "441-11H3LMLDEM2") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "441-11H3RMLDEM2") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "390079") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "390080") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5806962") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5806961") ) 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 = 362 AND aa.DataSupplierArticleNumber = "2766128") OR (aa.SupplierID = 362 AND aa.DataSupplierArticleNumber = "2765128") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "2266980") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "2266981") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "2266080") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "2266485") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "2266081") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "1EL 010 793-411") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "1EL 010 793-421") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "1E9 010 793-011") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "1E9 010 793-021") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "95 17 10") OR (aa.SupplierID = 138 AND aa.DataSupplierArticleNumber = "95 17 09") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "95150131") OR (aa.SupplierID = 78 AND aa.DataSupplierArticleNumber = "95150132") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "441-11H3LMLDEM2") OR (aa.SupplierID = 4657 AND aa.DataSupplierArticleNumber = "441-11H3RMLDEM2") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "390079") OR (aa.SupplierID = 4680 AND aa.DataSupplierArticleNumber = "390080") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5806962") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "5806961") ) AND aa.Language = "ru" Продажа автозапчастей типа Основная фара / вставка для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
ALKAR 2766128 Основная фара
2765128 Основная фара
DIEDERICHS 2266980 Основная фара
2266981 Основная фара
2266080 Основная фара
2266485 Комплект главных фар
2266081 Основная фара
HELLA 1EL 010 793-411 Основная фара
1EL 010 793-421 Основная фара
1E9 010 793-011 Основная фара
1E9 010 793-021 Основная фара
JOHNS 95 17 10 Основная фара
95 17 09 Основная фара
KLOKKERHOLM 95150131 Основная фара
95150132 Основная фара
LORO 441-11H3LMLDEM2 Основная фара
441-11H3RMLDEM2 Основная фара
SPILU 390079 Основная фара
390080 Основная фара
VAN WEZEL 5806962 Основная фара
5806961 Основная фара
2026 CATCAR.INFO (v 2.0)