albums_labels

6 rows where label_id = 2969

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
13072 13072 11486 11486 Fan Death 2969
13766 13766 12128 12128 Fan Death 2969
14590 14590 12888 12888 Fan Death 2969
15313 15313 13525 13525 Fan Death 2969
15840 15840 13985 13985 Fan Death 2969
17359 17359 15336 15336 Fan Death 2969

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