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', '1613', '1615', '1620')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') HANDLES AXE - REPL. HANDLES,STRIKING TOOLS - REPLACEMENT HANDLES - LAWN AND GARDEN
  1. See Detail

HANDLES AXE


View as Grid List

16 items

Page
per page
Set Descending Direction
  1. SINGLE BIT HICKORY AXE HANDLES Call for Price
    64707/100-09 36" BNT SNGL BT AXE HD Learn More
  2. DOUBLE BIT AXE HANDLES Call for Price
    64743/140-09 36" DOUBLE BIT AXE HND Learn More
  3. SINGLE BIT CURVED AXE HANDLE Call for Price
    64702/100-04 36" SNGL BIT CURVED AX Learn More
  4. AXE HANDLE DOUBLE BIT Call for Price
    64740 140-08 AXE HND DBLBIT 36" Learn More
  5. SINGLE BIT HICKORY AXE HANDLES Call for Price
    64914/116-08 28" BOYS AXE HANDLE Learn More
  6. BOY SCOUT AXE HANDLE Call for Price
    65300/368-19 14" BOY SCOUT AXE HNDL Learn More
  7. AXE HANDLE Call for Price
    64774 206-08 AX HND SB WOOD Learn More
  8. SINGLE BIT HICKORY AXE HANDLES Call for Price
    64731/119-19 36" STRAIGHT AXE HANDL Learn More
  9. DOUBLE BIT AXE HANDLES Call for Price
    64946/145-09 28" CRUISERS DB AXE HD Learn More
View as Grid List

16 items

Page
per page
Set Descending Direction