def list_active_lgas(request): context = RequestContext(request) context.site_title = "NMIS: LGA List" context.lgas = LGA.objects.annotate(facility_count=Count('facilities')).filter(facility_count__gt=0) return render_to_response("list_active_lgas.html", context_instance=context)