albums_labels
21 rows where label_id = 62
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 71 | 71 | 64 64 | Brassland 62 |
| 2804 | 2804 | 2443 2443 | Brassland 62 |
| 5107 | 5107 | 4465 4465 | Brassland 62 |
| 10504 | 10504 | 9191 9191 | Brassland 62 |
| 10636 | 10636 | 9308 9308 | Brassland 62 |
| 13597 | 13597 | 11977 11977 | Brassland 62 |
| 13657 | 13657 | 12028 12028 | Brassland 62 |
| 13937 | 13937 | 12282 12282 | Brassland 62 |
| 14104 | 14104 | 12432 12432 | Brassland 62 |
| 14473 | 14473 | 12783 12783 | Brassland 62 |
| 16742 | 16742 | 14782 14782 | Brassland 62 |
| 17649 | 17649 | 15596 15596 | Brassland 62 |
| 17650 | 17650 | 15597 15597 | Brassland 62 |
| 18105 | 18105 | 16026 16026 | Brassland 62 |
| 20732 | 20732 | 18471 18471 | Brassland 62 |
| 22037 | 22037 | 19658 19658 | Brassland 62 |
| 23128 | 23128 | 20659 20659 | Brassland 62 |
| 24413 | 24413 | 21874 21874 | Brassland 62 |
| 25765 | 25765 | 23168 23168 | Brassland 62 |
| 26034 | 26034 | 23424 23424 | Brassland 62 |
| 28197 | 28197 | 25445 25445 | Brassland 62 |
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) );