albums_labels

5 rows where label_id = 461

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
807 807 681 681 Damnably 461
827 827 700 700 Damnably 461
4699 4699 4100 4100 Damnably 461
5231 5231 4565 4565 Damnably 461
6228 6228 5422 5422 Damnably 461

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