albums_labels
32 rows where label_id = 806
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
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) );