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` = 67) WHERE (`e`.`entity_id` IN('2465', '3131', '3172', '3175')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') TOOL BAGS POUCHES WITH BELT AND BACKPACKS SHOULDER - CRAFTSMAN POUCHES, HOLSTERS & APRONS - CRAFTMAN AIDS - HAND & POWER TOOLS
  1. See Detail

TOOL BAGS POUCHES WITH BELT AND BACKPACKS SHOULDER


View as Grid List

16 items

Page
per page
Set Descending Direction
  1. 12 POCKET CONSTRUCTION WORK APRON
    $48.99 /EA
    527X 12PKT CONST APRON Learn More
  2. PRO ORGANIZER SHOULDER POUCH
    $71.99 /EA
    55419SP-14 PRO ORG SHLDR POUCH Learn More
  3. 53 POCKET TECH BACKPACK
    $139.99 /EA
    L255 53-PKT TECH BACKPACK Learn More
  4. 17 POCKET 4 PIECE TOOL BELT
    $79.49 /EA
    2602 17-PKT 4PC TOOL BELT Learn More
  5. 20 POCKET 4 PIECE TOOL BELT
    $100.99 /EA
    2605 20-PKT 4PC TOOL BELT Learn More
  6. 17 POCKET 4 PIECE TOOL BELT
    $112.99 /EA
    5608XL 17-PKT 4PC TOOL BELT Learn More
  7. 20 POCKET APRON AND SUSPENDERS
    $131.99 /EA
    DG5617 20-PKT COMBO APRON Learn More
  8. 12 POCKET SUEDE APRON
    $58.99 /EA
    DG5372 12-PKT SUEDE APRON Learn More
  9. 31 POCKET 5 PIECE HEAVY DUTY FRAMER'S COMFORT LIFT SYSTEM
    $115.99 /EA
    6714 HD LIFT SYSTEM APRON Learn More
View as Grid List

16 items

Page
per page
Set Descending Direction