home / pf

albums_labels

11 rows where label_id = 1441

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
4235 4235 3703 3703 Orchid Tapes 1441
4526 4526 3950 3950 Orchid Tapes 1441
8611 8611 7509 7509 Orchid Tapes 1441
8679 8679 7568 7568 Orchid Tapes 1441
10362 10362 9067 9067 Orchid Tapes 1441
10525 10525 9212 9212 Orchid Tapes 1441
11406 11406 9978 9978 Orchid Tapes 1441
11740 11740 10275 10275 Orchid Tapes 1441
11980 11980 10487 10487 Orchid Tapes 1441
12199 12199 10684 10684 Orchid Tapes 1441
13115 13115 11527 11527 Orchid Tapes 1441

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 78.27ms