why wouldn't you join against the users table which uses the public apis?