albums_labels

9 rows where label_id = 1112

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
2880 2880 2512 2512 All Saints 1112
2942 2942 2568 2568 All Saints 1112
7013 7013 6107 6107 All Saints 1112
7014 7014 6108 6108 All Saints 1112
11076 11076 9692 9692 All Saints 1112
11077 11077 9693 9693 All Saints 1112
11078 11078 9694 9694 All Saints 1112
11079 11079 9695 9695 All Saints 1112
12409 12409 10881 10881 All Saints 1112

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