added last_paid view