diff -r --unified roundup-orderprop/backends/back_mysql.py roundup-with-fix/backends/back_mysql.py
--- roundup-orderprop/backends/back_mysql.py	2006-01-13 17:04:02.627857303 +0100
+++ roundup-with-fix/backends/back_mysql.py	2006-01-13 17:03:07.651311101 +0100
@@ -688,9 +688,9 @@
                     op = link.orderprop ()
                     if op != 'id':
                         tn = '_' + lcn
-                        loj.append('LEFT OUTER JOIN %s on %s=%s.id'%(tn,
-                            o, tn))
-                        o = tn + '._%s'%op
+                        loj.append('LEFT OUTER JOIN %s as rhs_ on %s=rhs_.id'
+                                  %(tn, o))
+                        o = 'rhs_._%s'%op
                     ordercols.append(o)
                 elif prop == 'id':
                     o = '_%s.id'%cn
diff -r --unified roundup-orderprop/backends/rdbms_common.py roundup-with-fix/backends/rdbms_common.py
--- roundup-orderprop/backends/rdbms_common.py	2006-01-13 17:04:02.628857167 +0100
+++ roundup-with-fix/backends/rdbms_common.py	2006-01-13 08:29:20.000000000 +0100
@@ -2189,9 +2189,9 @@
                     op = link.orderprop()
                     if op != 'id':
                         tn = '_' + lcn
-                        loj.append('LEFT OUTER JOIN %s on %s=%s.id'%(tn,
-                            o, tn))
-                        o = tn + '._%s'%op
+                        loj.append('LEFT OUTER JOIN %s as rhs_ on %s=rhs_.id'
+                                  %(tn, o))
+                        o = 'rhs_._%s'%op
                     ordercols.append(o)
                 elif prop == 'id':
                     o = '_%s.id'%cn