albums_labels

9 rows where label_id = 2906

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
12587 12587 11044 11044 Olde English Spelling Bee 2906
14238 14238 12562 12562 Olde English Spelling Bee 2906
15725 15725 13883 13883 Olde English Spelling Bee 2906
16524 16524 14592 14592 Olde English Spelling Bee 2906
16528 16528 14596 14596 Olde English Spelling Bee 2906
17163 17163 15171 15171 Olde English Spelling Bee 2906
17170 17170 15178 15178 Olde English Spelling Bee 2906
18232 18232 16144 16144 Olde English Spelling Bee 2906
18315 18315 16221 16221 Olde English Spelling Bee 2906

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