albums_labels

10 rows where label_id = 681

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1420 1420 1228 1228 Marathon Artists 681
3479 3479 3039 3039 Marathon Artists 681
4655 4655 4064 4064 Marathon Artists 681
5026 5026 4390 4390 Marathon Artists 681
6046 6046 5265 5265 Marathon Artists 681
7612 7612 6628 6628 Marathon Artists 681
10743 10743 9401 9401 Marathon Artists 681
11538 11538 10094 10094 Marathon Artists 681
12633 12633 11089 11089 Marathon Artists 681
13084 13084 11498 11498 Marathon Artists 681

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