Body: <p>Here is the scenario...</p>
  <p>Person registers twice for an event using different emails. We merge the contact, they show up as being registered twice for the event. No big deal, we delete the extra registration. Everything looks good in the system.</p>
  <p>Except, when I run a search in searchkit, the person shows up twice.</p>
  <p>Is my search incorrectly setup, or is the system pulling the deleted information somehow. This happens to happen when I also want website information to also appear. If I remove the website info, it appears correctly.</p>
  <p>Below is my search query.</p>
  <pre><code>{
    &quot;version&quot;: 4,
    &quot;select&quot;: [
      &quot;display_name&quot;,
      &quot;first_name&quot;,
      &quot;last_name&quot;,
      &quot;employer_id.display_name&quot;,
      &quot;Contact_Website_contact_id_01.url&quot;,
      &quot;Custom_Fields.Sector:label&quot;,
      &quot;Custom_Fields.Industry:label&quot;,
      &quot;Contact_Participant_contact_id_01.register_date&quot;,
      &quot;Contact_Participant_contact_id_01.role_id:label&quot;,
      &quot;Contact_Participant_contact_id_01.status_id:label&quot;
    ],
    &quot;orderBy&quot;: [],
    &quot;where&quot;: [
      [
        &quot;contact_type:name&quot;,
        &quot;=&quot;,
        &quot;Individual&quot;
      ]
    ],
    &quot;groupBy&quot;: [],
    &quot;join&quot;: [
      [
        &quot;Participant AS Contact_Participant_contact_id_01&quot;,
        &quot;INNER&quot;,
        [
          &quot;id&quot;,
          &quot;=&quot;,
          &quot;Contact_Participant_contact_id_01.contact_id&quot;
        ],
        [
          &quot;Contact_Participant_contact_id_01.event_id&quot;,
          &quot;=&quot;,
          &quot;\&quot;12\&quot;&quot;
        ],
        [
          &quot;Contact_Participant_contact_id_01.status_id:name&quot;,
          &quot;=&quot;,
          &quot;\&quot;Registered\&quot;&quot;
        ]
      ],
      [
        &quot;Website AS Contact_Website_contact_id_01&quot;,
        &quot;LEFT&quot;,
        [
          &quot;id&quot;,
          &quot;=&quot;,
          &quot;Contact_Website_contact_id_01.contact_id&quot;
        ],
        [
          &quot;Contact_Website_contact_id_01.url&quot;,
          &quot;IS NOT EMPTY&quot;
        ]
      ]
    ],
    &quot;having&quot;: []
  }
  </code></pre>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-01-25T23:25:54.077Z
Comments.Text: Does the contact have 2 websites?
Comments.UserDisplayName: Aidan
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-01-30T16:42:14.657Z
Comments.Text: Hi @Aidan thank you - I thats the answer!
Comments.UserDisplayName: themak
Tags: <searchkit>
Title: How do I stop searchkit from displaying a deleted event registration
ThreadText: # How do I stop searchkit from displaying a deleted event registration
  
  (Asked by: username_0 on 2023-01-25)
  
  Here is the scenario...
  Person registers twice for an event using different emails. We merge the contact, they show up as being registered twice for the event. No big deal, we delete the extra registration. Everything looks good in the system.
  Except, when I run a search in searchkit, the person shows up twice.
  Is my search incorrectly setup, or is the system pulling the deleted information somehow. This happens to happen when I also want website information to also appear. If I remove the website info, it appears correctly.
  Below is my search query.
  {
    "version": 4,
    "select": [
      "display_name",
      "first_name",
      "last_name",
      "employer_id.display_name",
      "Contact_Website_contact_id_01.url",
      "Custom_Fields.Sector:label",
      "Custom_Fields.Industry:label",
      "Contact_Participant_contact_id_01.register_date",
      "Contact_Participant_contact_id_01.role_id:label",
      "Contact_Participant_contact_id_01.status_id:label"
    ],
    "orderBy": [],
    "where": [
      [
        "contact_type:name",
        "=",
        "Individual"
      ]
    ],
    "groupBy": [],
    "join": [
      [
        "Participant AS Contact_Participant_contact_id_01",
        "INNER",
        [
          "id",
          "=",
          "Contact_Participant_contact_id_01.contact_id"
        ],
        [
          "Contact_Participant_contact_id_01.event_id",
          "=",
          "\"12\""
        ],
        [
          "Contact_Participant_contact_id_01.status_id:name",
          "=",
          "\"Registered\""
        ]
      ],
      [
        "Website AS Contact_Website_contact_id_01",
        "LEFT",
        [
          "id",
          "=",
          "Contact_Website_contact_id_01.contact_id"
        ],
        [
          "Contact_Website_contact_id_01.url",
          "IS NOT EMPTY"
        ]
      ]
    ],
    "having": []
  }
  
  **Tags:** searchkit
  
  > **Comments:**
  > **username_1**: Does the contact have 2 websites?  
  > **username_0**: Hi @username_1 thank you - I thats the answer!  
  
  ---
  
  ## 0 answers
  
  