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 [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
