albums_labels

9 rows where label_id = 1770

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
5837 5837 5087 5087 Fade to Mind 1770
7917 7917 6890 6890 Fade to Mind 1770
9061 9061 7917 7917 Fade to Mind 1770
9423 9423 8240 8240 Fade to Mind 1770
12558 12558 11018 11018 Fade to Mind 1770
12630 12630 11086 11086 Fade to Mind 1770
13191 13191 11599 11599 Fade to Mind 1770
13918 13918 12265 12265 Fade to Mind 1770
15705 15705 13864 13864 Fade to Mind 1770

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