56,687
社区成员
发帖
与我相关
我的任务
分享
SELECT * from `user` `u` LEFT JOIN `form_id` `f` ON u.id = f.user_id
WHERE (`f`.`addtime` >= 6天前的时间) AND (`f`.`addtime` <= 3天前的时间)
ORDER BY `f`.`addtime` DESC LIMIT 20;
SELECT
`u`.`id`, `f`.`addtime` AS `f_addtime`
FROM `user` `u` LEFT JOIN `form_id` `f` ON f.user_id = u.id and f.type = 'form_id' and
NOT EXISTS(SELECT 1 FROM form_id ff
WHERE ff.user_id = f.user_id AND ff.type = 'form_id' AND ff.addtime >= 3天前的时间戳)
WHERE `f`.`type`='form_id' AND `f`.`addtime` >= 6天前的时间戳 AND `f`.`addtime` <= 3天前的时间戳
ORDER BY `f`.`addtime` DESC LIMIT 20
SELECT
*
FROM
USER u
WHERE
u.id != ANY ( SELECT DISTINCT f.user_id FROM form_id f WHERE f.addtime >= DATE_SUB( CURDATE( ), INTERVAL 3 DAY ) )