albums_labels

18 rows where label_id = 1974

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
6782 6782 5910 5910 Blackest Ever Black 1974
8063 8063 7019 7019 Blackest Ever Black 1974
8349 8349 7276 7276 Blackest Ever Black 1974
9832 9832 8600 8600 Blackest Ever Black 1974
10139 10139 8872 8872 Blackest Ever Black 1974
10873 10873 9518 9518 Blackest Ever Black 1974
11097 11097 9712 9712 Blackest Ever Black 1974
11300 11300 9883 9883 Blackest Ever Black 1974
11525 11525 10082 10082 Blackest Ever Black 1974
11688 11688 10233 10233 Blackest Ever Black 1974
11818 11818 10344 10344 Blackest Ever Black 1974
12051 12051 10550 10550 Blackest Ever Black 1974
12317 12317 10796 10796 Blackest Ever Black 1974
12412 12412 10884 10884 Blackest Ever Black 1974
12895 12895 11325 11325 Blackest Ever Black 1974
12907 12907 11337 11337 Blackest Ever Black 1974
13543 13543 11927 11927 Blackest Ever Black 1974
13849 13849 12205 12205 Blackest Ever Black 1974

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