albums_labels

7 rows where label_id = 634

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1256 1256 1083 1083 Rinse 634
9142 9142 7997 7997 Rinse 634
13609 13609 11986 11986 Rinse 634
14022 14022 12358 12358 Rinse 634
14032 14032 12368 12368 Rinse 634
16175 16175 14280 14280 Rinse 634
29159 29159 26304 26304 Rinse 634

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