albums_labels

5 rows where label_id = 210

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
297 297 256 256 PLZ Make It Ruins 210
1722 1722 1500 1500 PLZ Make It Ruins 210
2186 2186 1902 1902 PLZ Make It Ruins 210
2715 2715 2369 2369 PLZ Make It Ruins 210
4461 4461 3894 3894 PLZ Make It Ruins 210

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