list_members

2 rows where user = 24346858

descending

Link	list	user
29527592,24346858	JSK Alumni Network 29527592	J. Mariani-Belding 24346858
101267776,24346858	JSK-Fellows2003 101267776	J. Mariani-Belding 24346858

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE [list_members] (
   [list] INTEGER REFERENCES [lists]([id]),
   [user] INTEGER REFERENCES [users]([id]),
   PRIMARY KEY ([list], [user])
);