albums_labels

7 rows where label_id = 96

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
110 110 97 97 10K Projects 96
1189 1189 1022 1022 10K Projects 96
2581 2581 2250 2250 10K Projects 96
4275 4275 3738 3738 10K Projects 96
5292 5292 4611 4611 10K Projects 96
5702 5702 4963 4963 10K Projects 96
29210 29210 26346 26346 10K Projects 96

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