albums_labels

15 rows where label_id = 2550

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
10227 10227 8950 8950 Guided By Voices, Inc. 2550
11900 11900 10414 10414 Guided By Voices, Inc. 2550
13890 13890 12243 12243 Guided By Voices, Inc. 2550
15139 15139 13372 13372 Guided By Voices, Inc. 2550
15659 15659 13824 13824 Guided By Voices, Inc. 2550
16449 16449 14523 14523 Guided By Voices, Inc. 2550
17040 17040 15058 15058 Guided By Voices, Inc. 2550
17694 17694 15641 15641 Guided By Voices, Inc. 2550
17984 17984 15911 15911 Guided By Voices, Inc. 2550
18134 18134 16053 16053 Guided By Voices, Inc. 2550
18352 18352 16258 16258 Guided By Voices, Inc. 2550
18772 18772 16646 16646 Guided By Voices, Inc. 2550
19067 19067 16920 16920 Guided By Voices, Inc. 2550
19212 19212 17065 17065 Guided By Voices, Inc. 2550
19871 19871 17711 17711 Guided By Voices, Inc. 2550

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