albums_labels

4 rows where album_id = 6248

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
7177 7177 6248 6248 No World 2043
7178 7178 6248 6248 Quality Time 1757
7179 7179 6248 6248 Handsome Dad 2044
7180 7180 6248 6248 Big Oil  2045

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