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', '2826', '2894', '2903')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') DOUBLE ENDED DRIVE TIP BITS - ELECTRIC SCREWDRIVERS & BITS - POWER DRILLS AND SCREWDRIVERS - HAND & POWER TOOLS
  1. See Detail

DOUBLE ENDED DRIVE TIP BITS


View as Grid List

31 items

Page
per page
Set Descending Direction
  1. 3 PC DOUBLE SIDED BITSET
    $4.89 /EA
    3532993C #1PH6-8/#2PH8-10/#3PH10-12 Learn More
  2. IMPACT DOUBLE END 3 PIECE MIX PHILLIPS SET
    $10.99 /EA
    1882352 IMP DBL END 3PC MIX PH Learn More
  3. IMPACT DOUBLE END 3 PIECE MIX SQUARE
    $10.99 /EA
    1882353 IMP DBL END 3PC MIX SQ Learn More
  4. IMPACT DOUBLE END 3 PIECE MIX SET
    $11.99 /EA
    1903509 IMP DBL END 3PC MIX Learn More
  5. IMPACT DOUBLE END 4 PIECE MIX SET
    $12.99 /EA
    1903513 IMP DBL END 4PC MIX Learn More
  6. IMPACT DOUBLE END 4 PIECE MIX SET
    $12.99 /EA
    1903514 IMP DBL END 4PC MIX Learn More
  7. IMPACT DOUBLE END BIT
    $8.49 /EA
    1870982 IMP DBL END #1PHL 2-3/8" Learn More
  8. IMPACT DOUBLE END BIT
    $8.49 /EA
    1870988 IMP DBL END #3SQ#2PH 2-3/8 Learn More
  9. IMPACT DOUBLE END BIT
    $8.49 /EA
    1870983 IMP DBL END #2PHL 2-3/8 Learn More
View as Grid List

31 items

Page
per page
Set Descending Direction