domain query - query status by left join; redesign package.