albums_labels

22 rows where label_id = 827

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1907 1907 1666 1666 Metal Blade 827
2105 2105 1832 1832 Metal Blade 827
6498 6498 5652 5652 Metal Blade 827
8463 8463 7375 7375 Metal Blade 827
8787 8787 7668 7668 Metal Blade 827
11060 11060 9680 9680 Metal Blade 827
11618 11618 10167 10167 Metal Blade 827
12085 12085 10579 10579 Metal Blade 827
12225 12225 10708 10708 Metal Blade 827
12652 12652 11107 11107 Metal Blade 827
12985 12985 11408 11408 Metal Blade 827
13633 13633 12006 12006 Metal Blade 827
13843 13843 12199 12199 Metal Blade 827
13930 13930 12277 12277 Metal Blade 827
14935 14935 13189 13189 Metal Blade 827
14946 14946 13199 13199 Metal Blade 827
15325 15325 13536 13536 Metal Blade 827
19303 19303 17155 17155 Metal Blade 827
20263 20263 18044 18044 Metal Blade 827
23673 23673 21176 21176 Metal Blade 827
23859 23859 21354 21354 Metal Blade 827
23947 23947 21436 21436 Metal Blade 827

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