mysql - 在Mysql查询中， 'GROUP BY'答案数量和待处理的=' '

Question

我有一个数据库，其中包含问题和答案(用户表以及下面的查询引用)表。我目前正在执行查询:

SELECT questions.*,COUNT(answers.questionid) as num_answers,users.username 
FROM questions LEFT JOIN answers ON questions.questionid = answers.questionid 
LEFT JOIN users ON questions.userid = users.userid 
WHERE questions.pending=''  
GROUP BY questions.questionid

上面的查询可以让我获取问题详细信息，并且我计算了答案的数量。但是，我想包含answers.pending='' 的答案，这样当我获得答案计数时，它只显示已批准的答案。

我需要在查询中添加什么才能使其正常工作？

Answer 1

根据您的问题，您需要answers.pending=''

SELECT questions.*,COUNT(answers.questionid) as num_answers,users.username 
FROM questions LEFT JOIN answers ON questions.questionid = answers.questionid 
LEFT JOIN users ON questions.userid = users.userid 
WHERE questions.pending='' and  answers.pending=''
GROUP BY questions.questionid

使用上面的查询