albums_labels

6 rows where label_id = 4078

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
21058 21058 18765 18765 Off 4078
25922 25922 23319 23319 Off 4078
26122 26122 23509 23509 Off 4078
26123 26123 23510 23510 Off 4078
26354 26354 23730 23730 Off 4078
26426 26426 23799 23799 Off 4078

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