From 411ef3434ace8c97990552318992c844e97c6d31 Mon Sep 17 00:00:00 2001
From: Magnus Hagander <magnus@hagander.net>
Date: Thu, 11 Feb 2016 09:30:56 +0100
Subject: [PATCH] Fix query for list sync

---
 listsync.py | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/listsync.py b/listsync.py
index 1bec00a..3706f71 100755
--- a/listsync.py
+++ b/listsync.py
@@ -144,8 +144,8 @@ class Synchronizer:
 
 		curs = self.db.cursor()
 		curs.execute("""
-SELECT email FROM auth_user 
-INNER JOIN feeds ON auth_user.username=feeds.userid 
+SELECT DISTINCT email FROM auth_user
+INNER JOIN feeds ON auth_user.id=feeds.user_id
 WHERE feeds.approved
 """)
 		self.expected = set([r[0] for r in curs.fetchall()])
-- 
2.39.5