albums_labels
17 rows where label_id = 3554
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 17625 | 17625 | 15573 15573 | Mego 3554 |
| 21890 | 21890 | 19520 19520 | Mego 3554 |
| 24669 | 24669 | 22114 22114 | Mego 3554 |
| 25088 | 25088 | 22520 22520 | Mego 3554 |
| 25554 | 25554 | 22963 22963 | Mego 3554 |
| 25664 | 25664 | 23070 23070 | Mego 3554 |
| 26102 | 26102 | 23490 23490 | Mego 3554 |
| 26827 | 26827 | 24183 24183 | Mego 3554 |
| 26836 | 26836 | 24191 24191 | Mego 3554 |
| 26982 | 26982 | 24327 24327 | Mego 3554 |
| 26999 | 26999 | 24341 24341 | Mego 3554 |
| 27126 | 27126 | 24454 24454 | Mego 3554 |
| 27191 | 27191 | 24514 24514 | Mego 3554 |
| 27213 | 27213 | 24535 24535 | Mego 3554 |
| 27913 | 27913 | 25187 25187 | Mego 3554 |
| 28307 | 28307 | 25547 25547 | Mego 3554 |
| 28736 | 28736 | 25939 25939 | Mego 3554 |
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) );