#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU2MXx8bW9kZWxfaWQ9PTE0NTR8fG1kZl9pZD09MF4xNTMwNHx8c3BhcmVfaWQ9PTEwMDM1OA%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 = "15304" AND ( (av.SupplierID = 4654 AND av.DataSupplierArticleNumber = "121016" AND av.ProductID IN (183)) OR (av.SupplierID = 4654 AND av.DataSupplierArticleNumber = "121128" AND av.ProductID IN (183)) OR (av.SupplierID = 80 AND av.DataSupplierArticleNumber = "840200N" AND av.ProductID IN (183)) OR (av.SupplierID = 247 AND av.DataSupplierArticleNumber = "OL1347" AND av.ProductID IN (183)) OR (av.SupplierID = 105 AND av.DataSupplierArticleNumber = "8UW 351 239-391" AND av.ProductID IN (183)) OR (av.SupplierID = 4553 AND av.DataSupplierArticleNumber = "1212070" AND av.ProductID IN (183)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "TSP0585017" AND av.ProductID IN (183)) OR (av.SupplierID = 66 AND av.DataSupplierArticleNumber = "DVE20003" AND av.ProductID IN (183)) OR (av.SupplierID = 66 AND av.DataSupplierArticleNumber = "DVE20004" AND av.ProductID IN (183)) OR (av.SupplierID = 66 AND av.DataSupplierArticleNumber = "DVE20001" AND av.ProductID IN (183)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "DCE1060" AND av.ProductID IN (183)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "4.2010" AND av.ProductID IN (183)) OR (av.SupplierID = 313 AND av.DataSupplierArticleNumber = "431.30989" AND av.ProductID IN (2408)) OR (av.SupplierID = 4819 AND av.DataSupplierArticleNumber = "260552" AND av.ProductID IN (183)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "8UW 351 239-391" AND av.ProductID IN (183)) OR (av.SupplierID = 341 AND av.DataSupplierArticleNumber = "K42010" AND av.ProductID IN (183)) OR (av.SupplierID = 244 AND av.DataSupplierArticleNumber = "K42010" AND av.ProductID IN (183)) OR (av.SupplierID = 440 AND av.DataSupplierArticleNumber = "DVE20004" AND av.ProductID IN (183)) OR (av.SupplierID = 440 AND av.DataSupplierArticleNumber = "DVE20001" AND av.ProductID IN (183)) OR (av.SupplierID = 440 AND av.DataSupplierArticleNumber = "DVE20003" AND av.ProductID IN (183)) OR (av.SupplierID = 205 AND av.DataSupplierArticleNumber = "38375" AND av.ProductID IN (183)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "4.2010" AND av.ProductID IN (183)) OR (av.SupplierID = 4466 AND av.DataSupplierArticleNumber = "KTT140018" AND av.ProductID IN (183)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "508650" AND av.ProductID IN (183)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "37001347" AND av.ProductID IN (183)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V40-77-0008" AND av.ProductID IN (183)) ) 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 = 4654 AND aa.DataSupplierArticleNumber = "121016") OR (aa.SupplierID = 4654 AND aa.DataSupplierArticleNumber = "121128") OR (aa.SupplierID = 80 AND aa.DataSupplierArticleNumber = "840200N") OR (aa.SupplierID = 247 AND aa.DataSupplierArticleNumber = "OL1347") OR (aa.SupplierID = 105 AND aa.DataSupplierArticleNumber = "8UW 351 239-391") OR (aa.SupplierID = 4553 AND aa.DataSupplierArticleNumber = "1212070") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TSP0585017") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DVE20003") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DVE20004") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DVE20001") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "DCE1060") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "4.2010") OR (aa.SupplierID = 313 AND aa.DataSupplierArticleNumber = "431.30989") OR (aa.SupplierID = 4819 AND aa.DataSupplierArticleNumber = "260552") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8UW 351 239-391") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "K42010") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "K42010") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "DVE20004") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "DVE20001") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "DVE20003") OR (aa.SupplierID = 205 AND aa.DataSupplierArticleNumber = "38375") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "4.2010") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "KTT140018") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "508650") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "37001347") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V40-77-0008") ) 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 = 4654 AND aa.DataSupplierArticleNumber = "121016") OR (aa.SupplierID = 4654 AND aa.DataSupplierArticleNumber = "121128") OR (aa.SupplierID = 80 AND aa.DataSupplierArticleNumber = "840200N") OR (aa.SupplierID = 247 AND aa.DataSupplierArticleNumber = "OL1347") OR (aa.SupplierID = 105 AND aa.DataSupplierArticleNumber = "8UW 351 239-391") OR (aa.SupplierID = 4553 AND aa.DataSupplierArticleNumber = "1212070") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TSP0585017") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DVE20003") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DVE20004") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DVE20001") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "DCE1060") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "4.2010") OR (aa.SupplierID = 313 AND aa.DataSupplierArticleNumber = "431.30989") OR (aa.SupplierID = 4819 AND aa.DataSupplierArticleNumber = "260552") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8UW 351 239-391") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "K42010") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "K42010") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "DVE20004") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "DVE20001") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "DVE20003") OR (aa.SupplierID = 205 AND aa.DataSupplierArticleNumber = "38375") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "4.2010") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "KTT140018") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "508650") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "37001347") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V40-77-0008") ) AND aa.Language = "ru" Продажа автозапчастей типа Клапаны для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
ACR 121016 Расширительный клапан, кондиционер
121128 Расширительный клапан, кондиционер
AKS DASIS 840200N Расширительный клапан, кондиционер
AVA QUALITY COOLING OL1347 Расширительный клапан, кондиционер
BEHR HELLA SERVICE 8UW 351 239-391 Расширительный клапан, кондиционер
CTR 1212070 Расширительный клапан, кондиционер
DELPHI TSP0585017 Расширительный клапан, кондиционер
DENSO DVE20003 Расширительный клапан, кондиционер
DVE20004 Расширительный клапан, кондиционер
DVE20001 Расширительный клапан, кондиционер
DIEDERICHS DCE1060 Расширительный клапан, кондиционер
FISPA 4.2010 Расширительный клапан, кондиционер
FRIGAIR 431.30989 Форсунка, расширительный клапан
HC-Cargo 260552 Расширительный клапан, кондиционер
HELLA 8UW 351 239-391 Расширительный клапан, кондиционер
HOFFER K42010 Расширительный клапан, кондиционер
MEAT & DORIA K42010 Расширительный клапан, кондиционер
NPS DVE20004 Расширительный клапан, кондиционер
DVE20001 Расширительный клапан, кондиционер
DVE20003 Расширительный клапан, кондиционер
NRF 38375 Расширительный клапан, кондиционер
SIDAT 4.2010 Расширительный клапан, кондиционер
THERMOTEC KTT140018 Расширительный клапан, кондиционер
VALEO 508650 Расширительный клапан, кондиционер
VAN WEZEL 37001347 Расширительный клапан, кондиционер
VEMO V40-77-0008 Расширительный клапан, кондиционер
2026 CATCAR.INFO (v 2.0)