Certified Used Misc Lab Water Systems
|  |     | Although our primary business is new equipment we acquire a wide variety of previously owned systems accessories and parts for most major brands including Millipore Barnstead and Others. It is best to call us and discuss your needs and we can see what we have to meet them. New equipment can be found here | 
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 = 1024 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
