- Home /
- Reaction Support Equipment
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 = '532' 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] => 114953 [entity_type_id] => 4 [attribute_set_id] => 4 [type_id] => simple [sku] => PSL Filters [has_options] => 0 [required_options] => 0 [created_at] => 2020-08-13 19:45:21 [updated_at] => 2020-09-11 16:47:51 [visibility] => 4 [status] => 1 [cat_index_position] => 1 )[1] => Array ( [entity_id] => 114950 [entity_type_id] => 4 [attribute_set_id] => 4 [type_id] => simple [sku] => Aurora Filters [has_options] => 0 [required_options] => 0 [created_at] => 2020-08-13 19:39:36 [updated_at] => 2021-12-13 14:30:13 [visibility] => 4 [status] => 1 [cat_index_position] => 2 )[2] => Array ( [entity_id] => 114952 [entity_type_id] => 4 [attribute_set_id] => 4 [type_id] => simple [sku] => Steroglass [has_options] => 0 [required_options] => 0 [created_at] => 2020-08-13 19:43:20 [updated_at] => 2020-09-11 16:47:34 [visibility] => 4 [status] => 1 [cat_index_position] => 3 )[3] => Array ( [entity_id] => 114949 [entity_type_id] => 4 [attribute_set_id] => 4 [type_id] => simple [sku] => Ezi-Dock [has_options] => 0 [required_options] => 0 [created_at] => 2020-08-13 18:59:09 [updated_at] => 2020-09-11 16:46:16 [visibility] => 4 [status] => 1 [cat_index_position] => 4 )[4] => Array ( [entity_id] => 114951 [entity_type_id] => 4 [attribute_set_id] => 4 [type_id] => simple [sku] => Duker [has_options] => 0 [required_options] => 0 [created_at] => 2020-08-13 19:40:35 [updated_at] => 2020-09-11 16:47:18 [visibility] => 4 [status] => 1 [cat_index_position] => 5 ))
Reaction Support Equipment
For more information on the capabilities and offerings of our reaction support equipment please visit our sister site Kilolabs.com
Standard Features
Lab Filter Dryers
Standard Features
Glove Box Filter for API’s and Potent Compounds
Standard Features
Industrial Scale Rotary Evaporators
Standard Features
High containment transfer products
Standard Features
Glass Lined Process Valves and Fittings