albums_labels

7 rows where label_id = 2123

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
7643 7643 6654 6654 Undertow 2123
7885 7885 6864 6864 Undertow 2123
17681 17681 15628 15628 Undertow 2123
21018 21018 18729 18729 Undertow 2123
24272 24272 21743 21743 Undertow 2123
24273 24273 21744 21744 Undertow 2123
27381 27381 24693 24693 Undertow 2123

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