albums_labels

9 rows where label_id = 2936

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
12823 12823 11261 11261 Six Degrees 2936
15135 15135 13369 13369 Six Degrees 2936
19876 19876 17715 17715 Six Degrees 2936
20595 20595 18350 18350 Six Degrees 2936
22568 22568 20142 20142 Six Degrees 2936
23647 23647 21153 21153 Six Degrees 2936
25209 25209 22635 22635 Six Degrees 2936
25444 25444 22861 22861 Six Degrees 2936
29069 29069 26228 26228 Six Degrees 2936

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