albums_labels

7 rows where label_id = 108

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
123 123 107 107 Chapter Music 108
9345 9345 8171 8171 Chapter Music 108
11496 11496 10057 10057 Chapter Music 108
11572 11572 10124 10124 Chapter Music 108
13255 13255 11660 11660 Chapter Music 108
14028 14028 12364 12364 Chapter Music 108
15362 15362 13571 13571 Chapter Music 108

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