albums_labels

8 rows where label_id = 3566

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
17761 17761 15699 15699 No Fun 3566
19705 19705 17551 17551 No Fun 3566
19729 19729 17574 17574 No Fun 3566
19826 19826 17667 17667 No Fun 3566
20445 20445 18209 18209 No Fun 3566
20519 20519 18280 18280 No Fun 3566
21270 21270 18959 18959 No Fun 3566
21743 21743 19391 19391 No Fun 3566

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