albums_labels

6 rows where label_id = 3122

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
14385 14385 12704 12704 Everloving 3122
19118 19118 16971 16971 Everloving 3122
19139 19139 16992 16992 Everloving 3122
19140 19140 16993 16993 Everloving 3122
19979 19979 17806 17806 Everloving 3122
21509 21509 19174 19174 Everloving 3122

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