Question

我认为,我已经与Joins达成了目前的限制。目前,我有以下MySQL问题,正在做罚款:

SELECT blog.id, blog.title, blog.post, blog.date, blog.time,
       count(blog_comment.b_id) CommCount
FROM blog 
LEFT JOIN blog_comment ON blog.id = blog_comment.b_id
GROUP BY blog.id
ORDER BY id DESC
LIMIT $start_blog, $blog_per_page

这将显示一个博客员额清单,显示每个员额的评论数目、评论和简单。

就行政小组而言,我要显示博客员额,然后列出对每个员额的评论数目,然后是显示待评论数目的新领域。

待决意见存放在博客中。待决(1份待决,0份待决)

我看不出如何做。

Answer 1

为此:

SELECT blog.id, blog.title, blog.post, blog.date, blog.time, 
       count(blog_comment.b_id) CommCount,
       sum(blog_comment.pending) PendingComments
FROM blog 
LEFT JOIN blog_comment ON blog.id = blog_comment.b_id 
GROUP by blog.id 
ORDER BY id DESC LIMIT $start_blog , $blog_per_page

概要将仅增加pending states...

友情链接