home / pf

albums_labels

25 rows where label_id = 433

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
743 743 629 629 Fiction 433
915 915 780 780 Fiction 433
1183 1183 1018 1018 Fiction 433
3612 3612 3150 3150 Fiction 433
3749 3749 3270 3270 Fiction 433
8633 8633 7528 7528 Fiction 433
9788 9788 8564 8564 Fiction 433
12147 12147 10638 10638 Fiction 433
13892 13892 12244 12244 Fiction 433
14203 14203 12528 12528 Fiction 433
14462 14462 12773 12773 Fiction 433
14980 14980 13227 13227 Fiction 433
15339 15339 13550 13550 Fiction 433
16219 16219 14321 14321 Fiction 433
16453 16453 14527 14527 Fiction 433
16777 16777 14815 14815 Fiction 433
17408 17408 15380 15380 Fiction 433
17409 17409 15381 15381 Fiction 433
18936 18936 16789 16789 Fiction 433
19922 19922 17754 17754 Fiction 433
20099 20099 17908 17908 Fiction 433
20928 20928 18647 18647 Fiction 433
21118 21118 18823 18823 Fiction 433
21212 21212 18906 18906 Fiction 433
29831 29831 26882 26882 Fiction 433

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