albums_labels

6 rows where label_id = 204

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
286 286 248 248 Winspear 204
966 966 824 824 Winspear 204
2628 2628 2291 2291 Winspear 204
4443 4443 3880 3880 Winspear 204
7197 7197 6264 6264 Winspear 204
30228 30228 27240 27240 Winspear 204

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