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` = 95) WHERE (`e`.`entity_id` IN('2465', '2470', '2487')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') SLEDGE & MAULS - HAMMERS AND MALLETS - HAND & POWER TOOLS
  1. See Detail

SLEDGE & MAULS


View as Grid List

35 items

Page
per page
Set Descending Direction
  1. True American Sledgehammer
    $42.49 /EA
    1113091700 12#SLEDGE T-AMERICAN Learn More
  2. SLEDGE HAMMER WITH FIBERGLASS HANDLE
    $59.99 /EA
    1199800/30569 16LB SLDG FBRGLS HDL Learn More
  3. SLEDGE HAMMER
    $25.99 /EA
    1197400 6LB SLEDGE HICKORY HNDL Learn More
  4. SLEDGE HAMMER
    $31.99 /EA
    1197900 8LB SLEDGE HICKORY HNDL Learn More
  5. SLEDGE HAMMER
    $38.49 /EA
    1199100 10LB SLEDGE HICKORY HNDL Learn More
  6. SLEDGE HAMMER
    $44.49 /EA
    1199400/30584 12LB DBL FACE SLEDGE Learn More
  7. LICKETY SPLITTER
    $57.49 /EA
    1113090800 LICKETY SPLIT12# Learn More
  8. SPLITTING MAUL
    $29.99 /EA
    41589 SM-6P SPLIT MAUL 6# Learn More
  9. SLEDGE EYE MAUL
    $41.49 /EA
    41582 SM-8 SLEDGE EYE MAUL Learn More
View as Grid List

35 items

Page
per page
Set Descending Direction