albums_labels
12 rows where label_id = 3517
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 17365 | 17365 | 15341 15341 | Brah 3517 |
| 17471 | 17471 | 15435 15435 | Brah 3517 |
| 18431 | 18431 | 16333 16333 | Brah 3517 |
| 18770 | 18770 | 16644 16644 | Brah 3517 |
| 19671 | 19671 | 17516 17516 | Brah 3517 |
| 21346 | 21346 | 19029 19029 | Brah 3517 |
| 21358 | 21358 | 19040 19040 | Brah 3517 |
| 21776 | 21776 | 19417 19417 | Brah 3517 |
| 21958 | 21958 | 19584 19584 | Brah 3517 |
| 22527 | 22527 | 20103 20103 | Brah 3517 |
| 22639 | 22639 | 20209 20209 | Brah 3517 |
| 22689 | 22689 | 20250 20250 | Brah 3517 |
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) );