list_members

2 rows where user = 2400471 sorted by list

descending

Link	list ▼	user
76545315,2400471	JSK ONA14 76545315	Kaizar Campwala 2400471
97640575,2400471	JSK@ONA13 97640575	Kaizar Campwala 2400471

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