Comunicazioni chiuse da utente

SELECT
                    COUNT(*) AS tot
                FROM
                    (
                        SELECT
                            num_info
                        FROM
                            comunicazioni_
                        WHERE
                            id_cliente = <cfqueryparam cfsqltype="cf_sql_integer" VALUE="#SESSION.comunico_light.anagrafica_id#" />
                            AND id_utente = <cfqueryparam cfsqltype="cf_sql_integer" VALUE="#SESSION.comunico_light.user_id#" />
                            <cfif structKeyExists(SESSION,"tipo")>
                                AND tipo = <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#SESSION.tipo#" />
                            </cfif>
                            AND stato = 'C'
                            AND data_aggiornamento
                                BETWEEN <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#LSDateFormat(now(),'yyyy-mm-dd')# 00:00:00" />
                                AND <cfqueryparam cfsqltype="cf_sql_varchar" VALUE="#LSDateFormat(now(),'yyyy-mm-dd')# 23:59:59" />
                        GROUP BY
                            num_info
                    ) AS t