#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTU1MXx8bW9kZWxfaWQ9PTM1Mzl8fG1kZl9pZD09MV4xMjAwMHx8c3BhcmVfaWQ9PTIwMDc3NQ%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 articlecommercialvehicles av JOIN commercialvehiclelinkageattributes_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 = "12000" AND ( (av.SupplierID = 228 AND av.DataSupplierArticleNumber = "1470" AND av.ProductID IN (424)) OR (av.SupplierID = 228 AND av.DataSupplierArticleNumber = "470" AND av.ProductID IN (424)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "1 987 432 151" AND av.ProductID IN (424)) OR (av.SupplierID = 4702 AND av.DataSupplierArticleNumber = "BS02-009" AND av.ProductID IN (424)) OR (av.SupplierID = 163 AND av.DataSupplierArticleNumber = "NC2043" AND av.ProductID IN (424)) OR (av.SupplierID = 66 AND av.DataSupplierArticleNumber = "DCF132P" AND av.ProductID IN (424)) OR (av.SupplierID = 101 AND av.DataSupplierArticleNumber = "09443" AND av.ProductID IN (424)) OR (av.SupplierID = 4659 AND av.DataSupplierArticleNumber = "HC 7081" AND av.ProductID IN (424)) OR (av.SupplierID = 256 AND av.DataSupplierArticleNumber = "K1041" AND av.ProductID IN (424)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "070" AND av.ProductID IN (424)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "138" AND av.ProductID IN (424)) OR (av.SupplierID = 81 AND av.DataSupplierArticleNumber = "E906LI" AND av.ProductID IN (424)) OR (av.SupplierID = 341 AND av.DataSupplierArticleNumber = "17201" AND av.ProductID IN (424)) OR (av.SupplierID = 341 AND av.DataSupplierArticleNumber = "17396" AND av.ProductID IN (424)) OR (av.SupplierID = 34 AND av.DataSupplierArticleNumber = "LA 67" AND av.ProductID IN (424)) OR (av.SupplierID = 287 AND av.DataSupplierArticleNumber = "LA 67" AND av.ProductID IN (424)) OR (av.SupplierID = 4 AND av.DataSupplierArticleNumber = "CU 40 110" AND av.ProductID IN (424)) OR (av.SupplierID = 244 AND av.DataSupplierArticleNumber = "17396" AND av.ProductID IN (424)) OR (av.SupplierID = 244 AND av.DataSupplierArticleNumber = "17201" AND av.ProductID IN (424)) OR (av.SupplierID = 218 AND av.DataSupplierArticleNumber = "ELR7525" AND av.ProductID IN (424)) OR (av.SupplierID = 462 AND av.DataSupplierArticleNumber = "K 953" AND av.ProductID IN (424)) OR (av.SupplierID = 462 AND av.DataSupplierArticleNumber = "K 953C" AND av.ProductID IN (424)) OR (av.SupplierID = 4470 AND av.DataSupplierArticleNumber = "HB147" AND av.ProductID IN (424)) OR (av.SupplierID = 4623 AND av.DataSupplierArticleNumber = "022.305" AND av.ProductID IN (424)) OR (av.SupplierID = 225 AND av.DataSupplierArticleNumber = "SA 1121" AND av.ProductID IN (424)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "138" AND av.ProductID IN (424)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "070" AND av.ProductID IN (424)) OR (av.SupplierID = 4768 AND av.DataSupplierArticleNumber = "P906" AND av.ProductID IN (424)) OR (av.SupplierID = 142 AND av.DataSupplierArticleNumber = "S 3053 C" AND av.ProductID IN (424)) OR (av.SupplierID = 92 AND av.DataSupplierArticleNumber = "PC8039" AND av.ProductID IN (424)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "87-11802-SX" AND av.ProductID IN (424)) OR (av.SupplierID = 137 AND av.DataSupplierArticleNumber = "53.053.00" AND av.ProductID IN (424)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V34-30-2006" AND av.ProductID IN (424)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1215498" AND av.ProductID IN (424)) OR (av.SupplierID = 324 AND av.DataSupplierArticleNumber = "93116E" AND av.ProductID IN (424)) OR (av.SupplierID = 499 AND av.DataSupplierArticleNumber = "Z021" AND av.ProductID IN (424)) OR (av.SupplierID = 499 AND av.DataSupplierArticleNumber = "ZF021" AND av.ProductID IN (424)) ) 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 = 228 AND aa.DataSupplierArticleNumber = "1470") OR (aa.SupplierID = 228 AND aa.DataSupplierArticleNumber = "470") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "1 987 432 151") OR (aa.SupplierID = 4702 AND aa.DataSupplierArticleNumber = "BS02-009") OR (aa.SupplierID = 163 AND aa.DataSupplierArticleNumber = "NC2043") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DCF132P") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "09443") OR (aa.SupplierID = 4659 AND aa.DataSupplierArticleNumber = "HC 7081") OR (aa.SupplierID = 256 AND aa.DataSupplierArticleNumber = "K1041") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "070") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "138") OR (aa.SupplierID = 81 AND aa.DataSupplierArticleNumber = "E906LI") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "17201") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "17396") OR (aa.SupplierID = 34 AND aa.DataSupplierArticleNumber = "LA 67") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "LA 67") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "CU 40 110") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "17396") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "17201") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "ELR7525") OR (aa.SupplierID = 462 AND aa.DataSupplierArticleNumber = "K 953") OR (aa.SupplierID = 462 AND aa.DataSupplierArticleNumber = "K 953C") OR (aa.SupplierID = 4470 AND aa.DataSupplierArticleNumber = "HB147") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "022.305") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "SA 1121") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "138") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "070") OR (aa.SupplierID = 4768 AND aa.DataSupplierArticleNumber = "P906") OR (aa.SupplierID = 142 AND aa.DataSupplierArticleNumber = "S 3053 C") OR (aa.SupplierID = 92 AND aa.DataSupplierArticleNumber = "PC8039") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "87-11802-SX") OR (aa.SupplierID = 137 AND aa.DataSupplierArticleNumber = "53.053.00") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V34-30-2006") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1215498") OR (aa.SupplierID = 324 AND aa.DataSupplierArticleNumber = "93116E") OR (aa.SupplierID = 499 AND aa.DataSupplierArticleNumber = "Z021") OR (aa.SupplierID = 499 AND aa.DataSupplierArticleNumber = "ZF021") ) 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 = 228 AND aa.DataSupplierArticleNumber = "1470") OR (aa.SupplierID = 228 AND aa.DataSupplierArticleNumber = "470") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "1 987 432 151") OR (aa.SupplierID = 4702 AND aa.DataSupplierArticleNumber = "BS02-009") OR (aa.SupplierID = 163 AND aa.DataSupplierArticleNumber = "NC2043") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DCF132P") OR (aa.SupplierID = 101 AND aa.DataSupplierArticleNumber = "09443") OR (aa.SupplierID = 4659 AND aa.DataSupplierArticleNumber = "HC 7081") OR (aa.SupplierID = 256 AND aa.DataSupplierArticleNumber = "K1041") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "070") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "138") OR (aa.SupplierID = 81 AND aa.DataSupplierArticleNumber = "E906LI") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "17201") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "17396") OR (aa.SupplierID = 34 AND aa.DataSupplierArticleNumber = "LA 67") OR (aa.SupplierID = 287 AND aa.DataSupplierArticleNumber = "LA 67") OR (aa.SupplierID = 4 AND aa.DataSupplierArticleNumber = "CU 40 110") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "17396") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "17201") OR (aa.SupplierID = 218 AND aa.DataSupplierArticleNumber = "ELR7525") OR (aa.SupplierID = 462 AND aa.DataSupplierArticleNumber = "K 953") OR (aa.SupplierID = 462 AND aa.DataSupplierArticleNumber = "K 953C") OR (aa.SupplierID = 4470 AND aa.DataSupplierArticleNumber = "HB147") OR (aa.SupplierID = 4623 AND aa.DataSupplierArticleNumber = "022.305") OR (aa.SupplierID = 225 AND aa.DataSupplierArticleNumber = "SA 1121") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "138") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "070") OR (aa.SupplierID = 4768 AND aa.DataSupplierArticleNumber = "P906") OR (aa.SupplierID = 142 AND aa.DataSupplierArticleNumber = "S 3053 C") OR (aa.SupplierID = 92 AND aa.DataSupplierArticleNumber = "PC8039") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "87-11802-SX") OR (aa.SupplierID = 137 AND aa.DataSupplierArticleNumber = "53.053.00") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V34-30-2006") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1215498") OR (aa.SupplierID = 324 AND aa.DataSupplierArticleNumber = "93116E") OR (aa.SupplierID = 499 AND aa.DataSupplierArticleNumber = "Z021") OR (aa.SupplierID = 499 AND aa.DataSupplierArticleNumber = "ZF021") ) AND aa.Language = "ru" Продажа автозапчастей типа Фильтр салона для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
3F QUALITY 1470 Фильтр, воздух во внутренном пространстве
470 Фильтр, воздух во внутренном пространстве
BOSCH 1 987 432 151 Фильтр, воздух во внутренном пространстве
BOSS FILTERS BS02-009 Фильтр, воздух во внутренном пространстве
CLEAN FILTERS NC2043 Фильтр, воздух во внутренном пространстве
DENSO DCF132P Фильтр, воздух во внутренном пространстве
FEBI BILSTEIN 09443 Фильтр, воздух во внутренном пространстве
FIL FILTER HC 7081 Фильтр, воздух во внутренном пространстве
FILTRON K1041 Фильтр, воздух во внутренном пространстве
FISPA 070 Фильтр, воздух во внутренном пространстве
138 Фильтр, воздух во внутренном пространстве
HENGST FILTER E906LI Фильтр, воздух во внутренном пространстве
HOFFER 17201 Фильтр, воздух во внутренном пространстве
17396 Фильтр, воздух во внутренном пространстве
KNECHT LA 67 Фильтр, воздух во внутренном пространстве
MAHLE ORIGINAL LA 67 Фильтр, воздух во внутренном пространстве
MANN-FILTER CU 40 110 Фильтр, воздух во внутренном пространстве
MEAT & DORIA 17396 Фильтр, воздух во внутренном пространстве
17201 Фильтр, воздух во внутренном пространстве
MECAFILTER ELR7525 Фильтр, воздух во внутренном пространстве
MFILTER K 953 Фильтр, воздух во внутренном пространстве
K 953C Фильтр, воздух во внутренном пространстве
MISFAT HB147 Фильтр, воздух во внутренном пространстве
SAMPA 022.305 Фильтр, воздух во внутренном пространстве
SCT Germany SA 1121 Фильтр, воздух во внутренном пространстве
SIDAT 138 Фильтр, воздух во внутренном пространстве
070 Фильтр, воздух во внутренном пространстве
SIVENTO P906 Фильтр, воздух во внутренном пространстве
SOFIMA S 3053 C Фильтр, воздух во внутренном пространстве
SogefiPro PC8039 Фильтр, воздух во внутренном пространстве
STELLOX 87-11802-SX Фильтр, воздух во внутренном пространстве
UFI 53.053.00 Фильтр, воздух во внутренном пространстве
VEMO V34-30-2006 Фильтр, воздух во внутренном пространстве
WILMINK GROUP WG1215498 Фильтр, воздух во внутренном пространстве
WIX FILTERS 93116E Фильтр, воздух во внутренном пространстве
ZAFFO Z021 Фильтр, воздух во внутренном пространстве
ZF021 Фильтр, воздух во внутренном пространстве
2026 CATCAR.INFO (v 2.0)