albums_labels

7 rows where label_id = 802

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1840 1840 1612 1612 Kemosabe 802
3663 3663 3195 3195 Kemosabe 802
7211 7211 6275 6275 Kemosabe 802
9294 9294 8126 8126 Kemosabe 802
11234 11234 9828 9828 Kemosabe 802
29588 29588 26675 26675 Kemosabe 802
29973 29973 27006 27006 Kemosabe 802

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