albums_labels

6 rows where label_id = 410

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
695 695 585 585 Tin Angel 410
2275 2275 1979 1979 Tin Angel 410
5245 5245 4577 4577 Tin Angel 410
10799 10799 9452 9452 Tin Angel 410
14180 14180 12505 12505 Tin Angel 410
17391 17391 15364 15364 Tin Angel 410

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