Activated carbon is the most common method for reducing chlorine in water. Activated carbon requires periodic backwashing. For the most effective chlorine reduction activated carbon should be sized to flow at 2-3 g.p.m. per cubic foot (ft3 of media. All About : Activated Carbon Design Info for Activated Carbon Media Activated Carbon 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 = 1030 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