list_members

3 rows where user = 48193439 sorted by user

descending

Link	list	user ▼
97640575,48193439	JSK@ONA13 97640575	drigarcia 48193439
92193784,48193439	JSK-Fellows2013 92193784	drigarcia 48193439
29527592,48193439	JSK Alumni Network 29527592	drigarcia 48193439

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])
);