home / pf

albums_labels

12 rows where label_id = 3181

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
14803 14803 13073 13073 Friendly Fire 3181
15490 15490 13687 13687 Friendly Fire 3181
16425 16425 14505 14505 Friendly Fire 3181
16670 16670 14716 14716 Friendly Fire 3181
16702 16702 14745 14745 Friendly Fire 3181
16970 16970 14991 14991 Friendly Fire 3181
17016 17016 15035 15035 Friendly Fire 3181
17843 17843 15777 15777 Friendly Fire 3181
18317 18317 16223 16223 Friendly Fire 3181
19013 19013 16866 16866 Friendly Fire 3181
22564 22564 20138 20138 Friendly Fire 3181
25256 25256 22682 22682 Friendly Fire 3181

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE albums_labels (
	album_id integer NOT NULL,
	label_id integer NOT NULL,
	FOREIGN KEY(album_id) REFERENCES albums(id),
	FOREIGN KEY(label_id) REFERENCES labels(id),
	UNIQUE(album_id,label_id)
);
Powered by Datasette · Queries took 55.624ms