home / pf

albums_labels

14 rows where label_id = 424

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
725 725 612 612 American Dreams 424
1196 1196 1029 1029 American Dreams 424
1667 1667 1450 1450 American Dreams 424
2086 2086 1816 1816 American Dreams 424
2439 2439 2125 2125 American Dreams 424
2490 2490 2172 2172 American Dreams 424
3453 3453 3018 3018 American Dreams 424
3773 3773 3294 3294 American Dreams 424
29377 29377 26489 26489 American Dreams 424
29583 29583 26671 26671 American Dreams 424
29741 29741 26804 26804 American Dreams 424
29854 29854 26901 26901 American Dreams 424
30142 30142 27162 27162 American Dreams 424
30420 30420 27411 27411 American Dreams 424

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