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 ))