Unread badges that would not clear: 59 of my 64 messages were junk

A chat unread counter that reset itself and came back. Two wrong theories, one SQL query, and a bug that had been quietly filling the database.