albums_labels

9 rows where label_id = 3585

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
17895 17895 15828 15828 Gigantic 3585
18711 18711 16592 16592 Gigantic 3585
19517 19517 17367 17367 Gigantic 3585
19619 19619 17466 17466 Gigantic 3585
20790 20790 18521 18521 Gigantic 3585
21098 21098 18805 18805 Gigantic 3585
21337 21337 19023 19023 Gigantic 3585
22679 22679 20243 20243 Gigantic 3585
24090 24090 21572 21572 Gigantic 3585

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)
);