albums_labels

9 rows where label_id = 66

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
75 75 67 67 Sooper 66
571 571 479 479 Sooper 66
1321 1321 1136 1136 Sooper 66
1763 1763 1537 1537 Sooper 66
2642 2642 2304 2304 Sooper 66
3387 3387 2961 2961 Sooper 66
4376 4376 3821 3821 Sooper 66
6073 6073 5283 5283 Sooper 66
30178 30178 27196 27196 Sooper 66

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