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 = '495' 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] => 111051 [entity_type_id] => 4 [attribute_set_id] => 9 [type_id] => grouped [sku] => Tri-Clamp-Gasket [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-19 14:06:37 [updated_at] => 2018-01-10 17:32:04 [visibility] => 4 [status] => 1 [cat_index_position] => 1 )[1] => Array ( [entity_id] => 111054 [entity_type_id] => 4 [attribute_set_id] => 9 [type_id] => grouped [sku] => Elastomer-Backed-PTFE-Gaskets [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-19 14:11:32 [updated_at] => 2018-01-10 17:38:47 [visibility] => 4 [status] => 1 [cat_index_position] => 2 )[2] => Array ( [entity_id] => 111055 [entity_type_id] => 4 [attribute_set_id] => 9 [type_id] => grouped [sku] => Orifice-Plate-Gaskets-(Non-Tabbed) [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-19 14:12:39 [updated_at] => 2018-01-10 17:40:22 [visibility] => 4 [status] => 1 [cat_index_position] => 3 )[3] => Array ( [entity_id] => 111058 [entity_type_id] => 4 [attribute_set_id] => 9 [type_id] => grouped [sku] => Orifice-Plate-Gaskets-(Tabbed) [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-19 14:14:07 [updated_at] => 2018-01-10 17:42:22 [visibility] => 4 [status] => 1 [cat_index_position] => 4 )[4] => Array ( [entity_id] => 111059 [entity_type_id] => 4 [attribute_set_id] => 9 [type_id] => grouped [sku] => Orifice-Plate-Gaskets-(Right-Angle-Tabbed) [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-19 14:14:29 [updated_at] => 2018-01-10 17:42:50 [visibility] => 4 [status] => 1 [cat_index_position] => 5 )[5] => Array ( [entity_id] => 111060 [entity_type_id] => 4 [attribute_set_id] => 9 [type_id] => grouped [sku] => Screen-Gaskets [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-19 14:28:49 [updated_at] => 2018-01-10 18:04:33 [visibility] => 4 [status] => 1 [cat_index_position] => 6 )[6] => Array ( [entity_id] => 111061 [entity_type_id] => 4 [attribute_set_id] => 9 [type_id] => grouped [sku] => Sock-Gaskets [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-19 14:36:09 [updated_at] => 2018-01-10 18:14:03 [visibility] => 4 [status] => 1 [cat_index_position] => 7 )[7] => Array ( [entity_id] => 111062 [entity_type_id] => 4 [attribute_set_id] => 9 [type_id] => grouped [sku] => Compression-Control-Gaskets [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-19 14:39:30 [updated_at] => 2018-01-10 18:18:42 [visibility] => 4 [status] => 1 [cat_index_position] => 8 )[8] => Array ( [entity_id] => 111063 [entity_type_id] => 4 [attribute_set_id] => 9 [type_id] => grouped [sku] => Source-Gaskets [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-19 14:41:28 [updated_at] => 2018-01-10 18:21:14 [visibility] => 4 [status] => 1 [cat_index_position] => 9 )[9] => Array ( [entity_id] => 111057 [entity_type_id] => 4 [attribute_set_id] => 9 [type_id] => grouped [sku] => Gauge-Guard-Gaskets [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-19 14:13:22 [updated_at] => 2018-01-10 17:41:22 [visibility] => 4 [status] => 1 [cat_index_position] => 10 )[10] => Array ( [entity_id] => 111052 [entity_type_id] => 4 [attribute_set_id] => 9 [type_id] => grouped [sku] => Flanged-Tri-Clamp-Gasket [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-19 14:08:35 [updated_at] => 2018-01-10 17:34:47 [visibility] => 4 [status] => 1 [cat_index_position] => 11 )[11] => Array ( [entity_id] => 111053 [entity_type_id] => 4 [attribute_set_id] => 9 [type_id] => grouped [sku] => Schedule-5-Flanged-Gasket [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-19 14:10:12 [updated_at] => 2018-01-10 17:37:01 [visibility] => 4 [status] => 1 [cat_index_position] => 12 )[12] => Array ( [entity_id] => 111056 [entity_type_id] => 4 [attribute_set_id] => 9 [type_id] => grouped [sku] => Blank-Gaskets [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-19 14:13:03 [updated_at] => 2018-01-10 17:40:56 [visibility] => 4 [status] => 1 [cat_index_position] => 13 ))

Sealing Technologies (13)