shouldn't count retractions as part of the total vote countpolls

1 files changed, 1 insertions, 1 deletions

diff --git a/apioforum/db.py b/apioforum/db.py
index ba1f6a3..f3693a9 100644
--- a/apioforum/db.py
+++ b/apioforum/db.py
@@ -117,7 +117,7 @@ CREATE VIEW vote_counts AS
 """,
 """
 CREATE VIEW total_vote_counts AS
-    SELECT poll, count(*) AS total_votes FROM votes WHERE current GROUP BY poll;
+    SELECT poll, count(*) AS total_votes FROM votes WHERE current AND NOT is_retraction GROUP BY poll;
 """,
     
 ]