diff options
| -rw-r--r-- | persistence/__init__.py | 2 |
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] |