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` = 122) WHERE (`e`.`entity_id` IN('2465', '2685', '2686', '2697')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') PRECISION POCKET SCREWDRIVERS AND FILES SETS - SCREWDRIVERS & SETS - SCREWDRIVERS AND HAND DRILLS - HAND & POWER TOOLS
  1. See Detail

PRECISION POCKET SCREWDRIVERS AND FILES SETS


View as Grid List

18 items

Page
per page
Set Descending Direction
  1. 8 IN 1 PRECISION SCREWDRIVER SET
    $6.99 /EA
    80040 8N1 PRECISION SCREWDRVR SET Learn More
  2. POCKET SCREWDRIVER
    $3.49 /EA
    66-344 4-N-1 POCKET SCWDRVR Learn More
  3. 18PC PRECISION ULTRATECH SCREWDRIVER SET
    $27.49 /EA
    63518 18PC PREC ULTRATECH SD SET Learn More
  4. PROFESSIONAL PRECISION SCREWDRIVER SET
    $18.49 /EA
    SD-5A 5PC PREC SCRWDRVR SET Learn More
  5. 4PC PRECISION BLADE PROBE SET
    $11.49 /EA
    60004 4PC PRECISION BLD PROBE SET Learn More
  6. 5 IN 1 MULTI BLADE PRECISION SCREWDRIVER
    $10.49 /EA
    735 5N1 MULTI-BLD PREC SCRWDRV Learn More
  7. 22 PIECE SCREWDRIVER SET
    $13.49 /EA
    92089B 22PC SCREWDRIVER SET Learn More
  8. PROBE & HOOK SET
    $10.49 /EA
    862 3PC PROBE & HOOK SET Learn More
  9. 6 PC PRECISION SCREWDRIVER SET
    $16.99 /EA
    SDPS6 SCRWDRVR SET 6PC PREC Learn More
View as Grid List

18 items

Page
per page
Set Descending Direction