albums_labels

4 rows where label_id = 1362

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3864 3864 3377 3377 Dark Descent 1362
9737 9737 8519 8519 Dark Descent 1362
10795 10795 9448 9448 Dark Descent 1362
14701 14701 12984 12984 Dark Descent 1362

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