albums_labels

7 rows where label_id = 4177

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
21673 21673 19325 19325 Aesthetics 4177
24871 24871 22307 22307 Aesthetics 4177
26404 26404 23778 23778 Aesthetics 4177
26800 26800 24159 24159 Aesthetics 4177
27577 27577 24876 24876 Aesthetics 4177
27962 27962 25233 25233 Aesthetics 4177
28441 28441 25673 25673 Aesthetics 4177

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