SELECT `e`.*, IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) AS `visibility`, IF(at_status.value_id > 0, at_status.value, at_status_default.value) AS `status`, `cat_index`.`position` AS `cat_index_position` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_entity_int` AS `at_visibility_default` ON (`at_visibility_default`.`entity_id` = `e`.`entity_id`) AND (`at_visibility_default`.`attribute_id` = '102') AND `at_visibility_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_int` AS `at_visibility` ON (`at_visibility`.`entity_id` = `e`.`entity_id`) AND (`at_visibility`.`attribute_id` = '102') AND (`at_visibility`.`store_id` = 1) INNER JOIN `catalog_product_entity_int` AS `at_status_default` ON (`at_status_default`.`entity_id` = `e`.`entity_id`) AND (`at_status_default`.`attribute_id` = '96') AND `at_status_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '96') AND (`at_status`.`store_id` = 1) INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.category_id = '519' AND cat_index.is_parent=1 WHERE (IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) = '4') AND (IF(at_status.value_id > 0, at_status.value, at_status_default.value) = '1') AND (type_id = 'grouped' OR (type_id = 'simple' AND `e`.entity_id NOT IN (SELECT child_id FROM catalog_product_relation WHERE 1))) ORDER BY `cat_index`.`position` ASC LIMIT 100Array ( [0] => Array ( [entity_id] => 112014 [entity_type_id] => 4 [attribute_set_id] => 14 [type_id] => grouped [sku] => Conducell [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 10:33:00 [updated_at] => 2018-01-05 12:14:26 [visibility] => 4 [status] => 1 [cat_index_position] => 1 )[1] => Array ( [entity_id] => 112029 [entity_type_id] => 4 [attribute_set_id] => 14 [type_id] => grouped [sku] => EasyFerm-Plus-ORP [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 10:33:17 [updated_at] => 2018-01-05 12:15:08 [visibility] => 4 [status] => 1 [cat_index_position] => 2 )[2] => Array ( [entity_id] => 112022 [entity_type_id] => 4 [attribute_set_id] => 14 [type_id] => grouped [sku] => Polilyte-Plus-ORP [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 10:33:10 [updated_at] => 2018-01-05 12:14:56 [visibility] => 4 [status] => 1 [cat_index_position] => 3 )[3] => Array ( [entity_id] => 112033 [entity_type_id] => 4 [attribute_set_id] => 14 [type_id] => simple [sku] => 238433 [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 10:33:21 [updated_at] => 2018-01-05 12:15:25 [visibility] => 4 [status] => 1 [cat_index_position] => 4 )[4] => Array ( [entity_id] => 112039 [entity_type_id] => 4 [attribute_set_id] => 14 [type_id] => grouped [sku] => Polyplast-ORP [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 10:33:28 [updated_at] => 2018-01-05 12:15:27 [visibility] => 4 [status] => 1 [cat_index_position] => 5 )[5] => Array ( [entity_id] => 112038 [entity_type_id] => 4 [attribute_set_id] => 14 [type_id] => simple [sku] => 238523 [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 10:33:26 [updated_at] => 2018-01-05 12:15:33 [visibility] => 4 [status] => 1 [cat_index_position] => 6 )[6] => Array ( [entity_id] => 112034 [entity_type_id] => 4 [attribute_set_id] => 14 [type_id] => grouped [sku] => ChemoTrode-ORP [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 10:33:22 [updated_at] => 2018-01-05 12:15:19 [visibility] => 4 [status] => 1 [cat_index_position] => 7 )[7] => Array ( [entity_id] => 112032 [entity_type_id] => 4 [attribute_set_id] => 14 [type_id] => simple [sku] => 238810 [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 10:33:20 [updated_at] => 2018-01-05 12:15:23 [visibility] => 4 [status] => 1 [cat_index_position] => 8 ))

Hamilton ORP & Conductivity Sensors (8)

  • Conducell (20)

    Standard Features

    Hamilton Conductivity Sensors
  • EasyFerm Plus ORP (6)

    Standard Features

    Hamilton EasyFerm Plus; Oxygen-Reduction Potential Sensors; for Demanding Applications in the Pharmaceutical and Chemcial Industries
  • Polilyte Plus ORP (7)

    Standard Features

    Hamilton Polilyte Plus; Oxygen-Reduction Potential Sensors; for Demanding Applications in the Chemical and Petrochemical Industries
  • Polilyte RX 120 ORP

    Standard Features

    Hamilton Polilyte RX; Oxygen-Reduction Potential Sensor; for Water Applications and Low Conductivity Samples
  • Polyplast ORP (3)

    Standard Features

    Hamilton Polyplast; Oxygen-Reduction Potential Sensors; for Measurement in Water and Sewage
  • EasyControl 120 ORP

    Standard Features

    Hamilton EasyControl; Oxygen-Reduction Potential Sensor; for Chemical or Wastewater Applications and Low Process Temperatures
  • ChemoTrode ORP (2)

    Standard Features

    Hamilton ChemoTrode; Oxygen-Reduction Potential Sensors; Robust Design for Measurement in Pharmaceutical and Chemical Applications
  • OxyTrode ORP Pt 120

    Standard Features

    Hamilton OxyTrode; Oxygen-Reduction Potential Sensor; for Chemical and Wastewater Treatment Applications