albums_labels

22 rows where label_id = 2105

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
7546 7546 6569 6569 Bpitch Control 2105
13490 13490 11878 11878 Bpitch Control 2105
16192 16192 14295 14295 Bpitch Control 2105
16303 16303 14399 14399 Bpitch Control 2105
16620 16620 14675 14675 Bpitch Control 2105
17306 17306 15296 15296 Bpitch Control 2105
17400 17400 15372 15372 Bpitch Control 2105
18744 18744 16625 16625 Bpitch Control 2105
19086 19086 16939 16939 Bpitch Control 2105
19942 19942 17773 17773 Bpitch Control 2105
20058 20058 17873 17873 Bpitch Control 2105
20911 20911 18630 18630 Bpitch Control 2105
21065 21065 18772 18772 Bpitch Control 2105
21667 21667 19319 19319 Bpitch Control 2105
22770 22770 20328 20328 Bpitch Control 2105
23219 23219 20750 20750 Bpitch Control 2105
23984 23984 21471 21471 Bpitch Control 2105
24073 24073 21557 21557 Bpitch Control 2105
24950 24950 22386 22386 Bpitch Control 2105
24951 24951 22387 22387 Bpitch Control 2105
25929 25929 23326 23326 Bpitch Control 2105
26112 26112 23499 23499 Bpitch Control 2105

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