albums_labels

9 rows where label_id = 3454

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
16904 16904 14931 14931 Wall of Sound 3454
17372 17372 15348 15348 Wall of Sound 3454
18703 18703 16584 16584 Wall of Sound 3454
19264 19264 17116 17116 Wall of Sound 3454
19869 19869 17709 17709 Wall of Sound 3454
22028 22028 19650 19650 Wall of Sound 3454
22926 22926 20471 20471 Wall of Sound 3454
23901 23901 21392 21392 Wall of Sound 3454
25740 25740 23144 23144 Wall of Sound 3454

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