Skip to content

Instantly share code, notes, and snippets.

@poustovitss

poustovitss/sql query

Created July 30, 2018 10:20
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save poustovitss/52141f3699e01e2d4ffd3f97642b72f7 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save poustovitss/52141f3699e01e2d4ffd3f97642b72f7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sql query
forum_ids = [1,2,3] # given forum ids
forum_ids.map do |forum_id|
Post.joins(:topic).where(topics: { forum: forum_id }).pluck(:subject, 'posts.*').last
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment