Brine Tanks Slotted Brine Wells
    | Slotted Brine Tank Wells are the tubes inside the brine tank where the float assembly resides. They are slotted at the bottom to allow brine water to be pulled into the softener during regeneration while filtering out the raw salt.
Brine Tanks and Components |
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 = 1195 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