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 = '531' 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] => 111018 [entity_type_id] => 4 [attribute_set_id] => 4 [type_id] => simple [sku] => Sentinel's-Unique-Technologies [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-18 12:34:43 [updated_at] => 2023-02-21 20:28:20 [visibility] => 4 [status] => 1 [cat_index_position] => 1 )[1] => Array ( [entity_id] => 111019 [entity_type_id] => 4 [attribute_set_id] => 4 [type_id] => simple [sku] => Process-Glass-Reactor-Systems [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-18 12:34:44 [updated_at] => 2021-12-13 14:39:36 [visibility] => 4 [status] => 1 [cat_index_position] => 1 )[2] => Array ( [entity_id] => 111020 [entity_type_id] => 4 [attribute_set_id] => 4 [type_id] => simple [sku] => Process-Glass-Filters [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-18 12:34:46 [updated_at] => 2023-02-21 20:18:16 [visibility] => 4 [status] => 1 [cat_index_position] => 1 )[3] => Array ( [entity_id] => 111021 [entity_type_id] => 4 [attribute_set_id] => 4 [type_id] => simple [sku] => Scrubbers [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-18 12:34:47 [updated_at] => 2020-08-13 18:53:53 [visibility] => 4 [status] => 1 [cat_index_position] => 1 )[4] => Array ( [entity_id] => 111050 [entity_type_id] => 4 [attribute_set_id] => 4 [type_id] => simple [sku] => Hybrid-Process-Glass-Reactors [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-18 12:53:49 [updated_at] => 2020-08-13 18:53:03 [visibility] => 4 [status] => 1 [cat_index_position] => 1 ))

Reaction Equipment

For more information on the capabilities and offerings of our reaction equipment please visit our sister site Kilolabs.com

  • Sentinel's Unique Technologies

    Standard Features

    After nearly 60 years helping customers in the Chemical Process industries, Sentinel has developed a variety of unique and cost effective solutions to transition materials, provide easy access and minimize process hold up and cross contamination.
  • Process Glass Reactor Systems

    Standard Features

    Sentinel designs and builds Process Reactors which can be used in a Laboratory or a Production Plant. Suitability of the equipment for the application, pressure, temperature, operator safety, and comfort are just some of the considerations used by our engineers.
  • Process Glass Filters

    Standard Features

    Sentinel can provide your team with a cost effective high visibility separation vessel or process filter. We have units which Tilt/Separate or, are provided with "Clam Shell" tops to effective separate and remove solids.
  • Scrubbers

    Standard Features

    Our units provide a safe and cost effective way to help control process vapors or gases. Sentinel's basic Scrubber Units can be a first step to remove or neutralize those substances harmful to the environment.
  • Hybrid Process Glass Reactors

    Standard Features

    Includes reactor systems that incorporate Process Glassware and Hastelloy, Glass Lined Steel or other Exotic Alloys.