albums_labels

7 rows where label_id = 947

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
2302 2302 2003 2003 Dark Entries 947
3996 3996 3494 3494 Dark Entries 947
8375 8375 7297 7297 Dark Entries 947
9846 9846 8613 8613 Dark Entries 947
12035 12035 10535 10535 Dark Entries 947
12436 12436 10907 10907 Dark Entries 947
29908 29908 26946 26946 Dark Entries 947

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