albums_labels

9 rows where label_id = 1070

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
2707 2707 2364 2364 Sister Polygon 1070
4332 4332 3782 3782 Sister Polygon 1070
4782 4782 4176 4176 Sister Polygon 1070
5158 5158 4508 4508 Sister Polygon 1070
7277 7277 6330 6330 Sister Polygon 1070
8016 8016 6979 6979 Sister Polygon 1070
8256 8256 7194 7194 Sister Polygon 1070
8415 8415 7329 7329 Sister Polygon 1070
11790 11790 10321 10321 Sister Polygon 1070

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