albums_labels

9 rows where label_id = 8

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
9 9 9 9 KGLW 8
10 10 10 10 KGLW 8
11 11 11 11 KGLW 8
837 837 709 709 KGLW 8
1895 1895 1655 1655 KGLW 8
2273 2273 1977 1977 KGLW 8
2274 2274 1978 1978 KGLW 8
29704 29704 26772 26772 KGLW 8
30116 30116 27137 27137 KGLW 8

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