gistfile1.txt

            res = s.extra(select={"actotal": """SELECT COUNT('id_sindicato')
                FROM paginas P INNER JOIN sindicato S
                ON (P.id_sindicato=S.id_sindicato)
                INNER JOIN federacao F ON (S.id_federacao=F.id_federacao)
                WHERE P.boletins=true AND F.sigla=federacao.sigla"""}).\
                values("federationbulletin__federation__initials",
                       "actotal").\
                annotate(
                    virtualtarget_views_total=Sum("virtualtarget_views_total"),
                    virtualtarget_clicks=Sum("virtualtarget_clicks"),
                    virtualtarget_optout=Sum("virtualtarget_optout"),
                    virtualtarget_delivered=Sum("virtualtarget_delivered"),
                    virtualtarget_processed=Sum("virtualtarget_processed")).\
                order_by("federationbulletin__federation__initials")