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 = '530' 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] => 114954 [entity_type_id] => 4 [attribute_set_id] => 4 [type_id] => simple [sku] => Uniqsis [has_options] => 0 [required_options] => 0 [created_at] => 2020-08-13 19:47:50 [updated_at] => 2023-02-21 20:35:19 [visibility] => 4 [status] => 1 [cat_index_position] => 1 )[1] => Array ( [entity_id] => 114957 [entity_type_id] => 4 [attribute_set_id] => 4 [type_id] => simple [sku] => Fuji Techno [has_options] => 0 [required_options] => 0 [created_at] => 2020-08-14 12:08:17 [updated_at] => 2021-06-24 16:12:55 [visibility] => 4 [status] => 1 [cat_index_position] => 1 )[2] => Array ( [entity_id] => 114966 [entity_type_id] => 4 [attribute_set_id] => 4 [type_id] => simple [sku] => corning [has_options] => 0 [required_options] => 0 [created_at] => 2021-06-24 16:10:01 [updated_at] => 2021-06-30 14:02:36 [visibility] => 4 [status] => 1 [cat_index_position] => 1 ))
Flow Chemistry
For more information on the capabilities and offerings of our flow chemistry equipment please visit our sister site Kilolabs.com
Standard Features
Lab Scale Flow Reactors
Standard Features
Precision Flow Chemistry Metering Pumps
Standard Features
Advanced-Flow™ Reactors