Show earliest available statistic for new friends

1 files changed, 1 insertions, 1 deletions

diff --git a/persistence/__init__.py b/persistence/__init__.py
index 348ae59..4d50754 100644
--- a/persistence/__init__.py
+++ b/persistence/__init__.py
@@ -81,7 +81,7 @@ class StatsRepository:
     def get_stats(self, stats_datetime: datetime.datetime) -> typing.List[UserStats]:
         connection = self.__get_connection()
         cur = connection.cursor()
-        query = "SELECT * FROM stats WHERE stats_datetime IN (SELECT MIN(stats_datetime) FROM stats WHERE stats_datetime >= '{stats_datetime}')".format(stats_datetime = stats_datetime)
+        query = "SELECT * FROM stats a WHERE a.stats_datetime IN (SELECT MIN(b.stats_datetime) FROM stats b WHERE b.stats_datetime >= '{stats_datetime}' AND a.display_name = b.display_name)".format(stats_datetime = stats_datetime)
         cur.execute(query)
         result = cur.fetchall()
         return [self.__map_from_db(stats) for stats in result]