albums_labels

5 rows where label_id = 2156

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
7816 7816 6802 6802 Warner Music Group 2156
9903 9903 8661 8661 Warner Music Group 2156
10263 10263 8979 8979 Warner Music Group 2156
11299 11299 9882 9882 Warner Music Group 2156
11328 11328 9909 9909 Warner Music Group 2156

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