albums_labels

10 rows where label_id = 1775

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
5845 5845 5094 5094 Spectrum Spools 1775
10278 10278 8993 8993 Spectrum Spools 1775
10667 10667 9337 9337 Spectrum Spools 1775
10817 10817 9467 9467 Spectrum Spools 1775
12145 12145 10636 10636 Spectrum Spools 1775
13744 13744 12107 12107 Spectrum Spools 1775
13791 13791 12149 12149 Spectrum Spools 1775
13848 13848 12204 12204 Spectrum Spools 1775
14329 14329 12650 12650 Spectrum Spools 1775
14592 14592 12890 12890 Spectrum Spools 1775

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