albums_labels

7 rows where label_id = 2216

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
8153 8153 7103 7103 1017 Brick Squad 2216
8195 8195 7142 7142 1017 Brick Squad 2216
12378 12378 10851 10851 1017 Brick Squad 2216
13560 13560 11941 11941 1017 Brick Squad 2216
14964 14964 13213 13213 1017 Brick Squad 2216
15716 15716 13874 13874 1017 Brick Squad 2216
16711 16711 14751 14751 1017 Brick Squad 2216

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