albums_labels

5 rows where label_id = 123

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
141 141 120 120 Daydream Library Series  123
1215 1215 1047 1047 Daydream Library Series  123
2730 2730 2383 2383 Daydream Library Series  123
4117 4117 3608 3608 Daydream Library Series  123
5166 5166 4516 4516 Daydream Library Series  123

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