in改join后结果不一样

[elite2018]

SELECT aa
FROM f left join c on c.p_id = f.sid and f.create_time in(SELECT create_time from f WHERE create_time BETWEEN c.start_time and DATE_ADD(c.end_time,INTERVAL 2 DAY))
left join a on a.id = f.sId
left join b on a.userId = b.userId
WHERE
c.pyramid_id = 292
GROUP BY
c.classNo
ORDER BY
c.termId desc;
改写成以下格式后，有点问题：
SELECT
aa
FROM
f left join c on c.p_id = f.sid and f.create_time BETWEEN c.start_time and DATE_ADD(c.end_time,INTERVAL 2 DAY)
left join a on a.id = f.sId
left join b on a.userId = b.userId
WHERE
c.p_id = 292
GROUP BY
c.classNo
ORDER BY
c.termId desc;


第三行一个显示 2018-09-10，一个显示12-22日，为什么结果不一样？

[吉普赛的歌]

看你的业务逻辑吧。 个人认为下面的要合理一点。