albums_labels

5 rows where label_id = 4711

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
25829 25829 23232 23232 Three Gut 4711
25989 25989 23380 23380 Three Gut 4711
26362 26362 23738 23738 Three Gut 4711
27633 27633 24929 24929 Three Gut 4711
28212 28212 25459 25459 Three Gut 4711

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