albums_labels

21 rows where label_id = 1199

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
3217 3217 2814 2814 Crammed Discs 1199
4579 4579 3998 3998 Crammed Discs 1199
6569 6569 5715 5715 Crammed Discs 1199
6817 6817 5943 5943 Crammed Discs 1199
7596 7596 6612 6612 Crammed Discs 1199
9198 9198 8043 8043 Crammed Discs 1199
11676 11676 10221 10221 Crammed Discs 1199
12615 12615 11071 11071 Crammed Discs 1199
16646 16646 14696 14696 Crammed Discs 1199
16666 16666 14712 14712 Crammed Discs 1199
17232 17232 15230 15230 Crammed Discs 1199
17469 17469 15433 15433 Crammed Discs 1199
18381 18381 16286 16286 Crammed Discs 1199
19043 19043 16896 16896 Crammed Discs 1199
19572 19572 17419 17419 Crammed Discs 1199
19685 19685 17530 17530 Crammed Discs 1199
20407 20407 18174 18174 Crammed Discs 1199
21460 21460 19133 19133 Crammed Discs 1199
22009 22009 19633 19633 Crammed Discs 1199
23218 23218 20749 20749 Crammed Discs 1199
24349 24349 21815 21815 Crammed Discs 1199

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