37,719
社区成员
发帖
与我相关
我的任务
分享python sqlalchemy orm语句求教
SELECT * FROM task INNER JOIN user ON task.user_id = user.gid LEFT OUTER JOIN crm_user ON task.user_id = crm_user.user_id INNER JOIN staff ON task.recommend_teacher = staff.gid
WHERE task.gid IN (SELECT t.gid
FROM (select * from task
WHERE task.deleted IS false AND task.recommended IS true ORDER BY task.recommend_time DESC LIMIT 50) as t)
order by task.recommend_time desc
WHERE task.gid IN (SELECT t.gid
FROM (select * from task
WHERE task.deleted IS false AND task.recommended IS true ORDER BY task.recommend_time DESC LIMIT 50) as t)
order by task.recommend_time desc
...全文
请发表友善的回复…
发表回复
k826416971 2018-05-02
- 打赏
- 举报
将这个sql语句转化为sqlalchemy的orm语句
