mysql - 与右表中的 where 进行左连接

Question

我有这个连接:表 mmp_user 151 位用户表 MMP_MMPUBLISH_LOG URL 的访问

    select user.name as 'Usuário',count(log.referer) as 'Número de Acessos'
from mmp_user user
left JOIN MMP_MMPUBLISH_LOG log on (user.id=log.user_id)
where log.event_date between '2015-08-01' and '2015-08-08'
group by user.id
order by count(log.referer) desc

预期结果:151 行获得的结果:11行

请帮帮我

Answer 1

试试这个

SELECT u.name as 'Usuário',count(log.referer) as 'Número de Acessos'
FROM mmp_user u
LEFT JOIN (
    SELECT user_id, referer
    FROM MMP_MMPUBLISH_LOG
    WHERE event_date BETWEEN '2015-08-01' AND '2015-08-08'
) log ON u.id=log.user_id
group by u.id
order by count(log.referer) desc

ps。下次不要使用“用户”，不清楚