@Override public List<? extends Host> getNonPurgedHosts(long accountId) { return create() .select(HOST.fields()) .from(HOST) .where(HOST.ACCOUNT_ID.eq(accountId).and(HOST.STATE.notEqual(CommonStatesConstants.PURGED))) .fetchInto(Host.class); }