albums_labels
6 rows where label_id = 2290
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 8574 | 8574 | 7477 7477 | Shitkatapult 2290 |
| 15106 | 15106 | 13341 13341 | Shitkatapult 2290 |
| 24507 | 24507 | 21964 21964 | Shitkatapult 2290 |
| 25734 | 25734 | 23139 23139 | Shitkatapult 2290 |
| 25822 | 25822 | 23226 23226 | Shitkatapult 2290 |
| 26048 | 26048 | 23438 23438 | Shitkatapult 2290 |
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) );