albums_labels

9 rows where label_id = 2473

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
9723 9723 8505 8505 Ubiquity 2473
17572 17572 15527 15527 Ubiquity 2473
18719 18719 16600 16600 Ubiquity 2473
22067 22067 19687 19687 Ubiquity 2473
22226 22226 19833 19833 Ubiquity 2473
22426 22426 20013 20013 Ubiquity 2473
22665 22665 20230 20230 Ubiquity 2473
23881 23881 21374 21374 Ubiquity 2473
25407 25407 22826 22826 Ubiquity 2473

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