albums_labels

15 rows where label_id = 140

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
169 169 145 145 !K7 140
1331 1331 1145 1145 !K7 140
1452 1452 1259 1259 !K7 140
1937 1937 1692 1692 !K7 140
2203 2203 1918 1918 !K7 140
2781 2781 2424 2424 !K7 140
4137 4137 3622 3622 !K7 140
4438 4438 3875 3875 !K7 140
4846 4846 4233 4233 !K7 140
5000 5000 4368 4368 !K7 140
5042 5042 4404 4404 !K7 140
5522 5522 4809 4809 !K7 140
5828 5828 5079 5079 !K7 140
6999 6999 6094 6094 !K7 140
7040 7040 6130 6130 !K7 140

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