home / pf

albums_labels

9 rows where label_id = 131

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
154 154 132 132 Peaceville 131
272 272 236 236 Peaceville 131
714 714 602 602 Peaceville 131
4115 4115 3606 3606 Peaceville 131
4521 4521 3945 3945 Peaceville 131
8430 8430 7344 7344 Peaceville 131
13547 13547 11930 11930 Peaceville 131
20411 20411 18177 18177 Peaceville 131
23160 23160 20691 20691 Peaceville 131

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