list_members

9 rows where list = 101619900

descending

Link	list	user
101619900,15607854	JSK-Fellows1995 101619900	MarshaMcFadden 15607854
101619900,16911536	JSK-Fellows1995 101619900	Amy Virshup 16911536
101619900,17787248	JSK-Fellows1995 101619900	Richard Gonzales NPR 17787248
101619900,28292957	JSK-Fellows1995 101619900	HuShuli \| 胡舒立 28292957
101619900,28293072	JSK-Fellows1995 101619900	who 28293072
101619900,30117765	JSK-Fellows1995 101619900	Marcelo Rubens Paiva 30117765
101619900,32129142	JSK-Fellows1995 101619900	Carol Rosenberg 32129142
101619900,230336117	JSK-Fellows1995 101619900	jane gross 230336117
101619900,376400826	JSK-Fellows1995 101619900	Bob Shaw 376400826

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