albums_labels
6 rows where label_id = 4491
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 24236 | 24236 | 21707 21707 | File-13 4491 |
| 25230 | 25230 | 22656 22656 | File-13 4491 |
| 25802 | 25802 | 23206 23206 | File-13 4491 |
| 26110 | 26110 | 23497 23497 | File-13 4491 |
| 28132 | 28132 | 25386 25386 | File-13 4491 |
| 28201 | 28201 | 25448 25448 | File-13 4491 |
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) );