albums_labels
34 rows where label_id = 539
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 1013 | 1013 | 865 865 | Lex 539 |
| 2163 | 2163 | 1881 1881 | Lex 539 |
| 2549 | 2549 | 2220 2220 | Lex 539 |
| 5885 | 5885 | 5129 5129 | Lex 539 |
| 5981 | 5981 | 5216 5216 | Lex 539 |
| 6014 | 6014 | 5244 5244 | Lex 539 |
| 7510 | 7510 | 6536 6536 | Lex 539 |
| 8569 | 8569 | 7472 7472 | Lex 539 |
| 10888 | 10888 | 9531 9531 | Lex 539 |
| 11373 | 11373 | 9948 9948 | Lex 539 |
| 13269 | 13269 | 11675 11675 | Lex 539 |
| 14191 | 14191 | 12516 12516 | Lex 539 |
| 15481 | 15481 | 13678 13678 | Lex 539 |
| 17865 | 17865 | 15798 15798 | Lex 539 |
| 18407 | 18407 | 16311 16311 | Lex 539 |
| 18847 | 18847 | 16711 16711 | Lex 539 |
| 19970 | 19970 | 17799 17799 | Lex 539 |
| 20249 | 20249 | 18031 18031 | Lex 539 |
| 20550 | 20550 | 18309 18309 | Lex 539 |
| 21164 | 21164 | 18866 18866 | Lex 539 |
| 24338 | 24338 | 21804 21804 | Lex 539 |
| 24513 | 24513 | 21970 21970 | Lex 539 |
| 24932 | 24932 | 22368 22368 | Lex 539 |
| 25068 | 25068 | 22503 22503 | Lex 539 |
| 25190 | 25190 | 22616 22616 | Lex 539 |
| 25246 | 25246 | 22672 22672 | Lex 539 |
| 25373 | 25373 | 22796 22796 | Lex 539 |
| 25472 | 25472 | 22887 22887 | Lex 539 |
| 26039 | 26039 | 23429 23429 | Lex 539 |
| 26134 | 26134 | 23519 23519 | Lex 539 |
| 26559 | 26559 | 23927 23927 | Lex 539 |
| 27371 | 27371 | 24683 24683 | Lex 539 |
| 29460 | 29460 | 26560 26560 | Lex 539 |
| 29855 | 29855 | 26902 26902 | Lex 539 |
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) );