nutz自定义sql查询

Cnd cn1 = Cnd.NEW();        Cnd cn2 = Cnd.NEW();        if (i == temp - 1) {            if (special) {                break;            }        } else {            cutList = statistics.subList(flag * i, flag * (i + 1));            for (int j = 0; j < cutList.size(); j++) {                cn1 = Where.where(cn1, "IMEI1", "=", updateClientInfo.getIMEI()); // 查询手机唯一                Device device = dao.fetch(Device.class, cn1);                 cn2 = Where.where(cn2, "deviceId", "=",device.getId()); //查询手机id                 cn2 = Where.where(cn2, "packageName", "=",cutList.get(j).getPackageName()); //查询包名                DeviceApk deviceApk = dao.fetch(DeviceApk.class, cn2);                sql = Sqls.create(                        "select * from t_activating_quantity   where  q_createtime in (select max(q_createtime) from t_activating_quantity  $cnd )");                sql.setVar("cnd", Cnd.NEW().andEX("t_activating_quantity.q_apkId", "=", deviceApk.getId())                        .andEX("t_activating_quantity.q_deviceId", "=", device.getId()));                sql.setCallback(Sqls.callback.entities());                sql.setEntity(dao.getEntity(ActivatingQuantity.class));                dao.execute(sql);                List<ActivatingQuantity> fetch = sql.getList(ActivatingQuantity.class);