mysql - 无法弄清楚mysql查询

Question

我是 PHP 和 MySQL 的新手 -> 我还不太好。今天我遇到了这个问题。我有一个连接 2 个表“投票”和“故事”的查询在这里:

SELECT stories.*, SUM(votes.vote_value) as 'total_votes' 
FROM stories JOIN votes ON stories.id = votes.item_name WHERE stories.st_date >= DATE_SUB(NOW(), INTERVAL 32 DAY) 
GROUP BY stories.id 
ORDER BY total_votes ASC LIMIT 10

我需要对其进行修改，使其仅从字段showing = 1

的“stories”表中选择信息

一个简单的查询看起来像这样:

SELECT * FROM stories WHERE showing = 1

但我不知道如何在连接两个数据库的第一个查询中实现它。

Answer 1

SELECT stories.*, SUM(votes.vote_value) as 'total_votes' 
FROM stories, votes 
WHERE stories.id = votes.item_name AND stories.showing = 1 AND stories.st_date >= DATE_SUB(NOW(), INTERVAL 32 DAY)
GROUP BY stories.id 
ORDER BY total_votes ASC LIMIT 10