#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2M3x8bW9kZWxfaWQ9PTQ4OTJ8fG1kZl9pZD09MF4yOTc2MXx8c3BhcmVfaWQ9PTEwMDc1MQ%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 = "29761" AND ( (av.SupplierID = 4948 AND av.DataSupplierArticleNumber = "DP3210.10.1260" AND av.ProductID IN (1561)) OR (av.SupplierID = 4948 AND av.DataSupplierArticleNumber = "DP3210.10.0132" AND av.ProductID IN (1561)) OR (av.SupplierID = 4948 AND av.DataSupplierArticleNumber = "DP3210.10.0182" AND av.ProductID IN (1561)) OR (av.SupplierID = 4938 AND av.DataSupplierArticleNumber = "FT91953" AND av.ProductID IN (1761)) OR (av.SupplierID = 4938 AND av.DataSupplierArticleNumber = "FT91935" AND av.ProductID IN (1761)) OR (av.SupplierID = 4938 AND av.DataSupplierArticleNumber = "FT91955" AND av.ProductID IN (1761)) OR (av.SupplierID = 4938 AND av.DataSupplierArticleNumber = "FT91950" AND av.ProductID IN (1761)) OR (av.SupplierID = 4938 AND av.DataSupplierArticleNumber = "FT91951" AND av.ProductID IN (1761)) OR (av.SupplierID = 4627 AND av.DataSupplierArticleNumber = "WPR2887RM" AND av.ProductID IN (1561)) OR (av.SupplierID = 4627 AND av.DataSupplierArticleNumber = "WPR2086RM" AND av.ProductID IN (1561)) OR (av.SupplierID = 4627 AND av.DataSupplierArticleNumber = "WPR2087LM" AND av.ProductID IN (1561)) OR (av.SupplierID = 4627 AND av.DataSupplierArticleNumber = "WPR2886LM" AND av.ProductID IN (1561)) ) 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 = 4948 AND aa.DataSupplierArticleNumber = "DP3210.10.1260") OR (aa.SupplierID = 4948 AND aa.DataSupplierArticleNumber = "DP3210.10.0132") OR (aa.SupplierID = 4948 AND aa.DataSupplierArticleNumber = "DP3210.10.0182") OR (aa.SupplierID = 4938 AND aa.DataSupplierArticleNumber = "FT91953") OR (aa.SupplierID = 4938 AND aa.DataSupplierArticleNumber = "FT91935") OR (aa.SupplierID = 4938 AND aa.DataSupplierArticleNumber = "FT91955") OR (aa.SupplierID = 4938 AND aa.DataSupplierArticleNumber = "FT91950") OR (aa.SupplierID = 4938 AND aa.DataSupplierArticleNumber = "FT91951") OR (aa.SupplierID = 4627 AND aa.DataSupplierArticleNumber = "WPR2887RM") OR (aa.SupplierID = 4627 AND aa.DataSupplierArticleNumber = "WPR2086RM") OR (aa.SupplierID = 4627 AND aa.DataSupplierArticleNumber = "WPR2087LM") OR (aa.SupplierID = 4627 AND aa.DataSupplierArticleNumber = "WPR2886LM") ) 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 = 4948 AND aa.DataSupplierArticleNumber = "DP3210.10.1260") OR (aa.SupplierID = 4948 AND aa.DataSupplierArticleNumber = "DP3210.10.0132") OR (aa.SupplierID = 4948 AND aa.DataSupplierArticleNumber = "DP3210.10.0182") OR (aa.SupplierID = 4938 AND aa.DataSupplierArticleNumber = "FT91953") OR (aa.SupplierID = 4938 AND aa.DataSupplierArticleNumber = "FT91935") OR (aa.SupplierID = 4938 AND aa.DataSupplierArticleNumber = "FT91955") OR (aa.SupplierID = 4938 AND aa.DataSupplierArticleNumber = "FT91950") OR (aa.SupplierID = 4938 AND aa.DataSupplierArticleNumber = "FT91951") OR (aa.SupplierID = 4627 AND aa.DataSupplierArticleNumber = "WPR2887RM") OR (aa.SupplierID = 4627 AND aa.DataSupplierArticleNumber = "WPR2086RM") OR (aa.SupplierID = 4627 AND aa.DataSupplierArticleNumber = "WPR2087LM") OR (aa.SupplierID = 4627 AND aa.DataSupplierArticleNumber = "WPR2886LM") ) AND aa.Language = "ru" Продажа автозапчастей типа Подъемное устройство для окон для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
Dr!ve+ DP3210.10.1260 Подъемное устройство для окон
DP3210.10.0132 Подъемное устройство для окон
DP3210.10.0182 Подъемное устройство для окон
FAST FT91953 Выключатель, стеклолодъемник
FT91935 Выключатель, стеклолодъемник
FT91955 Выключатель, стеклолодъемник
FT91950 Выключатель, стеклолодъемник
FT91951 Выключатель, стеклолодъемник
WAI WPR2887RM Подъемное устройство для окон
WPR2086RM Подъемное устройство для окон
WPR2087LM Подъемное устройство для окон
WPR2886LM Подъемное устройство для окон
2026 CATCAR.INFO (v 2.0)