Since two days ago I’m trying to believe what I’ve found: MySQL (“the world’s most popular open source database“, as they say) is unable to resolve a simple SQL query in an efficient way, leading me (and the program I’m developing) to a dead end.