The optimal fix would be for the LEFT JOIN's to be paired with the tables we're left joining to. So your statement would become:
... FROM ROM buffer_types, results LEFT JOIN platforms ON results.platform = platforms.id, tests ...
I agree that the current SQL looks incorrect.
The optimal fix would be for the LEFT JOIN's to be paired with the tables we're left joining to. So your statement would become:
... FROM ROM buffer_types, results LEFT JOIN platforms ON results.platform = platforms.id, tests ...
I agree that the current SQL looks incorrect.