The best IN-SUMP pump is by far is the Eheim 1262. These pumps are virtually indestructible and last forever and by far produce the least amount of heat. You don't want to have a lot of turnover thru the sump, you want to have a lot of flow in the tank.

Steve