list_members

4 rows where user = 306428731

descending

Link	list	user
76545315,306428731	JSK ONA14 76545315	Martin Kotynek 306428731
93929292,306428731	JSK-Fellows2014 93929292	Martin Kotynek 306428731
97640575,306428731	JSK@ONA13 97640575	Martin Kotynek 306428731
219853736,306428731	JSKONA15 219853736	Martin Kotynek 306428731

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