find-landing-pages.rb

Admin::Project.where("landing_page_content LIKE '%renderMaterialsCollection(101%'")

list-non-official-resources.rb

non_cohort_resources = []
ExternalActivity.where(is_official: false, publication_status: "published").find_each{|r| non_cohort_resources << r if r.cohorts.blank?}; nil

puts "name, id, link, times assigned, assignment 1, assignment 2, assignment 3, assignment 4, assignment 5"

non_cohort_resources.select{|r| r.offerings.length > 9}.each{ |r| 
  sorted_offerings = r.offerings.map{|o| o.created_at.strftime("%Y-%m-%d")}.sort 
  row = [
    "\"#{r.name}\"",
    r.id,
    "https://learn.concord.org/resources/#{r.id}",
    r.offerings.length
  ]
  row += sorted_offerings[-5..-1]
  puts row.join(", ")
}; nil