Filters for Barnstead GenPure Systems
![]() |     | The Barnstead Genpure system provide high quality laboratory water from pretreated water. These are available as a basic version low organic version pyrogen free version or an ultrapure low organic/pyrogen free system. Filters for this device can be found in this section. Find Barnstead GenPure Systems |
select DISTINCTROW top 10 p.CatalogId,p.ccode from products p, prodcategories cc, categories c where cc.intCatalogId=p.CatalogId and cc.intcategoryid=c.categoryid and cc.intcategoryid = 1111 and p.hide = 0 and (p.customermatch is null or p.customermatch = '') and (p.loggedin = false or p.loggedin is null) and (c.customermatch is null or c.customermatch = '') and (c.loggedin = false or c.loggedin is null) AND (higherCatalogId is null) order by p.ccode

