albums_labels

6 rows where label_id = 3174

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
14740 14740 13019 13019 Manimal Vinyl 3174
17429 17429 15397 15397 Manimal Vinyl 3174
18359 18359 16265 16265 Manimal Vinyl 3174
18948 18948 16801 16801 Manimal Vinyl 3174
18975 18975 16828 16828 Manimal Vinyl 3174
20600 20600 18355 18355 Manimal Vinyl 3174

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