albums_labels

6 rows where label_id = 3450

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
16880 16880 14911 14911 Gold Dust Media 3450
17031 17031 15049 15049 Gold Dust Media 3450
17657 17657 15604 15604 Gold Dust Media 3450
17939 17939 15869 15869 Gold Dust Media 3450
18040 18040 15965 15965 Gold Dust Media 3450
19148 19148 17001 17001 Gold Dust Media 3450

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