albums_labels

15 rows where label_id = 165

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
213 213 182 182 UMC 165
2782 2782 2425 2425 UMC 165
4068 4068 3564 3564 UMC 165
4375 4375 3820 3820 UMC 165
4965 4965 4339 4339 UMC 165
4967 4967 4340 4340 UMC 165
4969 4969 4341 4341 UMC 165
4971 4971 4342 4342 UMC 165
5425 5425 4727 4727 UMC 165
5427 5427 4728 4728 UMC 165
6128 6128 5329 5329 UMC 165
7138 7138 6214 6214 UMC 165
7247 7247 6305 6305 UMC 165
7249 7249 6306 6306 UMC 165
7251 7251 6307 6307 UMC 165

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