sqlalchemy的order_by使用

问题：sqlalchemy中的order by 如何使用
解决：
topics = self.db.query(ForumTopic.title,ForumTopic.browse,ForumTopic.reply
,ForumTopic.created,Subject.name,ForumTopic.id,ForumTopic.subject_id)
.filter(ForumTopic.subject_id == Subject.id, ForumTopic.status == 1) .order_by('created desc') .offset((currentPage-1)*pageSize).limit(10) .options(FromCache()).all() 注：如果是两表联查就不能用字符串写了 result = self.db.query(A, B).filter(A.id == B.aid).order_by(A.id.desc()).all()