21,886
社区成员
发帖
与我相关
我的任务
分享
$lis3t = M()->query("SELECT *,SUM(j.fenzhi) as num FROM qf_jiangkou AS j INNER JOIN `qf_member` AS m ON rtrim(m.id) LIKE CONCAT ('%',j.mid,'%') where j.time between '2016-01-01' and '2019-12-01' GROUP BY m.id ORDER BY num desc");