#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU3NXx8bW9kZWxfaWQ9PTQzODN8fG1kZl9pZD09MF4xMzM2NHx8c3BhcmVfaWQ9PTEwMDM1OA%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 = "13364" AND ( (av.SupplierID = 4654 AND av.DataSupplierArticleNumber = "121059" AND av.ProductID IN (183)) OR (av.SupplierID = 80 AND av.DataSupplierArticleNumber = "840980N" AND av.ProductID IN (183)) OR (av.SupplierID = 80 AND av.DataSupplierArticleNumber = "840065N" AND av.ProductID IN (183)) OR (av.SupplierID = 247 AND av.DataSupplierArticleNumber = "VW1243" AND av.ProductID IN (183)) OR (av.SupplierID = 105 AND av.DataSupplierArticleNumber = "8UW 351 234-161" AND av.ProductID IN (183)) OR (av.SupplierID = 4553 AND av.DataSupplierArticleNumber = "1212180" AND av.ProductID IN (183)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "TSP0585065" AND av.ProductID IN (183)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "DCE1094" AND av.ProductID IN (183)) OR (av.SupplierID = 253 AND av.DataSupplierArticleNumber = "DCE1095" AND av.ProductID IN (183)) OR (av.SupplierID = 234 AND av.DataSupplierArticleNumber = "669009" AND av.ProductID IN (183)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "4.2026" AND av.ProductID IN (183)) OR (av.SupplierID = 313 AND av.DataSupplierArticleNumber = "431.30130" AND av.ProductID IN (2408)) OR (av.SupplierID = 4819 AND av.DataSupplierArticleNumber = "260225" AND av.ProductID IN (183)) OR (av.SupplierID = 2 AND av.DataSupplierArticleNumber = "8UW 351 234-161" AND av.ProductID IN (183)) OR (av.SupplierID = 341 AND av.DataSupplierArticleNumber = "K42026" AND av.ProductID IN (183)) OR (av.SupplierID = 292 AND av.DataSupplierArticleNumber = "VAL011" AND av.ProductID IN (183)) OR (av.SupplierID = 244 AND av.DataSupplierArticleNumber = "K42026" AND av.ProductID IN (183)) OR (av.SupplierID = 205 AND av.DataSupplierArticleNumber = "38368" AND av.ProductID IN (183)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "4.2026" AND av.ProductID IN (183)) OR (av.SupplierID = 4466 AND av.DataSupplierArticleNumber = "KTT140009" AND av.ProductID IN (183)) OR (av.SupplierID = 21 AND av.DataSupplierArticleNumber = "509682" AND av.ProductID IN (183)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "58001243" AND av.ProductID IN (183)) OR (av.SupplierID = 36 AND av.DataSupplierArticleNumber = "58001311" AND av.ProductID IN (183)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V15-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 = "121059") OR (aa.SupplierID = 80 AND aa.DataSupplierArticleNumber = "840980N") OR (aa.SupplierID = 80 AND aa.DataSupplierArticleNumber = "840065N") OR (aa.SupplierID = 247 AND aa.DataSupplierArticleNumber = "VW1243") OR (aa.SupplierID = 105 AND aa.DataSupplierArticleNumber = "8UW 351 234-161") OR (aa.SupplierID = 4553 AND aa.DataSupplierArticleNumber = "1212180") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TSP0585065") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "DCE1094") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "DCE1095") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "669009") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "4.2026") OR (aa.SupplierID = 313 AND aa.DataSupplierArticleNumber = "431.30130") OR (aa.SupplierID = 4819 AND aa.DataSupplierArticleNumber = "260225") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8UW 351 234-161") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "K42026") OR (aa.SupplierID = 292 AND aa.DataSupplierArticleNumber = "VAL011") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "K42026") OR (aa.SupplierID = 205 AND aa.DataSupplierArticleNumber = "38368") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "4.2026") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "KTT140009") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "509682") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "58001243") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "58001311") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-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 = "121059") OR (aa.SupplierID = 80 AND aa.DataSupplierArticleNumber = "840980N") OR (aa.SupplierID = 80 AND aa.DataSupplierArticleNumber = "840065N") OR (aa.SupplierID = 247 AND aa.DataSupplierArticleNumber = "VW1243") OR (aa.SupplierID = 105 AND aa.DataSupplierArticleNumber = "8UW 351 234-161") OR (aa.SupplierID = 4553 AND aa.DataSupplierArticleNumber = "1212180") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "TSP0585065") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "DCE1094") OR (aa.SupplierID = 253 AND aa.DataSupplierArticleNumber = "DCE1095") OR (aa.SupplierID = 234 AND aa.DataSupplierArticleNumber = "669009") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "4.2026") OR (aa.SupplierID = 313 AND aa.DataSupplierArticleNumber = "431.30130") OR (aa.SupplierID = 4819 AND aa.DataSupplierArticleNumber = "260225") OR (aa.SupplierID = 2 AND aa.DataSupplierArticleNumber = "8UW 351 234-161") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "K42026") OR (aa.SupplierID = 292 AND aa.DataSupplierArticleNumber = "VAL011") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "K42026") OR (aa.SupplierID = 205 AND aa.DataSupplierArticleNumber = "38368") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "4.2026") OR (aa.SupplierID = 4466 AND aa.DataSupplierArticleNumber = "KTT140009") OR (aa.SupplierID = 21 AND aa.DataSupplierArticleNumber = "509682") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "58001243") OR (aa.SupplierID = 36 AND aa.DataSupplierArticleNumber = "58001311") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V15-77-0008") ) AND aa.Language = "ru" Продажа автозапчастей типа Клапаны для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
ACR 121059 Расширительный клапан, кондиционер
AKS DASIS 840980N Расширительный клапан, кондиционер
840065N Расширительный клапан, кондиционер
AVA QUALITY COOLING VW1243 Расширительный клапан, кондиционер
BEHR HELLA SERVICE 8UW 351 234-161 Расширительный клапан, кондиционер
CTR 1212180 Расширительный клапан, кондиционер
DELPHI TSP0585065 Расширительный клапан, кондиционер
DIEDERICHS DCE1094 Расширительный клапан, кондиционер
DCE1095 Расширительный клапан, кондиционер
ERA 669009 Расширительный клапан, кондиционер
FISPA 4.2026 Расширительный клапан, кондиционер
FRIGAIR 431.30130 Форсунка, расширительный клапан
HC-Cargo 260225 Расширительный клапан, кондиционер
HELLA 8UW 351 234-161 Расширительный клапан, кондиционер
HOFFER K42026 Расширительный клапан, кондиционер
LIZARTE VAL011 Расширительный клапан, кондиционер
MEAT & DORIA K42026 Расширительный клапан, кондиционер
NRF 38368 Расширительный клапан, кондиционер
SIDAT 4.2026 Расширительный клапан, кондиционер
THERMOTEC KTT140009 Расширительный клапан, кондиционер
VALEO 509682 Расширительный клапан, кондиционер
VAN WEZEL 58001243 Расширительный клапан, кондиционер
58001311 Расширительный клапан, кондиционер
VEMO V15-77-0008 Расширительный клапан, кондиционер
2026 CATCAR.INFO (v 2.0)