Overview
You would like to craft a SQL query to perform a function such as purging held, unconfirmed, unapproved, expired, unsubscribed, or old referred members and need to know which fields have this information.
Information
Constructing custom SQL queries is outside the scope of Support. However, the information in this section will help you understand the fields in order to build your query. For additional field information see the Summary of the "lists_" fields in ListManager.
| Field | Description |
| CleanDays_ | After how many days a user is 'held' should we purge them (smallint, NOT NULL) |
| CleanUnsub_ | After how many days a user is 'unsub' should we purge them (smallint, NOT NULL) |
| ConfDays_ | How many days after a member has not confirmed to list should they be deleted (smallint, NOT NULL) |
| ExpireDays_ | How many days after a member has expired, should they be deleted (smallint, NOT NULL) |
| PrivDays_ | How many days after a member has applied to a private list, should they be deleted if not approved (smallint, NOT NULL) |
| ReferralPurgeDays_ | Purge referral data after how many days? (smallint, NOT NULL) |