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 = '517' 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] => 111840 [entity_type_id] => 4 [attribute_set_id] => 14 [type_id] => grouped [sku] => EasyFerm-Plus [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 10:29:48 [updated_at] => 2018-01-05 12:08:11 [visibility] => 4 [status] => 1 [cat_index_position] => 1 )[1] => Array ( [entity_id] => 111754 [entity_type_id] => 4 [attribute_set_id] => 14 [type_id] => grouped [sku] => EasyFerm-Bio [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 10:28:17 [updated_at] => 2018-01-05 12:05:57 [visibility] => 4 [status] => 1 [cat_index_position] => 2 )[2] => Array ( [entity_id] => 111673 [entity_type_id] => 4 [attribute_set_id] => 14 [type_id] => grouped [sku] => Polilyte-Plus [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 10:26:51 [updated_at] => 2018-01-05 12:03:35 [visibility] => 4 [status] => 1 [cat_index_position] => 3 )[3] => Array ( [entity_id] => 111884 [entity_type_id] => 4 [attribute_set_id] => 14 [type_id] => grouped [sku] => Polilyte-PRO [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 10:30:39 [updated_at] => 2018-01-05 12:11:38 [visibility] => 4 [status] => 1 [cat_index_position] => 4 )[4] => Array ( [entity_id] => 111879 [entity_type_id] => 4 [attribute_set_id] => 14 [type_id] => simple [sku] => 238408 [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 10:30:33 [updated_at] => 2018-01-05 12:11:42 [visibility] => 4 [status] => 1 [cat_index_position] => 5 )[5] => Array ( [entity_id] => 111858 [entity_type_id] => 4 [attribute_set_id] => 14 [type_id] => grouped [sku] => ChemoTrode [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 10:30:09 [updated_at] => 2018-01-05 12:10:42 [visibility] => 4 [status] => 1 [cat_index_position] => 6 )[6] => Array ( [entity_id] => 111863 [entity_type_id] => 4 [attribute_set_id] => 14 [type_id] => grouped [sku] => FermoTrode [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 10:30:15 [updated_at] => 2018-01-05 12:11:11 [visibility] => 4 [status] => 1 [cat_index_position] => 7 )[7] => Array ( [entity_id] => 111869 [entity_type_id] => 4 [attribute_set_id] => 14 [type_id] => grouped [sku] => InchTrode [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 10:30:22 [updated_at] => 2018-01-05 12:11:18 [visibility] => 4 [status] => 1 [cat_index_position] => 8 )[8] => Array ( [entity_id] => 111873 [entity_type_id] => 4 [attribute_set_id] => 14 [type_id] => grouped [sku] => MecoTrode [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 10:30:26 [updated_at] => 2018-01-05 12:11:28 [visibility] => 4 [status] => 1 [cat_index_position] => 9 )[9] => Array ( [entity_id] => 111876 [entity_type_id] => 4 [attribute_set_id] => 14 [type_id] => grouped [sku] => OneFerm [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 10:30:30 [updated_at] => 2018-01-05 12:11:34 [visibility] => 4 [status] => 1 [cat_index_position] => 10 )[10] => Array ( [entity_id] => 111880 [entity_type_id] => 4 [attribute_set_id] => 14 [type_id] => simple [sku] => 238525 [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 10:30:35 [updated_at] => 2018-01-05 12:11:44 [visibility] => 4 [status] => 1 [cat_index_position] => 11 )[11] => Array ( [entity_id] => 111881 [entity_type_id] => 4 [attribute_set_id] => 14 [type_id] => simple [sku] => 238940 [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 10:30:36 [updated_at] => 2018-01-05 12:11:45 [visibility] => 4 [status] => 1 [cat_index_position] => 12 )[12] => Array ( [entity_id] => 111882 [entity_type_id] => 4 [attribute_set_id] => 14 [type_id] => simple [sku] => 238515 [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 10:30:37 [updated_at] => 2018-01-05 12:11:47 [visibility] => 4 [status] => 1 [cat_index_position] => 13 )[13] => Array ( [entity_id] => 111883 [entity_type_id] => 4 [attribute_set_id] => 14 [type_id] => simple [sku] => 238522 [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 10:30:38 [updated_at] => 2018-01-05 12:11:48 [visibility] => 4 [status] => 1 [cat_index_position] => 14 )[14] => Array ( [entity_id] => 111888 [entity_type_id] => 4 [attribute_set_id] => 14 [type_id] => grouped [sku] => NovoTrode [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 10:30:43 [updated_at] => 2018-01-05 12:11:50 [visibility] => 4 [status] => 1 [cat_index_position] => 15 )[15] => Array ( [entity_id] => 111923 [entity_type_id] => 4 [attribute_set_id] => 14 [type_id] => grouped [sku] => Laboratory-pH-Sensors [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 10:31:20 [updated_at] => 2018-01-05 12:11:55 [visibility] => 4 [status] => 1 [cat_index_position] => 16 ))

Hamilton pH Sensors (16)

  • EasyFerm Plus (85)

    Standard Features

    Hamilton EasyFerm Plus pH Sensors; for Biotech, Pharmaceutical, and Chemical Applications
  • EasyFerm Bio (80)

    Standard Features

    Hamilton EasyFerm Bio pH Sensors; for Biotech, Pharmaceutical, and Food & Beverage Applications
  • Polilyte Plus (90)

    Standard Features

    Hamilton Polilyte Plus pH Sensors, for Chemical and Wastewater Applications
  • Polilyte PRO (2)

    Standard Features

    Hamilton Polilyte PRO pH Sensors; for Measurement in Water Applications (especially low conductivity)
  • Polyplast PRO

    Standard Features

    Hamilton Polyplast PRO pH Sensor; for Water Applications (especially low conductivity samples)
  • ChemoTrode (17)

    Standard Features

    Hamilton ChemoTrode pH Sensors; Robust for Demanding Applications in the Pharmaceutical and Chemical Industries
  • FermoTrode (4)

    Standard Features

    Hamilton FermoTrode pH Sensors; for Pharmaceutical and Biotech Applications; Fits the MasterFit and RetractoMaster Housings
  • InchTrode (5)

    Standard Features

    Hamilton InchTrode pH Sensors; for Applications in the Chemical and Paper Industries
  • MecoTrode (3)

    Standard Features

    Hamilton MecoTrode pH Sensors; for Applications in the Chemcial Industry with Extreme pH Values
  • OneFerm (2)

    Standard Features

    Hamilton OneFerm pH Sensors; for Precise pH Measurement in Bioreactors or Downstream Skid Applications
  • IonoTrode

    Standard Features

    Hamilton IonoTrode PRO pH Sensor; for Applications in Ion Weak Media
  • Single pH

    Standard Features

    Hamilton Single pH Sensor; for Cooling Water and Flue Gas Washer Applications
  • Loq-Glass PG

    Standard Features

    Hamilton Loq-Glass PG pH Sensor; for Chemical, Wastewater, and Low Process Temperature Applications
  • EasyControl

    Standard Features

    Hamilton EasyControl 120 pH Sensor; for Chemical or Wastewater Applications and Low Process Temperatures
  • NovoTrode (3)

    Standard Features

    Hamilton NovoTrode pH Sensors; for Measurment in Extreme pH Values in the Chemical Industry
  • Laboratory pH Sensors (34)

    Standard Features

    Hamilton Electrodes Designed for pH Measurement in Laboratory Environments