Logged In: YES 
user_id=150272

In MySQL 5.0, the LEFT JOIN syntax is more strict.  I fixed
this by patching back_mysql.py to wrap the tables in the
FROM clause in parentheses (see below).  I have no idea
whether this works for previous versions of MySQL, but it
works for 5.0:

***
/cygdrive/d/incoming/roundup-1.1.2/roundup/backends/back_mysql.py
Wed Apr 26 22:40:19 2006
--- back_mysql.py	Tue Aug 15 13:16:04 2006
***************
*** 783,789 ****
              order = ''
          cols = ','.join(cols)
          loj = ' '.join(loj)
!         sql = 'select %s from %s %s %s%s'%(cols, frum,
loj, where, order)
          args = tuple(args)
          self.db.sql(sql, args)
          l = self.db.cursor.fetchall()
--- 783,789 ----
              order = ''
          cols = ','.join(cols)
          loj = ' '.join(loj)
!         sql = 'select %s from (%s) %s %s%s'%(cols, frum,
loj, where, order)
          args = tuple(args)
          self.db.sql(sql, args)
          l = self.db.cursor.fetchall()