albums_labels

15 rows where label_id = 3198

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
14866 14866 13130 13130 Lo 3198
16041 16041 14163 14163 Lo 3198
17284 17284 15275 15275 Lo 3198
18505 18505 16402 16402 Lo 3198
18694 18694 16576 16576 Lo 3198
21165 21165 18867 18867 Lo 3198
21918 21918 19545 19545 Lo 3198
22442 22442 20027 20027 Lo 3198
22556 22556 20130 20130 Lo 3198
23636 23636 21143 21143 Lo 3198
25823 25823 23227 23227 Lo 3198
26638 26638 24005 24005 Lo 3198
27160 27160 24487 24487 Lo 3198
27800 27800 25084 25084 Lo 3198
28910 28910 26096 26096 Lo 3198

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