InvitationFilteringBySQL

pa_ids = Invitation.find_by_sql(<<-SQL)
  SELECT profile_administrations.id AS profile_administration_id
  FROM invitations
  INNER JOIN invitation_batches ON
    invitation_batches.id = invitations.invitation_batch_id
  INNER JOIN people ON
    people.id = invitations.invitee_id
  INNER JOIN profiles ON profiles.subject_id = people.id
  INNER JOIN profile_administrations ON
    profile_administrations.profile_id = profiles.id
    AND profile_administrations.primary = 1
  WHERE
    invitation_batches.invitation_type_name = 'action_invitation'
    AND invitation_batches.target_type = 'Action'
    AND invitation_batches.target_id = #{action_id}
    AND invitation_batches.created_at > '#{beginning_of_day.to_s(:db)}'
  GROUP BY profile_administrations.id
  HAVING COUNT(*) > 2
SQL

pa_ids.each do |pa_id|
  profile_administrations_map.delete(pa_id.profile_administration_id)
end