I suspect during initial migration of the reviewServer_user_stats table, when I migrated life counts for a subset of users, something went awry with the JOIN query, as well as a malformed date. This has caused ~30 or so records to be entered as below. None appear to have accounts associated, though.
SELECT * FROM PROD_2HOL.reviewServer_user_stats WHERE last_game_date < "2000-01-01"
36892
Colin13
1
1754-08-31 08:48:33
1754-08-31 08:48:33
0
1
0
0
1754-08-31 08:48:33
0
0
0
0
0
0
It may be possible that we can just clean up these records, as they're likely just artefacts of past migrations. The only information worth noting for any of them is the lives lived count, which in general is small for all of them.
I suspect during initial migration of the
reviewServer_user_statstable, when I migrated life counts for a subset of users, something went awry with theJOINquery, as well as a malformed date. This has caused ~30 or so records to be entered as below. None appear to have accounts associated, though.It may be possible that we can just clean up these records, as they're likely just artefacts of past migrations. The only information worth noting for any of them is the lives lived count, which in general is small for all of them.