list_members

9 rows where list = 101287221

descending

Link	list	user
101287221,16672162	JSK-Fellows2000 101287221	Veronica Flores-Paniagua 16672162
101287221,17018840	JSK-Fellows2000 101287221	Kevin Sullivan 17018840
101287221,17455049	JSK-Fellows2000 101287221	George Haj 17455049
101287221,77842540	JSK-Fellows2000 101287221	Katherine Ellison 77842540
101287221,101255581	JSK-Fellows2000 101287221	Theo Stein 101255581
101287221,118957609	JSK-Fellows2000 101287221	Kim Norgaard 118957609
101287221,230879206	JSK-Fellows2000 101287221	Sean P. Murphy 230879206
101287221,1522716182	JSK-Fellows2000 101287221	Sarah T. Williams 1522716182
101287221,1892710843	JSK-Fellows2000 101287221	Rita Neubauer 1892710843

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