我有这个加入:表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行
请帮帮我
试试这个
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。下次不使用“用户”,目前尚不清楚
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句