list_members

3 rows where user = 264340567

descending

Link	list	user
29527592,264340567	JSK Alumni Network 29527592	T. Christian Miller 264340567
91839852,264340567	JSK-Fellows2012 91839852	T. Christian Miller 264340567
197719925,264340567	NICAR15 197719925	T. Christian Miller 264340567

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