albums_labels

5 rows where label_id = 1286

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3565 3565 3109 3109 L.I.E.S. 1286
4934 4934 4312 4312 L.I.E.S. 1286
6750 6750 5880 5880 L.I.E.S. 1286
12818 12818 11256 11256 L.I.E.S. 1286
29525 29525 26621 26621 L.I.E.S. 1286

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