A submersible pump is a device which has a sealed motor close-coupled to the pump body. The whole assembly is submerged in the water to be pumped. The main advantage of this type of pump is that it prevents pump cavitation which is a problem associated between pump and the fluid when the pump has to lull the water. Submersible pumps push fluid to the surface as opposed to jet pumps having to pull fluids. Submersibles are more efficient than jet pumps. See all pumps Using Pressure Bladders with and without pumps

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