albums_labels
7 rows where label_id = 1459
This data as json, CSV (advanced)
| Link | rowid ▼ | album_id | label_id |
|---|---|---|---|
| 4321 | 4321 | 3772 3772 | Heavy on the Grind 1459 |
| 6220 | 6220 | 5415 5415 | Heavy on the Grind 1459 |
| 8241 | 8241 | 7180 7180 | Heavy on the Grind 1459 |
| 12421 | 12421 | 10893 10893 | Heavy on the Grind 1459 |
| 14708 | 14708 | 12990 12990 | Heavy on the Grind 1459 |
| 16066 | 16066 | 14186 14186 | Heavy on the Grind 1459 |
| 16068 | 16068 | 14187 14187 | Heavy on the Grind 1459 |
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) );