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` = 90) WHERE (`e`.`entity_id` IN('1977', '2106', '2107', '2109')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') BARREL FAN - ELEC. FANS - ELECTRIC HOME COMFORT APPLIANCES - HOUSEWARE & HOUSEHOLD SUPPLIES
  1. See Detail

BARREL FAN


View as Grid List

10 items

Page
per page
Set Descending Direction
  1. DIRECT DRIVE FAN Call for Price
    10380 30"DIRECT DRIVE FAN Learn More
  2. 42" BELT DRIVE DRUM FAN Call for Price
    BF42BD RED 42" BELT DRIVE Learn More
  3. 24" ROLL AROUND TILT FAN Call for Price
    BF24TF YEL 24' ROLL-AROUND Learn More
  4. MINI AIR MOVER Call for Price
    1032000 MINI AIR MOVER Learn More
  5. 2 SPEED TILT FAN Call for Price
    18289/10289 TILT FAN Learn More
  6. DRUM FAN Call for Price
    DR42 42" H/DUTY BELT DRUM F Learn More
  7. DIRECT DRIVE BARREL FAN Call for Price
    BF30DD RED 30" D/DRIVE BARR Learn More
  8. UTILITY BLOWER Call for Price
    CZBU80 FAN 8" HV UTL BLOWER Learn More
  9. BELT DRIVE FAN Call for Price
    10242 42"BELT DRIVE FAN Learn More
View as Grid List

10 items

Page
per page
Set Descending Direction