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 = '498' 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] => 114786 [entity_type_id] => 4 [attribute_set_id] => 17 [type_id] => simple [sku] => Tube-Sets-and-Manifolds [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 07:50:53 [updated_at] => 2020-08-14 12:55:42 [visibility] => 4 [status] => 1 [cat_index_position] => 1 )[1] => Array ( [entity_id] => 114948 [entity_type_id] => 4 [attribute_set_id] => 4 [type_id] => simple [sku] => single-use-manifolds [has_options] => 0 [required_options] => 0 [created_at] => 2020-08-07 16:49:07 [updated_at] => 2020-08-14 13:15:11 [visibility] => 4 [status] => 1 [cat_index_position] => 2 )[2] => Array ( [entity_id] => 114946 [entity_type_id] => 4 [attribute_set_id] => 4 [type_id] => simple [sku] => silicone-bulk-tubing [has_options] => 0 [required_options] => 0 [created_at] => 2020-08-07 16:32:55 [updated_at] => 2020-09-11 14:33:11 [visibility] => 4 [status] => 1 [cat_index_position] => 3 )[3] => Array ( [entity_id] => 114945 [entity_type_id] => 4 [attribute_set_id] => 4 [type_id] => simple [sku] => tpe-tubing [has_options] => 0 [required_options] => 0 [created_at] => 2020-08-07 16:28:42 [updated_at] => 2020-08-14 12:57:13 [visibility] => 4 [status] => 1 [cat_index_position] => 4 )[4] => Array ( [entity_id] => 114941 [entity_type_id] => 4 [attribute_set_id] => 4 [type_id] => simple [sku] => sanitary-fittings [has_options] => 0 [required_options] => 0 [created_at] => 2020-04-02 19:48:25 [updated_at] => 2020-08-14 13:02:49 [visibility] => 4 [status] => 1 [cat_index_position] => 5 )[5] => Array ( [entity_id] => 114942 [entity_type_id] => 4 [attribute_set_id] => 4 [type_id] => simple [sku] => tube-welder-sealer [has_options] => 0 [required_options] => 0 [created_at] => 2020-04-02 20:15:34 [updated_at] => 2020-08-13 16:31:06 [visibility] => 4 [status] => 1 [cat_index_position] => 7 )[6] => Array ( [entity_id] => 114947 [entity_type_id] => 4 [attribute_set_id] => 4 [type_id] => simple [sku] => tube-sealer [has_options] => 0 [required_options] => 0 [created_at] => 2020-08-07 16:39:10 [updated_at] => 2020-08-13 16:31:22 [visibility] => 4 [status] => 1 [cat_index_position] => 8 )[7] => Array ( [entity_id] => 114943 [entity_type_id] => 4 [attribute_set_id] => 4 [type_id] => simple [sku] => single-use-pinch-valves [has_options] => 0 [required_options] => 0 [created_at] => 2020-04-02 20:22:44 [updated_at] => 2020-08-26 14:10:20 [visibility] => 4 [status] => 1 [cat_index_position] => 9 )[8] => Array ( [entity_id] => 113177 [entity_type_id] => 4 [attribute_set_id] => 16 [type_id] => grouped [sku] => Sonotec-CO.55-V2-Non-Invasive-Flow-Sensor [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:08:01 [updated_at] => 2020-08-13 17:42:23 [visibility] => 4 [status] => 1 [cat_index_position] => 10 )[9] => Array ( [entity_id] => 113181 [entity_type_id] => 4 [attribute_set_id] => 16 [type_id] => simple [sku] => 200 08 0001 [has_options] => 0 [required_options] => 0 [created_at] => 2017-12-20 06:08:05 [updated_at] => 2020-08-26 14:05:59 [visibility] => 4 [status] => 1 [cat_index_position] => 11 ))

Single-Use Tubing Solutions