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', '1518')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') SPARK PLUG LAWNMOWER - TRACTOR & MOWER REPL. PARTS - LAWN & GARDEN TRACTORS - LAWN AND GARDEN
  1. See Detail

SPARK PLUG LAWNMOWER


View as Grid List

50 items

Page
per page
Set Descending Direction
  1. CHAMP 843ECO SPARK PLUG
    $7.55 /EA
    33843ECO CHAMP 843ECO SPARK PLUG Learn More
  2. SMALL ENGINE SPARK PLUG
    $7.85 /EA
    E3.10 SM ENGINE SPARK PLUG Learn More
  3. SPARK PLUG FOR RIDING MOWERS
    $3.45 /EA
    334056 SPARKPLUG FOR RIDERS Learn More
  4. SPARK PLUG
    $4.25 /EA
    33BM6FY NGK PRO-V BM6FY S-PLUG Learn More
  5. SPARK PLUG
    $4.25 /EA
    33B4LMY NGK PRO-V B4LMY S-PLUG Learn More
  6. SPARK PLUG
    $4.25 /EA
    33B2LMY NGK PRO-V B2LMY S-PLUG Learn More
  7. SPARK PLUG
    $4.25 /EA
    33BPMR6Y NGK PRO-V BPMR6Y S-PLUG Learn More
  8. SPARK PLUG
    $4.25 /EA
    338BPMR8Y NGK PRO-V BPMR8Y S-PLUG Learn More
  9. SPARK PLUG
    $4.25 /EA
    33BKR5E NGK PRO-V BKR5E S-PLUG Learn More
View as Grid List

50 items

Page
per page
Set Descending Direction