Reverse Osmosis is the most popular and cost effective method to purify drinking water. An RO system removes virtually 99% of contaminants in water including bacteria pesticides fluoride and other dissolved ions. A system comes complete with prefiltration reverse osmosis storage and a faucet. Commercial Reverse Osmosis Systems About Reverse Osmosis Systems What are RO stages and do they matter? Storage Tanks Water Softeners Iron Filters Designer Faucets

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 = 825 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