gistfile1.sql

##
    Article.find_by_sql("SELECT DISTINCT articles.* FROM articles INNER JOIN taggings ON taggings.taggable_id = articles.id WHERE taggings.tag_id = #{id} AND taggings.taggable_type = 'Article' AND articles.deleted_at IS NULL ORDER BY articles.id DESC LIMIT 5;")
##
    Article.find_by_sql("SELECT DISTINCT articles.* FROM articles INNER JOIN taggings ON taggings.taggable_id = articles.id WHERE taggings.tag_id = #{id} AND taggings.taggable_type = 'Article' AND articles.deleted_at IS NULL ORDER BY articles.score DESC LIMIT 5;")
##
    Article.find_by_sql(["SELECT DISTINCT articles.* FROM articles INNER JOIN taggings ON taggings.taggable_id = articles.id WHERE taggings.tag_id = #{id} AND taggings.taggable_type = 'Article' AND articles.deleted_at IS NULL AND articles.created_at > ? ORDER BY articles.comments_count DESC LIMIT 5;", 5.days.ago])
##
    Article.find_by_sql(["SELECT DISTINCT articles.* FROM articles INNER JOIN taggings ON taggings.taggable_id = articles.id WHERE taggings.tag_id = #{id} AND taggings.taggable_type = 'Article' AND articles.deleted_at IS NULL AND articles.created_at > ? ORDER BY articles.hit_count DESC LIMIT 5;", 5.days.ago])
  end