SQL optimizations for laoding subscibers