Read a list member by ID

Gets a single member by subscriber hash ID. Provide ListId in the WITH clause and Id in WHERE or WITH.

SELECT * FROM ListMembers 
WHERE Id='170a0722daae03855d6434eb3a5959fb' 
WITH (ListId='e246f7e24d')