#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUxMXx8bW9kZWxfaWQ9PTExMzAwfHxtZGZfaWQ9PTBeNTk4MDZ8fHNwYXJlX2lkPT0xMDA1OTY%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 = "59806" AND ( (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "49386" AND av.ProductID IN (1334)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "38634" AND av.ProductID IN (1334)) OR (av.SupplierID = 133 AND av.DataSupplierArticleNumber = "38621" AND av.ProductID IN (1334)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "314 715 0012" AND av.ProductID IN (1334)) OR (av.SupplierID = 144 AND av.DataSupplierArticleNumber = "314 715 0013" AND av.ProductID IN (1334)) OR (av.SupplierID = 134 AND av.DataSupplierArticleNumber = "BM-SB-15100" AND av.ProductID IN (1334)) OR (av.SupplierID = 135 AND av.DataSupplierArticleNumber = "821919" AND av.ProductID IN (1334)) OR (av.SupplierID = 135 AND av.DataSupplierArticleNumber = "821918" AND av.ProductID IN (1334)) OR (av.SupplierID = 151 AND av.DataSupplierArticleNumber = "20 94 9386" AND av.ProductID IN (1334)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "502 948" AND av.ProductID IN (1334)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V20-2799" AND av.ProductID IN (1334)) OR (av.SupplierID = 162 AND av.DataSupplierArticleNumber = "V20-2963" AND av.ProductID IN (1334)) ) 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 = 101 AND aa.DataSupplierArticleNumber = "49386") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "38634") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "38621") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "314 715 0012") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "314 715 0013") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "BM-SB-15100") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "821919") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "821918") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "20 94 9386") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "502 948") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V20-2799") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V20-2963") ) 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 = 101 AND aa.DataSupplierArticleNumber = "49386") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "38634") OR (aa.SupplierID = 133 AND aa.DataSupplierArticleNumber = "38621") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "314 715 0012") OR (aa.SupplierID = 144 AND aa.DataSupplierArticleNumber = "314 715 0013") OR (aa.SupplierID = 134 AND aa.DataSupplierArticleNumber = "BM-SB-15100") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "821919") OR (aa.SupplierID = 135 AND aa.DataSupplierArticleNumber = "821918") OR (aa.SupplierID = 151 AND aa.DataSupplierArticleNumber = "20 94 9386") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "502 948") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V20-2799") OR (aa.SupplierID = 162 AND aa.DataSupplierArticleNumber = "V20-2963") ) AND aa.Language = "ru" Продажа автозапчастей типа Детали крепежа для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
FEBI BILSTEIN 49386 Опора, стабилизатор
MAPCO 38634 Опора, стабилизатор
38621 Опора, стабилизатор
MEYLE 314 715 0012 Опора, стабилизатор
314 715 0013 Опора, стабилизатор
MOOG BM-SB-15100 Опора, стабилизатор
SIDEM 821919 Опора, стабилизатор
821918 Опора, стабилизатор
SWAG 20 94 9386 Опора, стабилизатор
TOPRAN 502 948 Опора, стабилизатор
VAICO V20-2799 Опора, стабилизатор
V20-2963 Опора, стабилизатор
2026 CATCAR.INFO (v 2.0)