albums_labels

26 rows where label_id = 45

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
52 52 47 47 Asylum 45
907 907 776 776 Asylum 45
3678 3678 3210 3210 Asylum 45
4270 4270 3734 3734 Asylum 45
5058 5058 4419 4419 Asylum 45
5963 5963 5198 5198 Asylum 45
6657 6657 5794 5794 Asylum 45
7784 7784 6774 6774 Asylum 45
7861 7861 6841 6841 Asylum 45
11041 11041 9667 9667 Asylum 45
12900 12900 11330 11330 Asylum 45
14482 14482 12791 12791 Asylum 45
16710 16710 14751 14751 Asylum 45
17466 17466 15430 15430 Asylum 45
17851 17851 15786 15786 Asylum 45
18669 18669 16552 16552 Asylum 45
18940 18940 16793 16793 Asylum 45
19915 19915 17748 17748 Asylum 45
22716 22716 20276 20276 Asylum 45
22943 22943 20485 20485 Asylum 45
22944 22944 20486 20486 Asylum 45
23457 23457 20974 20974 Asylum 45
23501 23501 21015 21015 Asylum 45
24069 24069 21554 21554 Asylum 45
28185 28185 25433 25433 Asylum 45
29441 29441 26542 26542 Asylum 45

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