albums_labels

5 rows where label_id = 71

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
81 81 73 73 Question Everything 71
2114 2114 1840 1840 Question Everything 71
4233 4233 3702 3702 Question Everything 71
4685 4685 4089 4089 Question Everything 71
5531 5531 4817 4817 Question Everything 71

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