ruby-on-rails - Ruby on Rails - 事件记录查询 - 返回只有图像的项目

Question

我正在重新开发一个网站，该网站在主页上有一个图像 slider ，显示 5 个最新的新闻故事，但是，我只希望它显示图像表中至少有一张图像的最新 5 个故事。

所以我的问题是，如何修改以下内容以返回五个带图像的记录:

@slider_stories = Story.published.all(:limit => 50, :include => [:images])

Answer 1

类似的东西

@slider_stories = Story.published.all(:limit => 50, :include => [:images], :conditions => "DISTINCT(stories.id), stories.*, images.*")

或

@slider_stories_ids = Image.all(:select => "DISTINCT(story_id)").map(&:story_id)
@slider_stories = Story.published.all(:limit => 50, :include => [:images], :conditions => {:id => @lider_stories_ids})