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 = '505' 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 17:34:43 [updated_at] => 2018-01-10 17:06:29 [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 17:34:44 [updated_at] => 2018-01-10 17:07:16 [visibility] => 4 [status] => 1 [cat_index_position] => 2 )[2] => 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 17:53:49 [updated_at] => 2017-12-19 11:28:13 [visibility] => 4 [status] => 1 [cat_index_position] => 3 )[3] => 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 17:34:46 [updated_at] => 2018-01-10 17:07:51 [visibility] => 4 [status] => 1 [cat_index_position] => 4 )[4] => 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 17:34:47 [updated_at] => 2018-01-10 20:16:30 [visibility] => 4 [status] => 1 [cat_index_position] => 5 ))

Process Equipment and Systems (5)

  • 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. Sentinel uses a unique ?process plant? approach when designing our systems and approaching our projects. Suitability of the equipment for the application, pressure, temperature, operator safety, and comfort are just some of the considerations used by our engineers.
  • Hybrid Process Glass Reactors

    Standard Features

    Includes reactor systems that incorporate Process Glassware and Hastelloy, Glass Lined Steel or other Exotic Alloys.
  • 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.