albums_labels

9 rows where label_id = 2742

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
11599 11599 10150 10150 Dovecote 2742
12318 12318 10797 10797 Dovecote 2742
14383 14383 12702 12702 Dovecote 2742
15042 15042 13282 13282 Dovecote 2742
15897 15897 14035 14035 Dovecote 2742
16190 16190 14293 14293 Dovecote 2742
17435 17435 15401 15401 Dovecote 2742
19153 19153 17006 17006 Dovecote 2742
19733 19733 17578 17578 Dovecote 2742

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