56,679
社区成员
发帖
与我相关
我的任务
分享
SELECT COUNT(a.uid) AS last_1_2_count FROM
(
SELECT DISTINCT uid,MAX(hfdate) AS max_hfdate,POSITION,checked FROM hrdk.dk_hf GROUP BY uid
) AS a
WHERE (a.max_hfdate BETWEEN UNIX_TIMESTAMP(DATE_SUB(CURDATE(),INTERVAL 2 DAY)) AND UNIX_TIMESTAMP(DATE_SUB(CURDATE(),INTERVAL 1 DAY)))
AND a.position>0 AND a.checked=2
SELECT COUNT(a.uid) AS last_1_2_count FROM
(
SELECT DISTINCT uid,MAX(hfdate) AS max_hfdate,POSITION,checked FROM hrdk.dk_hf WHERE POSITION>0 AND checked=2 GROUP BY uid
HAVING max_hfdate BETWEEN UNIX_TIMESTAMP(DATE_SUB(CURDATE(),INTERVAL 2 DAY)) AND UNIX_TIMESTAMP(DATE_SUB(CURDATE(),INTERVAL 1 DAY))
)
AS a