home / pf

albums_labels

21 rows where label_id = 239

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
355 355 304 304 Triple Crown 239
1009 1009 861 861 Triple Crown 239
1697 1697 1478 1478 Triple Crown 239
3486 3486 3046 3046 Triple Crown 239
3958 3958 3459 3459 Triple Crown 239
4262 4262 3727 3727 Triple Crown 239
5712 5712 4970 4970 Triple Crown 239
7469 7469 6498 6498 Triple Crown 239
7801 7801 6791 6791 Triple Crown 239
8224 8224 7166 7166 Triple Crown 239
8403 8403 7319 7319 Triple Crown 239
9240 9240 8081 8081 Triple Crown 239
9807 9807 8579 8579 Triple Crown 239
12047 12047 10546 10546 Triple Crown 239
12657 12657 11112 11112 Triple Crown 239
14021 14021 12357 12357 Triple Crown 239
15922 15922 14057 14057 Triple Crown 239
18099 18099 16021 16021 Triple Crown 239
22198 22198 19807 19807 Triple Crown 239
28671 28671 25877 25877 Triple Crown 239
29533 29533 26627 26627 Triple Crown 239

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