getting things to join without subqueries, but some glitches in the compiler step

when we do query.count() are showing

1 files changed, 8 insertions, 3 deletions

diff --git a/lib/sqlalchemy/sql/compiler.py b/lib/sqlalchemy/sql/compiler.py
index 030d6dce9..27e883c86 100644
--- a/lib/sqlalchemy/sql/compiler.py
+++ b/lib/sqlalchemy/sql/compiler.py
@@ -1095,14 +1095,19 @@ class SQLCompiler(engine.Compiled):
                     c._label = c._key_label = c.name
 
                 elem.right = selectable
-                adapters.append(
-                        sql_util.ClauseAdapter(selectable,
+                import pdb
+                pdb.set_trace()
+                adapter = sql_util.ClauseAdapter(selectable,
                                         traverse_options=traverse_options)
-                )
+                adapter.__traverse_options__.pop('stop_on')
+                adapters.append(adapter)
 
         select = visitors.cloned_traverse(select,
                                     traverse_options, {"join": visit_join})
 
+        if adapters:
+            import pdb
+            pdb.set_trace()
         for adap in reversed(adapters):
             select = adap.traverse(select)
         return select