reduced database hits and added last seen column