albums_labels

4 rows where label_id = 1414

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
4113 4113 3604 3604 Danger Collective 1414
4475 4475 3906 3906 Danger Collective 1414
29172 29172 26315 26315 Danger Collective 1414
30005 30005 27033 27033 Danger Collective 1414

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