Hey! I not sure if this is entirely possible in SQA and i'm more than open to suggestions for ways to improve the query itself but im looking to produce the following.
https://gist.github.com/mikeywaites/9e7290eaddcf003e4407 The thing in particular i'm having trouble with is the syntax for the nested joins. The below doesn't work but i thought it would serve as a start point for anyone able to help. https://gist.github.com/mikeywaites/59476c0fd91301b53697 Some related material i've found: https://bitbucket.org/zzzeek/sqlalchemy/issue/2120/support-nesting-of-joins-with-joined-eager http://docs.sqlalchemy.org/en/rel_0_9/changelog/migration_09.html#right-nested-inner-joins-available-in-joined-eager-loads So mostly its just the syntax of the nested joins im struggling with at the moment. I can't quite nail the alias + nesting combinations! Again, any suggestions on improving the query overall are more than welcome too!! Thanks! -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
