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 = '502' 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] => 114774 [entity_type_id] => 4 [attribute_set_id] => 15 [type_id] => simple [sku] => EM-Life-Sciences-Series-Pressure-Gauge-(90mm) [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 07:37:56 [updated_at] => 2017-12-20 07:37:56 [visibility] => 4 [status] => 1 [cat_index_position] => 1 )[1] => Array ( [entity_id] => 114770 [entity_type_id] => 4 [attribute_set_id] => 15 [type_id] => simple [sku] => FJ-Digital-Temperature-Gauge/Switch [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 07:37:51 [updated_at] => 2017-12-20 07:37:51 [visibility] => 4 [status] => 1 [cat_index_position] => 1 )[2] => Array ( [entity_id] => 111044 [entity_type_id] => 4 [attribute_set_id] => 4 [type_id] => simple [sku] => GEMU-Type-1434 [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-18 12:53:40 [updated_at] => 2017-12-19 06:28:03 [visibility] => 4 [status] => 1 [cat_index_position] => 1 )[3] => Array ( [entity_id] => 111038 [entity_type_id] => 4 [attribute_set_id] => 4 [type_id] => simple [sku] => GEMU-Type-1201 [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-18 12:53:34 [updated_at] => 2017-12-19 06:27:58 [visibility] => 4 [status] => 1 [cat_index_position] => 1 )[4] => Array ( [entity_id] => 111016 [entity_type_id] => 4 [attribute_set_id] => 4 [type_id] => simple [sku] => AFC-900-Series-Bioreactor-Control-System [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-18 12:34:42 [updated_at] => 2018-01-10 12:05:22 [visibility] => 4 [status] => 1 [cat_index_position] => 1 )[5] => Array ( [entity_id] => 114775 [entity_type_id] => 4 [attribute_set_id] => 15 [type_id] => simple [sku] => EK-Life-Sciences-Series-Pressure-Gauge-(63mm) [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 07:37:57 [updated_at] => 2017-12-20 07:37:57 [visibility] => 4 [status] => 1 [cat_index_position] => 2 )[6] => Array ( [entity_id] => 114771 [entity_type_id] => 4 [attribute_set_id] => 15 [type_id] => simple [sku] => SW/CT-Sanitary-RTDs-and-Temperature-Transmitters [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 07:37:53 [updated_at] => 2018-01-04 08:47:25 [visibility] => 4 [status] => 1 [cat_index_position] => 2 )[7] => Array ( [entity_id] => 111039 [entity_type_id] => 4 [attribute_set_id] => 4 [type_id] => simple [sku] => GEMU-Type-1230 [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-18 12:53:35 [updated_at] => 2017-12-19 06:27:58 [visibility] => 4 [status] => 1 [cat_index_position] => 2 )[8] => Array ( [entity_id] => 111017 [entity_type_id] => 4 [attribute_set_id] => 4 [type_id] => simple [sku] => AFC-2000-Series-Replacement-Bioreactor-Control-System [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-18 12:34:42 [updated_at] => 2018-01-10 12:05:50 [visibility] => 4 [status] => 1 [cat_index_position] => 2 )[9] => Array ( [entity_id] => 111045 [entity_type_id] => 4 [attribute_set_id] => 4 [type_id] => simple [sku] => GEMU-Type-1435 [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-18 12:53:41 [updated_at] => 2018-01-04 09:29:23 [visibility] => 4 [status] => 1 [cat_index_position] => 2 )[10] => Array ( [entity_id] => 111040 [entity_type_id] => 4 [attribute_set_id] => 4 [type_id] => simple [sku] => GEMU-Type-1235 [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-18 12:53:36 [updated_at] => 2018-01-04 09:29:21 [visibility] => 4 [status] => 1 [cat_index_position] => 3 )[11] => Array ( [entity_id] => 114779 [entity_type_id] => 4 [attribute_set_id] => 15 [type_id] => simple [sku] => Anderson-HMP-Life-Sciences-Turbine-Flow-Meter [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 07:38:02 [updated_at] => 2017-12-20 07:38:02 [visibility] => 4 [status] => 1 [cat_index_position] => 3 )[12] => Array ( [entity_id] => 114776 [entity_type_id] => 4 [attribute_set_id] => 15 [type_id] => simple [sku] => EP-Life-Sciences-Series-Digital-Pressure-Gauge/Switch [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 07:37:58 [updated_at] => 2017-12-20 07:37:58 [visibility] => 4 [status] => 1 [cat_index_position] => 3 )[13] => Array ( [entity_id] => 111046 [entity_type_id] => 4 [attribute_set_id] => 4 [type_id] => simple [sku] => GEMU-Type-1436 [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-18 12:53:42 [updated_at] => 2017-12-19 06:28:05 [visibility] => 4 [status] => 1 [cat_index_position] => 3 )[14] => Array ( [entity_id] => 114772 [entity_type_id] => 4 [attribute_set_id] => 15 [type_id] => simple [sku] => MPP-Life-Sciences-Series-Modular-Pressure-Transmitter [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 07:37:54 [updated_at] => 2017-12-20 07:37:54 [visibility] => 4 [status] => 1 [cat_index_position] => 4 )[15] => Array ( [entity_id] => 111041 [entity_type_id] => 4 [attribute_set_id] => 4 [type_id] => simple [sku] => GEMU-Type-1236 [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-18 12:53:37 [updated_at] => 2018-01-04 09:29:22 [visibility] => 4 [status] => 1 [cat_index_position] => 4 )[16] => Array ( [entity_id] => 114777 [entity_type_id] => 4 [attribute_set_id] => 15 [type_id] => simple [sku] => TP-HART/SMART-Life-Sciences-Series-Pressure-Transmitter [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 07:38:00 [updated_at] => 2017-12-20 07:38:00 [visibility] => 4 [status] => 1 [cat_index_position] => 5 )[17] => Array ( [entity_id] => 111042 [entity_type_id] => 4 [attribute_set_id] => 4 [type_id] => simple [sku] => GEMU-Type-4222 [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-18 12:53:38 [updated_at] => 2017-12-19 06:28:01 [visibility] => 4 [status] => 1 [cat_index_position] => 5 )[18] => Array ( [entity_id] => 114773 [entity_type_id] => 4 [attribute_set_id] => 15 [type_id] => simple [sku] => HA-Life-Sciences-Series-Mini-Pressure-Transmitter [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 07:37:55 [updated_at] => 2017-12-20 07:37:55 [visibility] => 4 [status] => 1 [cat_index_position] => 6 )[19] => Array ( [entity_id] => 111043 [entity_type_id] => 4 [attribute_set_id] => 4 [type_id] => simple [sku] => GEMU-Type-4242 [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-18 12:53:39 [updated_at] => 2017-12-19 06:28:02 [visibility] => 4 [status] => 1 [cat_index_position] => 6 )[20] => Array ( [entity_id] => 114778 [entity_type_id] => 4 [attribute_set_id] => 15 [type_id] => simple [sku] => SV-Life-Sciences-Series-Pressure-Transmitter [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 07:38:01 [updated_at] => 2017-12-20 07:38:01 [visibility] => 4 [status] => 1 [cat_index_position] => 7 ))