SELECT * FROM `order` where pay_status = 1 AND paytime BETWEEN '2019-06-11 00:00:01' AND '2019-06-11 23:59:59' AND order_type = 1 AND order_id NOT IN(SELECT order_id FROM `order` where pay_status = 1 AND paytime BETWEEN '2019-06-11 00:00:01' AND '2019-06-11 23:59:59' AND order_type = 1 GROUP BY userid)

这个sql 查询 一天 有没有买重复的 前几天都很好用 今天有反馈说漏了一个 我查了查 确实漏了

SELECT * FROM `order` where pay_status = 1 AND paytime BETWEEN '2019-06-11 00:00:01' AND '2019-06-11 23:59:59' AND order_type = 1 AND order_id

和

SELECT order_id FROM `order` where pay_status = 1 AND paytime BETWEEN '2019-06-11 00:00:01' AND '2019-06-11 23:59:59' AND order_type = 1 GROUP BY userid

的结果集差了1个，时间是在中午 条件也都符合 但是合起来的 那个sql 就查不出来
头一次遇见这种事，求大神 指教 或者说说可能是哪方面的问题