SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active` FROM `catalog_category_entity` AS `e` INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '46') AND `at_is_active_default`.`store_id` = 0 LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '46') AND (`at_is_active`.`store_id` = 100) WHERE (`e`.`entity_id` IN('1460', '1511', '1513', '1517')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') LAWN MOWER AIR FILTER - TRACTOR & MOWER REPL. PARTS - LAWN & GARDEN TRACTORS - LAWN AND GARDEN
  1. See Detail

LAWN MOWER AIR FILTER


View as Grid List

23 items

Page
per page
Set Descending Direction
  1. BRIGGS AND STRATTON AIR FILTERS
    $3.55 /EA
    334326 B&S 27987 AIR FILTER Learn More
  2. REPLACEMENT AIR FILTER
    $3.89 /EA
    334339 AIR FILTER TECUMSEH/SEARS Learn More
  3. TECUMSEH AIR FILTER
    $5.69 /EA
    334370 AIR FILTER TECUMSETH Learn More
  4. AIR FILTER/PRE-FILTER
    $14.65 /EA
    334360 AIR FILTER/PREFILTER BRIGGS Learn More
  5. AIR FILTER/PRE FILTER
    $8.75 /EA
    334365 AIR FILTER/PREFILTER B&S Learn More
  6. AIR FILTER/PRE FILTER BRIGGS & STRATTON
    $13.05 /EA
    334319 AIR FILTER/PREFILTER BRIGGS Learn More
  7. AIR FILTER FOR BRIGGS & STRATTON
    $12.65 /EA
    334374 AIR FILTER FOR BRIGGS Learn More
  8. BRIGGS & STRATTON FILTER AND PREFILTER
    $16.95 /EA
    334393 AIR/PRE FILTER KOHLER Learn More
  9. KOHLER AIR FILTER / PRE FILTER
    $14.25 /EA
    334390 AIR/PRE FILTER BRIGGS/STRATT Learn More
View as Grid List

23 items

Page
per page
Set Descending Direction