albums_labels

16 rows where label_id = 2625

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
10762 10762 9417 9417 Overcoat 2625
23182 23182 20713 20713 Overcoat 2625
23650 23650 21156 21156 Overcoat 2625
24212 24212 21684 21684 Overcoat 2625
24455 24455 21916 21916 Overcoat 2625
25876 25876 23274 23274 Overcoat 2625
25896 25896 23294 23294 Overcoat 2625
26026 26026 23416 23416 Overcoat 2625
26297 26297 23673 23673 Overcoat 2625
26866 26866 24219 24219 Overcoat 2625
27067 27067 24403 24403 Overcoat 2625
27554 27554 24855 24855 Overcoat 2625
27904 27904 25179 25179 Overcoat 2625
28105 28105 25364 25364 Overcoat 2625
28264 28264 25506 25506 Overcoat 2625
28883 28883 26072 26072 Overcoat 2625

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