Comment 1 for bug 162528

Revision history for this message
James Henstridge (jamesh) wrote :

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.