albums_labels
16 rows where label_id = 4089
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 21105 | 21105 | 18810 18810 | Monitor 4089 |
| 21454 | 21454 | 19127 19127 | Monitor 4089 |
| 21965 | 21965 | 19590 19590 | Monitor 4089 |
| 23080 | 23080 | 20617 20617 | Monitor 4089 |
| 23787 | 23787 | 21283 21283 | Monitor 4089 |
| 23946 | 23946 | 21435 21435 | Monitor 4089 |
| 24018 | 24018 | 21505 21505 | Monitor 4089 |
| 24528 | 24528 | 21984 21984 | Monitor 4089 |
| 25179 | 25179 | 22606 22606 | Monitor 4089 |
| 25180 | 25180 | 22607 22607 | Monitor 4089 |
| 25816 | 25816 | 23220 23220 | Monitor 4089 |
| 26384 | 26384 | 23760 23760 | Monitor 4089 |
| 27164 | 27164 | 24491 24491 | Monitor 4089 |
| 27423 | 27423 | 24732 24732 | Monitor 4089 |
| 27543 | 27543 | 24845 24845 | Monitor 4089 |
| 28176 | 28176 | 25426 25426 | Monitor 4089 |
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) );