The update to 0.19 broke federation and the db query fixed it again. Maybe there is a bug that was triggered by how the database looked when it wasn't a clean install. Lemmy.today has been around since the start so maybe related to some previous version...