100
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 = '504' 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] => 111026 [entity_type_id] => 4 [attribute_set_id] => 4 [type_id] => simple [sku] => Special-Process-Components [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-18 12:53:20 [updated_at] => 2021-12-13 14:25:32 [visibility] => 4 [status] => 1 [cat_index_position] => 1 )[1] => Array ( [entity_id] => 111025 [entity_type_id] => 4 [attribute_set_id] => 4 [type_id] => simple [sku] => Custom-Fabrications [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-18 12:53:19 [updated_at] => 2020-08-14 12:34:25 [visibility] => 4 [status] => 1 [cat_index_position] => 1 )[2] => Array ( [entity_id] => 111012 [entity_type_id] => 4 [attribute_set_id] => 4 [type_id] => simple [sku] => Valve-Fabrications [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-18 12:34:28 [updated_at] => 2020-08-14 12:34:53 [visibility] => 4 [status] => 1 [cat_index_position] => 1 )[3] => Array ( [entity_id] => 114780 [entity_type_id] => 4 [attribute_set_id] => 15 [type_id] => simple [sku] => Clean-Process-Measurement-Fittings [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 07:38:04 [updated_at] => 2017-12-20 07:38:04 [visibility] => 4 [status] => 1 [cat_index_position] => 1 )[4] => Array ( [entity_id] => 114781 [entity_type_id] => 4 [attribute_set_id] => 15 [type_id] => simple [sku] => Life-Sciences-Series-Thermowells [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 07:38:05 [updated_at] => 2018-01-04 08:47:27 [visibility] => 4 [status] => 1 [cat_index_position] => 2 )[5] => Array ( [entity_id] => 114716 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Clamp-Adapter-x-Male-NPT [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:33:09 [updated_at] => 2017-12-20 06:33:09 [visibility] => 4 [status] => 1 [cat_index_position] => 3 )[6] => Array ( [entity_id] => 111222 [entity_type_id] => 4 [attribute_set_id] => 18 [type_id] => grouped [sku] => Clamp-x-MNPT---Adapter [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-19 10:59:36 [updated_at] => 2018-01-19 09:50:09 [visibility] => 4 [status] => 1 [cat_index_position] => 3 )[7] => Array ( [entity_id] => 111315 [entity_type_id] => 4 [attribute_set_id] => 18 [type_id] => grouped [sku] => Clamp-x-FNPT---Adapter [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-19 11:01:21 [updated_at] => 2018-01-19 09:52:33 [visibility] => 4 [status] => 1 [cat_index_position] => 4 )[8] => Array ( [entity_id] => 114749 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Clamp-x-Female-NPT-Adapter [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:33:42 [updated_at] => 2017-12-20 06:33:42 [visibility] => 4 [status] => 1 [cat_index_position] => 4 )[9] => Array ( [entity_id] => 111361 [entity_type_id] => 4 [attribute_set_id] => 18 [type_id] => grouped [sku] => Clamp-x-Clamp---Short-Adaptor [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-19 11:02:08 [updated_at] => 2021-12-13 14:35:24 [visibility] => 4 [status] => 1 [cat_index_position] => 5 )[10] => Array ( [entity_id] => 111398 [entity_type_id] => 4 [attribute_set_id] => 18 [type_id] => grouped [sku] => Clamp-x-Tube [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-19 11:02:47 [updated_at] => 2018-01-19 09:56:05 [visibility] => 4 [status] => 1 [cat_index_position] => 6 )[11] => Array ( [entity_id] => 111420 [entity_type_id] => 4 [attribute_set_id] => 18 [type_id] => grouped [sku] => Tube-x-Tube---Concentric-Reducer [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-19 11:03:10 [updated_at] => 2018-01-19 09:57:04 [visibility] => 4 [status] => 1 [cat_index_position] => 7 )[12] => Array ( [entity_id] => 114026 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Reducer,-Concentric,-Short,-Tube-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:21:51 [updated_at] => 2017-12-20 06:21:51 [visibility] => 4 [status] => 1 [cat_index_position] => 7 )[13] => Array ( [entity_id] => 114069 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Reducer,-Concentric,-Short,-Clamp-and-Tube-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:22:39 [updated_at] => 2017-12-20 06:22:39 [visibility] => 4 [status] => 1 [cat_index_position] => 8 )[14] => Array ( [entity_id] => 114169 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Reducer,-Conical,-Short,-Clamp-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:24:03 [updated_at] => 2018-01-10 14:11:45 [visibility] => 4 [status] => 1 [cat_index_position] => 8 )[15] => Array ( [entity_id] => 111444 [entity_type_id] => 4 [attribute_set_id] => 18 [type_id] => grouped [sku] => Clamp-x-Tube---Concentric-Reducer [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-19 11:03:37 [updated_at] => 2018-01-19 09:57:35 [visibility] => 4 [status] => 1 [cat_index_position] => 8 )[16] => Array ( [entity_id] => 111470 [entity_type_id] => 4 [attribute_set_id] => 18 [type_id] => grouped [sku] => Clamp-x-Clamp---Concentric-Reducer [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-19 11:04:03 [updated_at] => 2018-01-19 09:58:08 [visibility] => 4 [status] => 1 [cat_index_position] => 9 )[17] => Array ( [entity_id] => 114112 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Reducer,-Concentric,-Short,-Clamp-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:23:16 [updated_at] => 2017-12-20 06:23:16 [visibility] => 4 [status] => 1 [cat_index_position] => 9 )[18] => Array ( [entity_id] => 114212 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Reducer,-Eccentric,-Short,-Tube-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:24:39 [updated_at] => 2017-12-20 06:24:39 [visibility] => 4 [status] => 1 [cat_index_position] => 10 )[19] => Array ( [entity_id] => 114255 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Reducer,-Eccentric,-Short,-Clamp-and-Tube-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:25:16 [updated_at] => 2017-12-20 06:25:16 [visibility] => 4 [status] => 1 [cat_index_position] => 11 )[20] => Array ( [entity_id] => 114298 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Reducer,-Eccentric,-Short,-Clamp-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:25:55 [updated_at] => 2017-12-20 06:25:55 [visibility] => 4 [status] => 1 [cat_index_position] => 12 )[21] => Array ( [entity_id] => 111536 [entity_type_id] => 4 [attribute_set_id] => 18 [type_id] => grouped [sku] => Clamp-x-Hose-Barb [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-19 11:05:12 [updated_at] => 2021-12-13 15:14:49 [visibility] => 4 [status] => 1 [cat_index_position] => 13 )[22] => Array ( [entity_id] => 113205 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => 45?-Elbow,-Tube-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:09:19 [updated_at] => 2017-12-20 06:09:19 [visibility] => 4 [status] => 1 [cat_index_position] => 14 )[23] => Array ( [entity_id] => 113228 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => 45?-Elbow,-Clamp-x-Tube-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:09:38 [updated_at] => 2017-12-20 06:09:38 [visibility] => 4 [status] => 1 [cat_index_position] => 15 )[24] => Array ( [entity_id] => 113251 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => 45?-Elbow,-Clamp-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:09:57 [updated_at] => 2017-12-20 06:09:57 [visibility] => 4 [status] => 1 [cat_index_position] => 16 )[25] => Array ( [entity_id] => 113268 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => 88?-Elbow,-Tube-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:10:15 [updated_at] => 2017-12-20 06:10:15 [visibility] => 4 [status] => 1 [cat_index_position] => 17 )[26] => Array ( [entity_id] => 113285 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => 88?-Elbow,-Clamp-x-Tube-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:10:30 [updated_at] => 2017-12-20 06:10:30 [visibility] => 4 [status] => 1 [cat_index_position] => 18 )[27] => Array ( [entity_id] => 113302 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => 88?-Elbow,-Clamp-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:10:45 [updated_at] => 2017-12-20 06:10:45 [visibility] => 4 [status] => 1 [cat_index_position] => 19 )[28] => Array ( [entity_id] => 113325 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => 90?-Elbow,-Tube-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:11:05 [updated_at] => 2017-12-20 06:11:05 [visibility] => 4 [status] => 1 [cat_index_position] => 20 )[29] => Array ( [entity_id] => 113348 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => 90?-Elbow,-Clamp-x-Tube-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:11:24 [updated_at] => 2017-12-20 06:11:24 [visibility] => 4 [status] => 1 [cat_index_position] => 21 )[30] => Array ( [entity_id] => 113371 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => 90?-Elbow,-Clamp-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:11:43 [updated_at] => 2017-12-20 06:11:43 [visibility] => 4 [status] => 1 [cat_index_position] => 22 )[31] => Array ( [entity_id] => 113388 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => 92?-Elbow,-Tube-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:11:57 [updated_at] => 2017-12-20 06:11:57 [visibility] => 4 [status] => 1 [cat_index_position] => 23 )[32] => Array ( [entity_id] => 113405 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => 92?-Elbow,-Clamp-x-Tube-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:12:12 [updated_at] => 2017-12-20 06:12:12 [visibility] => 4 [status] => 1 [cat_index_position] => 24 )[33] => Array ( [entity_id] => 113422 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => 92?-Elbow,-Clamp-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:12:27 [updated_at] => 2017-12-20 06:12:27 [visibility] => 4 [status] => 1 [cat_index_position] => 25 )[34] => Array ( [entity_id] => 113445 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Equal-Tee,-Tube-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:12:48 [updated_at] => 2017-12-20 06:12:48 [visibility] => 4 [status] => 1 [cat_index_position] => 26 )[35] => Array ( [entity_id] => 113464 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Equal-Tee,-Tube-(run)-x-Clamp-(branch)-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:13:05 [updated_at] => 2017-12-20 06:13:05 [visibility] => 4 [status] => 1 [cat_index_position] => 27 )[36] => Array ( [entity_id] => 113487 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Equal-Tee,-Clamp-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:13:26 [updated_at] => 2017-12-20 06:13:26 [visibility] => 4 [status] => 1 [cat_index_position] => 28 )[37] => Array ( [entity_id] => 113500 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Tee,-88?-Branch,-Tube-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:13:37 [updated_at] => 2017-12-20 06:13:37 [visibility] => 4 [status] => 1 [cat_index_position] => 29 )[38] => Array ( [entity_id] => 113513 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Tee,-176?,-Tube-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:13:48 [updated_at] => 2017-12-20 06:13:48 [visibility] => 4 [status] => 1 [cat_index_position] => 30 )[39] => Array ( [entity_id] => 113536 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Tee,-Short-Outlet,-Tube-(run)-and-Clamp-(outlet)-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:14:10 [updated_at] => 2017-12-20 06:14:10 [visibility] => 4 [status] => 1 [cat_index_position] => 31 )[40] => Array ( [entity_id] => 113559 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Tee,-Short-Outlet,-Clamp-and-Tube-Ends-(run),-Tube-End-(outlet) [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:14:30 [updated_at] => 2017-12-20 06:14:30 [visibility] => 4 [status] => 1 [cat_index_position] => 32 )[41] => Array ( [entity_id] => 113578 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Tee,-Short-Outlet,-Clamp-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:14:48 [updated_at] => 2017-12-20 06:14:48 [visibility] => 4 [status] => 1 [cat_index_position] => 33 )[42] => Array ( [entity_id] => 113653 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Tee,-Reducing,-Tube-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:15:57 [updated_at] => 2017-12-20 06:15:57 [visibility] => 4 [status] => 1 [cat_index_position] => 34 )[43] => Array ( [entity_id] => 113702 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Tee,-Reducing,-Tube-(run)-and-Clamp-(branch)-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:16:39 [updated_at] => 2017-12-20 06:16:39 [visibility] => 4 [status] => 1 [cat_index_position] => 35 )[44] => Array ( [entity_id] => 113787 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Tee,-Short-Outlet,-Reducing,-Tube-(run)-and-Clamp-(branch)-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:17:55 [updated_at] => 2017-12-20 06:17:55 [visibility] => 4 [status] => 1 [cat_index_position] => 36 )[45] => Array ( [entity_id] => 113862 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Tee,-Reducing,-Clamp-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:19:02 [updated_at] => 2017-12-20 06:19:02 [visibility] => 4 [status] => 1 [cat_index_position] => 37 )[46] => Array ( [entity_id] => 113949 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Tee,-Short-Outlet,-Reducing,-Clamp-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:20:17 [updated_at] => 2017-12-20 06:20:17 [visibility] => 4 [status] => 1 [cat_index_position] => 38 )[47] => Array ( [entity_id] => 113968 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Tee,-Instrument,-Tube-Ends-(Run)-and-Clamp-End-(Branch) [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:20:36 [updated_at] => 2017-12-20 06:20:36 [visibility] => 4 [status] => 1 [cat_index_position] => 39 )[48] => Array ( [entity_id] => 113983 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Tee,-Instrument,-Clamp-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:20:56 [updated_at] => 2017-12-20 06:20:56 [visibility] => 4 [status] => 1 [cat_index_position] => 40 )[49] => Array ( [entity_id] => 114315 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Use-Point,-180?-Bottom-Outlet-Weld,-Tube-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:26:13 [updated_at] => 2017-12-20 06:26:13 [visibility] => 4 [status] => 1 [cat_index_position] => 41 )[50] => Array ( [entity_id] => 114332 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Use-Point,-180?-Bottom-Outlet-Clamp,-Tube-Ends-(run) [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:26:27 [updated_at] => 2017-12-20 06:26:27 [visibility] => 4 [status] => 1 [cat_index_position] => 42 )[51] => Array ( [entity_id] => 114349 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Use-Point,-180?-Side-Outlet-Clamp,-Tube-Ends-(run) [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:26:41 [updated_at] => 2017-12-20 06:26:41 [visibility] => 4 [status] => 1 [cat_index_position] => 43 )[52] => Array ( [entity_id] => 114364 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => True-Y,-Tube-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:26:54 [updated_at] => 2017-12-20 06:26:54 [visibility] => 4 [status] => 1 [cat_index_position] => 44 )[53] => Array ( [entity_id] => 114379 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => True-Y,-Clamp-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:27:06 [updated_at] => 2017-12-20 06:27:06 [visibility] => 4 [status] => 1 [cat_index_position] => 45 )[54] => Array ( [entity_id] => 114394 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => 45?-Lateral,-Tube-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:27:19 [updated_at] => 2017-12-20 06:27:19 [visibility] => 4 [status] => 1 [cat_index_position] => 46 )[55] => Array ( [entity_id] => 114409 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => 45?-Lateral,-Clamp-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:27:33 [updated_at] => 2017-12-20 06:27:33 [visibility] => 4 [status] => 1 [cat_index_position] => 47 )[56] => Array ( [entity_id] => 114432 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Equal-Cross,-Tube-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:27:52 [updated_at] => 2017-12-20 06:27:52 [visibility] => 4 [status] => 1 [cat_index_position] => 48 )[57] => Array ( [entity_id] => 114455 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Equal-Cross,-Clamp-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:28:12 [updated_at] => 2017-12-20 06:28:12 [visibility] => 4 [status] => 1 [cat_index_position] => 49 )[58] => Array ( [entity_id] => 114526 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Cross,-Reducing,-Tube-Ends [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:29:13 [updated_at] => 2017-12-20 06:29:13 [visibility] => 4 [status] => 1 [cat_index_position] => 50 )[59] => Array ( [entity_id] => 114551 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Ferrule,-Long-Clamp [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:29:34 [updated_at] => 2017-12-20 06:29:34 [visibility] => 4 [status] => 1 [cat_index_position] => 51 )[60] => Array ( [entity_id] => 114576 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Ferrule,-Medium-Clamp [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:29:55 [updated_at] => 2017-12-20 06:29:55 [visibility] => 4 [status] => 1 [cat_index_position] => 52 )[61] => Array ( [entity_id] => 114601 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Ferrule,-Short-Clamp [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:30:33 [updated_at] => 2017-12-20 06:30:33 [visibility] => 4 [status] => 1 [cat_index_position] => 53 )[62] => Array ( [entity_id] => 114620 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Weld-Cap [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:31:02 [updated_at] => 2017-12-20 06:31:02 [visibility] => 4 [status] => 1 [cat_index_position] => 54 )[63] => Array ( [entity_id] => 114645 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Solid-End-Cap [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:31:35 [updated_at] => 2017-12-20 06:31:35 [visibility] => 4 [status] => 1 [cat_index_position] => 55 )[64] => Array ( [entity_id] => 114651 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Heavy-Duty-Clamp,-Double-Hinged [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:31:45 [updated_at] => 2017-12-20 06:31:45 [visibility] => 4 [status] => 1 [cat_index_position] => 56 )[65] => Array ( [entity_id] => 114660 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Heavy-Duty-Clamp [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:32:01 [updated_at] => 2017-12-20 06:32:01 [visibility] => 4 [status] => 1 [cat_index_position] => 57 )[66] => Array ( [entity_id] => 114669 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Heavy-Duty-Clamp,-Wing-nut-with-Hole [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:32:17 [updated_at] => 2017-12-20 06:32:17 [visibility] => 4 [status] => 1 [cat_index_position] => 58 )[67] => Array ( [entity_id] => 114675 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Heavy-Duty-Clamp,Three-Piece,-Wing-nut-with-Hole [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:32:27 [updated_at] => 2017-12-20 06:32:27 [visibility] => 4 [status] => 1 [cat_index_position] => 59 )[68] => Array ( [entity_id] => 114683 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => High-Pressure-Clamp,-Two-Nuts [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:32:40 [updated_at] => 2017-12-20 06:32:40 [visibility] => 4 [status] => 1 [cat_index_position] => 60 )[69] => Array ( [entity_id] => 114768 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Stub-End,-Type-A,-with-Grooves [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:33:59 [updated_at] => 2017-12-20 06:33:59 [visibility] => 4 [status] => 1 [cat_index_position] => 61 )[70] => Array ( [entity_id] => 114769 [entity_type_id] => 4 [attribute_set_id] => 19 [type_id] => grouped [sku] => Flange,-Slip-On [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:34:01 [updated_at] => 2018-01-10 14:12:40 [visibility] => 4 [status] => 1 [cat_index_position] => 62 ))
BioProcess Fittings and Fabrications
Standard Features
Precision, high quality, custom process fittings with ASME-BPE surface finishes
Standard Features
Minimize or eliminate product hold-up and entrapment areas which can cause contamination. We fabricate components to fit without using multiple process connections.
Standard Features
Sentinel offers many ways to minimize process connections and divert flow. Speak to one of our Engineers about your specific need or process applications.
Standard Features
Anderson Zero Deadleg Tees for Pressure, Temperature and Point Level Sensors
Standard Features
Anderson Thermowell, 316L Stainless Steel with Electro-Polish Finish
Standard Features
Clamp Adapter x Male NPT, 316L
Standard Features
Adapter Fitting, BPE Hygienic Clamp x Male NPT, 316L Stainless Steel
Standard Features
Adapter Fitting, BPE Hygienic Clamp x Female NPT, 316L Stainless Steel
Standard Features
Clamp x Female NPT Adapter, 316L
Standard Features
Adapter Fitting, BPE Hygienic Clamp x BPE Hygienic Clamp, Short, 316L Stainless Steel
Standard Features
Hygienic Clamp x Tube (ASME-BPE), 316L Stainless Steel
Standard Features
Concentric Reducer, Tube x Tube (ASME-BPE), 316L Stainless Steel
Standard Features
Reducer, Concentric, Short, BPE Tube Ends, 316L
Standard Features
Reducer, Concentric, Short, BPE Clamp and Tube Ends, 316L
Standard Features
Reducer, Conical, Short, BPE Clamp Ends, 316L
Standard Features
Concentric Reducer, Hygienic Clamp x Tube (ASME-BPE), 316L Stainless Steel
Standard Features
Concentric Reducer, Hygienic Clamp x Hygienic Clamp (ASME-BPE), 316L Stainless Steel
Standard Features
Reducer, Concentric, Short, BPE Clamp Ends, 316L
Standard Features
Reducer, Eccentric, Short, BPE Tube Ends, 316L
Standard Features
Reducer, Eccentric, Short, BPE Clamp and Tube Ends, 316L
Standard Features
Reducer, Eccentric, Short, BPE Clamp Ends, 316L
Standard Features
Non-Permanent Hose Fitting, Hygienic Clamp (BPE) x Hose Barb, 316L Stainless Steel
Standard Features
45° Elbow, BPE Tube Ends, 316L
Standard Features
45° Elbow, BPE Clamp x Tube Ends, 316L
Standard Features
45° Elbow, BPE Clamp Ends, 316L
Standard Features
88° Elbow, BPE Tube Ends, 316L
Standard Features
88° Elbow, BPE Clamp x Tube Ends, 316L
Standard Features
88° Elbow, BPE Clamp Ends, 316L
Standard Features
90° Elbow, BPE Tube Ends, 316L
Standard Features
90° Elbow, BPE Clamp x Tube Ends, 316L
Standard Features
90° Elbow, BPE Clamp Ends, 316L
Standard Features
92° Elbow, BPE Tube Ends, 316L
Standard Features
92° Elbow, BPE Clamp x Tube Ends, 316L
Standard Features
92° Elbow, BPE Clamp Ends, 316L
Standard Features
Equal Tee, BPE Tube Ends, 316L
Standard Features
Equal Tee, BPE Tube (run) x Clamp (branch) Ends, 316L
Standard Features
Equal Tee, BPE Clamp Ends, 316L
Standard Features
Tee, 88° Branch, BPE Tube Ends, 316L
Standard Features
Tee, 176°, BPE Tube Ends, 316L
Standard Features
Tee, Short Outlet, BPE Tube (run) and Clamp (outlet) Ends, 316L
Standard Features
Tee, Short Outlet, BPE Clamp and Tube Ends (run), BPE Tube End (outlet), 316L
Standard Features
Tee, Short Outlet, BPE Clamp Ends, 316L
Standard Features
Tee, Reducing, BPE Tube Ends, 316L
Standard Features
Tee, Reducing, BPE Tube (run) and Clamp (branch) Ends, 316L
Standard Features
Tee, Short Outlet, Reducing, BPE Tube (run) and Clamp (branch) Ends, 316L
Standard Features
Tee, Reducing, BPE Clamp Ends, 316L
Standard Features
Tee, Short Outlet, Reducing, BPE Clamp Ends, 316L
Standard Features
Tee, Instrument, BPE Tube Ends (Run) and Clamp End (Branch), 316L
Standard Features
Tee, Instrument, BPE Clamp Ends, 316L
Standard Features
Use Point, 180° Bottom Outlet Weld, BPE Tube Ends, 316L
Standard Features
Use Point, 180° Bottom Outlet BPE Clamp, Tube Ends (run), 316L
Standard Features
Use Point, 180° Side Outlet BPE Clamp, Tube Ends (run), 316L
Standard Features
True Y, BPE Tube Ends, 316L
Standard Features
True Y, BPE Clamp Ends, 316L
Standard Features
45° Lateral, BPE Tube Ends, 316L
Standard Features
45° Lateral, BPE Clamp Ends, 316L
Standard Features
Equal Cross, BPE Tube Ends, 316L
Standard Features
Equal Cross, BPE Clamp Ends, 316L
Standard Features
Cross, Reducing, BPE Tube Ends, 316L
Standard Features
Ferrule, Long Clamp, 316L
Standard Features
Ferrule, Medium Clamp, 316L
Standard Features
Ferrule, Short Clamp, 316L
Standard Features
Weld Cap, 316L
Standard Features
Solid End Cap, 316L
Standard Features
Heavy Duty Clamp, Double Hinged, 304 SS
Standard Features
Heavy Duty Clamp, 304 SS
Standard Features
Heavy Duty Clamp, Wing nut with Hole, 304 SS
Standard Features
Heavy Duty Clamp, Three Piece, Wing nut with Hole, 304 SS
Standard Features
High Pressure Clamp, Two Nuts, 304 SS
Standard Features
Stub End, Type A, with Grooves, 316L
Standard Features
Flange, Slip On, 316L