home / pf

albums_labels

32 rows where label_id = 806

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ album_id label_id
1852 1852 1621 1621 Touch 806
4809 4809 4200 4200 Touch 806
5609 5609 4882 4882 Touch 806
9855 9855 8620 8620 Touch 806
12473 12473 10943 10943 Touch 806
14926 14926 13180 13180 Touch 806
15175 15175 13405 13405 Touch 806
15721 15721 13879 13879 Touch 806
15736 15736 13894 13894 Touch 806
16798 16798 14835 14835 Touch 806
18215 18215 16127 16127 Touch 806
19235 19235 17087 17087 Touch 806
19657 19657 17504 17504 Touch 806
20505 20505 18267 18267 Touch 806
21364 21364 19046 19046 Touch 806
23825 23825 21321 21321 Touch 806
24705 24705 22146 22146 Touch 806
25161 25161 22588 22588 Touch 806
25223 25223 22649 22649 Touch 806
25513 25513 22926 22926 Touch 806
25537 25537 22948 22948 Touch 806
25639 25639 23046 23046 Touch 806
25809 25809 23213 23213 Touch 806
25818 25818 23222 23222 Touch 806
26028 26028 23418 23418 Touch 806
26548 26548 23917 23917 Touch 806
26636 26636 24003 24003 Touch 806
26775 26775 24136 24136 Touch 806
26820 26820 24177 24177 Touch 806
27045 27045 24383 24383 Touch 806
27074 27074 24409 24409 Touch 806
27102 27102 24433 24433 Touch 806

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)
);
Powered by Datasette · Queries took 57.002ms