albums_labels

20 rows where label_id = 4128

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
21340 21340 19026 19026 Beggars 4128
21754 21754 19399 19399 Beggars 4128
23284 23284 20812 20812 Beggars 4128
23732 23732 21230 21230 Beggars 4128
24332 24332 21798 21798 Beggars 4128
24538 24538 21992 21992 Beggars 4128
25825 25825 23229 23229 Beggars 4128
26558 26558 23926 23926 Beggars 4128
26917 26917 24266 24266 Beggars 4128
27040 27040 24380 24380 Beggars 4128
27121 27121 24449 24449 Beggars 4128
27226 27226 24547 24547 Beggars 4128
27308 27308 24622 24622 Beggars 4128
27383 27383 24694 24694 Beggars 4128
27813 27813 25095 25095 Beggars 4128
28432 28432 25664 25664 Beggars 4128
28458 28458 25688 25688 Beggars 4128
28482 28482 25710 25710 Beggars 4128
28500 28500 25725 25725 Beggars 4128
28640 28640 25852 25852 Beggars 4128

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