21,886
社区成员
发帖
与我相关
我的任务
分享
//现有如下sql:
SELECT c.c1,e.e1,c.c2,c.c3,e.e2,e.e3
FROM config e LEFT JOIN
(SELECT * FROM element WHERE pid = 1 ) c on c.eid = e.id
WHERE e.pid IN (SELECT pid FROM position WHERE id = 200)
AND e.is_del = 1 ORDER BY e.sort ASC,e.addtime DESC