#216.73.216.162 catalog.avtoformula.ru/totalcatalog/?l=YnJhbmRfaWQ9PTUxMXx8bW9kZWxfaWQ9PTU0MzB8fG1kZl9pZD09MF4yNTQ3OHx8c3BhcmVfaWQ9PTEwMDA0OA%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 = "25478" AND ( (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "9200-48260" AND av.ProductID IN (3922)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "9200-49880" AND av.ProductID IN (3922,3922,3922,3922,3922,3922,3922)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "9200-49842" AND av.ProductID IN (3922)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "9200-49414" AND av.ProductID IN (3922)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "9200-49138" AND av.ProductID IN (3922)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "9200-48456" AND av.ProductID IN (3922)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "9200-49462" AND av.ProductID IN (3922)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "9200-49268" AND av.ProductID IN (3922)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "9200-48490" AND av.ProductID IN (3922)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "9200-50036" AND av.ProductID IN (3922)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "9200-49680" AND av.ProductID IN (3922)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "9200-49380" AND av.ProductID IN (3922)) OR (av.SupplierID = 442 AND av.DataSupplierArticleNumber = "9200-48814" AND av.ProductID IN (3922)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "0 258 017 110" AND av.ProductID IN (3922)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "0 258 017 098" AND av.ProductID IN (3922)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "0 258 986 602" AND av.ProductID IN (3922)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "0 258 017 099" AND av.ProductID IN (3922)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "0 258 010 413" AND av.ProductID IN (3922)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "0 258 017 100" AND av.ProductID IN (3922)) OR (av.SupplierID = 30 AND av.DataSupplierArticleNumber = "0 258 010 414" AND av.ProductID IN (3922)) OR (av.SupplierID = 215 AND av.DataSupplierArticleNumber = "LS140548" AND av.ProductID IN (3922)) OR (av.SupplierID = 215 AND av.DataSupplierArticleNumber = "LS140696" AND av.ProductID IN (3922)) OR (av.SupplierID = 215 AND av.DataSupplierArticleNumber = "LS150014" AND av.ProductID IN (3922)) OR (av.SupplierID = 89 AND av.DataSupplierArticleNumber = "ES20173-11B1" AND av.ProductID IN (3922)) OR (av.SupplierID = 66 AND av.DataSupplierArticleNumber = "DOX-2026" AND av.ProductID IN (3922)) OR (av.SupplierID = 66 AND av.DataSupplierArticleNumber = "DOX-2046" AND av.ProductID IN (3922)) OR (av.SupplierID = 66 AND av.DataSupplierArticleNumber = "DOX-0150" AND av.ProductID IN (3922)) OR (av.SupplierID = 4005 AND av.DataSupplierArticleNumber = "1.998.328" AND av.ProductID IN (3922)) OR (av.SupplierID = 4005 AND av.DataSupplierArticleNumber = "1.998.325" AND av.ProductID IN (3922)) OR (av.SupplierID = 4969 AND av.DataSupplierArticleNumber = "09SKV905" AND av.ProductID IN (3922)) OR (av.SupplierID = 4969 AND av.DataSupplierArticleNumber = "09SKV909" AND av.ProductID IN (3922)) OR (av.SupplierID = 159 AND av.DataSupplierArticleNumber = "10.8325" AND av.ProductID IN (3922)) OR (av.SupplierID = 159 AND av.DataSupplierArticleNumber = "10.8328" AND av.ProductID IN (3922)) OR (av.SupplierID = 240 AND av.DataSupplierArticleNumber = "77442" AND av.ProductID IN (3922)) OR (av.SupplierID = 240 AND av.DataSupplierArticleNumber = "75056" AND av.ProductID IN (3922)) OR (av.SupplierID = 240 AND av.DataSupplierArticleNumber = "77443" AND av.ProductID IN (3922)) OR (av.SupplierID = 240 AND av.DataSupplierArticleNumber = "75075" AND av.ProductID IN (3922)) OR (av.SupplierID = 240 AND av.DataSupplierArticleNumber = "75079" AND av.ProductID IN (3922)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "90245" AND av.ProductID IN (3922)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "90335" AND av.ProductID IN (3922,3922,3922,3922,3922,3922,3922)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "90284OQ" AND av.ProductID IN (3922,3922,3922,3922,3922,3922,3922)) OR (av.SupplierID = 441 AND av.DataSupplierArticleNumber = "90284" AND av.ProductID IN (3922)) OR (av.SupplierID = 341 AND av.DataSupplierArticleNumber = "7481633" AND av.ProductID IN (3922)) OR (av.SupplierID = 341 AND av.DataSupplierArticleNumber = "7481668" AND av.ProductID IN (3922)) OR (av.SupplierID = 341 AND av.DataSupplierArticleNumber = "7481736" AND av.ProductID IN (3922)) OR (av.SupplierID = 4006 AND av.DataSupplierArticleNumber = "498 325" AND av.ProductID IN (3922)) OR (av.SupplierID = 4006 AND av.DataSupplierArticleNumber = "498 328" AND av.ProductID IN (3922)) OR (av.SupplierID = 244 AND av.DataSupplierArticleNumber = "81668" AND av.ProductID IN (3922)) OR (av.SupplierID = 244 AND av.DataSupplierArticleNumber = "81736" AND av.ProductID IN (3922)) OR (av.SupplierID = 244 AND av.DataSupplierArticleNumber = "81633" AND av.ProductID IN (3922)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "0893083" AND av.ProductID IN (3922)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "0893243" AND av.ProductID IN (3922)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "0893368" AND av.ProductID IN (3922)) OR (av.SupplierID = 94 AND av.DataSupplierArticleNumber = "0893027" AND av.ProductID IN (3922)) OR (av.SupplierID = 440 AND av.DataSupplierArticleNumber = "DOX-0150" AND av.ProductID IN (3922,3922,3922,3922,3922,3922,3922)) OR (av.SupplierID = 440 AND av.DataSupplierArticleNumber = "DOX-2026" AND av.ProductID IN (3922)) OR (av.SupplierID = 440 AND av.DataSupplierArticleNumber = "DOX-2046" AND av.ProductID IN (3922)) OR (av.SupplierID = 5 AND av.DataSupplierArticleNumber = "7.02604.42.0" AND av.ProductID IN (3922)) OR (av.SupplierID = 5 AND av.DataSupplierArticleNumber = "7.02604.26.0" AND av.ProductID IN (3922)) OR (av.SupplierID = 5 AND av.DataSupplierArticleNumber = "7.02604.34.0" AND av.ProductID IN (3922)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "90284OQ" AND av.ProductID IN (3922,3922,3922,3922,3922,3922,3922)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "90335" AND av.ProductID IN (3922,3922,3922,3922,3922,3922,3922)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "90245" AND av.ProductID IN (3922)) OR (av.SupplierID = 27 AND av.DataSupplierArticleNumber = "90284" AND av.ProductID IN (3922)) OR (av.SupplierID = 4595 AND av.DataSupplierArticleNumber = "20-00022-SX" AND av.ProductID IN (3922)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8845 11027" AND av.ProductID IN (3922)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8845 11014" AND av.ProductID IN (3922)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8845 11017" AND av.ProductID IN (3922)) OR (av.SupplierID = 108 AND av.DataSupplierArticleNumber = "8845 11022" AND av.ProductID IN (3922)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V20-76-0059" AND av.ProductID IN (3922,3922,3922,3922,3922,3922,3922)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V45-76-0011" AND av.ProductID IN (3922,3922,3922,3922,3922,3922,3922)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V20-76-0050" AND av.ProductID IN (3922)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V20-76-0067" AND av.ProductID IN (3922,3922,3922,3922,3922,3922,3922)) OR (av.SupplierID = 183 AND av.DataSupplierArticleNumber = "V99-76-0002" AND av.ProductID IN (3922)) OR (av.SupplierID = 303 AND av.DataSupplierArticleNumber = "250-24713" AND av.ProductID IN (3922)) OR (av.SupplierID = 303 AND av.DataSupplierArticleNumber = "250-25018" AND av.ProductID IN (3922)) OR (av.SupplierID = 303 AND av.DataSupplierArticleNumber = "250-25046" AND av.ProductID IN (3922)) OR (av.SupplierID = 303 AND av.DataSupplierArticleNumber = "250-24465" AND av.ProductID IN (3922)) OR (av.SupplierID = 303 AND av.DataSupplierArticleNumber = "250-25047" AND av.ProductID IN (3922)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1461223" AND av.ProductID IN (3922,3922,3922,3922,3922,3922,3922)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1029104" AND av.ProductID IN (3922)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1025977" AND av.ProductID IN (3922)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1029120" AND av.ProductID IN (3922)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1025985" AND av.ProductID IN (3922)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1013955" AND av.ProductID IN (3922)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1146120" AND av.ProductID IN (3922)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1025993" AND av.ProductID IN (3922)) OR (av.SupplierID = 4832 AND av.DataSupplierArticleNumber = "WG1014012" AND av.ProductID IN (3922)) ) 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 = 442 AND aa.DataSupplierArticleNumber = "9200-48260") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-49880") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-49842") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-49414") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-49138") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-48456") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-49462") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-49268") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-48490") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-50036") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-49680") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-49380") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-48814") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 258 017 110") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 258 017 098") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 258 986 602") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 258 017 099") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 258 010 413") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 258 017 100") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 258 010 414") OR (aa.SupplierID = 215 AND aa.DataSupplierArticleNumber = "LS140548") OR (aa.SupplierID = 215 AND aa.DataSupplierArticleNumber = "LS140696") OR (aa.SupplierID = 215 AND aa.DataSupplierArticleNumber = "LS150014") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "ES20173-11B1") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DOX-2026") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DOX-2046") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DOX-0150") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.998.328") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.998.325") OR (aa.SupplierID = 4969 AND aa.DataSupplierArticleNumber = "09SKV905") OR (aa.SupplierID = 4969 AND aa.DataSupplierArticleNumber = "09SKV909") OR (aa.SupplierID = 159 AND aa.DataSupplierArticleNumber = "10.8325") OR (aa.SupplierID = 159 AND aa.DataSupplierArticleNumber = "10.8328") OR (aa.SupplierID = 240 AND aa.DataSupplierArticleNumber = "77442") OR (aa.SupplierID = 240 AND aa.DataSupplierArticleNumber = "75056") OR (aa.SupplierID = 240 AND aa.DataSupplierArticleNumber = "77443") OR (aa.SupplierID = 240 AND aa.DataSupplierArticleNumber = "75075") OR (aa.SupplierID = 240 AND aa.DataSupplierArticleNumber = "75079") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "90245") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "90335") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "90284OQ") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "90284") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "7481633") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "7481668") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "7481736") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "498 325") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "498 328") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "81668") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "81736") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "81633") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0893083") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0893243") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0893368") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0893027") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "DOX-0150") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "DOX-2026") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "DOX-2046") OR (aa.SupplierID = 5 AND aa.DataSupplierArticleNumber = "7.02604.42.0") OR (aa.SupplierID = 5 AND aa.DataSupplierArticleNumber = "7.02604.26.0") OR (aa.SupplierID = 5 AND aa.DataSupplierArticleNumber = "7.02604.34.0") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "90284OQ") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "90335") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "90245") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "90284") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "20-00022-SX") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8845 11027") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8845 11014") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8845 11017") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8845 11022") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V20-76-0059") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V45-76-0011") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V20-76-0050") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V20-76-0067") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-76-0002") OR (aa.SupplierID = 303 AND aa.DataSupplierArticleNumber = "250-24713") OR (aa.SupplierID = 303 AND aa.DataSupplierArticleNumber = "250-25018") OR (aa.SupplierID = 303 AND aa.DataSupplierArticleNumber = "250-25046") OR (aa.SupplierID = 303 AND aa.DataSupplierArticleNumber = "250-24465") OR (aa.SupplierID = 303 AND aa.DataSupplierArticleNumber = "250-25047") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1461223") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1029104") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1025977") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1029120") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1025985") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1013955") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1146120") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1025993") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1014012") ) 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 = 442 AND aa.DataSupplierArticleNumber = "9200-48260") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-49880") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-49842") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-49414") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-49138") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-48456") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-49462") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-49268") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-48490") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-50036") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-49680") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-49380") OR (aa.SupplierID = 442 AND aa.DataSupplierArticleNumber = "9200-48814") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 258 017 110") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 258 017 098") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 258 986 602") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 258 017 099") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 258 010 413") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 258 017 100") OR (aa.SupplierID = 30 AND aa.DataSupplierArticleNumber = "0 258 010 414") OR (aa.SupplierID = 215 AND aa.DataSupplierArticleNumber = "LS140548") OR (aa.SupplierID = 215 AND aa.DataSupplierArticleNumber = "LS140696") OR (aa.SupplierID = 215 AND aa.DataSupplierArticleNumber = "LS150014") OR (aa.SupplierID = 89 AND aa.DataSupplierArticleNumber = "ES20173-11B1") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DOX-2026") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DOX-2046") OR (aa.SupplierID = 66 AND aa.DataSupplierArticleNumber = "DOX-0150") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.998.328") OR (aa.SupplierID = 4005 AND aa.DataSupplierArticleNumber = "1.998.325") OR (aa.SupplierID = 4969 AND aa.DataSupplierArticleNumber = "09SKV905") OR (aa.SupplierID = 4969 AND aa.DataSupplierArticleNumber = "09SKV909") OR (aa.SupplierID = 159 AND aa.DataSupplierArticleNumber = "10.8325") OR (aa.SupplierID = 159 AND aa.DataSupplierArticleNumber = "10.8328") OR (aa.SupplierID = 240 AND aa.DataSupplierArticleNumber = "77442") OR (aa.SupplierID = 240 AND aa.DataSupplierArticleNumber = "75056") OR (aa.SupplierID = 240 AND aa.DataSupplierArticleNumber = "77443") OR (aa.SupplierID = 240 AND aa.DataSupplierArticleNumber = "75075") OR (aa.SupplierID = 240 AND aa.DataSupplierArticleNumber = "75079") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "90245") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "90335") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "90284OQ") OR (aa.SupplierID = 441 AND aa.DataSupplierArticleNumber = "90284") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "7481633") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "7481668") OR (aa.SupplierID = 341 AND aa.DataSupplierArticleNumber = "7481736") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "498 325") OR (aa.SupplierID = 4006 AND aa.DataSupplierArticleNumber = "498 328") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "81668") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "81736") OR (aa.SupplierID = 244 AND aa.DataSupplierArticleNumber = "81633") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0893083") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0893243") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0893368") OR (aa.SupplierID = 94 AND aa.DataSupplierArticleNumber = "0893027") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "DOX-0150") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "DOX-2026") OR (aa.SupplierID = 440 AND aa.DataSupplierArticleNumber = "DOX-2046") OR (aa.SupplierID = 5 AND aa.DataSupplierArticleNumber = "7.02604.42.0") OR (aa.SupplierID = 5 AND aa.DataSupplierArticleNumber = "7.02604.26.0") OR (aa.SupplierID = 5 AND aa.DataSupplierArticleNumber = "7.02604.34.0") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "90284OQ") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "90335") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "90245") OR (aa.SupplierID = 27 AND aa.DataSupplierArticleNumber = "90284") OR (aa.SupplierID = 4595 AND aa.DataSupplierArticleNumber = "20-00022-SX") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8845 11027") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8845 11014") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8845 11017") OR (aa.SupplierID = 108 AND aa.DataSupplierArticleNumber = "8845 11022") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V20-76-0059") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V45-76-0011") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V20-76-0050") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V20-76-0067") OR (aa.SupplierID = 183 AND aa.DataSupplierArticleNumber = "V99-76-0002") OR (aa.SupplierID = 303 AND aa.DataSupplierArticleNumber = "250-24713") OR (aa.SupplierID = 303 AND aa.DataSupplierArticleNumber = "250-25018") OR (aa.SupplierID = 303 AND aa.DataSupplierArticleNumber = "250-25046") OR (aa.SupplierID = 303 AND aa.DataSupplierArticleNumber = "250-24465") OR (aa.SupplierID = 303 AND aa.DataSupplierArticleNumber = "250-25047") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1461223") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1029104") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1025977") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1029120") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1025985") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1013955") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1146120") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1025993") OR (aa.SupplierID = 4832 AND aa.DataSupplierArticleNumber = "WG1014012") ) AND aa.Language = "ru" Продажа автозапчастей типа Лямбда-зонд для автомобилей

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

