I got it:
>> from sqlalchemy.sql import func
>> stmt = session.query(Prod.store_id,
>> func.count('*').label('prod_count')).group_by(Prod.store_id).subquery()
>> obj_q = session.query(Store, stmt.c.prod_count).outerjoin(
(stmt,
Store.id==stmt.c.store_id)).order_by(stmt.c.prod_count.desc())
Voil`a!
Cheers,
Sandor
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
