albums_labels

6 rows where label_id = 2664

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
11020 11020 9652 9652 Ghost Box 2664
13243 13243 11648 11648 Ghost Box 2664
14892 14892 13149 13149 Ghost Box 2664
15638 15638 13810 13810 Ghost Box 2664
18839 18839 16703 16703 Ghost Box 2664
18840 18840 16704 16704 Ghost Box 2664

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