ODBC guide

Read a member by ID across all lists


Gets a specific member by ID (subscriber hash) across all lists. Use WHERE Id='...' and omit ListId.

SELECT * FROM ListMembers 
WHERE Id='170a0722daae03855d6434eb3a5959fb'