It happens this way because people rush to add entries into the database when a game is announced, instead of when a game is released. Like all those entries and dupes we get during E3 events, or Nintendo Directs or whatever. Often time, it is a wasted effort. Rather than creating entries for un-released games in physical section, they should be made in the digital categories only. Wait until the thing actually physically exists before putting it into the database.
Think about this. I believe it was one of the Far Cry games, perhaps Far Cry 4. It was added as "Far Cry 4" before the game came out. It had stock photo art. When the game was released, it released as "Limited Edition" which was then added to the db. The game didn't get a non-edition release until later and as a result more people have the "reprint" or "non-editioned" game entry in their collection than the LE or whichever version came out on the release day that they actually have. It took a bit to figure out that this happened, and we fixed up the entries, but it doesn't change the fact of what happened. And this happens all the time with games. Sometimes (as is the case with Agent of Mayhem) the game never gets a non-editioned release, so someone made an entry, and people added it to their collection or wishlist, for a thing that never existed.