albums_labels

15 rows where label_id = 474

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
847 847 718 718 Houndstooth 474
1001 1001 855 855 Houndstooth 474
1324 1324 1138 1138 Houndstooth 474
1950 1950 1703 1703 Houndstooth 474
3312 3312 2895 2895 Houndstooth 474
3610 3610 3149 3149 Houndstooth 474
5165 5165 4515 4515 Houndstooth 474
5795 5795 5047 5047 Houndstooth 474
6105 6105 5312 5312 Houndstooth 474
6807 6807 5934 5934 Houndstooth 474
6966 6966 6063 6063 Houndstooth 474
11419 11419 9990 9990 Houndstooth 474
12608 12608 11064 11064 Houndstooth 474
29544 29544 26636 26636 Houndstooth 474
30137 30137 27157 27157 Houndstooth 474

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