class OperatorNetwork < ActiveRecord::Base
  has_many :operator_accesses

  def find_all_exclusively_contained_physical_address_ids
    PhysicalAddress.find_by_sql("SELECT DISTINCT p.id FROM physical_addresses p, operator_accesses a WHERE p.id=a.physical_address_id AND a.operator_network_id=#{self.id} AND p.id NOT IN (SELECT DISTINCT p.id FROM physical_addresses p, operator_accesses a WHERE p.id=a.physical_address_id AND a.operator_network_id != #{self.id}) ORDER BY p.id")
  end

end