home / pf

albums_labels

7 rows where label_id = 3199

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
14874 14874 13136 13136 TBD 3199
15808 15808 13955 13955 TBD 3199
16307 16307 14402 14402 TBD 3199
17003 17003 15023 15023 TBD 3199
17061 17061 15077 15077 TBD 3199
18160 18160 16077 16077 TBD 3199
18657 18657 16540 16540 TBD 3199

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