albums_labels

8 rows where label_id = 1325

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3728 3728 3250 3250 Analog Africa 1325
4266 4266 3731 3731 Analog Africa 1325
12654 12654 11109 11109 Analog Africa 1325
15154 15154 13385 13385 Analog Africa 1325
16919 16919 14943 14943 Analog Africa 1325
18435 18435 16337 16337 Analog Africa 1325
19066 19066 16919 16919 Analog Africa 1325
19841 19841 17682 17682 Analog Africa 1325

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