albums_labels

6 rows where label_id = 867

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
2040 2040 1777 1777 GBV 867
7209 7209 6274 6274 GBV 867
7719 7719 6717 6717 GBV 867
10897 10897 9539 9539 GBV 867
12238 12238 10721 10721 GBV 867
13036 13036 11452 11452 GBV 867

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