albums_labels

11 rows where label_id = 453

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
788 788 668 668 PC Music 453
1393 1393 1203 1203 PC Music 453
2744 2744 2396 2396 PC Music 453
2909 2909 2538 2538 PC Music 453
3850 3850 3364 3364 PC Music 453
8228 8228 7169 7169 PC Music 453
9724 9724 8506 8506 PC Music 453
10567 10567 9250 9250 PC Music 453
29560 29560 26650 26650 PC Music 453
29872 29872 26916 26916 PC Music 453
30021 30021 27048 27048 PC Music 453

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