sql.append(" (select community_id ");
sql.append(" from item2community ");
sql.append(" where community_id=?) ");
QueryParser qp = new QueryParser(sql.toString());
qp.addPreparedStmtElementDefinition(community.getCommunityId());
qp.addPreparedStmtElementDefinition(community.getProjectId());
qp.addPreparedStmtElementDefinition(community.getCommunityId());
qp.addPreparedStmtElementDefinition(community.getCommunityId());
qp.addPreparedStmtElementDefinition(community.getCommunityId());
qp.addPreparedStmtElementDefinition(community.getCommunityId());