albums_labels
17 rows where label_id = 605
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 1176 | 1176 | 1012 1012 | LuckyMe 605 |
| 1846 | 1846 | 1615 1615 | LuckyMe 605 |
| 2010 | 2010 | 1752 1752 | LuckyMe 605 |
| 3109 | 3109 | 2716 2716 | LuckyMe 605 |
| 3206 | 3206 | 2804 2804 | LuckyMe 605 |
| 3898 | 3898 | 3406 3406 | LuckyMe 605 |
| 4018 | 4018 | 3516 3516 | LuckyMe 605 |
| 5258 | 5258 | 4586 4586 | LuckyMe 605 |
| 6201 | 6201 | 5398 5398 | LuckyMe 605 |
| 7071 | 7071 | 6158 6158 | LuckyMe 605 |
| 7274 | 7274 | 6327 6327 | LuckyMe 605 |
| 7787 | 7787 | 6777 6777 | LuckyMe 605 |
| 9325 | 9325 | 8155 8155 | LuckyMe 605 |
| 11959 | 11959 | 10466 10466 | LuckyMe 605 |
| 12322 | 12322 | 10801 10801 | LuckyMe 605 |
| 14225 | 14225 | 12549 12549 | LuckyMe 605 |
| 15073 | 15073 | 13311 13311 | LuckyMe 605 |
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) );