albums_labels
13 rows where label_id = 3521
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 17385 | 17385 | 15359 15359 | Get Physical 3521 |
| 18048 | 18048 | 15972 15972 | Get Physical 3521 |
| 18945 | 18945 | 16798 16798 | Get Physical 3521 |
| 19024 | 19024 | 16877 16877 | Get Physical 3521 |
| 19290 | 19290 | 17142 17142 | Get Physical 3521 |
| 19794 | 19794 | 17636 17636 | Get Physical 3521 |
| 19920 | 19920 | 17753 17753 | Get Physical 3521 |
| 20183 | 20183 | 17978 17978 | Get Physical 3521 |
| 20365 | 20365 | 18136 18136 | Get Physical 3521 |
| 21138 | 21138 | 18841 18841 | Get Physical 3521 |
| 22656 | 22656 | 20221 20221 | Get Physical 3521 |
| 22821 | 22821 | 20375 20375 | Get Physical 3521 |
| 23863 | 23863 | 21358 21358 | Get Physical 3521 |
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) );