list_members

12 rows where list = 101201079

descending

Link	list	user
101201079,10794392	JSK-Fellows2007 101201079	Kathleen McCoy 10794392
101201079,18197783	JSK-Fellows2007 101201079	Leslie Casimir 18197783
101201079,20253808	JSK-Fellows2007 101201079	Andrea Bernstein 20253808
101201079,20932059	JSK-Fellows2007 101201079	Imtiaz Ali 20932059
101201079,34827824	JSK-Fellows2007 101201079	Justine Gubar 34827824
101201079,48140747	JSK-Fellows2007 101201079	Patricia Mercado S. 48140747
101201079,55273455	JSK-Fellows2007 101201079	Christianne Gonzalez 55273455
101201079,96941094	JSK-Fellows2007 101201079	Andrew M. Mwenda 96941094
101201079,139161166	JSK-Fellows2007 101201079	Kevin Fagan 139161166
101201079,197544399	JSK-Fellows2007 101201079	Pete McBride 197544399
101201079,331451880	JSK-Fellows2007 101201079	Karl Vick 331451880
101201079,341118458	JSK-Fellows2007 101201079	Eric Schmitt 341118458

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