albums_labels

7 rows where label_id = 810

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1863 1863 1631 1631 Melody As Truth 810
2228 2228 1940 1940 Melody As Truth 810
6680 6680 5815 5815 Melody As Truth 810
6917 6917 6024 6024 Melody As Truth 810
7561 7561 6582 6582 Melody As Truth 810
8225 8225 7167 7167 Melody As Truth 810
10274 10274 8989 8989 Melody As Truth 810

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