albums_labels

5 rows where label_id = 3534

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
17464 17464 15429 15429 Cryptogramophone 3534
18937 18937 16790 16790 Cryptogramophone 3534
20771 20771 18505 18505 Cryptogramophone 3534
24763 24763 22202 22202 Cryptogramophone 3534
27096 27096 24427 24427 Cryptogramophone 3534

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