php - 如何获得每篇文章的浏览量？

Question

我有4张 table

articles
category
article_category
view

我需要找到每篇文章的浏览次数下面是我的sql查询

SELECT a.id,
(SELECT SUM(view) FROM view v ON v.aid=a.id) as view 
FROM articles a JOIN article_category ac ON a.id 
ON ac.aid JOIN category c ON c.id=ac.cid 
LEFT JOIN view cv ON v.aid=a.id GROUP BY a.id

我的问题是是否有其他方法可以不使用额外的 SELECT 查询？

Answer 1

看来您只需要从子查询中取出总和并使用它。

Select a.ID,SUM(cv.view)
FROM articles a 
JOIN article_category ac ON a.id = ac.aid 
JOIN category c ON c.id=ac.cid 
LEFT JOIN view cv ON v.aid=a.id GROUP BY a.id