session.query(User).order_by(desc(select([func.count(1)], user_subscriptions_table.c.user_id==users_table.c.id)))