reviews_albums
5 rows where review_id = 5599
This data as json, CSV (advanced)
| Link | rowid ▼ | review_id | album_id |
|---|---|---|---|
| 5760 | 5760 | The Wasted Years 5599 | 5760 5760 |
| 5761 | 5761 | The Wasted Years 5599 | 5761 5761 |
| 5762 | 5762 | The Wasted Years 5599 | 5762 5762 |
| 5763 | 5763 | The Wasted Years 5599 | 5763 5763 |
| 5764 | 5764 | The Wasted Years 5599 | 5764 5764 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE reviews_albums ( review_id integer NOT NULL, album_id integer NOT NULL, FOREIGN KEY(review_id) REFERENCES reviews(id), FOREIGN KEY(album_id) REFERENCES albums(id), UNIQUE(review_id, album_id) );