albums_labels

15 rows where label_id = 1245

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3393 3393 2966 2966 Terrible 1245
5361 5361 4668 4668 Terrible 1245
5406 5406 4707 4707 Terrible 1245
6365 6365 5546 5546 Terrible 1245
6747 6747 5877 5877 Terrible 1245
8348 8348 7275 7275 Terrible 1245
9785 9785 8562 8562 Terrible 1245
10086 10086 8825 8825 Terrible 1245
11948 11948 10455 10455 Terrible 1245
12138 12138 10628 10628 Terrible 1245
13025 13025 11441 11441 Terrible 1245
13842 13842 12198 12198 Terrible 1245
15516 15516 13708 13708 Terrible 1245
16824 16824 14857 14857 Terrible 1245
17768 17768 15706 15706 Terrible 1245

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