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` = 90) WHERE (`e`.`entity_id` IN('1460', '1535', '1536', '1537')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') LEAF BLOWER ELECTRIC - POWER LAWN & OUTDOOR SWEEPER - SPECIAL PURPOSE LAWN/GARDEN EQUI - LAWN AND GARDEN
  1. See Detail

LEAF BLOWER ELECTRIC


View as Grid List

4 Items

per page
Set Descending Direction
  1. WORX® TRIVAC BLOWER/MULCHER/VACUUM Call for Price
    WG505 TRIVAC BLOWR/MULCH/VAC 12A Learn More
  2. 12 AMP BLOWER Call for Price
    BV3600 12AMP BLOWER VAC Learn More
  3. MIGHTY PRO BLOWER Call for Price
    PS07424 MIGHTY PRO BLOWER Learn More
  4. GARAGE SHOP BLOWER Call for Price
    W50063 GARAGE/ SHOP BLOWER Learn More
View as Grid List

4 Items

per page
Set Descending Direction