home / pf

albums_labels

12 rows where label_id = 3451

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
16899 16899 14928 14928 Holy Mountain 3451
18794 18794 16663 16663 Holy Mountain 3451
19634 19634 17481 17481 Holy Mountain 3451
20804 20804 18534 18534 Holy Mountain 3451
21003 21003 18717 18717 Holy Mountain 3451
21827 21827 19464 19464 Holy Mountain 3451
22629 22629 20199 20199 Holy Mountain 3451
23130 23130 20661 20661 Holy Mountain 3451
23959 23959 21447 21447 Holy Mountain 3451
25266 25266 22691 22691 Holy Mountain 3451
25907 25907 23304 23304 Holy Mountain 3451
27791 27791 25075 25075 Holy Mountain 3451

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