Поиск по производителям:
Производители
Артикул
Наименование
Сведения
Полная информация
ASHUKI 9200-48260 Лямбда-зонд
9200-49880 Лямбда-зонд
9200-49842 Лямбда-зонд
9200-49414 Лямбда-зонд
9200-49138 Лямбда-зонд
9200-48456 Лямбда-зонд
9200-49462 Лямбда-зонд
9200-49268 Лямбда-зонд
9200-48490 Лямбда-зонд
9200-50036 Лямбда-зонд
9200-49680 Лямбда-зонд
9200-49380 Лямбда-зонд
9200-48814 Лямбда-зонд
BOSCH 0 258 017 110 Лямбда-зонд
0 258 017 098 Лямбда-зонд
0 258 986 602 Лямбда-зонд
0 258 017 099 Лямбда-зонд
0 258 010 413 Лямбда-зонд
0 258 017 100 Лямбда-зонд
0 258 010 414 Лямбда-зонд
CALORSTAT by Vernet LS140548 Лямбда-зонд
LS140696 Лямбда-зонд
LS150014 Лямбда-зонд
DELPHI ES20173-11B1 Лямбда-зонд
DENSO DOX-2026 Лямбда-зонд
DOX-2046 Лямбда-зонд
DOX-0150 Лямбда-зонд
EPS 1.998.328 Лямбда-зонд
1.998.325 Лямбда-зонд
ESEN SKV 09SKV905 Лямбда-зонд
09SKV909 Лямбда-зонд
FACET 10.8325 Лямбда-зонд
10.8328 Лямбда-зонд
FAE 77442 Лямбда-зонд
75056 Лямбда-зонд
77443 Лямбда-зонд
75075 Лямбда-зонд
75079 Лямбда-зонд
FISPA 90245 Лямбда-зонд
90335 Лямбда-зонд
90284OQ Лямбда-зонд
90284 Лямбда-зонд
HOFFER 7481633 Лямбда-зонд
7481668 Лямбда-зонд
7481736 Лямбда-зонд
KW 498 325 Лямбда-зонд
498 328 Лямбда-зонд
MEAT & DORIA 81668 Лямбда-зонд
81736 Лямбда-зонд
81633 Лямбда-зонд
METZGER 0893083 Лямбда-зонд
0893243 Лямбда-зонд
0893368 Лямбда-зонд
0893027 Лямбда-зонд
NPS DOX-0150 Лямбда-зонд
DOX-2026 Лямбда-зонд
DOX-2046 Лямбда-зонд
PIERBURG 7.02604.42.0 Лямбда-зонд
7.02604.26.0 Лямбда-зонд
7.02604.34.0 Лямбда-зонд
SIDAT 90284OQ Лямбда-зонд
90335 Лямбда-зонд
90245 Лямбда-зонд
90284 Лямбда-зонд
STELLOX 20-00022-SX Лямбда-зонд
TRISCAN 8845 11027 Лямбда-зонд
8845 11014 Лямбда-зонд
8845 11017 Лямбда-зонд
8845 11022 Лямбда-зонд
VEMO V20-76-0059 Лямбда-зонд
V45-76-0011 Лямбда-зонд
V20-76-0050 Лямбда-зонд
V20-76-0067 Лямбда-зонд
V99-76-0002 Лямбда-зонд
WALKER PRODUCTS 250-24713 Лямбда-зонд
250-25018 Лямбда-зонд
250-25046 Лямбда-зонд
250-24465 Лямбда-зонд
250-25047 Лямбда-зонд
WILMINK GROUP WG1461223 Лямбда-зонд
WG1029104 Лямбда-зонд
WG1025977 Лямбда-зонд
WG1029120 Лямбда-зонд
WG1025985 Лямбда-зонд
WG1013955 Лямбда-зонд
WG1146120 Лямбда-зонд
WG1025993 Лямбда-зонд
WG1014012 Лямбда-зонд
2026 CATCAR.INFO (v 2.0)