Answers.Body: <p>That information is contained in the table civicrm_subscription_history</p>
  
  <p>To remove them from those regular groups you would need to remove them from both the civicrm_subscription_history table and the civicrm_group_contact table</p>
  
  <p>Seamus</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-06-25T02:48:28.880Z
Answers.Text: but nothing via the UI or an extension eh?
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-08-01T23:38:04.910Z
Answers.LastActivityDate: 2017-08-01T23:38:04.910Z
Answers.UserDisplayName: Seamus Lee
Body: <p>I'm trying to help a friend. A slew of his contact records got added to groups that they don't belong in. It happened on July 19th. I thought the civicrm_group_contact table would have a timestamp column, but I don't see one. Where is this Date Added stored (see below)? Is there a way to select these group records and delete them? Thanks...</p>
  
  <p><a href="https://i.sstatic.net/rx1oa.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/rx1oa.png" alt="enter image description here"></a></p>
  
Tags: <groups>
Title: Where in the database is the Date Added for Group records?
ThreadText: # Where in the database is the Date Added for Group records?
  
  (Asked by: username_0 on 2017-08-01)
  
  I'm trying to help a friend. A slew of his contact records got added to groups that they don't belong in. It happened on July 19th. I thought the civicrm\_group\_contact table would have a timestamp column, but I don't see one. Where is this Date Added stored (see below)? Is there a way to select these group records and delete them? Thanks...
  
  [![enter image description here](https://i.sstatic.net/rx1oa.png)](https://i.sstatic.net/rx1oa.png)
  
  **Tags:** groups
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2017-08-01. Score: 3 | Accepted answer
  
  That information is contained in the table civicrm\_subscription\_history
  
  To remove them from those regular groups you would need to remove them from both the civicrm\_subscription\_history table and the civicrm\_group\_contact table
  
  username_1
  
  > **Comments:**
  > **username_2**: but nothing via the UI or an extension eh?  
  
  ---
  
  