Designed for the reduction of unwanted tastes and odors such as chlorine. Water enters the bottom and filters thru the entire bed before exiting at the top. This insures maximum contact time ensuring maximum absorption. A built-in 20 micron post filter reduces fines.

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