remove_federal_for_company.rb

company_id = 13011776
real_regions = Company.find(company_id).region_ids_for_binding.join(',')
ActiveRecord::Base.connection.execute <<-SQL
  UPDATE product_regions prs SET is_deleted = true, is_public = false
  FROM (
    SELECT pr.id FROM products p JOIN product_regions pr ON p.id = pr.product_id
       AND p.company_id = #{company_id}
       AND pr.is_deleted IS false
     WHERE pr.region_id NOT IN (#{real_regions})) t WHERE t.id = prs.id;
SQL