added latest activity queries