我试图收集昨天我的cp中不同的访问次数,然后统计它们.
SELECT
DISTINCT `user_id` as user,
`site_id` as site,
`ts` as time
FROM
`cp_visits`
WHERE
ts >= DATE_SUB(NOW(), INTERVAL 1 DAY)
出于某种原因,这是拉多个结果与相同的网站id....我如何只提取和统计不同的站点id cp登录?
我试图收集昨天我的cp中不同的访问次数,然后统计它们.
SELECT
DISTINCT `user_id` as user,
`site_id` as site,
`ts` as time
FROM
`cp_visits`
WHERE
ts >= DATE_SUB(NOW(), INTERVAL 1 DAY)
出于某种原因,这是拉多个结果与相同的网站id....我如何只提取和统计不同的站点id cp登录?
Select
Count(Distinct user_id) As countUsers
, Count(site_id) As countVisits
, site_id As site
From cp_visits
Where ts >= DATE_SUB(NOW(), INTERVAL 1 DAY)
Group By site_id