select a.id,a.userid,c.openid from ko_answer_score a left join (select userid from ko_answer_log where answer_time > '2018-02-24 00:00:00' and answer_time < '2018-02-24 23:59:59' group by userid) b on a.userid=b.userid where b.userid is null
比not in快很多