albums_labels

6 rows where label_id = 1768

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
5834 5834 5085 5085 Ghost Ramp 1768
6145 6145 5344 5344 Ghost Ramp 1768
7531 7531 6556 6556 Ghost Ramp 1768
9951 9951 8700 8700 Ghost Ramp 1768
10271 10271 8986 8986 Ghost Ramp 1768
15495 15495 13691 13691 Ghost Ramp 1768

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