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', '2244', '2245')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') WEATHER THERM.& INSTRUMENTS - THERMOMETERS/WEATHER INSTRUMENTS - HOUSEWARE & HOUSEHOLD SUPPLIES
  1. See Detail

WEATHER THERM.& INSTRUMENTS


View as Grid List

55 items

Page
per page
Set Descending Direction
  1. 12' FRYER THERMOMETER Call for Price
    B50A6 12" FRYER THERMOMETER Learn More
  2. JUMBO RAIN GUAGE Call for Price
    2704 JUMBO RAIN GUAGE Learn More
  3. GLASS RAIN GUAGE Call for Price
    2710N GLASS RAIN GUAGE Learn More
  4. JUMBO WALL THERMOMETER Call for Price
    5109 THERMOMETER JUMBO WALL Learn More
  5. WALL THERMOMETER Call for Price
    5135N THERMOMETER WALL Learn More
  6. WALL THERMOMETER CONTEMPORARY Call for Price
    5153/5154 THERMOMETER WALL Learn More
  7. WINDOW THERMOMETER Call for Price
    5316N THERMOMETER WINDOW Learn More
  8. THERMOMETER Call for Price
    5321N THERMOMETER Learn More
  9. INDOOR OUTDOOR THERMOMETER CONTEMPORARY Call for Price
    5379 THERMOMETER INDOOR/OUTDOOR Learn More
View as Grid List

55 items

Page
per page
Set Descending Direction