list_members

3 rows where user = 48068105

descending

Link	list	user
29527592,48068105	JSK Alumni Network 29527592	Beth Daley 48068105
91839852,48068105	JSK-Fellows2012 91839852	Beth Daley 48068105
197719925,48068105	NICAR15 197719925	Beth Daley 48068105

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