#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2Nnx8bW9kZWxfaWQ9PTM1MDh8fG1kZl9pZD09MF4xNjEwOXx8c3BhcmVfaWQ9PTEwMDY5MQ%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 = "16109" AND ( (av.SupplierID = 4849 AND av.DataSupplierArticleNumber = "44.4506" AND av.ProductID IN (1373,1373)) OR (av.SupplierID = 4849 AND av.DataSupplierArticleNumber = "41.4200" AND av.ProductID IN (1373,1373)) OR (av.SupplierID = 4849 AND av.DataSupplierArticleNumber = "44.4507" AND av.ProductID IN (1373,1373)) OR (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "6010-09-030401P" AND av.ProductID IN (1373)) OR (av.SupplierID = 4555 AND av.DataSupplierArticleNumber = "6010-09-030402P" AND av.ProductID IN (1373)) OR (av.SupplierID = 4603 AND av.DataSupplierArticleNumber = "AL8092002" AND av.ProductID IN (1373)) OR (av.SupplierID = 4719 AND av.DataSupplierArticleNumber = "AL8092002" AND av.ProductID IN (1373)) OR (av.SupplierID = 4721 AND av.DataSupplierArticleNumber = "80.920.02" AND av.ProductID IN (1373)) OR (av.SupplierID = 4720 AND av.DataSupplierArticleNumber = "AL8092002" AND av.ProductID IN (1373)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "RN0268508" AND av.ProductID IN (1373)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "RN0268407" AND av.ProductID IN (1373)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "OP9328502" AND av.ProductID IN (1373)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "OP9328401" AND av.ProductID IN (1373)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "RN0268408" AND av.ProductID IN (1373)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "RN0268401" AND av.ProductID IN (1373)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "OP9328402" AND av.ProductID IN (1373)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "RN0268507" AND av.ProductID IN (1373)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "RN0268402" AND av.ProductID IN (1373)) OR (av.SupplierID = 340 AND av.DataSupplierArticleNumber = "OP9328501" AND av.ProductID IN (1373)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "700 559" AND av.ProductID IN (1373)) OR (av.SupplierID = 301 AND av.DataSupplierArticleNumber = "700 558" AND av.ProductID IN (1373)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "125003" AND av.ProductID IN (1373)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "125000" AND av.ProductID IN (1373)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "125001" AND av.ProductID IN (1373)) OR (av.SupplierID = 4970 AND av.DataSupplierArticleNumber = "125002" AND av.ProductID IN (1373)) ) 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 = "44.4506") OR (aa.SupplierID = 4849 AND aa.DataSupplierArticleNumber = "41.4200") OR (aa.SupplierID = 4849 AND aa.DataSupplierArticleNumber = "44.4507") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6010-09-030401P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6010-09-030402P") OR (aa.SupplierID = 4603 AND aa.DataSupplierArticleNumber = "AL8092002") OR (aa.SupplierID = 4719 AND aa.DataSupplierArticleNumber = "AL8092002") OR (aa.SupplierID = 4721 AND aa.DataSupplierArticleNumber = "80.920.02") OR (aa.SupplierID = 4720 AND aa.DataSupplierArticleNumber = "AL8092002") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "RN0268508") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "RN0268407") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "OP9328502") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "OP9328401") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "RN0268408") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "RN0268401") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "OP9328402") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "RN0268507") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "RN0268402") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "OP9328501") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "700 559") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "700 558") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "125003") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "125000") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "125001") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "125002") ) 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 = "44.4506") OR (aa.SupplierID = 4849 AND aa.DataSupplierArticleNumber = "41.4200") OR (aa.SupplierID = 4849 AND aa.DataSupplierArticleNumber = "44.4507") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6010-09-030401P") OR (aa.SupplierID = 4555 AND aa.DataSupplierArticleNumber = "6010-09-030402P") OR (aa.SupplierID = 4603 AND aa.DataSupplierArticleNumber = "AL8092002") OR (aa.SupplierID = 4719 AND aa.DataSupplierArticleNumber = "AL8092002") OR (aa.SupplierID = 4721 AND aa.DataSupplierArticleNumber = "80.920.02") OR (aa.SupplierID = 4720 AND aa.DataSupplierArticleNumber = "AL8092002") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "RN0268508") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "RN0268407") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "OP9328502") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "OP9328401") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "RN0268408") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "RN0268401") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "OP9328402") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "RN0268507") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "RN0268402") OR (aa.SupplierID = 340 AND aa.DataSupplierArticleNumber = "OP9328501") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "700 559") OR (aa.SupplierID = 301 AND aa.DataSupplierArticleNumber = "700 558") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "125003") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "125000") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "125001") OR (aa.SupplierID = 4970 AND aa.DataSupplierArticleNumber = "125002") ) AND aa.Language = "ru" Продажа автозапчастей типа Ручки для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
Ac Rolcar 44.4506 Ручка двери
41.4200 Ручка двери
44.4507 Ручка двери
BLIC 6010-09-030401P Ручка двери
6010-09-030402P Ручка двери
ELECTRIC LIFE AL8092002 Ручка двери
LIFT-TEK AL8092002 Ручка двери
MIRAGLIO 80.920.02 Ручка двери
PMM AL8092002 Ручка двери
PRASCO RN0268508 Ручка двери
RN0268407 Ручка двери
OP9328502 Ручка двери
OP9328401 Ручка двери
RN0268408 Ручка двери
RN0268401 Ручка двери
OP9328402 Ручка двери
RN0268507 Ручка двери
RN0268402 Ручка двери
OP9328501 Ручка двери
TOPRAN 700 559 Ручка двери
700 558 Ручка двери
TRICLO 125003 Ручка двери
125000 Ручка двери
125001 Ручка двери
125002 Ручка двери
2026 CATCAR.INFO (v 2.0)