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` = 100) WHERE (`e`.`entity_id` IN('4881')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') ELECTRICAL SUPPLIES
  1. See Detail

ELECTRICAL SUPPLIES


View as Grid List

4015 items

Page
per page
Set Descending Direction
  1. MODULAR 3 WAY IN-LINE ADAPTER
    $2.65 /EA
    TS1001SPL2A PHONE SPLITTER AL Learn More
  2. CABLE WIRE CUTTER
    $56.95 /EA
    910 9" CABLE/WIRE CUTTER Learn More
  3. BANANA TAP INDOOR EXTENSION CORD
    $8.75 /EA
    608 8'16/3 EXT CORD BRN Learn More
  4. NON-METALLIC SNAP IN CONNECTOR
    $0.39 /EA
    457 1/2" NONMETALIC CONNECT Learn More
  5. DOVER SERIES CEILING FIXTURE
    $46.39 /EA
    104289 CEILING LIGHT 2LT DO Learn More
  6. 90° SCHEDULE 80 ELBOW
    $3.45 /EA
    5121054U 3/4" 90D ELBOW Learn More
  7. DIGITAL WIRELESS RECORDING SYSTEM
    $561.95 /EA
    DWS-472 2CAM.RECORD SYSTEM Learn More
  8. 2 POLE CIRCUIT BREAKER
    $15.65 /EA
    THQP220 20 DP BREAKER Learn More
  9. 20V MAX LED FLASHLIGHT
    $77.05 /EA
    DCL040 20VMAX LED FLASHLITE Learn More
View as Grid List

4015 items

Page
per page
Set Descending Direction