albums_labels

9 rows where label_id = 102

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
116 116 102 102 Eremite 102
2070 2070 1803 1803 Eremite 102
4758 4758 4153 4153 Eremite 102
6649 6649 5786 5786 Eremite 102
7738 7738 6734 6734 Eremite 102
8157 8157 7106 7106 Eremite 102
9823 9823 8592 8592 Eremite 102
26223 26223 23604 23604 Eremite 102
29504 29504 26601 26601 Eremite 102

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