albums_labels

4 rows where album_id = 13121

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
14853 14853 13121 13121 DD172 3193
14854 14854 13121 13121 BluRoc 3183
14855 14855 13121 13121 Jets International 3194
14856 14856 13121 13121 Tower Chime 3195

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