albums_labels
28 rows where label_id = 3332
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 15944 | 15944 | 14077 14077 | Mush 3332 |
| 18881 | 18881 | 16737 16737 | Mush 3332 |
| 19170 | 19170 | 17023 17023 | Mush 3332 |
| 19723 | 19723 | 17568 17568 | Mush 3332 |
| 19792 | 19792 | 17634 17634 | Mush 3332 |
| 20503 | 20503 | 18265 18265 | Mush 3332 |
| 22914 | 22914 | 20459 20459 | Mush 3332 |
| 24380 | 24380 | 21843 21843 | Mush 3332 |
| 24387 | 24387 | 21849 21849 | Mush 3332 |
| 24634 | 24634 | 22080 22080 | Mush 3332 |
| 24675 | 24675 | 22120 22120 | Mush 3332 |
| 24738 | 24738 | 22178 22178 | Mush 3332 |
| 25076 | 25076 | 22510 22510 | Mush 3332 |
| 25216 | 25216 | 22642 22642 | Mush 3332 |
| 25695 | 25695 | 23100 23100 | Mush 3332 |
| 25797 | 25797 | 23201 23201 | Mush 3332 |
| 25892 | 25892 | 23290 23290 | Mush 3332 |
| 25900 | 25900 | 23298 23298 | Mush 3332 |
| 25932 | 25932 | 23329 23329 | Mush 3332 |
| 26349 | 26349 | 23725 23725 | Mush 3332 |
| 26680 | 26680 | 24045 24045 | Mush 3332 |
| 26705 | 26705 | 24068 24068 | Mush 3332 |
| 26838 | 26838 | 24193 24193 | Mush 3332 |
| 27583 | 27583 | 24882 24882 | Mush 3332 |
| 27715 | 27715 | 25006 25006 | Mush 3332 |
| 27822 | 27822 | 25102 25102 | Mush 3332 |
| 28048 | 28048 | 25312 25312 | Mush 3332 |
| 28404 | 28404 | 25637 25637 | Mush 3332 |
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) );