albums_labels

6 rows where label_id = 3936

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
20121 20121 17928 17928 Audio Dregs 3936
21769 21769 19410 19410 Audio Dregs 3936
21900 21900 19529 19529 Audio Dregs 3936
26492 26492 23862 23862 Audio Dregs 3936
27933 27933 25206 25206 Audio Dregs 3936
27965 27965 25236 25236 Audio Dregs 3936

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