albums_labels

9 rows where label_id = 3455

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
16909 16909 14935 14935 eMusic 3455
18972 18972 16825 16825 eMusic 3455
19934 19934 17766 17766 eMusic 3455
20364 20364 18135 18135 eMusic 3455
23246 23246 20776 20776 eMusic 3455
28465 28465 25693 25693 eMusic 3455
28745 28745 25946 25946 eMusic 3455
28873 28873 26062 26062 eMusic 3455
29011 29011 26185 26185 eMusic 3455

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