#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUwNHx8bW9kZWxfaWQ9PTU1NDR8fG1kZl9pZD09MF4xOTQ1M3x8c3BhcmVfaWQ9PTEwMjY5MQ%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 = "19453" AND ( (av.SupplierID = 4849 AND av.DataSupplierArticleNumber = "01.7697" AND av.ProductID IN (1561,1561)) OR (av.SupplierID = 4849 AND av.DataSupplierArticleNumber = "01.7696" AND av.ProductID IN (1561,1561)) OR (av.SupplierID = 4455 AND av.DataSupplierArticleNumber = "BSG 90-860-027" AND av.ProductID IN (1761)) OR (av.SupplierID = 4585 AND av.DataSupplierArticleNumber = "101547" AND av.ProductID IN (1561)) OR (av.SupplierID = 4585 AND av.DataSupplierArticleNumber = "101548" AND av.ProductID IN (1561)) OR (av.SupplierID = 4948 AND av.DataSupplierArticleNumber = "DP3210.10.0185" AND av.ProductID IN (1561)) OR (av.SupplierID = 4948 AND av.DataSupplierArticleNumber = "DP3210.10.0195" AND av.ProductID IN (1561)) OR (av.SupplierID = 4603 AND av.DataSupplierArticleNumber = "ZR AD718 R" AND av.ProductID IN (1561)) OR (av.SupplierID = 4603 AND av.DataSupplierArticleNumber = "ZR AD718 L" AND av.ProductID IN (1561)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "WRL2011L" AND av.ProductID IN (1561)) OR (av.SupplierID = 4344 AND av.DataSupplierArticleNumber = "WRL2011R" AND av.ProductID IN (1561)) OR (av.SupplierID = 234 AND av.DataSupplierArticleNumber = "490496" AND av.ProductID IN (1561)) OR (av.SupplierID = 234 AND av.DataSupplierArticleNumber = "490497" AND av.ProductID IN (1561)) OR (av.SupplierID = 268 AND av.DataSupplierArticleNumber = "1196702800" AND av.ProductID IN (1761)) OR (av.SupplierID = 4719 AND av.DataSupplierArticleNumber = "LT AD718 R" AND av.ProductID IN (1561)) OR (av.SupplierID = 4719 AND av.DataSupplierArticleNumber = "LT AD718 L" AND av.ProductID IN (1561)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "0916261" AND av.ProductID IN (1761)) OR (av.SupplierID = 4720 AND av.DataSupplierArticleNumber = "13004 L" AND av.ProductID IN (1561)) OR (av.SupplierID = 4720 AND av.DataSupplierArticleNumber = "13004 R" AND av.ProductID IN (1561)) OR (av.SupplierID = 263 AND av.DataSupplierArticleNumber = "901272" AND av.ProductID IN (1561)) OR (av.SupplierID = 263 AND av.DataSupplierArticleNumber = "901271" AND av.ProductID IN (1561)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "114 573" AND av.ProductID IN (1761)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V10-73-0008" AND av.ProductID IN (1761)) OR (av.SupplierID = 4627 AND av.DataSupplierArticleNumber = "WPR2938L" AND av.ProductID IN (1561)) OR (av.SupplierID = 4627 AND av.DataSupplierArticleNumber = "WPR2939R" 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 = 4849 AND aa.DataSupplierArticleNumber = "01.7697") OR (aa.SupplierID = 4849 AND aa.DataSupplierArticleNumber = "01.7696") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 90-860-027") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "101547") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "101548") OR (aa.SupplierID = 4948 AND aa.DataSupplierArticleNumber = "DP3210.10.0185") OR (aa.SupplierID = 4948 AND aa.DataSupplierArticleNumber = "DP3210.10.0195") OR (aa.SupplierID = 4603 AND aa.DataSupplierArticleNumber = "ZR AD718 R") OR (aa.SupplierID = 4603 AND aa.DataSupplierArticleNumber = "ZR AD718 L") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "WRL2011L") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "WRL2011R") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "490496") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "490497") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1196702800") OR (aa.SupplierID = 4719 AND aa.DataSupplierArticleNumber = "LT AD718 R") OR (aa.SupplierID = 4719 AND aa.DataSupplierArticleNumber = "LT AD718 L") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0916261") OR (aa.SupplierID = 4720 AND aa.DataSupplierArticleNumber = "13004 L") OR (aa.SupplierID = 4720 AND aa.DataSupplierArticleNumber = "13004 R") OR (aa.SupplierID = 263 AND aa.DataSupplierArticleNumber = "901272") OR (aa.SupplierID = 263 AND aa.DataSupplierArticleNumber = "901271") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "114 573") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V10-73-0008") OR (aa.SupplierID = 4627 AND aa.DataSupplierArticleNumber = "WPR2938L") OR (aa.SupplierID = 4627 AND aa.DataSupplierArticleNumber = "WPR2939R") ) 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 = 4849 AND aa.DataSupplierArticleNumber = "01.7697") OR (aa.SupplierID = 4849 AND aa.DataSupplierArticleNumber = "01.7696") OR (aa.SupplierID = 4455 AND aa.DataSupplierArticleNumber = "BSG 90-860-027") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "101547") OR (aa.SupplierID = 4585 AND aa.DataSupplierArticleNumber = "101548") OR (aa.SupplierID = 4948 AND aa.DataSupplierArticleNumber = "DP3210.10.0185") OR (aa.SupplierID = 4948 AND aa.DataSupplierArticleNumber = "DP3210.10.0195") OR (aa.SupplierID = 4603 AND aa.DataSupplierArticleNumber = "ZR AD718 R") OR (aa.SupplierID = 4603 AND aa.DataSupplierArticleNumber = "ZR AD718 L") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "WRL2011L") OR (aa.SupplierID = 4344 AND aa.DataSupplierArticleNumber = "WRL2011R") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "490496") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "490497") OR (aa.SupplierID = 268 AND aa.DataSupplierArticleNumber = "1196702800") OR (aa.SupplierID = 4719 AND aa.DataSupplierArticleNumber = "LT AD718 R") OR (aa.SupplierID = 4719 AND aa.DataSupplierArticleNumber = "LT AD718 L") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0916261") OR (aa.SupplierID = 4720 AND aa.DataSupplierArticleNumber = "13004 L") OR (aa.SupplierID = 4720 AND aa.DataSupplierArticleNumber = "13004 R") OR (aa.SupplierID = 263 AND aa.DataSupplierArticleNumber = "901272") OR (aa.SupplierID = 263 AND aa.DataSupplierArticleNumber = "901271") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "114 573") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V10-73-0008") OR (aa.SupplierID = 4627 AND aa.DataSupplierArticleNumber = "WPR2938L") OR (aa.SupplierID = 4627 AND aa.DataSupplierArticleNumber = "WPR2939R") ) AND aa.Language = "ru" Продажа автозапчастей типа Подъемное устройство для окон для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
Ac Rolcar 01.7697 Подъемное устройство для окон
01.7696 Подъемное устройство для окон
BSG BSG 90-860-027 Выключатель, стеклолодъемник
DOGA 101547 Подъемное устройство для окон
101548 Подъемное устройство для окон
Dr!ve+ DP3210.10.0185 Подъемное устройство для окон
DP3210.10.0195 Подъемное устройство для окон
ELECTRIC LIFE ZR AD718 R Подъемное устройство для окон
ZR AD718 L Подъемное устройство для окон
ELTA AUTOMOTIVE WRL2011L Подъемное устройство для окон
WRL2011R Подъемное устройство для окон
ERA 490496 Подъемное устройство для окон
490497 Подъемное устройство для окон
JP GROUP 1196702800 Выключатель, стеклолодъемник
LIFT-TEK LT AD718 R Подъемное устройство для окон
LT AD718 L Подъемное устройство для окон
METZGER 0916261 Выключатель, стеклолодъемник
PMM 13004 L Подъемное устройство для окон
13004 R Подъемное устройство для окон
SEIM 901272 Подъемное устройство для окон
901271 Подъемное устройство для окон
TOPRAN 114 573 Выключатель, стеклолодъемник
VEMO V10-73-0008 Выключатель, стеклолодъемник
WAI WPR2938L Подъемное устройство для окон
WPR2939R Подъемное устройство для окон
2026 CATCAR.INFO (v 2.0)