MySQL Left join error, Unknown column

Currently, the expression builder dont put parenthesis between the FROM and JOIN and this create a bug. In my case, the LEFT JOIN was only on the tests class. With the parenthesis, it work perfectly

Modification I made so it work:
In expr.py in the build_tables function

ORIGINAL VERSION:
def build_tables(compile, tables, default_tables, state):
      ...
        # Remove tables that were seen in join statements.
        table_stmts -= state.join_tables

        state.pop()

        result = ", ".join(sorted(table_stmts)+sorted(join_stmts))

        if half_join_stmts:
            result += " " + " ".join(sorted(half_join_stmts))

        return "".join(result)
   ...

SQL query with original version:
SELECT platforms.name, results.`time` FROM buffer_types, results, tests LEFT JOIN platforms ON results.platform = plat
forms.id WHERE tests.kernel_type = buffer_types.id AND buffer_types.name = %s AND tests.serial_no = results.test ORDER B
Y platforms.name ASC

Exception catched:
Exception in Tkinter callback
Traceback (most recent call last):
  File "C:\Python25\lib\lib-tk\Tkinter.py", line 1403, in __call__
    return self.func(*args)
  File "E:\current\milbench\current\BenchDBTool\source\ExportResultWindow.py", line 97, in search
    for res in results:
  File "C:\Python25\lib\site-packages\storm\store.py", line 1109, in values
    result = self._store._connection.execute(select)
  File "C:\Python25\lib\site-packages\storm\database.py", line 182, in execute
    raw_cursor = self.raw_execute(statement, params)
  File "C:\Python25\lib\site-packages\storm\database.py", line 247, in raw_execute
    raw_cursor.execute(statement, params)
  File "C:\Python25\lib\site-packages\MySQLdb\cursors.py", line 166, in execute
    self.errorhandler(self, exc, value)
  File "C:\Python25\lib\site-packages\MySQLdb\connections.py", line 35, in defaulterrorhandler
    raise errorclass, errorvalue
OperationalError: (1054, "Unknown column 'results.platform' in 'on clause'")

MODIFIED VERSION:
      ....
        # Remove tables that were seen in join statements.
        table_stmts -= state.join_tables

        state.pop()

        result = "(" + ", ".join(sorted(table_stmts)) + ")"
        result += ", ".join(sorted(join_stmts))
        if half_join_stmts:
            result += " " + " ".join(sorted(half_join_stmts))

        return "".join(result)
      ....
SQL query with modified version:
SELECT platforms.name, results.`time` FROM (buffer_types, results, tests) LEFT JOIN platforms ON results.platform = plat
forms.id WHERE tests.kernel_type = buffer_types.id AND buffer_types.name = %s AND tests.serial_no = results.test ORDER B
Y platforms.name ASC

Modified version work

See following documentation: http://dev.mysql.com/doc/refman/5.0/en/join.html