Ok, that worked perfectly! If I want *all* of the "Thing" object, I change it to this:
q = s.query(Thing, func.count(Comment.type)).\ filter(Thing.creation >= datetime.date(2015, 4, 19)).\ filter(Thing.creation < datetime.date(2015, 4, 26)).\ filter(Comment.target_id == Thing.id).\ filter(Comment.creation >= datetime.date(2015, 4, 19)).\ filter(Comment.creation < datetime.date(2015, 4, 26)).\ filter(Comment.type == 5).\ group_by(Thing.id).\ order_by(func.count(Comment.type).desc()) I get the original problem. Is there a way to accomplish that without specifying the columns by hand? -- 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 sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.