private Query prepareQuery(RicercaDeleghe ricercaAssociati,boolean count){
        Utenti ut = (Utenti) SecurityContextHolder.getContext().getAuthentication().getPrincipal();
        StringBuffer query = new StringBuffer();

        if("1".equalsIgnoreCase(ricercaAssociati.getTipoUtenti()) || "-1".equalsIgnoreCase(ricercaAssociati.getTipoUtenti())){
            if(count){
                query.append(getProperties().getProperty("selectCountListAssociati")).append(" ");
            }else{
                query.append(getProperties().getProperty("listGestioneAssociati")).append(" ");
                query.append(getProperties().getProperty("listAssociati")).append(" ");
            }
            if(ut.isAdminINPS()){
                query.append(getProperties().getProperty("tabellaAssociati")).append(" ");
            }else{
                query.append(getProperties().getProperty("vistaAssociatiUtente")).append(" ");
            }
            if(StringUtils.isEmpty(ricercaAssociati.getZonaInps()) && (StringUtils.isNotEmpty(ricercaAssociati.getCodIstatRegioneSede()) || StringUtils.isNotEmpty(ricercaAssociati.getCodIstatProvinciaSede()))){
                query.append(getProperties().getProperty("tabellaSediINPS")).append(" ");
            }
            query.append(getProperties().getProperty("whereConditions")).append(" ");

            bloccoWhereConditions(query, ricercaAssociati, count);
        }
        if("-1".equalsIgnoreCase(ricercaAssociati.getTipoUtenti())){
            query.append("UNION").append(" ");
        }
        if("3".equalsIgnoreCase(ricercaAssociati.getTipoUtenti()) || "-1".equalsIgnoreCase(ricercaAssociati.getTipoUtenti())){
            if(count){
                query.append(getProperties().getProperty("selectCountListAssociati")).append(" ");
            }else{
                query.append(getProperties().getProperty("listGestioneAssociati")).append(" ");
                query.append(getProperties().getProperty("listDomiciliati")).append(" ");
            }
            if(ut.isAdminINPS()){
                query.append(getProperties().getProperty("tabellaDomiciliati")).append(" ");
            }else{
                query.append(getProperties().getProperty("vistaDomiciliatiUtente")).append(" ");
            }
            if(StringUtils.isEmpty(ricercaAssociati.getZonaInps()) && (StringUtils.isNotEmpty(ricercaAssociati.getCodIstatRegioneSede()) || StringUtils.isNotEmpty(ricercaAssociati.getCodIstatProvinciaSede()))){
                query.append(getProperties().getProperty("tabellaSediINPS")).append(" ");
            }
            query.append(getProperties().getProperty("whereConditions")).append(" ");

            bloccoWhereConditions(query, ricercaAssociati, count);
        }

        if("-1".equalsIgnoreCase(ricercaAssociati.getTipoUtenti())){
            query.append("UNION").append(" ");
        }
        if("2".equalsIgnoreCase(ricercaAssociati.getTipoUtenti()) || "-1".equalsIgnoreCase(ricercaAssociati.getTipoUtenti())){
            if(count){
                query.append(getProperties().getProperty("selectCountListAssociati")).append(" ");
            }else{
                query.append(getProperties().getProperty("listGestioneTrascodificati")).append(" ");
                query.append(getProperties().getProperty("listTrascodificati")).append(" ");
            }
            if(ut.isAdminINPS()){
                query.append(getProperties().getProperty("tabellaTrascodificati")).append(" ");
            }else{
                query.append(getProperties().getProperty("vistaTrascodificatiUtente")).append(" ");
            }
            if(StringUtils.isEmpty(ricercaAssociati.getZonaInps()) && (StringUtils.isNotEmpty(ricercaAssociati.getCodIstatRegioneSede()) || StringUtils.isNotEmpty(ricercaAssociati.getCodIstatProvinciaSede()))){
                query.append(getProperties().getProperty("tabellaSediINPS")).append(" ");
            }
            query.append(getProperties().getProperty("whereConditions")).append(" ");

            bloccoWhereConditions(query, ricercaAssociati, count);
        }

        if("-1".equalsIgnoreCase(ricercaAssociati.getTipoUtenti())){
            query.append("UNION").append(" ");
        }
        if("4".equalsIgnoreCase(ricercaAssociati.getTipoUtenti()) || "-1".equalsIgnoreCase(ricercaAssociati.getTipoUtenti())){
            if(count){
                query.append(getProperties().getProperty("selectCountListAssociati")).append(" ");
            }else{
                query.append(getProperties().getProperty("listGestioneAssociati")).append(" ");
                query.append(getProperties().getProperty("listCancellati")).append(" ");
            }
            if(ut.isAdminINPS()){
                query.append(getProperties().getProperty("tabellaCancellati")).append(" ");
            }else{
                query.append(getProperties().getProperty("vistaCancellatiUtente")).append(" ");
            }
            if(StringUtils.isEmpty(ricercaAssociati.getZonaInps()) && (StringUtils.isNotEmpty(ricercaAssociati.getCodIstatRegioneSede()) || StringUtils.isNotEmpty(ricercaAssociati.getCodIstatProvinciaSede()))){
                query.append(getProperties().getProperty("tabellaSediINPS")).append(" ");
            }
            query.append(getProperties().getProperty("whereConditions")).append(" ");

            bloccoWhereConditions(query, ricercaAssociati, count);
        }

        if("-1".equalsIgnoreCase(ricercaAssociati.getTipoUtenti())){
            query.append("UNION").append(" ");
        }
        if("5".equalsIgnoreCase(ricercaAssociati.getTipoUtenti()) || "-1".equalsIgnoreCase(ricercaAssociati.getTipoUtenti())){
            if(count){
                query.append(getProperties().getProperty("selectCountListAssociati")).append(" ");
            }else{
                query.append(getProperties().getProperty("listGestioneAssociati")).append(" ");
                query.append(getProperties().getProperty("listAffievoliti")).append(" ");
            }
            if(ut.isAdminINPS()){
                query.append(getProperties().getProperty("tabellaAffievoliti")).append(" ");
            }else{
                query.append(getProperties().getProperty("vistaAffievolitiUtente")).append(" ");
            }
            if(StringUtils.isEmpty(ricercaAssociati.getZonaInps()) && (StringUtils.isNotEmpty(ricercaAssociati.getCodIstatRegioneSede()) || StringUtils.isNotEmpty(ricercaAssociati.getCodIstatProvinciaSede()))){
                query.append(getProperties().getProperty("tabellaSediINPS")).append(" ");
            }
            query.append(getProperties().getProperty("whereConditions")).append(" ");

            bloccoWhereConditions(query, ricercaAssociati, count);
        }

        if("-1".equalsIgnoreCase(ricercaAssociati.getTipoUtenti())){
            query.append("UNION").append(" ");
        }
        if("6".equalsIgnoreCase(ricercaAssociati.getTipoUtenti()) || "-1".equalsIgnoreCase(ricercaAssociati.getTipoUtenti())){
            if(count){
                query.append(getProperties().getProperty("selectCountListAssociati")).append(" ");
            }else{
                query.append(getProperties().getProperty("listGestioneAssociati")).append(" ");
                query.append(getProperties().getProperty("listCaloFisiologico")).append(" ");
            }
            if(ut.isAdminINPS()){
                query.append(getProperties().getProperty("tabellaCaloFisiologico")).append(" ");
            }else{
                query.append(getProperties().getProperty("vistaCaloFisiologicoUtente")).append(" ");
            }
            if(StringUtils.isEmpty(ricercaAssociati.getZonaInps()) && (StringUtils.isNotEmpty(ricercaAssociati.getCodIstatRegioneSede()) || StringUtils.isNotEmpty(ricercaAssociati.getCodIstatProvinciaSede()))){
                query.append(getProperties().getProperty("tabellaSediINPS")).append(" ");
            }
            query.append(getProperties().getProperty("whereConditions")).append(" ");

            bloccoWhereConditions(query, ricercaAssociati, count);
        }
        if(!count){
            query.insert(0, getProperties().getProperty("listUnionGestioneAssociati")+" ");
            query.append(") as tabella").append(" ");
            if(StringUtils.isNotEmpty(ricercaAssociati.getOrderBy())){
                if("nome".equalsIgnoreCase(ricercaAssociati.getOrderBy())){
                    query.append(getProperties().getProperty("associatiOrderByNome")).append(" ");
                }
                if("cognome".equalsIgnoreCase(ricercaAssociati.getOrderBy())){
                    query.append(getProperties().getProperty("associatiOrderByCognome")).append(" ");
                }
                if("CODFISCALE".equalsIgnoreCase(ricercaAssociati.getOrderBy())){
                    query.append(getProperties().getProperty("associatiOrderByCodfiscale")).append(" ");
                }
                if("azienda".equalsIgnoreCase(ricercaAssociati.getOrderBy())){
                    query.append(getProperties().getProperty("associatiOrderByAzienda")).append(" ");
                }
                if("anno".equalsIgnoreCase(ricercaAssociati.getOrderBy())){
                    query.append(getProperties().getProperty("associatiOrderByAnno")).append(" ");
                }
                if(ricercaAssociati.isOrderDesc()){
                    query.append(getProperties().getProperty("ordinamentoDecrescente")).append(" ");
                }
            }else{
                //query.append(getProperties().getProperty("associatiOrderByCognome")).append(" ");
                query.append(getProperties().getProperty("associatiOrderDefault")).append(" ");
            }
        }