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', '1484', '1485', '1486')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') BRUSH HOOKS DOUBLE EDGED AXE DITCH BANK BLADES - WEED & BUSH CUTTERS - GRASS & WEED TOOLS - LAWN AND GARDEN
  1. See Detail

BRUSH HOOKS DOUBLE EDGED AXE DITCH BANK BLADES


View as Grid List

9 Items

per page
Set Descending Direction
  1. LIGHT DITCH BANK BLADE Call for Price
    62222/2316500 LIGHT DITCH BANK BLAD Learn More
  2. DITCH BANK BLADE Call for Price
    640C DITCH BANK BLADE(3 BOLT) Learn More
  3. SINGLE EDGE BUSH HOOK Call for Price
    122-C SGL EDGR BUSH HOOK Learn More
  4. DOUBLE EDGE BUSH HOOK Call for Price
    212 DOUBLE EDGE BUSH HOOK Learn More
  5. DOUBLE EDGE DITCH BANK BLADE Call for Price
    1230 12" DBL EDGE BANK BLD Learn More
  6. DITCH BLANK BLADE Call for Price
    1436 14" DITCH BANK BLADE Learn More
  7. HEAVYWEIGHT DITCH BANK BLADE Call for Price
    62223/2316600 DITCH BANK BLADE 40" Learn More
  8. DITCH BANK BLADE Call for Price
    87640 DT-1640 DITCH BANK BL Learn More
  9. CLEARING HOOK Call for Price
    385071-1002 CLEARING HOOK 9" Learn More
View as Grid List

9 Items

per page
Set Descending Direction