@daviddavis @bbuckingham I did some hacking and:
```ruby
ContentView.scope :promoted do |safe = false|
  relation = self.joins(:environments).group('"content_views"."id"').having('count("environment"."id") > 1') 
  if safe
     self.where :id => relation.all.map(&:id)
  else
    relation
  end
end

class ContentViewDefinition
  def has_promoted_views?
    !! self.content_views.promoted.first
  end
end